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