-
Job para Rankings.
Galera algum pode me da uma ajudinho e adapita essa JOB para MuSite e MuShop Daldegam?
Eu so meio novato nessa área e me atrapalho um pouco...
Eu precisava dela pra Premiar Semanal e Mensal...
Segue JOB que eu achei aqui mesmo no fórum:
Código:
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 Semanal desc, name desc
Select top 1 @AccountID2=AccountID,@Name2=Name from character where Name<>@Name order by Semanal desc, name desc
Select top 1 @AccountID3=AccountID,@Name3=Name from character where Name<>@Name and Name<>@Name2 order by Semanal desc, name desc
Update memb_info set gold=gold+30 where memb___id=@AccountID
Update memb_info set gold=gold+20 where memb___id=@AccountID2
Update memb_info set gold=gold+20 where memb___id=@AccountID3
Update character set Semanal=0
vlw galera!
-
Semanal
Código PHP:
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 ResetsWeek desc, name desc
Select top 1 @AccountID2=AccountID,@Name2=Name from character where Name<>@Name order by ResetsWeek desc, name desc
Select top 1 @AccountID3=AccountID,@Name3=Name from character where Name<>@Name and Name<>@Name2 order by ResetsWeek desc, name desc
Update memb_info set gold=gold+30 where memb___id=@AccountID
Update memb_info set gold=gold+20 where memb___id=@AccountID2
Update memb_info set gold=gold+20 where memb___id=@AccountID3
Update character set ResetsWeek=0
Mensal
Código PHP:
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 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 memb_info set gold=gold+30 where memb___id=@AccountID
Update memb_info set gold=gold+20 where memb___id=@AccountID2
Update memb_info set gold=gold+20 where memb___id=@AccountID3
Update character set ResetsMonth=0
Só mudar o nome das colunas.
