require "func.php";
$conf = loadconfig('irclogger.config.php');
header('Content-Type: text/html; charset=utf-8');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<title>IRC channel log</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" media="all" type="text/css" href="style.css" />
</head>
<body>
<?php
$dbh = getdbhandle($conf);
if ($_REQUEST['s']) {
$sql = "SELECT id, DATE(dt) as d, TIME(dt) as t, user, type, msg\n FROM messages\n WHERE MATCH (msg)\n AGAINST ('" . addslashes($_REQUEST['s']) . "')\n ORDER BY dt DESC, id DESC";
} elseif ($_REQUEST['u']) {
$sql = "SELECT dt\n FROM messages\n WHERE user = '******'u']) . "'\n ORDER BY dt DESC, id DESC\n LIMIT 1";
$res = mysql_query($sql, $dbh);
$row = mysql_fetch_array($res, MYSQL_ASSOC);
if ($row['dt']) {
$sql = "SELECT id, DATE(dt) as d, TIME(dt) as t, user, type, msg\n FROM messages\n WHERE dt >= '" . addslashes($row['dt']) . "'\n ORDER BY dt, id";
} else {
echo 'Could not find any logs for user ' . htmlspecialchars($_REQUEST['u']);
$sql = '';
}
} else {
if ($_REQUEST['d']) {
$date = $_REQUEST['d'];
<?php
require 'func.php';
$conf = loadconfig('doorlogger.config.php');
$con = getdbhandle($conf);
$sql = "select * from doorEvents order by dtEventDate DESC limit 1";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
if ($row['bDoorIsOpen'] == 1) {
echo '<img src=open.png width=100px height=43px>';
} else {
echo '<img src=closed.png width=100px height=43px>';
}
mysql_close($con);
