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!

leoadrian Newbie

leoadrian

Posted
Posted

i have these error

screen : 26294851.png

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

    • Constellation
      JewStor Service ➤ Verified Accounts, Drop Service etc.

      By Constellation · Posted

      Inventory restock: Premium business accounts are now available.   ✔ Wallester Business EU 🇪🇺|💳 Unlimited virtual cards, physical cards, 🏦 multi-currency IBAN, ₿ crypto & stablecoin deposits. ✔ Stripe Business UK 🇬🇧|💳 Instant virtual cards (Visa/Mastercard), high-conversion checkout, multi-currency payouts, ₿ crypto payments, no-code payment links. ✔ Mercury Business US 🇺🇸|🏦 US checking & savings, 💳 unlimited virtual cards, domestic & International wires, native stablecoin settlement. ✔ Payset Business EU 🇪🇺|🏦 Multiple IBANs, UK sort code, SEPA Instant, 💳 unlimited virtual cards, multi-currency accounts. ✔ Novo Business US 🇺🇸|🏦 Business checking account, ACH payments & invoicing, 💳 virtual & physical cards, novo boost.
    • THEFINK
      🧵 [FREE RELEASE] L2Updater + AntiCheat + Build System + Ful

      By THEFINK · Posted

      Let me see if I understand correctly, older gentlemen, when a newcomer shows up to create modern things with the help of AI, doing what you charge them to do, you point the finger and laugh. I believe that's why everything is stagnant. The product isn't for programming experts, it's for newcomers. Don't buy from you if they can do it themselves using this base. You're going to deliver a similar product, maybe even worse than this one, so why are you complaining? PowerShell, as you well know, started with it, then came new platforms and new apps, new creation models, all with different languages; I chose the simplest one for my taste. This is about being organized and knowing how to choose the right words for each situation. It's not 100%, but it already gives a good impression. Nothing is 100%, so a topic written by AI, and all the code that you charge an absurd amount for to prohibit and sell hacks, could be open source so that everyone can create new practices, new models, new information for passing packets, prohibiting the use of cheats that cause server owners to break so much. Let's remember that the Admin doesn't always shut down the server; it's the players who find problems and take advantage by buying and reselling items, and they say that the GM shuts down the server every week, but that's a lie. What they do is duplicate items with packages and sell them, but perhaps this could give some future developers a starting point to create their own protection following the model in the initial documentation. Because none of you answer a question from a newbie, you think you're superior because you have knowledge, but with AI, people like that can have the same knowledge as you, but with less practice. And if they practice a lot, 10,000 hours, they can be as good as all of you older developers in the L2J field.
    • 911reg
      🧵 [FREE RELEASE] L2Updater + AntiCheat + Build System + Ful

      By 911reg · Posted

      even the fucking post is AI, insane
    • BoostLike
      Boost-Like Store>GitHub Services: Followers, Stars, Forks

      By BoostLike · Posted

      ✨ Exclusive Offer for Marketplace Growth 🔥 Elevate your performance with a premium bonus. 💲 Top up your balance with $100 or more and receive an additional $5 credit — seamlessly added to your account. ⭐️ Designed for those who value efficiency, scale, and results. ⚡️ Effortless. Refined. Effective. 💥 Enhance your strategy today 💥
    • `Sanctus
      🧵 [FREE RELEASE] L2Updater + AntiCheat + Build System + Ful

      By `Sanctus · Posted

      Common AI Brazilian Slop

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