Xp convertion

Senne · Post by **Senne** » Sat May 26, 2007 12:44 pm

Hi, i really really want to update my server from RC5.0 to RC6.0 or RC7.0 , but then my players loose all there xp ; any chance on an official script release to convert the tables?

plzzzzz

Post by **Geesu** » Sun May 27, 2007 10:39 am

Why do they lose their XP? Did I state that they would?

Senne · Post by **Senne** » Sun May 27, 2007 1:06 pm

from rc 5.0 to rc 6.0 , its a other other table structure in mysql.
i updated it to rc 6.0 , but then it creates new tables with no users info..so i i reinstalled rc 5.0 so my players would have there xp.

Coksnuss · Post by **Coksnuss** » Mon May 28, 2007 3:21 am

Could you give me the both structures? I would try to give u a script wich converts the old to the new structur...

Manix · Post by **Manix** » Mon May 28, 2007 7:39 am

Here is the RC5 and RC6 structures for you

Post by **Geesu** » Mon May 28, 2007 10:17 am

Looks like you just need to rename the first 3 players - that would fix it...

Senne · Post by **Senne** » Mon May 28, 2007 12:59 pm

Can someone explain it in detail, bec i have no experience in mysql beside looking things up in it and changing values.
thx for the help and responses so far tho

Post by **Geesu** » Mon May 28, 2007 4:17 pm

Do you have access to phpmyadmin?

Senne · Post by **Senne** » Tue May 29, 2007 10:48 am

yep thats what i always use to go tru tables to alter ppls xp

Senne · Post by **Senne** » Fri Jun 01, 2007 10:02 am

anyone 5 minutes to help me out

Coksnuss · Post by **Coksnuss** » Fri Jun 01, 2007 3:20 pm

I am currently on my Notebook (without HDD) and using a linux live CD (with no .zip support) so just wait for tommorow, ill look into it...

Senne · Post by **Senne** » Sat Jun 02, 2007 1:05 pm

Coksnuss wrote:I am currently on my Notebook (without HDD) and using a linux live CD (with no .zip support) so just wait for tommorow, ill look into it...

thx

Coksnuss · Post by **Coksnuss** » Sun Jun 03, 2007 8:01 am

Well ok 2nd day now...
Anyways... all i can see is that the table names are different...so try this: (After a !!!BACKUP!!!)

Code: Select all

ALTER TABLE wc3players RENAME AS wc3_player;
ALTER TABLE wc3_skills RENAME AS wc3_player_skill;
ALTER TABLE wc3_race RENAME AS wc3_player_race;
DROP TABLE wc3_web_skills;
DROP TABLE wc3_web_races;

I guess it should work but this would be TOO easy^^...
Anyways, try it...

Senne · Post by **Senne** » Mon Jun 04, 2007 12:36 pm

thx ill try it out this weekend when i have lots of time to test it

Senne · Post by **Senne** » Tue Jun 05, 2007 10:08 am

i tried it out , i copied the war3users to a diffrent database i have , just to be sure :

this error i received :
SQL-query:

ALTER TABLE wc3players RENAME AS wc3_player;

MySQL retourneerde: Documentatie
#1146 - Table 'senne_amxxft.wc3players' doesn't exist

i think you have the wrong table names :
rc5.0 :
table war3users :
playerid
playerip
playername
xp
race
skill1
skill2
skill3
skill4
time

manix gave you the wrong structures

Coksnuss · Post by **Coksnuss** » Tue Jun 05, 2007 11:36 pm

Damn, hell he didnt i guess... But you said you are using RC5... As i can see you are using 2.3.2, right?!

Senne · Post by **Senne** » Wed Jun 06, 2007 11:19 am

Coksnuss wrote:Damn, hell he didnt i guess... But you said you are using RC5... As i can see you are using 2.3.2, right?!

nope im using version 3.0 RC5 ; if you want ill even make a screenshot of it

its in RC6.0 they changed the mysql coding, i didnt knew even they changed it again in RC7.0

Post by **YamiKaitou** » Wed Jun 06, 2007 11:26 am

RC6 uses a new database format. There will be an xp conversion installed in the mod. It might already be in RC7, not sure though. But, I am 100% certain that it will be in Final, Geesu said so.

Maybe, just maybe, if I have time and feel like it, I might ask for a copy of your table so I can convert it. But, that is just a maybe

DesasterUK · Post by **DesasterUK** » Wed Jun 06, 2007 11:36 am

I'm not sure, but didn't rc6 convert the old db structure from rc5 to the new one?

Just try RC6 to convert the db and after that update to RC7.

I'm sure one of the betas can convert it by itself (one of the RC6 ones).

Senne · Post by **Senne** » Wed Jun 06, 2007 3:37 pm

Nope , i updated to rc6 and it started from 0 xp again.
I then submitted a thread here , about the mysql change and they told me to wait

Post by **YamiKaitou** » Wed Jun 06, 2007 3:43 pm

Geesu never started working on the conversion until RC7. I am not sure if it is finished yet. Try upgrading straight to RC7, see if it does convert it.

Senne · Post by **Senne** » Wed Jun 06, 2007 4:08 pm

ill try it tomorrow its getting late , and have to go to work tomorrow bah

Post by **YamiKaitou** » Thu Jun 07, 2007 9:13 pm

If upgradng to RC7 doesn't work, then go ahead and send me a copy of your database so I can attempt to translate it

Senne · Post by **Senne** » Fri Jun 08, 2007 1:01 pm

YamiKaitou wrote:If upgradng to RC7 doesn't work, then go ahead and send me a copy of your database so I can attempt to translate it

Can i just use thee same database connection details as the previous one?
will the new one delete the old one or just make new tables? (yea ii backup always

)

EDIT : did the update to the same database , xp reseted and new tables were created.
mysql database is in the attachment , altho if you could write me the lines to make it convert ?
Or if you guys are gonna keep the same mysql setup as now, you might wanne consider making an convertion tool/guide? if not to much trouble

Post by **YamiKaitou** » Fri Jun 08, 2007 3:03 pm

The xp will convert auto in 3.0 Final. When I translate yours, it will be using the new database setup. Everything else will stay the same, same host, user, pass, and database. The only thing that will change will be the table names

Senne · Post by **Senne** » Sat Jun 09, 2007 6:39 am

YamiKaitou wrote:The xp will convert auto in 3.0 Final. When I translate yours, it will be using the new database setup. Everything else will stay the same, same host, user, pass, and database. The only thing that will change will be the table names

If 3.0 Final is not that far away , i would wait bec i dont wanne cause to much trouble for you.