header("Location: GuildBuddyList.php?guild=Your+guild+here");
die();
session_start();
require_once("../../psolbl/connect.inc.php");
require_once("../../psolbl/getLaanxStatus.inc.php");
?>
PlaneShift Online Buddylist
$query = "SELECT * FROM online";
$result = mysql_query($query);
if($result)
{
if(mysql_num_rows($result) > 0)
{
$online = mysql_fetch_assoc($result);
}
$now = strtotime(date("Y-m-d H:i"));
$last_online = strtotime($online["lastupd"]);
trigger_error("Last online: ".date("r", $last_online));
trigger_error("Time is now: ".date("r", $now));
$players = explode("\n", $online["names"]);
if((mysql_num_rows($result) == 0) || ($last_online < $now))
{
$laanx = getLaanxStatus();
switch($laanx["result"])
{
case LAANX_OK:
$player_arr = $laanx["players"];
if(!is_array($player_arr) || empty($player_arr)) $player_arr = array();
$players = array_keys($player_arr);
sort($players);
$names = mysql_real_escape_string(implode("\n", $players));
$lastupd = date("Y-m-d H:i", $now);
$query = "UPDATE online SET names = '".$names."', lastupd = '".$lastupd."'";
$result = mysql_query($query);
break;
case LAANX_UNINIT:
trigger_error("Laanx status not initialised");
break;
case LAANX_NO_CONN:
trigger_error("Laanx status not retrieved");
break;
case LAANX_BAD_XML:
trigger_error("Laanx status not interpreted");
break;
default:
trigger_error("Laanx status unknown!");
}
}
}
else die("Unable to request online list");
if(empty($_SESSION["user"]))
{
if($_REQUEST["show"] > 0)
{
$query = "SELECT name, level FROM buddy WHERE user_id = ".intval($_REQUEST["show"]);
$result = mysql_query($query);
if($result && (($num_rows = mysql_num_rows($result)) > 0))
{
$buddies = array();
for($idx = 0; $idx < $num_rows; $idx++)
{
$buddy = mysql_fetch_assoc($result);
$buddies[$buddy["name"]] = $buddy["level"];
}
}
}
}
else
{
}
?>
Last online: Thu, 01 Jan 1970 01:00:00 +0100
Players in database:
var_export($players); ?>
Players online:
var_export($laanx); ?>