[derleybr]

Se for isso que vc precise...

ESTRUTURA BD: realmd.account

[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

To te mandando o arquivo o codigo de dois arquivos.

config.php
[INDENT]<?php
/*
LET'S INSTALL YOUR ROSPORA!


1-Set up your mysql database ip adress (ex. 127.0.0.1 or 127.0.0.1)
2-Set up your mysql databases usernames and passwords (ex. user= root password = mangos)
3-Set up your mysql databases which mangos is used them! (imp. databases already had set to default names)
4-Set up your Server PC's IP address (for realm status)
5-Set up your Template Options (if you want)
6-Write your server informations (ex. XP options , Versions..)

You are ready to pump it up!

Open a browser , call your servers ip at address bar! (pisstt.. If you have a router , dont forget forwarding 80 number port to your Server!)

WELL DONE! You did it!

----------------------
NOO , I cant did it!

Don't be a hasty.Check your Configuration again slowly!
----------------------
Again ?

Check [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar] and find The RoSpora Topic and write your error.
or send me a email at [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar] !

----------------------
CREDITS:

THANK YOU ALL , WHO IS SUPPORTING AND LIKES ROSPORA!
THIS ROSPORA GOING TO BLESS YOUR SERVER! =)
DONT FORGET TO CHECK UPDATES OF YOURS @ [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]
*/

#DATABASE SETTINGS

$serveros="windows"; //Write your server operation system For Windows "windows" For Linux "linux"
$lang="en"; // Language ("en" - english, "ru" - russian, "tr" - turkish, "hu" - hungarian, "de" - deutsch)

//////////////////////////////////////////
#MAIN HOST - MAIN SERVER
//////////////////////////////////////////
$host="127.0.0.1"; // MAIN HOST for Mangos database
$user="root"; // MAIN USER for Mangos database
$password="minhasenha"; // MAIN PASS for Mangos database
$db="mangos"; // MAIN NAME of Mangos database
//////////////////////////////////////////
$hostr="127.0.0.1"; // MAIN HOST for Realm database
$userr="root"; // MAIN USER for Realm database
$passwordr="minhasenha"; // MAIN PASS for Realm database
$dbr="realmd"; // MAIN NAME of Real database
//////////////////////////////////////////
#HOST MAIN - REALM ONE
//////////////////////////////////////////
$hostrealmone="127.0.0.1"; // MAIN HOST for Characters database
$userrealmone="root"; // MAIN USER for Characters database
$passwordrealmone="minhasenha"; // MAIN PASS for Characters database
$dbrealmone="characters"; // MAIN NAME of Characters database
/////////////////////////////////
#HOST TWO - REALM TWO
/////////////////////////////////
$hostrealmtwo="127.0.0.1"; // 2. HOST for Characters database
$userrealmtwo="root"; // 2. USER for Characters database
$passwordrealmtwo="minhasenha"; // 2. PASS for Characters database
$dbrealmtwo="characters"; // 2. NAME of Characters database
/////////////////////////////////
#HOST THREE - REALM THREE
/////////////////////////////////
$hostrealmthree="127.0.0.1"; // 3. HOST for Characters database
$userrealmthree="root"; // 3. USER for Characters database
$passwordrealmthree="minhasenha"; // 3. PASS for Characters database
$dbrealmthree="characters"; // 3. NAME of Characters database
////////////////////////////////
#HOST FOUR - REALM FOUR
/////////////////////////////////
$hostrealmfour="127.0.0.1"; // 4. HOST for Characters database
$userrealmfour="root"; // 4. USER for Characters database
$passwordrealmfour="minhasenha"; // 4. PASS for Characters database
$dbrealmfour="characters"; // 4. NAME of Characters database
//////////////////////////////////////////

#REALM STATUS CHECK OPTIONS
//////////////////////////////////////////
$database_encoding = 'CP1251'; // Set character encoding for MySQL
$server = "127.0.0.1"; // MAIN HOST adress (for realm status)
$servertwo = "127.0.0.1"; // 2. HOST adress (for realm status)
$serverthree = "127.0.0.1"; // 3. HOST adress (for realm status)
$serverfour = "127.0.0.1"; // 4. HOST adress (for realm status)
$port = "8085"; // Server port (for all realms status) 8085 or 3724
//////////////////////////////////////////

#ACCOUNT PAGE OPTIONS
//////////////////////////////////////////
$accountoption="1"; //Set your RoSPORA's account creating is open or closed. 1 - Open , 2 - Closed
$onlineoption="1"; //Set your RoSPORA's online player display is open or closed. 1 - Open , 2 - Closed
$accountmessage="Upgrading Server's Version!"; //Set your account creation closed text
$onlinemessage="Online Player Display Disabled For Upgrading Server!"; //Set your online player display text
$lock_acc=2; // Lock created account to IP adress (1 - on, 0 - off)
$lock_reg=0; // Registration only one (or more) account from one IP adress (IT HAVE A SECURITY ON FORM ACTION BOTS! , JUST SET IT TO 1 OR 2) // 0 - not limit, 1 - one acc, 2 - two acc, etc...

//////////////////////////////////////////
#TEMPLATE OPTIONS

$img_base = "img/"; // Image dir
$ongif = "img/on.gif";
$offgif = "img/off.gif";
$charset="windows-1251"; //Browser charset of your language.Tarayýcýnýzýn dilinize göre charset ayarý - Türkçe : "iso-8859-9"
$timetext="Current Server Time"; //Shows Server Time , if you want you can change it to your language Example: ="yourlang";

//////////////////////////////////////////
#MINI INFORMATION BOX OPTIONS

$information="
<li>This server supports only 2.x.x clients<br>
<li>1x Quest XP , 1x Kill XP , 1x Discovery XP<br>
<li>Runnig on One Realm<br>
<li>First Realm has 100 User Cap.<br>";
?>[/INDENT

---------------------------------------------------------------------

Functiondata.php (esse arquivo é o que faz os insert's)

<?php
require_once( 'config.php' );
require_once( 'languages.php' );
$version="V1.5.0";
$maps_a = Array(
0 => 'Azeroth',
1 => 'Kalimdor',
2 => 'UnderMine',
13 => 'Test zone',
17 => 'Kalidar',
30 => 'Alterac Valley',
33 => 'Shadowfang Keep Instance',
34 => 'The Stockade Instance',
35 => 'Stormwind Prizon',
36 => 'Deadmines Instance',
37 => 'Plains of Snow',
43 => 'Wailing Caverns Instance',
44 => 'Monastery Interior',
47 => 'Razorfen Kraul Instance',
48 => 'Blackfathom Deeps Instance',
70 => 'Uldaman Instance',
90 => 'Gnomeregan Instance',
109 => 'Sunken Temple Instance',
129 => 'Razorfen Downs Instance',
530 => 'Outland',
169 => 'Emerald Forest',
189 => 'Scarlet Monastery Instance',
209 => 'ZulFarrak Instance',
229 => 'Blackrock Spire Instance',
230 => 'Blackrock Depths Instance',
249 => 'Onyxias Lair Instance',
269 => 'Caverns of Time',
289 => 'Scholomance Instance',
309 => 'ZulGurub Instance',
329 => 'Stratholme Instance',
349 => 'Maraudon Instance',
369 => 'Deeprun Tram',
389 => 'Ragefire Chasm Instance',
409 => 'The Molten Core Instance',
429 => 'Dire Maul Instance',
449 => 'Alliance PVP Barracks',
450 => 'Horde PVP Barracks',
451 => 'Development Land',
469 => 'Blackwing Lair Instance',
489 => 'Warsong Gulch',
509 => 'Ruins of AhnQiraj Instance',
529 => 'Arathi Basin',
531 => 'Temple of AhnQiraj Instance',
533 => 'Naxxramas Instance',
532 => 'Karazahn',
534 => 'Hyjal Past',
540 => 'Shattered Halls Instance',
542 => 'Blood Furnace Instance',
543 => 'Hellfire Ramparts Instance',
544 => 'Magtheridons Lair Instance',
545 => 'Steamvault Instance',
546 => 'Underbog Instance',
547 => 'Slave Pens Instance',
548 => 'Coilfang Resevoir Instance',
550 => 'Tempest Keep',
552 => 'Tempest Keep',
553 => 'Tempest Keep',
554 => 'Tempest Keep',
555 => 'Auchindoun',
556 => 'Auchindoun',
557 => 'Auchindoun',
558 => 'Auchindoun',
559 => 'Nagrand Arena',
560 => 'Hillsbrad Past',
562 => 'Blades Edge Arena',
564 => 'Black Temple',
565 => 'Gruuls Lair',
566 => 'Netherstorm Arena',
568 => 'Zulaman',
);

$zone = Array(
0 => Array(
Array(700,10,1244,1873,'Undercity',1497),
Array(-840,-1330,-5050,-4560,'Ironforge',1537),
Array(1190,200,-9074,-8280,'Stormwind City',1519),
Array(-2170,-4400,-7348,-6006,'Badlands',3),
Array(-500,-4400,-4485,-2367,'Wetlands',11),
Array(2220,-2250,-15422,-11299,'Stranglethorn Vale',33),
Array(-1724,-3540,-9918,-8667,'Redridge Mountains',44),
Array(-2480,-4400,-6006,-4485,'Loch Modan',38),
Array(662,-1638,-11299,-9990,'Duskwood',10),
Array(-1638,-2344,-11299,-9918,'Deadwind Pass',41),
Array(834,-1724,-9990,-8526,'Elwynn Forest',12),
Array(-500,-3100,-8667,-7348,'Burning Steppes',46),
Array(-608,-2170,-7348,-6285,'Searing Gorge',51),
Array(2000,-2480,-6612,-4485,'Dun Morogh',1),
Array(-1575,-5425,-432,805,'The Hinterlands',47),
Array(3016,662,-11299,-9400,'Westfall',40),
Array(600,-1575,-1874,220,'Hillsbrad Foothills',267),
Array(-2725,-6056,805,3800,'Eastern Plaguelands',139),
Array(-850,-2725,805,3400,'Western Plaguelands',28),
Array(2200,600,-900,1525,'Silverpine Forest',130),
Array(2200,-850,1525,3400,'Tirisfal Glades',85),
Array(-2250,-3520,-12800,-10666,'Blasted Lands',4),
Array(-2344,-4516,-11070,-9600,'Swamp of Sorrows',8),
Array(-1575,-3900,-2367,-432,'Arathi Highlands',45),
Array(600,-1575,220,1525,'Alterac Mountains',36),
),
1 => Array(
Array(2698,2030,9575,10267,'Darnassus',1657),
Array(326,-360,-1490,-910,'Thunder Bluff',1638),
Array(-3849,-4809,1387,2222,'Orgrimmar',1637),
Array(-1300,-3250,7142,8500,'Moonglade',493),
Array(2021,-400,-9000,-6016,'Silithus',1377),
Array(-2259,-7000,4150,8500,'Winterspring',618),
Array(-400,-2094,-8221,-6016,'Un\'Goro Crater',490),
Array(-590,-2259,3580,7142,'Felwood',361),
Array(-3787,-8000,1370,6000,'Azshara',16),
Array(-1900,-5500,-10475,-6825,'Tanaris',440),
Array(-2478,-5500,-5135,-2330,'Dustwallow Marsh',15),
Array(360,-1536,-3474,-412,'Mulgore',215),
Array(4000,-804,-6828,-2477,'Feralas',357),
Array(3500,360,-2477,372,'Desolace',405),
Array(-804,-5500,-6828,-4566,'Thousand Needles',400),
Array(-3758,-5500,-1300,1370,'Durotar',14),
Array(1000,-3787,1370,4150,'Ashenvale',331),
Array(2500,-1300,4150,8500,'Darkshore',148),
Array(3814,-1100,8600,11831,'Teldrassil',141),
Array(3500,-804,-412,3580,'Stonetalon Mountains',406),
Array(-804,-4200,-4566,1370,'The Barrens',17),
),
530 => Array(
Array(6135.25,4829,-2344.78,-1473.95,'Shattrath City',3703),
Array(-6400.75,-7612.20,9346.93,10153.70,'Silvermoon City',3487),
Array(5483.33,-91.66,1739.58,5456.25,'Netherstorm',3523),
Array(7083.33,1683.33,-4600,-999.99,'Terokkar Forest',3519),
Array(10295.83,4770.83,-3641.66,41.66,'Nagrand',3518),
Array(-10075,-13337.49,-2933.33,-758.33,'Bloodmyst Isle',3525),
Array(8845.83,3420.83,791.66,4408.33,'Blades Edge Mountains',3522),
Array(4225,-1275,-5614.58,-1947.91,'Shadowmoon Valley',3520),
Array(-11066.36,-12123.13,-4314.37,-3609.68,'The Exodar',3557),
Array(9475,4447.91,-1416.66,1935.41,'Zangarmarsh',3521),
Array(5539.58,375,-1962.49,1481.25,'Hellfire Peninsula',3483),
Array(-10500,-14570.83,-5508.33,-2793.75,'Azuremyst Isle',3524),
Array(-5283.33,-8583.33,6066.66,8266.66,'Ghostlands',3433),
Array(-4487,-9412,7758,11041,'Eversong Woods',3430)
),
);

$def = Array(
'character_race' => Array(
1 => 'Human',
2 => 'Orc',
3 => 'Dwarf',
4 => 'Night&nbsp;Elf',
5 => 'Undead',
6 => 'Tauren',
7 => 'Gnome',
8 => 'Troll',
9 => 'Goblin',
10 => 'Blood&nbspElf',
11 => 'Dranei',
),

'character_class' => Array(
1 => 'Warrior',
2 => 'Paladin',
3 => 'Hunter',
4 => 'Rogue',
5 => 'Priest',
7 => 'Shaman',
8 => 'Mage',
9 => 'Warlock',
11 => 'Druid',
),

'character_rank' => Array(
'alliance' => Array(
1 => 'Private',
2 => 'Corporal',
3 => 'Sergeant',
4 => 'Master Sergeant',
5 => 'Sergeant Major',
6 => 'Knight',
7 => 'Knight-Lieutenant',
8 => 'Knight-Captain',
9 => 'Knight-Champion',
10 => 'Lieutenant Commander',
11 => 'Commander',
12 => 'Marshal',
13 => 'Field Marshal',
14 => 'Grand Marshal'
),
'horde' => Array(
1 => 'Scout',
2 => 'Grunt',
3 => 'Sergeant',
4 => 'Senior Sergeant',
5 => 'First Sergeant',
6 => 'Stone Guard',
7 => 'Blood Guard',
8 => 'Legionnare',
9 => 'Centurion',
10 => 'Champion',
11 => 'Lieutenant General',
12 => 'General',
13 => 'Warlord',
14 => 'High Warlord'
)
),
);
class DBLayer
{
var $link_id;
var $query_result;
var $saved_queries = array();
var $num_queries = 0;

function DBLayer($db_host, $db_username, $db_password, $db_name)
{
$this->link_id = @mysql_connect($db_host, $db_username, $db_password, true);

if ($this->link_id)
{
if (@mysql_select_db($db_name, $this->link_id))
return $this->link_id;
else
error('Unable to select database. MySQL reported: '.mysql_error(), __FILE__, __LINE__);
}
else
error('Unable to connect to MySQL server. MySQL reported: '.mysql_error(), __FILE__, __LINE__);
}

function query($sql)
{
$this->query_result = @mysql_query($sql, $this->link_id);

if ($this->query_result)
{
++$this->num_queries;
return $this->query_result;
}
else
{
return false;
}
}


function result($query_id = 0, $row = 0)
{
return ($query_id) ? @mysql_result($query_id, $row) : false;
}


function fetch_assoc($query_id = 0)
{
return ($query_id) ? @mysql_fetch_assoc($query_id) : false;
}


function fetch_row($query_id = 0)
{
return ($query_id) ? @mysql_fetch_row($query_id) : false;
}


function num_rows($query_id = 0)
{
return ($query_id) ? @mysql_num_rows($query_id) : false;
}


function affected_rows()
{
return ($this->link_id) ? @mysql_affected_rows($this->link_id) : false;
}


function insert_id()
{
return ($this->link_id) ? @mysql_insert_id($this->link_id) : false;
}


function get_num_queries()
{
return $this->num_queries;
}


function get_saved_queries()
{
return $this->saved_queries;
}


function free_result($query_id = false)
{
return ($query_id) ? @mysql_free_result($query_id) : false;
}


function escape($str)
{
if (function_exists('mysql_real_escape_string'))
return mysql_real_escape_string($str, $this->link_id);
else
return mysql_escape_string($str);
}


function error()
{
$result['error_sql'] = @current(@end($this->saved_queries));
$result['error_no'] = @mysql_errno($this->link_id);
$result['error_msg'] = @mysql_error($this->link_id);

return $result;
}


function close()
{
if ($this->link_id)
{
if ($this->query_result)
@mysql_free_result($this->query_result);

return @mysql_close($this->link_id);
}
else
return false;
}
}
//Functions of RoSpora Tab System
function test_realm(){
global $server, $port;
$s = @fsockopen("$server", $port, $ERROR_NO, $ERROR_STR,(float)0.5);
if($s){@fclose($s);return true;} else return false;
}


function test_realmtwo(){
global $servertwo, $port;
$s = @fsockopen("$servertwo", $port, $ERROR_NO, $ERROR_STR,(float)0.5);
if($s){@fclose($s);return true;} else return false;
}


function test_realmthree(){
global $serverthree, $port;
$s = @fsockopen("$serverthree", $port, $ERROR_NO, $ERROR_STR,(float)0.5);
if($s){@fclose($s);return true;} else return false;
}


function test_realmfour(){
global $serverfour, $port;
$s = @fsockopen("$serverfour", $port, $ERROR_NO, $ERROR_STR,(float)0.5);
if($s){@fclose($s);return true;} else return false;
}

function get_realm_name(){
global $hostr, $userr, $passwordr, $dbr, $database_encoding;
$realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr);
$realm_db->query("SET NAMES $database_encoding");
$query = $realm_db->query("SELECT * FROM `realmlist` WHERE id = '1'");
$result = $realm_db->fetch_assoc($query);
$realm_db->close();
unset($realm_db);
return($result['name']);
}
function get_realm_nametwo(){
global $hostr, $userr, $passwordr, $dbr, $database_encoding;
$realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr);
$realm_db->query("SET NAMES $database_encoding");
$query2 = $realm_db->query("SELECT * FROM `realmlist` WHERE id = '2'");
$result2 = $realm_db->fetch_assoc($query2);
$realm_db->close();
unset($realm_db);
return($result2['name']);
}
function get_realm_namethree(){
global $hostr, $userr, $passwordr, $dbr, $database_encoding;
$realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr);
$realm_db->query("SET NAMES $database_encoding");
$query3 = $realm_db->query("SELECT * FROM `realmlist` WHERE id = '3'");
$result3 = $realm_db->fetch_assoc($query3);
$realm_db->close();
unset($realm_db);
return($result3['name']);
}
function get_realm_namefour(){
global $hostr, $userr, $passwordr, $dbr, $database_encoding;
$realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr);
$realm_db->query("SET NAMES $database_encoding");
$query4 = $realm_db->query("SELECT * FROM `realmlist` WHERE id = '4'");
$result4 = $realm_db->fetch_assoc($query4);
$realm_db->close();
unset($realm_db);
return($result4['name']);
}
function get_zone_name($mapid, $x, $y){
global $maps_a, $zone;

if (!empty($maps_a[$mapid]))
{
$zmap=$maps_a[$mapid];
if (($mapid==0) or ($mapid==1) or ($mapid==530))
{
$i=0; $c=count($zone[$mapid]);
while ($i<$c)
{
if ($zone[$mapid][$i][2] < $x AND $zone[$mapid][$i][3] > $x AND $zone[$mapid][$i][1] < $y AND $zone[$mapid][$i][0] > $y) $zmap=$zone[$mapid][$i][4];
$i++;
}
}
} else $zmap="Unknown zone";
return $zmap;
}


function make_players_arrayrealmone(){
global $hostrealmone, $userrealmone, $passwordrealmone, $dbrealmone, $database_encoding, $pl_array;
$i=0;
$mangos_db = new DBLayer($hostrealmone, $userrealmone, $passwordrealmone, $dbrealmone);
$mangos_db->query("SET NAMES $database_encoding");
$query = $mangos_db->query("SELECT * FROM `characters` WHERE `online`='1' ORDER BY `name`");
while($result = $mangos_db->fetch_assoc($query))
{
$char_data = explode(' ',$result['data']);
$char_gender = dechex($char_data[36]);
$char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT);
$char_gender = $char_gender{3};
$res_pos=get_zone_name($result['map'], $result['position_x'], $result['position_y']);

$pl_array[$i] = Array($result['name'], $result['race'], $result['class'], $char_data[34], $res_pos, $char_gender);
$i++;
}
$mangos_db->close();
unset($mangos_db);
return $i;
}

$onlineplayers=make_players_arrayrealmone();

if (!$sort = &$_GET['s']) $sort=0;
if (!$flag = &$_GET['f']) $flag=0;
if ($flag==0) { $flag=1; $sort_type='<'; }
else { $flag=0; $sort_type='>'; }
$link=$_SERVER['PHP_SELF']."?f=".$flag."&s=";

if (!empty($pl_array))
{
usort($pl_array, create_function('$a, $b', 'if ( $a['.$sort.'] == $b['.$sort.'] ) return 0; if ( $a['.$sort.'] '.$sort_type.' $b['.$sort.'] ) return -1; return 1;'));
}

$listone="";
$i=0;
while ($i < $onlineplayers)
{
$name=$pl_array[$i][0];
$race=$pl_array[$i][1];
$class=$pl_array[$i][2];
$res_race = $def['character_race'][$race];
$res_class = $def['character_class'][$class];
$lvl=$pl_array[$i][3];
$loc=$pl_array[$i][4];
$gender=$pl_array[$i][5];
$listone.= "
<tr class=txt>
<td></td>
<td>$name</td>
<td align='center'><img alt=$res_race src='".$img_base.$race."-$gender.gif' height='18' width='18'></td>
<td align='center'><img alt=$res_class src='".$img_base."$class.gif' height='18' width='18'></td>
<td align='center'>$lvl</td>
<td >$loc</td>
</tr>";
$i++;
}
//Realm Two

function make_players_arrayrealmtwo(){
global $hostrealmtwo, $userrealmtwo, $passwordrealmtwo, $dbrealmtwo, $database_encoding, $pl_array;
$i=0;
$mangos_dbtwo = new DBLayer($hostrealmtwo, $userrealmtwo, $passwordrealmtwo, $dbrealmtwo);
$mangos_dbtwo->query("SET NAMES $database_encoding");
$query = $mangos_dbtwo->query("SELECT * FROM `characters` WHERE `online`='1' ORDER BY `name`");
while($result = $mangos_dbtwo->fetch_assoc($query))
{
$char_data = explode(' ',$result['data']);
$char_gender = dechex($char_data[36]);
$char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT);
$char_gender = $char_gender{3};
$res_pos=get_zone_name($result['map'], $result['position_x'], $result['position_y']);

$pl_array[$i] = Array($result['name'], $result['race'], $result['class'], $char_data[34], $res_pos, $char_gender);
$i++;
}
$mangos_dbtwo->close();
unset($mangos_dbtwo);
return $i;
}

$onlineplayerstwo=make_players_arrayrealmtwo();

if (!$sort = &$_GET['s']) $sort=0;
if (!$flag = &$_GET['f']) $flag=0;
if ($flag==0) { $flag=1; $sort_type='<'; }
else { $flag=0; $sort_type='>'; }
$link=$_SERVER['PHP_SELF']."?f=".$flag."&s=";

if (!empty($pl_array))
{
usort($pl_array, create_function('$a, $b', 'if ( $a['.$sort.'] == $b['.$sort.'] ) return 0; if ( $a['.$sort.'] '.$sort_type.' $b['.$sort.'] ) return -1; return 1;'));
}

$listtwo="";
$i=0;
while ($i < $onlineplayerstwo)
{
$name=$pl_array[$i][0];
$race=$pl_array[$i][1];
$class=$pl_array[$i][2];
$res_race = $def['character_race'][$race];
$res_class = $def['character_class'][$class];
$lvl=$pl_array[$i][3];
$loc=$pl_array[$i][4];
$gender=$pl_array[$i][5];
$listtwo.= "
<tr class=txt>
<td></td>
<td>$name</td>
<td align='center'><img alt=$res_race src='".$img_base.$race."-$gender.gif' height='18' width='18'></td>
<td align='center'><img alt=$res_class src='".$img_base."$class.gif' height='18' width='18'></td>
<td align='center'>$lvl</td>
<td >$loc</td>
</tr>";
$i++;
}
//Realm Three

function make_players_arrayrealmthree(){
global $hostrealmthree, $userrealmthree, $passwordrealmthree, $dbrealmthree, $database_encoding, $pl_array;
$i=0;
$mangos_dbthree = new DBLayer($hostrealmthree, $userrealmthree, $passwordrealmthree, $dbrealmthree);
$mangos_dbthree->query("SET NAMES $database_encoding");
$query = $mangos_dbthree->query("SELECT * FROM `characters` WHERE `online`='1' ORDER BY `name`");
while($result = $mangos_dbthree->fetch_assoc($query))
{
$char_data = explode(' ',$result['data']);
$char_gender = dechex($char_data[36]);
$char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT);
$char_gender = $char_gender{3};
$res_pos=get_zone_name($result['map'], $result['position_x'], $result['position_y']);

$pl_array[$i] = Array($result['name'], $result['race'], $result['class'], $char_data[34], $res_pos, $char_gender);
$i++;
}
$mangos_dbthree->close();
unset($mangos_dbthree);
return $i;
}

$onlineplayersthree=make_players_arrayrealmthree() ;

if (!$sort = &$_GET['s']) $sort=0;
if (!$flag = &$_GET['f']) $flag=0;
if ($flag==0) { $flag=1; $sort_type='<'; }
else { $flag=0; $sort_type='>'; }
$link=$_SERVER['PHP_SELF']."?f=".$flag."&s=";

if (!empty($pl_array))
{
usort($pl_array, create_function('$a, $b', 'if ( $a['.$sort.'] == $b['.$sort.'] ) return 0; if ( $a['.$sort.'] '.$sort_type.' $b['.$sort.'] ) return -1; return 1;'));
}

$listthree="";
$i=0;
while ($i < $onlineplayersthree)
{
$name=$pl_array[$i][0];
$race=$pl_array[$i][1];
$class=$pl_array[$i][2];
$res_race = $def['character_race'][$race];
$res_class = $def['character_class'][$class];
$lvl=$pl_array[$i][3];
$loc=$pl_array[$i][4];
$gender=$pl_array[$i][5];
$listthree.= "
<tr class=txt>
<td></td>
<td>$name</td>
<td align='center'><img alt=$res_race src='".$img_base.$race."-$gender.gif' height='18' width='18'></td>
<td align='center'><img alt=$res_class src='".$img_base."$class.gif' height='18' width='18'></td>
<td align='center'>$lvl</td>
<td >$loc</td>
</tr>";
$i++;
}
//Realm Four

function make_players_arrayrealmfour(){
global $hostrealmfour, $userrealmfour, $passwordrealmfour, $dbrealmfour, $database_encoding, $pl_array;
$i=0;
$mangos_dbfour = new DBLayer($hostrealmfour, $userrealmfour, $passwordrealmfour, $dbrealmfour);
$mangos_dbfour->query("SET NAMES $database_encoding");
$query = $mangos_dbfour->query("SELECT * FROM `characters` WHERE `online`='1' ORDER BY `name`");
while($result = $mangos_dbfour->fetch_assoc($query))
{
$char_data = explode(' ',$result['data']);
$char_gender = dechex($char_data[36]);
$char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT);
$char_gender = $char_gender{3};
$res_pos=get_zone_name($result['map'], $result['position_x'], $result['position_y']);

$pl_array[$i] = Array($result['name'], $result['race'], $result['class'], $char_data[34], $res_pos, $char_gender);
$i++;
}
$mangos_dbfour->close();
unset($mangos_dbfour);
return $i;
}

$onlineplayersfour=make_players_arrayrealmfour();

if (!$sort = &$_GET['s']) $sort=0;
if (!$flag = &$_GET['f']) $flag=0;
if ($flag==0) { $flag=1; $sort_type='<'; }
else { $flag=0; $sort_type='>'; }
$link=$_SERVER['PHP_SELF']."?f=".$flag."&s=";

if (!empty($pl_array))
{
usort($pl_array, create_function('$a, $b', 'if ( $a['.$sort.'] == $b['.$sort.'] ) return 0; if ( $a['.$sort.'] '.$sort_type.' $b['.$sort.'] ) return -1; return 1;'));
}

$listfour="";
$i=0;
while ($i < $onlineplayersfour)
{
$name=$pl_array[$i][0];
$race=$pl_array[$i][1];
$class=$pl_array[$i][2];
$res_race = $def['character_race'][$race];
$res_class = $def['character_class'][$class];
$lvl=$pl_array[$i][3];
$loc=$pl_array[$i][4];
$gender=$pl_array[$i][5];
$listfour.= "
<tr class=txt>
<td></td>
<td>$name</td>
<td align='center'><img alt=$res_race src='".$img_base.$race."-$gender.gif' height='18' width='18'></td>
<td align='center'><img alt=$res_class src='".$img_base."$class.gif' height='18' width='18'></td>
<td align='center'>$lvl</td>
<td >$loc</td>
</tr>";
$i++;
}
$title=get_realm_name();
$titletwo=get_realm_nametwo();
$titlethree=get_realm_namethree();
$titlefour=get_realm_namefour();
$copyright=get_realm_name();
$status=get_realm_name();
$statustwo=get_realm_nametwo();
$statusthree=get_realm_namethree();
$statusfour=get_realm_namefour();
if (test_realm())
{
$title.=(' ('.$onlineplayers.' '.$text["playerson"].')');
$status = "<img alt=Online src='".$img_base."online.gif' height='18' width='18'>";
} else
{
$title.=(' '.$text["off"] );
$status = "<img alt=Offline src='".$img_base."offline.gif' height='18' width='18'>";
}

if (test_realmtwo())
{
$titletwo.=(' ('.$onlineplayerstwo.' '.$text["playerson"].')');
$statustwo = "<img alt=Online src='".$img_base."online.gif' height='18' width='18'>";
} else
{
$titletwo.=(' '.$text["off"] );
$statustwo = "<img alt=Offline src='".$img_base."offline.gif' height='18' width='18'>";
}
if (test_realmthree())
{
$titlethree.=(' ('.$onlineplayersthree.' '.$text["playerson"].')');
$statusthree = "<img alt=Online src='".$img_base."online.gif' height='18' width='18'>";
} else
{
$titlethree.=(' '.$text["off"] );
$statusthree = "<img alt=Offline src='".$img_base."offline.gif' height='18' width='18'>";
}
if (test_realmfour())
{
$titlefour.=(' ('.$onlineplayersfour.' '.$text["playerson"].')');
$statusfour = "<img alt=Online src='".$img_base."online.gif' height='18' width='18'>";
} else
{
$titlefour.=(' '.$text["off"] );
$statusfour = "<img alt=Offline src='".$img_base."offline.gif' height='18' width='18'>";
}
?>