$pageTitle="View Profile"; include($_SERVER['DOCUMENT_ROOT'] . "/template/header.php"); if($_POST['submittedName']) $submittedName=$_POST['submittedName']; if(user_logged_in() && $_COOKIE['sclcr']==$submittedName){ //this is a real user echo "
You must supply a username to view or be logged in. Please log in to view your profile or visit the members page.
\n"; include($_SERVER['DOCUMENT_ROOT'] . "/template/footer.php"); exit(); } else{ //invalid login, try again echo "You are not logged in. Please log in to view your profile or visit the members page.
\n"; include($_SERVER['DOCUMENT_ROOT'] . "/template/footer.php"); exit(); } //need to get the values to put in the form from the MEMBERS table $result=database_query("SELECT id, name, username, email, category, created FROM Members WHERE username='$u' LIMIT 1"); if($result && mysql_num_rows($result)==1){ //we got the data we needed so put it into variables $myrow=mysql_fetch_row($result); $memberID=$myrow[0]; $membertype=$myrow[4]; $name=$myrow[1]; $email=$myrow[3]; $username=$myrow[2]; $created=$myrow[5]; } else{ //there was a problem so bail out echo "We could not find a profile for that username or we experienced a technical issue. Please try a different username or try again a little later. Thank you. (101)
\n"; return false; } //need to get the values to put in the form from the PROFILES table $queryString="SELECT * FROM Profiles WHERE userID=$memberID LIMIT 1"; //echo "$queryString
\n"; $result=database_query($queryString); //echo "" . mysql_num_rows($result) . "
\n"; if($result && mysql_num_rows($result)==1){ //we got the data we needed so put it into variables $myrow=mysql_fetch_row($result); $title=$myrow[2]; $institution=$myrow[3]; $cv=nl2p(convertURLs($myrow[4])); $bio=nl2p(convertURLs($myrow[5])); $facebook=$myrow[6]; $academia=$myrow[7]; $linkedin=$myrow[8]; $links=nl2br(convertURLs($myrow[9])); $phone=$myrow[10]; $address=nl2br($myrow[11]); $allowcontact=$myrow[12]; } else{ //there was a problem so bail out echo "Experienced a technical problem. Sorry. Please try again in a little bit. (102)
\n"; return false; } ?>Member Name: echo $name; ?>
Username: echo $username; ?>
Member Type: if($membertype==1){ echo "Grad Student"; } elseif($membertype==2){ echo "Faculty"; } elseif($membertype==3){ echo "Researcher"; } elseif($membertype==4){ echo "Practitioner"; } elseif($membertype==5){ echo "Undergrad Student"; } elseif($membertype==0){ echo "No Response"; } else{ echo "No Response";} ?>
Conceptions (" . mysql_num_rows($result) . ")
\n";
while($myrow=mysql_fetch_row($result)){
echo "$myrow[1]
\n";
}
echo "
This member has not yet contributed to the Concept Database.
"; } ?>Title/Job: echo $title; ?>
Institution/Employer: echo $institution; ?>
CV/Resume:
echo $cv; ?>
Click a concept to finish editing it.
\n"; while($myrow=mysql_fetch_row($incompleteEntries)){ echo "\n"; } echo "