Web Based Tools ( PrivateHiveTools )

nightmare · September 22, 2013

So if I use the BEC whitelister, BEC needs to be restarted after a new GUID is added?

which whitlister you mean, db or text?

nightmare · September 22, 2013

The admin tools, i have the tool_admins table and is all lower case

hmm... this is courius.

i have tested the actual build (PHT 1.0.2.2) and it works fine for me

BetterDeadThanZed · September 22, 2013

which whitlister you mean, db or text?

You have two Whitelist options in the tool. The one under "Survivor Editor" uses some Whitelist plugin and the other one says Whitelist (FTP). This is the one that uses the BEC whitelist, so my question is, do I need to restart BEC after updating the whitelist?

Achmed · September 22, 2013

hmm... this is courius.

i have tested the actual build (PHT 1.0.2.2) and it works fine for me

anything you can suggest i try? have double and triple checked the table name etc and all looks ok.

if not is it possible to add the details in the database my self?

If i dont add detail it tells me i need to, if i add my detail it tells me there is already an account with that name but if i add a new name it gives the error :(

nightmare · September 22, 2013

You have two Whitelist options in the tool. The one under "Survivor Editor" uses some Whitelist plugin and the other one says Whitelist (FTP). This is the one that uses the BEC whitelist, so my question is, do I need to restart BEC after updating the whitelist?

if you use the BEC-Whitelist with DB (plugin) you don't need a restart after inserting a GUID.

If you use BEC Whitelist.txt, no idea.

nightmare · September 22, 2013

anything you can suggest i try? have double and triple checked the table name etc and all looks ok.

if not is it possible to add the details in the database my self?

If i dont add detail it tells me i need to, if i add my detail it tells me there is already an account with that name but if i add a new name it gives the error :(

try this with "navicat" or another SQL-Client:

INSERT INTO `tool_admins` SET `username` = 'test', `password` = 'test', `permissions` = '[\"\"]';

if not working then your DB-User needs "INSERT" rights...

nightmare · September 22, 2013

a example with "HeidiSQL", to set up the Database-User Rights. " but you must be a mysql "root" user ( own MySQL server ), if not contact your provider "

Achmed · September 22, 2013

I tried that however it failed with

/* SQL Error (1364): Field 'hash' doesn't have a default value */

I have run this before with out a problem

INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES

nightmare · September 22, 2013

I tried that however it failed with
/* SQL Error (1364): Field 'hash' doesn't have a default value */
I have run this before with out a problem
INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES

okay try this:

DROP TABLE IF EXISTS `tool_admins`;

CREATE TABLE `tool_admins` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`username` VARCHAR(100) NOT NULL,
	`password` VARCHAR(65) NOT NULL,
	`hash` VARCHAR(250) NULL DEFAULT NULL,
	`ip` VARCHAR(65) NULL DEFAULT NULL,
	`permissions` VARCHAR(250) NULL DEFAULT '[\"\"]',
	`userinfo` VARCHAR(250) NULL DEFAULT NULL,
	`last_active` DATETIME NULL DEFAULT NULL,
	`loginfail` INT(1) NOT NULL DEFAULT '0',
	`loginblock` INT(1) NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`),
	UNIQUE INDEX `username` (`username`),
	INDEX `password` (`password`),
	INDEX `hash` (`hash`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
ROW_FORMAT=DYNAMIC
AUTO_INCREMENT=1;

Achmed · September 22, 2013

yay it worked :)

what was the difference between that and what was in before?

nightmare · September 22, 2013

yay it worked :)

what was the difference between that and what was in before?

OLD

`hash` VARCHAR(250) NOT NULL,

`ip` VARCHAR(65) NOT NULL,

`permissions` VARCHAR(250) NOT NULL DEFAULT '[\"\"]',

`userinfo` VARCHAR(250) NOT NULL,

`last_active` DATETIME NOT NULL,

NEW

`hash` VARCHAR(250) NULL DEFAULT NULL,

`ip` VARCHAR(65) NULL DEFAULT NULL,

`permissions` VARCHAR(250) NULL DEFAULT '[\"\"]',

`userinfo` VARCHAR(250) NULL DEFAULT NULL,

`last_active` DATETIME NULL DEFAULT NULL,

but no idea why the "OLD" works for me without a problem

DethMarine · September 23, 2013

Can this be used on HFB Servers? And if you have to have a website is any free ones that use PHP?

ToejaM · September 23, 2013

When I try and edit the whitelist.txt - I get this error: FTP-Error: There was an error in transmission.

Which only saves half the whitelist for some reason? :S

BetterDeadThanZed · September 23, 2013

Can this be used on HFB Servers? And if you have to have a website is any free ones that use PHP?

Yes, it can be used with HFB. My server is hosted with HFB.

ToejaM · September 23, 2013

Also suggestion for the live map:

When it picks up everything on the map, could we have a tick box to only show certain items? Such as plot poles, tents, vaults ect as this will stop it from slowing down to a crawl and make it easier to find items.

Could you also add a second live map that doesnt have the option to show players?

When you click on the items on the map, could you have it show us the owner or at least the character ID so we can find out who put what where, thanks!

Going to be donating again :)

DethMarine · September 23, 2013

Yes, it can be used with HFB. My server is hosted with HFB.

So did you need to have you're own web hosting provider to use it?

BetterDeadThanZed · September 23, 2013

So did you need to have you're own web hosting provider to use it?

Yes, you do, or you can set up your own webserver with a program like XAMPP.

glowpowner · September 23, 2013

i also have it hosted by HFBServers

but it dont works for me have me own webserver but nothing works its says connected but still nothing works

BetterDeadThanZed · September 24, 2013

Can someone explain how the Epoch Key Generator works?

mysticviperx · September 24, 2013

I am getting a start up error in BEC, and I cant restart/shutdown the server from the PHT web interface.


Unhandled exception in thread started by <function start at 0x030495B0>
Traceback (most recent call last):
  File "C:\BEC\Plugins\pht_whitelist\__init__.py", line 85, in start
    Bec_MysqlHandler(i)
  File "C:\BEC\Plugins\pht_whitelist\__init__.py", line 50, in __init__
    self.MySqlObj = Bec_Mysql()
  File "C:\BEC\Plugins\pht_whitelist\__init__.py", line 20, in __init__
    self.db = self.connect()
  File "C:\BEC\Plugins\pht_whitelist\__init__.py", line 26, in connect
    db = MySQLdb.connect(self.HOST, self.USER, self.PASS, self.DATABASE)
  File "MySQLdb\__init__.pyo", line 81, in Connect

  File "MySQLdb\connections.pyo", line 187, in __init__
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

Project · September 24, 2013

Great online control panel.

ToejaM · September 24, 2013

Any idea with my problem of only half the list saving and throwing up that error?

nightmare · September 25, 2013

I am getting a start up error in BEC, and I cant restart/shutdown the server from the PHT web interface.


Unhandled exception in thread started by <function start at 0x030495B0>
Traceback (most recent call last):
  File "C:\BEC\Plugins\pht_whitelist\__init__.py", line 85, in start
    Bec_MysqlHandler(i)
  File "C:\BEC\Plugins\pht_whitelist\__init__.py", line 50, in __init__
    self.MySqlObj = Bec_Mysql()
  File "C:\BEC\Plugins\pht_whitelist\__init__.py", line 20, in __init__
    self.db = self.connect()
  File "C:\BEC\Plugins\pht_whitelist\__init__.py", line 26, in connect
    db = MySQLdb.connect(self.HOST, self.USER, self.PASS, self.DATABASE)
  File "MySQLdb\__init__.pyo", line 81, in Connect

  File "MySQLdb\connections.pyo", line 187, in __init__
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

BEC can't connect to your MySQL Server

(2003, "Can't connect to MySQL server on 'localhost' (10061)")

for RCON Shutdown / Restart:

- Battleye must be active

- Rcon passwd must be set

- ip and port must be right

is all right and you can connect successful with another RCON-Tool like DarT?!

- open your "PHP.ini " and look for "allow_url_fopen" , if "allow_url_fopen = Off" then change to " allow_url_fopen = On" ( restart your webserver )

nightmare · September 25, 2013

BEC PHT-WHITELIST PLUGIN CHANGELOG 25.09.2013
- FIX GUID was kicked when in database ( more like a ban as whitelist :P )

Achmed · September 25, 2013

is it only the plugin that has changed or some of the php files?

Web Based Tools ( PrivateHiveTools )

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

nightmare

nightmare

nightmare

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Similar Content