public function getItems() { $items = parent::getItems(); // If current realm list is empty populate from TC database if ($this->getTotal() <= 0) { $authdb = JTrinityCoreDBHelper::getAuthDBName(); $sql = "SELECT id, name, address, port, population FROM " . $authdb . ".realmlist"; $dbo = JTrinityCoreDBHelper::getDB(); $dbo->setQuery($sql); $results = $dbo->loadObjectList(); if (count($results)) { foreach ($results as $row) { $data = new stdClass(); $data->id = NULL; $data->realmid = $row->id; $data->realmname = $row->name; $data->ip = $row->address; $data->port = $row->port; $data->population = $row->population; $this->_db->insertObject('#__jtc_realms', $data, 'id'); } $items = parent::getItems(); } } return $items; }
public function __construct(&$subject, $config) { // Set log $date = JFactory::getDate()->format('Y-m-d'); $options['format'] = '{DATE}\\t {TIME} \\t{LEVEL} \\t{CODE} \\t{MESSAGE}'; $options['text_file'] = 'plg_usertrinity.' . $date . '.php'; JLog::addLogger($options, JLog::ALL, $this->logcat); $this->dbaccount = JTrinityCoreDBHelper::getAuthDBName(); //$this->dbcharacters=JTrinityCoreDBHelper::getCharactersDBName(); parent::__construct($subject, $config); $this->loadLanguage(); }
/** * Get the characters of the user_name in the realm_id * @param int $realm_id * @param int $user_name */ public function getCharacters($realm_id, $username = null) { if ($realm_id == 0) { return; } if (!$username) { $user = JFactory::getUser(); $username = $user->username; } // Get accountid if from username $dbo = JTrinityCoreDBHelper::getDB(); $accdb = JTrinityCoreDBHelper::getAuthDBName(); $query = "SELECT id FROM " . $accdb . ".account WHERE UPPER(username)=UPPER('" . $username . "')"; $dbo->setQuery($query); $accid = $dbo->loadResult(); // Get Character DB name $database = JTrinityCoreUtilities::getCharacterDBName($realm_id); // open the characters db $query = "SELECT guid, name, level, money FROM " . $database . ".characters where account=" . $accid; $dbo->setQuery($query); return $dbo->loadObjectList(); }
public function delete(&$pks) { try { // delete from tc db $dbo = JTrinityCoreDBHelper::getDB(); $accdb = JTrinityCoreDBHelper::getAuthDBName(); // Iterate the items to delete each one. $res = true; $pks = (array) $pks; $table = $this->getTable(); foreach ($pks as $i => $pk) { $realmid = 0; // Get realmid if ($table->load($pk)) { $realmid = $table->realmid; } $query = "DELETE FROM " . $accdb . ".realmlist WHERE id=" . $realmid; $dbo->setQuery($query); $res = $res && $dbo->query(); } if ($res) { $res = parent::delete($pks); } return $res; } catch (Exception $e) { $this->setError($e->getMessage()); return false; } }
public function getUptimeServer($realmid) { $db = JTrinityCoreDBHelper::getDB(); $accdb = JTrinityCoreDBHelper::getAuthDBName(); $query = "SELECT uptime FROM " . $accdb . ".uptime WHERE realmid=" . $realmid . " ORDER BY starttime DESC LIMIT 1"; $db->setQuery($query); if (!($uptime_res = $db->loadResult())) { $uptime = '0'; } else { $obj = $this->secondsToTime($uptime_res); $uptime = ''; if ($obj['d'] > 0) { $uptime = $obj['d'] . JText::_('COM_JTRINITYCORE_DAYS'); } if ($obj['h'] > 0) { $uptime .= ' ' . $obj['h'] . JText::_('COM_JTRINITYCORE_HOURS'); } if ($obj['m'] > 0) { $uptime .= ' ' . $obj['m'] . JText::_('COM_JTRINITYCORE_MINS'); } } return $uptime; }