--- a/details.php Tue May 19 00:30:06 2009 +0100
+++ b/details.php Tue May 19 08:30:24 2009 +0100
@@ -1,6 +1,6 @@
<?php
// read user ID from cookie, if cookie doesn't exist, set to 1 (master)
- $currID = $_COOKIE['h4c_ID'];
+ $currID = $_COOKIE['n4c_ID'];
if ($currID == "")
{
@@ -13,25 +13,25 @@
// connect to the database
- $conn = mysql_connect('localhost','root','') or die(mysql_error());
- mysql_select_db('h4c_db');
+ $conn = mysql_connect('localhost','www-data','www-data') or die(mysql_error());
+ mysql_select_db('members');
// search server cache for received websites
if ($currID != 1)
{
- $query_cache = mysql_query("SELECT * FROM requests_tbl WHERE (user_ID = '$currID' OR user_ID = 1)");
+ $query_cache = mysql_query("SELECT * FROM requests_tbl WHERE (uid = '$currID' OR uid = 1)");
}
else
{
- $query_cache = mysql_query("SELECT * FROM requests_tbl WHERE (user_ID = 1)");
+ $query_cache = mysql_query("SELECT * FROM requests_tbl WHERE (uid = 1)");
}
while ($db_fieldcache = mysql_fetch_assoc($query_cache))
{
// send command to squid and return value
$curr_reqID = $db_fieldcache["req_ID"];
- $commandline = "squidclient -m HEAD -p 8080 -H \"Cache-Control: only-if-cached\n\" -u " . $db_fieldcache["req_ID"] . " -w " . $db_fieldcache["user_ID"] . " " . $db_fieldcache["req_val"] . " |grep X-Cache: |grep MISS";
- exec($commandline, $cache_results);
+# $commandline = "squidclient -m HEAD -p 8080 -H \"Cache-Control: only-if-cached\n\" -u " . $db_fieldcache["req_ID"] . " -w " . $db_fieldcache["uid"] . " " . $db_fieldcache["req_val"] . " |grep X-Cache: |grep MISS";
+# exec($commandline, $cache_results);
// find out if site is available and update the database
if (strpos($cache_results, "HIT") == true)
@@ -67,15 +67,15 @@
// pick relervant mySQl QUERY
if ($view_mode == "public")
{
- $query = mysql_query("SELECT * FROM requests_tbl WHERE (user_ID = 1) ORDER BY " . $order_sql);
+ $query = mysql_query("SELECT * FROM requests_tbl WHERE (uid = 1) ORDER BY " . $order_sql);
}
else if ($view_mode == "all")
{
- $query = mysql_query("SELECT * FROM requests_tbl WHERE (user_ID = '$currID' OR user_ID = 1) ORDER BY " . $order_sql);
+ $query = mysql_query("SELECT * FROM requests_tbl WHERE (uid = '$currID' OR uid = 1) ORDER BY " . $order_sql);
}
else
{
- $query = mysql_query("SELECT * FROM requests_tbl WHERE (user_ID = '$currID') ORDER BY " . $order_sql);
+ $query = mysql_query("SELECT * FROM requests_tbl WHERE (uid = '$currID') ORDER BY " . $order_sql);
}
@@ -94,14 +94,14 @@
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
-<title>H4C - Welcome. <?php print $search_info; ?></title>
-<link href="files/h4c_main.css" rel="stylesheet" type="text/css" media="screen" />
+<title>N4C - Welcome. <?php print $search_info; ?></title>
+<link href="files/n4c_main.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<div id="container">
<div id="header">
- <h1><span>H4C</span></h1>
+ <h1><span>N4C</span></h1>
<p id="credits">HTML Requester v. 1.00</p>
</div>
<?php
@@ -161,7 +161,7 @@
while ($db_field = mysql_fetch_assoc($query))
{
- if ($db_field['user_ID'] != 1 and $view_mode == "all")
+ if ($db_field['uid'] != 1 and $view_mode == "all")
{
print "<div class='search_result_private'><span class='result_no'>" . $search_count . "</span> ";
print "<span class='search_txt'>Search:</span><span class='search_input'><em>" . $db_field['req_val'] . "</em></span> ";