AP Coin

02/07/2012 08:17 Foxyz#16
ok well it didnt work lol :/
02/07/2012 08:35 RebeccaBlack#17
I tested it before I sent it, and it worked fine. Did you paste the query into a new query window and run it? Did you check the USERS_MASTER table to verify the points were added? or did you just look at the in game mall? Since it takes between a few seconds to a minute for it to show up in game.
11/13/2013 10:18 nukri11#18
?????????? level up coin ???????????

IF( @ActionType = 114 )
BEGIN
IF( @Value2 = 100001 )
BEGIN
UPDATE PS_GameData.dbo.Chars
SET Level = Level + ( 70 * @Value4 )
WHERE useruid = @UserUID
END

IF( @Value2 = 100002 )
BEGIN
UPDATE PS_GameData.dbo.Chars
SET Level = Level + ( 70 * @Value4 )
WHERE useruid = @UserUID
END
END
11/13/2013 11:55 sominus#19
Quote:
Originally Posted by nukri11 View Post
?????????? level up coin ???????????

IF( @ActionType = 114 )
BEGIN
IF( @Value2 = 100001 )
BEGIN
UPDATE PS_GameData.dbo.Chars
SET Level = Level + ( 70 * @Value4 )
WHERE useruid = @UserUID
END

IF( @Value2 = 100002 )
BEGIN
UPDATE PS_GameData.dbo.Chars
SET Level = Level + ( 70 * @Value4 )
WHERE useruid = @UserUID
END
END
Don't do that, you would be making every toon on that account "current level + (70 * X)"
Use [Only registered and activated users can see links. Click Here To Register...] posted by nubness if you want a lvl up item. (read 'how it works' first).
11/13/2013 12:20 nubness#20
Quote:
Originally Posted by sominus View Post
Don't do that, you would be making every toon on that account "current level + (70 * X)"
Use [Only registered and activated users can see links. Click Here To Register...] posted by nubness if you want a lvl up item. (read 'how it works' first).
If he does that nothing will change, because the account is logged in.

Sometimes I really hate myself and the other people who released stuff, these dumbos will never learn anything like that.