declare @AccountID varchar (10)
declare @Name varchar(10)
declare @ResetsDay int
Select top 1 @AccountID=AccountID,@Name=Name,@ResetsDay=ResetsD ay from character order by ResetsDay desc, name desc
Update memb_info set Gold=Gold+15 where memb___id=@AccountID
Select top 1 @AccountID=AccountID,@Name=Name,@ResetsDay=ResetsD ay from character order by ResetsDay desc, name desc
Update character set post = post + 15, ResetsDay=0 where Name=@Name