MySQL Error: " . mysqli_error($dbc));
$row = mysqli_fetch_array ($r, MYSQLI_ASSOC);
}//!
}else //if user isn't logged in
{$_SESSION['same'] ='0';
$q = "SELECT * FROM user WHERE username ='".$_GET['name']."'";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n MySQL Error: " . mysqli_error($dbc));
$row = mysqli_fetch_array ($r, MYSQLI_ASSOC);
}//!
}
else{ //directed from Personal Profile Menu Option
$_SESSION['same'] = '1';
$row = $_SESSION;
}
//is the profile deactivated?
$q = "SELECT da_id FROM deactivated WHERE user_id ='".$row['user_id']."'";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n MySQL Error: " . mysqli_error($dbc));
if (mysqli_num_rows($r)==1) {//yes, it is!
//profile is deactivated, redirect
print"Loop!";
header('Location: Access Error.php');
}
//text search? redirect!
if (isset ($_GET['sitesearch'])){
header('Location: home.php?sitesearch='.$_GET['sitesearch'].'');
}
//is the user followed or reported by session user?
if (isset($_SESSION['logged_in'])&&isset($_SESSION['same'])&&($_SESSION['same']=='0')){
//is the user followed by session user?
$q = "SELECT * FROM users_followers WHERE user_id = '".$row['user_id']."' AND follower_id = '".$_SESSION['user_id']."'";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q1\n MySQL Error: " . mysqli_error($dbc));
$flag = mysqli_num_rows($r); //0 if they aren't, 1 if they are
if ($flag==1)
$bvalue = "Unfollow";
else
$bvalue = "Follow";
//is the user reported by session user?
$q = "SELECT rep_id FROM reports WHERE type='1' AND byuser_id = '".$_SESSION['user_id']."' AND item_id ='".$row['user_id']."'";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q1\n MySQL Error: " . mysqli_error($dbc));
$flag = mysqli_num_rows($r); //0 if not, 1 if it is
if ($flag==1){
$rvalue = "Reported";
}
else
$rvalue = "Report User";
} //end if for follow and report
if (isset($_POST['followed'])){ //if user was followed
//---------------------------------
//----------------------------------
if ($bvalue == "Follow"){
//Add follower to the database:
$q = "INSERT INTO users_followers(user_id, follower_id) VALUES ('".$row['user_id']."','".$_SESSION['user_id']."')";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n MySQL Error: " . mysqli_error($dbc));
if (mysqli_affected_rows($dbc) == 1) { //One row affected, user successfully added
//Update follower no
//$q2 = "UPDATE user SET followers_no = (SELECT COUNT(*) FROM users_followers WHERE user_id ='".$row['user_id']."') WHERE user_id ='".$row['user_id']."'";
//$r2 = mysqli_query ($dbc, $q2) or trigger_error("Query: $q2\n MySQL Error: " . mysqli_error($dbc));
//make notification
$q3 = "INSERT INTO notification(to_user, from_user, itemref, type, seen) VALUES ('".$row['user_id']."','".$_SESSION['user_id']."','".$row['user_id']."','1', '0' )";
$r3 = mysqli_query ($dbc, $q3) or trigger_error("Query: $q3\n MySQL Error: " . mysqli_error($dbc));
$follow= "Done!";
$bvalue = "Unfollow";
header ('Location:profile.php?name='.$row['username'].'&content=1');
}
else {
$follow= "System error. Please try again.";
}
}
else {
//Remove follower from database
$q = "DELETE FROM users_followers WHERE user_id = '".$row['user_id']."' AND follower_id = '".$_SESSION['user_id']."'";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n MySQL Error: " . mysqli_error($dbc));
if (mysqli_affected_rows($dbc) == 1) { //One row affected
$follow= "Unfollowed!";
$bvalue = "Follow";
//Update follower no
//$q2 = "UPDATE user SET followers_no = (SELECT COUNT(*) FROM users_followers WHERE user_id ='".$row['user_id']."') WHERE user_id ='".$row['user_id']."'";
//$r2 = mysqli_query ($dbc, $q2) or trigger_error("Query: $q2\n MySQL Error: " . mysqli_error($dbc));
header ('Location:profile.php?name='.$row['username'].'&content=1'); }//!
else
$follow= "System error. Please click again.";
}//end else-remove from database
}//end-if followed user
if (isset($_POST['reported'])){ //if user was reported
if ($rvalue != "Reported"){//Add user to reported table for further inspection by admin:
$q = "INSERT INTO reports (byuser_id, type, item_id) VALUES ('".$_SESSION['user_id']."', '1', '".$row['user_id']."')";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n MySQL Error: " . mysqli_error($dbc));
if (mysqli_affected_rows($dbc) == 1) { //One row affected, user successfully added
$report= "Done!";
$rvalue = "Reported";
}//!
else {
$report= "System error. Please try again later.";
}//!
}
else $report= "Already reported!";
}//end if reported artwork
//-------------------------------------------START HTML PAGE
?>