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

 

[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-warcraft/pspad-txt-editor-tutor-scripters-dream-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]

You must be registered to see links

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^^