[Share]GrandBoss Respawn Php Script

EdenEternal · August 1, 2010

Hello Ladies. i want to share php script:GrandBoss Respawn Time.i have bad php skills so if need some fixes please post.

Screen:

So Let's Start

First Create config.php in sites root directory.

<?php
$db_user = "User";
$db_pass = "Password";
$db_name = "l2jdb";
$db_serv = "localhost";
$db_port = "3306";
$res = mysql_connect ( $db_serv, $db_user, $db_pass, $db_port ) or die ("Coudn't connect to [$db_serv]");
mysql_select_db ( $db_name );
?>

Now create grandboss_respawn.php also in sites root directory.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>GrandBoss Status By Leki</title>
<style type="text/css">
<!--
body,td,th {
color: #CCCCCC;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
body {
background-color: #000000;
}
-->
</style>
</head>
<body>
<table style="border: 1px solid; border-color: #444444; background-color:#222222;" align="center" width="100%">
  <tr>
    <th class='Stil7' colspan="5">Grand Boss Status</th>
  </tr>
  <tr>
    <th width="5%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> No </th>
    <th width="35%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Boss </th>
    <th width="19%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Level </th>
    <th width="19%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Status </th>
    <th width="20%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Respawn time </th>
  </tr>

  <?php 
require("Config.php");
$activity = mysql_query("SELECT grandboss_data.respawn_time, grandboss_data.status, npc.name, npc.level 
	FROM grandboss_data 
	LEFT JOIN npc ON grandboss_data.boss_id = npc.id 
	ORDER BY npc.level DESC");
$i = 1;

while($row = mysql_fetch_array($activity))

{
	if (!($i%2)) echo "<tr bgcolor='#000000' align='center'>";
	else
	echo "<tr bgcolor='#161616' align='center'>";
	echo "<td>"."<center>".$i."</center>"."</td>";
	echo "<td>"."<center>".$row['name']."</center>"."</td>";
	echo "<td>"."<center>".$row['level']."</center>"."</td>";
	echo "<td align='center'>";
	    if ($row['status'] == 2)
		{
echo "Dead";
}
else
echo "Live";
	echo "</td>";
	echo "<td>"."<center>".date("D\, j M Y H\:i",$row['respawn_time'])."</center>"."</td>";
	$i++;
}
?>
</table>
</body>
</html>

Works on Interlude La2base Pack!

Credits to Me!

SoRa · August 1, 2010

Good job Leki.Keep sharing. :)

Onix · August 1, 2010

excellent share and good work, thnx for your share ! :P

TsIpIzTiK® · August 1, 2010

i have these error

screen :

EdenEternal · August 1, 2010

why you change format from php to html? format must be *.php

a1 · August 1, 2010

usefull, nice work =] looks beutiful

sekker · August 3, 2010

I doesn't work for me, it simply shows an empty table :s BTW does this work with l2jfree? if not can you help me to adapt it?

leoadrian · August 3, 2010

i have these error

screen :

sure u dont change the configuration, remember u have to put ur db configuration.

Good job Leki. Keep sharing. u are betwen mi favorites.

EdenEternal · August 3, 2010

I doesn't work for me, it simply shows an empty table :s BTW does this work with l2jfree? if not can you help me to adapt it?

which chonicle you use?

if gf there is not grandboss_data.sql table so you need this query

SELECT grandboss_spawnlist.respawn_time, npc.name, npc.level 
	FROM grandboss_data 
	LEFT JOIN npc ON grandboss_spawnlist.boss_id = npc.id 
	ORDER BY npc.level DESC

AzMaKiEl · August 5, 2010

i have these error

screen :

The web is hosted and can connect to the DB? try it, keep connecting the webpage to the database(web + server in same pc) =):D

z3rocool · August 6, 2010

very usefull script... a good design and it`s very good for a website :D :D

sekker · August 9, 2010

which chonicle you use?

if gf there is not grandboss_data.sql table so you need this query
SELECT grandboss_spawnlist.respawn_time, npc.name, npc.level 
	FROM grandboss_data 
	LEFT JOIN npc ON grandboss_spawnlist.boss_id = npc.id 
	ORDER BY npc.level DESC

Nope it didn't work :s here i leave you my whole php file, maybe im doing something wrong.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>GrandBoss Status By Leki</title>
<style type="text/css">
<!--
body,td,th {
color: #CCCCCC;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
body {
background-color: #000000;
}
-->
</style>
</head>
<body>
<table style="border: 1px solid; border-color: #444444; background-color:#222222;" align="center" width="100%">
  <tr>
    <th class='Stil7' colspan="5">Grand Boss Status</th>
  </tr>
  <tr>
    <th width="5%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> No </th>
    <th width="35%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Boss </th>
    <th width="19%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Level </th>
    <th width="19%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Status </th>
    <th width="20%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Respawn time </th>
  </tr>

<?php 
require("Config.php");
$activity = mysql_query("SELECT grandboss_spawnlist.respawn_time, npc.name, npc.level 
	FROM grandboss_data 
	LEFT JOIN npc ON grandboss_spawnlist.boss_id = npc.id 
	ORDER BY npc.level DESC");
$i = 1;

while($row = mysql_fetch_array($activity))

{
	if (!($i%2)) echo "<tr bgcolor='#000000' align='center'>";
	else
	echo "<tr bgcolor='#161616' align='center'>";
	echo "<td>"."<center>".$i."</center>"."</td>";
	echo "<td>"."<center>".$row['name']."</center>"."</td>";
	echo "<td>"."<center>".$row['level']."</center>"."</td>";
	echo "<td align='center'>";
	    if ($row['status'] == 2)
		{
echo "Dead";
}
else
echo "Live";
	echo "</td>";
	echo "<td>"."<center>".date("D\, j M Y H\:i",$row['respawn_time'])."</center>"."</td>";
	$i++;
}
?>
</table>
</body>
</html>

Config.php

<?php
$db_user = "*****";
$db_pass = "*****";
$db_name = "*****";
$db_serv = "localhost";
$db_port = "3306";
$res = mysql_connect ( $db_serv, $db_user, $db_pass, $db_port ) or die ("Coudn't connect to [$db_serv]");
mysql_select_db ( $db_name );
?>

And yes im using L2JFree Gracia Final

Fanky · August 13, 2010

Cool,Very nice Work Leki.

But i think its already shared.

by the way good job.

thanks.

EdenEternal · August 16, 2010

Cool,Very nice Work Leki.

But i think its already shared.

by the way good job.

thanks.

it's not shared.if you have any link share and i will report to close this topic

nemancati · September 3, 2011

a little rework for freya? cause it not working at all

[Share]GrandBoss Respawn Php Script

Recommended Posts

EdenEternal

SoRa

Onix

TsIpIzTiK®

EdenEternal

a1

sekker

leoadrian

EdenEternal

AzMaKiEl

z3rocool

sekker

Fanky

EdenEternal

nemancati

Join the conversation

Posts

Topics

Browse

Activity

Store