Page 1 of 1
Using MySQL to save xp on RC11
Posted: Mon Jul 07, 2008 4:59 pm
by silversinner
Hey, been having some troubles with lagg spikes at the end of each round, we are using sqlite to save XP and was wandering if swithing to MySQL would solve the lagg spike issues?
but my problem is i dont know how to setup up the MySQL, i know how to enter all the database information like which host, username and password etc, but what to put in tables, i looked on the wiki in configuration but just comes up with some foreign language,
does anyone know what needs to be in the tables?
thanks
SS
Re: Using MySQL to save xp on RC11
Posted: Thu Jul 10, 2008 5:11 pm
by silversinner
alright thank you.
can you just double check for me, the settings ive changed have only been in the wc3FT.cfg in:
amxmodx>configs>war3ft>war3FT.cfg
Code: Select all
// Warcraft 3 Frozen Throne Configuration File
// Saving Options
wc3_save_xp 0 // Enables saving of experience (default is 0)
wc3_save_xp_db 1 // 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 0 // Automatically prunes the database of old users at a mapchange (default is 0)
wc3_days_before_delete 31 // 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)
// SQL Database Information
wc3_sql_dbhost "71.6.217.**" // Host Name
wc3_sql_dbuser "unlimite_wc3ft" // User Name
wc3_sql_dbpass "****" // Password
wc3_sql_dbname "unlimite_wc3ft" // Database Name
the * indicate stuff i dont want you to know
are there any other cvars i have missed out?
regards
SS
Re: Using MySQL to save xp on RC11
Posted: Tue Aug 19, 2008 11:25 am
by Mayhem
That looks right silversinner.