"; mysql_connect("$db_addr", "$db_user", "$db_pass"); mysql_select_db("airpics") or die( "Unable to select database"); //echo $userid1; if (!is_numeric ($userid1)) { $result = mysql_query("SELECT * FROM airpics_members WHERE display_name = '$userid1' limit 1"); //echo "No"; } else { $result = mysql_query("SELECT * FROM airpics_members WHERE user_id = '$userid1' limit 1"); //echo "Yes"; } //$result = mysql_query("SELECT * FROM airpics_members WHERE display_name = '$userid1' limit 1"); $num=mysql_numrows($result); $userid1=mysql_result($result,$i,"user_id"); if ($num == '') // Check if member name is correct, error and exit(). { echo(" "); include("../includes_01/header_includes.php"); echo(" "); include("../includes_01/header_04.php"); echo ("

There is no photographer with that name on this website. Please try another search

"); include("../includes_01/footer_01.php"); echo (""); // bah, modify the "Not Found" error for your needs. exit(); } //**********Start Login Script********** $logout_page = "$wap_login_link/logout.php"; $page_name="$wap_login_link/members/photo_prefs.php"; //**********Finish Login Script********** //**********Last Page Visited********** // Function to generate random string function randomstring($chars) { srand((double) microtime() * 1000000); $allowchars = '0123456789'; while(++$n < ($chars+1)) $freturn .= $allowchars[rand(0, strlen($allowchars)-1)]; return $freturn; } $random = randomstring("5"); $current_time = time(); $trimmed_time = substr($current_time, 5); $random_id = "$trimmed_time$random"; $question_mark = "?"; $string = $_SERVER['QUERY_STRING']; $last_visited_page = $page_name; $query_redirect = "insert into airpics_logging_redirect (redirect_url, unique_id, timestamp) VALUES ('$page_name', '$random_id', NOW())"; $result_redirect = mysql_query($query_redirect); if (!isset($result_redirect)) { echo ("Error in query.
Please go back and try again."); //exit(); } //**********Connect Check********** if (!($connect)) // If no connect, error and exit(). { echo(" "); include("../includes_01/header_04_no_menu.php"); echo ("

The WorldAirPics.com server appears to be down, please refresh this page or try again later. WorldAirPics.com apologises for this interruption.

"); include("../includes_01/footer_01.php"); echo (""); // bah, modify the "Not Found" error for your needs. exit(); } if (!(@mysql_select_db($db_name))) // If can't connect to database, error and exit(). { echo(" "); include("../includes_01/header_04_no_menu.php"); echo ("

The WorldAirPics.com server appears to be down, please refresh this page or try again later. WorldAirPics.com apologises for this interruption.

"); include("../includes_01/footer_01.php"); echo (""); // bah, modify the "Not Found" error for your needs. exit(); } if ($turn_website_on != 'yes') // Check if website is turned on or off, error and exit(). { echo(" "); include("../includes_01/header_04_no_menu.php"); echo ("

The $website_name_01 has been turned off for maintenance, please try again later. $website_name_01 apologises for this interruption.

"); include("../includes_01/footer_01.php"); echo (""); // bah, modify the "Not Found" error for your needs. exit(); } require_once('/home/users/web/b2270/pow.frankjnr/htdocs/worldairpics/forum/SSI.php'); $logout_page = "$wap_login_link/members/logout.php"; $userid2 = $context['user']['id']; if ($userid2 != '29') { //echo "USERID: $userid1
"; $ad_free_groups = array(1, 2, 9,10); $no_adverts = FALSE; foreach ($ad_free_groups as $ad_free) if (in_array($ad_free, $user_info['groups'])) { $no_adverts = TRUE; break; } $username = $context['user']['name']; //echo "$userid1
"; if ($context['user']['is_guest']) { echo (" "); include("../includes_01/header_includes.php"); echo (" "); include("../includes_01/header_04.php"); echo "

You are not logged in. You must be logged in to view this page. Please Login or Register

You do not have permission to view this page

"; exit(); } else if ($context['user']['id'] != $userid1) //if (($context['user']['is_guest']) && (($userid1 != $userid2) || ($userid2 == '29'))) { echo (" "); include("../includes_01/header_includes.php"); echo (" "); include("../includes_01/header_04.php"); echo "

You are not logged in. You must be logged in to view this page. Please Login or Register

"; exit(); } } ?>
You are not logged in. You must be logged in to view this page.

Please Login or Register "; } else { echo "

You are logged in as $username - "; $_SESSION['logout_url'] = "$page_name"; ssi_logout($logout_page); echo "

"; } if ($no_adverts) { echo ""; } else { echo "

"; include("../adverts/google_468_60.php"); echo "

"; } ?>

Profile Info

Summary Show Stats Show Posts

Modify Profile

Account Related Settings Forum Profile Information Look and Layout Preferences Notifications and Email Photo Info & Preferences Edit Buddies

Actions

Delete this account

'; $main_table_width = 482; } ?> Your Pictures'; } ?>

'; mysql_connect("$db_addr", "$db_user", "$db_pass"); mysql_select_db("airpics") or die( "Unable to select database"); $query="SELECT * FROM pictures WHERE display_picture='yes' and member_id = '$userid1' ORDER BY views DESC LIMIT 1"; $result=mysql_query($query) or die("MySQL Error ".mysql_errno().": ".mysql_error()."
\nThe query was: ".$query);; $num=mysql_numrows($result); $i=0; while ($i < $num) { $TYPE=mysql_result($result,$i,"TYPE"); $clean_type=mysql_result($result,$i,"clean_type"); $reg=mysql_result($result,$i,"reg"); $picture=mysql_result($result,$i,"picture"); $date=mysql_result($result,$i,"date"); $added=mysql_result($result,$i,"added"); $operator=mysql_result($result,$i,"operator"); $clean_operator=mysql_result($result,$i,"clean_operator"); $id=mysql_result($result,$i,"id"); $full_size_folder=mysql_result($result,$i,"full_size_folder"); $views=mysql_result($result,$i,"views"); $clean_operator = str_replace(" ", "_", "$clean_operator"); $clean_operator_url = str_replace("_", "-", "$clean_operator"); $clean_operator_url = str_replace(" / ", "--", "$clean_operator_url"); $clean_operator_url = str_replace("-/-", "--", "$clean_operator_url"); $clean_type = str_replace(" ", "_", "$clean_type"); $clean_type_url = str_replace("_", "-", "$clean_type"); $clean_type_url = str_replace(" / ", "--", "$clean_type_url"); $clean_type_url = str_replace("-/-", "--", "$clean_type_url"); $clean_type_url = str_replace("/", "--", "$clean_type_url"); $clean_reg_url = str_replace(" ", "_", "$reg"); $clean_reg_url = str_replace("_", "-", "$clean_reg_url"); $photo = "photo"; include("../../images/scripts/wap_searchthumbs.php"); echo '
Most Popular



'; ++$i; } mysql_connect("$db_addr", "$db_user", "$db_pass"); mysql_select_db("airpics") or die( "Unable to select database"); $query="SELECT * FROM pictures WHERE display_picture='yes' and member_id = '$userid1' ORDER BY added DESC LIMIT 1"; $result=mysql_query($query) or die("MySQL Error ".mysql_errno().": ".mysql_error()."
\nThe query was: ".$query);; $num=mysql_numrows($result); $i=0; while ($i < $num) { $TYPE=mysql_result($result,$i,"TYPE"); $clean_type=mysql_result($result,$i,"clean_type"); $reg=mysql_result($result,$i,"reg"); $picture=mysql_result($result,$i,"picture"); $date=mysql_result($result,$i,"date"); $added=mysql_result($result,$i,"added"); $operator=mysql_result($result,$i,"operator"); $clean_operator=mysql_result($result,$i,"clean_operator"); $id=mysql_result($result,$i,"id"); $full_size_folder=mysql_result($result,$i,"full_size_folder"); $views=mysql_result($result,$i,"views"); $clean_operator = str_replace(" ", "_", "$clean_operator"); $clean_operator_url = str_replace("_", "-", "$clean_operator"); $clean_operator_url = str_replace(" / ", "--", "$clean_operator_url"); $clean_operator_url = str_replace("-/-", "--", "$clean_operator_url"); $clean_type = str_replace(" ", "_", "$clean_type"); $clean_type_url = str_replace("_", "-", "$clean_type"); $clean_type_url = str_replace(" / ", "--", "$clean_type_url"); $clean_type_url = str_replace("-/-", "--", "$clean_type_url"); $clean_type_url = str_replace("/", "--", "$clean_type_url"); $clean_reg_url = str_replace(" ", "_", "$reg"); $clean_reg_url = str_replace("_", "-", "$clean_reg_url"); $photo = "photo"; include("../../images/scripts/wap_searchthumbs.php"); echo '
Latest Addition



'; ++$i; } echo ''; } ?> '; } ?> '; } ?>

" HEIGHT="20">   Photographer Name:

" style="vertical-align:top;"> '; } ?> '; } ?> \nThe query was: ".$query1); $num1=mysql_numrows($result1); //echo "$userid2"; $count=mysql_result($result1,$i1,"count"); $total=mysql_result($result1,$i1,"total"); $average = (round($total/$count)); ?> '; } ?> Photographer Name: This is the name that people will search for, it will also be stamped on your pictures.'; } ?> Email: '.$email.' Allow Other Users To Comment On And Rate Your Pictures: Please Note: Name changes will need to be reviewed by the Administrator first before being applied to your pictures, you will be notified by email when a decision is made. Pictures Online: Total Hits: Average Hits Per Picture: Picture Upload Stats: '; mysql_connect("$db_addr", "$db_user", "$db_pass"); mysql_select_db("airpics") or die( "Unable to select database"); //$query2="SELECT member_id, SUM(upload_count) AS upload_count, SUM(declined) AS declined, SUM(accepted) AS accepted, COUNT(*) AS count1 FROM airpics_upload_stats WHERE display_picture = 'yes' and reject_reason <> 'bad_upload' and member_id='$userid1' GROUP BY upload_count order by upload_count DESC"; $query2="SELECT member_id, SUM(upload_count) AS upload_count, SUM(pending) AS pending, SUM(declined) AS declined, SUM(accepted) AS accepted FROM airpics_upload_stats WHERE member_id = '$userid1' GROUP BY member_id order by upload_count DESC"; $result2=mysql_query($query2) or die("MySQL Error ".mysql_errno().": ".mysql_error()." \nThe query was: ".$query2); $num=mysql_numrows($result2); $upload_count=mysql_result($result2,$i2,"upload_count"); $accepted=mysql_result($result2,$i2,"accepted"); $declined=mysql_result($result2,$i2,"declined"); $pending=mysql_result($result2,$i2,"pending"); $acceptance_percentage = (($accepted/$upload_count)*100); //$acceptance_percentage = number_format($acceptance_percentage); $english_format_number = number_format($acceptance_percentage, 0, '.', ''); echo "$english_format_number%"; $green_bar = number_format($acceptance_percentage, 0, '.', ''); if ($green_bar == '0') { echo "  "; } else { echo "  "; if ($green_bar == '100') { echo ""; } elseif ($green_bar <> '100') { $red_bar = 100-$green_bar; echo ""; } } echo ' Total Number of Pictures Uploaded: '.$upload_count.' Total Number of Pictures Accepted: '.$accepted.' Total Number of Pictures Declined: '.$declined.' Pictures In Upload Queue: '.$pending.' - View Your Queued Pictures

Most Popular Pictures:

'; mysql_connect("$db_addr", "$db_user", "$db_pass"); mysql_select_db("airpics") or die( "Unable to select database"); $query="SELECT * FROM pictures WHERE display_picture='yes' and member_id = '$userid1' ORDER BY views DESC LIMIT 4"; $result=mysql_query($query) or die("MySQL Error ".mysql_errno().": ".mysql_error()." \nThe query was: ".$query);; $num=mysql_numrows($result); $i=0; while ($i < $num) { $TYPE=mysql_result($result,$i,"TYPE"); $clean_type=mysql_result($result,$i,"clean_type"); $reg=mysql_result($result,$i,"reg"); $picture=mysql_result($result,$i,"picture"); $date=mysql_result($result,$i,"date"); $added=mysql_result($result,$i,"added"); $operator=mysql_result($result,$i,"operator"); $clean_operator=mysql_result($result,$i,"clean_operator"); $id=mysql_result($result,$i,"id"); $full_size_folder=mysql_result($result,$i,"full_size_folder"); $views=mysql_result($result,$i,"views"); $clean_operator = str_replace(" ", "_", "$clean_operator"); $clean_operator_url = str_replace("_", "-", "$clean_operator"); $clean_operator_url = str_replace(" / ", "--", "$clean_operator_url"); $clean_operator_url = str_replace("-/-", "--", "$clean_operator_url"); $clean_type = str_replace(" ", "_", "$clean_type"); $clean_type_url = str_replace("_", "-", "$clean_type"); $clean_type_url = str_replace(" / ", "--", "$clean_type_url"); $clean_type_url = str_replace("-/-", "--", "$clean_type_url"); $clean_type_url = str_replace("/", "--", "$clean_type_url"); $clean_reg_url = str_replace(" ", "_", "$reg"); $clean_reg_url = str_replace("_", "-", "$clean_reg_url"); $photo = "photo"; include("../../images/scripts/wap_searchthumbs.php"); echo '   '; ++$i; } echo '

latest Additions:

'; mysql_connect("$db_addr", "$db_user", "$db_pass"); mysql_select_db("airpics") or die( "Unable to select database"); $query="SELECT * FROM pictures WHERE display_picture='yes' and member_id = '$userid1' ORDER BY added DESC LIMIT 4"; $result=mysql_query($query) or die("MySQL Error ".mysql_errno().": ".mysql_error()." \nThe query was: ".$query);; $num=mysql_numrows($result); $i=0; while ($i < $num) { $TYPE=mysql_result($result,$i,"TYPE"); $clean_type=mysql_result($result,$i,"clean_type"); $reg=mysql_result($result,$i,"reg"); $picture=mysql_result($result,$i,"picture"); $date=mysql_result($result,$i,"date"); $added=mysql_result($result,$i,"added"); $operator=mysql_result($result,$i,"operator"); $clean_operator=mysql_result($result,$i,"clean_operator"); $id=mysql_result($result,$i,"id"); $full_size_folder=mysql_result($result,$i,"full_size_folder"); $views=mysql_result($result,$i,"views"); $clean_operator = str_replace(" ", "_", "$clean_operator"); $clean_operator_url = str_replace("_", "-", "$clean_operator"); $clean_operator_url = str_replace(" / ", "--", "$clean_operator_url"); $clean_operator_url = str_replace("-/-", "--", "$clean_operator_url"); $clean_type = str_replace(" ", "_", "$clean_type"); $clean_type_url = str_replace("_", "-", "$clean_type"); $clean_type_url = str_replace(" / ", "--", "$clean_type_url"); $clean_type_url = str_replace("-/-", "--", "$clean_type_url"); $clean_type_url = str_replace("/", "--", "$clean_type_url"); $clean_reg_url = str_replace(" ", "_", "$reg"); $clean_reg_url = str_replace("_", "-", "$clean_reg_url"); $photo = "photo"; include("../../images/scripts/wap_searchthumbs.php"); echo '   '; ++$i; } echo '

Text Goes Here:

Text Goes Here Text Goes Here