<style type="text/css">
/*----------Text Styles----------*/
.ws8 {font-size: 10px;}
.ws9 {font-size: 11px;}
.wpmd {font-size: 10px;font-family: 'Arial';font-style: normal;font-weight: normal;}
/*----------Para Styles----------*/
DIV,UL,OL /* Left */
{
margin-top: 0px;
margin-bottom: 0px;
}
body,td,th {
font-size: 10px;
}
</style>
<?php
@session_start();
include "config.php";
//กำหนดชื่อของปราสาท
$GUILD_CASTLE[0] = 'Neuschwanstein'; // Aldebaran - Neuschwanstein
$GUILD_CASTLE[1] = 'Hohenschwangau'; // Aldebaran - Hohenschwangau
$GUILD_CASTLE[2] = 'Nuenberg'; // Aldebaran - Nuenberg
$GUILD_CASTLE[3] = 'Wuerzburg'; // Aldebaran - Wuerzburg
$GUILD_CASTLE[4] = 'Rothenburg'; // Aldebaran - Rothenburg
$GUILD_CASTLE[5] = 'Repherion'; // Geffen - Repherion
$GUILD_CASTLE[6] = 'Eeyolbriggar'; // Gffen - Eeyolbriggar
$GUILD_CASTLE[7] = 'Yesnelph'; // Geffen - Yesnelph
$GUILD_CASTLE[8] = 'Bergel'; // Geffen - Bergel
$GUILD_CASTLE[9] = 'Mersetzdeitz'; // Geffen - Mersetzdeitz
$GUILD_CASTLE[10] = 'Bright Arbor'; // Payon - Bright Arbor
$GUILD_CASTLE[11] = 'Scarlet Palace'; // Payon - Scarlet Palace
$GUILD_CASTLE[12] = 'Holy Shadow'; // Payon - Holy Shadow
$GUILD_CASTLE[13] = 'Sacred Alta'; // Payon - Sacred Altar
$GUILD_CASTLE[14] = 'Bamboo Grove Hill'; // Payon - Bamboo Grove Hill
$GUILD_CASTLE[15] = 'Kriemhild'; // Prontera - Kriemhild
$GUILD_CASTLE[16] = 'Swanhild'; // Prontera - Swanhild
$GUILD_CASTLE[17] = 'Fadhgridh'; // Prontera - Fadhgridh
$GUILD_CASTLE[18] = 'Skoegul'; // Prontera - Skoegul
$GUILD_CASTLE[19] = ' Gondul'; // Prontera - Gondul
//connect mysql server
mysql_connect($sql_host,$sql_user,$sql_pass) or die(mysql_error());
//connect db
mysql_select_db($sql_db) or die(mysql_error());
//ค้นหารายชื่อปราสาทที่มีคนครองอยู่
$query = "SELECT castle_id,guild_id FROM $CONFIG_sql_dbname.guild_castle WHERE guild_id!=\"\" order by castle_id ASC";
$result = mysql_query($query) or die(mysql_error());
//ถ้ามีปราสาทถูกยึดครองโดยกิลใดกิลนึง
if(mysql_num_rows($result) > 0) {
echo "<table width=\"60%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
</tr>";
//ทำการลูปเพื่อแสดงรายละเอียดกิลทั้งหมดที่ครองปราสาท
while($row = mysql_fetch_array($result)) {
$gvalue=$row[castle_id];
$gid = $row[guild_id];
//เลือกกิลที่มีบ้านอยู่เพื่อทำการแสดงรายละเอียด
$query = "SELECT name,master,emblem_data FROM $CONFIG_sql_dbname.guild WHERE guild_id=$gid ";
//print "<p>SELECT name,master,emblem_data FROM $CONFIG_sql_dbname.guild WHERE guild_id=$gid </p>";
$results = mysql_query($query) or die(mysql_error());
$grow = mysql_fetch_array($results) or die(mysql_error());
$guild_name=$grow[name];
$g_master_name=$grow[master];
$emblems[$gid]=$grow[emblem_data];
echo '
$emblems[$gid]=$grow[emblem_data];
?>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="25%"><div align="center"><font class="\"ws9\"" face="\"Tahoma\""><font color="\"##CE0000\""><b>Castle</b></font></font></div></td>
<td width="27%"><div align="center"><b>Guild</b></div></td>
<td width="27%"><div align="center"><b>Guild Master</b></div></td>
<td width="21%"><div align="center"><b>Emblem</b></div></td>
</tr>
<tr>
<td><div align="center"><?=$GUILD_CASTLE[$gvalue]?></div></td>
<td><div align="center"><font color="\"#000000\""><?=$guild_name?></font></div></td>
<td><div align="center"><font color="\"#000000\""><?=$g_master_name?></font></div></td>
<td><div align="center"><img src="emblem.php?data=<?=$gid?>" alt="<?=$guild_name?>"></div></td>
</tr>
</table>
</table>
<?php
if (isset($emblems)) {
session_register(emblems);
$_SESSION['emblems'] = $emblems;
}
}
echo "</table>";
}
else {
echo "<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
<td width=\"10\" height=\"10\"></td>
<td width=\"35\"></td>
<td width=\"164\"></td>
</tr>
<tr>
<TR class=\"topic_title4\">
<font color=\"#000000\"><font class=\"ws8\" face=\"Tahoma\"><b>ยังไม่มีกิลด์ใดยึดครอง</b></font><br>
</TR>
";
echo "</table>";
}
?>
Load balance : Server 04
Quote:
