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 ?>



Connecting to MySQL server: p3plzcpnl506558.prod.phx3.secureserver.net with user: twincitiesfun
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, t2.est_type, t3.ent_type FROM est_overview AS t1, type_of_est as t2, type_of_entertain as t3 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Mobile Video Game Entertainment Center ' AND t1.est_id = t3.est_id AND t3.ent_type = 'Featured Hotspots' AND substring(t1.est_name,1,1) = 'm ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30Query: 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, t2.est_type, t3.ent_type FROM est_overview AS t1, type_of_est as t2, type_of_entertain as t3 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Mobile Video Game Entertainment Center ' AND t1.est_id = t3.est_id AND t3.ent_type = 'Featured Hotspots' AND substring(t1.est_name,1,1) = 'm ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
Query: 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, t2.est_type, t3.ent_type FROM est_overview AS t1, type_of_est as t2, type_of_entertain as t3 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Mobile Video Game Entertainment Center ' AND t1.est_id = t3.est_id AND t3.ent_type = 'Featured Hotspots' AND substring(t1.est_name,1,1) = 'm ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC
Query: SELECT date_format(date2, '%Y-%c-%e') as ArticleDate FROM featured_events
Query: SELECT eo.est_id, est_name, est_city, icon FROM est_overview as eo, type_of_est as toe WHERE eo.est_id = toe.est_id AND toe.est_type = 'Restaurants' AND eo.accnt_type = 'P' AND publish = 'Y' ORDER BY RAND() LIMIT 3
Query: SELECT eo.est_id, title, `description`, est_name, est_city FROM perks as p, est_overview as eo WHERE eo.est_id = p.est_id AND eo.publish = 'Y' ORDER BY RAND() LIMIT 3
Query: SELECT est_type, count(*) AS Count FROM type_of_est as toe, est_overview as eo WHERE eo.est_id = toe.est_id AND eo.accnt_type = 'P' GROUP BY toe.est_type ORDER BY Count DESC LIMIT 8
Query: SELECT ent_type, count(*) AS Count FROM type_of_entertain as toe, est_overview as eo WHERE eo.est_id = toe.est_id AND eo.accnt_type = 'P' GROUP BY toe.ent_type ORDER BY Count DESC LIMIT 8
Query: SELECT cuisine_type, count(*) AS Count FROM type_of_cuisine as toc, est_overview as eo WHERE eo.est_id = toc.est_id AND eo.accnt_type = 'P' GROUP BY toc.cuisine_type ORDER BY Count DESC LIMIT 8
Query: SELECT music_type, count(*) AS Count FROM type_of_music as tom, est_overview as eo WHERE eo.est_id = tom.est_id AND eo.accnt_type = 'P' GROUP BY tom.music_type ORDER BY Count DESC LIMIT 8
Query: SELECT perks_type, count(*) AS Count FROM type_of_perks as top, est_overview as eo WHERE eo.est_id = top.est_id AND eo.accnt_type = 'P' GROUP BY top.perks_type ORDER BY Count DESC LIMIT 8
Query: SELECT est_city, count(*) AS Count FROM est_overview as eo WHERE eo.accnt_type = 'P' GROUP BY eo.est_city ORDER BY Count DESC LIMIT 8
Query: SELECT event_type, count(*) AS Count FROM daily_events as de, est_overview as eo WHERE eo.est_id = de.est_id GROUP BY de.event_type ORDER BY Count DESC LIMIT 9
Query: SELECT dotw, dotw_num, count(*) AS Count FROM daily_events as de, est_overview as eo WHERE eo.est_id = de.est_id GROUP BY de.dotw, de.dotw_num ORDER BY dotw_num ASC LIMIT 7
Mobile Video Game Entertainment Center with Featured Hotspots in the Twin Cities | Twincitiesfun.com



Mobile Video Game Entertainment Center with Featured Hotspots in the Twin Cities

1 Result, Scroll down to view
Search Options
+More Map
Sort: Featured | Name | City
1 - 1 of 1 Result
Query: SELECT title FROM perks WHERE est_id = '002185'

Mounds Park Sports Bar

1067 Hudson Rd St. Paul, MN 55106
651-340-0319
Query: SELECT * FROM gift_cards WHERE est_id = 2185 AND publish = '1'
Query: SELECT te.est_type FROM type_of_est as te WHERE te.est_id = '002185' ORDER BY est_type

Place to Go: 21+ Clubs  Bands  Bar Crawl  Bars/Nightclubs  Bingo service  Family Fun  Fun  Golf  Mobile Video Game Entertainment Center  Music Venue  Nightclub  Party Promoter  Receptions/Weddings  Reservations Accepted  Service  Social Club  Sports Bars  WiFi Hotspots  Wine Bar 

Query: SELECT te.ent_type FROM type_of_entertain as te WHERE te.est_id = '002185' ORDER BY ent_type

Amenities 22 50' Plasma TV's  Arcade Games  Bachelor/ette Party Specials  Bands  Bar Bingo  Baseball  Big Screen TV  Bingo  Birthday Parties  Bowling  Cards  College Sport Team Specials  Dancing  Dart Tournaments  Featured Hotspots  Free Computer access  Full-Service Bar  Gift Cards  GLBT Friendly  Happy Hour  Indoor Sports  Jukebox  Karaoke  Live Music  Meat Raffle  Meetings  NFL Sunday Ticket  Private Party   Progressive Bingo  Promotional Items  Pull tabs  Receptions/wedding  Reservations Accepted  Texas Hold'em  TV  Wi-Fi 


1 - 1 of 1 Results
*All information is deemed reliable, but unfortunatly cannot not be guaranteed. Events & prices are subject to change.
Popular Searches

Minneapolis Happy Hour

Minneapolis Restaurants

Lunch Specials at Restaurants in St. Paul

Bars/Nightclubs with Indoor Sports

Drink Specials in Mpls