[Release]Overpower items [SQL]

[holthelper]

actually moogra its inventoryitemid but that only updates one

(going off Valhalla Rev 84 db setup)

[xChibi]

No use this!
UPDATE inventoryequipment SET watk=32767, str=32767, `int`=32767, luk=32767, dex=32767, matk=19*** jump = 23, speed = 40, accuracy = 9*** avoid = 999

It is pwnage!

lul wouldnt this make all equips in the inventoryequipment have these stats rofl

[ZeroSix]

nice Sql script [: haha

[MSDartz]

Thanks everyone for positive comments.

[HelpMePlease]

everytime i execute this sql i get an error it says unsuccessfully loaded.

[xcelinex33]

Edit:

Thanks :)

[MSDartz]

I'm happy, people like it.

[shakar96]

Here is a fixed version:

UPDATE inventoryequipment, inventoryitems
SET `watk`=32767, `str`=32767, `int`=32767, `luk`=32767, `dex`=32767, `matk`=32767
WHERE inventoryitems.characterid = *****
&& inventoryequipment.inventoryitemid = inventoryitems.inventoryitemid 

you forgot some `('s).

[MSDartz]

You don't need them...

It works fine for me.

[giwnet]

when i execute them, it says no database selected error number 1046

[MSDartz]

Did you replace the ***** with your character ID?

[billabonker]

lol nice release

[viydude]

when i execute them, it says no database selected error number 1046

Umm you have to put a ; at the end of the sql.

[cihadpx68]

nice release :)

[Cyberbully]

For the love of jesus

UPDATE inventoryequipment 
SET `watk`=32767, `str`=32767, `int`=32767, `luk`=32767, `dex`=32767, `matk`=32767, 
wdef = 32767, speed = 40, jump = 23
 where inventoryitemid in (select inventoryitemid from inventoryitems 
where characterid in (select id from characters where name = 'NAME'))

I WIN.

and there is a way of doing this in game you know.