$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();