query($query); // $numresult=$result->num_rows; //ELSE $result=mysql_query($query); $numresult=mysql_num_rows($result); //ENDIF $valid=true; $slot='(Unknown)'; $active='(Unknown)'; if ($numresult!=1) { //Match $valid=false; $reason= ($numresult==0)?'Stamp not found.':'Duplicate timestamps.'; } if ($valid) { //Active //IF MYSQLI // $row=$result->fetch_assoc(); //ELSE $row=mysql_fetch_assoc($result); //ENDIF $nKey=$row['nKey']; $slot=$row['Slot']; $active=$row['Active']; if (!$active) { $valid=false; $reason='Certificate is not active'; } } if ($valid) { //Update //IF MYSQLI // $dbu=new mysqli('localhost', 'inters_phpUpdate', 'flask3301', 'inters_Flask'); // if (mysqli_connect_errno()) die ('Cannot update package database. Please try again later.'); //ELSE $linku=mysql_connect('localhost', 'inters_phpUpdate', 'flask3301') or die('Could not connect: ' . mysql_error()); mysql_select_db('inters_Flask') or die('Could not select database'); //ENDIF $update="update Package set LastLocation='".$location."', LastTime=CURRENT_TIMESTAMP where nKey='".$nKey."' "; //IF MYSQLI // $dbu->query($update); //ELSE if (!$bpv) { //update location so creator can see $resultu=mysql_query($update); if (!$resultu) die ("Could not UPDATE ($update): " . mysql_error()); } //ENDIF } $active=$active==1; //Key based on timestamp and location $pbpE=0; if ($valid) { $pbp=$location.$timestamp.$guid; for($i=0; $i

>SQL Offline - Package Delivery

Package Certificate

Stamp:
Sender ID:
Package Slot:
Active:	DISABLED>

Valid':'Not Valid'; ?>

, from: .