details.php
changeset 25 5c3c1b82fea2
parent 24 0cc2bfb3d6e1
child 26 e8da4f096fde
equal deleted inserted replaced
24:0cc2bfb3d6e1 25:5c3c1b82fea2
    33                 if (!isset($_COOKIE['uid']))
    33                 if (!isset($_COOKIE['uid']))
    34                         {
    34                         {
    35                         $uid = '1';
    35                         $uid = '1';
    36 			$currID = '1';
    36 			$currID = '1';
    37 	                $mysql = new mysqli("localhost", "www-data", "www-data", "members");
    37 	                $mysql = new mysqli("localhost", "www-data", "www-data", "members");
    38  #              $result = $mysql->query("SELECT sid, sid_dir FROM sessions WHERE ((uid = '$currID' or uid = 1) AND (expiration_date = DATE_ADD(NOW(), INTERVAL 24 HOUR)))");
    38 			$result = $mysql->query("SELECT sid_dir, enum FROM sessions WHERE ((uid = '$currID' or uid = 1) AND (sid = '$sid1' or sid = '06D5VlLQTbM57LL7IBMW38yHkFpb1XVa')) ORDER BY enum desc LIMIT 0,1");
    39 			$result = $mysql->query("SELECT sid_dir, enum FROM sessions WHERE ((uid = '$currID' or uid = 1) AND (sid = '$sid1') AND (expiration_date = DATE_ADD(NOW(), INTERVAL 1440 MINUTE)))");
       
    40                 	$row = $result->fetch_assoc();
    39                 	$row = $result->fetch_assoc();
    41                 	$tsid2 = $row["sid_dir"];
    40                 	$tsid2 = $row["sid_dir"];
    42 			$enum = $row["enum"];
    41 			$enum = $row["enum"];
    43                 	$result->close();
    42                 	$result->close();
    44 
       
    45                         }
    43                         }
    46 
       
    47         $currSID2 = $_COOKIE['sid2'];
    44         $currSID2 = $_COOKIE['sid2'];
    48 	$sid2 = $currSID2;
    45 	$sid2 = $currSID2;
    49                 if (!isset($_COOKIE['sid2']))
    46                 if (!isset($_COOKIE['sid2']))
    50                         {
    47                         {
    51 			$sid2 = $tsid2;
    48 #			$sid2 = $tsid2;
    52 //                        $sid2 = '06D5VlLQTbM57LL7IBMW38yHkFpb1XVa';
    49                         $sid2 = '06D5VlLQTbM57LL7IBMW38yHkFpb1XVa';
    53 			$currSID2 = $sid2;
    50 			$currSID2 = $sid2;
    54                         }
    51                         }
    55 #        $view_mode = "public"
    52 #        $view_mode = "public"
    56 #        $view_order = "pend"
    53 #        $view_order = "pend"
    57 	$status = $_GET['alert'];
    54 	$status = $_GET['alert'];
   256 					print "<span class='result_output_none'>Result pending</span>";
   253 					print "<span class='result_output_none'>Result pending</span>";
   257 					print "<a href='delete.php?req_id=" . $db_field['req_ID'] . "'><img src='images/x.gif' width='14' height='20' /></a>";
   254 					print "<a href='delete.php?req_id=" . $db_field['req_ID'] . "'><img src='images/x.gif' width='14' height='20' /></a>";
   258 				} else {
   255 				} else {
   259 //header ('Location: http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . dirname($db_fieldcache["req_ID"]));
   256 //header ('Location: http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . dirname($db_fieldcache["req_ID"]));
   260 //strip_tags($text, '<p><a>')
   257 //strip_tags($text, '<p><a>')
   261 if ($db_field['uid'] != 1)
   258 /*if ($db_field['uid'] != 1)
   262 {
   259 {
   263                 print "<span class='result_output'><a href='". 'router_stage/' . $db_field['req_ID'] . '/' . remove_http($db_field['req_val'] . '?' . 'uid=' . $uid . '&'  . 'sid1=' . $sid1 . '&' . 'sid2=' . $sid2) ."' target='_blank'>View website</a></span>";
   260                 print "<span class='result_output'><a href='". 'router_stage/' . $db_field['req_ID'] . '/' . remove_http($db_field['req_val'] . '?' . 'uid=' . $uid . '&'  . 'sid1=' . $sid1 . '&' . 'sid2=' . $sid2) ."' target='_blank'>View website</a></span>";
   264 }
   261 }
   265 else
   262 else
   266 {
   263 {
   267 
   264 */
   268 print "<span class='result_output'><a href='". 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/router_stage/' . $db_field['req_ID'] . '/' . remove_http($db_field['req_val'] . '?' . 'uid=' . $uid . '&'  . 'sid1=' . $sid1 . '&' . 'sid2=' . $sid2) ."' target='_blank'>View website</a></span>";
   265 print "<span class='result_output'><a href='". 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/router_stage/' . $db_field['req_ID'] . '/' . remove_http($db_field['req_val'] . '?' . 'uid=' . $uid . '&'  . 'sid1=' . $sid1 . '&' . 'sid2=' . $sid2) ."' target='_blank'>View website</a></span>";
   269 
   266 
   270 #print "<span class='result_output'><a href='". 'http://village.n4c.eu/portal'. '/router_stage/' . $db_field['req_ID'] . '/' . remove_http($db_field['req_val'] . '?' . 'uid=' . $uid . '&'  . 'sid1=' . $sid1 . '&' . 'sid2=' . $sid2) ."' target='_blank'>View website</a></span>";
   267 #print "<span class='result_output'><a href='". 'http://village.n4c.eu/portal'. '/router_stage/' . $db_field['req_ID'] . '/' . remove_http($db_field['req_val'] . '?' . 'uid=' . $uid . '&'  . 'sid1=' . $sid1 . '&' . 'sid2=' . $sid2) ."' target='_blank'>View website</a></span>";
   271 #print "<span class='result_output'><a href='". 'http://village.n4c.eu/portal:8080'. '/' . remove_http($db_field['req_val'] . '?' . 'uid=' . $uid . '&'  . 'sid1=' . $sid1 . '&' . 'sid2=' . $sid2) ."' target='_blank'>View website</a></span>";
   268 #print "<span class='result_output'><a href='". 'http://village.n4c.eu/portal:8080'. '/' . remove_http($db_field['req_val'] . '?' . 'uid=' . $uid . '&'  . 'sid1=' . $sid1 . '&' . 'sid2=' . $sid2) ."' target='_blank'>View website</a></span>";
   272 
   269 
   273 #print "<span class='result_output'><a href='". $response ."' target='_blank'>View website</a></span>";
   270 #print "<span class='result_output'><a href='". $response ."' target='_blank'>View website</a></span>";
   274 
   271 
   275 }
   272 //}
   276 
   273 
   277                         //                print "<span class='result_output'><a href='". 'router_stage/' . $db_field['req_ID'] . '/' . remove_http($db_field['req_val'] . '?' . 'uid=' . $uid . '&'  . 'sid1=' . $sid1 . '&' . 'sid2=' . $sid2) ."' target='_blank'>View website</a></span>";
   274                         //                print "<span class='result_output'><a href='". 'router_stage/' . $db_field['req_ID'] . '/' . remove_http($db_field['req_val'] . '?' . 'uid=' . $uid . '&'  . 'sid1=' . $sid1 . '&' . 'sid2=' . $sid2) ."' target='_blank'>View website</a></span>";
   278 
   275 
   279 /////////////////////////////////////////////////////////////
   276 /////////////////////////////////////////////////////////////
   280 ////Uncomment this next section for Cookie in header if uid != 1  
   277 ////Uncomment this next section for Cookie in header if uid != 1