• Bem vindo à nossa comunidade - Quer se juntar ao resto dos nossos membros? Registre-se*Registros aprovados pela adminitração

[Duvida] Me Ajudem com o Mu Site 2.5

Hugo_Ts

Honrado XPZ
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 !
 

supremooffcial

ESPANHA - Malaga
Honrado XPZ
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 
 
Topo Bottom