[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.