<?
/**
* Programmer    : Nitin
* Module 	: Database Connection
* File Name : DBConnection.php
* Description : Database Connection Class
* Versions 	: PHP5, Apache 2.0 
* Last Modified : 23/08/2006
*/

class DBConnection {    

	var $connection, $statement, $dbQuery, $dbResult;

	// ///////////////////////////////////////////////////// //
	// PHP and MySQL Connection and Error Specific methods
	// ///////////////////////////////////////////////////// //
    
	function DBConnection()
	{
		//try {
			$dbUsername = MYSQL_DB_USER;
			$dbPassword = MYSQL_DB_PWD;
			$dbServer = MYSQL_DB_SERVER;
			$dbName = MYSQL_DB_NAME;

			// Use mysqli_connect instead of deprecated mysql_connect
			$connection = mysqli_connect($dbServer, $dbUsername, $dbPassword, $dbName);

			if(!$connection) {
			    $this->saveIntoErrorLog("DBConnection.php", "DBConnection()", "mysqli_connect()", mysqli_connect_error());
			    return false;
			}

			// Set charset for the connection
			mysqli_set_charset($connection, 'utf8');

			$this->connection = $connection;
			$this->statement = true; // With mysqli_connect, database is selected automatically

			return true;

		/*} catch (Exception $e) {

			$this->saveIntoErrorLog("DBConnection.php", "DBConnection()", "", $e);
			return false;

		}*/
	}

	function CloseConnection()
	{
		//try {
			$close = mysqli_close($this->connection);

			if(!$close) {
			    $this->saveIntoErrorLog("DBConnection.php", "CloseConnection()", "mysqli_close()");
			}
			return true;

		/*} catch (Exception $e) {

			$this->saveIntoErrorLog("DBConnection.php", "CloseConnection()", "", $e);
			return false;

		}*/
	}

	/**	
	* Execute query for select
	*/    
	function SelectQuery($fileName="", $methodName="")
	{
		//try {
			if($this->connection && $this->statement) 
			{
				if(empty($this->dbQuery)) { return false; }

				$this->dbResult = mysql_query($this->dbQuery, $this->connection);
				if(!$this->dbResult) {
					$this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery);
					return false;
				}

				$rowCount = 0;
				$resultData = array();
				while($rowData = mysql_fetch_array($this->dbResult, MYSQL_ASSOC)) {
				    $resultData[$rowCount] = $rowData;
				    $rowCount++;
				}

				mysql_free_result($this->dbResult);
				return $resultData;

			} else {
				return false;
			}

		/*} catch (Exception $e) {

			$this->saveIntoErrorLog($fileName, $methodName, "", $e);
			return false;

		}*/
	}

	/**	
	* Execute query for Insert
	*/    
	function InsertQuery($fileName="", $methodName="")
	{
		//try {
			if($this->connection && $this->statement) 
			{
				if(empty($this->dbQuery)) { return false; }

				$this->dbResult = mysql_query($this->dbQuery, $this->connection);
				if(!$this->dbResult) {
					$this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery);
					return false;
				}

				$id = mysql_insert_id();

				mysql_free_result($this->dbResult);
				return $id;

			} else {
				return false;
			}

		/*} catch (Exception $e) {

			$this->saveIntoErrorLog($fileName, $methodName, "", $e);
			return false;

		}*/
	}

	/**	
	* Execute query for Update/Delete
	*/    
	function ExecuteQuery($fileName="", $methodName="")
	{
		//try {
			if($this->connection && $this->statement) 
			{
		if(empty($this->dbQuery)) { return false; }

		$this->dbResult = mysqli_query($this->connection, $this->dbQuery);
		if(!$this->dbResult) {
			$this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery);
			return false;
		}

		$rows = 0;
		$rows = mysqli_affected_rows($this->connection);
		mysqli_free_result($this->dbResult);
		return $rows;			} else {
				return false;
			}

		/*} catch (Exception $e) {

			$this->saveIntoErrorLog($fileName, $methodName, "", $e);
			return false;

		}*/
	}
	
	
	/**	
	* Execute queries for webservice
	*/    
	function SelectQueryResult($fileName="", $methodName="")
	{
		//try {
			if($this->connection && $this->statement) 
			{
				if(empty($this->dbQuery)) { return false; }

				$this->dbResult = mysql_query($this->dbQuery, $this->connection);
				if(!$this->dbResult) {
					$this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery);
					return false;
				}

				$resultData = $this->dbResult;

				//mysql_free_result($this->dbResult);
				return $resultData;

			} else {
				return false;
			}

		/*} catch (Exception $e) {

			$this->saveIntoErrorLog($fileName, $methodName, "", $e);
			return false;

		}*/
	}
	

	/**
	* Use this method to log the database errors.
	*/				 
	function saveIntoErrorLog($fileName="", $methodName="", $sqlQuery="", $exception="")
	{
		$errorCode = mysql_errno();
		$errorText = mysql_error();

		$errorMessage = "File: ".$fileName.", Method/Function: ".$methodName.", Query: ".$sqlQuery.", Error: ".$errorCode."-".$errorText;
		if($exception != "")
			$errorMessage.= " Exception : ".$exception ;

		// timestamp for the error entry
		$errorMessage = "[".date("j-M-Y H:i:s (T)")."] ".$errorMessage."\r\n";

		// save to the error log
		error_log($errorMessage, 3, ERROR_LOG."ErrorLog".date("j-M-Y").".log");
	} 

} //ends the class over here
?>
SELECT t1.est_id, t1.icon, t1.est_name, t1.est_street, t1.est_city, t1.est_state, t1.est_zip, t1.est_phone, t1.accnt_type, t1.percentoffcard, t3.ent_type, t4.cuisine_type FROM est_overview AS t1, type_of_entertain as t3, type_of_cuisine as t4 WHERE t1.publish = 'Y'  AND t1.est_id = t3.est_id AND t3.ent_type = 'Jukebox ' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'Pizza' AND substring(t1.est_name,1,1) = 'e' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
    <meta name="description" content="">
    <meta name="author" content="">
    <link rel="icon" type="image/x-icon" href="/img/favicon.ico" />

	
    <title>Pizza Food Jukebox  in the Twin Cities | Twincitiesfun.com</title>

    <!-- Bootstrap core CSS -->
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css" integrity="sha512-dTfge/zgoMYpP7QbHy4gWMEGsbsdZeCXz7irItjcC3sPUFtf0kuFbDz/ixG7ArTxmDjLXDmezHubeNikyKGVyQ==" crossorigin="anonymous">

	<!-- custom style -->
	<link rel="stylesheet" href="custom_style.css?v=1">

    <!-- Custom styles for this template -->
    <link href="/sticky-footer-navbar.css" rel="stylesheet">


    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
      <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
  </head>
  

  <body>
<?
	if($show_nav!==false) {
		require 'nav.php';
	}
?>
<br/><br/><br/><br/>
  <!--
	<div class="container-fluid" style="padding-top:60px">
		<div class="row">
			<div class="col-xs-12 text-center hidden-xs">
				<a href="http://www.discountpartybusmn.com" target="_blank">
					<img src="/img/DPB728x90.jpg" style='max-width:100%;'>
				</a>
			</div>
			<div class="col-xs-12 text-center visible-xs">
				<a href="http://www.discountpartybusmn.com" target="_blank">
					<img src="/images/discount_party_bus_logo_only.jpg" style='max-width:100%;'>
				</a>
			</div>
		
		</div>
	</div>
	-->

	
	<!-- Begin page content -->
    <div class="container-fluid" style="padding-top:10px;">
    	<div class="row">
    		<div class='col-xs-12'>
    			<div >
	<!-- Pagetitle -->
	<h1 class="pagetitle" align="center">Pizza Food Jukebox  in the Twin Cities</h1>

		
	<div class='visible-xs text-center' style='padding-top:15px;padding-bottom:15px;'>
		1 Result, Scroll down to view
	</div>
	<div class='hidden-xs'>
	<div align="center" style="margin-top:4px;margin-bottom:4px;"></div>	</div>	
</div>			</div>
		</div>
		
    	<div class="row">
			<div class="col-sm-3 col-xs-12">
				
		
		<style>
			.interactive_search h2 {
				font-size: 14px;
				background-color: white;
				border: 1px solid gray;
				padding: 5px;
			}
			.interactive_search h2 a {
				float:right;
			}
		</style>
	
		<div class="panel panel-default">
			<div class="panel-heading">
				<div class="panel-title">Search Options</div>
			</div>
			<div class="panel-body">
			
				<form id="search" class="search" action="search.php" method="get">
					<div id="accordion" class="guide-grid2">
					  					  <div class='interactive_search '>
						<h3>Current Search: <a style="font-size:0.9em; padding-left:15px;" href="search.php" rel="nofollow" title="Clear All Search Values">Clear</a></h3>
												<h2><a class="selected" rel="nofollow" href="/search.php?ent_type=Jukebox+&ltr=e " title="Remove Pizza from guided search">X</a>Pizza						  <input type="hidden" name="cuisine_type" value="Pizza" />
						</h2>
												<h2><a class="selected" rel="nofollow" href="/search.php?cuisine_type=Pizza&ltr=e " title="Remove Jukebox  from guided search">X</a>Jukebox 						  <input type="hidden" name="ent_type" value="Jukebox " />
						</h2>
											  </div>
					  
					  				<div class='visible-xs'>
					<button type="button" class="btn btn-primary btn-block" onclick="$('#narrow_search').removeClass('hidden-xs');$(this).hide();">Add More Filters</button>
				</div>
				  <div class='hidden-xs' id='narrow_search'>
				  	<h3>Narrow Search By:</h3>
					<div class="panel-group" id="accordion" role="tablist" aria-multiselectable="true">


																				<div class="panel panel-default" >
								<div class="panel-heading " role="tab" id="headingOne" data-toggle="collapse" data-target="#collapseOne" >
									<h4 class="panel-title">
										<a role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
										  Days: (0)
										</a>
									</h4>
								</div>
							</div>
							<div id="collapseOne" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingOne">
								<div class="panel-body">
																	</div>
							</div>
											
					
																				<div class="panel panel-default">
								<div class="panel-heading" role="tab" id="headingCities" data-toggle="collapse" data-target="#collapseCities" >
									<h4 class="panel-title">
										<a role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseCities" aria-expanded="true" aria-controls="collapseCities">
										  Cities: (1)
										</a>
									</h4>
								</div>
							</div>
							<div id="collapseCities" class="panel-collapse collapse " role="tabpanel" aria-labelledby="headingCities">
								<div class="panel-body">
																			<ul class="accordion_content">
																							<li><a href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&est_city=Ramsey" rel="nofollow">Ramsey</a> <span class="count">(1)</span></li>
																					</ul>
																	</div>
							</div>
													
				  
																				<div class="panel panel-default">
								<div class="panel-heading" role="tab" id="headingEstTypes" data-toggle="collapse" data-target="#collapseEstTypes" >
									<h4 class="panel-title">
										<a role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseEstTypes" aria-expanded="true" aria-controls="collapseEstTypes">
										  Places to Go: (7)
										</a>
									</h4>
								</div>
							</div>
							<div id="collapseEstTypes" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingEstTypes">
								<div class="panel-body">
																			<ul class="accordion_content">
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&est_type=Bars%2FNightclubs">Bars/Nightclubs</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&est_type=Outdoor%2FPatio">Outdoor/Patio</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&est_type=Reservations+Accepted">Reservations Accepted</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&est_type=Restaurants">Restaurants</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&est_type=Sports+Bars">Sports Bars</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&est_type=Take+Out">Take Out</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&est_type=WiFi+Hotspots">WiFi Hotspots</a> <span class="count">(1)</span></li>
																					</ul>
																	</div>
							</div>
										  
				  
																				<div class="panel panel-default">
								<div class="panel-heading" role="tab" id="headingEventTypes" data-toggle="collapse" data-target="#collapseEventTypes" >
									<h4 class="panel-title">
										<a role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseEventTypes" aria-expanded="true" aria-controls="collapseEventTypes">
										  Things to Do: (0)
										</a>
									</h4>
								</div>
							</div>
							<div id="collapseEventTypes" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingEventTypes">
								<div class="panel-body">
																			<li>Searching All</li>
																	</div>
							</div>
										  
					
																				<div class="panel panel-default">
								<div class="panel-heading" role="tab" id="headingMusic" data-toggle="collapse" data-target="#collapseMusic" >
									<h4 class="panel-title">
										<a role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseMusic" aria-expanded="true" aria-controls="collapseMusic">
										  Music: (10)
										</a>
									</h4>
								</div>
							</div>
							<div id="collapseMusic" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingMusic">
								<div class="panel-body">
																			<ul class="accordion_content">
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&music_type=80%27s">80's</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&music_type=Acoustic">Acoustic</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&music_type=Country">Country</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&music_type=DJ">DJ</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&music_type=House">House</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&music_type=Jukebox">Jukebox</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&music_type=Live+Music">Live Music</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&music_type=Oldies">Oldies</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&music_type=Rock">Rock</a> <span class="count">(1)</span></li>
																							<li><a class="add" rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&music_type=Top+40">Top 40</a> <span class="count">(1)</span></li>
																					</ul>
																	</div>
							</div>
											
					
					  </div>
				  </div>
				  
				  
					</div>
																			  </form>
			
			
			</div>
		</div>
	
	
			</div>
			<div class="col-sm-6  col-xs-12">
				<div>
	<div class="pull-left">
		<a href="/map.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e" class="lightwindow" params="lightwindow_type=external" title="Show Results on a Larger Map" caption="TwinCitiesFun.com | What are you doing for fun tonight?" rel="nofollow">+More Map</a>
	</div>
	<div class="pull-right">
		<strong>Sort:</strong>
		<strong>Featured</strong>		|
					<a href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&order=est_name" rel="nofollow">Name</a>
				|
					<a href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e&order=est_city" rel="nofollow">City</a>
			</div>
</div>
<div class='clearfix'></div>

	<div style="border-top:1px solid gray; margin-bottom: 1em;">

	<table border="0" width="100%">
		<tr align="center">
		<td width="10%"></td>
		<td width="20%"></td>
		<td width="42%">1 - 1 of 1 Result</td>
		<td width="18%" align="right"></td>
		<td width="10%" align="right"></td>
		</tr>
	</table>
	
	
	<table border="0" align="center" width="100%" class='hidden-xs'>
		<tr>
		<td colspan="5">
						<table width="100%">
			<tr>
				<td><font color="#BED3E9">A</font></td><td><font color="#BED3E9">B</font></td><td><font color="#BED3E9">C</font></td><td><font color="#BED3E9">D</font></td><td><a rel="nofollow" href="/search.php?cuisine_type=Pizza&ent_type=Jukebox+">E</a></td><td><font color="#BED3E9">F</font></td><td><font color="#BED3E9">G</font></td><td><font color="#BED3E9">H</font></td><td><font color="#BED3E9">I</font></td><td><font color="#BED3E9">J</font></td><td><font color="#BED3E9">K</font></td><td><font color="#BED3E9">L</font></td><td><font color="#BED3E9">M</font></td><td><font color="#BED3E9">N</font></td><td><font color="#BED3E9">O</font></td><td><font color="#BED3E9">P</font></td><td><font color="#BED3E9">Q</font></td><td><font color="#BED3E9">R</font></td><td><font color="#BED3E9">S</font></td><td><font color="#BED3E9">T</font></td><td><font color="#BED3E9">U</font></td><td><font color="#BED3E9">V</font></td><td><font color="#BED3E9">W</font></td><td><font color="#BED3E9">X</font></td><td><font color="#BED3E9">Y</font></td><td><font color="#BED3E9">Z</font></td>			</tr>
			</table>
		</td>
		</tr>
	</table>
</div>
<!-- search_results_panel.inc.php -->
                <!--
        --------- [Name]				[Discount]
        |       | [Address]
        |       | [Phone]
        ---------
        [Extra Details]
        [Extra Details]
        [Extra Details]
        -->
        <div class='result_row'>
        	
        				
			<h1>
				<a href="End-Zone-Bar-and-Grill-ID003659.html"> End Zone Bar & Grill</a>
			</h1> 
			<div>
				Closed Ramsey, MN 55303			</div>
			<h5 class="phone_num">763-433-2615</h5>
			
			<div>
				<p class="category"><font style="font-size:1.4em;">Cuisine:</font>
American&nbsp;
<font class="active">Pizza</font>&nbsp;
Soup&nbsp;
Steaks&nbsp;
Subs&nbsp;
Vegetarian&nbsp;
  
</p><div class='clearfix'></div><p class="category"><font style="font-size:1.4em;">Amenities</font>
Arcade Games&nbsp;
Bar Bingo&nbsp;
Big Screen TV&nbsp;
Birthday Parties&nbsp;
College Football&nbsp;
Darts&nbsp;
DTV&nbsp;
Family Friendly&nbsp;
Featured Hotspots&nbsp;
Happy Hour&nbsp;
Jukebox&nbsp;
Ladies Night&nbsp;
Live Music&nbsp;
Outdoor/Patio&nbsp;
Progressive Bingo&nbsp;
Pull tabs&nbsp;
Texas Hold'em&nbsp;
Wi-Fi&nbsp;
  
</p><div class='clearfix'></div>			</div>


			<!-- rewards -->
			

			<!-- perks -->
			
		</div>
		
		<div style='padding:5px;'></div>
		
		<div class='clearfix'></div>
        
<br />

<table border="0" width="100%">
	<tr align="center">
	<td width="10%"></td>
	<td width="20%"></td>
	<td width="42%">1 - 1 of 1 Results</td>
	<td width="18%" align="right"></td>
	<td width="10%" align="right"></td>
	</tr>
</table>
        
<span style="font-size:.8em; text-align:center;">*All information is deemed reliable, but unfortunatly cannot not be guaranteed. Events & prices are subject to change.</span>      

<script src="http://maps.google.com/maps?file=api&amp;v=2&amp;key=ABQIAAAARBtqJXNcoDBs6A5q29y9ZhTpwR4x7bvj0Vv_3X93adJvnbfs0BRVQgm5A5jBXyigxiFps25LHSHz_w" type="text/javascript"></script>
<script type="text/javascript">
//<![CDATA[

var iconBlue = new GIcon(); 
iconBlue.image = 'http://www.twincitiesfun.com/img/mm_20_blue.png';
iconBlue.shadow = 'http://www.twincitiesfun.com/img/mm_20_shadow.png';
iconBlue.iconSize = new GSize(12, 20);
iconBlue.shadowSize = new GSize(22, 20);
iconBlue.iconAnchor = new GPoint(6, 20);
iconBlue.infoWindowAnchor = new GPoint(5, 1);

var iconRed = new GIcon(); 
iconRed.image = 'http://www.twincitiesfun.com/img/mm_20_red.png';
iconRed.shadow = 'http://www.twincitiesfun.com/img/mm_20_shadow.png';
iconRed.iconSize = new GSize(12, 20);
iconRed.shadowSize = new GSize(22, 20);
iconRed.iconAnchor = new GPoint(6, 20);
iconRed.infoWindowAnchor = new GPoint(5, 1);

var customIcons = [];
customIcons["B"] = iconBlue;
customIcons["P"] = iconRed;
	// ===== Start with an empty GLatLngBounds object =====     
	var bounds = new GLatLngBounds();

function load() {
	if (GBrowserIsCompatible()) {
	var map = new GMap2(document.getElementById("map"));
	map.addControl(new GSmallMapControl());
	map.setCenter(new GLatLng(0, 0), 10);

	GDownloadUrl("includes/gmap_search_xml.php?cuisine_type=Pizza&ent_type=Jukebox+&ltr=e", function(data) {
		var xml = GXml.parse(data);
		var markers = xml.documentElement.getElementsByTagName("marker");
		for (var i = 0; i < markers.length; i++) {
		var name = markers[i].getAttribute("name");
		var url = markers[i].getAttribute("url");
		var id = markers[i].getAttribute("id");
		var icon = markers[i].getAttribute("icon");
		var street = markers[i].getAttribute("street");
		var city = markers[i].getAttribute("city");
		var state = markers[i].getAttribute("state");
		var zip = markers[i].getAttribute("zip");
		var phone = markers[i].getAttribute("phone");
		var rewards = markers[i].getAttribute("rewards");
		var perks = markers[i].getAttribute("perks");
		var type = markers[i].getAttribute("type");
		var point = new GLatLng(parseFloat(markers[i].getAttribute("lat")),
								parseFloat(markers[i].getAttribute("lng")));
		var marker = createMarker(point, name, url, id, icon, street, city, state, zip, phone, rewards, perks, type);
		map.addOverlay(marker);
		
		bounds.extend(point);
		}
				// ===== determine the zoom level from the bounds =====
		map.setZoom(map.getBoundsZoomLevel(bounds));

		// ===== determine the centre from the bounds ======
		map.setCenter(bounds.getCenter());
	});
	}
}	

function createMarker(point, name, url, id, icon, street, city, state, zip, phone, rewards, perks, type) {
	var marker = new GMarker(point, customIcons['P']);
	if(type == "P") {
	var img = "<img class='center' src=" + icon + ">";} 
	else { var img = "";}
	var html =  img + "<div style='text-align:center' height='100px'><a href='" + url + "'><b>" + name + "</b></a> <br/>" + street + "<br/>" + city + ", " + state + " " + zip + "<br/>" + phone + "<h2>" + rewards + " </h2><h2>" + perks + " </h2><br></div>";
	GEvent.addListener(marker, 'click', function() {
	marker.openInfoWindowHtml(html);
	});
	return marker;
}
//]]>
</script>
  

<div class='hidden-xs'>
	<div align="center" style="margin-top:4px;margin-bottom:4px;"></div></div>			</div>
			<div class="col-sm-3 col-xs-12">
				
	
			<div class="panel panel-default">
			<div class="panel-heading">
				<div class="panel-title">Popular Searches</div>
			</div>
			<div class="panel-body">
				<p><a href="search.php?dotw=all&event_type=Happy+Hour&est_city=Minneapolis">Minneapolis Happy Hour</a></p>
				<p><a href="search.php?est_city=Minneapolis&est_type=Restaurants">Minneapolis Restaurants</a></p>
				<p><a href="search.php?est_city=St.+Paul&event_type=Lunch+Specials">Lunch Specials at Restaurants in St. Paul</a></p>
				<p><a href="search.php?est_type=Bars/Nightclubs&ent_type=Indoor+Sports">Bars/Nightclubs with Indoor Sports</a></p>
				<p><a href="search.php?est_city=Minneapolis&event_type=Drink+Specials">Drink Specials in Mpls</a></p>
			</div>
		</div>
	
	
			<div class="panel panel-default">
			<div class="panel-body">
				<div align="center" style="margin-top:4px;margin-bottom:4px;"></div>			</div>
		</div>
	
	
			</div>
		</div>
	</div>

<?
// Initialize footer content display variable if not set
if (!isset($show_footer_content)) {
    $show_footer_content = true; // Default to showing footer content
}
// Initialize validator JS requirement variable if not set
if (!isset($require_validator_js)) {
    $require_validator_js = false; // Default to not requiring validator JS
}
?>
    <footer class="footer">
      <div class="container">
      	<p class="text-muted">
      		<!-- 
			<div class='pull-right'>
				<a href="/sitemap.xml">Sitemap</a>
			</div>
			-->
			 <!-- pull-left -->
			Copyright 2025 TwinCitiesFun.com.
			
		</p>
      	
      	
      	<!--
      	<p class="text-muted">
			<div class='pull-right'>
				<a href="/sitemap.xml">Sitemap</a>
			</div>
			<div class='pull-right'>
				<a href="/sitemap.xml">Sitemap</a>
			</div>
			<div class='pull-right'>
				<a href="/sitemap.xml">Sitemap</a>
			</div>
			<div class='pull-left'>
				Copyright 2025 TwinCitiesFun.com.
			</div>
		</p>
		-->
      </div>
      
    </footer>

    <!-- Bootstrap core JavaScript
    ================================================== -->
    <!-- Placed at the end of the document so the pages load faster -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js" integrity="sha512-K1qjQ+NcF2TYO/eI3M6v8EiNYZfA95pQumfvcVrTHtwQVDG+aHRqLi/ETn2uB+1JqwYqVG3LIvdm9lj6imS/pQ==" crossorigin="anonymous"></script>
	
    <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
    <script src="/ie10-viewport-bug-workaround.js"></script>
    
    
<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-77Z6KG7R2Y"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'G-77Z6KG7R2Y');
</script>
  </body>
</html>