Buenas noches hace dias que no encuentro como solucionar este problema uso la web engime y resulta que esta es la busqueda que hace de los onlines

Code: [Select]

define('_TBL_LOGEX_', 'MuLogEx');
	define('_CLMN_LOGEX_ACCID_', 'AccountId');
	define('_CLMN_LOGEX_IP_', 'IP');
	define('_CLMN_LOGEX_TIN_', 'TimeIn');
	define('_CLMN_LOGEX_TOUT_', 'TimeOut');
	define('_CLMN_LOGEX_OD_', 'OnlineDuration');
	define('_CLMN_LOGEX_SRV_', 'Server');

y esto en la clase

Code: [Select]

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");
				}

Resulta que mi base de datos no tiene estas tablas ni columnas, estas son las que tiene y interpreto que son de ahi que toman los datos de MEMB_STAT  y esa tabla contiene memb___id, ConnectStat,  ServerNAme, IP, ConnectTM, DisConnect

Alguiem me podria dar una mano? por eso no actualiza el cache online

Want to earn more by just clicking, Try our fachai9 arcade games to win more. Be your own boss.