Pruning WC3FT Database
Posted: Sun Oct 21, 2007 2:26 pm
Code: Select all
L 10/21/2007 - 00:17:12: [war3ft.amxx] [MYSQLX] Error in querying database, location: 11
L 10/21/2007 - 00:17:12: [war3ft.amxx] [MYSQLX] Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE() (1064)
L 10/21/2007 - 00:17:12: [war3ft.amxx] [MYSQLX] Query statement: DELETE FROM wc3_player_race WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 14 DAY) > time ) );
Amxmodx Version: 1.76d
Metamod Version: P28
amxx list:
Code: Select all
Currently loaded plugins:
name version author file status
[ 1] AMXBans 5.0 YoMama/Lux & lan amxbans.amxx debug
[ 2] AmxBans Admin Base 1.76 AMXX Dev Team admin_amxbans.a running
[ 3] Admin Commands 1.76d AMXX Dev Team admincmd.amxx running
[ 4] Admin Help 1.76d AMXX Dev Team adminhelp.amxx running
[ 5] Multi-Lingual System 1.76d AMXX Dev Team multilingual.am running
[ 6] Menus Front-End 1.76d AMXX Dev Team menufront.amxx running
[ 7] Commands Menu 1.76d AMXX Dev Team cmdmenu.amxx running
[ 8] Players Menu 1.76d AMXX Dev Team plmenu.amxx running
[ 9] Teleport Menu 1.76d AMXX Dev Team telemenu.amxx running
[ 10] Maps Menu 1.76d AMXX Dev Team mapsmenu.amxx running
[ 11] Admin Chat 1.76d AMXX Dev Team adminchat.amxx running
[ 12] Anti Flood 1.76d AMXX Dev Team antiflood.amxx running
[ 13] Scrolling Message 1.76d AMXX Dev Team scrollmsg.amxx running
[ 14] Info. Messages 1.76d AMXX Dev Team imessage.amxx running
[ 15] Admin Votes 1.76d AMXX Dev Team adminvote.amxx running
[ 16] NextMap 1.76d AMXX Dev Team nextmap.amxx running
[ 17] TimeLeft 1.76d AMXX Dev Team timeleft.amxx running
[ 18] Pause Plugins 1.76d AMXX Dev Team pausecfg.amxx running
[ 19] Stats Configuration 1.76d AMXX Dev Team statscfg.amxx running
[ 20] Restrict Weapons 1.76d AMXX Dev Team restmenu.amxx running
[ 21] StatsX 1.76d AMXX Dev Team statsx.amxx running
[ 22] CS Misc. Stats 1.76d AMXX Dev Team miscstats.amxx running
[ 23] Warcraft 3 Frozen Thro 3.0 RC8 Geesu & Avanderi war3ft.amxx debug
[ 24] AMX Super 3.1 Bmann_420 & Bo0m amx_super.amxx running
[ 25] Bad Camper 1.3b Brad Jones bad_camper.amxx running
[ 26] Grenade Spam Punish 1.3 [gOf]-Soul grenspampunish. running
[ 27] Admin Spectator ESP 1.3 KoST admin_spec_esp. running
[ 28] AMX Toggle Immunity 3.12 slmclarengt amx_toggleimmun running
[ 29] DeagsMapManager 2.40 Deags/JTP10181 deagsmapmanager running
[ 30] Descriptive 'Fire in t 0.1 VEN descriptive_fir running
[ 31] No Rush 2.0 GHW_Chronic GHW_No_Rush.amx running
[ 32] List Maps 1.0 stupok69 listmaps.amxx running
[ 33] Advanced Roll The Dice v2.5 RC Striker roll_the_dice.a running
[ 34] Spawn Protection 7.0 Peli spawnprotection running
[ 35] AdThemes 1.6 Vet(3TT3V) adthemes.amxx running
[ 36] FakeFull Original 1.7.6 JTP10181/Freecod fakefull_origin running
[ 37] Server redirect 0.9.1 x0R serverredirect. running
[ 38] Map Spawns Editor 1.0.16 iG_os Map_Spawns_Edit running
[ 39] Knife Only on Bridge i 1.0 xx_sirhc_xx amx_deagle5_kni running
39 plugins, 39 running
Code: Select all
Currently loaded modules:
name version author status
[ 1] MySQL 1.76b AMX Mod X Dev Team running
[ 2] Fun 1.76 AMX Mod X Dev Team running
[ 3] Engine 1.76 AMX Mod X Dev Team running
[ 4] FakeMeta 1.76d AMX Mod X Dev Team running
[ 5] CStrike 1.76 AMX Mod X Dev Team running
[ 6] CSX 1.76c AMX Mod X Dev Team running
[ 7] SQLite 1.76b AMX Mod X Dev Team running
[ 8] Sockets 1.76 HLSW Dev Team running
8 modules, 8 correct
meta list:
Code: Select all
Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm.dll v1.76d ini ANY ANY
[ 2] SBSRV RUN - sbsrv_mm.dll v3.5.2 ini Start Never
[ 3] MySQL RUN - mysql_amxx.dll v1.76b pl1 ANY ANY
[ 4] Fun RUN - fun_amxx.dll v1.76 pl1 ANY ANY
[ 5] Engine RUN - engine_amxx.dll v1.76 pl1 ANY ANY
[ 6] FakeMeta RUN - fakemeta_amxx.dl v1.76d pl1 ANY ANY
[ 7] CStrike RUN - cstrike_amxx.dll v1.76 pl1 ANY ANY
[ 8] CSX RUN - csx_amxx.dll v1.76c pl1 ANY ANY
[ 9] SQLite RUN - sqlite_amxx.dll v1.76b pl1 ANY ANY
9 plugins, 9 running
Code: Select all
// Warcraft 3 Frozen Throne Configuration File
// Saving Options
wc3_save_xp 1 // Enables saving of experience (default is 0)
wc3_save_xp_db 1 //TESTING // How should we save XP? (0 = SQLite, 1 = MySQL)
wc3_save_by 0 // What should I save this as? steam id = 0, IP = 1, name = 2 (default is 0)
wc3_save_pruning 1 // Automatically prunes the database of old users at a mapchange (default is 0)
wc3_days_before_delete 14 // However many days before deleting XP or pruning from the database (default is 31)
wc3_save_end_round 1 // Save xp at the end of each round (may cause lag, default is 1)
MySQL version: 4.0.25
Slmclarengt