2 $db['host'] = "localhost";
3 $db['user'] = "neonserv";
5 $db['base'] = "neonserv";
7 $db['conn'] = @mysql_connect($db['host'], $db['user'], $db['pass']) or die(mysql_error());
9 $mysql_connection=TRUE;
10 mysql_select_db($db['base'], $db['conn']) OR $mysql_connection=FALSE;
13 if(!$mysql_connection)
14 die("no connection to the MySQL Server.");
18 if(!is_numeric($id) || strlen($key) != 32)
21 $result = mysql_query("SELECT `nick`, `hand`, `host`, `time`, `status`, `text`, `log`, `supporter`, `users`.`user_user`, MD5(CONCAT(`id`, `host`, `time`, `supporter`)) FROM `helpserv_requests` LEFT JOIN `users` ON `supporter` = `user_id` WHERE `id` = '".mysql_real_escape_string($id)."';");
22 if(mysql_num_rows($result) == 0)
24 $row = mysql_fetch_row($result);
25 if(strtolower($row[9]) != strtolower($key))
29 <table border="1" width="600">
31 <td width="150">Nick:</td>
32 <td><?php echo$row[0]; ?></td>
35 <td width="150">Hostmask:</td>
36 <td><?php echo$row[2]; ?> (auth: <?php echo$row[1]; ?>)</td>
39 <td width="150">Time</td>
40 <td><?php echo date("d.m.Y H:i:s", $row[3]); ?></td>
43 <td width="150">State</td>
49 echo "active (".$row[8].")";
51 echo "closed (".($row[7] == 0 ? "*" : $row[8]).")";
56 <td colspan="2"><span style="font-size:10pt; font-family:Courier New;"><?php echo str_replace("\n", "<br>", $row[5]); ?></span></td>
59 <td colspan="2"><span style="font-size:10pt; font-family:Courier New;"><?php echo str_replace("\n", "<br>", $row[6]); ?></span></td>