Jump to content

[Share]GrandBoss Respawn Php Script


Recommended Posts

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

 

Screen:

84770909.png

 

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 1 year later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...