table column mass edit

[xmasta]

hi there,
I'm searching a little tool that modifies a whole column of a table in mangos, like multiplying the maxhp column in creatures_template with 2. or 0.5 if i want them weaker. there are just to much creatures to do it manually, so if you know a programm just let me know :)

thx

[MentaL]

[EvilRyu]

hi there,
I'm searching a little tool that modifies a whole column of a table in mangos, like multiplying the maxhp column in creatures_template with 2. or 0.5 if i want them weaker. there are just to much creatures to do it manually, so if you know a programm just let me know :)

thx

You could try this:
http://forum.ragezone.com/world-warc...am-212297.html
Hope it helps.

[xmasta]

i tried it but its not what i was searching. this is mostly for coding so i cannot show the sql file as a table but as text which is the same effect then opening a sql file with notepad :). but thx for this i think i will need it in future for other coding :). you know d2excel (dunno the exact name...)for making mods for diablo2?with it you can edit the whole column with a few clicks very easy, but this is only for excel files.

[aceindy]

SQL Tutorial
UPDATE table SET xp = xp * 2;

Use any mySQL manager to create a query; navicat has my preference

[xmasta]

I am really starting to hate mysql...but it works..thank you aceindy^^