[HELP] RaidBoss Status PhP Script?

Th3On3 · July 28, 2008

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

fdLP. · July 28, 2008

<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

Th3On3 · July 28, 2008

OMG THANK YOU ^^ For the fast reply

hozuke · August 2, 2008

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

kblo138 · September 30, 2008

Thx man i post im my site realy useful

sorry my english! Oo

Ident · September 30, 2008

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? -.-

macdonald12 · September 30, 2008

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 ;)

eKoIce · October 1, 2008

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

Darion · May 20, 2009

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

WizZy™ · May 20, 2009

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

[HELP] RaidBoss Status PhP Script?

Question

Th3On3

Link to comment

Share on other sites

9 answers to this question

Recommended Posts

fdLP.

Link to comment

Share on other sites

Th3On3

Link to comment

Share on other sites

hozuke

Link to comment

Share on other sites

kblo138

Link to comment

Share on other sites

Ident

Link to comment

Share on other sites

macdonald12

Link to comment

Share on other sites

eKoIce

Link to comment

Share on other sites

Darion

Link to comment

Share on other sites

WizZy™

Link to comment

Share on other sites

Posts

Topics

Browse

Activity

Store