[Release]Automaticly Staff Reward via command

[SvHe]

Hi Epvp,

Automaticly give staff members Donation points via command ingame :

Create new column Staff in [PS_UserData].[dbo].[Users_Master] :

ALTER TABLE [PS_UserData].[dbo].[Users_Master] 
ADD 	Staff int

Update all the Staff Accounts with the Staff column

UPDATE [PS_UserData].[dbo].[Users_Master]
SET Staff = 1
WHERE UserID = '[GS]A' or 
UserID = '[GMA]B' 
/* and so on */

Put inside PS_ChatLog >Programmabilty > dbo.usp_insert_Chat_Log_E

/* Automaticly points for staff via command */
/* UserUID = ADM Account ID  */
IF (@UserUID = 1 or @UserUID = 2  or @UserUID= 3 and @ChatData ='StaffReward123'
/* can be anything , make a unique string to avoid mistakes*/)
BEGIN 
UPDATE PS_UserData.dbo.Users_Master
Set Point=  Point + 1000  /* add 1000 points */
Where Staff= 1
END

type "StaffReward123" in normal chat and it will give your staff donation points .

UPDATE : StaffPointLog table for history

Create new table at PS_UserData

Create Table StaffPointLog (Description varchar(50),HistoryTime datetime)

Put inside PS_ChatLog >Programmabilty > dbo.usp_insert_Chat_Log_E after 'Where Staff= 1'

Insert Into PS_UserData.dbo.StaffPointLog (Description,HistoryTime) Values ('Added Staff Reward',@ChatTime)

Everytime u type "StaffReward123" it will give u staff Donation Points and u can see the history at PS_UserData.dbo.StaffPointLog

Im new at SQL so dont judge me , i am still learning and i tought it was a usefull script for some servers with a Staff rewarding,

SvHe

[Shànks♠]

Nice release!

[Hep]

Added to collective thread

[Stureplan]

Originally Posted by RedDuty

Nice release!

Just click the 'thanks' button.
-
#Added to Index.