[Tiny-Release] Auto DP PvP Reward

12/18/2015 01:37 [Admin]Ziggy#1
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--
12/18/2015 11:25 SkuulCandy#2
Nice :)
12/18/2015 17:42 Truth1010#3
Quote:
Originally Posted by SkuulCandy View Post
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.