Warcraft 3 MODs

Posted: **Sat Nov 19, 2005 10:20 am**

Hi,

Well, before i start, I have read ALL the threads I could find regarding SQL, also the How-To . still cant get it to work...

my problem is :

whenever I convert the vault from the convertion base to my SQL server I get an error : could not select database. php error on line 94, undeclared variable dbname

well, the privileges on the sql server, the database and the table are all set up and do have the right permissions. but still it wont convert. and when i dl the vault as an sql file and try to implement it via phpmyadmin it doesnt work either... guess it`s too large ( 1.8 MB )

now i`m really running out of ideas, anyone ahs an explanation for this ?

Posted: **Sat Nov 19, 2005 2:08 pm**

Fixed, I re-wrote the vault code and didn't test it

Thanks for reading the other threads though! Not a lot of people do that

Posted: **Thu Nov 24, 2005 9:47 am**

zhx for re-writing it, the table is now filled with all the users xp`s, however, there is still an slight problem I encounter... heres the part from the wc3.cfg :

Code: Select all

mp_savexp		1		// Enables saving of experience (uses a vault, default is 0)
sv_mysql		1		// this will save w/MySQL (note: to use this mp_savexp must also be 1, default is 0)
FT_saveby		0		// What should I save this as?  steam id = 0, IP = 1, name = 2 (works for vault and mysql, default is 0)

// MySQL configuration
FT_mysql_host		"193.22.164.134"	// Host Name
FT_mysql_user		"root"		// User Name
FT_mysql_pass		"*******"		// Password
FT_mysql_db		"war3xp"		// Database Name
sv_mysql_auto_pruning	1		// Automatically prunes the database of old users at a mapchange occuring between 5:36 to 5:59 AM (default is 0, doesn't work for vault)
sv_daysbeforedelete	31		// However many days before deleting XP or pruning from MySQL database (default is 31)
sv_mysqltablename	"war3users"	// Table Name, no need to change (default is war3users)
sv_mysql_save_end_round 0		// Save Users at the end of each round (causes slight lag, default is 0)
FT_disable_savexp	0		// Set this to 1 to disable users typing /savexp (default is 0)

whenever I activate those settings wc3 disables... well, the SQL module is running of course... any ideas ?

Warcraft 3 MODs

SQL-Problem...

SQL-Problem...