Secret Experience

derleybr · 13-12-2008, 09:10 PM

como assim a estrutura?

Setokaiba · 13-12-2008, 09:12 PM

A página do site que deve se chamar register.php e a DUMP SQL FILE da tabela que são inseridas as contas.

derleybr · 13-12-2008, 09:32 PM

Se for isso que vc precise...

ESTRUTURA BD: realmd.account

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

To te mandando o arquivo o codigo de dois arquivos.

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

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

You are ready to pump it up!

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

WELL DONE! You did it!

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

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

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

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

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

#DATABASE SETTINGS

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

return $result;
}

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

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

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

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

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

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

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

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

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

$onlineplayers=make_players_arrayrealmone();

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

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

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

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

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

$onlineplayerstwo=make_players_arrayrealmtwo();

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

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

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

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

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

$onlineplayersthree=make_players_arrayrealmthree() ;

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

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

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

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

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

$onlineplayersfour=make_players_arrayrealmfour();

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

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

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

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

Setokaiba · 13-12-2008, 09:44 PM

É impressão minha, ou tu não estabeleceu a senha do MySQL nos scripts?

$password="minhasenha"; // MAIN PASS for Mangos database

???

derleybr · 13-12-2008, 09:45 PM

é impressão meu amigo. Eu so nao compartilhei no forum ^^. Não sou tao nooob assim. ^^

_Dudu_1533 · 14-12-2008, 11:21 AM

Essa página não faz nenhum INSERT.
Tem certeza que postou a classe inteira?

Até mais.

christiand · 14-12-2008, 12:44 PM

seria mais facil fazer o q eu falei anteriormente, upa o seu banco de dados e seu site para um shared e coloque os links aqui q eu em casa testo e vejo c esta legal.

bem masi simples pois pelo visto as perguntas q estamos fazendo a vc esta sendo dificil de vc compreender.

derleybr · 14-12-2008, 03:43 PM

Citação:

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

seria mais facil fazer o q eu falei anteriormente, upa o seu banco de dados e seu site para um shared e coloque os links aqui q eu em casa testo e vejo c esta legal.

bem masi simples pois pelo visto as perguntas q estamos fazendo a vc esta sendo dificil de vc compreender.

Blz... Vou preparar isso agora.

Citação:

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

seria mais facil fazer o q eu falei anteriormente, upa o seu banco de dados e seu site para um shared e coloque os links aqui q eu em casa testo e vejo c esta legal.

bem masi simples pois pelo visto as perguntas q estamos fazendo a vc esta sendo dificil de vc compreender.

Aqui está!

link do server e de todo o utilitário. Tudo que tenho, eu to usando daqui.
- [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

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

Eu uso o APPSERVER, ultima versão.

Minha porta é a 8090.

NAVICAT
MySQL ultima versão;

Eu acho que é isso.
Windows XP Pro.

E mais uma vez, obrigado pela pronta ajuda de todos neste forum!

Alguem ae, pôde me ajudar?

~~!

Hinata · 29-12-2008, 09:50 PM

ae eu fiz um serer de wow ele ta funcionando de boa mas tem algun bugs mas a questap naum é essa eu ja criei 2 contas novas e consegui entrar com as 2 mas quando eu passo pro meu amigo jogar ele tanta logar mas fika só no conecting e naum sai disso ele ja boto o realmlist do meu server q é o meu IP mas msm assim naum dá eu ja tentei fazer um server na casa dele mas deu a msma coisa alguem pode me ajudar? por favor me respondao

Setokaiba · 29-12-2008, 09:55 PM

Cite quais as configurações do teu modem.

Modelo?
Se está a utilizar uma conexão PPPoE Router ou Bridge?
E qual software está a utilizar? (DDNS, No-IP)

13-12-2008, 09:32 PM	#13
derleybr Membro - Soldado Registrado em: Dec 2008 Posts: 15 Agradeceu: 4 Agradecido 0 Vezes em 0 Posts Achei Ruim: Acharam ruim Vezes em Posts Inventório de derleybr	Site nao cria conta Se for isso que vc precise... ESTRUTURA BD: realmd.account [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar] To te mandando o arquivo o codigo de dois arquivos. config.php [INDENT]<?php /* LET'S INSTALL YOUR ROSPORA! 1-Set up your mysql database ip adress (ex. 127.0.0.1 or 127.0.0.1) 2-Set up your mysql databases usernames and passwords (ex. user= root password = mangos) 3-Set up your mysql databases which mangos is used them! (imp. databases already had set to default names) 4-Set up your Server PC's IP address (for realm status) 5-Set up your Template Options (if you want) 6-Write your server informations (ex. XP options , Versions..) You are ready to pump it up! Open a browser , call your servers ip at address bar! (pisstt.. If you have a router , dont forget forwarding 80 number port to your Server!) WELL DONE! You did it! ---------------------- NOO , I cant did it! Don't be a hasty.Check your Configuration again slowly! ---------------------- Again ? Check [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar] and find The RoSpora Topic and write your error. or send me a email at [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar] ! ---------------------- CREDITS: THANK YOU ALL , WHO IS SUPPORTING AND LIKES ROSPORA! THIS ROSPORA GOING TO BLESS YOUR SERVER! =) DONT FORGET TO CHECK UPDATES OF YOURS @ [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar] / #DATABASE SETTINGS $serveros="windows"; //Write your server operation system For Windows "windows" For Linux "linux" $lang="en"; // Language ("en" - english, "ru" - russian, "tr" - turkish, "hu" - hungarian, "de" - deutsch) ////////////////////////////////////////// #MAIN HOST - MAIN SERVER ////////////////////////////////////////// $host="127.0.0.1"; // MAIN HOST for Mangos database $user="root"; // MAIN USER for Mangos database $password="minhasenha"; // MAIN PASS for Mangos database $db="mangos"; // MAIN NAME of Mangos database ////////////////////////////////////////// $hostr="127.0.0.1"; // MAIN HOST for Realm database $userr="root"; // MAIN USER for Realm database $passwordr="minhasenha"; // MAIN PASS for Realm database $dbr="realmd"; // MAIN NAME of Real database ////////////////////////////////////////// #HOST MAIN - REALM ONE ////////////////////////////////////////// $hostrealmone="127.0.0.1"; // MAIN HOST for Characters database $userrealmone="root"; // MAIN USER for Characters database $passwordrealmone="minhasenha"; // MAIN PASS for Characters database $dbrealmone="characters"; // MAIN NAME of Characters database ///////////////////////////////// #HOST TWO - REALM TWO ///////////////////////////////// $hostrealmtwo="127.0.0.1"; // 2. HOST for Characters database $userrealmtwo="root"; // 2. USER for Characters database $passwordrealmtwo="minhasenha"; // 2. PASS for Characters database $dbrealmtwo="characters"; // 2. NAME of Characters database ///////////////////////////////// #HOST THREE - REALM THREE ///////////////////////////////// $hostrealmthree="127.0.0.1"; // 3. HOST for Characters database $userrealmthree="root"; // 3. USER for Characters database $passwordrealmthree="minhasenha"; // 3. PASS for Characters database $dbrealmthree="characters"; // 3. NAME of Characters database //////////////////////////////// #HOST FOUR - REALM FOUR ///////////////////////////////// $hostrealmfour="127.0.0.1"; // 4. HOST for Characters database $userrealmfour="root"; // 4. USER for Characters database $passwordrealmfour="minhasenha"; // 4. PASS for Characters database $dbrealmfour="characters"; // 4. NAME of Characters database ////////////////////////////////////////// #REALM STATUS CHECK OPTIONS ////////////////////////////////////////// $database_encoding = 'CP1251'; // Set character encoding for MySQL $server = "127.0.0.1"; // MAIN HOST adress (for realm status) $servertwo = "127.0.0.1"; // 2. HOST adress (for realm status) $serverthree = "127.0.0.1"; // 3. HOST adress (for realm status) $serverfour = "127.0.0.1"; // 4. HOST adress (for realm status) $port = "8085"; // Server port (for all realms status) 8085 or 3724 ////////////////////////////////////////// #ACCOUNT PAGE OPTIONS ////////////////////////////////////////// $accountoption="1"; //Set your RoSPORA's account creating is open or closed. 1 - Open , 2 - Closed $onlineoption="1"; //Set your RoSPORA's online player display is open or closed. 1 - Open , 2 - Closed $accountmessage="Upgrading Server's Version!"; //Set your account creation closed text $onlinemessage="Online Player Display Disabled For Upgrading Server!"; //Set your online player display text $lock_acc=2; // Lock created account to IP adress (1 - on, 0 - off) $lock_reg=0; // Registration only one (or more) account from one IP adress (IT HAVE A SECURITY ON FORM ACTION BOTS! , JUST SET IT TO 1 OR 2) // 0 - not limit, 1 - one acc, 2 - two acc, etc... ////////////////////////////////////////// #TEMPLATE OPTIONS $img_base = "img/"; // Image dir $ongif = "img/on.gif"; $offgif = "img/off.gif"; $charset="windows-1251"; //Browser charset of your language.Tarayýcýnýzýn dilinize göre charset ayarý - Türkçe : "iso-8859-9" $timetext="Current Server Time"; //Shows Server Time , if you want you can change it to your language Example: ="yourlang"; ////////////////////////////////////////// #MINI INFORMATION BOX OPTIONS $information=" <li>This server supports only 2.x.x clients<br> <li>1x Quest XP , 1x Kill XP , 1x Discovery XP<br> <li>Runnig on One Realm<br> <li>First Realm has 100 User Cap.<br>"; ?>[/INDENT --------------------------------------------------------------------- Functiondata.php (esse arquivo é o que faz os insert's)* <?php require_once( 'config.php' ); require_once( 'languages.php' ); $version="V1.5.0"; $maps_a = Array( 0 => 'Azeroth', 1 => 'Kalimdor', 2 => 'UnderMine', 13 => 'Test zone', 17 => 'Kalidar', 30 => 'Alterac Valley', 33 => 'Shadowfang Keep Instance', 34 => 'The Stockade Instance', 35 => 'Stormwind Prizon', 36 => 'Deadmines Instance', 37 => 'Plains of Snow', 43 => 'Wailing Caverns Instance', 44 => 'Monastery Interior', 47 => 'Razorfen Kraul Instance', 48 => 'Blackfathom Deeps Instance', 70 => 'Uldaman Instance', 90 => 'Gnomeregan Instance', 109 => 'Sunken Temple Instance', 129 => 'Razorfen Downs Instance', 530 => 'Outland', 169 => 'Emerald Forest', 189 => 'Scarlet Monastery Instance', 209 => 'ZulFarrak Instance', 229 => 'Blackrock Spire Instance', 230 => 'Blackrock Depths Instance', 249 => 'Onyxias Lair Instance', 269 => 'Caverns of Time', 289 => 'Scholomance Instance', 309 => 'ZulGurub Instance', 329 => 'Stratholme Instance', 349 => 'Maraudon Instance', 369 => 'Deeprun Tram', 389 => 'Ragefire Chasm Instance', 409 => 'The Molten Core Instance', 429 => 'Dire Maul Instance', 449 => 'Alliance PVP Barracks', 450 => 'Horde PVP Barracks', 451 => 'Development Land', 469 => 'Blackwing Lair Instance', 489 => 'Warsong Gulch', 509 => 'Ruins of AhnQiraj Instance', 529 => 'Arathi Basin', 531 => 'Temple of AhnQiraj Instance', 533 => 'Naxxramas Instance', 532 => 'Karazahn', 534 => 'Hyjal Past', 540 => 'Shattered Halls Instance', 542 => 'Blood Furnace Instance', 543 => 'Hellfire Ramparts Instance', 544 => 'Magtheridons Lair Instance', 545 => 'Steamvault Instance', 546 => 'Underbog Instance', 547 => 'Slave Pens Instance', 548 => 'Coilfang Resevoir Instance', 550 => 'Tempest Keep', 552 => 'Tempest Keep', 553 => 'Tempest Keep', 554 => 'Tempest Keep', 555 => 'Auchindoun', 556 => 'Auchindoun', 557 => 'Auchindoun', 558 => 'Auchindoun', 559 => 'Nagrand Arena', 560 => 'Hillsbrad Past', 562 => 'Blades Edge Arena', 564 => 'Black Temple', 565 => 'Gruuls Lair', 566 => 'Netherstorm Arena', 568 => 'Zulaman', ); $zone = Array( 0 => Array( Array(700,10,1244,1873,'Undercity',1497), Array(-840,-1330,-5050,-4560,'Ironforge',1537), Array(1190,200,-9074,-8280,'Stormwind City',1519), Array(-2170,-4400,-7348,-6006,'Badlands',3), Array(-500,-4400,-4485,-2367,'Wetlands',11), Array(2220,-2250,-15422,-11299,'Stranglethorn Vale',33), Array(-1724,-3540,-9918,-8667,'Redridge Mountains',44), Array(-2480,-4400,-6006,-4485,'Loch Modan',38), Array(662,-1638,-11299,-9990,'Duskwood',10), Array(-1638,-2344,-11299,-9918,'Deadwind Pass',41), Array(834,-1724,-9990,-8526,'Elwynn Forest',12), Array(-500,-3100,-8667,-7348,'Burning Steppes',46), Array(-608,-2170,-7348,-6285,'Searing Gorge',51), Array(2000,-2480,-6612,-4485,'Dun Morogh',1), Array(-1575,-5425,-432,805,'The Hinterlands',47), Array(3016,662,-11299,-9400,'Westfall',40), Array(600,-1575,-1874,220,'Hillsbrad Foothills',267), Array(-2725,-6056,805,3800,'Eastern Plaguelands',139), Array(-850,-2725,805,3400,'Western Plaguelands',28), Array(2200,600,-900,1525,'Silverpine Forest',130), Array(2200,-850,1525,3400,'Tirisfal Glades',85), Array(-2250,-3520,-12800,-10666,'Blasted Lands',4), Array(-2344,-4516,-11070,-9600,'Swamp of Sorrows',8), Array(-1575,-3900,-2367,-432,'Arathi Highlands',45), Array(600,-1575,220,1525,'Alterac Mountains',36), ), 1 => Array( Array(2698,2030,9575,10267,'Darnassus',1657), Array(326,-360,-1490,-910,'Thunder Bluff',1638), Array(-3849,-4809,1387,2222,'Orgrimmar',1637), Array(-1300,-3250,7142,8500,'Moonglade',493), Array(2021,-400,-9000,-6016,'Silithus',1377), Array(-2259,-7000,4150,8500,'Winterspring',618), Array(-400,-2094,-8221,-6016,'Un\'Goro Crater',490), Array(-590,-2259,3580,7142,'Felwood',361), Array(-3787,-8000,1370,6000,'Azshara',16), Array(-1900,-5500,-10475,-6825,'Tanaris',440), Array(-2478,-5500,-5135,-2330,'Dustwallow Marsh',15), Array(360,-1536,-3474,-412,'Mulgore',215), Array(4000,-804,-6828,-2477,'Feralas',357), Array(3500,360,-2477,372,'Desolace',405), Array(-804,-5500,-6828,-4566,'Thousand Needles',400), Array(-3758,-5500,-1300,1370,'Durotar',14), Array(1000,-3787,1370,4150,'Ashenvale',331), Array(2500,-1300,4150,8500,'Darkshore',148), Array(3814,-1100,8600,11831,'Teldrassil',141), Array(3500,-804,-412,3580,'Stonetalon Mountains',406), Array(-804,-4200,-4566,1370,'The Barrens',17), ), 530 => Array( Array(6135.25,4829,-2344.78,-1473.95,'Shattrath City',3703), Array(-6400.75,-7612.20,9346.93,10153.70,'Silvermoon City',3487), Array(5483.33,-91.66,1739.58,5456.25,'Netherstorm',3523), Array(7083.33,1683.33,-4600,-999.99,'Terokkar Forest',3519), Array(10295.83,4770.83,-3641.66,41.66,'Nagrand',3518), Array(-10075,-13337.49,-2933.33,-758.33,'Bloodmyst Isle',3525), Array(8845.83,3420.83,791.66,4408.33,'Blades Edge Mountains',3522), Array(4225,-1275,-5614.58,-1947.91,'Shadowmoon Valley',3520), Array(-11066.36,-12123.13,-4314.37,-3609.68,'The Exodar',3557), Array(9475,4447.91,-1416.66,1935.41,'Zangarmarsh',3521), Array(5539.58,375,-1962.49,1481.25,'Hellfire Peninsula',3483), Array(-10500,-14570.83,-5508.33,-2793.75,'Azuremyst Isle',3524), Array(-5283.33,-8583.33,6066.66,8266.66,'Ghostlands',3433), Array(-4487,-9412,7758,11041,'Eversong Woods',3430) ), ); $def = Array( 'character_race' => Array( 1 => 'Human', 2 => 'Orc', 3 => 'Dwarf', 4 => 'Night Elf', 5 => 'Undead', 6 => 'Tauren', 7 => 'Gnome', 8 => 'Troll', 9 => 'Goblin', 10 => 'Blood&nbspElf', 11 => 'Dranei', ), 'character_class' => Array( 1 => 'Warrior', 2 => 'Paladin', 3 => 'Hunter', 4 => 'Rogue', 5 => 'Priest', 7 => 'Shaman', 8 => 'Mage', 9 => 'Warlock', 11 => 'Druid', ), 'character_rank' => Array( 'alliance' => Array( 1 => 'Private', 2 => 'Corporal', 3 => 'Sergeant', 4 => 'Master Sergeant', 5 => 'Sergeant Major', 6 => 'Knight', 7 => 'Knight-Lieutenant', 8 => 'Knight-Captain', 9 => 'Knight-Champion', 10 => 'Lieutenant Commander', 11 => 'Commander', 12 => 'Marshal', 13 => 'Field Marshal', 14 => 'Grand Marshal' ), 'horde' => Array( 1 => 'Scout', 2 => 'Grunt', 3 => 'Sergeant', 4 => 'Senior Sergeant', 5 => 'First Sergeant', 6 => 'Stone Guard', 7 => 'Blood Guard', 8 => 'Legionnare', 9 => 'Centurion', 10 => 'Champion', 11 => 'Lieutenant General', 12 => 'General', 13 => 'Warlord', 14 => 'High Warlord' ) ), ); class DBLayer { var $link_id; var $query_result; var $saved_queries = array(); var $num_queries = 0; function DBLayer($db_host, $db_username, $db_password, $db_name) { $this->link_id = @mysql_connect($db_host, $db_username, $db_password, true); if ($this->link_id) { if (@mysql_select_db($db_name, $this->link_id)) return $this->link_id; else error('Unable to select database. MySQL reported: '.mysql_error(), __FILE__, __LINE__); } else error('Unable to connect to MySQL server. MySQL reported: '.mysql_error(), __FILE__, __LINE__); } function query($sql) { $this->query_result = @mysql_query($sql, $this->link_id); if ($this->query_result) { ++$this->num_queries; return $this->query_result; } else { return false; } } function result($query_id = 0, $row = 0) { return ($query_id) ? @mysql_result($query_id, $row) : false; } function fetch_assoc($query_id = 0) { return ($query_id) ? @mysql_fetch_assoc($query_id) : false; } function fetch_row($query_id = 0) { return ($query_id) ? @mysql_fetch_row($query_id) : false; } function num_rows($query_id = 0) { return ($query_id) ? @mysql_num_rows($query_id) : false; } function affected_rows() { return ($this->link_id) ? @mysql_affected_rows($this->link_id) : false; } function insert_id() { return ($this->link_id) ? @mysql_insert_id($this->link_id) : false; } function get_num_queries() { return $this->num_queries; } function get_saved_queries() { return $this->saved_queries; } function free_result($query_id = false) { return ($query_id) ? @mysql_free_result($query_id) : false; } function escape($str) { if (function_exists('mysql_real_escape_string')) return mysql_real_escape_string($str, $this->link_id); else return mysql_escape_string($str); } function error() { $result['error_sql'] = @current(@end($this->saved_queries)); $result['error_no'] = @mysql_errno($this->link_id); $result['error_msg'] = @mysql_error($this->link_id); return $result; } function close() { if ($this->link_id) { if ($this->query_result) @mysql_free_result($this->query_result); return @mysql_close($this->link_id); } else return false; } } //Functions of RoSpora Tab System function test_realm(){ global $server, $port; $s = @fsockopen("$server", $port, $ERROR_NO, $ERROR_STR,(float)0.5); if($s){@fclose($s);return true;} else return false; } function test_realmtwo(){ global $servertwo, $port; $s = @fsockopen("$servertwo", $port, $ERROR_NO, $ERROR_STR,(float)0.5); if($s){@fclose($s);return true;} else return false; } function test_realmthree(){ global $serverthree, $port; $s = @fsockopen("$serverthree", $port, $ERROR_NO, $ERROR_STR,(float)0.5); if($s){@fclose($s);return true;} else return false; } function test_realmfour(){ global $serverfour, $port; $s = @fsockopen("$serverfour", $port, $ERROR_NO, $ERROR_STR,(float)0.5); if($s){@fclose($s);return true;} else return false; } function get_realm_name(){ global $hostr, $userr, $passwordr, $dbr, $database_encoding; $realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr); $realm_db->query("SET NAMES $database_encoding"); $query = $realm_db->query("SELECT * FROM `realmlist` WHERE id = '1'"); $result = $realm_db->fetch_assoc($query); $realm_db->close(); unset($realm_db); return($result['name']); } function get_realm_nametwo(){ global $hostr, $userr, $passwordr, $dbr, $database_encoding; $realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr); $realm_db->query("SET NAMES $database_encoding"); $query2 = $realm_db->query("SELECT * FROM `realmlist` WHERE id = '2'"); $result2 = $realm_db->fetch_assoc($query2); $realm_db->close(); unset($realm_db); return($result2['name']); } function get_realm_namethree(){ global $hostr, $userr, $passwordr, $dbr, $database_encoding; $realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr); $realm_db->query("SET NAMES $database_encoding"); $query3 = $realm_db->query("SELECT * FROM `realmlist` WHERE id = '3'"); $result3 = $realm_db->fetch_assoc($query3); $realm_db->close(); unset($realm_db); return($result3['name']); } function get_realm_namefour(){ global $hostr, $userr, $passwordr, $dbr, $database_encoding; $realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr); $realm_db->query("SET NAMES $database_encoding"); $query4 = $realm_db->query("SELECT * FROM `realmlist` WHERE id = '4'"); $result4 = $realm_db->fetch_assoc($query4); $realm_db->close(); unset($realm_db); return($result4['name']); } function get_zone_name($mapid, $x, $y){ global $maps_a, $zone; if (!empty($maps_a[$mapid])) { $zmap=$maps_a[$mapid]; if (($mapid==0) or ($mapid==1) or ($mapid==530)) { $i=0; $c=count($zone[$mapid]); while ($i<$c) { if ($zone[$mapid][$i][2] < $x AND $zone[$mapid][$i][3] > $x AND $zone[$mapid][$i][1] < $y AND $zone[$mapid][$i][0] > $y) $zmap=$zone[$mapid][$i][4]; $i++; } } } else $zmap="Unknown zone"; return $zmap; } function make_players_arrayrealmone(){ global $hostrealmone, $userrealmone, $passwordrealmone, $dbrealmone, $database_encoding, $pl_array; $i=0; $mangos_db = new DBLayer($hostrealmone, $userrealmone, $passwordrealmone, $dbrealmone); $mangos_db->query("SET NAMES $database_encoding"); $query = $mangos_db->query("SELECT * FROM `characters` WHERE `online`='1' ORDER BY `name`"); while($result = $mangos_db->fetch_assoc($query)) { $char_data = explode(' ',$result['data']); $char_gender = dechex($char_data[36]); $char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT); $char_gender = $char_gender{3}; $res_pos=get_zone_name($result['map'], $result['position_x'], $result['position_y']); $pl_array[$i] = Array($result['name'], $result['race'], $result['class'], $char_data[34], $res_pos, $char_gender); $i++; } $mangos_db->close(); unset($mangos_db); return $i; } $onlineplayers=make_players_arrayrealmone(); if (!$sort = &$_GET['s']) $sort=0; if (!$flag = &$_GET['f']) $flag=0; if ($flag==0) { $flag=1; $sort_type='<'; } else { $flag=0; $sort_type='>'; } $link=$_SERVER['PHP_SELF']."?f=".$flag."&s="; if (!empty($pl_array)) { usort($pl_array, create_function('$a, $b', 'if ( $a['.$sort.'] == $b['.$sort.'] ) return 0; if ( $a['.$sort.'] '.$sort_type.' $b['.$sort.'] ) return -1; return 1;')); } $listone=""; $i=0; while ($i < $onlineplayers) { $name=$pl_array[$i][0]; $race=$pl_array[$i][1]; $class=$pl_array[$i][2]; $res_race = $def['character_race'][$race]; $res_class = $def['character_class'][$class]; $lvl=$pl_array[$i][3]; $loc=$pl_array[$i][4]; $gender=$pl_array[$i][5]; $listone.= " <tr class=txt> <td></td> <td>$name</td> <td align='center'><img alt=$res_race src='".$img_base.$race."-$gender.gif' height='18' width='18'></td> <td align='center'><img alt=$res_class src='".$img_base."$class.gif' height='18' width='18'></td> <td align='center'>$lvl</td> <td >$loc</td> </tr>"; $i++; } //Realm Two function make_players_arrayrealmtwo(){ global $hostrealmtwo, $userrealmtwo, $passwordrealmtwo, $dbrealmtwo, $database_encoding, $pl_array; $i=0; $mangos_dbtwo = new DBLayer($hostrealmtwo, $userrealmtwo, $passwordrealmtwo, $dbrealmtwo); $mangos_dbtwo->query("SET NAMES $database_encoding"); $query = $mangos_dbtwo->query("SELECT * FROM `characters` WHERE `online`='1' ORDER BY `name`"); while($result = $mangos_dbtwo->fetch_assoc($query)) { $char_data = explode(' ',$result['data']); $char_gender = dechex($char_data[36]); $char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT); $char_gender = $char_gender{3}; $res_pos=get_zone_name($result['map'], $result['position_x'], $result['position_y']); $pl_array[$i] = Array($result['name'], $result['race'], $result['class'], $char_data[34], $res_pos, $char_gender); $i++; } $mangos_dbtwo->close(); unset($mangos_dbtwo); return $i; } $onlineplayerstwo=make_players_arrayrealmtwo(); if (!$sort = &$_GET['s']) $sort=0; if (!$flag = &$_GET['f']) $flag=0; if ($flag==0) { $flag=1; $sort_type='<'; } else { $flag=0; $sort_type='>'; } $link=$_SERVER['PHP_SELF']."?f=".$flag."&s="; if (!empty($pl_array)) { usort($pl_array, create_function('$a, $b', 'if ( $a['.$sort.'] == $b['.$sort.'] ) return 0; if ( $a['.$sort.'] '.$sort_type.' $b['.$sort.'] ) return -1; return 1;')); } $listtwo=""; $i=0; while ($i < $onlineplayerstwo) { $name=$pl_array[$i][0]; $race=$pl_array[$i][1]; $class=$pl_array[$i][2]; $res_race = $def['character_race'][$race]; $res_class = $def['character_class'][$class]; $lvl=$pl_array[$i][3]; $loc=$pl_array[$i][4]; $gender=$pl_array[$i][5]; $listtwo.= " <tr class=txt> <td></td> <td>$name</td> <td align='center'><img alt=$res_race src='".$img_base.$race."-$gender.gif' height='18' width='18'></td> <td align='center'><img alt=$res_class src='".$img_base."$class.gif' height='18' width='18'></td> <td align='center'>$lvl</td> <td >$loc</td> </tr>"; $i++; } //Realm Three function make_players_arrayrealmthree(){ global $hostrealmthree, $userrealmthree, $passwordrealmthree, $dbrealmthree, $database_encoding, $pl_array; $i=0; $mangos_dbthree = new DBLayer($hostrealmthree, $userrealmthree, $passwordrealmthree, $dbrealmthree); $mangos_dbthree->query("SET NAMES $database_encoding"); $query = $mangos_dbthree->query("SELECT * FROM `characters` WHERE `online`='1' ORDER BY `name`"); while($result = $mangos_dbthree->fetch_assoc($query)) { $char_data = explode(' ',$result['data']); $char_gender = dechex($char_data[36]); $char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT); $char_gender = $char_gender{3}; $res_pos=get_zone_name($result['map'], $result['position_x'], $result['position_y']); $pl_array[$i] = Array($result['name'], $result['race'], $result['class'], $char_data[34], $res_pos, $char_gender); $i++; } $mangos_dbthree->close(); unset($mangos_dbthree); return $i; } $onlineplayersthree=make_players_arrayrealmthree() ; if (!$sort = &$_GET['s']) $sort=0; if (!$flag = &$_GET['f']) $flag=0; if ($flag==0) { $flag=1; $sort_type='<'; } else { $flag=0; $sort_type='>'; } $link=$_SERVER['PHP_SELF']."?f=".$flag."&s="; if (!empty($pl_array)) { usort($pl_array, create_function('$a, $b', 'if ( $a['.$sort.'] == $b['.$sort.'] ) return 0; if ( $a['.$sort.'] '.$sort_type.' $b['.$sort.'] ) return -1; return 1;')); } $listthree=""; $i=0; while ($i < $onlineplayersthree) { $name=$pl_array[$i][0]; $race=$pl_array[$i][1]; $class=$pl_array[$i][2]; $res_race = $def['character_race'][$race]; $res_class = $def['character_class'][$class]; $lvl=$pl_array[$i][3]; $loc=$pl_array[$i][4]; $gender=$pl_array[$i][5]; $listthree.= " <tr class=txt> <td></td> <td>$name</td> <td align='center'><img alt=$res_race src='".$img_base.$race."-$gender.gif' height='18' width='18'></td> <td align='center'><img alt=$res_class src='".$img_base."$class.gif' height='18' width='18'></td> <td align='center'>$lvl</td> <td >$loc</td> </tr>"; $i++; } //Realm Four function make_players_arrayrealmfour(){ global $hostrealmfour, $userrealmfour, $passwordrealmfour, $dbrealmfour, $database_encoding, $pl_array; $i=0; $mangos_dbfour = new DBLayer($hostrealmfour, $userrealmfour, $passwordrealmfour, $dbrealmfour); $mangos_dbfour->query("SET NAMES $database_encoding"); $query = $mangos_dbfour->query("SELECT * FROM `characters` WHERE `online`='1' ORDER BY `name`"); while($result = $mangos_dbfour->fetch_assoc($query)) { $char_data = explode(' ',$result['data']); $char_gender = dechex($char_data[36]); $char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT); $char_gender = $char_gender{3}; $res_pos=get_zone_name($result['map'], $result['position_x'], $result['position_y']); $pl_array[$i] = Array($result['name'], $result['race'], $result['class'], $char_data[34], $res_pos, $char_gender); $i++; } $mangos_dbfour->close(); unset($mangos_dbfour); return $i; } $onlineplayersfour=make_players_arrayrealmfour(); if (!$sort = &$_GET['s']) $sort=0; if (!$flag = &$_GET['f']) $flag=0; if ($flag==0) { $flag=1; $sort_type='<'; } else { $flag=0; $sort_type='>'; } $link=$_SERVER['PHP_SELF']."?f=".$flag."&s="; if (!empty($pl_array)) { usort($pl_array, create_function('$a, $b', 'if ( $a['.$sort.'] == $b['.$sort.'] ) return 0; if ( $a['.$sort.'] '.$sort_type.' $b['.$sort.'] ) return -1; return 1;')); } $listfour=""; $i=0; while ($i < $onlineplayersfour) { $name=$pl_array[$i][0]; $race=$pl_array[$i][1]; $class=$pl_array[$i][2]; $res_race = $def['character_race'][$race]; $res_class = $def['character_class'][$class]; $lvl=$pl_array[$i][3]; $loc=$pl_array[$i][4]; $gender=$pl_array[$i][5]; $listfour.= " <tr class=txt> <td></td> <td>$name</td> <td align='center'><img alt=$res_race src='".$img_base.$race."-$gender.gif' height='18' width='18'></td> <td align='center'><img alt=$res_class src='".$img_base."$class.gif' height='18' width='18'></td> <td align='center'>$lvl</td> <td >$loc</td> </tr>"; $i++; } $title=get_realm_name(); $titletwo=get_realm_nametwo(); $titlethree=get_realm_namethree(); $titlefour=get_realm_namefour(); $copyright=get_realm_name(); $status=get_realm_name(); $statustwo=get_realm_nametwo(); $statusthree=get_realm_namethree(); $statusfour=get_realm_namefour(); if (test_realm()) { $title.=(' ('.$onlineplayers.' '.$text["playerson"].')'); $status = "<img alt=Online src='".$img_base."online.gif' height='18' width='18'>"; } else { $title.=(' '.$text["off"] ); $status = "<img alt=Offline src='".$img_base."offline.gif' height='18' width='18'>"; } if (test_realmtwo()) { $titletwo.=(' ('.$onlineplayerstwo.' '.$text["playerson"].')'); $statustwo = "<img alt=Online src='".$img_base."online.gif' height='18' width='18'>"; } else { $titletwo.=(' '.$text["off"] ); $statustwo = "<img alt=Offline src='".$img_base."offline.gif' height='18' width='18'>"; } if (test_realmthree()) { $titlethree.=(' ('.$onlineplayersthree.' '.$text["playerson"].')'); $statusthree = "<img alt=Online src='".$img_base."online.gif' height='18' width='18'>"; } else { $titlethree.=(' '.$text["off"] ); $statusthree = "<img alt=Offline src='".$img_base."offline.gif' height='18' width='18'>"; } if (test_realmfour()) { $titlefour.=(' ('.$onlineplayersfour.' '.$text["playerson"].')'); $statusfour = "<img alt=Online src='".$img_base."online.gif' height='18' width='18'>"; } else { $titlefour.=(' '.$text["off"] ); $statusfour = "<img alt=Offline src='".$img_base."offline.gif' height='18' width='18'>"; } ?>

14-12-2008, 12:44 PM	#17
christiand Amigo SE Registrado em: Nov 2008 Localização: Rio de Janeiro, RJ Posts: 597 Agradeceu: 47 Agradecido 1,826 Vezes em 246 Posts Achei Ruim: Acharam ruim Vezes em Posts Inventório de christiand	seria mais facil fazer o q eu falei anteriormente, upa o seu banco de dados e seu site para um shared e coloque os links aqui q eu em casa testo e vejo c esta legal. bem masi simples pois pelo visto as perguntas q estamos fazendo a vc esta sendo dificil de vc compreender. __________________ [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar] [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar] [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

29-12-2008, 09:50 PM	#19
Hinata Membro - Recruta Registrado em: Dec 2008 Posts: 4 Agradeceu: 0 Agradecido 0 Vezes em 0 Posts Achei Ruim: Acharam ruim Vezes em Posts Inventório de Hinata	meu server ae eu fiz um serer de wow ele ta funcionando de boa mas tem algun bugs mas a questap naum é essa eu ja criei 2 contas novas e consegui entrar com as 2 mas quando eu passo pro meu amigo jogar ele tanta logar mas fika só no conecting e naum sai disso ele ja boto o realmlist do meu server q é o meu IP mas msm assim naum dá eu ja tentei fazer um server na casa dele mas deu a msma coisa alguem pode me ajudar? por favor me respondao

Tópicos Similares
Tópico	Tópico Iniciado Por	Fórum	Respostas	Última Mensagem
Criando Site de Lineage 2	Setokaiba	[L2J] Tutoriais	42	30-08-2011 04:51 AM
[Web Site] MuPadrão [Free]	Mandark³	[MU] Sites	3	16-03-2010 09:51 AM
[Web Site] Site do Kryer.Estou com uma duvida.	andreimunhoz	[L2J] Dúvidas	3	23-06-2009 10:41 PM
[Web Site] Duvida sobre o site	activecaptions	[L2J] Dúvidas	2	07-06-2009 02:16 PM
Site ^^	Setokaiba	[L2J] Tutoriais	10	05-06-2009 11:14 PM

13-12-2008, 09:10 PM	#11
derleybr Membro - Soldado Registrado em: Dec 2008 Posts: 15 Agradeceu: 4 Agradecido 0 Vezes em 0 Posts Achei Ruim: Acharam ruim Vezes em Posts Inventório de derleybr	como assim a estrutura?

13-12-2008, 09:45 PM	#15
derleybr Membro - Soldado Registrado em: Dec 2008 Posts: 15 Agradeceu: 4 Agradecido 0 Vezes em 0 Posts Achei Ruim: Acharam ruim Vezes em Posts Inventório de derleybr	é impressão meu amigo. Eu so nao compartilhei no forum ^^. Não sou tao nooob assim. ^^

14-12-2008, 11:21 AM	#16
_Dudu_1533 Amigo SE Registrado em: Oct 2008 Posts: 170 Agradeceu: 32 Agradecido 1,411 Vezes em 95 Posts Achei Ruim: Acharam ruim Vezes em Posts Inventório de _Dudu_1533	Essa página não faz nenhum INSERT. Tem certeza que postou a classe inteira? Até mais.