Move database updates into MaNGOS.

[Guest]

Hello! I was just thinking about it, and the current SQL update system we have right now is flawless, except that it it bothering to install new SQL updates as they roll out.

So i was thinking, why can't those be integrated into mangos sourcecode and executed just as they are now, but on mangos startup instead?.

I think i could make a "bad but working" solution on this.

This could evolve into WIP if someone is interested!

- Carl

[void513]

maybe it be a module like a seperate program or script say if in a certain dir under mangos mangos load theses script and excute then a scipt to load db update be excxuted like a addon.also leave open for other possiblityif server load addons

[shlainn]

This should not be hard. I will not write the script for you, though

Here are the ingredients you need:

SHOW COLUMNS FROM db_version LIKE 'required%';

This code gives you one row like

+-----------------------------------------------+--------+------+-----+---------+-------+
| Field                                         | Type   | Null | Key | Default | Extra |
+-----------------------------------------------+--------+------+-----+---------+-------+
| required_s1718_12113_01_mangos_spell_template | bit(1) | YES  |     | NULL    |       |
+-----------------------------------------------+--------+------+-----+---------+-------+

The "Field" column is the last update applied (without the "required_".

Now, create a list of *.sql in the update directory, sort it, and then run through the list comparing against your SQL result. Once found, apply all following updates.

Actually UDB405 has a script that does just that...

[lillecarl]

Well i was thinking about merging sql updates into mangosd/realmd