[Help] Sql Question

[ucigashu]

can someone give me a sql code that makes x2 what ever i want ?
lets say i want all items in game to have x2 stamina
or x5 strenght

Dose a sql code like that exist ?


Help plzz.....

[b!atch]

I think it would be something like

UPDATE items SET stat_value2 = 5

Now, idk what stattype strength/stamina etc is But find out what the type means and change the 2 at value2 to the type's number

try

UPDATE `items` SET `stat_value2`='5'

if the one above doesnt work

[TheSpidey]

If you want all items to have twice the stats, just do
UPDATE items SET stat_value1 = stat_value1*2, stat_value2 = stat_value2*2, ... ;