/!\ IF YOU DON'T WANT TO USE THE SQL MODULE, YOU HAVE TO COMMENT THE LINE "#define AMXMD_USE_SQL" AND RECOMPILE THE PLUGIN (read AMXX readme/doc). /!\ http://wiki.amxmodx.org/Configuring_AMX_Mod_X#SQL Note: If you are not getting stats added to your database, search your log files for: [AMXX] SQL Connection FailedIf you are getting that error, there is a problem with your sql.cfg file, or your SQL server is not configured correctly.
[AMXX] SQL Connection Failed
Open web/config.php Edit config.php file for the correct information: $mysql_host -- Hostname of your SQL server (Can also use ip address, e.g. '127.0.0.1') $mysql_username -- User name of your SQL server $mysql_password -- Password for the username used $mysql_database -- Database name on your SQL server Upload files to your web server
/!\ IF YOU DON'T WANT TO USE THE SOCKETS MODULE (FOR THE HLTV), YOU HAVE TO COMMENT THE LINE "#define AMXMD_USE_HLTV" AND RECOMPILE THE PLUGIN (read AMXX readme/doc). /!\ To configure your HLTV: In order to be able to control the HLTV, you must know the rcon password. HLTV rcon can be set using "adminpassword" command in the HLTV console HLTV Checklist: Load your HLTV.Set the HLTV adminpassword by using adminpassword <rcon> command in the HLTV console. Then connect it to your server using "connect ip:port" in the console.Set the HLTV adminpassword in the 'hltv.ini' config file.Load your match on the server using amx_match or amx_match2If your HLTV is already connected, you should see it say " HLTV correctly configured =)".If you don't see that, it means that the HLTV adminpassword hasn't been correctly configured.If your HLTV isn't connected, it will try the adminpassword that you've set when it enters the server.
8.11: (minor release) - Sunday, June 24, 2007 fixed bug in stats_log where plugin would not compile with SQL stats disabled ------ 8.10: (semi-major release) - Sunday, June 24, 2007 added multi-lingual support to menu headings ---changed the sql functions to only log an error when they failed to connect to the sql server, rather than fail the plugin changed picking of teams after a knife round to a vote, rather than say commands changed pug style games to change to next map in the mapcycle rather than to a default map (i.e. only to dust2) ---fixed hltv delay bug where second half demos were being cut off after only 30 seconds or so fixed bug in knife round where users could still fire one shot with the pistol before being forced to switch to knife ------ 8.02: (minor release) - Tuesday, May 22, 2007 fixed typo in knife round's start message: "KNIFE_ROUND_STARTED" vs. "KNIFE_ROUND_START" ------ 8.01: (minor release) - Sunday, May 20, 2007 fixed bug where after a team had won in a knife-round only Ts could pick a team, even if CTs won fixed bug where you could still type 'ready' in knife round fixed bug where teams would be swapped, but the clan names wouldn't after a knife round fixed bug where ready list would still display "None." even after the first player was ready ---changed sequence of knife round/warmup/first half (now start-]warmup-]knife round-]warmup-]first half) ------ 8.00: (major release) - Friday, May 18, 2007 added French translation, thanks AIA-Shogun added updated German translation, thanks ToT | V!PER added br translation, thanks rfrik added Serbian translation, thanks iggy_bus ---fixed hltv bug, thanks AIA-Shogun fixed hltv delay bug ---added knife round added unlimited overtime support added cvar 'amx_match_otunlimited' added MySQL support for recording stats added PHP/MySQL web interface to display SQL stats ---changed name of cvar: 'amx_match_overtimecfg' to 'amx_match_otcfg', to match other overtime cvar names changed format of hltv demos to remove duplicate parts of the demo name changed the format for logging stats to the match half file (check that file for the new format) ------ 7.03: (minor release) - Monday, November 13, 2006 fixed runtime error when executing a match ------ 7.02: (minor release) - Friday, November 10, 2006 added warmup configs added constants for all file handles so all hardcoded file names are all variables and in one place added cvar amx_match_warmupcfg. ---fixed problem where match would not end, if match played through all rounds and endtype was not 0 ---changed the format of the teams for the logging: CT -] 2, T -] 1 (instead of CT -] 1, T -] 2) ---removed french translation due to all of the problems that the incomplete translation is causing. (Will add it back in once somebody translates it again) ------ 7.01: (minor release) - Friday, July 21, 2006 fixed OT portion of the plugin. Overtime works correctly now... fixed bug where password would be shown to all players if the server console started a match (id=0) fixed bug where first map's name was used for demos during second map in a two map match. ---updated swedish translation for five missing translation tags, thanks TheLinx. ------ 7.00: (major release) - Saturday, July 15, 2006 added PUG type gameplay (See www.sk-gaming.com for details) turned on by cvar added winlimit type matches added logging to HL logs as well as AMXX logs added printing to server console as well as AMXX logs added two new console commands 'amx_match_addlength' and 'amx_match_addconfig' (equiv. to server commands: 'amx_match_lmenu' and 'amx_match_cmenu') added two map matches (amx_match3 and amx_match4) added logging of match stats added new command 'say /relo3' added new command 'amx_matchrelo3' added ability to restart the half as well as the match added ability for league files to be in the main cstrike directory as well as in '/amxmd/leagues/' added file: 'defaultmaps.ini' for maps list in the menu added polish translation, thanks rain. added danish translation, thanks ZiP*. added czech translation, thanks James. added team randomizer, thanks for the idea Eklundh added cvar amx_match_pugstyle added cvar amx_match_randomizeteams added cvar amx_match_stats ---alphabatized the translation file (amx_match_deluxe.txt) ---changed swap_teams to support the new cs_user_change_team functions (Swaps without killing the player) changed the order of menus (removed 'match_type -> mr13'; added 'MatchType -> MR/TL/WL' and 'MatchLength -> 13'; added a menu for Tags/No Tags between CT Tags and the main menu ) changed all hud message channels (except the timer and show_score functions) to -1. changed the way the plugin looks for the config file list in match_start; cfglist.txt is not used anymore changed the settings menu to disable the dependent settings when the independent settings are disabled (amx_match_otlength and amx_match_overtimecfg, when amx_match_overtime is disabled, for instance) changed the readme to html format changed the defaults for some of the cvars (refer to cvar portion of the readme) ---fixed menu settings function so it's not completely dependent on what cvars are registered (can't think of a way to completely get away from dependency) fixed hltv delay, it actually delays the hltv now... fixed all multilingual lines of code to use 'id' and 'LANG_PLAYER' properly ---updated swedish translation, thanks TheLinx. updated german translation, thanks pl2003. ---reformated function names reformated variable names ---removed support for NO_STEAM ---rewrote 'new_score' and 'start_match' functions completely new layoutsway easier to debug
fixed bug in stats_log where plugin would not compile with SQL stats disabled
added multi-lingual support to menu headings ---changed the sql functions to only log an error when they failed to connect to the sql server, rather than fail the plugin changed picking of teams after a knife round to a vote, rather than say commands changed pug style games to change to next map in the mapcycle rather than to a default map (i.e. only to dust2) ---fixed hltv delay bug where second half demos were being cut off after only 30 seconds or so fixed bug in knife round where users could still fire one shot with the pistol before being forced to switch to knife
---
fixed typo in knife round's start message: "KNIFE_ROUND_STARTED" vs. "KNIFE_ROUND_START"
fixed bug where after a team had won in a knife-round only Ts could pick a team, even if CTs won fixed bug where you could still type 'ready' in knife round fixed bug where teams would be swapped, but the clan names wouldn't after a knife round fixed bug where ready list would still display "None." even after the first player was ready ---changed sequence of knife round/warmup/first half (now start-]warmup-]knife round-]warmup-]first half)
added French translation, thanks AIA-Shogun added updated German translation, thanks ToT | V!PER added br translation, thanks rfrik added Serbian translation, thanks iggy_bus ---fixed hltv bug, thanks AIA-Shogun fixed hltv delay bug ---added knife round added unlimited overtime support added cvar 'amx_match_otunlimited' added MySQL support for recording stats added PHP/MySQL web interface to display SQL stats ---changed name of cvar: 'amx_match_overtimecfg' to 'amx_match_otcfg', to match other overtime cvar names changed format of hltv demos to remove duplicate parts of the demo name changed the format for logging stats to the match half file (check that file for the new format)
fixed runtime error when executing a match
added warmup configs added constants for all file handles so all hardcoded file names are all variables and in one place added cvar amx_match_warmupcfg. ---fixed problem where match would not end, if match played through all rounds and endtype was not 0 ---changed the format of the teams for the logging: CT -] 2, T -] 1 (instead of CT -] 1, T -] 2) ---removed french translation due to all of the problems that the incomplete translation is causing. (Will add it back in once somebody translates it again)
fixed OT portion of the plugin. Overtime works correctly now... fixed bug where password would be shown to all players if the server console started a match (id=0) fixed bug where first map's name was used for demos during second map in a two map match. ---updated swedish translation for five missing translation tags, thanks TheLinx.
added PUG type gameplay (See www.sk-gaming.com for details) turned on by cvar added winlimit type matches added logging to HL logs as well as AMXX logs added printing to server console as well as AMXX logs added two new console commands 'amx_match_addlength' and 'amx_match_addconfig' (equiv. to server commands: 'amx_match_lmenu' and 'amx_match_cmenu') added two map matches (amx_match3 and amx_match4) added logging of match stats added new command 'say /relo3' added new command 'amx_matchrelo3' added ability to restart the half as well as the match added ability for league files to be in the main cstrike directory as well as in '/amxmd/leagues/' added file: 'defaultmaps.ini' for maps list in the menu added polish translation, thanks rain. added danish translation, thanks ZiP*. added czech translation, thanks James. added team randomizer, thanks for the idea Eklundh added cvar amx_match_pugstyle added cvar amx_match_randomizeteams added cvar amx_match_stats ---alphabatized the translation file (amx_match_deluxe.txt) ---changed swap_teams to support the new cs_user_change_team functions (Swaps without killing the player) changed the order of menus (removed 'match_type -> mr13'; added 'MatchType -> MR/TL/WL' and 'MatchLength -> 13'; added a menu for Tags/No Tags between CT Tags and the main menu ) changed all hud message channels (except the timer and show_score functions) to -1. changed the way the plugin looks for the config file list in match_start; cfglist.txt is not used anymore changed the settings menu to disable the dependent settings when the independent settings are disabled (amx_match_otlength and amx_match_overtimecfg, when amx_match_overtime is disabled, for instance) changed the readme to html format changed the defaults for some of the cvars (refer to cvar portion of the readme) ---fixed menu settings function so it's not completely dependent on what cvars are registered (can't think of a way to completely get away from dependency) fixed hltv delay, it actually delays the hltv now... fixed all multilingual lines of code to use 'id' and 'LANG_PLAYER' properly ---updated swedish translation, thanks TheLinx. updated german translation, thanks pl2003. ---reformated function names reformated variable names ---removed support for NO_STEAM ---rewrote 'new_score' and 'start_match' functions completely new layoutsway easier to debug
