# HG changeset patch
# User Alex McMahon <alex.mcmahon@cs.tcd.ie>
# Date 1242922278 -3600
# Node ID e506cab7f83a103e3ba48a2af669a2fb708e18e3
# Parent  6df283b800af78c3384f4b8f98e8a1ae57ba08a0
altered query string to produce correct trans_ID

diff -r 6df283b800af -r e506cab7f83a add_search.php
--- a/add_search.php	Thu May 21 12:58:40 2009 +0100
+++ b/add_search.php	Thu May 21 17:11:18 2009 +0100
@@ -63,11 +63,11 @@
 		mysql_select_db('members');
 
 		$seed = crc32($search_term);
-                $req_ID = genID($seed + time(), 30);
+                $req_ID = genID($seed + time(), 32);
 
 		$query = mysql_query("INSERT INTO requests_tbl (req_ID, uid, req_val, req_response, req_created) VALUES ('$req_ID', '$currID', '$search_term', 0, CURDATE())");
 #		$query2 =  mysql_query("SELECT MAX(req_ID) as id FROM requests_tbl");
-		$query2 =  mysql_query("SELECT req_ID as id FROM requests_tbl");
+		$query2 =  mysql_query("SELECT req_ID as id FROM requests_tbl WHERE req_ID ='$req_ID'");
 		mysql_close();
 		
 		while ($db_field2 = mysql_fetch_assoc($query2)) 
@@ -77,7 +77,8 @@
 		
 		// construct message string
 #		$message = "#" . $currID . "#" . $reqID . "#" . $search_term;
-		$message = "#" . $reqID . "#" . $search_term;
+#		$message = "#" . $reqID . "#" . $search_term;
+		$message =  $reqID . $search_term;
 
 		
 		$host="localhost";