$accdb = self::getAuthDBName();
$sql = "SELECT id FROM " . $accdb . ".account WHERE username='******'";
self::$db->setQuery($sql);
if (!($id = self::$db->loadResult())) {
JLog::add("Error getAccId. sql=" . $sql, JLog::ERROR);
return -1;
}
return $id;
}
/**
* Returns a character info object
* @param int $realmid
* @param int $guid
*/
public static function getCharacterInfo($realmid, $guid)
{
$chardb = JTrinityCoreUtilities::getCharacterDBName($realmid);
$accid = JTrinityCoreDBHelper::getAccId();
$sql = "SELECT * FROM " . $chardb . ".characters WHERE account=" . $accid . " AND guid=" . $guid;
$db = JTrinityCoreDBHelper::getDB();
$db->setQuery($sql);
return $db->loadObject();
}
public static function getWowGroups()
{
$group = array(array('id' => '0', 'name' => 'Wow User'), array('id' => '1', 'name' => 'Wow Game Moderator'), array('id' => '2', 'name' => 'Wow Game Master'), array('id' => '3', 'name' => 'Wow Administrator'), array('id' => '4', 'name' => 'Wow Console user'));
return $group;
}
}
JTrinityCoreDBHelper::createDatabases();
