Use MuOnline
declare @AccountID varchar (10)
declare @AccountID2 varchar (10)
declare @AccountID3 varchar (10)
declare @Name varchar(10)
declare @Name2 varchar(10)
declare @Name3 varchar(10)
Select top 1 @AccountID=AccountID,@Name=Name from character order by PkHeroSemanal desc, name desc
Select top 1 @AccountID2=AccountID,@Name2=Name from character where Name<>@Name order by PkHeroSemanal desc, name desc
Select top 1 @AccountID3=AccountID,@Name3=Name from character where Name<>@Name and Name<>@Name2 order by PkHeroSemanal desc, name desc
Update memb_info set cashs=cashs+3 where memb___id=@AccountID
Update memb_info set cashs=cashs+2 where memb___id=@AccountID2
Update memb_info set cashs=cashs+1 where memb___id=@AccountID3
Update character set trofeus_ouro_pk=trofeus_ouro_pk+1 where AccountID=@AccountID
Update character set trofeus_prata_pk=trofeus_prata_pk+1 where AccountID=@AccountID2
Update character set trofeus_bronze_pk=trofeus_bronze_pk+1 where AccountID=@AccountID3
Update character set trofeus_total_pk=trofeus_total_pk+1 where AccountID=@AccountID
Update character set trofeus_total_pk=trofeus_total_pk+1 where AccountID=@AccountID2
Update character set trofeus_total_pk=trofeus_total_pk+1 where AccountID=@AccountID3
Update character set PkHeroSemanal=0