header('Location: //my.leadswork.co.uk/join'); $ip = $_SERVER["REMOTE_ADDR"]; $browser = $_SERVER["HTTP_USER_AGENT"]; $s_eng=$_REQUEST["s_eng"]; $dbh = mysql_connect("localhost","bettercrew","localsponge"); mysql_select_db("bettercrew2", $dbh); if (!$_SESSION) { session_start(); $_SESSION[sessid]=session_id(); }; if ($s_eng == "Surrey"){ $titextra = "Catalogue Distribution jobs in Surrey"; $footextra = "Crawley,Dorking,Horsham,Cranleigh,Haslemere,Hindhead,Northchapel"; $jobextra = "in Surrey"; }; #save da key $chars = "abcdefghijklmnopqrstuvwxyz0123456789"; $pckey = ""; for ($i = 0; $i <16; ++$i) { $pckey .= substr($chars, rand(0, strlen($chars) - 1), 1); }; $keyinsertion = "\n"; $dbt = mysql_connect("binet.adyx.co.uk","scripts","sec11ret"); mysql_select_db("paf_cp", $dbt); mysql_query("REPLACE INTO lookups(code,date) VALUES(\"$pckey\",NOW())", $dbt); mysql_close($dbt); if (!$_SESSION[PEUID]){ #generate uid $uid = rand(1000, 32768).rand(1000, 32768); while (strlen($uid) < 11) { $uid = rand(0,9) . $uid; } $uid_ok = false; while (!$uid_ok) { $query = "SELECT COUNT(*) FROM `logins2` WHERE `uid` = \"$uid\""; $sth = mysql_query($query, $dbh); list($ct) = mysql_fetch_array($sth, MYSQL_NUM); if($ct) { // change one digit at random $uid = substr_replace($uid, rand(0,9), rand(0, (strlen($uid) - 1)), 1); } else { // now $uid looks good and unique $uid_ok = mysql_query($query, $dbh); $_SESSION[PEUID] = $uid; } } }else{ $uid = $_SESSION[PEUID]; } ?>