fullySanitize($_GET['key']); if (strlen($key) == 0) $key = "singles-US"; $depth = 1; // 1 for country, 2 for state, 3 for city $keys = explode("-", $key); $cat = $keys[0]; // this is cat_path $country = $keys[1]; // this is loc_path of country $state = ""; // this is loc_path of state $city = ""; // this is loc_path of city $catdisp = ""; // this is display value for category, ex. "Christian Singles" $peopledisp = ""; // this is display value for people of above category, which may differ from above $catlink = ""; // this is the category link html, ex. "United States / Nevada" $locdesc = ""; // description of the top location, ex. "Reno, NV" $countryname = ""; // display name of country $statename = ""; // display name of state $cityname = ""; // display name of city $toplocpath = $country; $toploctype = 'COUNTRY'; if (count($keys) > 2) { $state = $keys[2]; $toplocpath = $state; $toploctype = 'STATE'; $depth = 2; } if (count($keys) > 3) { $city = $keys[3] . '_' . strtolower($state); $toplocpath = $city; $toploctype = 'CITY'; $depth = 3; } $trans->beginTrans(); $pdo = $trans->getPDO(); //first are there any tips on this page? and it's a page of depth 3? //if not, kill the page with a 404 if ($depth == 3) { $stmt = $pdo->prepare('SELECT 1 FROM tip a, location_cat b WHERE b.location_cat_id=a.location_cat_id AND b.loc_path = ? AND b.cat_path = ? AND a.admin_flag = \'A\' LIMIT 1'); $stmt->bindParam(1, $toplocpath); $stmt->bindParam(2, $cat); $stmt->execute(); //no tip? 404! if (!$stmt->fetch(PDO::FETCH_NUM)) { header('HTTP/1.1 404 Not Found', TRUE, 404); ?> 404 File Not Found

404 File Not Found

Oops. There is no page to display!

fullySanitize($_SERVER['HTTP_USER_AGENT']); if (strpos($useragent, 'Googlebot/2.1')) append_file("../referer_files/geospider.txt", date("m/d/y H:i:s") . ' - Google spidered: ' . $key . "\n"); else if (strpos($useragent, 'msnbot/1.0')) append_file("../referer_files/geospider.txt", date("m/d/y H:i:s") . ' - MSN spidered: ' . $key . "\n"); else if (strpos($useragent, 'Yahoo! Slurp')) append_file("../referer_files/geospider.txt", date("m/d/y H:i:s") . ' - Yahoo spidered: ' . $key . "\n"); ?> prepare('SELECT display, people_disp FROM category WHERE cat_path = ?'); $stmt->bindParam(1, $cat); $stmt->execute(); $myrow = $stmt->fetch(PDO::FETCH_NUM); $catdisp = $myrow[0]; $peopledisp = $myrow[1]; if (strlen($country) != 0) { $stmt = $pdo->prepare('SELECT name FROM location WHERE loc_path = ?'); $stmt->bindParam(1, $country); $stmt->execute(); $myrow = $stmt->fetch(PDO::FETCH_NUM); $countryname = $myrow[0]; } if (strlen($state) != 0) { $stmt = $pdo->prepare('SELECT name FROM location WHERE loc_path = ?'); $stmt->bindParam(1, $state); $stmt->execute(); $myrow = $stmt->fetch(PDO::FETCH_NUM); $statename = $myrow[0]; } if ($city != "") { $stmt = $pdo->prepare('SELECT name FROM location WHERE loc_path = ?'); $stmt->bindParam(1, $city); $stmt->execute(); $myrow = $stmt->fetch(PDO::FETCH_NUM); $cityname = $myrow[0]; } if ($depth == 1) { $catlink = $countryname; $locdesc = $countryname; } else if ($depth == 2) { $catlink = "$countryname / $statename"; $locdesc = $statename; } else if ($depth == 3) { $catlink = "$countryname / $statename / $cityname"; $locdesc = $cityname . ", " . $state; } printf("%s Dating ♥ %s", $locdesc, $catdisp); ?>

Dating in

Dating Diversions | prepare('SELECT cat_path, display FROM category ORDER BY disp_order'); $stmt->execute(); while ($myrow = $stmt->fetch(PDO::FETCH_NUM)) { if ($myrow[0] != 'friends') { if ($c != 0) echo " | "; if ($cat == $myrow[0]) echo $myrow[1]; else printf("%s", $myrow[0], $myrow[1]); $c = $c + 1; } } ?>
Category: $catlink
\r\n"; $stmt = $pdo->prepare('SELECT a.loc_path, a.name, a.population FROM location a, location_cat b WHERE a.loc_path=b.loc_path AND b.cat_path = ? AND a.parent_path = ? '. ($toplocpath == 'US' ? '' : 'AND EXISTS(SELECT 1 FROM tip t WHERE t.location_cat_id=b.location_cat_id and t.admin_flag = \'A\') ') .' ORDER BY a.name'); $stmt->bindParam(1, $cat); $stmt->bindParam(2, $toplocpath); $stmt->execute(); $rows = array(); while ($myrow = $stmt->fetch(PDO::FETCH_NUM)) $rows[] = $myrow; $num = count($rows); if ($num != 0) { echo "
    "; $c = 0; foreach ($rows AS $myrow) { $keyend = $myrow[0]; if ($depth == 2) $keyend = substr($keyend, 0, strlen($keyend) - 3); printf("
  • %s
  • \r\n", $key . "-" . $keyend, $myrow[1]); $c = $c + 1; if ($c >= ($num / 2)) { echo "
    "; $c = -10; } } echo "
"; } ?>

Nightclubs

** Coming Soon **

Restaurants

** Coming Soon **

fullySanitize($_COOKIE['mystic']); if ($cookieval == '') { if ($cat == 'christian') { echo ''; echo 'ChristianCafe.com - All Christian. All Single!'; } else if ($cat == 'gay') { echo ''; echo 'gay.com Premium Personals Free Week Offer'; } else { echo getAd($cookieval, '120x240', 'f', $pdo); } } else echo getAd($cookieval, '120x240', 'f', $pdo); ?>

Online Dating Services Serving

prepare('SELECT a.body FROM ad a, ad_map b, location_cat c WHERE c.cat_path = ? AND c.loc_path = ? AND b.location_cat_id=c.location_cat_id AND a.ad_id=b.ad_id'); $stmt->bindParam(1, $cat); $stmt->bindParam(2, $toplocpath); $stmt->execute(); $countad = 0; while ($myrow = $stmt->fetch(PDO::FETCH_NUM)) { if ($countad == 0) echo ''; */ ?>

Dating Tips and Advice for

prepare('SELECT a.body, a.name, a.location, a.tip_id FROM tip a, location_cat b WHERE b.location_cat_id=a.location_cat_id AND b.loc_path = ? AND b.cat_path = ? AND a.admin_flag = \'A\' ORDER BY a.tip_id DESC LIMIT 30'); $stmt->bindParam(1, $toplocpath); $stmt->bindParam(2, $cat); $stmt->execute(); $tipcount = 0; while ($myrow = $stmt->fetch(PDO::FETCH_NUM)) { if ($tipcount == 1) { ?>
\"%s\" -%s, %s

\r\n
", $myrow[0], $myrow[1], $myrow[2]); $tipcount++; } if ($tipcount == 0) echo '

No advice yet, be the first to add advice to this location!

'; ?>
Add your dating tips or advice for in
View our Privacy Policy commit(); $trans->disconnect(); ?>