req_ID now a random varchar(32) 30 char random string based on query and 2 # delimeter
--- a/add_search.php Thu May 21 12:20:19 2009 +0100
+++ b/add_search.php Thu May 21 12:58:40 2009 +0100
@@ -1,4 +1,28 @@
<?php
+ function genID($seed, $length)
+ {
+ $ID = "";
+ srand($seed);
+ for($i = 0; $i < $length; $i++)
+ {
+ $chtype = rand(1, 3);
+ switch($chtype)
+ {
+ case 1: // 0-9
+ $ID .= chr(rand(48, 57));
+ break;
+ case 2: // A-Z
+ $ID .= chr(rand(65, 90));
+ break;
+ case 3: // a-z
+ $ID .= chr(rand(97, 122));
+ break;
+ }
+ }
+ return $ID;
+
+ }
+
// URL validate function
function validUrl($str)
{
@@ -38,8 +62,12 @@
$conn = mysql_connect('localhost','www-data','www-data') or die(mysql_error());
mysql_select_db('members');
- $query = mysql_query("INSERT INTO requests_tbl (req_ID, uid, req_val, req_response, req_created) VALUES ('', '$currID', '$search_term', 0, CURDATE())");
- $query2 = mysql_query("SELECT MAX(req_ID) as id FROM requests_tbl");
+ $seed = crc32($search_term);
+ $req_ID = genID($seed + time(), 30);
+
+ $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");
mysql_close();
while ($db_field2 = mysql_fetch_assoc($query2))
@@ -48,7 +76,9 @@
}
// construct message string
- $message = "#" . $currID . "#" . $reqID . "#" . $search_term;
+# $message = "#" . $currID . "#" . $reqID . "#" . $search_term;
+ $message = "#" . $reqID . "#" . $search_term;
+
$host="localhost";
$port = 9090;
@@ -71,7 +101,7 @@
}
fclose($sk);
-
+ header ('Location: http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . 'details.php');
//header ('Location: http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/details.php?alert=add');
}
?>