Jump to content
  • 0

online script rb's


rullezz

Question

hi all!

1) I have one problem,look i have script for raid bosses status...if i kill any rb at web site don't showing status(dead) i need to restart my server to see this in my site...in db respawn_time don't change at once i need to rr server lol! how can i fix this?

 

2) i have this script:

<html>

<head>

<title>

Raidboss info

</title>

</head>

<body>

<table>

<b>(Table will be updated after auto restart at:<br> 01:00:00 +3 GMT)</b>

<br><br>

<font color="0000FF">Raid Bosses</font>

<tr><td>Name</td><td>Status</td><td></td></tr><br>

<?php

$hostname = "localhost"; // your database location

$database = "oldl2";

$user = "root"; // your database user

$pass = ""; // your database password

 

$connect = @mysql_connect($hostname, $user, $pass);

@mysql_select_db($database, $connect);

 

if(!$connect)

echo 'Can\'t connect to the database';

else

{

$raidspawn = mysql_query("SELECT bossid,respawnDate FROM grandboss_intervallist ORDER BY respawnDate DESC");

while(list($bossid,$respawnDate) = mysql_fetch_row($raidspawn))

{

$raidnames = mysql_query("SELECT name FROM npc WHERE id = $bossid");

$text = '<font color="00FF00">alive</font>';

 

if($respawnDate > 0)

{

$respawntime = date('r',($respawnDate / 1000));

$text = '<font color="FF0000">dead</font>';

 

}

 

while(list($raidname) = mysql_fetch_row($raidnames))

{

echo '<tr><td>'.$raidname.'</td><td>'.$text.'</td><td>'.$respawn.'</td></tr>';

}

}

}

?>

<?php

$hostname = "localhost"; // your database location

$database = "l2jdb";

$user = "root"; // your database user

$pass = ""; // your database password

 

$connect = @mysql_connect($hostname, $user, $pass);

@mysql_select_db($database, $connect);

 

if(!$connect)

echo 'Can\'t connect to the database';

else

{

$raidspawn = mysql_query("SELECT boss_id,respawn_time FROM raidboss_spawnlist ORDER BY respawn_time DESC");

while(list($boss_id,$respawn_time) = mysql_fetch_row($raidspawn))

{

$raidnames = mysql_query("SELECT name FROM npc WHERE id = $boss_id");

$text = '<font color="00FF00">alive</font>';

$respawn = '<font color="0000FF"></font>';

if($respawn_time > 0)

{

$respawntime = date('r',($respawn_time / 1000));

$text = '<font color="FF0000">dead</font>';

 

}

 

while(list($raidname) = mysql_fetch_row($raidnames))

{

echo '<tr><td>'.$raidname.'</td><td>'.$text.'</td><td>'.$respawn.'</td></tr>';

}

}

}

?>

</table>

</body>

</html>

 

How can i add rb one by one,not all.....with pic an RB with status Alive/Death?

 

thx.

 

 

Link to comment
Share on other sites

9 answers to this question

Recommended Posts

  • 0

Well , maybe the script is not working or your web cannot connect to your server.

 

Try to search another script for rb's and try again.

 

If this happens again , open the port 80 in your router.

Link to comment
Share on other sites

  • 0

look i mean if i kill Raid boss in db respawn_time don't change i need to do restart for this.

script don't have any problem....

i can't understand why i need to do restart for respawn_time in db ?

Link to comment
Share on other sites

  • 0

go in java/net/l2off/gameserver/instancemanager/RaidBossSpawnManager.java  , find ->"  //updateDb(); " and delete the comment " // " then compile and the raidboss status will be updated immediatly!

 

http://l2joff.info -> The best interlude project !

Link to comment
Share on other sites

  • 0

what i need to delete here? :S

 

   updateDb();

    _bosses.clear();

    if (_schedules != null)
    {
      for (Iterator i$ = _schedules.keySet().iterator(); i$.hasNext(); ) { Integer bossId = (Integer)i$.next();

        ScheduledFuture f = (ScheduledFuture)_schedules.get(bossId);
        f.cancel(true);
      }
    }

    _schedules.clear();
    _storedInfo.clear();
    _spawns.clear();
  }

  private class spawnSchedule
  implements Runnable
  {
    private int bossId;

    public spawnSchedule(, int paramInt)
    {
      this.bossId = npcId;
    }

    public void run()
    {
      L2RaidBossInstance raidboss = null;

Link to comment
Share on other sites

  • 0

see if ... else clause.

 

if ($respawntime>"0")

{

$text='dead';

}

else

{

$text='alive';

}

 

 

.....

 

Echo '$raidbossname $text';

 

What is this?....

 

Mmmm any one have good working scrip or i need to fix something in java/net/l2off/gameserver/instancemanager/RaidBossSpawnManager.java  ?....

Link to comment
Share on other sites

  • 0

This script php for gracia final

 

 

$result1 = mysql_query("SELECT `boss_id`, `respawn_time` FROM `grandboss_data` ORDER by `boss_id` DESC ") or die(mysql_error());

echo "<table border='1'><tr>";
echo "<th class='Stil5'><center>Position</center></th>";
echo "<th class='Stil5'><center> GrandBoss Name  </center></th>";
echo "<th class='Stil5'><center> Level  </center></th>";
echo "<th class='Stil5'><center> Status  </center></th>";
echo "<th class='Stil5'><center> Drop List  </center></th>";
echo "<th class='Stil5'><center> Map  </center></th>";
echo "</tr>";

$i=1;

while($row1=mysql_fetch_row($result1))
{


$result2 = mysql_query("SELECT `name`, `level` FROM `npc` WHERE `id` = '$row1[0]'");
$row2 = mysql_fetch_row($result2);
$respawn=$row1[1];
if($respawn == "0")
{
$online="<font color=#00FF00>Alive</font>";
}
else
{
$online="<font color=#ff0000>Dead</font>";
}
echo "<tr>";
echo "<td class='Stil5'><center> $i  </center></td>";
echo "<td class='Stil5'><center>$row2[0]</center></td>";
echo "<td class='Stil5'><center> $row2[1]</center></td>";
echo "<td class='Stil5'><center> $online  </center></td>";
echo "<td class='Stil5'><center><a href='clan/droplist.php?id=$row1[0]' target='_blank''>View</a></center></td>";
echo "<td class='Stil5'><center><a href='clan/map.php?id=$row1[0]' target='_blank''> Loc</a></center></td>";
echo "</tr>";

$i++;

}
echo "</table>";

Link to comment
Share on other sites

Join the conversation

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

Guest
Answer this question...

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



  • Posts

    • ( +256754809279 ) MOST EFFECTIVE REVENGE DEATH SPELLS CASTER USA, UK, BAHAMAS, BAHRAIN, NEW ZEALAND, SPAIN AUSTRALIA SOUTH CAROLINA. +256754809279 drmama Tango, Powerful instant death spells online instant spell that work fast in USA, UK, Kuwait, Germany, Asian, Europe, Philippines, Canada, South Africa, Italy, Peru, India, Iran, Gambia. Sweden, Australia, Nigeria, Spain, Ghana, California, Greece. Death spell on someone, death spells that Death Revenge Spell on wicked friends, Voodoo Death Spells to kill Enemies Black Magic Spells To Harm Someone, Black magic death spells on ex-lover, Revenge instant death spells on toxic uncles powerful instant death spells online instant spell that work fast in USA, UK, Kuwait, Germany, Asian, Europe, Philippines, Canada, revenge spells, most powerful death spell, spell to die in your sleep, successful death spell, most powerful voodoo spell caster, voodoo spell casters in new Orleans, voodoo love spells reviews, proven authentic voodoo spell casters, most powerful voodoo priest in world, black magic tricks to destroy enemy. Results are 100% sure and guaranteed , Europe, Philippines, Canada, South Africa, Italy, Peru, India, Iran, Gambia. spells, guaranteed voodoo spells, spell to make someone sick and die, revenge spells that work instantly, real witches for hire, revenge spells on an ex- lover, how to put a spell on someone who hurts you, spell to make someone sick, voodoo spells to hurt someone, spells to curse someone, powerful revenge spells, most powerful death spell, spell to die in your sleep, successful death spell. +256754809279 drmama Tango Email: drmamatango@gmail.com
    • Psychic Readings | Astrology | Love Spells | Black Magic spells | Witchcraft Spells | Spell Caster | Voodoo spells | Marriage spells | Divorce spells | Attraction spells | Bring back lost lover spells REUNITE WITH AN EX LOVER IN 72 HOURS If your lover is gone, don't be desperate anymore! You are a few clicks away from a prompt resolution of your problem: We will our spiritual powers to bring him/her back Let us show you our method with zero chances of rejection. Don't waste your precious time; get your lover back NOW! MAKE HIM/HER LOVE ME  Don't wait for the deluge and make him or her love you now. This service will create a great alchemy between this person and you. In just a few weeks, you can make the person you dream of falling in love with you. We recommend you to combine this service with a Marriage ritual if you want this person to commit you. BREAK UP A RELATIONSHIP The perfect service to break up a relationship you don't think legitimate. Your lover has gone with someone else Don't hesitate to break them up as this ritual and prayer is very powerful and will give very good results in a few weeks only. STOP A DIVORCE NOW  Order this service now to reinforce the bonds of your relationship and save your marriage. This service will make him/her realize that a divorce would be a mistake and will strengthen love and passion. With permanent results, this service will guarantee a long lasting marriage and will make you happy. FAITHFULNESS  Your partner cheats on you? This love ritual is definitely the one you need!  LOVE CHARMS   
    • Psychic Readings | Astrology | Love Spells | Black Magic spells | Witchcraft Spells | Spell Caster | Voodoo spells | Marriage spells | Divorce spells | Attraction spells | Bring back lost lover spells REUNITE WITH AN EX LOVER IN 72 HOURS If your lover is gone, don't be desperate anymore! You are a few clicks away from a prompt resolution of your problem: We will our spiritual powers to bring him/her back Let us show you our method with zero chances of rejection. Don't waste your precious time; get your lover back NOW! MAKE HIM/HER LOVE ME  Don't wait for the deluge and make him or her love you now. This service will create a great alchemy between this person and you. In just a few weeks, you can make the person you dream of falling in love with you. We recommend you to combine this service with a Marriage ritual if you want this person to commit you. BREAK UP A RELATIONSHIP The perfect service to break up a relationship you don't think legitimate. Your lover has gone with someone else Don't hesitate to break them up as this ritual and prayer is very powerful and will give very good results in a few weeks only. STOP A DIVORCE NOW  Order this service now to reinforce the bonds of your relationship and save your marriage. This service will make him/her realize that a divorce would be a mistake and will strengthen love and passion. With permanent results, this service will guarantee a long lasting marriage and will make you happy. FAITHFULNESS  Your partner cheats on you? This love ritual is definitely the one you need!  LOVE CHARMS   
    • Psychic Readings | Astrology | Love Spells | Black Magic spells | Witchcraft Spells | Spell Caster | Voodoo spells | Marriage spells | Divorce spells | Attraction spells | Bring back lost lover spells REUNITE WITH AN EX LOVER IN 72 HOURS If your lover is gone, don't be desperate anymore! You are a few clicks away from a prompt resolution of your problem: We will our spiritual powers to bring him/her back Let us show you our method with zero chances of rejection. Don't waste your precious time; get your lover back NOW! MAKE HIM/HER LOVE ME  Don't wait for the deluge and make him or her love you now. This service will create a great alchemy between this person and you. In just a few weeks, you can make the person you dream of falling in love with you. We recommend you to combine this service with a Marriage ritual if you want this person to commit you. BREAK UP A RELATIONSHIP The perfect service to break up a relationship you don't think legitimate. Your lover has gone with someone else Don't hesitate to break them up as this ritual and prayer is very powerful and will give very good results in a few weeks only. STOP A DIVORCE NOW  Order this service now to reinforce the bonds of your relationship and save your marriage. This service will make him/her realize that a divorce would be a mistake and will strengthen love and passion. With permanent results, this service will guarantee a long lasting marriage and will make you happy. FAITHFULNESS  Your partner cheats on you? This love ritual is definitely the one you need!  LOVE CHARMS   
    • Psychic Readings | Astrology | Love Spells | Black Magic spells | Witchcraft Spells | Spell Caster | Voodoo spells | Marriage spells | Divorce spells | Attraction spells | Bring back lost lover spells REUNITE WITH AN EX LOVER IN 72 HOURS If your lover is gone, don't be desperate anymore! You are a few clicks away from a prompt resolution of your problem: We will our spiritual powers to bring him/her back Let us show you our method with zero chances of rejection. Don't waste your precious time; get your lover back NOW! MAKE HIM/HER LOVE ME  Don't wait for the deluge and make him or her love you now. This service will create a great alchemy between this person and you. In just a few weeks, you can make the person you dream of falling in love with you. We recommend you to combine this service with a Marriage ritual if you want this person to commit you. BREAK UP A RELATIONSHIP The perfect service to break up a relationship you don't think legitimate. Your lover has gone with someone else Don't hesitate to break them up as this ritual and prayer is very powerful and will give very good results in a few weeks only. STOP A DIVORCE NOW  Order this service now to reinforce the bonds of your relationship and save your marriage. This service will make him/her realize that a divorce would be a mistake and will strengthen love and passion. With permanent results, this service will guarantee a long lasting marriage and will make you happy. FAITHFULNESS  Your partner cheats on you? This love ritual is definitely the one you need!  LOVE CHARMS   
  • Topics

×
×
  • Create New...