diff -r e2ac834162fb -r 3ad193634e5d details.php_lessold --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/details.php_lessold Tue Jul 07 19:14:12 2009 +0100 @@ -0,0 +1,278 @@ +query("SELECT sid, sid_dir FROM sessions WHERE ((uid = '$currID' or uid = 1) AND (expiration_date = DATE_ADD(NOW(), INTERVAL 24 HOUR)))"); + $row = $result->fetch_assoc(); + $tsid1 = $row["sid"]; + $tsid2 = $row["sid_dir"]; + $result->close(); + + + } + // read session IDs from cookie, if cookie doesn't exist, set to 06D5VlLQTbM57LL7IBMW38yHkFpb1XVa (master) + + + +//echo $_COOKIE["sid1"]; + $currSID1 = $_COOKIE['sid1']; + if ($currSID1 == "") + { + // $currSID1 = "06D5VlLQTbM57LL7IBMW38yHkFpb1XVa"; + $currSID1 = $tsid1; +echo $currSID1; + + } + + $currSID2 = $_COOKIE['sid2']; + if ($currSID2 == "") + { +// $currSID2 = "06D5VlLQTbM57LL7IBMW38yHkFpb1XVa"; + $currSID2 = $tsid2; +echo $currSID2; + } + +print_r($_COOKIE); + + $status = $_GET['alert']; + $view_mode = $_GET['view_mode']; + $view_order = $_GET['view_order']; + + + // connect to the database + $conn = mysql_connect('localhost','www-data','www-data') or die(mysql_error()); + mysql_select_db('members'); + + // search server cache for received websites + // anonymous uid=1, sid1=06D5VlLQTbM57LL7IBMW38yHkFpb1XVa & sid2 =06D5VlLQTbM57LL7IBMW38yHkFpb1XVa +// if (($currID != 1) && ($currSID1 != "06D5VlLQTbM57LL7IBMW38yHkFpb1XVa")) + if ($currID != 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 (uid = 1)"); + while ($db_fieldcache = mysql_fetch_assoc($query_cache)) + { + // send command to squid and return value + # $command2 = "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"; +# $command2 = "squidclient -m HEAD -p 8080" . $db_fieldcache["req_val"] . " |grep X-Cache: |grep MISS"; +// $command2 = "squidclient -m HEAD -p 8080 -u {$db_fieldcache["req_ID"]} -w $currSID1 http://localhost/router_stage/{$db_fieldcache["req_ID"]}/$strip_url_val/ |grep X-Cache: |grep MISS"; + $command2 = "squidclient -m HEAD -p 8080 -u www-data -w www-data http://localhost/router_stage/{$db_fieldcache["req_ID"]}/$strip_url_val/ |grep X-Cache: |grep MISS"; + exec($command2, $cache_results); + // find out if site is available and update the database + if (strpos($cache_results, "HIT") == true) + { + $query_update = mysql_query("UPDATE responses_tbl SET req_response = '1' WHERE req_ID = '$curr_reqID'"); + } +/* else + { + $query_update = mysql_query("UPDATE responses_tbl SET req_response = '0' WHERE req_ID = '$curr_reqID'"); + $curr_reqID = $db_fieldcache["req_ID"]; + $http_proxy = "http://localhost:8080"; + $staging = "/var/www/private/HTMLrequester/staging/"; + $wget_options = "--delete-after -N -r -l 3 --no-remove-listing -p --max-redirect 10 -t 1 -d"; + $strip_url_val = remove_http($db_fieldcache['req_val']); + $command1 = "wget -P $staging $wget_options http://localhost/router_stage/{$db_fieldcache["req_ID"]}/$strip_url_val/"; + exec($command1, $wget_results); + + } +*/ + } + } + + while ($db_fieldcache = mysql_fetch_assoc($query_cache)) + { + $filename = "/var/www/private/HTMLrequester/router_stage/{$db_fieldcache["req_ID"]}/"; + if (file_exists($filename)) + { + $query_update = mysql_query("UPDATE requests_tbl SET req_response = '1' WHERE req_ID = '$curr_reqID'"); + } + else + { + $query_update = mysql_query("UPDATE requests_tbl SET req_response = '0' WHERE req_ID = '$curr_reqID'"); + } + } + + + // pick order to show (user specified) + + if ($view_order == "pend") + { + $order_sql = "req_response ASC"; + } + else if ($view_order == "date_asc") + { + $order_sql = "req_created ASC"; + } + else if ($view_order == "avail") + { + $order_sql = "req_response DESC"; + } + else + { + $order_sql = "req_created DESC"; + } + + // pick relervant mySQl QUERY + if ($view_mode == "public") + { + $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 (uid = '$currID' OR uid = 1) ORDER BY " . $order_sql); + } + else + { + $query = mysql_query("SELECT * FROM requests_tbl WHERE (uid = '$currID') ORDER BY " . $order_sql); + } + + + // Construct search information message + if ($view_mode == "public") + { + $search_info = "There are " . mysql_num_rows($query) . " saved public searches."; + } else if ($view_mode == "private") { + $search_info = "You have " . mysql_num_rows($query) . " saved private searches."; + } else { + $search_info = "There are " . mysql_num_rows($query) . " saved searches."; + } +?> + + + + + +N4C - Welcome. <?php print $search_info; ?> + + + + +
+ + You have successfully deleted the selected search.
"; + } else if ($status == "add") + { + print "
You have successfully added a new search.
"; + } else if ($status == "urlerror") + { + print "
You have entered an malformed url. Please use this format: http://www.yourwebsite.com
"; + } + ?> + +
+

+
"; + + if ($currID != 1) + { + print " "; + } + + print " "; + print "
"; + ?> + " . $search_count . " "; + print "Search:" . $db_field['req_val'] . " "; + } else { + print "
" . $search_count . " "; + print "Search:" . $db_field['req_val'] . " "; + } + + print "Status:"; + + if ($db_field['req_response'] == 0) + { + print "Result pending"; + print ""; + } else { +//header ('Location: http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . dirname($db_fieldcache["req_ID"])); +//strip_tags($text, '

') + print "View website"; +// print "View website"; + print ""; + } + print "

"; + + $search_count++; + } + + // if no requests, display message + if (mysql_num_rows($query) < 1) + { + print '

You have no previous searches please use the search form to create a new search.

'; + } + + mysql_close(); + ?> + + + +