[Tiny-Release] Auto DP PvP Reward

[[Admin]Ziggy]

Hello!

I would like to release Auto DP PvP Rewards.

USE [PS_GameData]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[Kill_REWARDS]
ON [PS_GameData].[dbo].[Chars]
AFTER UPDATE
AS
--DP KILL REWARDS SYSTEM BY [Admin]Ziggy--
IF (UPDATE (K1))
BEGIN
DECLARE @OldK1 INT = (SELECT K1 FROM deleted)
DECLARE @NewK1 INT = (SELECT K1 FROM inserted)
DECLARE @CharID INT = (SELECT CharID FROM inserted)
DECLARE @NewUserUID INT = (SELECT UserUID FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)

UPDATE
PS_UserData.dbo.Users_Master
SET Point = Point + CASE
WHEN @OLDK1 < 1000 AND @NEWK1 >= 1000 THEN 1000
WHEN @OLDK1 < 2000 AND @NEWK1 >= 2000 THEN 1000
WHEN @OLDK1 < 5000 AND @NEWK1 >= 5000 THEN 1000
WHEN @OLDK1 < 10000 AND @NEWK1 >= 10000 THEN 1000
WHEN @OLDK1 < 15000 AND @NEWK1 >= 15000 THEN 1000
WHEN @OLDK1 < 30000 AND @NEWK1 >= 30000 THEN 1000
WHEN @OLDK1 < 50000 AND @NEWK1 >= 50000 THEN 1000
WHEN @OLDK1 < 75000 AND @NEWK1 >= 75000 THEN 1000
WHEN @OLDK1 < 100000 AND @NEWK1 >= 100000 THEN 1000
WHEN @OLDK1 < 120000 AND @NEWK1 >= 120000 THEN 1000
ELSE Point
END
WHERE UserUID = @NewUserUID
END



--THE FIRST 2 NUMBERS ARE THE KILL RANGE THE LAST NUMBER IS THE DP REWARDS EDIT HOW YOU LIKE THEM--
--THE FIRST 2 NUMBERS OF EACH LINE HAS TO BE THE SAME IF YOU CHANGE 1 YOU HAVE TO CHANGE THE OTHER--
--YOU CAN ALSO ADD MORE SETTINGS BY COPY AND PASTE THE SAME CODE INTO THE SCRIPT AND CHANGING THE INFO--
--CASE STATMENTS ARE THE BEST AND FASTEST WAY TO USE VARIOUS OUTCOMES WITHOUT SLOWING DOWN YOUR DATABASE--

[SkuulCandy]

Nice

[Truth1010]

Originally Posted by SkuulCandy

Nice

You really don't need to post "nice" to every thread made with anything released you know. If you think it's nice, just click the thank button. It's just spam.