[HELP] GM Reroll

06/28/2014 11:52 white95260#1

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.

06/28/2014 13:14 beetols#2

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

Code:

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.

06/28/2014 17:51 nubness#3

[Only registered and activated users can see links. Click Here To Register...]'s an easier way, which I posted a while back.

07/02/2014 10:50 white95260#4

Thanks nubness.