UPDATE_PREMIUM_SERVICE_USER

Knight Online private server tutorials/guides, new releases, and discussion
Post Reply
User avatar
DeadPoetic
Posts: 57
Joined: Fri Aug 17, 2018 3:45 am

Sat Aug 18, 2018 10:51 pm

ALTER PROCEDURE [dbo].[UPDATE_PREMIUM_SERVICE_USER]
@AccountID varchar(27),
@Days smallint
AS
SET NOCOUNT ON;
if @Days = 0
BEGIN
--UPDATE PREMIUM_SERVICE SET nDays = @Days WHERE strAccountID = @AccountID
DELETE FROM PREMIUM_SERVICE where strAccountID = @AccountID
END
Image
Post Reply