'Male', 2=>'Female', 3=>'Couple'); $typesdisplayplural = array(1=>'Men', 2=>'Women', 3=>'Couples'); $typeslinks = array(1=>'m', 2=>'f', 3=>'c'); $last_used_class = ''; $last_class_used = ''; if($county == null){ require 'components/fragments/page_header.php'; echo '

'; echo '

Missing parameter

'; echo '
'; require 'components/fragments/page_footer.php'; exit(); } $query = "SELECT m.id, c.county FROM members AS m LEFT JOIN counties AS c ON m.county = c.id WHERE LOWER(c.county) = '".ereg_replace('-', ' ', strtolower($county))."' AND type=".$type." GROUP BY m.id ORDER BY m.lastlogin DESC"; $result = q($query, $SESS_DBH); $matches = array(); while($row = mysql_fetch_assoc($result)) array_push($matches, intval($row['id'])); $results = count($matches); if ($results > 0) { $tempn = isset($_GET['n']) ? (int)$_GET['n'] : 1; define('n', $tempn); define('numperpage', 30); define('numpages', ceil($results / numperpage)); define('startnumber', (n * numperpage) - numperpage); $tempend = $results < numperpage ? $results : numperpage; define('endnumber', $tempend); $idsa = array(); for($x=startnumber; $x<(startnumber+endnumber); $x++) { if(!empty($matches[$x])) $idsa[] = $matches[$x]; } $ids = implode(', ', $idsa); $query = "SELECT m.id, m.username, m.type, m.extras_renewal, t.title, p.name, o.gender, (SELECT COUNT(1) AS cnt FROM members_photos WHERE userid = m.id) AS photocnt, (SELECT COUNT(1) AS cnt FROM members_genuine WHERE userid = m.id) AS establishedcnt, (SELECT COUNT(1) AS cnt FROM members_videos WHERE userid = m.id) AS videocnt, (SELECT COUNT(1) AS cnt FROM members_comments WHERE userid = m.id) AS commentcnt FROM members m INNER JOIN members_advert t ON m.id = t.userid INNER JOIN members_profile p ON m.id = p.userid INNER JOIN options_class o ON p.class = o.id WHERE m.id IN($ids) GROUP BY m.id"; $result = q($query, $SESS_DBH); //echo $query.'

'.mysql_error(); $nextlink = 'Next Page'; $prevlink = 'Previous Page'; } $pagetitle = 'American '.$typesdisplayplural[$type].' swinging in '. $state; $meta_keywords = $state ." Swingers, swinging in ". $state .", ". $state ." swinger directory"; $meta_description = "Browse Couples, Males and Females in ". $state ." and find swinging matches in America"; //////////////////// require 'components/fragments/page_header.php'; ?>

Couples Females Males

click here to start a new search.'; } else { ?>
Couples Females Males

Showing s in , page of

1) ? $prevlink : ' '; ?>

' . $name . ' (' . $gender . ')'; $id = $row['id']; $username = $row['username']; $type = $row['type']; $gender = $row['gender']; $title = ucfirst(strtolower(wordwrap(stripspam($row['title'], 0, 0), 30, "
", 1))); $user_has_extras = false; $extras_class = ""; if(empty($title)) { $title = " "; } if($row['extras_renewal'] >= date("Ymd")) { $user_has_extras = true; } //get counts $photocount = $row['photocnt']; $videocount = $row['videocnt']; $commentcount = $row['commentcnt']; $established = $row['establishedcnt']; $establishedimage = $established > 0 ? "User is established " : "User is not established "; $videoimage = $videocount > 0 ? "User has videos " : "User doesnt have videos "; $commentimage = $commentcount > 0 ? "User has comments " : "User doesnt have comments "; $photoimage = $photocount > 0 ? "User has photos " : "User doesnt have photos "; $has_icons = " $establishedimage$photoimage$videoimage$commentimage"; if($type == 3) // COUPLE { $names_label = 'Names'; $about_label = 'About us'; $temp = q("SELECT p.name, o.gender FROM members_profile p INNER JOIN options_class o ON p.class = o.id WHERE p.userid = ".intval($id)." LIMIT 1, 1", $SESS_DBH); $name2 = @mysql_result($temp, 0, 'name'); $gender2 = getGenderName( @mysql_result($temp, 0, 'gender') ); $memberData[] = '' . $name2 . ' (' . $gender2 . ')'; } $gender_icon = " "; if($user_has_extras) { $extras_class = " extrasrowhighlight"; //get a photo for the result $temp = q("SELECT p.filename, p.comment FROM members_photos p WHERE p.public = 1 AND p.userid = ".intval($id)." AND $porn LIMIT 1", $SESS_DBH); $row2 = mysql_fetch_assoc($temp); if(!empty($row2)) { $small_photo = $row2['filename']; $small_comment = $row2['comment']; } else { $small_photo = "no-photo.gif"; $small_comment = "Contact ".$username." for photo"; } } $about = preg_replace('##', ' ', $title); $names = implode(" & ", $memberData); echo << HTML; } //} // see note at matching brace ?>
User: {$username}
{$names_label}: {$names}
{$about_label}: {$about}
{$has_icons}

1) ? $prevlink : ' '; ?>