"); $sql = "SELECT * FROM lodges WHERE `council_number`='" . $_GET['lodge'] . "' "; if ($result=mysql_query($sql)) { if ($lodge=mysql_fetch_array($result)) { echo "

" . $lodge["lodge_name"] . " Lodge

" . $lodge["council_name"] . " Council (#" . $lodge["council_number"] . ")

"; if( file_exists("/home/western/public_html/images/lodges/flaps/" . $lodge["council_number"] . ".gif")) echo ""; else echo ""; echo "

Back to Section W-" . $lodge["area_number"] . $lodge["section_name"] . " Map

"; echo "
"; // Website echo "

Website:

"; // Section echo "

Section:

"; // Location echo "

Location:

    "; echo "
  • " . $lodge["location"] . "
  • "; echo "
"; // Headquarters echo "

Headquarters:

    "; echo "
  • " . $lodge["council_city"] . ", " . $lodge["council_state"] . "
  • "; echo "
"; // Leaderships echo "

Leadership:

    "; $sql = "SELECT * FROM positions, members LEFT JOIN joomla_contact_details contact ON contact.id=members.contact_id WHERE members.id=positions.member_id AND `org`='" . $lodge["council_number"] . "' AND `position`='Lodge Chief' "; if ($result=mysql_query($sql)) { while ($member=mysql_fetch_array($result)) { echo "
  • Chief: " . $member["firstname"] . " " . $member["lastname"] . "
  • "; } } else die("Database Error: $sql"); $sql = "SELECT * FROM positions, members LEFT JOIN joomla_contact_details contact ON contact.id=members.contact_id WHERE members.id=positions.member_id AND `org`='" . $lodge["council_number"] . "' AND `position`='Lodge Adviser' "; if ($result=mysql_query($sql)) { while ($member=mysql_fetch_array($result)) { echo "
  • Adviser: " . $member["firstname"] . " " . $member["lastname"] . "
  • "; } } else die("Database Error: $sql"); $sql = "SELECT * FROM positions, members LEFT JOIN joomla_contact_details contact ON contact.id=members.contact_id WHERE members.id=positions.member_id AND `org`='" . $lodge["council_number"] . "' AND `position`='Lodge Staff Adviser' "; if ($result=mysql_query($sql)) { while ($member=mysql_fetch_array($result)) { echo "
  • Staff Adviser: " . $member["firstname"] . " " . $member["lastname"] . "
  • "; } } else die("Database Error: $sql"); $sql = "SELECT * FROM positions, members LEFT JOIN joomla_contact_details contact ON contact.id=members.contact_id WHERE members.id=positions.member_id AND `org`='" . $lodge["council_number"] . "' AND `position`='Scout Executive' "; if ($result=mysql_query($sql)) { while ($member=mysql_fetch_array($result)) { echo "
  • Scout Executive: " . $member["firstname"] . " " . $member["lastname"] . "
  • "; } } else die("Database Error: $sql"); echo "
"; echo "

Corrections? Updates? Send them to Western Region Administration.
"; } } } else if(isset($_GET['section'])) { $area = $_GET['section'][2]; $section = $_GET['section'][3]; echo "

Section W-" . $area . $section . "


Back to Region Map

"; $db = mysql_connect($server, $user, $pass); mysql_select_db("western_joomla", $db) or die(mysql_errno() . ": " . mysql_error() . "
"); $sql = "SELECT * FROM sections WHERE `area`='$area' AND `section`='$section' "; // Website if ($result=mysql_query($sql)) { if ($sectionData=mysql_fetch_array($result)) { echo "

Website:

    "; if(is_null( $sectionData["sectionweb"] ) ) echo "
  • none
  • "; else echo "
  • " . $sectionData["sectionweb"] . "
    "; if(! is_null($sectionData["sectionfacebook"])) print "\"Facebook\"  "; if(! is_null($sectionData["sectiontwitter"])) print "\"Twitter\""; print "
  • "; } echo "

"; } else die("Database Error: $sql"); // Name if(! is_null($sectionData["sectionname"])) { echo "

Name:

    "; echo "
  • " . $sectionData["sectionname"] . "
  • "; echo "

"; } // Lodges: $sql = "SELECT * FROM lodges WHERE `area_number`='$area' AND `section_name`='$section' ORDER BY `lodge_name` "; if ($result=mysql_query($sql)) { echo "

Lodges:".nl2br(chr(10)); while ($lodge=mysql_fetch_array($result)) { if( file_exists("/home/western/public_html/images/sections/maps/key/" . $lodge["council_number"] . ".gif")) echo " "; echo "" . $lodge["lodge_name"] . "".nl2br(chr(10)); } echo nl2br(chr(10))."

"; } else die("Database Error: $sql"); // Section Officers echo "

Officers:

    "; // Section Chief $sql = "SELECT * FROM positions, members LEFT JOIN joomla_contact_details contact ON contact.id=members.contact_id WHERE members.id=positions.member_id AND org='".$_GET['section']."' AND `position`='Section Chief' "; if ($result=mysql_query($sql)) { while ($member=mysql_fetch_array($result)) { echo "
  • Chief: "; if ($member["contact_id"] > 0) print ""; print $member["firstname"]." ".$member["lastname"]; if ($member["contact_id"] > 0) print ""; echo "
  • "; } } else die("Database Error: $sql"); // Section Vice Chief $sql = "SELECT * FROM positions, members LEFT JOIN joomla_contact_details contact ON contact.id=members.contact_id WHERE members.id=positions.member_id AND org='".$_GET['section']."' AND `position`='Section Vice Chief' "; if ($result=mysql_query($sql)) { while ($member=mysql_fetch_array($result)) { echo "
  • Vice Chief: " . $member["firstname"] . " " . $member["lastname"] . "
  • "; } } else die("Database Error: $sql"); // Section Secretary $sql = "SELECT * FROM positions, members LEFT JOIN joomla_contact_details contact ON contact.id=members.contact_id WHERE members.id=positions.member_id AND org='".$_GET['section']."' AND `position`='Section Secretary' "; if ($result=mysql_query($sql)) { while ($member=mysql_fetch_array($result)) { echo "
  • Secretary: " . $member["firstname"] . " " . $member["lastname"] . "
  • "; } } else die("Database Error: $sql"); echo "

"; // Section Advisers echo "

Advisers:

    "; // Section Adviser $sql = "SELECT * FROM positions, members LEFT JOIN joomla_contact_details contact ON contact.id=members.contact_id WHERE members.id=positions.member_id AND org='".$_GET['section']."' AND `position`='Section Adviser' "; if ($result=mysql_query($sql)) { while ($member=mysql_fetch_array($result)) { echo "
  • Adviser: "; if ($member["contact_id"] > 0) print ""; print $member["firstname"]." ".$member["lastname"]; if ($member["contact_id"] > 0) print ""; echo "
  • "; } } else die("Database Error: $sql"); // Section Associate Advisers $sql = "SELECT * FROM positions, members LEFT JOIN joomla_contact_details contact ON contact.id=members.contact_id WHERE members.id=positions.member_id AND org='".$_GET['section']."' AND `position`='Section Associate Adviser' "; if ($result=mysql_query($sql)) { while ($member=mysql_fetch_array($result)) { echo "
  • Associate: " . $member["firstname"] . " " . $member["lastname"] . "
  • "; } } else die("Database Error: $sql"); // Section Staff Adviser $sql = "SELECT * FROM positions, members LEFT JOIN joomla_contact_details contact ON contact.id=members.contact_id WHERE members.id=positions.member_id AND org='".$_GET['section']."' AND `position`='Section Staff Adviser' "; if ($result=mysql_query($sql)) { while ($member=mysql_fetch_array($result)) { echo "
  • Staff Adv: " . $member["firstname"] . " " . $member["lastname"] . "
  • "; } } else die("Database Error: $sql"); echo "

"; echo "

Corrections? Updates? Send them to Western Region Administration.
"; } else if(isset($_GET['area'])) { $area=$_GET['area']; print "

Area " . $area . "


Back to Region Map

Sections:

"; if ($area==1) print "
  • Section W-1E
  • Section W-1N
  • Section W-1S
  • "; elseif ($area==2) print "
  • Section W-2N
  • Section W-2S
  • "; elseif ($area==3) print "
  • Section W-3N
  • Section W-3S
  • "; elseif ($area==4) print "
  • Section W-4N
  • Section W-4S
  • "; elseif ($area==5) print "
  • Section W-5N
  • Section W-5S
  • "; elseif ($area==6) print "
  • Section W-6E
  • Section W-6P
  • Section W-6W
  • "; print "
    "; } else { echo "
    \"\" Area 1".nl2br(chr(10))."   Section W-1E".nl2br(chr(10))."   Section W-1N".nl2br(chr(10))."   Section W-1S".nl2br(chr(10))." ".nl2br(chr(10))."Area 2".nl2br(chr(10))."   Section W-2N".nl2br(chr(10))."   Section W-2S".nl2br(chr(10))."   Section W-2W".nl2br(chr(10))." ".nl2br(chr(10))."Area 3".nl2br(chr(10))."   Section W-3N".nl2br(chr(10))."   Section W-3S".nl2br(chr(10))." ".nl2br(chr(10))."Area 4".nl2br(chr(10))."   Section W-4N".nl2br(chr(10))."   Section W-4S".nl2br(chr(10))." ".nl2br(chr(10))."Area 6".nl2br(chr(10))."   Section W-6E".nl2br(chr(10))."   Section W-6P".nl2br(chr(10))."   Section W-6W".nl2br(chr(10))."
    \"Section\"Section\"Section\"Section\"Section\"Section\"Section\"Section\"Section\"Section\"Section\"Section\"Section\"Section "; } ?> Section W-1NSection W-1NSection W-1SSection W-1ESection W-2WSection W-2NSection W-2SSection W-3NSection W-3SSection W-4NSection W-4SSection W-6PSection W-6WSection W-6E