Citação:
declare @AccountID varchar (10)
declare @AccountID2 varchar (10)
declare @AccountID3 varchar (10)
declare @Name varchar(10)
declare @Name2 varchar(10)
declare @Name3 varchar(10)
declare @resetsMonth int
Select top 1 @AccountID=AccountID,@Name=Name,@resetsMonth=reset sMonth from character order by resetsMonth desc, name desc
Select top 1 @AccountID2=AccountID,@Name2=Name from character where Name<>@Name order by resetsMonth desc, name desc
Select top 1 @AccountID3=AccountID,@Name3=Name from character where Name<>@Name and Name<>@Name2 order by resetsMonth desc, name desc
Update CashShopData set WCoinP=WCoinP+10 where login=@AccountID
Update CashShopData set WCoinP=WCoinP+7 where login=@AccountID2
Update CashShopData set WCoinP=WCoinP+5 where login=@AccountID3
UPDATE Character SET resetsMonth = 0
