[Duvida] Me Ajudem com o Mu Site 2.5

[Hugo_Ts]

Boa Noite Galera estou com 1 erro nos rankings do mu site 2.5 n to conseguindo configurar ele para pegar os rankings resets / mrs / pk / guilds mas o resto funciona poderiam me ajudar oq fazer ou passar um tutorial para configurar ele para 97D vlw !

 

[ortelino]

entra em contato cmg que ti ajudo 

 

[supremooffcial]

TRUNCATE TABLE dbo.webRankingCharactersResets
INSERT INTO webRankingCharactersResets (account,character,clevel,pkcount,resets,mresets,resetsweek,resetsmonth,class)
Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,resetsWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by resets desc




TRUNCATE TABLE dbo.webRankingCharactersResetsMonth
INSERT INTO webRankingCharactersResetsMonth (account,character,clevel,pkcount,resets,mresets,resetsweek,resetsmonth,class)
Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,resetsWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by resetsMonth desc, resets desc


TRUNCATE TABLE dbo.webRankingCharactersPk
INSERT INTO webRankingCharactersPk (account,character,clevel,pkcount,resets,mresets,resetsweek,resetsmonth,class)
Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,resetsWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by PkCountWeb desc, resets desc



TRUNCATE TABLE dbo.webRankingCharactersMasterReset
INSERT INTO webRankingCharactersMasterReset(account,character,clevel,pkcount,resets,mresets,resetsweek,resetsmonth,class)
Select TOP 200 AccountID,Name,cLevel,PkCountweb,resets,mresets,resetsWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by Mresets desc, resets desc


TRUNCATE TABLE dbo.webRankingCharactersLevel
INSERT INTO webRankingCharactersLevel (account,character,clevel,pkcount,resets,mresets,resetsweek,resetsmonth,class)
Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,resetsWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by cLevel desc, resets desc

TRUNCATE TABLE dbo.webRankingCharactersResetsWeek
INSERT INTO webRankingCharactersResetsWeek (account,character,clevel,pkcount,resets,mresets,resetsweek,resetsmonth,class)
Select TOP 200 AccountID,Name,cLevel,PkCount,resets,mresets,resetsWeek,resetsMonth,Class from Character where ctlcode < 8 or ctlcode is null order by resetsWeek desc, resets desc 

 

[CronusMakerchanel]

verifique se seu gs tem query systen se não não ira pegar

pois a musite tem tabelas especificas pra que essa job acima funcione