Web Based Tools ( PrivateHiveTools )

[nightmare]

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]

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]

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]

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]

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]

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]

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]

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]

 

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]

yay it worked :)

 

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

[nightmare]

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]

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

[ToejaM]

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]

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]

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]

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]

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]

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]

Can someone explain how the Epoch Key Generator works?

[mysticviperx]

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]

Great online control panel.

[ToejaM]

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

[nightmare]

 

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]

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

[Achmed]

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