diff -r b7f8324faded -r 0bd6e7537154 details.php_lessold --- a/details.php_lessold Wed Jun 16 13:28:45 2010 +0100 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,278 +0,0 @@ -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(); - ?> - - - -