Web Based Tools ( PrivateHiveTools )

[nightmare]

  On 7/31/2014 at 9:03 AM, Dave said:

Hi,

everything working for me except there is no player information, and the do not show on the map.  Where have I went wrong?

 

 

  On 7/31/2014 at 5:20 PM, CMDR. Taco said:

Same for me.

 

 

please look:

[BetterDeadThanZed]

  On 8/1/2014 at 3:28 AM, nightmare said:

removed because the new "PHT" works with sqlite instead of mysql (on hive)  for his own structure.

 

Is a whitelist feature something you'd consider developing for a future version? It was really handy having that web interface to add people to the whitelist.

[nightmare]

  On 8/1/2014 at 8:38 AM, BetterDeadThanZed said:

Is a whitelist feature something you'd consider developing for a future version? It was really handy having that web interface to add people to the whitelist.

 

 

only when epoch comes with a whitelist feature by default.

[RC_Robio]

Got everything fully functioning. Thanks for the updates!!

[Captvape]

i can see players whn i injected the sql code for players but in the objects part it says it is already there, and it is already there with dates in it not NULL  

 

what should i do?

[ReDBaroN]

Hi, I seem to be failing at the first hurdle! Can anyone help?

 

All I have done is to copy xampp to my F:\, execute start.bat and I get this message below:

 

Diese Eingabeforderung nicht waehrend des Running beenden

Bitte erst bei einem gewollten Shutdown schliessen

Please close this command only for Shutdown

Apache 2 is starting ...

(OS 10048)Only one usage of each socket address (protocol/network address/port)

is normally permitted.  : AH00072: make_sock: could not bind to address 0.0.0.0:

80

AH00451: no listening sockets available, shutting down

AH00015: Unable to open logs

 

Apache konnte nicht gestartet werden

Apache could not be started

Press any key to continue . . .

[nightmare]

that means the PORT 80 on your box  is already in use, change the PORT number or shutdown the other application which is using PORT 80

(OS 10048)Only one usage of each socket address (protocol/network address/port)

is normally permitted.  : AH00072: make_sock: could not bind to address 0.0.0.0:80

[ReDBaroN]

  On 8/8/2014 at 6:24 PM, nightmare said:

 

that means the PORT 80 on your box  is already in use, change the PORT number or shutdown the other application which is using PORT 80

(OS 10048)Only one usage of each socket address (protocol/network address/port)

is normally permitted.  : AH00072: make_sock: could not bind to address 0.0.0.0:80

Thanks for your reply, can you tell me where I can change the port from 80 and what I could/should change it to?

[ReconSix]

Hey guys, 

 

Is this compatible with Taviana? I don't see it in the list of supported maps is there any way this can be configured for Tavi 2.0?

 

Thanks, 

[nightmare]

  On 8/13/2014 at 5:47 PM, ReconSix said:

Hey guys, 

 

Is this compatible with Taviana? I don't see it in the list of supported maps is there any way this can be configured for Tavi 2.0?

 

Thanks, 

 

 

yes, you can use all functions except the live map.

[ReDBaroN]

  On 8/8/2014 at 7:11 PM, ReDBaroN said:

Thanks for your reply, can you tell me where I can change the port from 80 and what I could/should change it to?

Hi Nightmare, can you help me with my question?

 

I would really love to use this tool but am completely out of my comfort zone with web stuff and ports etc.

[nightmare]

  On 8/14/2014 at 8:47 AM, ReDBaroN said:

Hi Nightmare, can you help me with my question?

 

I would really love to use this tool but am completely out of my comfort zone with web stuff and ports etc.

 

 

1.) go to  C:\xampp\apache\conf  and open the "httpd.conf" with a texteditor (notepad++) and look for "Listen 80" and change it to "Listen 81"  ->  SAVE FILE!

 

2.) open the "start.bat" file in "C:\xampp\"  with texteditor and change "start http://localhost/index.php" to "start http://localhost:81/index.php"  ->  SAVE FILE!

[ReDBaroN]

  On 8/14/2014 at 9:10 AM, nightmare said:

1.) go to  C:\xampp\apache\conf  and open the "httpd.conf" with a texteditor (notepad++) and look for "Listen 80" and change it to "Listen 81"  ->  SAVE FILE!

 

2.) open the "start.bat" file in "C:\xampp\"  with texteditor and change "start http://localhost/index.php" to "start http://localhost:81/index.php"  ->  SAVE FILE!

Thanks! 

[Darth_Rogue]

Having an issue with the trader parser.  Tried to use it today on a new server and I get an error.

 

  Quote

 

 

CWarning: SQLite3::query(): Unable to prepare statement: 1, near ",": syntax error inC:\inetpub\wwwroot\PHTEpoch\includes\SQLConnect.phpon line 69:\inetpub\wwwroot\PHTEpoch\includes\SQLConnect.phpon line 69

 

I'm using a stock server_traders.sqf.

 

Any ideas?

[Oshydaka]

Hi Nightmare.

 

Could you please check your Altis web map ?

 

I think the coord system is not right :/

 

The GPS indicate wrong coord.

 

Like Paros, in 105 / 382 instead of 210 / 170

 

 

You can check the map here :

 

(huge image, so just a link : http://digitaleccentric.files.wordpress.com/2013/09/arma3atlis.jpg )

[Darth_Rogue]

Ok so I rolled over to the Apache version and that solved my sqlite problem that I posted about a couple posts ago.  It is now able to successfully parse the server_traders file.  But now I've found that this new version doesn't have the trader drop down box when you want to add a new item to a trader.  You have to know the trader ID.  There's several tids for each category (i.e., Weapons Friendly - 485, 486, 489, 574, 487, 488) .  How do I know which one to use when entering a new item??  Does it even matter?

[THEbookie]

When editing the traders like the old version is this compatible with the Gold Coins?

 

EDIT: wait never mind, maybe I can just add stuff in and change to coins this way - 

[bmw]

─▄▒▒▒▒▒▒─▄▒▒▄▒▒─▄▒▒▄▒▒
─▀▀█▒▒▀──█▒▒▒▒▒─▀█▒▒▒
───█▒▒───█▒▒█▒▒─▄▒▒█▒▒
───▀▀────▀▀─▀▀──▀▀─▀▀─ 

[BetterDeadThanZed]

I've had this set up for my Napf server for a while and previously for a Takistan server and it's worked fine. I just put up a new Takistan server and it's not showing player data, although "latest objects" works fine. All tables are lower case in both databases. Any idea why?

 

 

[ReDBaroN]

  On 8/24/2014 at 10:51 PM, BetterDeadThanZed said:

I've had this set up for my Napf server for a while and previously for a Takistan server and it's worked fine. I just put up a new Takistan server and it's not showing player data, although "latest objects" works fine. All tables are lower case in both databases. Any idea why?

Hey man, did you check part 3 of this post for lastupdated column in character_data:

[BetterDeadThanZed]

  On 8/25/2014 at 1:54 AM, ReDBaroN said:

Hey man, did you check part 3 of this post for lastupdated column in character_data:

 

Oh yeah, now I remember that! :) Now it's working. Thanks!

[BetterDeadThanZed]

Ok so now there's another problem. I added an admin and the box to edit the permissions isn't there, and I can't delete the admin. If I try deleting him, it says "An error has occured". BTW: I think this tool should get it's own forum section here.

 

[nightmare]

  On 8/25/2014 at 2:10 AM, BetterDeadThanZed said:

Ok so now there's another problem. I added an admin and the box to edit the permissions isn't there, and I can't delete the admin. If I try deleting him, it says "An error has occured". BTW: I think this tool should get it's own forum section here.

 

 

 

 

please download again, i have it fixed since a while.

 

!( overwrite except "/map", "config.php", "/db" )

[Oshydaka]

Nightmare, anything about my issue with Altis web map ?

[SmokeyBR]

hello

i added all the recomended sql events that comes with  epoch server 1.0.5.1

 

Since then my objects (buildables) wont show location on map, noticed it added key or codes for every buildable objects

im not sure wich sql event did that but its got to be one of these. 3,

 

  Reveal hidden contents

-- ----------------------------
-- Function structure for FindVehicleKeysCount
-- ----------------------------
DROP FUNCTION IF EXISTS `FindVehicleKeysCount`;
DELIMITER ;;
CREATE FUNCTION `FindVehicleKeysCount`(`keyId` INT) RETURNS int(11)
BEGIN
    DECLARE totalKeys INT DEFAULT 0;
    DECLARE keyName VARCHAR(32) DEFAULT "";
    DECLARE keysInChar INT DEFAULT 0;
    DECLARE keysInObj INT DEFAULT 0;
 
    SET keyName = (CASE
        WHEN `keyId` < 2501 THEN CONCAT('ItemKeyGreen', `keyId`)
        WHEN `keyId` < 5001 THEN CONCAT('ItemKeyRed', `keyId` - 2500)
        WHEN `keyId` < 7501 THEN CONCAT('ItemKeyBlue', `keyId` - 5000)
        WHEN `keyId` < 10001 THEN CONCAT('ItemKeyYellow', `keyId` - 7500)
        WHEN `keyId` < 12501 THEN CONCAT('ItemKeyBlack', `keyId` - 10000)
        ELSE 'ERROR'
    END);
 
    SET keysInChar = (SELECT COUNT(*) FROM `Character_DATA` WHERE `Alive` = '1' AND (`Inventory` LIKE CONCAT('%', keyName, '%') OR `Backpack` LIKE CONCAT('%', keyName, '%')));
    SET keysInObj = (SELECT COUNT(*) FROM `Object_DATA` WHERE `Inventory` LIKE CONCAT('%', keyName, '%'));
 
    RETURN (keysInChar + keysInObj);
END
;;
DELIMITER ;
 
-- ----------------------------
-- Function structure for DeleteNonKeyVehicles
-- Example usage: SELECT DeleteNonKeyVehicles();
-- ----------------------------
DROP FUNCTION IF EXISTS `DeleteNonKeyVehicles`;
DELIMITER ;;
CREATE FUNCTION `DeleteNonKeyVehicles`() RETURNS int(11)
BEGIN
DELETE FROM
`Object_DATA`
WHERE
`Object_DATA`.`CharacterID` <> 0
AND `Object_DATA`.`CharacterID` <= 12500
AND `Object_DATA`.`Classname` NOT LIKE 'Tent%'
AND `Object_DATA`.`Classname` NOT LIKE '%Locked'
AND `Object_DATA`.`Classname` NOT LIKE 'Land%'
AND `Object_DATA`.`Classname` NOT LIKE 'Cinder%'
AND `Object_DATA`.`Classname` NOT LIKE 'Wood%'
AND `Object_DATA`.`Classname` NOT LIKE 'Metal%'
AND `Object_DATA`.`Classname` NOT LIKE '%Storage%'
AND `Object_DATA`.`Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ', 'DesertCamoNet_DZ', 'StickFence_DZ', 'LightPole_DZ', 'DeerStand_DZ', 'ForestLargeCamoNet_DZ', 'Plastic_Pole_EP1_DZ', 'Hedgehog_DZ', 'FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ')
AND FindVehicleKeysCount(Object_DATA.CharacterID) = 0;
 
RETURN ROW_COUNT();
END
;;
DELIMITER ;
-- ----------------------------
-- Event structure for UnlockNonKeyVehicles
-- ----------------------------
DROP EVENT IF EXISTS `UnlockNonKeyVehicles`;
DELIMITER ;;
CREATE EVENT `UnlockNonKeyVehicles` ON SCHEDULE EVERY 1 DAY DO UPDATE
`Object_DATA`
SET
`Object_DATA`.`CharacterID` = 0
WHERE
`Object_DATA`.`CharacterID` <> 0
AND `Object_DATA`.`CharacterID` <= 12500
AND `Object_DATA`.`Classname` NOT LIKE 'Tent%'
AND `Object_DATA`.`Classname` NOT LIKE '%Locked'
AND `Object_DATA`.`Classname` NOT LIKE 'Land%'
AND `Object_DATA`.`Classname` NOT LIKE 'Cinder%'
AND `Object_DATA`.`Classname` NOT LIKE 'Wood%'
AND `Object_DATA`.`Classname` NOT LIKE 'Metal%'
AND `Object_DATA`.`Classname` NOT LIKE '%Storage%'
AND `Object_DATA`.`Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ', 'DesertCamoNet_DZ', 'StickFence_DZ', 'LightPole_DZ', 'DeerStand_DZ', 'ForestLargeCamoNet_DZ', 'Plastic_Pole_EP1_DZ', 'Hedgehog_DZ', 'FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ')
AND FindVehicleKeysCount(Object_DATA.CharacterID) = 0
;;
DELIMITER ;

 

 

can anyone help ?