BarJuice
Zyloria Owner
I'm not sure if this is in the right spot, and this is also my first tutorial.
I ran my old server using .xml for my accounts and players and wanted to update and move to The forgotten server using .sql for all that. I downloaded wrzasq's xml2sql converter and it took me a while to learn how to work it. So I'm going to try to explain how this worked for me the best i can, and hope that everyone else can do the same.
Before you start working, make sure to download xml2sql. heres the link http://sourceforge.net/project/showfiles.php?group_id=32523&package_id=202862
1.) you should already know how to set up an sql database, if not then search for a sql tutorial.
2.) go into phpmyadmin and import the database.sql file you want. It will be in your servers folder with config.lua. Mine was called forgottenserver.sql
3.) put the xml2sql.exe in the server folder you want to convert. (IE: "C:\Documents and Settings\Michael\Desktop\Tibia\ALLOTS\Zyloria Server" thats where mine went.)
4.) make a batch file to start it, or else it wont make the .sql file you need.
To do this open up wordpad.
type in the following: xml2sql.exe > xml2sql.sql
save it as xml2sql.bat
5.) use your batch file and you will see the program doing its thing. When it is finished you will have a xml2sql.sql file.
6.) go back into your phpmyadmin and import your xml2sql.sql file into your database you made earlier (remember my forgottenserver.sql i had to make? )
7.) It will take a while to import all the information, but it will go thru eventually.
Not all items will convert, and i dont think houses will either... BUT I'm sure people would much rather have their players back at least, ESPECIALLY in my current situation..
Moral of the story....
Never use xml, sql is so much better
Dont flame me too bad, ive never been a good teacher, but i hope someone can learn something from this.
I ran my old server using .xml for my accounts and players and wanted to update and move to The forgotten server using .sql for all that. I downloaded wrzasq's xml2sql converter and it took me a while to learn how to work it. So I'm going to try to explain how this worked for me the best i can, and hope that everyone else can do the same.
Before you start working, make sure to download xml2sql. heres the link http://sourceforge.net/project/showfiles.php?group_id=32523&package_id=202862
1.) you should already know how to set up an sql database, if not then search for a sql tutorial.
2.) go into phpmyadmin and import the database.sql file you want. It will be in your servers folder with config.lua. Mine was called forgottenserver.sql
3.) put the xml2sql.exe in the server folder you want to convert. (IE: "C:\Documents and Settings\Michael\Desktop\Tibia\ALLOTS\Zyloria Server" thats where mine went.)
4.) make a batch file to start it, or else it wont make the .sql file you need.
To do this open up wordpad.
type in the following: xml2sql.exe > xml2sql.sql
save it as xml2sql.bat
5.) use your batch file and you will see the program doing its thing. When it is finished you will have a xml2sql.sql file.
6.) go back into your phpmyadmin and import your xml2sql.sql file into your database you made earlier (remember my forgottenserver.sql i had to make? )
7.) It will take a while to import all the information, but it will go thru eventually.
Not all items will convert, and i dont think houses will either... BUT I'm sure people would much rather have their players back at least, ESPECIALLY in my current situation..
Moral of the story....
Never use xml, sql is so much better
Dont flame me too bad, ive never been a good teacher, but i hope someone can learn something from this.
Attachments
-
xml2sql.rar1,022.2 KB · Views: 72 · VirusTotal
Last edited: