- Joined
- Dec 27, 2004
- Messages
- 108
- Reaction score
- 16
Here's a small php based mass item converter
I've created this for a db migration. In case you want to move on to the latest season II server files but you don't want your players to lose their stuff and "whine all the way".
Its a bit messy, but does the job done. As far as i tested it converts every item perfectly well.. I haven't tested the footer query though..but as far as i know it should work fine..
In order to migrate a database do the following stuff:
p.s. its so messy cuz its ment for a one-time execution and i didn't think i needed to debug it more..delete them after you are finished.
I'm not supporting this..just wrote it for my server and decided to share it
I've created this for a db migration. In case you want to move on to the latest season II server files but you don't want your players to lose their stuff and "whine all the way".
Its a bit messy, but does the job done. As far as i tested it converts every item perfectly well.. I haven't tested the footer query though..but as far as i know it should work fine..
In order to migrate a database do the following stuff:
- Backup your current (season I) database
- Restore the Database backs from your season II files in database MuOnline.
- Create a new database (Mu_Old for example) and restore your season I backup you made.
- Now use the MsSQL enterprise manager to export the data from Character and warehouse tables to The Muonline (season II) database.(ull have to extract memb_info,accountcharacter,vi_curr_info,guild,guildmember and memb_stat) in order to have the full db migrated to s2
- Download these scripts and put them in your http document root (configure the mssql connection settings in them) -> MuItemConverter (PHP Format)
- Now execute them one by one while your server is OFFLINE!!
- If you get any browser errors -> F5!
- If you get any mssql.query errors -> F5 (if still doesn't work report them here)
- If you get an error like "Exceeded the maximum execution time" etc.. open the file you are executing and decrease the $persession variable.
- Done.
p.s. its so messy cuz its ment for a one-time execution and i didn't think i needed to debug it more..delete them after you are finished.
I'm not supporting this..just wrote it for my server and decided to share it
Attachments
You must be registered for see attachments list
Last edited: