//Connect to MYSQL & select Database.
$connection = mysql_connect("mysql6.servage.net","sore4x4", "07850785") or die ("unable to connect to mysql");
$selected = mysql_select_db("sore4x4", $connection) or die ("unable to open database sore4x4");
$skip = explode('/',$_SERVER['REQUEST_URI']);
if (preg_match("#skip#is",$skip[3])){
$allow_skip=1;
}
else $allow_skip=0;
if(!isset($_POST['state1'])){
echo'
';
}
elseif (!isset($_POST['city'])){
echo '';
}
if(!($allow_skip)&&(isset($_POST['search']))){
echo 'You searched for "'.$_POST['search'].'" Please note: To retain the local feel of Craigslist, and ensure that server loads are not surpassed, this program is currently limited to 10 cities. If you have questions or concerns about this, please email me.
';
$query = preg_replace("# #","+",$_POST['search']);
$cityfeeback="";
$n_all="";
$loopnumber=$_POST['iter'];
$citynumber=$_POST['citytotal'];
$city_count=0;
$cnt=0;
while(($cnt<$citynumber)&&($city_count<$loopnumber)){
if (($_POST["city$cnt"]!="none")&&($_POST["city$cnt"]!="")){
$n = $_POST["city$cnt"];
echo ' ';
echo 'Your Search results for ';
$cityfeeback=$cityfeeback.'_'.echocity($n);
echo ' ';
$n_all=$n.'_'.$n_all;
$url = "http://www.craigslist.org/cgi-bin/search?".
"areaID=".$n.
"&subAreaID=0".
"&query=".$query.
"&catAbbreviation=".$_POST['filter'].
"&minAsk=".$_POST['min'].
"&maxAsk=".$_POST['max'];
$file = file_get_contents($url);
EchoLinksTable($file,1,8);
$city_count++;
}
$cnt++;
}
$date=date('d-m-Y');
$ip = $_SERVER['REMOTE_ADDR'];
Feedback($cityfeeback,$date,$query,$ip);
$skipurl='http://sore4x4.com/home/craigsearch/skip/&iter='.$_POST['iter'].'&city='.$n_all.'&query='.$query.'&cat='.$_POST['filter'].'&min='.$_POST['min'].'&max='.$_POST['max'];
echo '
';
echo 'Bookmark this search! ';
}
if($allow_skip){
$cityfeedback="";
preg_match("#&iter=(.*)Uis",$skip[4],$matches);
$loopnumber=$matches[1];
preg_match("#&city=(.*)Uis",$skip[4],$matches);
$city=$matches[1];
$city=explode('_',$city);
$citynumber=sizeof($city);
preg_match("#&query=(.*)Uis",$skip[4],$matches);
$query=$matches[1];
echo 'You searched for "'.$query.'" ';
preg_match("#&cat=(.*)Uis",$skip[4],$matches);
$cat=$matches[1];
preg_match("#&min=(.*)Uis",$skip[4],$matches);
$min=$matches[1];
preg_match("#&max=(.*)Uis",$skip[4],$matches);
$max=$matches[1];
$n=1;
$city_count=0;
$cnt=0;
while(($cnt<$citynumber)&&($city_count<$loopnumber)){
if (($city[$cnt]!="none")&&($city[$cnt]!="")){
$n = $city[$cnt];
echo ' ';
echo 'Your Search results for ';
$cityfeeback=$cityfeeback.'_'.echocity($n);
echo ' ';
$n_all=$n.'_'.$n_all;
$url = "http://www.craigslist.org/cgi-bin/search?".
"areaID=".$n.
"&subAreaID=0".
"&query=".$query.
"&catAbbreviation=".$cat.
"&minAsk=".$min.
"&maxAsk=".$max;
$file = file_get_contents($url);
EchoLinksTable($file,1,8);
$city_count++;
}
$cnt++;
}
$date=date('d-m-Y');
$ip = $_SERVER['REMOTE_ADDR'];
Feedback($cityfeeback,$date,$query,$ip);
}
function echofilter(){
echo '
all for sale / wanted
all community
all event
--
auto parts
baby & kid stuff
barter
bicycles
boats
books
cars & trucks
cds / dvds / vhs
clothing
collectibles
computers & tech
electronics
free stuff
furniture
garage sales
general
household
items wanted
jewelry
motorcycles/scooters
musical instruments
recreational vehicles
sporting goods
tickets
tools
--
all gigs
all housing
all jobs
all personals
all resume
all services offered
';
}
function echocity ($code){
$query = mysql_query ('select city, state_name from CraigSearch where `code`='.$code);
if (!$query){echo 'Yeah, I suck at mysql......'.mysql_error();}
$result = mysql_fetch_array($query, MYSQL_NUM);
echo $result[0].', '.$result[1];
return $result[0];
}
function echocities ($cities,$iter){
$cnt=0;
echo ' ';
}
function getcities ($where,$cities){
$iter=sizeof($cities);
$query = mysql_query ('select city,code from CraigSearch '.$where.'');
if (!$query){echo 'you screweded up'.mysql_error();}
while (($result = mysql_fetch_array($query, MYSQL_NUM)) !== false){
$cities[$iter]=$result[0].'|||'.$result[1];
$iter++;
}
return $cities;
}
function echostates (){
$query = mysql_query ('select state,state_name from CraigSearch');
if (!$query){echo 'you screweded up'.mysql_error();}
while (($result = mysql_fetch_array($query, MYSQL_NUM)) !== false){
if ($result[1]!=$prev_result){
echo ''.$result[1].' ';
}
$prev_result=$result[1];
}
}
function EchoLinksTable ($file,$cols,$date){
preg_match_all("# (.*)a>#Uis",$file,$links);
$cnt = 0;
echo '
';
foreach ($links[0] as $link){
if (!preg_match("#TABLE width#",$link)){
if ($cnt == 0){ echo '';}
$cnt++;
echo ''.$link.' ';
if ($cnt == $cols){
echo ' ';
$cnt = 0;
}
}
}
echo '
';
}
function Feedback ($city, $date, $query,$ip){
$result = mysql_query("INSERT INTO `CraigSearchFeedback` ( `id` , `query` , `date` , `cities`,`ip`) VALUES ('','$query', '$date' , '$city','$ip')");
if (!$result){echo mysql_error()."you screwed up!"; exit;}
}
?>