[HELP] GM Reroll

[white95260]

Hey, some people need GM stats, it's okay, I do, but the only problem I GM stat through database and take much times. I'm in EP4.5, if someone can help me, could be usefull.

[beetols]

You can create a simple query using a basic UPDATE form for insert their new stats in that certain item.. for example:

USE PS_GameData
UPDATE CharItems
SET Craftname =  '010203040506070809' + SUBSTRING (Craftname, 19, 20)
WHERE CharID = 'CharID' AND ItemUID = 'itemuid'

Naturally u must create another query for find the itemUID from the item, but i'm sure u can do it alone!

then idk if other have a better query but this would work.

[nubness]

's an easier way, which I posted a while back.

[white95260]

Thanks nubness.