Hi,
History:
today I tried update my mangos database but there was a lot of sql files. I found a python script ut it not works
So I opened the readme file in updates and I understood the meaning of the updates name.
So i made this simple PHP script to make less work with update.
Features:
- Automatically applies updates from every sql file
- If there are any problem for example: "Failed: Table 'mangosd.creature_respawn' doesn't exist." (this error is because the creature spawn database table is not exist in mangosd database). You will see this message ing quotes as status of update.
- Updates that are successfully applied You will see status message "Success" and this sql files are moved into folder: success
- There are some updates like "ALTER TABLE db_version CHANGE COLUMN required_11754_mangos_mangos_string required_11755_01_mangos bit;" these files will be skipped and you need to apply this sql file/files manually. Dont worry these files is moved into TryManually directory.
My mysql server is on my PC so i am not sure it works remotely.
Download: http://www11.zippyshare.com/v/82467475/file.html
How To Use:
VirusTotal: http://www.virustotal.com/file-scan/report.html?id=745fb7a2abe7545025ea83e288a13363c10eeda988e0ce1bdf1a806c4a9044da-1314997413
this works while name of update is correct because it is base on it:
6936_01_mangos_spell_chain.sql
| | | |
| | | |
| | | The table `spell_chain`
| | | will need an update.
| | |
| | Name of affected DB (default recommended name)
| | Can be: characters, mangos, realmd
| |
| Counter show number of sql updates in updates list for provided revision
| and set proper order for sql updates for same revision
|
MaNGOS commit revision related to sql update.
It included in commit description in form [6936] as you can see at http://github.com/mangos/mangos/commits/master