quote_smart($_GET['realm']); if (is_numeric($realmid)) $sqlc->connect($characters_db[$realmid]['addr'], $characters_db[$realmid]['user'], $characters_db[$realmid]['pass'], $characters_db[$realmid]['name']); else $realmid = $realm_id; } $id = $sqlc->quote_smart($_GET['id']); if (is_numeric($id)); else $id = 0; $result = $sqlc->query('SELECT account, name, race, class, level, gender FROM characters WHERE guid = '.$id.' LIMIT 1'); if ($sqlc->num_rows($result)) { $char = $sqlc->fetch_assoc($result); $owner_acc_id = $sqlc->result($result, 0, 'account'); $result = $sqlr->query('SELECT gmlevel, username FROM account WHERE id = '.$char['account'].''); $owner_gmlvl = $sqlr->result($result, 0, 'gmlevel'); $owner_name = $sqlr->result($result, 0, 'username'); if (($user_lvl > $owner_gmlvl)||($owner_name === $user_name)) { $output .= '
'.htmlentities($char['name']).' - - lvl '.char_get_level_color($char['level']).'

'; $result = $sqlc->query('SELECT id, level, exp, name, curhappiness FROM character_pet WHERE owner = '.$id.''); if ($sqlc->num_rows($result)) { $sqlm = new SQL; $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']); while($pet = $sqlc->fetch_assoc($result)) { $happiness = floor($pet['curhappiness']/333000); if (1 == $happiness) { $hap_text = 'Content'; $hap_val = 1; } elseif (2 == $happiness) { $hap_text = 'Happy'; $hap_val = 2; } else { $hap_text = 'Unhappy'; $hap_val = 0; } $pet_next_lvl_xp = floor(char_get_xp_to_level($pet['level'])/4); $output .= ' '.$pet['name'].' - lvl '.char_get_level_color($pet['level']).'

Exp: '.$pet['exp'].'/'.$pet_next_lvl_xp.'
Pet Abilities: '; $ability_results = $sqlc->query('SELECT spell FROM pet_spell WHERE guid = '.$pet['id'].' and active > 1'); // active = 0 is unused and active = 1 probably some passive auras, i dont know diference between values 129 and 193, need to check mangos source if ($sqlc->num_rows($ability_results)) { while ($ability = $sqlc->fetch_assoc($ability_results)) { $output .= ' '.$ability['spell'].' '; } } $output .= '


'; } unset($ability_results); unset($pet_next_lvl_xp); unset($happiness); unset($pet); } $output .= '


'; } else error($lang_char['no_permission']); } else error($lang_char['no_char_found']); } //######################################################################################################################## // MAIN //######################################################################################################################## //$action = (isset($_GET['action'])) ? $_GET['action'] : NULL; $lang_char = lang_char(); char_pets($sqlr, $sqlc); //unset($action); unset($action_permission); unset($lang_char); require_once 'footer.php'; ?>