61 { |
61 { |
62 $conn = mysql_connect('localhost','www-data','www-data') or die(mysql_error()); |
62 $conn = mysql_connect('localhost','www-data','www-data') or die(mysql_error()); |
63 mysql_select_db('members'); |
63 mysql_select_db('members'); |
64 |
64 |
65 $seed = crc32($search_term); |
65 $seed = crc32($search_term); |
66 $req_ID = genID($seed + time(), 30); |
66 $req_ID = genID($seed + time(), 32); |
67 |
67 |
68 $query = mysql_query("INSERT INTO requests_tbl (req_ID, uid, req_val, req_response, req_created) VALUES ('$req_ID', '$currID', '$search_term', 0, CURDATE())"); |
68 $query = mysql_query("INSERT INTO requests_tbl (req_ID, uid, req_val, req_response, req_created) VALUES ('$req_ID', '$currID', '$search_term', 0, CURDATE())"); |
69 # $query2 = mysql_query("SELECT MAX(req_ID) as id FROM requests_tbl"); |
69 # $query2 = mysql_query("SELECT MAX(req_ID) as id FROM requests_tbl"); |
70 $query2 = mysql_query("SELECT req_ID as id FROM requests_tbl"); |
70 $query2 = mysql_query("SELECT req_ID as id FROM requests_tbl WHERE req_ID ='$req_ID'"); |
71 mysql_close(); |
71 mysql_close(); |
72 |
72 |
73 while ($db_field2 = mysql_fetch_assoc($query2)) |
73 while ($db_field2 = mysql_fetch_assoc($query2)) |
74 { |
74 { |
75 $reqID = $db_field2['id']; |
75 $reqID = $db_field2['id']; |
76 } |
76 } |
77 |
77 |
78 // construct message string |
78 // construct message string |
79 # $message = "#" . $currID . "#" . $reqID . "#" . $search_term; |
79 # $message = "#" . $currID . "#" . $reqID . "#" . $search_term; |
80 $message = "#" . $reqID . "#" . $search_term; |
80 # $message = "#" . $reqID . "#" . $search_term; |
|
81 $message = $reqID . $search_term; |
81 |
82 |
82 |
83 |
83 $host="localhost"; |
84 $host="localhost"; |
84 $port = 9090; |
85 $port = 9090; |
85 $timeout = 30; |
86 $timeout = 30; |