What am i doing wrong this time?

**Snailz** · 01-01-2008

Ok so i want to make a regisration page for my server with no hamachi IP.

But when i set my live site and my IP or the adress it cant connects any help?

Index.php:

Code:

<?php
/* 
    SPORA for Antrix v1.32
    Simple Page Of Registration of Accounts for Antrix

    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 Antrix by Kandyman            http://www.burning-wow.com

*/

$lang="en";            // Language ("en" - english, "ru" - russian)
$host="localhost";        // HOST for Antrix database
$user="root";            // USER for Antrix database
$password="ascent";        // PASS for Antrix database
$db="ascent";            // NAME of Antrix database
$hostr="localhost";        // HOST for Login database
$userr="root";            // USER for Login database
$passwordr="ascent";        // PASS for Login database
$dbr="logon";            // NAME of Login database
$database_encoding = 'CP1251';     // Set encoding
$img_base = "img/";        // Image dir
$server = "wowepic.servegame.org";        // Antrix Server Address
$port = "8129";            // Antrix Server Port
$title="WoWepic";        // Insert the title of your server here
$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',
    'off' => 'is offline',
    'name' => 'Account Name',
    'password' => 'Password',
    'ip_limit' => Array('From your IP ',' accounts are already created'),
    'char' => Array('Name','Race','Class','LvL','Location'),
    );
    break; 
case "ru": 
    $button="create_ru.gif";
    $text = Array(
    'acc' =>     'Ñîçäàíèå àêêàóíòà',
    'create' => 'çàâåðøåíî !',
    'failed' => 'íåâîçìîæíî !',
    'not_all' => 'Çàïîëíåíû íå âñå ïîëÿ',
    'taken' => 'is already taken !',
    'playerson' => 'èãðîêîâ íà ñåðâåðå',
    'off' => 'ñåé÷àñ îòêëþ÷åí',
    'name' => 'Èìÿ Àêêàóíòà',
    'password' => 'Ïàðîëü',
    'ip_limit' => Array('Ñ âàøåãî IP ',' àêêàóíòîâ óæå ñîçäàíî'),
    'char' => Array('Ïåðñîíàæ','**àñà','Êëàññ','ËâË','**àñïîëîæåíèå'),
    );
    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;">Burning Crusade 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){$tbc = "8";} else {$tbc = "0";}

$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','$tbc')"))
        {
        $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;
    $mangos_db = new DBLayer($host, $user, $password, $db);
    $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 = ($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++;
    }
    $mangos_db->close();
    unset($mangos_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>
            
<strong class=title><center><?php print $title ?></center></strong><br>

<table cellpadding='3' cellspacing='0' align='center'>
                <tbody>
<tr class=title>
            <td align='left' nowrap='nowrap' width=50></td>
            <td align='left' nowrap='nowrap' width=60><a href="<?php print $link.'0">'.$text['char'][0] ?></a></td>
            <td align='center' nowrap='nowrap' width=40><a href="<?php print $link.'1">'.$text['char'][1] ?></a></td>
            <td align='center' nowrap='nowrap' width=40><a href="<?php print $link.'2">'.$text['char'][2] ?></a></td>
            <td align='center' nowrap='nowrap' width=40><a href="<?php print $link.'3">'.$text['char'][3] ?></a></td>
            <td align='left' nowrap='nowrap' width=100><a href="<?php print $link.'4">'.$text['char'][4] ?></a></td>
                </tr>
<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>

Config.php:
<?php

Code:

$mosConfig_MetaAuthor = '1';
$mosConfig_MetaDesc = 'Joomla - the dynamic portal engine and content management system';
$mosConfig_MetaKeys = 'Joomla, joomla';
$mosConfig_MetaTitle = '1';
$mosConfig_absolute_path = 'C:/AC Web Ultimate Repack/Server/htdocs';
$mosConfig_admin_expired = '1';
$mosConfig_allowUserRegistration = '0';
$mosConfig_back_button = '1';
$mosConfig_cachepath = 'C:/AC Web Ultimate Repack/Server/htdocs/cache';
$mosConfig_cachetime = '900';
$mosConfig_caching = '0';
$mosConfig_db = 'joomla';
$mosConfig_dbprefix = 'jos_';
$mosConfig_debug = '0';
$mosConfig_dirperms = '';
$mosConfig_editor = 'tinymce';
$mosConfig_enable_log_items = '0';
$mosConfig_enable_log_searches = '0';
$mosConfig_enable_stats = '0';
$mosConfig_error_message = 'This site is temporarily unavailable.<br /> Please notify the System Administrator';
$mosConfig_error_reporting = '-1';
$mosConfig_favicon = 'favicon.ico';
$mosConfig_fileperms = '';
$mosConfig_fromname = 'AC Web Ultimate Repack';
$mosConfig_frontend_login = '1';
$mosConfig_frontend_userparams = '1';
$mosConfig_gzip = '0';
$mosConfig_helpurl = 'http://help.joomla.org';
$mosConfig_hideAuthor = '0';
$mosConfig_hideCreateDate = '0';
$mosConfig_hideEmail = '0';
$mosConfig_hideModifyDate = '0';
$mosConfig_hidePdf = '0';
$mosConfig_hidePrint = '0';
$mosConfig_hits = '1';
$mosConfig_host = 'localhost';
$mosConfig_icons = '1';
$mosConfig_item_navigation = '1';
$mosConfig_lang = 'english';
$mosConfig_lifetime = '900';
$mosConfig_link_titles = '0';
$mosConfig_list_limit = '30';
$mosConfig_live_site = 'http://90.242.6.173';
$mosConfig_locale = 'en_GB';
$mosConfig_mailer = 'mail';
$mosConfig_mailfrom = '[email protected]';
$mosConfig_multilingual_support = '0';
$mosConfig_multipage_toc = '1';
$mosConfig_offline = '0';
$mosConfig_offline_message = 'This site is down for maintenance.<br /> Please check back again soon.';
$mosConfig_offset = '-1';
$mosConfig_offset_user = '0';
$mosConfig_pagetitles = '1';
$mosConfig_password = 'ascent';
$mosConfig_readmore = '1';
$mosConfig_secret = 'neuJlbcY2kPMX376';
$mosConfig_sef = '0';
$mosConfig_sendmail = '/usr/sbin/sendmail';
$mosConfig_session_life_admin = '1800';
$mosConfig_session_type = '0';
$mosConfig_shownoauth = '0';
$mosConfig_sitename = 'WowEpic';
$mosConfig_smtpauth = '0';
$mosConfig_smtphost = 'localhost';
$mosConfig_smtppass = '';
$mosConfig_smtpuser = '';
$mosConfig_uniquemail = '1';
$mosConfig_user = 'root';
$mosConfig_useractivation = '0';
$mosConfig_vote = '0';
setlocale (LC_TIME, $mosConfig_locale);
?>

**Snailz** · 01-01-2008

*Bump* For replys

**Snailz** · 01-01-2008

*nudge**bump*

**Performer** · 01-01-2008

Hmm try this

<?php
/*
SPORA for Antrix v1.32
Simple Page Of Registration of Accounts for Antrix

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 Categories

Modified for Antrix by Kandyman Burning WoW

*/

$lang="en"; // Language ("en" - english, "ru" - russian)
$host="wowepic.servegame.org
"; // HOST for Antrix database
$user="root"; // USER for Antrix database
$password="ascent"; // PASS for Antrix database
$db="ascent"; // NAME of Antrix database
$hostr="wowepic.servegame.org
"; // HOST for Login database
$userr="root"; // USER for Login database
$passwordr="ascent"; // PASS for Login database
$dbr="logon(Might Be Ascent)"; // NAME of Login database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "wowepic.servegame.org"; // Antrix Server Address
$port = "8129"; // Antrix Server Port
$title="WoWepic"; // Insert the title of your server here
$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',
'off' => 'is offline',
'name' => 'Account Name',
'password' => 'Password',
'ip_limit' => Array('From your IP ',' accounts are already created'),
'char' => Array('Name','Race','Class','LvL','Location'),
);
break;
case "ru":
$button="create_ru.gif";
$text = Array(
'acc' => 'Ñîçäàíèå àêêàóíòà',
'create' => 'çàâåðøåíî !',
'failed' => 'íåâîçìîæíî !',
'not_all' => 'Çàïîëíåíû íå âñå ïîëÿ',
'taken' => 'is already taken !',
'playerson' => 'èãðîêîâ íà ñåðâåðå',
'off' => 'ñåé÷àñ îòêëþ÷åí',
'name' => 'Èìÿ Àêêàóíòà',
'password' => 'Ïàðîëü',
'ip_limit' => Array('Ñ âàøåãî IP ',' àêêàóíòîâ óæå ñîçäàíî'),
'char' => Array('Ïåðñîíàæ','**àñà','Êëàññ','ËâË','**àñïîëîæåí� �å'),
);
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',3

,
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',2

,
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',

,
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',163

,
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',61

,
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',14

,
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',351

,
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 Elf',
5 => 'Undead',
6 => 'Tauren',
7 => 'Gnome',
8 => 'Troll',
9 => 'Goblin',
10 => 'Blood 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> </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> </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> </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;">Burning Crusade 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){$tbc = "8";} else {$tbc = "0";}

$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','$tbc')"))
{
$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;
$mangos_db = new DBLayer($host, $user, $password, $db);
$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 = ($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++;
}
$mangos_db->close();
unset($mangos_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>

</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>

<strong class=title><center><?php print $title ?></center></strong><br>

<table cellpadding='3' cellspacing='0' align='center'>
<tbody>
<tr class=title>
<td align='left' nowrap='nowrap' width=50></td>
<td align='left' nowrap='nowrap' width=60><a href="<?php print $link.'0">'.$text['char'][0] ?></a></td>
<td align='center' nowrap='nowrap' width=40><a href="<?php print $link.'1">'.$text['char'][1] ?></a></td>
<td align='center' nowrap='nowrap' width=40><a href="<?php print $link.'2">'.$text['char'][2] ?></a></td>
<td align='center' nowrap='nowrap' width=40><a href="<?php print $link.'3">'.$text['char'][3] ?></a></td>
<td align='left' nowrap='nowrap' width=100><a href="<?php print $link.'4">'.$text['char'][4] ?></a></td>
</tr>
<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>

**~~Illidan1~~** · 01-01-2008

Umm, Yimo, could you please put that in a Coded Message

**Performer** · 01-01-2008

Soz its being gay and wont let me put it in a code box

**Performer** · 01-01-2008

When i try i keep getting some kinda web error -.-

**Snailz** · 01-01-2008

ok.. so its on my site wiht the ac page and it says it cannot be made unkown host?

How do i make a SQl host with my adress?

**Snailz** · 01-01-2008

Got it sorted

See if you can go on

WoWepic (0 players online)
and see if you can go on server pl0x

wowepic.servegame.com:6060 <-- yes thats there

Test
Test

Ty +rep for all help :P

**Snailz** · 01-01-2008

Have to spred it

lol

**Performer** · 01-01-2008

Yeah can make an acc

Gratz

Shout-Out

User Tag List

Thread: What am i doing wrong this time?

Thread Tools

Search Thread

What am i doing wrong this time?

Similar Threads

[Question] What am I doing wrong?

What am I doing wrong WoW.exe does not appear on WPE.

[Question] errr what am i doing wrong?

DynDNS help. What am I doing wrong?

what am i doing wrong...

OwnedCore Forums

casino

CoreCoins

My OwnedCore

About Us

Casino