[Help How can i give AP points to players

[-Elliot-]

if anyone know how can i give AP points to an account plz thanks you in advantage

[lilprohacker]

use the stored procedure under [PS_UserData]

[dbo].[usp_Optisp_Charge_ShaiyaPoint]

Execute it and place the "UserName" and "Points" you want to give and click ok

[-Elliot-]

sorry i have another question i read somewhere but i cant find it atm when i buy something from the item mall it said item is no located and that spot how can i fix that issue.

and my other question there are some items i can buy but when i buy it i get DC anyone know about this issue and thanks again

[rafael1mc]

to give ap itens to player...go to PS_userdata and open dbo.Users_Master
and change the number of "Point" its near the end.

[tomek92]

Originally Posted by lilprohacker

use the stored procedure under [PS_UserData]

[dbo].[usp_Optisp_Charge_ShaiyaPoint]

Execute it and place the "UserName" and "Points" you want to give and click ok

Can i get Free APs ??

[jamessimpler]

Originally Posted by tomek92

Can i get Free APs ??

I dont know what u mean by get Free APs... but if u follow this post, it means that if u configure ur P Server Database to include the Procedure.... player who register can get certain amount (set by the admin) of AP free or something.

[cloverchips]

lol how to get it

[sondo81]

hmm take this skript may be it help


USE PS_GameData
DECLARE
@CharName varchar(30),
@UserUID int,
@UserID varchar(18),
@Point int,
@Points int,
@Point2 int

--Change "Char Name" to the name of the Character who you're giving DP to
SET @CharName = 'Gilgamesch'
--Change "PointsToGive" to the amount of DP you want to give to that Character
SET @Point = '50000'

SELECT @UserUID=U.UserUID, @UserID=U.UserID
FROM PS_GameData.dbo.Chars AS C INNER JOIN PS_UserData.dbo.Users_Master AS U
ON C.UserUID = U.UserUID
WHERE C.CharName = @CharName AND C.Del=0;
IF @@ROWCOUNT=0
BEGIN
PRINT 'Character nicht gefunden.';
return;
END
ELSE
BEGIN
SET @Point2=(SELECT Point FROM PS_UserData.dbo.Users_Master WHERE UserUID=@UserUID)
UPDATE PS_UserData.dbo.Users_Master
SET Point=(Point+@Point)
WHERE UserUID=@UserUID
SET @Points=(SELECT Point FROM PS_UserData.dbo.Users_Master WHERE UserUID=@UserUID)
PRINT @CharName + 's Derzeitigen Punkte: ' + convert(varchar(30), @Point2) + '
Der Account - ' + @CharName + ' - hat seine Punkte bekommen.
Verbundener Accountname zum Charakter: "' + @UserID + '"
Aktuelle Punkte des Accounts: ' + convert(varchar(30), @Points)
END


--skript made by SonDo gaming<<<