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