OkMuOnline


HubWarez


NowaHosting


Resultados 1 a 1 de 1
  1. #1
    Membro LuizerA's Avatar

    Data de Ingresso
    Jul 2022
    Posts
    50
    Thanks Thanks Given 
    41
    Thanks Thanks Received 
    296
    Thanked in
    11 Posts
    Mentioned
    0 Post(s)
    País
    Brazil

    Premiar top 1 classes reset semanal com vip/cash

    Código:
    DECLARE @DIAS int
    DECLARE @FREEWCOIN int
    DECLARE @VIPWCOIN int
    DECLARE @MINRESET int
    
    
    SET @DIAS = 7 -- Quantidade de dias vips à adicionar.
    SET @FREEWCOIN = 50 -- Quantidade de Wcoin à adicionar para usuários Free.
    SET @VIPWCOIN = 50 -- Quantidade de Wcoin à adicionar para usuários Vip.
    SET @MINRESET = 200 -- Mínimo de Resets semanais necessário para a premiação funcionar.
    
    
    BEGIN
    
    
    SET NOCOUNT ON
    SET XACT_ABORT ON
    
    
    -- INICIO CLASSE 1 --
    IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (48,49) order by ResetWek desc, ResetCount desc) AND AccountLevel = 1)
    BEGIN
    UPDATE CashShopData set WCoinC=WCoinC + @VIPWCOIN where AccountID = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (48,49) order by ResetWek desc, ResetCount desc)
    UPDATE MEMB_INFO SET AccountExpireDate = AccountExpireDate + @DIAS where memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (48,49) order by ResetWek desc, ResetCount desc)
    END
    
    
    IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (48,49) order by ResetWek desc, ResetCount desc) AND AccountLevel = 0)
    BEGIN
    UPDATE CashShopData set WCoinC=WCoinC + @FREEWCOIN where AccountID = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (48,49) order by ResetWek desc, ResetCount desc)
    UPDATE MEMB_INFO SET AccountLevel = 1, AccountExpireDate = GETDATE()+ @DIAS where memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (48,49) order by ResetWek desc, ResetCount desc)
    END
    -- FIM CLASSE 1 --
    
    
    -- INICIO CLASSE 2 --
    IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (0,1,2) order by ResetWek desc, ResetCount desc) AND AccountLevel = 1)
    BEGIN
    UPDATE CashShopData set WCoinC=WCoinC + @VIPWCOIN where AccountID = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (0,1,2) order by ResetWek desc, ResetCount desc)
    UPDATE MEMB_INFO SET AccountExpireDate = AccountExpireDate + @DIAS where memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (0,1,2) order by ResetWek desc, ResetCount desc)
    END
    
    
    IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (0,1,2) order by ResetWek desc, ResetCount desc) AND AccountLevel = 0)
    BEGIN
    UPDATE CashShopData set WCoinC=WCoinC + @FREEWCOIN where AccountID = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (0,1,2) order by ResetWek desc, ResetCount desc)
    UPDATE MEMB_INFO SET AccountLevel = 1, AccountExpireDate = GETDATE()+ @DIAS where memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (0,1,2) order by ResetWek desc, ResetCount desc)
    END
    -- FIM CLASSE 2 --
    
    
    -- INICIO CLASSE 3 --
    IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (16,17,18) order by ResetWek desc, ResetCount desc) AND AccountLevel = 1)
    BEGIN
    UPDATE CashShopData set WCoinC=WCoinC + @VIPWCOIN where AccountID = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (16,17,18) order by ResetWek desc, ResetCount desc)
    UPDATE MEMB_INFO SET AccountExpireDate = AccountExpireDate + @DIAS where memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (16,17,18) order by ResetWek desc, ResetCount desc)
    END
    
    
    IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (16,17,18) order by ResetWek desc, ResetCount desc) AND AccountLevel = 0)
    BEGIN
    UPDATE CashShopData set WCoinC=WCoinC + @FREEWCOIN where AccountID = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (16,17,18) order by ResetWek desc, ResetCount desc)
    UPDATE MEMB_INFO SET AccountLevel = 1, AccountExpireDate = GETDATE()+ @DIAS where memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (16,17,18) order by ResetWek desc, ResetCount desc)
    END
    -- FIM CLASSE 3 --
    
    
    -- INICIO CLASSE 4 --
    IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (32,33,34) order by ResetWek desc, ResetCount desc) AND AccountLevel = 1)
    BEGIN
    UPDATE CashShopData set WCoinC=WCoinC + @VIPWCOIN where AccountID = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (32,33,34) order by ResetWek desc, ResetCount desc)
    UPDATE MEMB_INFO SET AccountExpireDate = AccountExpireDate + @DIAS where memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (32,33,34) order by ResetWek desc, ResetCount desc)
    END
    
    
    IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (32,33,34) order by ResetWek desc, ResetCount desc) AND AccountLevel = 0)
    BEGIN
    UPDATE CashShopData set WCoinC=WCoinC + @FREEWCOIN where AccountID = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (32,33,34) order by ResetWek desc, ResetCount desc)
    UPDATE MEMB_INFO SET AccountLevel = 1, AccountExpireDate = GETDATE()+ @DIAS where memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (32,33,34) order by ResetWek desc, ResetCount desc)
    END
    -- FIM CLASSE 4 --
    
    
    -- INICIO CLASSE 5 --
    IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (64,65,66) order by ResetWek desc, ResetCount desc) AND AccountLevel = 1)
    BEGIN
    UPDATE CashShopData set WCoinC=WCoinC + @VIPWCOIN where AccountID = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (64,65,66) order by ResetWek desc, ResetCount desc)
    UPDATE MEMB_INFO SET AccountExpireDate = AccountExpireDate + @DIAS where memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (64,65,66) order by ResetWek desc, ResetCount desc)
    END
    
    
    IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (64,65,66) order by ResetWek desc, ResetCount desc) AND AccountLevel = 0)
    BEGIN
    UPDATE CashShopData set WCoinC=WCoinC + @FREEWCOIN where AccountID = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (64,65,66) order by ResetWek desc, ResetCount desc)
    UPDATE MEMB_INFO SET AccountLevel = 1, AccountExpireDate = GETDATE()+ @DIAS where memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (64,65,66) order by ResetWek desc, ResetCount desc)
    END
    -- FIM CLASSE 5 --
    
    
    -- INICIO CLASSE 6 --
    IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (81,82) order by ResetWek desc, ResetCount desc) AND AccountLevel = 1)
    BEGIN
    UPDATE CashShopData set WCoinC=WCoinC + @VIPWCOIN where AccountID = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (81,82) order by ResetWek desc, ResetCount desc)
    UPDATE MEMB_INFO SET AccountExpireDate = AccountExpireDate + @DIAS where memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (81,82) order by ResetWek desc, ResetCount desc)
    END
    
    
    IF EXISTS (SELECT AccountLevel FROM MEMB_INFO WHERE memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (81,82) order by ResetWek desc, ResetCount desc) AND AccountLevel = 0)
    BEGIN
    UPDATE CashShopData set WCoinC=WCoinC + @FREEWCOIN where AccountID = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (81,82) order by ResetWek desc, ResetCount desc)
    UPDATE MEMB_INFO SET AccountLevel = 1, AccountExpireDate = GETDATE()+ @DIAS where memb___id = (select top 1 accountID from character WHERE ResetWek > @MINRESET AND Class IN (81,82) order by ResetWek desc, ResetCount desc)
    END
    -- FIM CLASSE 6 --
    
    
    
    
    
    
    SET NOCOUNT OFF
    SET XACT_ABORT OFF
    
    
    END
    Créditos: LuizerA

  2. The Following User Says Thank You to LuizerA For This Useful Post:


Permissões de Postagem

  • Você não pode iniciar novos tópicos
  • You may not post Resposta(s)
  • Você não pode enviar anexos
  • Você não pode editar suas mensagens
  •