Soacs v41+ coupon event (oyun içi cash kırdırma + premium servisi)

98001 Gold Premium Exchange
98002 Silver Premium Exchange
6000 Bronze Premium Exchange
6001 Exchange Voucher of 1000 Cash
6002 Exchange Voucher of 700 Cash
6003 Exchange Voucher of 350 Cash 6004 Exchange Voucher of 100 Cash

Genişletmek için tıkla ...

36009 <selfname> İslem Basarili Premium icin relog atiniz.
36011 <selfname> Yeterli Item Bulunmamaktadir. 85002 <selfname> Hosgeldiniz

Genişletmek için tıkla ...

USE [kn_online]
GO
/****** Object: StoredProcedure [dbo].[ADD_PREM_USER] Script Date: 10/16/2015 06:29:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ADD_PREM_USER]
@AccountID varchar(27),
@nType smallint,
@nDays smallint
AS
declare @ID varchar(27)
SELECT @ID = count(strAccountID) FROM PREMIUM_SERVICE where strAccountID = @AccountID
IF @ID = 0
BEGIN
INSERT INTO PREMIUM_SERVICE VALUES (@AccountID,@nType,@nDays,GETDATE());
RETURN
END
BEGIN
DELETE FROM PREMIUM_SERVICE where strAccountID = @AccountID
INSERT INTO PREMIUM_SERVICE VALUES (@AccountID,@nType,@nDays,GETDATE());
RETURN END

Genişletmek için tıkla ...

CREATE PROCEDURE [dbo].[GIVE_Premium]
@day int OUTPUT,
@control int,
@id varchar(21)


AS


if @control in (1,2,3)


if @control = 1
begin
exec ADD_PREM_USER @id,@control,@day
END


if @control = 2
begin
exec ADD_PREM_USER @id,@control,@day
END


if @control = 3
begin
exec ADD_PREM_USER @id,@control,@day
END GO

Genişletmek için tıkla ...