Süreli Ban/Mute Sistemi

ANLATIM

Manuel olarak bireysel ban/mute aynı şekilde 0 değeriyle oynarsanız banladıgınız veya mutelediğiniz kişi otomatikmen vereceğiniz değere mutakib kalır.

update userdata set Muteday = '0' where struserid = 'Nick'
update userdata set Banday = '0' where struserid = 'Nick'

Hazır hali ; aşağıdaki 0 değeriyle oynarsanız her banladıgınız kişi otomatikmen vereceğiniz değere mutakib kalır.

UPDATE USERDATA SET Muteday=0
UPDATE USERDATA SET BanDay=0

(0,olan kısmı istediğiniz numarayı verirseniz o kadar gün müteli kalır.)

Kod:

EXEC SURELI_BAN @AccountID
EXEC SURELI_MUTE @strUserID

Yukaridaki iki kodu load_user_data ekleyiniz.

Kod:

ALTER TABLE USERDATA

Kod:

ADD MuteDate datetime NULL GO ALTER TABLE USERDATAADD MuteDay smallint NULL DEFAULT(0)GO  

UPDATE USERDATA SET MuteDay=0

Kod:

ALTER TABLE USERDATA 

Kod:

  ADD BanDate datetime NULL  GO   ALTER TABLE USERDATA  ADD BanDay smallint NULL DEFAULT(0)GO  

UPDATE USERDATA SET BanDay=0

Kod:

USE [Kn_online] 
GO 
/****** Object:  StoredProcedure [dbo].[SURELI_BAN]    KO-CUCE XPECTED 2012/ 
SET ANSI_NULLS OFF 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
-- Yapan: AKI 
-- 2011.01.20 
-- www.pvpke.com 
  
CREATE PROCEDURE [dbo].[SURELI_BAN] 
@AccountID    varchar(21) 
AS 
  
DECLARE @BanDayFinish datetime, @TIME datetime, @Day smallint 
DECLARE @BanDay smallint, @Authority tinyint  
DECLARE @UserID1 char(21), @UserID2 char(21), @UserID3 char(21) 
  
SET @UserID1=(SELECT strCharID1 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID AND strCharID1 is not null) 
SET @UserID2=(SELECT strCharID2 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID AND strCharID2 is not null) 
SET @UserID3=(SELECT strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID AND strCharID3 is not null) 
SELECT @Authority=Authority, @BanDay = BanDay, @BanDayFinish = BanDate FROM USERDATA Where strUserId=@UserID1 
SELECT @Authority=Authority, @BanDay = BanDay, @BanDayFinish = BanDate FROM USERDATA Where strUserId=@UserID2 
SELECT @Authority=Authority, @BanDay = BanDay, @BanDayFinish = BanDate FROM USERDATA Where strUserId=@UserID3 
   IF @Authority=255 and @BanDay >0 and @BanDay <31 
   BEGIN 
SET @TIME = getdate() 
SET @Day = datediff( DAY, @TIME,@BanDayFinish) 
       IF @Day < 30 
       BEGIN 
           UPDATE USERDATA SET BanDay=@Day WHERE Authority =255 and  strUserId=@UserID1 or  Authority =255 and strUserId=@UserID2 or   Authority =255 and strUserId=@UserID3 
       END 
   END 
ELSE 
   IF @BanDay =0 AND @Authority=255 
   BEGIN 
       UPDATE USERDATA SET BanDate=getdate()+29, BanDay=30 WHERE  Authority =255 and strUserId=@UserID1 or  Authority =255 and  strUserId=@UserID2 or  Authority =255 and strUserId=@UserID3 
   END 
ELSE  
    IF @BanDayFinish < GETDATE() 
    BEGIN 
       UPDATE USERDATA SET BanDay=0,Authority=1, BanDate = null  WHERE  Authority =255 and strUserId=@UserID1 or  Authority =255 and  strUserId=@UserID2 or  Authority =255 and strUserId=@UserID3 
END 
  
Update USERDATA set BanDate = GETDATE()+29 , BanDay =30 where Authority=255 and BanDate is null 
update USERDATA set Authority=1, BanDay=0,BanDate=null where BanDate<GETDATE() and Authority=255  

Kod:

USE [kn_online]

Kod:

GO/****** Object:  StoredProcedure [dbo].[SURELI_MUTE]    KO-CUCE XPECTED 2012/SET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER ONGO-- Yapan: AKI-- 2011.01.20-- www.pvpke.comCREATE PROCEDURE [dbo].[SURELI_MUTE]@strUserID varchar(21)ASdeclare @MuteDayFinish datetime, @TIME datetime, @Day smallintdeclare @MuteDay smallint, @Authority tinyint SELECT @Authority=Authority, @MuteDay = MuteDay, @MuteDayFinish = MuteDate FROM USERDATA WHERE strUserId = @strUserID IF @Authority=11 and @MuteDay >0 and @MuteDay <8 BEGINSET @TIME = getdate()SET @Day = datediff( DAY, @TIME,@MuteDayFinish)  IF @Day < 7  BEGIN  UPDATE USERDATA SET MuteDay=@Day  WHERE strUserId = @strUserID  END ENDELSE IF @MuteDay =0 AND @Authority=11 BEGIN UPDATE USERDATA SET MuteDate=getdate()+7, MuteDay=7 WHERE strUserId = @strUserID ENDELSE   IF @MuteDayFinish < GETDATE()  BEGIN UPDATE USERDATA SET MuteDay=0,Authority=1, MuteDate = null  WHERE strUserId = @strUserIDENDUpdate USERDATA set MuteDate = GETDATE()+7 , MuteDay =7 where Authority=11 and MuteDate is null 

update USERDATA set Authority=1, MuteDay=0,MuteDate=null where MuteDate<GETDATE() and Authority=11