UPDATED TO RC6.0

Senne · Post by **Senne** » Wed Apr 11, 2007 2:21 pm

Xp started back from 0 , it looks like the mysql database is changed , no more table war3users???

It now creates diffrent tables ; so does updating means everyone will loose there xp?

* war3users
* wc3_config
* wc3_player
* wc3_player_race
* wc3_player_skill
* wc3_web_race
* wc3_web_skill

before it was just * war3users

--- Please enter the following information for support ---
War3ft Version:
Amxmodx Version:
Metamod Version:
amxx list:
amxx modules:
meta list:

Post by **Geesu** » Wed Apr 11, 2007 2:32 pm

3.0 Final will auto-convert old XP

Senne · Post by **Senne** » Wed Apr 11, 2007 2:50 pm

owke so i just have to wait on the final release and convert xp then?

bec it would mean almost the end of my server if i have to reset it tho...

AlataR · Post by **AlataR** » Sat Apr 14, 2007 2:38 am

heh, zero xp frightended players!))

Gessu, hm, it did not converted xp!! I just replaced plugin file and restarted server, everybody had 0 xp!

then i queried two SQL-queries and converted xp by myself... there is the queries for MySQL, may be they will help you somehow, Senne...

REPLACE INTO `wc3_player` (player_name)
SELECT DISTINCT `playername` as player_name FROM war3users

REPLACE
INTO wc3_player_race (player_id,race_id,race_xp)
SELECT wc3_player.player_id as player_id,
war3users.race as race_id,war3users.xp as race_xp
FROM wc3_player,war3users
WHERE wc3_player.player_name = war3users.playername

if you save xp by playername, do not forget to add UNIQUE index to wc3_player table! I found double names after a day of gaming on new version! double-names will cause instability!

Post by **YamiKaitou** » Sat Apr 14, 2007 7:30 am

3.0 Final will convert. This is 3.0 RC6

Senne · Post by **Senne** » Sat Apr 14, 2007 10:07 am

Owke Thx Altar but im just gonna wait on the final release and the conversion then

Gunny · Post by **Gunny** » Fri Apr 27, 2007 1:57 pm

I need to convert my XP now, what SQL commands will do this???
I am using RC6 Final

NM, I am going to do a database reset.