hola buenas noches, tengo un problema no se si alguien me podria ayudar, las mitad de las cron se ejecutan y el resto no, esta es la funcion que tiene la clase , es para la version 97x y no se si es por eso porque creo que no todas son las misma base de datos porque tiene menos cosas que las demas seanson de mu

Code: [Select]

private function _onlineRanking() {
		$this->me = Connection::Database('Me_MuOnline');
		$this->mu = Connection::Database('MuOnline');
		
		switch($this->serverFiles) {
			case "mue":
				if($this->config['SQL_USE_2_DB']) {
					$muLogEx = $this->me->query_fetch("SELECT TOP ".$this->_results." "._CLMN_LOGEX_ACCID_.", sum("._CLMN_LOGEX_OD_.") as TotalOnlineTime FROM "._TBL_LOGEX_." GROUP BY "._CLMN_LOGEX_ACCID_." WHERE ConnectStat==1 ORDER BY TotalOnlineTime DESC");
					if(is_array($muLogEx)) {
						$result = array();
						$character = new Character();
						foreach($muLogEx as $key => $thisUser) {
							$characterName = $character->AccountCharacterIDC($thisUser[_CLMN_LOGEX_ACCID_]);
							$characterData = $character->CharacterData($characterName);
							$result[$key] = array($characterName, $thisUser['TotalOnlineTime'], $characterData[_CLMN_CHR_CLASS_], $characterData[_CLMN_CHR_MAP_]);
						}
					}
				} else {
					$result = $this->mu->query_fetch("SELECT TOP ".$this->_results." tb2."._CLMN_GAMEIDC_.", sum(tb1."._CLMN_LOGEX_OD_.") AS TotalOnlineDuration, tb3."._CLMN_CHR_CLASS_.", tb3."._CLMN_CHR_MAP_." FROM "._TBL_LOGEX_." AS tb1 INNER JOIN "._TBL_AC_." AS tb2 ON tb1."._CLMN_LOGEX_ACCID_." = tb2."._CLMN_AC_ID_." INNER JOIN "._TBL_CHR_." AS tb3 ON tb2."._CLMN_GAMEIDC_." = tb3."._CLMN_CHR_NAME_." WHERE tb3."._CLMN_CHR_NAME_." NOT IN(".$this->_rankingsExcludeChars().") GROUP BY tb1."._CLMN_LOGEX_ACCID_.", tb2."._CLMN_GAMEIDC_.", tb3."._CLMN_CHR_CLASS_." WHERE ConnectStat==1 ORDER BY TotalOnlineDuration DESC");
				}
				break;
			case "muemu":
				$result = $this->_getOnlineRankingDataMembStatHours();
				break;
			case "louis":
				$result = $this->_getOnlineRankingDataMembStatHours();
				break;
			case "xteam":
				$result = $this->_getOnlineRankingDataMembStatHours();
				break;
			default:
				return;
		}
		if(!is_array($result)) return

hola buenas noches, tengo un problema no se si alguien me podria ayudar, las mitad de las cron se ejecutan y el resto no, esta es la funcion que tiene la clase , es para la version 97x y no se si es por eso porque creo que no todas son las misma base de datos porque tiene menos cosas que las demas seanson de mu

Code: [Select]

private function _onlineRanking() {
		$this->me = Connection::Database('Me_MuOnline');
		$this->mu = Connection::Database('MuOnline');
		
		switch($this->serverFiles) {
			case "mue":
				if($this->config['SQL_USE_2_DB']) {
					$muLogEx = $this->me->query_fetch("SELECT TOP ".$this->_results." "._CLMN_LOGEX_ACCID_.", sum("._CLMN_LOGEX_OD_.") as TotalOnlineTime FROM "._TBL_LOGEX_." GROUP BY "._CLMN_LOGEX_ACCID_." WHERE ConnectStat==1 ORDER BY TotalOnlineTime DESC");
					if(is_array($muLogEx)) {
						$result = array();
						$character = new Character();
						foreach($muLogEx as $key => $thisUser) {
							$characterName = $character->AccountCharacterIDC($thisUser[_CLMN_LOGEX_ACCID_]);
							$characterData = $character->CharacterData($characterName);
							$result[$key] = array($characterName, $thisUser['TotalOnlineTime'], $characterData[_CLMN_CHR_CLASS_], $characterData[_CLMN_CHR_MAP_]);
						}
					}
				} else {
					$result = $this->mu->query_fetch("SELECT TOP ".$this->_results." tb2."._CLMN_GAMEIDC_.", sum(tb1."._CLMN_LOGEX_OD_.") AS TotalOnlineDuration, tb3."._CLMN_CHR_CLASS_.", tb3."._CLMN_CHR_MAP_." FROM "._TBL_LOGEX_." AS tb1 INNER JOIN "._TBL_AC_." AS tb2 ON tb1."._CLMN_LOGEX_ACCID_." = tb2."._CLMN_AC_ID_." INNER JOIN "._TBL_CHR_." AS tb3 ON tb2."._CLMN_GAMEIDC_." = tb3."._CLMN_CHR_NAME_." WHERE tb3."._CLMN_CHR_NAME_." NOT IN(".$this->_rankingsExcludeChars().") GROUP BY tb1."._CLMN_LOGEX_ACCID_.", tb2."._CLMN_GAMEIDC_.", tb3."._CLMN_CHR_CLASS_." WHERE ConnectStat==1 ORDER BY TotalOnlineDuration DESC");
				}
				break;
			case "muemu":
				$result = $this->_getOnlineRankingDataMembStatHours();
				break;
			case "louis":
				$result = $this->_getOnlineRankingDataMembStatHours();
				break;
			case "xteam":
				$result = $this->_getOnlineRankingDataMembStatHours();
				break;
			default:
				return;
		}
		if(!is_array($result)) return

Ranking MuCore no muestra los reset

Started by JYachelini Soporte / Ayudas

NO MUESTRA RANKING DE USUARIO WEBENGINE 1.2.0

Started by jimmy456 Soporte / Ayudas