'; for($count = 1; $count <= $Rating; $count++) $RatingSpan .= '*'; $RatingSpan .= ''; for($finalcount = $count; $finalcount < 6; $finalcount++) $RatingSpan .= '*'; return $RatingSpan; } /********************************** ////////get business rating - OLD - NOT USE//////// **********************************/ function getRating($biz_id){ $query = "select total_votes, total_value from ratings where id='".$biz_id."' limit 1"; $result = mysql_query($query); $row=mysql_fetch_assoc($result); if (!$row['total_votes'] || ($row['total_votes']==0)){ $rating =0; } else { $rating = round($row['total_value']/$row['total_votes']); } if ($rating){ return $rating; } else { return 0; } } /********************************** ////////get business Review//////// **********************************/ function getBusinessRating($biz_id, $dbd){ $query = "SELECT count(*) as total_rating, round(avg(`rating`)) as rating FROM `local_review` WHERE biz_id = ".$biz_id." limit 1"; $result = mysql_query($query, $dbd); $row=mysql_fetch_assoc($result); $BusinessRating['total_rating'] = $row['total_rating']; $BusinessRating['rating'] = $row['rating']; return $BusinessRating; } /************************************ ////search businesses using lat long// ************************************/ function search_keyword($search,$dbd,$latmin,$latmax,$lonmin,$lonmax,$resultcount = 10){ $searchresult = array(); $search_query = $search; $terms = explode(' ', trim($search_query)); $like = ''; foreach($terms as $term) { $like .= 'bname like \'%'.$term.'%\' or '; } $like = rtrim($like, ' or '); $searchq = str_replace (' ','%',$search); $searchq = str_replace ("'","''",$searchq); //$query = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax and bname like '%$searchq%' limit 10"; //$query = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax and match(bname) against('$searchq' in boolean mode) limit 10"; $query = "select SQL_NO_CACHE * from local_pages_lat_lon_updated WHERE MBRCONTAINS(LINESTRING(point($latmin,$lonmin), point($latmax,$lonmax)), pnt) and duplicate=0 and ($like) limit $resultcount;"; $result = mysql_query($query, $dbd); while ($row = mysql_fetch_assoc($result)) { $searchresult[] = $row; } if (count($searchresult) > 10){ return $searchresult; } else { $terms = explode(' ', trim($search_query)); $like = ''; foreach($terms as $term) { $like .= 'keywords like \'%'.$term.'%\' or '; } $like = rtrim($like, ' or '); //$query = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax and keywords like '%$searchq%' limit 10"; //$query = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax and match(keywords) against('$searchq' in boolean mode) limit 10"; $query = "select SQL_NO_CACHE * from local_pages_lat_lon_updated WHERE MBRCONTAINS(LINESTRING(point($latmin,$lonmin), point($latmax,$lonmax)), pnt) and duplicate=0 and ($like) limit $resultcount;"; $result = mysql_query($query, $dbd); while ($row = mysql_fetch_assoc($result)) { $searchresult[] = $row; } } return $searchresult; # $splitkeyword = array(); # $splitkeyword = explode(" ", $search); # # if (count($searchresult) > 100){ # return $searchresult; # } else { # $query1 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax "; # for ($j=0; $j < count($splitkeyword);$j++){ # $query1 .= " and bname like '%"; # $query1 .= $splitkeyword[$j]; # $query1 .= "%'"; # } # $query1 .= " limit 50"; # $result = mysql_query($query1, $dbd); # while ($row = mysql_fetch_assoc($result)) { # $searchresult[] = $row; # } # } # # if (count($searchresult) > 100){ # return $searchresult; # } else { $query1 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax "; # for ($j=0; $j < count($splitkeyword);$j++){ # $query1 .= " and keywords like '%"; # $query1 .= $splitkeyword[$j]; # $query1 .= "%'"; # } # $query1 .= " limit 50"; # $result = mysql_query($query1, $dbd); # while ($row = mysql_fetch_assoc($result)) { # $searchresult[] = $row; # } # } # # if (count($searchresult) > 100){ # return $searchresult; # } elseif ($splitkeyword[0]) { $query2 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax and bname like '$splitkeyword[0]%'"; # $query2 .= " limit 50"; # $result = mysql_query($query2, $dbd); # while ($row = mysql_fetch_assoc($result)) { # $searchresult[] = $row; } # } # # if (count($searchresult) > 100){ # return $searchresult; # } elseif ($splitkeyword[1]) { $query2 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax and bname like '$splitkeyword[1]%'"; # $query2 .= " limit 50"; # # $result = mysql_query($query2, $dbd); # while ($row = mysql_fetch_assoc($result)) { # $searchresult[] = $row; # } // if (count($searchresult) > $resultcount){ // return $searchresult; // } elseif ($splitkeyword[1]){// $query3 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and abs(lon) between abs($lonmax) and abs($lonmin) and keywords like '%$splitkeyword[1]%'"; // $query2 .= " limit $resultcount"; // $result = mysql_query($query3); // while ($row = mysql_fetch_assoc($result)) { // $searchresult[] = $row; // } // // } return $searchresult; } function search_cskeyword($search,$dbd,$latmin,$latmax,$lonmin,$lonmax,$resultcount = 10){ $searchresult = array(); $searchq = str_replace (' ','%',$search); $searchq = str_replace ("'","''",$searchq); $query = "select lat,lon,biz_id from citysearch_lat_lon where lat between $latmin and $latmax and lon between $lonmin and $lonmax and bname like '%$searchq%' limit 10"; $result = mysql_query($query, $dbd); while ($row = mysql_fetch_assoc($result)) { $searchresult[] = $row; } if (count($searchresult) > 1){ return $searchresult; } else { $query = "select lat,lon,biz_id from citysearch_lat_lon where lat between $latmin and $latmax and lon between $lonmin and $lonmax and keywords like '%$searchq%' limit 10"; $result = mysql_query($query, $dbd); while ($row = mysql_fetch_assoc($result)) { $searchresult[] = $row; } } return $searchresult; } function select_csbiz($results, $bizresult, $dbd){ global $searchresult; for ($i=count($bizresult), $a = 0;$a< count($results);$a++, $i++){ $id = $results[$a]['biz_id']; $query = "select * from citysearch_biz_new,citysearch_budget where citysearch_biz_new.id=citysearch_budget.id and citysearch_budget.id=$id"; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $phone = ""; $bizresult[$i]['business_name'] = $row['name']; $bizresult[$i]['title'] = $row['name']; $bizresult[$i]['address1'] = $row['street']; $bizresult[$i]['biz_id'] = 'CS'.$row['id']; if ($row['phone']){ $phone = "(".substr($row['phone'],0,3).") ".substr($row['phone'],3,3).'-'.substr($row['phone'],6,4); } $tmp_desc = ""; if ($row['street']){ $tmp_desc .= trim($row['street']); } if ($row['city']){ if ($tmp_desc){ $tmp_desc .= ", ".$row['city']; } else { $tmp_desc = $row['city']; } } if ($row['state'] && $row['zip']){ $tmp_desc .= " ".$row['state']."-".$row['zip']; } if ($phone){ $tmp_desc .= " [".$phone."]"; } $bizresult[$i]['desc'] = $row['title']?$row['title']:$tmp_desc; $bizresult[$i]['city'] = $row['city']; $bizresult[$i]['state'] = $row['state']; $bizresult[$i]['zip'] = $row['zip']; $bizresult[$i]['phone_number'] = $row['phone']; $bizresult[$i]['bid'] = $row['bid']; $bizresult[$i]['phone'] = $phone; $bizresult[$i]['profile_url'] = $row['profile_url'].'?publisher=local_pages_rbl&eference_id=1&placement=full'; $bizresult[$i]['reviews_url'] = $row['reviews_url'].'?publisher=local_pages_rbl&eference_id=1&placement=full'; $bizresult[$i]['website_url'] = $row['website_url'].'?publisher=local_pages_rbl&eference_id=1&placement=full'; } } //print_r($bizresult);die(); if ($bizresult) return $bizresult; } /************************************ ////search businesses using lat long// ************************************/ function search_keyword2($search,$dbd,$latmin,$latmax,$lonmin,$lonmax,$resultcount = 10){ $searchresult = array(); $search_query = $search; $terms = explode(' ', trim($search_query)); $like = ''; foreach($terms as $term) { $like .= 'bname like \'%'.$term.'%\' or '; } $like = rtrim($like, ' or '); $searchq = str_replace (' ','%',$search); $searchq = str_replace ("'","''",$searchq); //$query = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax and bname like '%$searchq%' limit 150"; //$query = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax and match(bname) against('$searchq' in boolean mode) limit 150"; $query = "select SQL_NO_CACHE * from local_pages_lat_lon_updated WHERE MBRCONTAINS(LINESTRING(point($latmin,$lonmin), point($latmax,$lonmax)), pnt) and duplicate=0 and ($like) limit 150"; $result = mysql_query($query, $dbd); while ($row = mysql_fetch_assoc($result)) { $searchresult[] = $row; } if (count($searchresult) > 10){ return $searchresult; } else { $terms = explode(' ', trim($search_query)); $like = ''; foreach($terms as $term) { $like .= 'keywords like \'%'.$term.'%\' or '; } $like = rtrim($like, ' or '); //$query = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax and keywords like '%$searchq%' limit 50"; //$query = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax and match(keywords) against('$searchq' in boolean mode) limit 50"; $query = "select SQL_NO_CACHE * from local_pages_lat_lon_updated WHERE MBRCONTAINS(LINESTRING(point($latmin,$lonmin), point($latmax,$lonmax)), pnt) and duplicate=0 and ($like) limit 50;"; $result = mysql_query($query, $dbd); while ($row = mysql_fetch_assoc($result)) { $searchresult[] = $row; } } # $splitkeyword = array(); # $splitkeyword = explode(" ", $search); # # if (count($searchresult) > 100){ # return $searchresult; # } else { # $query1 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax "; # for ($j=0; $j < count($splitkeyword);$j++){ # $query1 .= " and bname like '%"; # $query1 .= $splitkeyword[$j]; # $query1 .= "%'"; # } # $query1 .= " limit 50"; # $result = mysql_query($query1, $dbd); # while ($row = mysql_fetch_assoc($result)) { # $searchresult[] = $row; # } # } # # if (count($searchresult) > 100){ # return $searchresult; # } else { $query1 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax "; # for ($j=0; $j < count($splitkeyword);$j++){ # $query1 .= " and keywords like '%"; # $query1 .= $splitkeyword[$j]; # $query1 .= "%'"; # } # $query1 .= " limit 50"; # $result = mysql_query($query1, $dbd); # while ($row = mysql_fetch_assoc($result)) { # $searchresult[] = $row; # } # } # # if (count($searchresult) > 100){ # return $searchresult; # } elseif ($splitkeyword[0]) { $query2 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax and bname like '$splitkeyword[0]%'"; # $query2 .= " limit 50"; # $result = mysql_query($query2, $dbd); # while ($row = mysql_fetch_assoc($result)) { # $searchresult[] = $row; } # } # # if (count($searchresult) > 100){ # return $searchresult; # } elseif ($splitkeyword[1]) { $query2 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and lon between $lonmin and $lonmax and bname like '$splitkeyword[1]%'"; # $query2 .= " limit 50"; # # $result = mysql_query($query2, $dbd); # while ($row = mysql_fetch_assoc($result)) { # $searchresult[] = $row; # } // if (count($searchresult) > $resultcount){ // return $searchresult; // } elseif ($splitkeyword[1]){// $query3 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and abs(lon) between abs($lonmax) and abs($lonmin) and keywords like '%$splitkeyword[1]%'"; // $query2 .= " limit $resultcount"; // $result = mysql_query($query3); // while ($row = mysql_fetch_assoc($result)) { // $searchresult[] = $row; // } // // } return $searchresult; } function search_keyword_RETIRED($search,$dbd,$latmin,$latmax,$lonmin,$lonmax,$resultcount = 10){ $searchresult = array(); $searchq = str_replace (' ','%',$search); $searchq = str_replace ("'","''",$search); $query = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and abs(lon) between abs($lonmax) and abs($lonmin) and bname like '%$searchq%' limit 200"; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $searchresult[] = $row; } // if (count($searchresult) > 0){ // return $searchresult; // } else { $query = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and abs(lon) between abs($lonmax) and abs($lonmin) and keywords like '%$searchq%' limit 50"; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $searchresult[] = $row; } // } $splitkeyword = array(); $splitkeyword = explode(" ", $search); if (count($searchresult) > 0){ return $searchresult; } else { $query1 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and abs(lon) between abs($lonmax) and abs($lonmin) "; for ($j=0; $j < count($splitkeyword);$j++){ $query1 .= " and bname like '%"; $query1 .= $splitkeyword[$j]; $query1 .= "%'"; } $query1 .= " limit 50"; $result = mysql_query($query1); while ($row = mysql_fetch_assoc($result)) { $searchresult[] = $row; } } if (count($searchresult) > 0){ return $searchresult; } else { $query1 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and abs(lon) between abs($lonmax) and abs($lonmin) "; for ($j=0; $j < count($splitkeyword);$j++){ $query1 .= " and keywords like '%"; $query1 .= $splitkeyword[$j]; $query1 .= "%'"; } $query1 .= " limit 50"; $result = mysql_query($query1); while ($row = mysql_fetch_assoc($result)) { $searchresult[] = $row; } } if (count($searchresult) > 0){ return $searchresult; } elseif ($splitkeyword[0]) { $query2 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and abs(lon) between abs($lonmax) and abs($lonmin) and bname like '$splitkeyword[0]%'"; $query2 .= " limit 50"; $result = mysql_query($query2); while ($row = mysql_fetch_assoc($result)) { $searchresult[] = $row; } } if (count($searchresult) > 0){ return $searchresult; } elseif ($splitkeyword[1]) { $query2 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and abs(lon) between abs($lonmax) and abs($lonmin) and bname like '$splitkeyword[1]%'"; $query2 .= " limit 50"; $result = mysql_query($query2); while ($row = mysql_fetch_assoc($result)) { $searchresult[] = $row; } } // if (count($searchresult) > $resultcount){ // return $searchresult; // } elseif ($splitkeyword[1]){ // $query3 = "select lat,lon,biz_id from local_pages_lat_lon_updated where lat between $latmin and $latmax and abs(lon) between abs($lonmax) and abs($lonmin) and keywords like '%$splitkeyword[1]%'"; // $query2 .= " limit $resultcount"; // $result = mysql_query($query3); // while ($row = mysql_fetch_assoc($result)) { // $searchresult[] = $row; // } // // } if ($searchresult) return $searchresult; } /********************************** ////////lookup business ids//////// **********************************/ function select_biz_new($results, $start, $count, $dbd){ $bizresult = array(); $searchresult = array(); if($start == 1) $start = 0; else $start = $start*$count; for ($i=$start, $inc = 0;$i< $count+$start && $results[$i] ;$i++, $inc++) { //$startLoop = microtime(true); // echo $results[$i]['biz_id']." - "; $query = "select id, business_name,full_address,city,state,zip,phone,phone_code from local_pages_biz_updated where id = ". $results[$i]['biz_id']." limit 1"; $result = mysql_query($query, $dbd); while ($row = mysql_fetch_assoc($result)) { $searchresult[$inc]['business_name'] = $row['business_name']; $searchresult[$inc]['address1'] = $row['full_address']; $searchresult[$inc]['biz_id'] = $row['id']; $searchresult[$inc]['city'] = $row['city']; $searchresult[$inc]['state'] = $row['state']; $searchresult[$inc]['zip'] = $row['zip']; $searchresult[$inc]['area_code'] = $row['phone_code']; $searchresult[$inc]['phone_number'] = $row['phone_number']; if ($row['phone']) { $searchresult[$inc]['phone'] = "(".substr($row['phone'],0,3).") ".substr($row['phone'],3,3).'-'.substr($row['phone'],6,4); } $searchresult[$inc]['web_url_address'] = $row['web_address']; $BusinessRating = getBusinessRating($row['id'], $dbd); $searchresult[$inc]['total_rating'] = $BusinessRating['total_rating']; $searchresult[$inc]['rating'] = $BusinessRating['rating']; } $QueryPremium = "select id from premium where id = ".$results[$i]['biz_id']." limit 1"; ; $ResultPremium = mysql_query($QueryPremium, $dbd); if(mysql_num_rows($ResultPremium)) $searchresult[$inc]['premium'] = 1; else $searchresult[$inc]['premium'] = 0; //echo microtime(true) - $startLoop.'
\r\n'; } if ($searchresult) return $searchresult; } function select_biz($results,$dbd){ global $searchresult; $bizresult = array(); for ($i=0;$i< count($results);$i++){ // echo $results[$i]['biz_id']." - "; $query = "select id, business_name,full_address,city,state,zip,phone,phone_code,web_address from local_pages_biz_updated where id = ". $results[$i]['biz_id']." limit 1"; ; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $searchresult[$i]['business_name'] = $row['business_name']; $searchresult[$i]['address1'] = $row['full_address']; $searchresult[$i]['biz_id'] = $row['id']; $searchresult[$i]['city'] = $row['city']; $searchresult[$i]['state'] = $row['state']; $searchresult[$i]['zip'] = $row['zip']; $searchresult[$i]['area_code'] = $row['phone_code']; $searchresult[$i]['phone_number'] = $row['phone_number']; if ($row['phone']){ $searchresult[$i]['phone'] = "(".substr($row['phone'],0,3).") ".substr($row['phone'],3,3).'-'.substr($row['phone'],6,4); } $searchresult[$i]['web_url_address'] = $row['web_address']; } $QueryPremium = "select id from premium where id = ". $searchresult[$i]['biz_id']." limit 1"; ; $ResultPremium = mysql_query($QueryPremium); if(mysql_num_rows($ResultPremium)) $searchresult[$i]['premium'] = 1; else $searchresult[$i]['premium'] = 0; } if ($bizresult) return $bizresult; } /********************************** ////////Sorting algorithm//////// **********************************/ function simplesort($results) { for($i=0;$i$results[$j]['distance'])) { $temp=$results[$j]; $results[$j]=$results[$i]; $results[$i]=$temp; } } } $k= 0; $temp = ""; for($i=0;$i3)?3:count($redirecturlarray); $txt = ""; $i=$start; $limit = $i + $count; for($i=$start;$i<$limit;$i++) { if ($redirecturlarray[$i] && $titlearray[$i]){ $current_time = time(); $tstamp = $current_time + 3600; $encrypted_target = encrypt_link( $ip . "::" . $search . "::" . $tstamp . "::" . $redirecturlarray[$i] . "::" . $ua ); $et = urlencode($encrypted_target); $hash = "&v=" . md5($et); $redirURL="http://".$ref."/click_y.php?mc=".$et.$hash; $txt .= '

'; $txt .= '
'."\n"; $tmp_img = urldecode($imgarray[$i]); $tmp_img = str_replace("<","<",$tmp_img); $tmp_img = str_replace(">",">",$tmp_img); $tmp_img = str_replace('"','" ',$tmp_img); $tmp_img = str_replace('&','&',$tmp_img); $tmp_img = str_replace('=" ','="',$tmp_img); $txt .= $tmp_img."\n"; $txt .= ''.$descarray[$i].''.'
'; $txt .= ''.$urlarray[$i].''; $txt .= '

'; } } return $txt; } /****************************** ** display Sponsored Output ** ******************************/ function displaySponsoredOutput($start = 0, $count = 3, $type=1) { global $titlearray,$urlarray,$redirecturlarray,$descarray,$ua,$ip,$search,$adcenter,$yahootag,$domaintype; if (strtolower($domaintype) == "bestyellowpages"){ $click_ref = "click.bestyellowpages.com"; } else { $click_ref = "click.pointcom.com"; } $results1cnt=(count($redirecturlarray)>3)?3:count($redirecturlarray); $txt = ""; $i=$start; $limit = $i + $count; for($i=$start;$i<$limit;$i++) { // if ($redirecturlarray[$i] && $descarray[$i] && $titlearray[$i] && $urlarray[$i]){ if ($redirecturlarray[$i] && $titlearray[$i]){ $current_time = time(); $tstamp = $current_time + 3600; $encrypted_target = encrypt_link( $ip . "::" . $search . "::" . $tstamp . "::" . $redirecturlarray[$i] . "::" . $ua ); $et = urlencode($encrypted_target); $hash = "&v=" . md5($et); $redirURL="http://$click_ref/click_y.php?mc=".$et.$hash; $txt .= '

'; $txt .= ''; $txt .= ''.$descarray[$i].''.'
'; $txt .= ''.$urlarray[$i].''; $txt .= '

'; } } return $txt; } /****************************** ** display Sponsored Output ** ******************************/ function displaySponsoredOutputDitto($start = 0, $count = 3, $type=1) { global $titlearray,$urlarray,$redirecturlarray,$descarray,$ua,$ip,$search,$adcenter,$yahootag,$domaintype,$imagetags; if (strtolower($domaintype) == "bestyellowpages"){ $click_ref = "click.bestyellowpages.com"; } else { $click_ref = "click.pointcom.com"; } $results1cnt=(count($redirecturlarray)>3)?3:count($redirecturlarray); $txt = ""; $i=$start; $limit = $i + $count; for($i=$start;$i<$limit;$i++) { // if ($redirecturlarray[$i] && $descarray[$i] && $titlearray[$i] && $urlarray[$i]){ if ($redirecturlarray[$i] && $titlearray[$i]){ $current_time = time(); $tstamp = $current_time + 3600; $encrypted_target = encrypt_link( $ip . "::" . $search . "::" . $tstamp . "::" . $redirecturlarray[$i] . "::" . $ua ); $et = urlencode($encrypted_target); $hash = "&v=" . md5($et); $redirURL="http://$click_ref/click_y.php?mc=".$et.$hash; $txt .= '

'; $txt .= '

'; } } return $txt; } /*********************************** //////////display output////////// **********************************/ function displayOutput($start = 0, $count = 3, $type) { global $titlearray,$urlarray,$redirecturlarray,$descarray, $searchresult,$locationarray; $results1cnt=(count($searchresult)>3)?3:count($searchresult); $txt = ""; $i=$start; $limit = $i + $count; if ((count($searchresult) ==0) && ($type==1)){ $txt = '
Make sure your spelling is correct

Try different keywords that mean the same thing. For example, try "food" instead of dining.

Try a different geographic location, or use a zip code or area code in place of a city and state

Try increasing the radius of your search

Two-word keywords generally return better results than one-word keywords. For example, try "italian restaurant" instead of "restaurant".

Your "what" keyword should be a product category, service or business name. For example:

Cars in New York, NY

Hotels in 90007

Insurance in 310

Do not use the following in your searches:

Proper names of people

Book, movie or music titles

Web site addresses

'; return $txt; } for($i=$start;$i<$limit;$i++){ $distance = $searchresult[$i]['distance']; if (!$distance){ $distance = getDistance ($locationarray['lat'],$locationarray['lon'],$searchresult[$i]['lat'],$searchresult[$i]['lon']); $distance = round($distance,1); } if ($searchresult[$i]['business_name']) { $txt .= '

'; $txt .= '

Distance: '.$distance.' miles
'; $txt .= '

'; $txt .= 'View on Map»
'; $txt .= '

'; $rating = getRating($searchresult[$i]['biz_id']); $txt .= '

Rating'; $txt .= '

'; $txt .= 'Rate» Read»

'; $txt .= ''; $txt .= ' '; if ($searchresult[$i]['moreInfoPage']){ $txt .= ''; if($searchresult[$i]['smallImage']) { $txt .= ''; } $txt .= '

'; $txt .= '

'; } else { $txt .= '

'; } if ($searchresult[$i]['phone']){ $txt .= ''. $searchresult[$i]['phone'].'
'; } else { $txt .='
'; } $txt .= $searchresult[$i]['address1'].'
'; $txt .= $searchresult[$i]['city'].', '.$searchresult[$i]['state'].'-'.$searchresult[$i]['zip'].'
'; $txt .= ''.$searchresult[$i]['web_url_address'].'

'; if ($searchresult[$i]['website']){ $txt .= '

'; } else { $txt .= '

'; } $txt .= '

'; if ($searchresult[$i]['moreInfoPage']){ $txt .= '

More Information »

'; } else { $txt .= '

More Information »

'; } $txt .= '

'; } } return $txt; } /*********************************** //////////display output////////// **********************************/ function displayLandingOutput($start = 0, $count = 3, $type, $keyword, $place) { global $searchresult; $txt = ""; $i=$start; $limit = $i + $count; for($i=$start;$i<$limit;$i++){ if ($searchresult[$i]['business_name']){ $txt .= '

'; $rating = getRating($searchresult[$i]['biz_id']); $txt .= '

Rating'; $txt .= '

'; $txt .= 'Rate» Read»

'; $txt .= '

'; $txt .= '
'; if ($searchresult[$i]['phone']){ $txt .= ''. $searchresult[$i]['phone'].'
'; } else { $txt .='
'; } $txt .= $searchresult[$i]['address1'].'
'; $txt .= $searchresult[$i]['city'].', '.$searchresult[$i]['state'].'-'.$searchresult[$i]['zip'].'
'; $txt .= ''.$searchresult[$i]['web_url_address'].''; $txt .= '

More Information »

'; $txt .= '

'; } } return $txt; } ///******************* // ** displaysponsoredWebLinks ** // *******************/ //function displaysponsoredWebLinks($start = 0, $count = 3, $type=1) { // // global $titlearray,$urlarray,$redirecturlarray,$descarray,$numfeed1; // // $results1cnt=(count($redirecturlarray)>3)?3:count($redirecturlarray); // $txt = ""; // $i=$start; // $limit = $i + $count; // for($i=$start;$i<$limit;$i++) // { // if ($redirecturlarray[$i]){ // $current_time = time(); // $tstamp = $current_time + 3600; // $encrypted_target = encrypt_link( // $GLOBALS["ip"] . "::" . // $GLOBALS["kw"] . "::" . // $tstamp . "::" . // $redirecturlarray[$i] . "::" . // $GLOBALS["useragent"] // ); // $et = urlencode($encrypted_target); // $hash = "&v=" . md5($et); // // $redirURL="http://yellowpages.insiderinfo.com/click_y.php?mc=".$et.$hash; // // if ($type == 1){ // $txt .= '

'; // $txt .= ''; // $txt .= '

'; // $txt .= '

'; // $txt .= ''.$titlearray[$i].''; // $txt .= '

'; // $txt .= $descarray[$i]; // $txt .= '

'; // $txt .= ''.$urlarray[$i].''; // $txt .= '

'; // $txt .= "

\n"; // } else { // $txt .= '

'; // $txt .= ''.$titlearray[$i].'
'; // $txt .= $descarray[$i].'
'; // $txt .= ''.$urlarray[$i].''; // $txt .= "

\n"; // } // } // } // return $txt; //} /********************************************************* ///////calculates distance between two points /////// *********************************************************/ function getDistance($lat1, $lng1, $lat2, $lng2, $miles = true) { $pi80 = M_PI / 180; $lat1 *= $pi80; $lng1 *= $pi80; $lat2 *= $pi80; $lng2 *= $pi80; $r = 6372.797; // mean radius of Earth in km $dlat = $lat2 - $lat1; $dlng = $lng2 - $lng1; $a = sin($dlat / 2) * sin($dlat / 2) + cos($lat1) * cos($lat2) * sin($dlng / 2) * sin($dlng / 2); $c = 2 * atan2(sqrt($a), sqrt(1 - $a)); $km = $r * $c; return ($miles ? ($km * 0.621371192) : $km); } /******************************** ** Curl request to read file ** ********************************/ function get_file_get_contents($url, $timeout=3) { $ch = curl_init($url); // initialize curl handle // $timeout = 3; // curl_setopt($ch, CURLOPT_HEADER, true); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // discard SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); // discard SSL verification curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // return into a variable curl_setopt($ch, CURLOPT_TIMEOUT, $timeout); // times out after 4s $data = curl_exec($ch); // run the whole process if (curl_errno($ch)) { return false; } else { curl_close($ch); return $data; } } /******************************** ****** Parser functions ******* ********************************/ function hchar($xp,$cdata) { global $tag_name,$insideitem,$url,$desc,$title,$redirecturl,$redirecturl,$displaytags,$desctags,$titletags,$redirecturltags,$cpctags,$cpc,$random,$insideresult,$result,$insideengine,$engine; if ($insideitem && $insideresult) { if($result['SEGMENT']=="localppc" || $engine['NAME']=="sponsored") { switch ($tag_name) { case $displaytags[$random]: $url .= $cdata; break; case $desctags[$random]: $desc .= $cdata; break; case $titletags[$random]: $title .= $cdata; break; case $redirecturltags[$random]: $redirecturl .= $cdata; break; case $cpctags[$random]: $cpc .= $cdata; break; } } } return true; } function hestart($xp,$name,$attr) { global $tag_name,$insideitem,$starttags,$random,$insideresult,$result,$insideengine,$engine; if ($insideitem) $tag_name = $name; elseif ($name == $starttags[$random]) $insideitem = true; if ($insideresult) $tag_name = $name; elseif ($name == "RESULTSET" ) { $insideresult = true; $result = array(); $result=$attr; } elseif ($name == "ENGINE") { $insideengine = true; $engine = array(); $engine=$attr; } return true; } function heend($xp,$name) { global $insideresult, $result, $tag_name,$url,$insideitem,$urlarray,$descarray,$desc,$titlearray,$title,$redirecturl,$redirecturlarray,$starttags,$cpc,$cpcarray,$random,$kudodomain,$insideengine,$engine; if($result['SEGMENT']=="localppc" || $engine['NAME']=="sponsored") { if ($name == $starttags[$random]) { $urlarray[]=trim($url); $descarray[]=trim($desc); $titlearray[]=str_replace("+"," ",trim($title)); $redirecturlarray[]=trim($redirecturl); $bid=str_replace("$","",$cpc); $bid=($bid)?$bid:"1.00"; $cpcarray[]=$bid; $url=""; $desc=""; $title=""; $redirecturl=""; $cpc=""; $insideitem = false; } } if ($name == "RESULTSET"){ $insideresult=false; } else if ($name == "ENGINE"){ $insideengine=false; } $tag_name = ''; return true; } function h_char($xp,$cdata) { global $tag_name,$insideitem,$url,$desc,$title,$redirecturl,$redirecturl,$urltag,$descriptiontag,$titletag,$redirecturltag,$cpctag,$cpc,$insideengine,$engine,$feedtag; if ($insideitem&&$insideengine) { if($engine['NAME']== $feedtag) { switch ($tag_name) { case $urltag: $url .= $cdata; break; case $descriptiontag: $desc .= $cdata; break; case $titletag: $title .= $cdata; break; case $redirecturltag: $redirecturl .= $cdata; break; } } } return true; } function h_estart($xp,$name,$attr) { global $listing, $tag_name,$insideitem,$listtag,$insideengine,$engine,$feedtag; if ($insideitem) $tag_name = $name; elseif ($name == $listtag) $insideitem = true; if ($insideengine) $tag_name = $name; elseif ($name == "ENGINE") { $insideengine = true; $engine = array(); $engine=$attr; } return true; } function h_eend($xp,$name) { global $tag_name,$url,$insideitem,$urlarray,$descarray,$desc,$titlearray,$title,$redirecturl,$redirecturlarray,$listtag,$insideengine,$engine,$feedtag; if($engine['NAME']==$feedtag) { if ($name == $listtag) { $urlarray[]=trim($url); $descarray[]=str_replace("&","&",trim($desc)); $titlearray[]=str_replace("+"," ",trim($title)); $redirecturlarray[]=trim($redirecturl); $url=""; $desc=""; $title=""; $redirecturl=""; $insideitem = false; } } if ($name == "ENGINE") $insideengine=false; $tag_name = ''; return true; } function h_char_weather($xp,$cdata) { global $tag_name,$insideitem,$url,$desc,$title,$redirecturl,$redirecturl,$displaytags,$desctags,$titletags,$redirecturltags,$cpctags,$cpc,$random; if ($insideitem) { switch ($tag_name) { case $displaytags[$random]: $url .= $cdata; break; case $desctags[$random]: $desc .= $cdata; break; case $titletags[$random]: $title .= $cdata; break; case $redirecturltags[$random]: $redirecturl .= $cdata; break; case $cpctags[$random]: $cpc .= $cdata; break; } } return true; } function h_estart_weather($xp,$name,$attr) { global $tag_name,$insideitem,$starttags,$random; if ($insideitem) $tag_name = $name; elseif ($name == $starttags[$random]) $insideitem = true; return true; } function h_eend_weather($xp,$name) { global $tag_name,$url,$insideitem,$urlarray,$descarray,$desc,$titlearray,$title,$redirecturl,$redirecturlarray,$starttags,$cpc,$cpcarray,$random,$domain,$random; // print $name." ".$starttags[$random]."\n"; if ($name == $starttags[$random]) { if ( $url!="http://www.pointcom.com"){ $urlarray[]=trim($url); $descarray[]=trim($desc); $titlearray[]=str_replace("+"," ",trim($title)); $redirecturl = str_replace("http://www.http://www.","http://www.",$redirecturl); $redirecturlarray[]=trim($redirecturl); $bid=str_replace("$","",$cpc); $bid=($bid)?$bid:"1.00"; $cpcarray[]=$bid; } $url=""; $desc=""; $title=""; $redirecturl=""; $cpc=""; $insideitem = false; } $tag_name = ''; return true; } function h2_char($xp,$cdata) { global $tag_name,$insideitem,$url,$desc,$title,$redirecturl,$redirecturl,$displaytags,$desctags,$titletags,$redirecturltags,$cpctags,$cpc,$random; if ($insideitem) { switch ($tag_name) { case $displaytags[$random]: $url .= $cdata; break; case $desctags[$random]: $desc .= $cdata; break; case $titletags[$random]: $title .= $cdata; break; case $redirecturltags[$random]: $redirecturl .= $cdata; break; case $cpctags[$random]: $cpc .= $cdata; break; } } return true; } function h2_estart($xp,$name,$attr) { global $tag_name,$insideitem,$starttags,$random; if ($insideitem) $tag_name = $name; elseif ($name == $starttags[$random]) $insideitem = true; return true; } function h2_eend($xp,$name) { global $tag_name,$url,$insideitem,$urlarray,$descarray,$desc,$titlearray,$title,$redirecturl,$redirecturlarray,$starttags,$cpc,$cpcarray,$random,$domain; if ($name == $starttags[$random]) { if ( $url!="http://www.pointcom.com"){ if (!(stristr($redirecturl, 'overture'))){ $urlarray[]=trim($url); $descarray[]=trim($desc); $titlearray[]=str_replace("+"," ",trim($title)); $redirecturl = str_replace("http://www.http://www.","http://www.",$redirecturl); $redirecturlarray[]=trim($redirecturl); $bid=str_replace("$","",$cpc); $bid=($bid)?$bid:"1.00"; $cpcarray[]=$bid; } } $url=""; $desc=""; $title=""; $redirecturl=""; $cpc=""; $insideitem = false; } $tag_name = ''; return true; } function h2_char_sp($xp,$cdata) { global $tag_name,$insideitem,$url,$desc,$title,$redirecturl,$redirecturl,$displaytags,$desctags,$titletags,$redirecturltags,$cpctags,$cpc,$random,$img,$imgtags; if ($insideitem) { switch ($tag_name) { case $displaytags[$random]: $url .= $cdata; break; case $desctags[$random]: $desc .= $cdata; break; case $titletags[$random]: $title .= $cdata; break; case $redirecturltags[$random]: $redirecturl .= $cdata; break; case $cpctags[$random]: $cpc .= $cdata; break; case $imgtags[$random]: $img .= $cdata; break; } } return true; } function h2_estart_sp($xp,$name,$attr) { global $tag_name,$insideitem,$starttags,$random,$img,$imgtags; if ($insideitem) $tag_name = $name; elseif ($name == $starttags[$random]) $insideitem = true; return true; } function h2_eend_sp($xp,$name) { global $tag_name,$url,$insideitem,$urlarray,$descarray,$desc,$titlearray,$title,$redirecturl,$redirecturlarray,$starttags,$cpc,$cpcarray,$random,$domain,$imgarray,$img,$imgtags; if ($name == $starttags[$random]) { if ( $url!="http://www.pointcom.com"){ $urlarray[]=trim($url); $desc = str_replace("<","<",$desc); $desc = str_replace(">",">",$desc); $descarray[]=trim($desc); $titlearray[]=str_replace("+"," ",trim($title)); $redirecturl = str_replace("http://www.http://www.","http://www.",$redirecturl); $redirecturlarray[]=trim($redirecturl); $bid=str_replace("$","",$cpc); $bid=($bid)?$bid:"1.00"; $cpcarray[]=trim($bid); $imgarray[] = trim($img); } $url=""; $desc=""; $title=""; $redirecturl=""; $cpc=""; $img=""; $insideitem = false; } $tag_name = ''; return true; } function h3_char($xp,$cdata) { global $tag_name,$insideitem,$redirecturl,$redirecturltag,$listing,$tag_name,$insideitem,$url,$desc,$title,$cpc,$insideresult,$result; if ($insideitem && $insideresult) { if($result['ID']=="searchResults"){ if (is_array($listing)and $tag_name) $redirecturl .= $cdata; } } return true; } function h3_estart($xp,$name,$attr) { global $listing, $tag_name,$insideitem,$listtag,$insideresult,$result; if ($insideitem) $tag_name = $name; elseif($name==$listtag) { $insideitem=true; $listing = array(); $listing=$attr; } if ($insideresult) $tag_name = $name; elseif ($name == "RESULTSET" ) { $insideresult = true; $result = array(); $result=$attr; } return true; } function h3_eend($xp,$name) { global $tag_name,$insideitem,$urlarray,$descarray,$titlearray,$redirecturl,$redirecturlarray,$listtag,$listing,$urltag,$descriptiontag,$titletag, $insideresult, $result, $insideitem; if($name==$listtag) { if ($redirecturl && ($listing[$urltag] != "AdultFriendFinder.com")){ $urlarray[]=trim($listing[$urltag]); $descarray[]=trim($listing[$descriptiontag]); $titlearray[]=str_replace("+"," ",trim($listing[$titletag])); $redirecturl= trim($redirecturl); $redirecturlarray[]= "http://click.pointcom.com/d.php?url=".urlencode($redirecturl); } $redirecturl= ''; $insideitem = false; } if ($name == "RESULTSET"){ $insideresult=false; } $tag_name = ''; return true; } function h4_char($xp,$cdata) { global $tag_name,$insideitem1,$redirecturl,$redirecturltag,$listing,$tag_name,$insideitem1,$url,$desc,$title,$cpc; if ($insideitem1) { if (is_array($listing)and $tag_name) $redirecturl .= $cdata; } return true; } function h4_estart($xp,$name,$attr) { global $listing, $tag_name,$insideitem1,$listtag,$insideitem1; if ($insideitem1) $tag_name = $name; elseif($name==$listtag) { $insideitem1=true; $listing = array(); $listing=$attr; } if ($insideresult) $tag_name = $name; elseif ($name == "AD" ) { $insideresult = true; $result = array(); $result=$attr; } return true; } function h4_eend($xp,$name) { global $tag_name,$insideitem1,$urlarray,$descarray,$titlearray,$redirecturl,$redirecturlarray,$listtag,$listing,$urltag,$descriptiontag,$titletag,$insideitem1; if($name==$listtag) { if ($listing[$urltag] == "business_name"){ $redirecturlarray[]= "http://click.pointcom.com/d.php?url=".urlencode($listing[$descriptiontag]); $titlearray[]=trim($listing[$titletag]); } elseif ($listing[$urltag] == "tagline") { $descarray[]=trim($listing[$titletag]); } elseif ($listing[$urltag] == "website_link") { $urlarray[]=trim($listing[$titletag]); } $redirecturl= ''; $insideitem1 = false; } if ($name == "AD"){ $insideresult=false; } $tag_name = ''; return true; } function kudoid($domain){ $kudoids=array("amazo.com"=>"64687","aoll.com"=>"133786","aollonlinelyrics.com"=>"133857","bakofamerica.com"=>"32198","businesweek.com"=>"41503","channelfour.com"=>"523","cityserch.com"=>"45686","cnett.com"=>"50576","colo.com"=>"51181","disey.com"=>"64736","eather.com"=>"133786","ebayc.com"=>"6087","heatcc.com"=>"15568","hedhunter.net"=>"83045","mapques.com"=>"8593","moey.com"=>"15564","pcword.com"=>"102586","referenc.com"=>"127682","searchs.com"=>"45686","sprimtpcs.com"=>"130203","supercybersearcher.com"=>"15392","traveocity.com"=>"512","voicepulsevoip.com"=>"83045","weater.com"=>"511","whensearch.com"=>"134108","yellowpagesonline.com"=>"9786214"); return $kudoids[$domain]; } function getrandcat($db){ $categories=array(); $selectsql="select category from categories order by rand() limit 2"; if ($result = mysql_query($selectsql,$db)) { while($row=mysql_fetch_assoc($result)) { $categories[]=array("Category"=>$row["category"]); } } if(count($categories)>0) return $categories; else return 0; } function getBrowser(){ $browser = array("OPERA","MSIE","NETSCAPE","FIREFOX","SAFARI","MOZILLA"); $info['browser'] = "OTHER"; foreach ($browser as $parent) { if(isset($_SERVER['HTTP_USER_AGENT'])) { if ( ($s=strpos(strtoupper($_SERVER['HTTP_USER_AGENT']), $parent)) !== FALSE ) { $f = $s + strlen($parent); $version = substr($_SERVER['HTTP_USER_AGENT'], $f, 5); $version = preg_replace('/[^0-9,.]/','',$version); $info['browser'] = $parent; $info['version'] = $version; break; } } } return $info; } function generateSlug($slug){ $result = strtolower($slug); $result = preg_replace('/[^a-z0-9\s-]/', '', $result); $result = trim(preg_replace('/[\s-]+/', ' ', $result)); $result = preg_replace('/\s/', '-', $result); return $result; } ?>