Ap points

01/18/2013 02:12 liston28727#1

Set up my test server everything else seems to be working correctly. I went into my ps_users Master db and added ap points. after restarting my server and logging on i opened the in-game item mall and no points appear.. I tried the gm command /set [char name] points or point "tried both" amount with no results.. Would appreciate any help with this...

01/18/2013 06:36 WildTaurus#2

/set [charname] point will not work

try:

Code:

USE PS_UserData;
UPDATE Users_Master
SET Point = (Point + 5000)
WHERE UserID = 'UserID'

or for all accounts:

Code:

USE PS_UserData;
UPDATE Users_Master
SET Point = (Point + 5000)
WHERE Status = '0'

01/19/2013 01:23 liston28727#3

Interesting development. Was using the original user that was there "admin". Created another account and added points in the DB. Started the server and logged into the new account and the points were there to use. But still the GM command /set points still fails to work.

01/19/2013 01:28 [ADM]Prophecy�#4

To avoid these problems, using the administration panel from dash :)not hard to use the search button and download the files