Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing

[Share]GrandBoss Respawn Php Script

EdenEternal
 Share

Recommended Posts

EdenEternal Newbie

EdenEternal

Posted
Posted

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!

EdenEternal Newbie

EdenEternal

Posted
  • Author
Posted

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

sekker Newbie

sekker

Posted
Posted

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

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


  • Posts

    • Nightw0lf
      Outerlude - A Modern Interlude aCis fork

      By Nightw0lf · Posted

      Migrating a legacy Interlude server to PostgreSQL while adding real observability is basically forcing 2006 MMO engineering to attend a 2026 infrastructure conference at gunpoint. PS: which revision of aCis? PS: 🧻what was broken during this whatever you call it.    AAC Guard beign asked to adapt to this be like: - Creating bugs since early 2018
    • Splicho
      Outerlude - A Modern Interlude aCis fork

      By Splicho · Posted

      OH MY LORDDDDDDDDDDDDDDDDDDDDD   FINALLY
    • KONOPIA
      [L2] VISERION

      By KONOPIA · Posted

      no discord ?
    • sellerking
      ⭐ buyingproxy.com | ⭐ $0.95/GB ⭐ Residential Proxies - 80M+

      By sellerking · Posted

      TG Support: https://t.me/buyingproxysup | Channel: https://t.me/buyingproxycom Discord support: #buyingproxy | Server: Join the BuyingProxy Discord Server!  Create your free account here
    • Elfo
      Outerlude - A Modern Interlude aCis fork

      By Elfo · Posted

      I came out of my cave as I do once every 5 years. By now, I know nobody really cares about L2, but I still find it fun to experiment. Everything you see here will be free and open source. I have no interest in selling anything.   Long story short, I like to revisit Interlude and apply what I've learned to see how far I can push it. Here's Outerlude, a public fork of aCis for the modern age.   Video demo:   Work that has been done:   Redone the netcode from scratch to be async The NPC AI was completely redone based on Finite State Machines Moved to PostgreSQL and using some of its cool features Lots of config that should be hot reloadable has moved to the database OpenTelemetry instrumentation, where it makes sense, and a Grafana dashboard A built-in REST API for server management A built-in MCP Server for LLMs Nidrah AI, an AI Agent to make managing the server easier Real-time server map view Chat auditing and live snooping A new Fake Players Engine with a Node logic system and a new LLM planner for any behavior Just watch the video   If there is interest in this and I'm happy with it, or I get bored (which I always do), I will open-source it. Let me know what you think and if there is some feature you'd like me to implement.

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..