playboy Dom Abr 01, 2012 3:42 pmdeclare @AccountID varchar (10)
declare @Name varchar(10)
declare @resetsday int
declare @memb___id varchar (10)
Select top 1 @AccountID=AccountID,@Name=Name,@ResetsDay =ResetsDay from character order by ResetsDay desc, name desc
Update memb_info set gold=gold+@ResetsDay where memb___id=@AccountID
Select @memb___id=memb___id from memb_info where memb___id =@AccountID
update character set ResetsDay = 0 where AccountID=@memb___id
Coloque A Job para Rodar De 1 á 1 Minuto.
declare @Name varchar(10)
declare @resetsday int
declare @memb___id varchar (10)
Select top 1 @AccountID=AccountID,@Name=Name,@ResetsDay =ResetsDay from character order by ResetsDay desc, name desc
Update memb_info set gold=gold+@ResetsDay where memb___id=@AccountID
Select @memb___id=memb___id from memb_info where memb___id =@AccountID
update character set ResetsDay = 0 where AccountID=@memb___id
Coloque A Job para Rodar De 1 á 1 Minuto.
» MuServer 1.02n+S2 + Tutorial + Client Full
» Muaway2013
» Mu Server Enc 2.0.7 premium. Crackd + Sala vip + Sala No pvp + Sala pvp!
» MUSERVER 97D + ITENS DO MUAWAY E DBZ
» MuServer Season6 Episodio 3
» skycheats_Senha_Perdida
» [MuServer]97d+99i+Season 4,5 e 6 Items
» MuServer 97D+Customs+Novos Itens