//ini_set("display_errors", '1');
require_once 'conf.php';
require_once THISBASEDIR.'/lib-func/common.php';
require_once THISBASEDIR.'/lib-func/SiteData.php';
require_once THISBASEDIR.'/lib-func/mysqlConnector.php';
require_once THISBASEDIR.'/lib-func/LinkFormat.php';
require_once THISBASEDIR.'/configuration/conf.php';
require_once THISBASEDIR.'/lib-func/articlePageFunctions.php';
require_once THISBASEDIR.'/lib-func/Pager.php';
require_once THISBASEDIR.'/configuration/conf.php';
require_once THISBASEDIR.'/adsense-content.php';
// initialize
$dbObj = new MySQLConnector(array('host'=>HOST,'user'=>DBUSER,'password'=>DBPASS,'database'=>DBNAME));
$siteDataObj = new SiteData($dbObj);
$stateDataArr = getStateArr($dbObj);
$breedsdDataArr = getBreedsArr($dbObj);
$sideMenuHTML = "";
if(!isset($_GET['page']))$_GET['page'] = 1;
// determine page request type
if(trim($_SERVER['QUERY_STRING'])==""){
// show state list of breeders with count
$breedersArr = array();
$html .= "
Hunting Dog breeders by state
";
$query = "SELECT COUNT(breeders.id) as breederCount, state.stateName, countries.country
FROM state LEFT JOIN breeders ON (state.id = breeders.state AND breeders.active = 1), countries
WHERE state.country = countries.id
GROUP BY state.id
ORDER BY state.stateName";
$dbObj->performQuery($query);
while($row = $dbObj->fetchRow()){
$breedersArr[$row['country']][] = $row;
}
$html .="
";
$pageTitle = "Hunting Dog Breeders";
$metaDescription = "Find gun dog breeders by State or by hunting dog breeds. Bird dog puppy for sale classified ads include started and finished dogs for sale.";
$metaKeywords = "gun dogs, hunting dogs, dog breeders, trainers, bird dog, kennel, puppy for sale, started, finished, male, female, puppies, sporting breeds, USA and Canada";
// record hit
//$dbObj->performQuery("INSERT INTO traffic SET mark = NOW(), referringIP = '{$_SERVER['REMOTE_ADDR']}', type = 'incoming', pageType='breeder'");
} else if(isset($_GET['breederName']) && isset($_GET['stateID'])){
// show breeder data
$query = "SELECT breeders.id,
breeders.name,
breeders.linkName,
breeders.services,
breeders.address,
breeders.zip,
breeders.city,
breeders.phone,
breeders.secPhone,
breeders.contact,
breeders.writeup,
breeders.businessYrs,
breeders.breeds,
breeders.dateModified,
breeders.logo,
breeders.imgExt,
breeders.expires,
breeders.email,
breeders.website,
state.stateName,
count(classifieds.id) as classifiedsCount
FROM breeders LEFT JOIN classifieds ON classifieds.ownerID = breeders.id AND classifieds.expires >= NOW(), state
WHERE breeders.state = state.id
AND breeders.linkName LIKE '".linkFormat::stripDashes($_GET['breederName'])."'
AND breeders.active = 1
AND state.stateName LIKE '".LinkFormat::stripDashes($_GET['stateID'])."'
GROUP BY breeders.id";
$dbObj->performQuery($query);
if($row = $dbObj->fetchRow()){
$html = "";
$services = "";
if(strtotime($row['expires'])>strtotime("now")){
$paid=1;
$dataContainerClass = "dataContainer2";
} else {
$dataContainerClass = "dataContainer";
}
if(trim($row['logo']!="" && trim($row['imgExt']!=""))){
if($row['imgExt']==".png"){
} else {
$html.= "
";
}
// get pedigrees
$query = "SELECT title, id FROM pedigrees WHERE owner = ".$row['id']." AND showOnBreedPage = 1 ORDER BY title";
$dbObj->performQuery($query);
$pedigreeArr = array();
while($pRow = $dbObj->fetchRow()){
$pedigreeArr[] = "mobileSiteURL}/pedigree{$pRow['id']}.html\">{$pRow['title']}";
}
if(count($pedigreeArr)>0){
$html .= "
Our Pedigrees
";
$html .= "
";
$html .= implode(" ",$pedigreeArr);
$html .= "
";
}
// get testimonials
$testInitLimit = 10;
$query = "SELECT count(id) as totalReviews FROM reviews WHERE ownerID = {$row['id']} AND active = 1 ";
$dbObj->performQuery($query);
if($revCount = $dbObj->fetchRow()){
$totalReviews = $revCount['totalReviews'];
} else {
$totalReviews = 0;
}
$query = "SELECT name, dateCreated, rating, comment FROM reviews WHERE ownerID = ".$row['id']." AND (active = 1 OR ip = '".$_SERVER['REMOTE_ADDR']."') ORDER BY dateCreated DESC LIMIT $testInitLimit";
$dbObj->performQuery($query);
$reviewArr =array();
while($rRow = $dbObj->fetchRow()){
$reviewArr[] = "
Submitted by: ".$rRow['name']." on ".formatDate($rRow['dateCreated'])."
".nl2br($rRow['comment']);
}
$html .= "
Testimonials ($totalReviews)";
$html .= ($totalReviews>$testInitLimit)?' You are viewing the 10 most recent - Click here for more reviews':"";
$html .= "
";
}
$pageTitle = "$breed Puppies For Sale by $breed Breeders, Trainers and Kennels";
$metaDescription = "Find $breed puppies for sale from gun dog breeders who raise $breed puppies and offer started $breed dogs, finished dogs and $breed puppies for sale.";
$metaKeywords = "$breed puppies, $breed breeders, $breed puppy for sale, $breed dogs, Female, Male, Puppies, Breeders, Kennels, Started, Finished, stud, pups";
// record hit
//$dbObj->performQuery("INSERT INTO traffic SET mark = NOW(), referringIP = '{$_SERVER['REMOTE_ADDR']}', breedID = (SELECT id FROM breeds WHERE breeds LIKE '".Linkformat::stripDashes($_GET['breeds'])."'), type = 'incoming', pageType='breeder'");
} else if(isset($_GET['stateID'])){
// Breeders by State
// assumes only state has been set
$stateID = LinkFormat::stripDashes($_GET['stateID']);
$query = "SELECT breeders.name,breeders.linkName,breeders.services,breeders.city, breeders.breeds, breeders.dateModified,
breeders.id,
state.stateName,state.abbv, breeders.expires,
COUNT(reviews.id) as reviewCount
FROM breeders LEFT JOIN reviews ON reviews.ownerID = breeders.id, state
WHERE breeders.state = state.id
AND breeders.active = 1
AND state.stateName LIKE '$stateID'
GROUP BY breeders.id
ORDER BY IF(breeders.expires >=NOW(),0,1), reviewCount DESC, breeders.businessYrs DESC";
$pg=&new Pager($dbObj,$query,50);
$resArr = $pg->displayRecords($_GET['page'],"$siteDataObj->mobileSiteURL/breeders-{$_GET['stateID']}/breeders");
//$stateClassifiedLink = "View puppies for sale in $stateID by $stateID gun dog breeders.";
if(count($resArr['results'])>0){
$html = "
";
} else {
showImproperRequest();
exit();
}
}
$pageTitle = "Hunting Dog Puppies in $stateName and $stateName Bird Dog Breeders";
$metaDescription = "Find hunting dog breeders in $stateName with bird dog puppies for sale as well as started and finished bird hunting dogs raised and trained in $stateName.";
$metaKeywords = "$stateName hunting dog breeders, bird dogs, hunting, puppy for sale, $stateName dog kennels, breeder, kennel, puppies, female, male, pup";
// record hit
//$dbObj->performQuery("INSERT INTO traffic SET mark = NOW(), referringIP = '{$_SERVER['REMOTE_ADDR']}', stateID = (SELECT id FROM state WHERE stateName LIKE '$stateID'), type = 'incoming', pageType='breeder'");
} else if(isset($_GET['allBreeders'])){
// All breeders by alpha
$resultsPerPage = 50;
$query = "SELECT breeders.name,breeders.linkName,breeders.city,breeders.breeds,breeders.dateModified, breeders.expires,
breeders.id,
state.stateName, count(classifieds.id) as classifiedsCount
FROM state, breeders LEFT JOIN classifieds ON (breeders.id = classifieds.ownerID AND classifieds.expires >= NOW())
WHERE breeders.active = 1
AND breeders.state = state.id
GROUP BY breeders.id
ORDER BY IF(breeders.expires >=NOW(),0,1), breeders.name";
$pg=&new Pager($dbObj,$query,$resultsPerPage);
$resArr = $pg->displayRecords($_GET['page'],"allBreeders");
$a = 0;
if(count($resArr['results'])>0){
$html = "
";
}
$pageTitle = "All Gun Dog Breeders in USA and Canada";
$metaDescription = "Find gun dog breeders in USA and Canada with bird dog puppies for sale as well as started dogs, finished dogs and training for hunting dogs and sporting breeds.";
$metaKeywords = "gun dog, hunting dog breeder, bird dogs, USA dog breeders, Canada puppy for sale, kennel, hunting, bird, started, finished dogs, training, pup, pointer, retriever, setter ";
$metaSEO = "";
} else if(isset($_GET['canadaBreeders'])){
// Canada breeders by alpha
$resultsPerPage = 50;
$html = "";
$query = "SELECT COUNT(breeders.id) as breederCount, state.stateName, countries.country
FROM state LEFT JOIN breeders ON (state.id = breeders.state AND breeders.active = 1), countries
WHERE state.country = countries.id
AND breeders.country = 2
GROUP BY state.id
ORDER BY state.stateName";
$dbObj->performQuery($query);
while($row = $dbObj->fetchRow()){
$breedersArr[$row['country']][] = $row;
}
$itemArr = array();
$optionArr = array();
foreach($breedersArr as $key => $value){
if(is_array($value) && count($value)>0){
foreach($value as $stateBreederData){
$itemArr[] = "mobileSiteURL."/breeders-".LinkFormat::addDashes($stateBreederData['stateName'],lcase)."/\">{$stateBreederData['stateName']}". (($stateBreederData['breederCount']>0)?" (".$stateBreederData['breederCount'].")":"");
$optionArr[] = "";
}
}
$html .="
";
$selectHTML = "";
$html.="
".$selectHTML."
".implode("
",$itemArr)."
";
}
$query = "SELECT breeders.name,breeders.linkName,breeders.city,breeders.breeds,breeders.dateModified, breeders.expires,
breeders.id,
state.stateName, count(classifieds.id) as classifiedsCount
FROM state, breeders LEFT JOIN classifieds ON (breeders.id = classifieds.ownerID AND classifieds.expires >= NOW())
WHERE breeders.active = 1
AND breeders.state = state.id
AND breeders.country = 2
GROUP BY breeders.id
ORDER BY IF(breeders.expires >=NOW(),0,1), breeders.name";
$pg=&new Pager($dbObj,$query,$resultsPerPage);
$resArr = $pg->displayRecords($_GET['page'],"bird-dog-breeders-in-canada");
$a = 0;
if(count($resArr['results'])>0){
$html .= "
";
}
$pageTitle = "Bird Dog Breeders in Canada";
$metaDescription = "Find bird dog breeders in Canada with bird dog puppies for sale as well as started dogs, finished dogs and training for hunting dogs and sporting breeds.";
$metaKeywords = "bird dog, canada hunting dog breeder, bird dogs for sale, canadian dog breeders, Canada puppy for sale, kennel, hunting, bird, started, finished dogs, training, pup, pointer, retriever, setter ";
$metaSEO = "";
} else {
showImproperRequest();
exit();
}
function formatListing(&$row, &$a, &$siteDataObj, &$thisBreedsArr, &$dbObj){
$colorArr = array("eeeeee","ffffff");
$html = "";
$style = "background: #".$colorArr[($a%2)];
$html .= "
";
if(strtotime("now") < strtotime($row['expires'])){
$html .= "";
}
//$html.= strtotime($row['expires'])."-".strtotime("now");
$html .= "mobileSiteURL."/breeders-".LinkFormat::addDashes($row['stateName'],lcase)."/".LinkFormat::addDashes($row['linkName'],lcase).".html\" class=\"breederLink\">".$row['name']."";
$html .= " ".$row['city']." - ".$row['stateName']." ";
$dbObj->performQuery("SELECT COUNT(*) as cCount FROM classifieds WHERE ownerID = {$row['id']} AND expires >= NOW()");
if($row = $dbObj->fetchRow()){
if($row['cCount'] >0){
$html .= "We currently have an active classified ";
}
}
if(count($thisBreedsArr)>0) $html .= "Hunting Dog Breeds Raised: ".implode(", ",$thisBreedsArr)."";
$html .= "
";
return $html;
}
function getBreedNames($breeds,&$breedsdDataArr){
$thisBreedsArr = array();
$dbBreeds = explode(",",$breeds);
if(count($dbBreeds)>0){
foreach($dbBreeds as $value){
if($value!=0){
$thisBreedsArr[] = $breedsdDataArr[$value];
}
}
}
return $thisBreedsArr;
}
function getCategoryAd(&$dbObj,$breedID,$table){
$html = '';
$query = "SELECT * FROM $table WHERE category = $breedID AND end > DATE_SUB(NOW(),INTERVAL 1 DAY) AND start <= NOW() ";
$dbObj->performQuery($query);
if($row = $dbObj->fetchRow()){
$html = "