LF some HELP!

[kimmern]

Does anybody know what i should type in a .sql file to make every single item on wow scale to about 2000% of normal stats? i am trying to run a lvl 100 Custom Funserver, but i cant seem to find anyone that knows how to make that type of SQL file, we need every single item in the DB scaled with 2000% of normal stats. would highly apreciate it if anyone could answer this as soon as possible!

~Anarchy

[stoneharry]

UPDATE items SET statvalue1 = statvalue1 * 200;

Or similar. Do this for each stat column. Same with item level. Ta' da.

Formulas will not work well past level 80.

[kimmern]

UPDATE items SET statvalue1 = statvalue1 * 200;

Or similar. Do this for each stat column. Same with item level. Ta' da.

Formulas will not work well past level 80.

uhm, i'm sorry i don't completely understand, do i just make copy paste it in notepad and save it as a SQL?

edit: also whats the one for the lvl of the item?

[kimmern]

and what do i use to mod the weapon dmg too ?
UPDATE item_template SET dmg_min1 = dmg_min1 * 200
UPDATE item_template SET dmg_max1 = dmg_max1 *200 ?

edit:
How do i make a SQL that ONLY edits haste/resilience/spellpower/attack power rating and nothing else? i need every item in-game to have 200-500 haste. i have 2 custom donor things that gives haste so.