Please, do not show any gm game master information

Mon

Administrator
Developer
#2
You can exclude players from the rankings, just go to the rankings settings in the admin panel.
 

Mon

Administrator
Developer
#5
I added the information but it would be better to change the selection of characters with the gm code
Many files don't use such database column for managing GM's anymore, it's useless.

After you added the list of players to your excluded list you must wait for the rankings cache to be updated. Or simply go to your scheduled tasks in admincp and clear the cron last run.
 
#6
Many files don't use such database column for managing GM's anymore, it's useless.

After you added the list of players to your excluded list you must wait for the rankings cache to be updated. Or simply go to your scheduled tasks in admincp and clear the cron last run.
borre los cron antiguos pero en el ranking de gens, online guilds siguen apareciendo los administrador en el ranking
no esta configurado los escluidos en el codigo php me da flojera hacer ese fix
 
#7
class.ranking.php
PHP:
private function _getOnlineRankingDataMembStatHours() {
        $this->mu = Connection::Database('MuOnline');
      
        $accounts = $this->mu->query_fetch("SELECT TOP ".$this->_results." "._CLMN_MS_MEMBID_.", "._CLMN_MS_ONLINEHRS_." FROM "._TBL_MS_." WHERE "._CLMN_MS_ONLINEHRS_." > 0 ORDER BY "._CLMN_MS_ONLINEHRS_." DESC");
no aparece la lista de excluidos
PHP:
NOT IN(".$this->_rankingsExcludeChars().")
 
Last edited:
#9
es facil solo se agrega en build ranking
PHP:
    private function _guildsRanking() {
        $this->mu = Connection::Database('MuOnline');
    
        switch($this->serverFiles) {
            default:
                $result = $this->mu->query_fetch("SELECT TOP ".$this->_results." "._CLMN_GUILD_NAME_.","._CLMN_GUILD_MASTER_.","._CLMN_GUILD_SCORE_.",CONVERT(varchar(max), "._CLMN_GUILD_LOGO_.", 2) as "._CLMN_GUILD_LOGO_." FROM "._TBL_GUILD_." NOT IN(".$this->_rankingsExcludeChars().") ORDER BY "._CLMN_GUILD_SCORE_." DESC");
ahora solo falta los baneados
 
Last edited:

Mon

Administrator
Developer
#10
es facil solo se agrega en build ranking
PHP:
    private function _guildsRanking() {
        $this->mu = Connection::Database('MuOnline');
   
        switch($this->serverFiles) {
            default:
                $result = $this->mu->query_fetch("SELECT TOP ".$this->_results." "._CLMN_GUILD_NAME_.","._CLMN_GUILD_MASTER_.","._CLMN_GUILD_SCORE_.",CONVERT(varchar(max), "._CLMN_GUILD_LOGO_.", 2) as "._CLMN_GUILD_LOGO_." FROM "._TBL_GUILD_." NOT IN(".$this->_rankingsExcludeChars().") ORDER BY "._CLMN_GUILD_SCORE_." DESC");
ahora solo falta los baneados
Esta mal esta query ya que estas usando la lista de nombres de personajes para excluir nombres de guilds.
 
#11
excluye a
_CLMN_GUILD_MASTER_

al guild master a mi me funciono


esta query obtienes los nombres de la guild, el nombre del creador guild master, el score y el logo , pero no quieres que aparescan los escluidos en el resultado que obtienes de buscar en la tabla guild ordenados por guild score.
 
Last edited:
Top