Page 1 of 1
UPDATED TO RC6.0
Posted: Wed Apr 11, 2007 2:21 pm
by Senne
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:
Posted: Wed Apr 11, 2007 2:32 pm
by Geesu
3.0 Final will auto-convert old XP
Posted: Wed Apr 11, 2007 2:50 pm
by Senne
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...
Posted: Sat Apr 14, 2007 2:38 am
by AlataR
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!
Posted: Sat Apr 14, 2007 7:30 am
by YamiKaitou
3.0 Final will convert. This is 3.0 RC6
Posted: Sat Apr 14, 2007 10:07 am
by Senne
Owke Thx Altar but im just gonna wait on the final release and the conversion then
Posted: Fri Apr 27, 2007 1:57 pm
by Gunny
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.