<?
        // Temp redirect to usyellowpagedb9 for certain states
        // This is to accomodate the dynamic pages the search engines have already listed.
        // Must be removed for use with 411-us-3

        $url = "";
        
	if(!empty($_GET[c]))
	{
		$c = $_GET[c];
	}
        
	if(!empty($_GET[Classif]))
	{
		$classif = $_GET[Classif];
	}

	if(!empty($_GET[search_country]))
	{
		$search_country = $_GET[search_country];
	}

	if(!empty($_GET[state]))
	{
		//$search_state = $_GET[state];
		$search_state = "AK";
	}
        else
        {
		$search_state = "AK";
        }

	if(!empty($_GET[search_zipcode]))
	{
		$search_zipcode = $_GET[search_zipcode];
	}

	if(!empty($_GET[search_region]))
	{
		$search_region = $_GET[search_region];
	}

	if(!empty($_GET[search_city]))
	{
		$search_city = $_GET[search_city];
	}

	$my_kw = trim($_GET[kw]);

	if(!empty($my_kw))
	{
		$search_kw = $my_kw;
	}

	$my_phonenbr = trim($_GET[search_phonenbr]);

	if(!empty($my_phonenbr))
	{
		$search_phonenbr = $my_phonenbr;
	}

	$my_staddress = trim($_GET[search_address]);

	if(!empty($my_staddress))
	{
		$search_staddress = $my_staddress;
	}

//}

switch ($search_state) {
        case 'AK' :
                $url = "http://www.alaska411.org/searchclassif.php?c=$c&search_kw=$search_kw&search_zipcode=$search_zipcode&search_city=$search_city&classif=$classif&search_country=$search_country&search_state=$search_state&search_staddress=$search_staddress&search_phonenbr=$search_phonenbr&search_region=$search_region&state=$search_state";
                break;
        default:
                // do nothing
                break;
}
if ($url != "")
{
        header("location:$url");
        exit();
}

        // End Temp redirect to usyellowpagedb9


//include ("begin_caching.php");
// Settings
$cachedir = '../cache/'; // Directory to cache files in (keep outside web root)
$cachetime = 360000; // Seconds to cache files for
$cacheext = 'cache'; // Extension to give cached files (usually cache, htm, txt)

// Ignore List
$ignore_list = array(
'ilovejackdaniels.com/rss.php',
'ilovejackdaniels.com/search/'
);

// Script
$page = 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; // Requested page
$cachefile = $cachedir . md5($page) . '.' . $cacheext; // Cache file to either load or create

$ignore_page = false;
for ($i = 0; $i < count($ignore_list); $i++) {
$ignore_page = (strpos($page, $ignore_list[$i]) !== false) ? true : $ignore_page;
}

$cachefile_created = ((@file_exists($cachefile)) and ($ignore_page === false)) ? @filemtime($cachefile) : 0;
@clearstatcache();

// Show file from cache if still valid
if (time() - $cachetime < $cachefile_created) {

//ob_start('ob_gzhandler');
@readfile($cachefile);
//ob_end_flush();
exit();

}

// If we're still here, we need to generate a cache file

ob_start();

require_once("conn.php");
require_once("includes.php");

$query   = array();
$nbrargs = 0;
$blanks  = "          ";
$alphabet = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
$display_cStart = "";
$first_row = "Y";


if(!empty($_GET[classif]))
{
        $classif = $_GET[classif];        

        $qsbrc = "select classification from yellow_classifications where classid = '$classif' ";
        $rsbrc = mysql_query($qsbrc) or die(mysql_error());
        if(mysql_num_rows($rsbrc) > '0')
        {
	        $asbrc = mysql_fetch_array($rsbrc);
	        $class_name = $asbrc[classification];
	        $class_name .= " ";
        }
        else
        {
	        $class_name .= "Unknown ";
        }

        if(!empty($_GET[alpha_search]))
        { 
                $cStart = $_GET[alpha_search];
                $display_cStart = "($_GET[alpha_search])";
                $cPageStart = $_GET[alpha_search];
	        $query[] = "yellow_classifications.classification like '$cStart%' ";
        }
        else
        {
                $cStart = "";
	        $query[] = "yellow_classifications.classification like '$cStart%' ";
        }
        $nbrargs++;
}


if(!empty($_GET[search_region]))
{
        $Region = $_GET[search_region];
        $qsbr = "select region_name from yellow_region2 where region_id = '$Region' ";
        $rsbr = mysql_query($qsbr) or die(mysql_error());
        if(mysql_num_rows($rsbr) > '0')
        {
	        $asbr = mysql_fetch_array($rsbr);
	        $region_name = $asbr[region_name];
	        $region_name .= " ";
        }
}

if(!empty($query))
{
	$MyQuery = implode(" and ", $query);
	$MyQuery = " and ".$MyQuery;
}


////////////////////////////////////////////////////////////
//////////		order by
////////////////////////////////////////////////////////////

$order = array();

if(!empty($_GET[orderby]))
{
	$MyOrder = explode("|", $_GET[orderby]);

	// ,$ov ??????
        while(list(,$ov) = each($MyOrder))
	{
		if($ov == "DateAdded")
		{
			$order[] = " yellow_classifications.classification desc ";
		}
		
		if($ov == "address")
		{
			$order[] = " yellow_classifications.classification asc ";
		}

	}
}
else
{
	if(!empty($_GET[p]))
	{
		$order[] = " yellow_classifications.classification desc ";
	}
	
}


if(count($order) > '0')
{
	$MyOrder = implode(", ", $order);

}

if(empty($MyOrder))
{
	$MyOrder = " order by yellow_classifications.classification asc";
}
else
{
	$MyOrder = " order by yellow_classifications.PriorityLevel desc, $MyOrder";
}


if(!empty($_GET[Start]))
{
	$Start = $_GET[Start];
}
else
{
	$Start = '0';
}

$ByPage = '20';
$ByPage100 = '100';

$aset[SiteTitle] = "US & Alaska Yellow Pages, 411 Search";
$aset[SiteDescription] = "The US & Alaska Yellow Pages, Business 411, Find Anything Anywhere."; 
//$aset[SiteKeywords] = ""; 


        //$q1 = "select * from yellow_classifications, where $MyQuery $MyOrder limit $Start, $ByPage ";
        //$qnav = "select * from yellow_classifications where $MyQuery";
        if(!empty($_GET[alpha_search]))
        { 
                $cStart = $_GET[alpha_search];
                $cPageStart = $_GET[alpha_search];
        }
        if(!empty($_GET[cPageStart]))
        {
                $cStart = $_GET[cPageStart];
        }
        $q1   = "select * from yellow_classifications where yellow_classifications.classification like '$cStart%' $MyOrder limit $Start, $ByPage ";
        $qnav = "select * from yellow_classifications where yellow_classifications.classification like '$cStart%'  $MyOrder limit $Start, $ByPage100 ";
           

$r1 = mysql_query($q1) or die(mysql_error());
$lrows = mysql_num_rows($r1);

$first_time = 'true';

//if (empty($query))
//{
//	$ListingTable = "<br><br><br><br><center><br><br><font color=#ff0000 size=4>Sorry, must specify search criteria...</font><br><br><br><a href=\"javascript:history.go(-1)\"><img src=\"myimages/back-button.gif\" border=0></a></center>";
//}


//else if($lrows > '0')
if($lrows > '0')
{
	//$ListingTable .= "<table align=center width=540 border=0 bordercolor=#336699  cellspacing=0>\n";
	//$ListingTable .= "<tr><td><br><font color=#404040><center><b>[$a1[CategoryName]] Click on a listing for more information...</b></center></font><br></td></tr>\n\t";

	while($a1 = mysql_fetch_array($r1))
	{
                if ($first_time == 'true')
                {
                      if ($class_name == '')
                      {
                      }
                      else
                      {
                              // CLASSIFICATION
                              //$first_time = 'false';
                              //$class_name = substr($class_name,0,44);
	                      $aset[SiteTitle] .= " - Business Classifications for: $region_name $class_name";
                              $aset[SiteDescription] .= " Business Classifications for: $region_name $class_name"; 
	                      $ListingTable .= "<table align=center width=525 border=0 bordercolor=#336699  cellspacing=0 cellpadding=0>\n";
	                      $ListingTable .= "<tr><td><font face=\"Arial\" color=#0000ff size=4><center><font color=#000000>Business Classifications for:</font> $region_name $class_name $display_cStart</font><br><font face=\"Arial\" color=#404040 size=2>Click on a classification for a list of businesses...</center></font><br></td></tr>\n\t";
                      }
	                //$ListingTable .= "<tr bgcolor=#ffffff><td height=10></td</tr>\n\t";
	                $ListingTable .= "<tr><td><img src=\"myimages/rounded-rec-search-2B.gif\" height=20 width=525></td></tr>\n\t";
                }
                
		$ListingTable .= "<tr onMouseOver=\"this.style.background='#ddffff'; this.style.cursor='hand' \" onMouseOut=\"this.style.background='#ffffff'\" onClick=\"this.style.cursor='wait'; window.open('search.php?classif=$a1[ClassID]&search_region=$Region', '_top')\" bgcolor=#ffffff>\n\t";
		$ListingTable .= "<td>";

		$ListingTable .= "<table align=center width=525 border=0 cellspacing=0 cellpadding=0>\n";
                
                if ($first_row == "Y")
                {
                        $first_row = "N";
	                //$ListingTable .= "<tr bxcolor=#ffffff border=0 rowspacing=0 rowpadding=0 background=\"myimages/rounded-rec-search-2B.gif\"><td height=20><img src=\"myimages/rounded-rec-search-2B.gif\" height=20 width=525></td></tr>\n\t";
                }
                
                // Listing Row
		$ListingTable .= "<tr>\n\t<td width=1 bgcolor=#cccccc></td><td width=8></td>";
                
        
                
		        $ListingTable .= "<td width=320 valign=top>";
		        $ListingTable .= "<br><font color=#404040><a class=BlueLink5 href=\"search.php?classif=$a1[ClassID]&search_region=$Region\"><b>$class_name</b></a></font><br>";
                        $ListingTable .= "<br></td>\n\t\n";
                        
                
                $ListingTable .= "<td width=1 bgcolor=#cccccc></td>\n\t</tr>\n";
                



                $ListingTable .= "</table>\n\n</td>\n</tr>\n\n";
                
                $first_time = 'false';

	}
                
        
	$ListingTable .= "<td><img src=\"myimages/rounded-rec-search-4B.gif\" height=20 width=525></td></tr>\n\t";
	                
                        









        //$ListingTable .= "<td height=20><img src=\"myimages/rounded-rec-search-2B.gif\" height=20 width=525><br></td>\n\t";

		$rnav = mysql_query($qnav) or die(mysql_error());
		$rows = mysql_num_rows($rnav);
                
                        if ($rows > 100)
                        {
                                // Limit the number of rows the user can request for any query.
                                $rows = 100;
                        }

			if($rows > $ByPage)
			{
                                // Fix for last cell / paging problem 
				//$ListingTable .=  "<br><table align=center width=570>";
				
                                //$ListingTable .=  "<td height=10></td></tr><tr><br>";
				
                                //$ListingTable .= "<td align=center bgcolor=#e0e0e0><font face=verdana size=2 color=#404040><br>Additional pages...<br> |  ";
                                $ListingTable .= "<td align=center bgcolor=#ffffcc><font face=verdana size=2 color=#404040><br>Additional pages...<br> |  ";

				$pages = ceil($rows/$ByPage);

				for($i = 0; $i <= ($pages); $i++)
				{
					$PageStart = $ByPage*$i;
	
					$i2 = $i + 1;
	
					if($PageStart == $Start)
					{
						$links[] = " <span class=RedLink>$i2</span>\n\t ";
					}
					elseif($PageStart < $rows)
					{
						$links[] = " <a onClick=\"this.style.cursor='wait';\" class=Blue2Link href=\"searchclassif.php?Start=$PageStart&alpha_search=$cPageStart&search_region=$_GET[search_region]\">$i2</a>\n\t ";
					}
				}

				$links2 = implode(" | ", $links);
		
				$ListingTable .= $links2;

				$ListingTable .= " | </td>";

        //--------------------- Alphabetic Search ---------------------------------------------------

				$ListingTable .=  "<td height=10></td></tr><tr><br>";
				

                                //if ($rows > $ByPage)
                                //{
                                        $ListingTable .= "<td align=center bgcolor=#ffffcc><font face=verdana size=1 color=#404040><br><font size=2>Or, select from <b>Classifications</b> alphabetically...</font><br> |  ";

				        //$pages = ceil($rows/$ByPage);
				        for($i = 0; $i <= 26; $i++)
				        {
					        $cPageStart = $alphabet[$i];
	
					        $c2 = $alphabet[$i];
	
					        if($cPageStart == $cStart)
					        {
						        $clinks[] = " <span class=Red3Link>$c2</span>\n\t ";
					        }
					        else
					        {
						        $clinks[] = " <a onClick=\"this.style.cursor='wait';\" class=Blue3Link href=\"searchclassif.php?Start=0&alpha_search=$cPageStart&search_region=$_GET[search_region]\">$c2</a>\n\t ";
					        }
				        }

				        $clinks2 = implode(" | ", $clinks);
		
				        $ListingTable .= $clinks2;

				        $ListingTable .= "<br><br></td>";
                                
                                //}
        
        //-------------------------------------------------------------------------------------------

                                // Fix for last cell / paging problem 
				//$ListingTable .= "</table><br>\n";

			}
                        else
                        {
				$ListingTable .=  "<td height=10></td></tr><tr><br>";
				
                                //$ListingTable .= "<td align=center bgcolor=#e0e0e0><font face=verdana size=1 color=#404040><br><font size=2>Select from <b>search results</b> alphabetically... ($rows)</font><br> |  ";
                                $ListingTable .= "<td align=center bgcolor=#ffffcc><font face=verdana size=1 color=#404040><br><font size=2>End of Search Results</font><br><br>";
                                
                                $ListingTable .= "<center><a href=\"javascript:history.go(-1)\"><img src=\"myimages/back-button.gif\" border=0></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"alaska-yellow-pages-search.html\"><img src=\"myimages/button-search-agin.gif\" border=0></a></center> ";
				
                                //--- begin alpha select

                                if ($rows > $ByPage)
                                {
                                        for($i = 0; $i <= 26; $i++)
				        {
					        $cPageStart = $alphabet[$i];
	                        
					        $c2 = $alphabet[$i];
	                        
					        if($cPageStart == $cStart)
					        {
						        $clinks[] = " <span class=Red3Link>$c2</span>\n\t ";
					        }
					        else
					        {
						        //$clinks[] = " <a onClick=\"this.style.cursor='wait';\" class=Blue3Link href=\"search.php?Start=0&alpha_search=$cPageStart&c=$_GET[c]&search_city=$_GET[search_city]&search_state=$_GET[search_state]&search_country=$_GET[search_country]&search_kw=$_GET[search_kw]&search_phonenbr=$_GET[search_phonenbr]&search_staddress=$_GET[search_staddress]&search_zipcode=$_GET[search_zipcode]&classif=$_GET[classif]&search_region=$_GET[search_region]\">$c2</a>\n\t ";
						        $clinks[] = " <a onClick=\"this.style.cursor='wait';\" class=Blue3Link href=\"searchclassif.php?Start=0&alpha_search=$cPageStart&search_region=$_GET[search_region]\">$c2</a>\n\t ";
					        }
				        }
                                
				        $clinks2 = implode(" | ", $clinks);
		                
				        $ListingTable .= "<br><font size=2>Or, select from <b>search results</b> alphabetically...</font><br>";
				        $ListingTable .= $clinks2;
                                }
                                //--- end alpha select
				
                                $ListingTable .= "<br><br></td>";
                        }
}
else
{
	$ListingTable = "<br><br><br><br><font face=\"Arial\" size=4 color=#ff0000><center>Sorry, no results for this search.<br> $region_name $class_name $category $search_keyword $Street $City $ZipCode $Phone $display_cStart</b></font></center><br><br>Sugestions:<br><br>- Check your spelling<br>- Try more general words<br>- Try different words that mean the same thing<br>- Broaden your search by using fewer words<br>- Try a general <a href=\"us-411-yellow-pages-search.html\">United States Search</a><br><br><br><a href=\"javascript:history.go(-1)\"><img src=\"myimages/back-button.gif\" border=0></a></center>";
}

mysql_free_result($r1);

require_once("templates/HeaderTemplate.php");
require_once("templates/SearchTemplate.php");	
require_once("templates/FooterTemplate.php");


//include ("end_caching.php"); 
// Now the script has run, generate a new cache file
$fp = @fopen($cachefile, 'w');

// save the contents of output buffer to the file
@fwrite($fp, ob_get_contents());
@fclose($fp);

ob_end_flush();
?>