$numofpgs++; } if ($CHDB) { $query = $CHDB->select("SELECT guid, name, race, class, gender, level, zone FROM `characters` WHERE `online`='1' AND (NOT `extra_flags` & 1 AND NOT `extra_flags` & 16) ORDER BY `name` LIMIT {$limitstart},{$limit}"); } } else { output_message('alert', 'Realm <b>' . $realm_info['name'] . '</b> is offline <img src="./templates/WotLK/images/downarrow2.gif" border="0" align="top">'); } foreach ($query as $result) { if ($res_color == 1) { $res_color = 2; } else { $res_color = 1; } $cc++; $res_race = $MANG->characterInfoByID['character_race'][$result['race']]; $res_class = $MANG->characterInfoByID['character_class'][$result['class']]; $res_pos = $MANG->get_zone_name($result['zone']); $res_info[$cc]["number"] = $cc; $res_info[$cc]["res_color"] = $res_color; $res_info[$cc]["name"] = $result['name']; $res_info[$cc]["race"] = $result['race']; $res_info[$cc]["class"] = $result['class']; $res_info[$cc]["gender"] = $result['gender']; $res_info[$cc]["level"] = $result['level']; $res_info[$cc]["pos"] = $res_pos; $res_info[$cc]["guid"] = $result['guid']; } unset($query); // Free up memory. unset($MANG);