Page 1 of 1
XP database
Posted: Sun Jul 06, 2008 5:08 am
by priedzza
Hello, for some time I used war3FT 2.3.2. But recently I installed the newest one (RC11 I believe) and I changed the war3ft.cfg settings where to save the xp and I thought players who played before could continue, but nah, they can't because the newest war3ft has changed it date base etc. with wc3_ table. So I thought maybe there is an easy way how to copy the xp to that date base? Or should I just reset the xp.
p.s I used to savexp by MySQL etc.
Thanks, hope to get an answer soon!
Re: XP database
Posted: Sun Jul 06, 2008 9:30 am
by YamiKaitou
It should convert it to the new format. Did it not do that?
Re: XP database
Posted: Sun Jul 06, 2008 10:37 am
by priedzza
L 07/06/2008 - 19:35:22: [war3ft.amxx] [MYSQLX] Error in querying database, location: 15
L 07/06/2008 - 19:35:22: [war3ft.amxx] [MYSQLX] Message: Unknown column 'playerip' in 'field list' (1054)
L 07/06/2008 - 19:35:22: [war3ft.amxx] [MYSQLX] Query statement: INSERT INTO wc3_player select '', playerid, playerip, playername, time FROM `war3users` GROUP BY playerid;
XP is saved by nick btw, so is this going to be fixed?
Re: XP database
Posted: Mon Jul 07, 2008 6:41 am
by YamiKaitou
There is nothing for us to fix. The issue is on your end. The war3users table is missing a required column. You can create it if you want.
Re: XP database
Posted: Mon Jul 07, 2008 7:58 am
by priedzza
Ah, sorry then. But can you help me creating that table? So I log to phpmyadmin, select war3users datebase and then what?
Thank you!
Re: XP database
Posted: Mon Jul 07, 2008 8:07 am
by YamiKaitou
Show me a printscreen of the table
Re: XP database
Posted: Mon Jul 07, 2008 8:16 am
by priedzza
http://img371.imageshack.us/img371/5173 ... dinlm7.jpg
You can see there are already wc3_ tables created, but they don't contain player xp, they are empty.
Re: XP database
Posted: Mon Jul 07, 2008 8:35 am
by Geesu
create a playerip column... just make it like varchar 30
then delete the wc3_ tables (ALL OF THEM)
Then start plugin
profit
Re: XP database
Posted: Mon Jul 07, 2008 5:45 pm
by priedzza
Yeah, thanks! It formatted now and the xp is there! Thank you guys! Love that your still supporting war3FT, keep up the good work!
