Using MySQL to save xp on RC11

[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

[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

[Mayhem]

That looks right silversinner.