[No1.Pervade]

Hello,

FIRST PROBLEM: I RECEIVE THIS ERROR WHEN I EXECUTE THE instal.sql file.

WRONG
COMMAND SQL:

-- -- Dumping data for table `hlstats_Actions` -- INSERT INTO `hlstats_Actions` (`game`, `code`, `reward_player`, `reward_team`, `team`, `description`, `for_PlayerActions`, `for_PlayerPlayerActions`, `for_TeamActions`, `for_WorldActions`) VALUES ('tf', 'flagevent_defended', 1, 0, '', 'Defended the flag', '1', '', '', ''), ('tf', 'flagevent_captured', 5, 1, '', 'Captured the flag', '1', '', '', ''), ('tf', 'flagevent_dropped', -2, 0, '', 'Dropped the flag (while alive)', '1', '', '', ''), ('tf', 'flagevent_dropped_death', 0, 0, '', 'Dropped the flag (on death)', '1', '', '', ''), ('tf', 'flagevent_picked_up', 2, 0, '', 'Picked up the flag', '1', '', '', ''), ('tf', 'killedobject_obj_teleporter', 2, 0, '', 'Destroyed a teleporter', '1', '', '', ''), ('tf', 'killedobject_obj_dispenser', 3, 0, '', 'Destroyed a dispenser', '1', '', '', ''), ('tf', 'killedobject_obj_sentrygun', 4, 0, '', 'Destroyed a sentry gun', '1', '', '', ''), ('tf', 'killedobject_obj_sentrygun_mini', 4, 0, '', 'Destr[...]

Η MySQL Returned this message.

#1062 - Duplicate entry 'flagevent_defended-tf-' for key 'gamecode'


SECOND PROBLEM:ALSO ABOUT THAT 0/0 PLAYERS I FOLLOWED THAT TUTORIAL:

Old 11-23-12 , 01:45 PM Re: Frequently Asked Questions (FAQ)
#3
Q: How can I resolve the 0/0 players notation on the website?
Q: How can I resolve the 366573:0:0 maptime notation on the website?
Q: My server is getting the error: "NOT ALLOWED SERVER"

A: This can be because of a few issues:
Take a look at the Hosting Blacklist? Is your webhoster mentioned? If so, stop everything you are trying to do, it won't work, get a different hoster!!!
Is the Daemon running?
Is the port that the Daemon is listening on open? (is it firewalled or are you perhaps behind a router?)
Do you have the correct modtype for the gameserver you are running? (ie. DoD:S and not DoD gold)
Is the server you wish to include in the stats also filled in as a gameserver under the gametab (admin section)?
Have you added the loggaddress to the config?
Either add the following to the server.cfg or the autoexec.cfg file:
HL2
Code:
logaddress_add ip:port
HL1
Code:
logaddress_add ip port
ip and port being the ip and port your hlstats daemon is running on. If this is the same machine, be sure to use the internal ip (192.168.100.185 for example, do not use 127.0.0.1!).
The server's rcon password is not the same with that it is configured with.
Please login as admin on the website.
Go to the gameslist and click on the gamemod you are hosting.
Click on the tab called "edit server" and then on the link called "configure".
A new page should be shown in which is a textbox with the option of filling in a rcon password.
Make sure the rcon on both this textfield and your gameserver are the same.
RESTART the daemon.

BUT I CANNOT GET IT TO WORK MAY ITS THE SQL ERROR I DONT KNOW REALY IM A BEGINNER

OTHER INFO MAY BE IMPORTANT:
GAME: CS 1.6 (HL1 ENGINE)
GAMEMOD: AMXMODX IN SITE SETTING CONFIGURES AS AMXX
THIRD PROBLEM:PLUGIN IN GAME IS RUNNING FINE BUT ONLY hlx_menu command works that the menu turns on if i press any command from menu like /top10 nothing happens.

I APPRECIATE ANY HELP I WOULD REALY LIKE TO GET IT WORK BECAUSE I SPENT HOURS TO INSTALL IT.

[No1.Pervade]

Port 27500 fro daemon and servers ports 27015 for cs 1.6 should be opened for outbound and inbound connections from my host so the server can be online and hlstatsx run now its ok and online.

thanks my self again sarcasm