Spora Updated for WoTLK

**volitle** · 11-13-2008

Well i dont know if it was going to be done anytime soon but oh well here it is

ArcEmu Spora - DOWNLOAD NOW!
Aspire Spora - DOWNLOAD NOW!

Demo site, Courtesy of Frost team http://www.frosteamproject.com/spora/
Demo site, Courtesy of Performer http://blackjackjoker.gom-team.com/spora/

I added a wotlk type of background on there can easily be changed.

UPDATED - made it for both aspire and arcemu as they use dfferent flags for some strange reason lol
UPDATED - ArcEmu flag updated now the same as aspire but both are there to save confusion
UPDATED - Added Deathknight icon, should work but if not tell me (Credits to rofldestroyer for the DK icon)

**volitle** · 11-13-2008

lol 13 downloads and not even one thankyou

**TheNlghtmare** · 11-13-2008

I thank you for contributing to MMOwned.

**volitle** · 11-13-2008

lol weeey thanks

**devilat** · 11-14-2008

thank you + rep
lol too many leechers

**Lukas 45** · 11-14-2008

Pics plz

**volitle** · 11-14-2008

its just spora lol non needed

**Retrac** · 11-14-2008

hehe thanks alot i use this and its really good

thanks alot mate +Rep

**alex95.sv** · 11-26-2008

volitle one BIG THANK YOU!

**iotech** · 11-26-2008

Thank you much!

**alex95.sv** · 11-26-2008

Ooops. I have one problem but i can't resolve it ... and here is it

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\xampp\htdocs\index.php on line 463

If you can please help. When i try to register this thing is on the top and in the middle :

Creation of account
test
was not possible !

Please help me. Thank you.

**Lukas 45** · 11-26-2008

post your .php file in [code] tag.

**jang** · 11-26-2008

i would say wrong db selection (wrong table structure), or not permined to access selected db

**alex95.sv** · 11-27-2008

Code:

<?php
/* 
	SPORA for Ascent v1.4
	Simple Page Of Registration of Accounts for Ascent

	It is made in the form of one page with fields of input of the 
	information of an account and the list of players being on a server.
	
	Original Creation by mirage666 for MaNGOS	http://pomm.da.ru/
	
	Modified for Ascent by Kandyman			http://www.burning-wow.com

*/

$lang="en";			// Language ("en" - english, "ru" - russian)
$title="xLs WoW 3.0.3";		// Insert the title of your server here
$host="localhost";		// HOST for Character database
$user="root";			// USER for Character database
$password="****";		// PASS for Character database
$db="characters";			// NAME of Character database
$hostr="localhost";		// HOST for Logonserver database
$userr="root";			// USER for Logonserver database
$passwordr="****";		// PASS for Logonserver database
$dbr="realmd";			// NAME of Logonserver database
$database_encoding = 'CP1251'; 	// Set encoding
$img_base = "img/";		// Image dir
$server = "85.217.219.179";	// Ascent Server Address
$port = "8129";			// Ascent Server Port
$lock_acc=0;			// Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0;			// Registration only one (or more) account from one IP address
				// 0 - not limit, 1 - one acc,  2 - two acc, etc...



Switch ($lang)
{
case "en": 
	$button="create_en.gif";
	$text = Array(
	'acc' => 'Creation of account',
	'create' => 'is completed !',
	'failed' => 'was not possible !',
	'not_all' => 'Fields are filled not all',
	'taken' => 'is already taken !',
	'playerson' => 'players online',
	'name' => 'Account Name',
	'password' => 'Password',
	'ip_limit' => Array('From your IP ',' accounts are already created'),
	
	);
	break; 

}

$maps_a = Array(
	0 => 'Azeroth',
	1 => 'Kalimdor',
	2 => 'UnderMine',
	13 => 'Test zone',
	17 => 'Kalidar',
	30 => 'Alterac Valley',
	33 => 'Shadowfang Keep',
	34 => 'The Stockade',
	35 => 'Stormwind Prison',
	36 => 'Deadmines',
	37 => 'Plains of Snow',
	43 => 'Wailing Caverns',
	44 => 'Monastery Interior',
	47 => 'Razorfen Kraul',
	48 => 'Blackfathom Deeps',
	70 => 'Uldaman',
	90 => 'Gnomeregan',
	109 => 'Sunken Temple',
	129 => 'Razorfen Downs',
	169 => 'Emerald Forest',
	189 => 'Scarlet Monastery',
	209 => 'Zul\'Farrak',
	229 => 'Blackrock Spire',
	230 => 'Blackrock Depths',
	249 => 'Onyxias Lair',
	269 => 'Caverns of Time',
	289 => 'Scholomance',
	309 => 'Zul\'Gurub',
	329 => 'Stratholme',
	349 => 'Maraudon',
	369 => 'Deeprun Tram',
	389 => 'Ragefire Chasm',
	409 => 'The Molten Core',
	429 => 'Dire Maul',
	449 => 'Alliance PVP Barracks',
	450 => 'Horde PVP Barracks',
	451 => 'Development Land',
	469 => 'Blackwing Lair',
	489 => 'Warsong Gulch',
	509 => 'Ruins of Ahn\'Qiraj',
	529 => 'Arathi Basin',
	530 => 'Burning Crusade Zones',
	531 => 'Temple of Ahn\'Qiraj',
	532 => 'Karazhan',
	533 => 'Naxxramas',
	534 => 'Hyjal Past',
	540 => 'Shattered Halls',
	542 => 'Blood Furnace',
	543 => 'Hellfire Ramparts',
	544 => 'Magtheridon\'s Lair',
	545 => 'The Steamvault',
	546 => 'The Black Temple',
	547 => 'The Slave Pens',
	548 => 'Coilfang Resevoir',
	550 => 'The Eye',
	552 => 'The Arcatraz',
	553 => 'The Botanica',
	554 => 'The Mechanar',
	555 => 'Shadow Labyrinth',
	556 => 'Sethekk Halls',
	557 => 'Mana-Tombs',
	558 => 'Auchenai Crypts',
	559 => 'Nagrand Arena',
	560 => 'Hillsbrad Past',
	562 => 'Blade\'s Edge Arena',
	564 => 'Black Temple',
	565 => 'Gruul\'s Lair',
	566 => 'Eye of the Storm',
	568 => 'Zul\'aman',
);

$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&nbsp;Elf',
		11 => 'Draenei',
	),

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

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;
	}
}

function error($message, $file, $line, $db_error = false)
{
	global $siteerrors;
	$s = "\t\t".'Error: <strong>'.$message.'.</strong>'."\n";
	echo $s;
}

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 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 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`");
	$result = $realm_db->fetch_assoc($query);
	$realm_db->close();
	unset($realm_db);
	return($result['name']);
}



if (empty($_POST['username']) and empty($_POST['passw']) and empty($_POST['email'])) 
	{
	$cont='         <TR>
                <TD rowSpan=6><IMG height=110 
                  src="'.$img_base.'pixel.gif" width=15></TD>
                <TD vAlign=center align=left width=190><B 
                  style="FONT-SIZE: 8pt;"><LABEL 
                  for=username>'.$text["name"].':</LABEL>&nbsp;</b><BR><INPUT 
                  id=username style="WIDTH: 175px" tabIndex=1 maxLength=16 
                  size=18 name=username></TD>
                <TD rowSpan=6><IMG height=1 src="'.$img_base.'pixel.gif" width=15></TD></TR>
              <TR><TD width=190 height=1></TD></TR>
              <TR><TD width=190 height=1></TD></TR>
              <TR>
                <TD vAlign=center align=left width=190><B 
                  style="FONT-SIZE: 8pt;"><LABEL 
                  for=passw>'.$text["password"].':</LABEL>&nbsp;</B><BR><INPUT id=passw 
                  style="WIDTH: 175px" tabIndex=2 type=password maxLength=16 
                  size=18 name=passw></TD></TR>
              <TR>
                <TD vAlign=center align=left width=190><B 
                  style="FONT-SIZE: 8pt;"><LABEL 
                  for=email>E-mail:</LABEL>&nbsp;</B><BR><INPUT id=email 
                  style="WIDTH: 175px" tabIndex=2 maxLength=50 
                  size=18 name=email></TD></TR>
              <TR>
                <TD align=left>
                  <TABLE cellSpacing=0 cellPadding=0 border=0>
                    <TBODY>
                    <TR>
                      <TD><B style="FONT-SIZE: 8pt;">WoTLK Enabled?&nbsp</b>
		      <input type="checkbox" name="flags" value="1" checked></td>
                      <TD></TD>
                      <TD></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD align=left colSpan=3>
                  <TABLE cellSpacing=0 cellPadding=0 border=0>
                    <TBODY>
                    <TR>
                      <TD><IMG height=39 
                        src="'.$img_base.'pixel.gif" width=19></TD>
                      <TD><INPUT class=button 
                        style="WIDTH: 168px; HEIGHT: 39px" tabIndex=3 type=image 
                        alt=Create src="'.$img_base.$button.'" 
                        value=Create border=0></TD>
					</TR></TBODY></TABLE></TD></TR>';
	} 
	elseif  (empty($_POST['username']) or empty($_POST['passw']) or empty($_POST['email'])) 
	{

	$cont='<TR><TD rowSpan=6><IMG height=152 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL class=error>
	'.$text["not_all"].'
	<br><br><br><br></SMALL></TD></TD></TR><br>';

	}
	else
	{
	$username = htmlspecialchars(trim("$_POST[username]"));
	$passw = trim($_POST['passw']);
	$email = htmlspecialchars(trim($_POST['email']));
	$ip = getenv('REMOTE_ADDR');
// сделать проверку на неполучение ипа

	$realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr);
	$realm_db->query("SET NAMES $database_encoding");

if ($_POST['flags'] == 1){$wotlk = "36";} else {$wotlk = "8";}

$uniqueuser = $realm_db->query("SELECT `login` FROM `accounts` WHERE `login` = '$username'");
$logincheck = mysql_num_rows($uniqueuser);

$ip_cr=0;
if ($lock_reg!=0){
  $query = $realm_db->query("SELECT `lastip` FROM `accounts`  WHERE `lastip`='$ip'");
  while($result = $realm_db->fetch_assoc($query)) $ip_cr++;
}

if (($ip_cr>=$lock_reg) && ($lock_reg!=0))
{
		$cont='<TR><TD rowSpan=6><IMG height=152 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL class=error>
'.$text["ip_limit"][0].$ip.'<br>'.$ip_cr.$text["ip_limit"][1].'
<br><br><br><br></SMALL></TD></TD></TR><br>';
	}
	elseif ($logincheck > 0)
	{
        $cont='<TR><TD rowSpan=6><IMG height=152 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL class=error>
'.$text["name"].'<br><strong>'.$username.'</strong><br>'.$text["taken"].'
<br><br><br><br></SMALL></TD></TD></TR><br>';
        }
	else
	{
	if($realm_db->query("INSERT INTO `accounts` (`login`,`password`,`email`,`lastip`,`gm`,`banned`,`flags`) VALUES ('$username','$passw','$email','$ip','0','0','$wotlk')"))
		{
		$cont='<TR><TD rowSpan=6><IMG height=152 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL>
'.$text["acc"].'<br><strong>'.$username.'</strong><br>'.$text["create"].'
<br><br><br><br></SMALL></TD></TD></TR><br>';
		}
		else
		{
		$cont='<TR><TD rowSpan=6><IMG height=152 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL class=error>
'.$text["acc"].'<br><strong>'.$username.'</strong><br>'.$text["failed"].'
<br><br><br><br></SMALL></TD></TD></TR><br>';
		}
}


	
	$realm_db->close();
	unset($realm_db);
	}



function make_players_array(){
	global $host, $user, $password, $db, $database_encoding, $pl_array;
$i=0;
	$ascent_db = new DBLayer($host, $user, $password, $db);
	$ascent_db->query("SET NAMES $database_encoding");
	$query = $ascent_db->query("SELECT * FROM `characters` WHERE `online`='1' ORDER BY `name`");
	while($result = $ascent_db->fetch_assoc($query))
	{
		$char_data = ($result['level']);
		$char_gender = ($result['gender']);
		$res_pos=get_zone_name($result['mapId'], $result['positionX'], $result['positionY']);

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

$onlineplayers=make_players_array();

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;'));
	}

$list="";
$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];
	$list.= "
				<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++;
	}

if (test_realm())
	{
	$title.=(' ('.$onlineplayers.' '.$text["playerson"].')');
	} else
	{
	$title.=(' '.$text["off"]);
	}


// Main part !!!
?>
<HTML><HEAD><META HTTP-EQUIV="Pragma" CONTENT="no-cache"><TITLE><?php print $title ?></TITLE>
<META http-equiv=Content-Type content="text/html; charset=windows-1251"><LINK 
id=bnetstyle href="<?php print $img_base ?>style.css" type=text/css 
rel=stylesheet>
<SCRIPT language=javascript>
  <!--
    var styleSheet;
    var agt     = navigator.userAgent.toLowerCase();
    var appVer  = navigator.appVersion.toLowerCase();
    var verInt  = parseInt(appVer);
    var ie      = (appVer.indexOf('msie') != -1);
    var opera   = (agt.indexOf('opera') != -1);
    var mozilla = ((agt.indexOf('mozilla')!=-1) && (agt.indexOf('opera')==-1)
      && (agt.indexOf('spoofer')==-1) && (agt.indexOf('compatible') == -1)
      && (agt.indexOf('webtv')==-1) && (agt.indexOf('hotjava')==-1));
    var ns4     = (mozilla && (verInt == 4));

    if (ie && !opera) {
      document.styleSheets["bnetstyle"].addRule ("input", "background-color: #040D1A");
      document.styleSheets["bnetstyle"].addRule ("input", "border-style: solid");
      document.styleSheets["bnetstyle"].addRule ("input", "border-width: 1px");
      document.styleSheets["bnetstyle"].addRule ("input", "border-color: #7F7F7F");
      document.styleSheets["bnetstyle"].addRule ("input", "color: #FFAC04");

      document.styleSheets["bnetstyle"].addRule ("textarea", "background-color: #040D1A");
      document.styleSheets["bnetstyle"].addRule ("textarea", "border-style: solid");
      document.styleSheets["bnetstyle"].addRule ("textarea", "border-width: 1px");
      document.styleSheets["bnetstyle"].addRule ("textarea", "border-color: #7F7F7F");
      document.styleSheets["bnetstyle"].addRule ("textarea", "color: #FFAC04");

      document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-Base-Color: #012158");
      document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-Arrow-Color: #7F7F7F");
      document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-3dLight-Color: #7F7F7F");
      document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-DarkShadow-Color: black");
      document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-Highlight-Color: black");
      document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-Shadow-Color: #00B3FF");

      document.styleSheets["bnetstyle"].addRule ("select", "background-color: #040D1A");
      document.styleSheets["bnetstyle"].addRule ("select", "color: #FFAC04");

      document.styleSheets["bnetstyle"].addRule ("select.gray", "background-color: #040D1A");
      document.styleSheets["bnetstyle"].addRule ("select.gray", "color: #FFAC04");

      document.styleSheets["bnetstyle"].addRule ("ul.thread", "margin-left: 22px;");
    }
  //-->
  </SCRIPT>
</HEAD>
<BODY text=#cccc99 vLink=#aaaaaa link=#ffffbb bgColor=#000000 leftMargin=0 
topMargin=0 marginheight="0" marginwidth="0">
<FORM name=login_form method=post>
<TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0>
  <TBODY>
  <TR>
    <TD align=middle>
      <TABLE cellSpacing=0 cellPadding=0 background="<?php print $img_base ?>back_create.jpg" border=0 style="background-repeat: no-repeat;">
        <TBODY>
        <TR>
          <TD vAlign=top>
            <DIV style="POSITION: relative">
            <DIV 

            style="LEFT: 130px; WIDTH: 400px; POSITION: absolute; TOP: 0px"></DIV></DIV></TD>
          <TD><IMG height=169 src="<?php print $img_base ?>pixel.gif" 
          width=1></TD>
          <TD></TD></TR>
        <TR>
          <TD><IMG height=1 src="<?php print $img_base ?>pixel.gif" 
          width=203></TD>
          <TD>
		  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
		  <TBODY>
            <?php print $cont ?></TBODY></TABLE></TD>
          <TD><IMG height=1 src="<?php print $img_base ?>pixel.gif" 
          width=217></TD></TR>
        <TR>
          <TD colSpan=3>
            <TABLE cellSpacing=0 cellPadding=0 border=0>
              <TBODY>
              <TR>
                <TD colSpan=3><IMG height=17 
                  src="<?php print $img_base ?>pixel.gif" width=1></TD></TR>
	      <TR>
                <TD width=106><IMG height=1 
                  src="<?php print $img_base ?>pixel.gif" width=106></TD>
                <TD width=410><SMALL>
			
<class=text>
Welcome to <b>xLs GN WorldOfWarcraft 3.0.3 servrer</b>, Our Dedicated team hopes you enjoy your time with us and has a very joyful stay and we do welcome anyone with open arms. To Join just simply create and account and set your realmlist to <b>85.217.219.179</b>, then wait 5 - 10 minutes fo you account to get processed and then log in, simple.<p><li>To get back to the homepage - <a href="url here">Click here</a><br>

<table cellpadding='3' cellspacing='0' align='center'>
				<tbody>

<tr><td class='txt' align='center' colspan='6' nowrap='nowrap'><IMG height=1 src='<?php print $img_base ?>pixel.gif' width=400></td></tr>				<?php print $list ?>				
				</tbody>
</table>

                  </SMALL></TD>
                <TD width=124><IMG height=1 
                  src="<?php print $img_base ?>pixel.gif" width=124></TD></TR>
              <TR>
                <TD colSpan=3><IMG height=100 
                  src="<?php print $img_base ?>pixel.gif" 
            width=1></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></FORM></BODY></HTML>

This is it

**volitle** · 11-27-2008

Originally Posted by alex95.sv

Code:

<?php
/* 
    SPORA for Ascent v1.4
    Simple Page Of Registration of Accounts for Ascent

    It is made in the form of one page with fields of input of the 
    information of an account and the list of players being on a server.
    
    Original Creation by mirage666 for MaNGOS    http://pomm.da.ru/
    
    Modified for Ascent by Kandyman            http://www.burning-wow.com

*/

$lang="en";            // Language ("en" - english, "ru" - russian)
$title="xLs WoW 3.0.3";        // Insert the title of your server here
$host="localhost";        // HOST for Character database
$user="root";            // USER for Character database
$password="****";        // PASS for Character database
$db="characters";            // NAME of Character database
$hostr="localhost";        // HOST for Logonserver database
$userr="root";            // USER for Logonserver database
$passwordr="****";        // PASS for Logonserver database
$dbr="realmd";            // NAME of Logonserver database
$database_encoding = 'CP1251';     // Set encoding
$img_base = "img/";        // Image dir
$server = "85.217.219.179";    // Ascent Server Address
$port = "8129";            // Ascent Server Port
$lock_acc=0;            // Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0;            // Registration only one (or more) account from one IP address
                // 0 - not limit, 1 - one acc,  2 - two acc, etc...



Switch ($lang)
{
case "en": 
    $button="create_en.gif";
    $text = Array(
    'acc' => 'Creation of account',
    'create' => 'is completed !',
    'failed' => 'was not possible !',
    'not_all' => 'Fields are filled not all',
    'taken' => 'is already taken !',
    'playerson' => 'players online',
    'name' => 'Account Name',
    'password' => 'Password',
    'ip_limit' => Array('From your IP ',' accounts are already created'),
    
    );
    break; 

}

$maps_a = Array(
    0 => 'Azeroth',
    1 => 'Kalimdor',
    2 => 'UnderMine',
    13 => 'Test zone',
    17 => 'Kalidar',
    30 => 'Alterac Valley',
    33 => 'Shadowfang Keep',
    34 => 'The Stockade',
    35 => 'Stormwind Prison',
    36 => 'Deadmines',
    37 => 'Plains of Snow',
    43 => 'Wailing Caverns',
    44 => 'Monastery Interior',
    47 => 'Razorfen Kraul',
    48 => 'Blackfathom Deeps',
    70 => 'Uldaman',
    90 => 'Gnomeregan',
    109 => 'Sunken Temple',
    129 => 'Razorfen Downs',
    169 => 'Emerald Forest',
    189 => 'Scarlet Monastery',
    209 => 'Zul\'Farrak',
    229 => 'Blackrock Spire',
    230 => 'Blackrock Depths',
    249 => 'Onyxias Lair',
    269 => 'Caverns of Time',
    289 => 'Scholomance',
    309 => 'Zul\'Gurub',
    329 => 'Stratholme',
    349 => 'Maraudon',
    369 => 'Deeprun Tram',
    389 => 'Ragefire Chasm',
    409 => 'The Molten Core',
    429 => 'Dire Maul',
    449 => 'Alliance PVP Barracks',
    450 => 'Horde PVP Barracks',
    451 => 'Development Land',
    469 => 'Blackwing Lair',
    489 => 'Warsong Gulch',
    509 => 'Ruins of Ahn\'Qiraj',
    529 => 'Arathi Basin',
    530 => 'Burning Crusade Zones',
    531 => 'Temple of Ahn\'Qiraj',
    532 => 'Karazhan',
    533 => 'Naxxramas',
    534 => 'Hyjal Past',
    540 => 'Shattered Halls',
    542 => 'Blood Furnace',
    543 => 'Hellfire Ramparts',
    544 => 'Magtheridon\'s Lair',
    545 => 'The Steamvault',
    546 => 'The Black Temple',
    547 => 'The Slave Pens',
    548 => 'Coilfang Resevoir',
    550 => 'The Eye',
    552 => 'The Arcatraz',
    553 => 'The Botanica',
    554 => 'The Mechanar',
    555 => 'Shadow Labyrinth',
    556 => 'Sethekk Halls',
    557 => 'Mana-Tombs',
    558 => 'Auchenai Crypts',
    559 => 'Nagrand Arena',
    560 => 'Hillsbrad Past',
    562 => 'Blade\'s Edge Arena',
    564 => 'Black Temple',
    565 => 'Gruul\'s Lair',
    566 => 'Eye of the Storm',
    568 => 'Zul\'aman',
);

$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&nbsp;Elf',
        11 => 'Draenei',
    ),

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

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;
    }
}

function error($message, $file, $line, $db_error = false)
{
    global $siteerrors;
    $s = "\t\t".'Error: <strong>'.$message.'.</strong>'."\n";
    echo $s;
}

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 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 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`");
    $result = $realm_db->fetch_assoc($query);
    $realm_db->close();
    unset($realm_db);
    return($result['name']);
}



if (empty($_POST['username']) and empty($_POST['passw']) and empty($_POST['email'])) 
    {
    $cont='         <TR>
                <TD rowSpan=6><IMG height=110 
                  src="'.$img_base.'pixel.gif" width=15></TD>
                <TD vAlign=center align=left width=190><B 
                  style="FONT-SIZE: 8pt;"><LABEL 
                  for=username>'.$text["name"].':</LABEL>&nbsp;</b><BR><INPUT 
                  id=username style="WIDTH: 175px" tabIndex=1 maxLength=16 
                  size=18 name=username></TD>
                <TD rowSpan=6><IMG height=1 src="'.$img_base.'pixel.gif" width=15></TD></TR>
              <TR><TD width=190 height=1></TD></TR>
              <TR><TD width=190 height=1></TD></TR>
              <TR>
                <TD vAlign=center align=left width=190><B 
                  style="FONT-SIZE: 8pt;"><LABEL 
                  for=passw>'.$text["password"].':</LABEL>&nbsp;</B><BR><INPUT id=passw 
                  style="WIDTH: 175px" tabIndex=2 type=password maxLength=16 
                  size=18 name=passw></TD></TR>
              <TR>
                <TD vAlign=center align=left width=190><B 
                  style="FONT-SIZE: 8pt;"><LABEL 
                  for=email>E-mail:</LABEL>&nbsp;</B><BR><INPUT id=email 
                  style="WIDTH: 175px" tabIndex=2 maxLength=50 
                  size=18 name=email></TD></TR>
              <TR>
                <TD align=left>
                  <TABLE cellSpacing=0 cellPadding=0 border=0>
                    <TBODY>
                    <TR>
                      <TD><B style="FONT-SIZE: 8pt;">WoTLK Enabled?&nbsp</b>
              <input type="checkbox" name="flags" value="1" checked></td>
                      <TD></TD>
                      <TD></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD align=left colSpan=3>
                  <TABLE cellSpacing=0 cellPadding=0 border=0>
                    <TBODY>
                    <TR>
                      <TD><IMG height=39 
                        src="'.$img_base.'pixel.gif" width=19></TD>
                      <TD><INPUT class=button 
                        style="WIDTH: 168px; HEIGHT: 39px" tabIndex=3 type=image 
                        alt=Create src="'.$img_base.$button.'" 
                        value=Create border=0></TD>
                    </TR></TBODY></TABLE></TD></TR>';
    } 
    elseif  (empty($_POST['username']) or empty($_POST['passw']) or empty($_POST['email'])) 
    {

    $cont='<TR><TD rowSpan=6><IMG height=152 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL class=error>
    '.$text["not_all"].'
    <br><br><br><br></SMALL></TD></TD></TR><br>';

    }
    else
    {
    $username = htmlspecialchars(trim("$_POST[username]"));
    $passw = trim($_POST['passw']);
    $email = htmlspecialchars(trim($_POST['email']));
    $ip = getenv('REMOTE_ADDR');
// сделать проверку на неполучение ипа

    $realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr);
    $realm_db->query("SET NAMES $database_encoding");

if ($_POST['flags'] == 1){$wotlk = "36";} else {$wotlk = "8";}

$uniqueuser = $realm_db->query("SELECT `login` FROM `accounts` WHERE `login` = '$username'");
$logincheck = mysql_num_rows($uniqueuser);

$ip_cr=0;
if ($lock_reg!=0){
  $query = $realm_db->query("SELECT `lastip` FROM `accounts`  WHERE `lastip`='$ip'");
  while($result = $realm_db->fetch_assoc($query)) $ip_cr++;
}

if (($ip_cr>=$lock_reg) && ($lock_reg!=0))
{
        $cont='<TR><TD rowSpan=6><IMG height=152 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL class=error>
'.$text["ip_limit"][0].$ip.'<br>'.$ip_cr.$text["ip_limit"][1].'
<br><br><br><br></SMALL></TD></TD></TR><br>';
    }
    elseif ($logincheck > 0)
    {
        $cont='<TR><TD rowSpan=6><IMG height=152 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL class=error>
'.$text["name"].'<br><strong>'.$username.'</strong><br>'.$text["taken"].'
<br><br><br><br></SMALL></TD></TD></TR><br>';
        }
    else
    {
    if($realm_db->query("INSERT INTO `accounts` (`login`,`password`,`email`,`lastip`,`gm`,`banned`,`flags`) VALUES ('$username','$passw','$email','$ip','0','0','$wotlk')"))
        {
        $cont='<TR><TD rowSpan=6><IMG height=152 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL>
'.$text["acc"].'<br><strong>'.$username.'</strong><br>'.$text["create"].'
<br><br><br><br></SMALL></TD></TD></TR><br>';
        }
        else
        {
        $cont='<TR><TD rowSpan=6><IMG height=152 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL class=error>
'.$text["acc"].'<br><strong>'.$username.'</strong><br>'.$text["failed"].'
<br><br><br><br></SMALL></TD></TD></TR><br>';
        }
}


    
    $realm_db->close();
    unset($realm_db);
    }



function make_players_array(){
    global $host, $user, $password, $db, $database_encoding, $pl_array;
$i=0;
    $ascent_db = new DBLayer($host, $user, $password, $db);
    $ascent_db->query("SET NAMES $database_encoding");
    $query = $ascent_db->query("SELECT * FROM `characters` WHERE `online`='1' ORDER BY `name`");
    while($result = $ascent_db->fetch_assoc($query))
    {
        $char_data = ($result['level']);
        $char_gender = ($result['gender']);
        $res_pos=get_zone_name($result['mapId'], $result['positionX'], $result['positionY']);

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

$onlineplayers=make_players_array();

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;'));
    }

$list="";
$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];
    $list.= "
                <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++;
    }

if (test_realm())
    {
    $title.=(' ('.$onlineplayers.' '.$text["playerson"].')');
    } else
    {
    $title.=(' '.$text["off"]);
    }


// Main part !!!
?>
<HTML><HEAD><META HTTP-EQUIV="Pragma" CONTENT="no-cache"><TITLE><?php print $title ?></TITLE>
<META http-equiv=Content-Type content="text/html; charset=windows-1251"><LINK 
id=bnetstyle href="<?php print $img_base ?>style.css" type=text/css 
rel=stylesheet>
<SCRIPT language=javascript>
  <!--
    var styleSheet;
    var agt     = navigator.userAgent.toLowerCase();
    var appVer  = navigator.appVersion.toLowerCase();
    var verInt  = parseInt(appVer);
    var ie      = (appVer.indexOf('msie') != -1);
    var opera   = (agt.indexOf('opera') != -1);
    var mozilla = ((agt.indexOf('mozilla')!=-1) && (agt.indexOf('opera')==-1)
      && (agt.indexOf('spoofer')==-1) && (agt.indexOf('compatible') == -1)
      && (agt.indexOf('webtv')==-1) && (agt.indexOf('hotjava')==-1));
    var ns4     = (mozilla && (verInt == 4));

    if (ie && !opera) {
      document.styleSheets["bnetstyle"].addRule ("input", "background-color: #040D1A");
      document.styleSheets["bnetstyle"].addRule ("input", "border-style: solid");
      document.styleSheets["bnetstyle"].addRule ("input", "border-width: 1px");
      document.styleSheets["bnetstyle"].addRule ("input", "border-color: #7F7F7F");
      document.styleSheets["bnetstyle"].addRule ("input", "color: #FFAC04");

      document.styleSheets["bnetstyle"].addRule ("textarea", "background-color: #040D1A");
      document.styleSheets["bnetstyle"].addRule ("textarea", "border-style: solid");
      document.styleSheets["bnetstyle"].addRule ("textarea", "border-width: 1px");
      document.styleSheets["bnetstyle"].addRule ("textarea", "border-color: #7F7F7F");
      document.styleSheets["bnetstyle"].addRule ("textarea", "color: #FFAC04");

      document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-Base-Color: #012158");
      document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-Arrow-Color: #7F7F7F");
      document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-3dLight-Color: #7F7F7F");
      document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-DarkShadow-Color: black");
      document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-Highlight-Color: black");
      document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-Shadow-Color: #00B3FF");

      document.styleSheets["bnetstyle"].addRule ("select", "background-color: #040D1A");
      document.styleSheets["bnetstyle"].addRule ("select", "color: #FFAC04");

      document.styleSheets["bnetstyle"].addRule ("select.gray", "background-color: #040D1A");
      document.styleSheets["bnetstyle"].addRule ("select.gray", "color: #FFAC04");

      document.styleSheets["bnetstyle"].addRule ("ul.thread", "margin-left: 22px;");
    }
  //-->
  </SCRIPT>
</HEAD>
<BODY text=#cccc99 vLink=#aaaaaa link=#ffffbb bgColor=#000000 leftMargin=0 
topMargin=0 marginheight="0" marginwidth="0">
<FORM name=login_form method=post>
<TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0>
  <TBODY>
  <TR>
    <TD align=middle>
      <TABLE cellSpacing=0 cellPadding=0 background="<?php print $img_base ?>back_create.jpg" border=0 style="background-repeat: no-repeat;">
        <TBODY>
        <TR>
          <TD vAlign=top>
            <DIV style="POSITION: relative">
            <DIV 

            style="LEFT: 130px; WIDTH: 400px; POSITION: absolute; TOP: 0px"></DIV></DIV></TD>
          <TD><IMG height=169 src="<?php print $img_base ?>pixel.gif" 
          width=1></TD>
          <TD></TD></TR>
        <TR>
          <TD><IMG height=1 src="<?php print $img_base ?>pixel.gif" 
          width=203></TD>
          <TD>
          <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
          <TBODY>
            <?php print $cont ?></TBODY></TABLE></TD>
          <TD><IMG height=1 src="<?php print $img_base ?>pixel.gif" 
          width=217></TD></TR>
        <TR>
          <TD colSpan=3>
            <TABLE cellSpacing=0 cellPadding=0 border=0>
              <TBODY>
              <TR>
                <TD colSpan=3><IMG height=17 
                  src="<?php print $img_base ?>pixel.gif" width=1></TD></TR>
          <TR>
                <TD width=106><IMG height=1 
                  src="<?php print $img_base ?>pixel.gif" width=106></TD>
                <TD width=410><SMALL>
            
<class=text>
Welcome to <b>xLs GN WorldOfWarcraft 3.0.3 servrer</b>, Our Dedicated team hopes you enjoy your time with us and has a very joyful stay and we do welcome anyone with open arms. To Join just simply create and account and set your realmlist to <b>85.217.219.179</b>, then wait 5 - 10 minutes fo you account to get processed and then log in, simple.<p><li>To get back to the homepage - <a href="url here">Click here</a><br>

<table cellpadding='3' cellspacing='0' align='center'>
                <tbody>

<tr><td class='txt' align='center' colspan='6' nowrap='nowrap'><IMG height=1 src='<?php print $img_base ?>pixel.gif' width=400></td></tr>                <?php print $list ?>                
                </tbody>
</table>

                  </SMALL></TD>
                <TD width=124><IMG height=1 
                  src="<?php print $img_base ?>pixel.gif" width=124></TD></TR>
              <TR>
                <TD colSpan=3><IMG height=100 
                  src="<?php print $img_base ?>pixel.gif" 
            width=1></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></FORM></BODY></HTML>

This is it

this is for ascent/aspire/arcemu not mangos

ive updated it for the different flags also i will make a mangos version for you

Shout-Out

User Tag List

Thread: Spora Updated for WoTLK

Thread Tools

Search Thread

Spora Updated for WoTLK

Similar Threads

[Release] Project Silvermoon Fundatabase, Update for NCDB 0.2.3

SQL UPDATES for 2.1-2.3

[Release] Project Silvermoon Fundatabase, Update for NCDB 0.2.2

Update for Free WoW exploit users..

OwnedCore Forums

casino

CoreCoins

My OwnedCore

About Us

Casino