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

Create an account or sign in to comment

Create an account

Sign in

Posts

Topics

Browse

Activity

Store