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

Link to comment

Share on other sites

9 answers to this question

Recommended Posts

Commodus

Link to comment

Share on other sites

rullezz

Link to comment

Share on other sites

michael9ufo

Link to comment

Share on other sites

rullezz

Link to comment

Share on other sites

hoangnhan

Link to comment

Share on other sites

rullezz

Link to comment

Share on other sites

hoangnhan

Link to comment

Share on other sites

Syntax

Link to comment

Share on other sites

rullezz

Link to comment

Share on other sites

Join the conversation

Posts

Topics

Browse

Activity

Store