[RELEASE]Show in-game DP with Commands

[XareL]

Hi Epvpers,
this script will show the most current DP value of your account with in-game commands.

especially if in the site, do not work DP value and itemmal not working
it will be a useful topic.

First of all you need to install to use this script.
and then
you need to install for the personal notice to be active.

Put inside PS_ChatLog >Programmabilty > dbo.usp_insert_Chat_Log_E

DECLARE @Charname varchar(max), @CharIDNotice varchar(max), @return_value int

SET @Charname = (SELECT Charname FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)

SET @CharNotice = @CharID

SET @return_value ='0'

/* --------- Show in-game DP with Commands ------------*/

DECLARE @Puanbak varchar(max)
SET @Charname = (SELECT Charname FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)
SET @Puanbak = (SELECT top 1 Point FROM PS_UserData.dbo.Users_Master WHERE UserUID=@UserUID)

-- now we select the chat type
-- ChatType : 1 = Normal Chat | 2 = Whisper (!) | 3 = Guild | 4 = Group (@) (/raid) | 5 = Trade | 6 = /yelling | 7 = Area

IF (@Chatdata like '!pointlook' and @ChatType = '1') -- Change This Line for in game commands !pointlook change to whatever you want

/* this query can be improved */
BEGIN

SET @CharID = (SELECT top 1 CharID FROM PS_GameData.dbo.Chars WHERE Charname = @CharName)

DECLARE @PuanbakTR varchar(max) = N'/ntplayer ' + @CharNotice + 'Dear '+''+ + @CharName +' you have '+@Puanbak+ ' DP in your account'

SET @return_value ='0'
EXEC @return_value = PS_GameDefs.[dbo].[Command]
@serviceName = N'ps_game',
@cmmd =@PuanbakTR

END

and then and then type your in-game command to see the current value.

you do not even need to relog it anymore.

Best regards