online script rb's

rullezz · December 14, 2009

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>

(Table will be updated after auto restart at: 01:00:00 +3 GMT)

 

Raid Bosses

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

<?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 = 'alive';

if($respawnDate > 0)

{

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

$text = 'dead';

}

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 = 'alive';

$respawn = '';

if($respawn_time > 0)

{

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

$text = 'dead';

}

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.

Commodus · December 15, 2009

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.

rullezz · December 15, 2009

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 ?

michael9ufo · December 18, 2009

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 !

rullezz · December 18, 2009

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;

hoangnhan · December 19, 2009

see if ... else clause.

if ($respawntime>"0")

{

$text='dead';

}

else

{

$text='alive';

}

.....

Echo '$raidbossname $text';

rullezz · December 20, 2009

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

hoangnhan · December 21, 2009

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

Syntax · December 21, 2009

Script will update your website in real time if you replace this:

if($respawn == "0")

{

with this:

if ( $respawn== 0 or time()*1000 > $respawn)

{

rullezz · December 21, 2009

i don't need update site i need update in db ... respawn_time table

online script rb's

Question

rullezz

9 answers to this question

Recommended Posts

Commodus

rullezz

michael9ufo

rullezz

hoangnhan

rullezz

hoangnhan

Syntax

rullezz

Join the conversation

Posts

Topics

Browse

Activity

Store