Does anyone know where i can get RaidBoss Status PhP Script? I searched the Forum and I didn't find anything relevant.... if anyone has this script or can post a link to download it i would be really greatful

 

Thank You,

Th3On3

<html>
<head>
<title>
Raidboss info
</title>
</head>
<body>
<table>
<tr><td>Name</td><td>Status</td><td>Spawn</td></tr>
<?php
$hostname = "localhost"; // your database location
$database = "l2jdb";
$user = "root"; // your database user
$pass = ""; // your database password

$connect = @mysql_connect($hostname, $user, $pass);
@mysql_select_db($database, $connect);

if(!$connect)
echo 'Can\'t connect to the database';
else
{
$raidspawn = mysql_query("SELECT boss_id,respawn_time FROM raidboss_spawnlist ORDER BY respawn_time DESC");
while(list($boss_id,$respawn_time) = mysql_fetch_row($raidspawn))
{
$raidnames = mysql_query("SELECT name FROM npc WHERE id = $boss_id");
$text = '<font color="00FF00">alive</font>';
$respawn = '<font color="0000FF">spawned</font>';
if($respawn_time > 0)
{
	$respawntime = date('r',($respawn_time / 1000));
	$text = '<font color="FF0000">dead</font>';
	$respawn = '<font color="FF0000">Will respawn '.$respawntime.'</font>';
}

while(list($raidname) = mysql_fetch_row($raidnames))
{
	echo '<tr><td>'.$raidname.'</td><td>'.$text.'</td><td>'.$respawn.'</td></tr>';
}
}
}
?>
</table>
</body>
</html>

 

credits to hanwik

OMG THANK YOU ^^ For the fast reply

oooo ... to many thx .... OMG !!!

Thx man i post im my site realy useful 

 

sorry my english! Oo

is this way a secure way? I mean when someone want to see the code of the page, he will see the DB password and username? -.-

is this way a secure way? I mean when someone want to see the code of the page, he will see the DB password and username? -.-

lol no they won't, learn how php is processed ;)

when you right click on a webpage to see the source, (and this page have a final string with .php) then is NOT possible (yet) to see the php script inside that page ;D

<html>
<head>
<title>
Raidboss info
</title>
</head>
<body>
<table>
<tr><td>Name</td><td>Status</td><td>Spawn</td></tr>
<?php
$hostname = "localhost"; // your database location
$database = "l2jdb";
$user = "root"; // your database user
$pass = ""; // your database password

$connect = @mysql_connect($hostname, $user, $pass);
@mysql_select_db($database, $connect);

if(!$connect)
echo 'Can\'t connect to the database';
else
{
$raidspawn = mysql_query("SELECT boss_id,respawn_time FROM raidboss_spawnlist ORDER BY respawn_time DESC");
while(list($boss_id,$respawn_time) = mysql_fetch_row($raidspawn))
{
$raidnames = mysql_query("SELECT name FROM npc WHERE id = $boss_id");
$text = '<font color="00FF00">alive</font>';
$respawn = '<font color="0000FF">spawned</font>';
if($respawn_time > 0)
{
	$respawntime = date('r',($respawn_time / 1000));
	$text = '<font color="FF0000">dead</font>';
	$respawn = '<font color="FF0000">Will respawn '.$respawntime.'</font>';
}

while(list($raidname) = mysql_fetch_row($raidnames))
{
	echo '<tr><td>'.$raidname.'</td><td>'.$text.'</td><td>'.$respawn.'</td></tr>';
}
}
}
?>
</table>
</body>
</html>

 

credits to hanwik

 

How i edit the raidboss name color ?

My website background is black and the raidbosses names too.

<font color="0000FF"> this is the text color and <font color="FF0000"> this too.