Jump to content

Recommended Posts

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 . . .
Link to comment
Share on other sites

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
Link to comment
Share on other sites

 

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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

 

 

 

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?

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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:

Link to comment
Share on other sites

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.

 

juQkSp.png

 

 

 

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

 

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

Link to comment
Share on other sites

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,

 

-- ----------------------------
-- 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 ?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...