<% require("../include_function.php"); %> <% require("/home/alderac/public_html/bountyhunters/members/dbconnect.php"); %>
<% $data = include_html("../include_menu.html",""); echo($data); %>
<% $data = include_html("../include_flash.html",""); echo($data); %>

Event Calendar

Tournaments
AEG Tournaments

Be sure to check out our Conventions page!

TO Feedback

Demonstration Calendar
Choose the area you wish to search for demonstrations


(Optional)

<% if (isset($submit)) { echo "

Results

"; //default search always includes country $searchterms="EventLocationCountry='$_POST[country]' AND EventDate >= curdate()"; //determine all games or a specific one if($_POST[event_game] != "0") { $searchterms=$searchterms . " AND EventFeatureGame='$_POST[event_game]'"; } //determine all states or a specific one if($_POST[state] != "0") { $searchterms=$searchterms . " AND EventLocationState='$_POST[state]'"; } //Testing searchterms by showing them //echo "$searchterms
"; $query="SELECT DATE_FORMAT(EventDate, '%b %d, %Y') AS demodate,EventID,EventFeatureGame,EventType,EventFormalName,EventLocationName,EventLocationCity,EventLocationState,EventLocationCountry,EventLocationStreetAddress,EventLocationZip,EventLocationPhone,EventLocationPhone FROM bheventlog WHERE $searchterms ORDER BY EventDate DESC"; //$query="SELECT * FROM events WHERE $searchterms"; $result=mysql_db_query($db, $query ,$connection) or die("Error in query."); //Output results in a table %> <% while($myrow = mysql_fetch_array($result)) { $demodate = $myrow["demodate"]; $location = $myrow["EventLocationName"]; $address = $myrow["EventLocationStreetAddress"]; $city = $myrow["EventLocationCity"]; $state = $myrow["EventLocationState"]; $country = $myrow["EventLocationCountry"]; $zip = $myrow["EventLocationZip"]; $phone = $myrow["EventLocationPhone"]; $email = $myrow["EventLocationEmail"]; $game = $myrow["EventFeatureGame"]; %> <% } %>
Date Location
<% echo $demodate; %>  <% echo $game; %>
<% echo $location; %>
<% echo $address; %>
<% echo "$city $state"; %>
<% echo "$country $zip"; %>
<% echo $phone; %>
<% if ($email && $email != "none") { %> Email: <% echo $email; %> <% } %>
<% // memory flush mysql_free_result($result); } %>

------------------------

<% $data = include_html("../include_footer.html",""); echo($data); %>