Help with Sql commands

[Julesx]

So i'm reading this correctly. To 5x stats i'd simply type
UPDATE items SET CR=CR*5
And do this command for each stat i'd like to x ?

Don't think i'ma bother with mob scaleing hoping wife will just "think" they are scaled sense equips will balance out things for her and her bots lol.

[c0ncrete]

yes, * is the multiplication operator.
you might consider updating each stat individually, as tabasco suggested, to keep from multiplying negative values:

UPDATE items SET CR=CR*5 WHERE CR > 0;

that would only multiply positive CR values.

additionally, you could run something like this:

UPDATE items SET CR=0 WHERE CR < 0;

to set any negative CR values to 0.

[Julesx]

Yea those commands are working out nicely. Could use a couple more to finish up server. Sql command to jincrease all items drop chance and one to lower respawn on mobs higher than level say 51 to like an hour. Unless theres one to do like raid mobs only to hour respawn. Was thinking Update npcs set with hp >100k but thats whewre i'm lost. lol Tried georges Npc/loot editor but don't see how to do more than 1 item at a time or 1 zone at a time max.