XP database

[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!

[YamiKaitou]

It should convert it to the new format. Did it not do that?

[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?

[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.

[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!

[YamiKaitou]

Show me a printscreen of the table

[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.

[Geesu]

create a playerip column... just make it like varchar 30

then delete the wc3_ tables (ALL OF THEM)

Then start plugin

profit

[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!