Jump to content
--> Place your ad text here <--
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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
Go to topic listing


  • Posts

    • Tinker123aa
      @Maxtor, What Happened to Your Forum?

      By Tinker123aa · Posted

      it's great that you know who these files come from... you shouldn't forget vanganth too! now it is very easy, you take my last revision of svn and compare it against those files.... when you finish analyzing and comparing you should do the following... which will be very easy to check...   once everything is checked, analyze what did L2Devs do hahaha   I who give away the files, make me problem. L2Devs is SCAMMING people, selling something free and you don't say anything... It is something very strange what happens .... Besides you ripped me off 100usd, but I hope you got server to eat at least. PD: the day you take it back and return my 100usd I will forgive you and pretend that nothing ever happened 😉
    • JulioPradosk8
      [MOD] System DressMe

      By JulioPradosk8 · Posted

      🔥 Apresentação I present to you a new fully customized DressMe system, developed for DreamV2, inspired by the best servers and enhanced with unique features that guarantee performance, customization and stunning visuals. ✨ Funcionalidades ✅ Aplicação de visual de armas e armaduras sem alterar o item real equipado. ✅ Compatível com qualquer tipo de arma/armadura (ex: skins de bow visíveis apenas com bows equipados). ✅ Remoção automática do visual quando parte do set real é desequipada. ✅ Efeitos visuais (skills) aplicados com suporte a: Aplicação única ou recorrente Intervalo configurável via XML Remoção automática ao desativar o visual ✅ Interface limpa e lógica modular, fácil de expandir com novos visuais ou efeitos.     <?xml version="1.0" encoding="UTF-8"?> <dressMeList> <dress skillId="9100" name="Draconic Armor" type="ARMOR" isVip="false" > <visualSet chest="6379" legs="0" gloves="6380" feet="6381" helmet="6841" /> <visualEffect skillId="445" level="1" recurring="true" interval="35" /> </dress> <dress skillId="9102" name="Cloak Style Armor" type="CLOAK" isVip="false"> <visualSet chest="7000" legs="0" gloves="0" feet="0" helmet="0" /> <visualEffect skillId="10005" level="1" recurring="false" /> </dress> <dress skillId="9103" name="Valakas Style Weapon" type="WEAPON" isVip="false"> <visualWep type="bow" rhand="7575" lhand="0" lrhand="0" /> <visualEffect skillId="10005" level="1" recurring="false" /> </dress> </dressMeList> 📸 Imagens & Vídeo 🛠️ Detalhes Técnicos Desenvolvido com base no L2J DreamV2 Integração direta com L2PcInstance, Inventory, ThreadPoolManager e SkillTable Sistema de gerenciamento central via DressMeEffectManager Agendamento e cancelamento seguro de efeitos recorrentes Totalmente thread-safe e compatível com jogadores offline 📂 Instalação A instalação é feita via patch e inclui: Classes: DressMeHolder, DressMeEffectManager, modificações em L2PcInstance XML de exemplo Suporte completo à expansão por armas, cloaks e visuais parciais 📎 Download https://pastebin.com/raw/7i843yKh 💬 Feedback & Sugestões Sinta-se à vontade para comentar abaixo com sugestões, dúvidas ou feedbacks. Toda contribuição é bem-vinda para futuras versões!
    • SkyLord
      @Maxtor, What Happened to Your Forum?

      By SkyLord · Posted

      @Tinker123aa Guytis, I have nothing against you, but it's very clear to me who is behind this files. I'm talking about the one that came with the captcha anti-bot system. I personally bought it from the real owner, who was one of the administrators of L2Gold.cc. This can be confirmed by him if he wishes. 😊 Maybe you worked on the files, but they didn’t start from you.   To the people trying to buy the files I’m just advising you not to waste your money. This is 100% verified information.   I honestly don't know how people believe you. 🙂 I'll share the link to the guy's topic below.   ps  
    • SkyLord
      [L2OFF] L2Etina x50

      By SkyLord · Posted

      [L2OFF]? goodluck
    • NightFoxV
      L2J Eternity [High Five 5] Emulator

      By NightFoxV · Posted

      Hello,  Anyone knows how I can communicate to purchase this emulator.  Nobody answered in the forum of eternity neither Kate neither lord winter.    Thanks in advance.

  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock