'; echo 'Welcome to Sugar Hill Roots'; echo ''; //// page content echo '
'; echo ''; global $admin_session; global $member_session; mysql_connect($authDBHost, $authDBUser, $authDBPasswd); if (isset($admin_session["admin_user_id"])) { $admin_user_query = "SELECT * FROM admin_user WHERE admin_user_id=" . $admin_session["admin_user_id"] . ";"; $admin_user_result = mysql_db_query($authDBName, $admin_user_query); while ($admin_user_row = mysql_fetch_array($admin_user_result)) { $admin_user_id = $admin_user_row["admin_user_id"]; $admin_user_firstname = $admin_user_row["admin_user_firstname"]; $admin_user_fullname = $admin_user_row["admin_user_fullname"]; $admin_user_level = $admin_user_row["admin_user_level"]; if ($admin_user_level == 3) { // partner, limited to certain artists $whichartist_query = "SELECT * FROM admin_user_artist WHERE admin_user_artist_user_id='$admin_user_id';"; $whichartist_result = mysql_db_query($authDBName, $whichartist_query); while ($whichartist_row = mysql_fetch_array($whichartist_result)) { $whichartist_artist_id = $whichartist_row["admin_user_artist_artist_id"]; $whichartist_array[] = $whichartist_artist_id; ////// we've created the array with this user's artists } } } echo ''; } elseif (isset($member_session["member_id"])) { /// grassroots member is logged in $member_query = "SELECT * FROM member WHERE member_id=" . $member_session["member_id"] . ";"; $member_result = mysql_db_query($authDBName, $member_query); while ($member_row = mysql_fetch_array($member_result)) { $member_id = $member_row["member_id"]; $member_firstname = $member_row["member_firstname"]; $member_fullname = $member_row["member_fullname"]; $whichartist_query = "SELECT * FROM member_artist WHERE member_artist_member_id='$member_id';"; $whichartist_result = mysql_db_query($authDBName, $whichartist_query); while ($whichartist_row = mysql_fetch_array($whichartist_result)) { $whichartist_artist_id = $whichartist_row["member_artist_artist_id"]; $whichartist_array[] = $whichartist_artist_id; ////// we've created the array with this user's artists } } echo ''; } else { // not logged in. display login link echo ''; } echo '
'; if ($admin_user_level == 3) { /// limit the links to this user's artists (DOES NOT WORK CORRECTLY YET) foreach($whichartist_array as $this_artist_id) { $this_artist_query = "SELECT * FROM artist WHERE artist_id='$this_artist_id';"; $this_artist_result = mysql_db_query($authDBName, $this_artist_query); while ($this_artist_row = mysql_fetch_array($this_artist_result)) { $this_artist_name = $this_artist_row["artist_name"]; } echo '
'; echo 'this module does not yet work'; } } elseif ($admin_user_level > 3) { //// user is root or operator echo '
'; echo '
'; echo ''; echo '
'; echo '
'; echo ''; echo ' '; echo ' '; echo ' '; echo ''; echo ' '; echo ' '; echo ' '; echo ''; echo '
'; } echo '


'; echo '
'; echo 'CONTENT/LINKS WILL GO HERE'; echo '


'; echo '


'; echo '
'; if ($maintenance) { echo '


New registrations are currently disabled. We apologize for the inconvenience.

'; } else { global $register_successful; global $resent_email; if (($register_successful=="true") OR ($resent_email=="true")) { // extract user info from the new entry mysql_connect($authDBHost, $authDBUser, $authDBPasswd); $member_query = "SELECT * FROM member WHERE member_id=$member_id;"; //echo 'user query is ' . $member_query . '
'; $member_result = mysql_db_query($authDBName, $member_query); while ($member_row = mysql_fetch_array($member_result)) { $member_id = $member_row["member_id"]; $member_firstname = $member_row["member_firstname"]; $member_email = $member_row["member_email"]; //echo 'gr user id is ' . $member_id; } } if ($register_successful == "true") { echo ''; echo 'Thanks ' . $member_firstname . '! You have successfully registered for the ' . $module_name . ' Volunteer Network. You should receive an email shortly '; echo 'to the address ' . $member_email . ' confirming your registration.

'; echo 'Didn\'t get the email? Please add the domain "' . $module_domain . '" to your "Safe Senders" list in your email, then '; echo 'click here to re-send it.'; echo '


'; } elseif ($resent_email == "true") { echo ''; echo 'Your confirmation email has been re-sent to ' . $member_email . '. You should receive it shortly.

'; echo 'Still didn\'t get it? Give us an email at ' . $module_admin_email . ' and we will investigate. Thanks!'; echo '


'; } else { // visitor hasn't registered yet. echo 'If you are interested in joining the ' . $module_name . ' Volunteer Network, WELCOME! Please '; echo 'click the button below to sign up.

'; } //echo 'Currently, the password-protected areas of this site are for administrators only. However, over the coming weeks and months we will be adding amazing and revolutionary new '; //echo 'tools for you, the fan and volunteer, to utilize and explore. We will be offering special exclusive content, rewards systems, and new ways to interact. We will let you '; //echo 'know when we make progress towards these ambitious plans!'; echo ''; //if (($register_successful <> "true") and ($resent_email <> "true")) { echo '
'; echo ''; echo '


'; //} echo ''; echo 'By signing up on this site, you are letting us know that you are a dedicated fan and want to help. Touring is the life-blood of our artists, and they need as '; echo 'much help from us as they can get so that they can continue to bring their music to our thirsty ears. When your favorite acts announce a show near you, '; echo 'we will send you an email and ask if you can help get the word out. We won\'t bug you for any other reason! And of course your info is safe with us - we will '; echo 'share it with our artists, but nobody else. You can remove your name from our system at any time.'; echo '

'; //echo 'Administrator Login


'; echo ''; } echo '
'; echo ''; echo ''; /////////////////////////////////// require ($top_of_site . "php/templates/web_footer.html"); // Page Template Header ?>