MySQL to vault

kp_downarrow · Post by **kp_downarrow** » Fri Feb 16, 2007 3:08 pm

any way to get mysql data xp to nvault?

Post by **YamiKaitou** » Fri Feb 16, 2007 3:53 pm

I will give you a little preview of the next RC. nVault support will be removed

kp_downarrow · Post by **kp_downarrow** » Fri Feb 16, 2007 4:11 pm

so what will it be

Post by **YamiKaitou** » Fri Feb 16, 2007 4:14 pm

MySQL and SQLite(default) will be the only methods of saving

kp_downarrow · Post by **kp_downarrow** » Fri Feb 16, 2007 4:16 pm

is SQLITE something i need to install on the remote server?

Post by **YamiKaitou** » Fri Feb 16, 2007 4:20 pm

No. It creates the database in your game mod folder. It is set up like MySQL, but the server host is localhost.

kevlartester · Post by **kevlartester** » Fri Feb 16, 2007 5:15 pm

well i never worked with MySQL or SQLite and saved to nVault all the time...
will there be a possibility to "copy"/"transform" the XP from a nVault to an SQLite Database? or am i forced to reset all XP when i want to use RC6 ?

kp_downarrow · Post by **kp_downarrow** » Fri Feb 16, 2007 5:24 pm

sence he didnt say, its probably a NO

Post by **YamiKaitou** » Fri Feb 16, 2007 5:27 pm

Maybe I am not supposed to be saying this, but I will anyways.

1) RC6 will be a different MySQL database structure than pre-RC6.
2) To my knowledge, there is no method of converting nVault to MySQL/SQLite
3) Geesu may convert the old MySQL structure into the new one.
4) I have no knowledge of any attempt on Geesu's part to convert nVault to SQLite/MySQL

Also, can't you give me some time to reply?

kp_downarrow · Post by **kp_downarrow** » Fri Feb 16, 2007 5:40 pm

um... sorry if i didnt give time

so.. when you upgrade to RC6 the XP must reset also Awwww..........

anders_dog · Post by **anders_dog** » Fri Feb 16, 2007 6:09 pm

If there's sufficient interest I'm happy to code something that will convert player info and races from vault to the new mysql tables. If someone who is familiar with sqlite wants they can modify that for their system.

In the beta forums I've posted some SQL queries which migrate most data from the old mysql db design to the new one. The only thing that's missing is to migrate skills, and tbh, I cbf doing that r.n. Besides, players get all their XP back and just reassign their skills. Big deal.