[moy-web] Статус рб
5 replies200 viewsCurrently viewing: 1
· 02/16/2009, 05:15 PM
Нужен реально рабочий скрипт статуса рб для Moy-Web , примерно как на ДЛЕ, Помогите спасибками закидаю.
0
· 02/16/2009, 06:06 PM
Попробуй такой скрипт.
Код
<?php
$configdb = array(
"host" => "localhost",
"user" => "root",
"pass" => "12345",
"base" => "l2jdb",
);
$link = mysql_connect($configdb["host"],$configdb["user"],$configdb["pass"]) or die("MySQL error");
mysql_select_db($configdb["base"],$link);
echo "
<table width=100% border=0>
<tr>
<td width=50% align=center><b>Рейдбосс(Епик)</td>
<td width=25% align=center><b>Статус</td>
<td width=25% align=center><b>Респаун</td>
</tr>
";
$query = mysql_query("SELECT raid.boss_id, raid.respawn_time, npc.name, npc.level, npc.hp FROM grandboss_data AS raid INNER JOIN npc ON npc.id = raid.boss_id");
while ($raidData = mysql_fetch_array($query)) {
echo "<tr><td width=25% align=center>".$raidData["name"]."</td>";
echo "<td width=25% align=center><span style='color:green'>".($raidData["respawn_time"]=="0"?"Жив":"Мёртв")."</span></td>";
echo "<td width=50% align=center>".$raidData["respawn_time"]."</td></tr>";
}
echo "</table>";
mysql_close($link);
?>
$configdb = array(
"host" => "localhost",
"user" => "root",
"pass" => "12345",
"base" => "l2jdb",
);
$link = mysql_connect($configdb["host"],$configdb["user"],$configdb["pass"]) or die("MySQL error");
mysql_select_db($configdb["base"],$link);
echo "
<table width=100% border=0>
<tr>
<td width=50% align=center><b>Рейдбосс(Епик)</td>
<td width=25% align=center><b>Статус</td>
<td width=25% align=center><b>Респаун</td>
</tr>
";
$query = mysql_query("SELECT raid.boss_id, raid.respawn_time, npc.name, npc.level, npc.hp FROM grandboss_data AS raid INNER JOIN npc ON npc.id = raid.boss_id");
while ($raidData = mysql_fetch_array($query)) {
echo "<tr><td width=25% align=center>".$raidData["name"]."</td>";
echo "<td width=25% align=center><span style='color:green'>".($raidData["respawn_time"]=="0"?"Жив":"Мёртв")."</span></td>";
echo "<td width=50% align=center>".$raidData["respawn_time"]."</td></tr>";
}
echo "</table>";
mysql_close($link);
?>
0
· 02/17/2009, 12:55 PM
Цитата
<?php
$configdb = array(
"host" => "localhost",
"user" => "root",
"pass" => "12345",
"base" => "l2jdb",
);
$link = mysql_connect($configdb["host"],$configdb["user"],$configdb["pass"]) or die("MySQL error");
mysql_select_db($configdb["base"],$link);
echo "
<table width=100% border=0>
<tr>
<td width=50% align=center><b>Рейдбосс(Епик)</td>
<td width=25% align=center><b>Статус</td>
<td width=25% align=center><b>Респаун</td>
</tr>
";
$query = mysql_query("SELECT raid.boss_id, raid.respawn_time, npc.name, npc.level, npc.hp FROM grandboss_data AS raid INNER JOIN npc ON npc.id = raid.boss_id");
while ($raidData = mysql_fetch_array($query)) {
echo "<tr><td width=25% align=center>".$raidData["name"]."</td>";
echo "<td width=25% align=center><span style='color:green'>".($raidData["respawn_time"]=="0"?"Жив":"Мёртв")."</span></td>";
echo "<td width=50% align=center>".$raidData["respawn_time"]."</td></tr>";
}
echo "</table>";
mysql_close($link);
?>
этот скрипт старый , и плохо работает дайте плз новый$configdb = array(
"host" => "localhost",
"user" => "root",
"pass" => "12345",
"base" => "l2jdb",
);
$link = mysql_connect($configdb["host"],$configdb["user"],$configdb["pass"]) or die("MySQL error");
mysql_select_db($configdb["base"],$link);
echo "
<table width=100% border=0>
<tr>
<td width=50% align=center><b>Рейдбосс(Епик)</td>
<td width=25% align=center><b>Статус</td>
<td width=25% align=center><b>Респаун</td>
</tr>
";
$query = mysql_query("SELECT raid.boss_id, raid.respawn_time, npc.name, npc.level, npc.hp FROM grandboss_data AS raid INNER JOIN npc ON npc.id = raid.boss_id");
while ($raidData = mysql_fetch_array($query)) {
echo "<tr><td width=25% align=center>".$raidData["name"]."</td>";
echo "<td width=25% align=center><span style='color:green'>".($raidData["respawn_time"]=="0"?"Жив":"Мёртв")."</span></td>";
echo "<td width=50% align=center>".$raidData["respawn_time"]."</td></tr>";
}
echo "</table>";
mysql_close($link);
?>
0
Topic is closed for replies



