"; exit(); } } } $post = @$_POST["post"]; if ($post !="") { $date_added = date("Y-m-d"); $added_by = $user; $user_posted_to = $username; $sqlCommand = "INSERT INTO posts VALUES('','$post','$date_added','$added_by','$user_posted_to')"; $query = mysql_query($sqlCommand) or die (mysql_error()); } $check_pic = mysql_query("SELECT profile_pic FROM users WHERE username='$user'"); $get_pic_row = mysql_fetch_assoc($check_pic); $profile_pic_db = $get_pic_row['profile_pic']; if ($profile_pic_db =="") { $profile_pic = "img/default_pic.jpg"; } else { $profile_pic = "userdata/profile_pics/".$profile_pic_db; } ?>





Posted by: $added_by on $date_added -

  $body



"; } if (isset($_POST['sendmsg'])) { header("Location: send_msg.php?u=$username"); } $errorMsg = ""; if (isset($_POST['addfriend'])) { $friend_request = $_POST['addfriend']; $user_to = $user; $user_from = $username; if ($user_to == $username) { $errorMsg = "You can't befriend yourself!
"; } else { $create_request = mysql_query("INSERT INTO friend_requests VALUES ('','$user_to','$user_from')"); $errorMsg = "Request sent"; } } else { //do nothing } ?>
<?php echo $username; ?>'s Profile
'; } else { $addAsFriend = ''; } echo $addAsFriend; } //remove later!!! else { $addAsFriend = ''; echo $addAsFriend; } //$user = logged in user //$username = user who owns profile if (@$_POST['removefriend']) { //Friend array for logged in user $add_friend_check = mysql_query("SELECT friend_array FROM users WHERE username='$user'"); $get_friend_row = mysql_fetch_assoc($add_friend_check); $friend_array = $get_friend_row['friend_array']; $friend_array_explode = explode(",",$friend_array); $friend_array_count = count($friend_array_explode); //Friend array for user who owns profile $add_friend_check_username = mysql_query("SELECT friend_array FROM users WHERE username='$username'"); $get_friend_row_username = mysql_fetch_assoc($add_friend_check_username); $friend_array_username = $get_friend_row_username['friend_array']; $friend_array_explode_username = explode(",",$friend_array_username); $friend_array_count_username = count($friend_array_explode_username); $usernameComma = ",".$username; $usernameComma2 = $username.","; $userComma = ",".$user; $userComma2 = $user.","; if (strstr($friend_array,$usernameComma)) { $friend1 = str_replace("$usernameComma","",$friend_array); } else if (strstr($friend_array,$usernameComma2)) { $friend1 = str_replace("$usernameComma2","",$friend_array); } else if (strstr($friend_array,$username)) { $friend1 = str_replace("$username","",$friend_array); } //Remove logged in user from other persons array if (strstr($friend_array,$userComma)) { $friend2 = str_replace("$userComma","",$friend_array); } else if (strstr($friend_array,$userComma2)) { $friend2 = str_replace("$userComma2","",$friend_array); } else if (strstr($friend_array,$user)) { $friend2 = str_replace("$user","",$friend_array); } $friend2 = ""; $removeFriendQuery = mysql_query("UPDATE users SET friend_array='$friend1' WHERE username='$user'"); $removeFriendQuery_username = mysql_query("UPDATE users SET friend_array='$friend2' WHERE username='$username'"); echo "Friend Removed ..."; header("Location: $username"); } //poke code if (@$_POST['nudge']) { $check_if_nudged = mysql_query("SELECT * FROM pokes WHERE user_to='$username' && user_from='$user'"); $num_nudge_found = mysql_num_rows($check_if_nudged); if ($num_nudge_found == 1) { echo "You must wait for a nudge back"; } else if ($username == $user) { echo "Cant nudge yourself"; } else { $poke_user = mysql_query("INSERT INTO pokes VALUES ('','$user','$username')"); echo "$username has been nudged"; } } //Create like button if it doesn't already exist $check_like_button = mysql_query("SELECT * FROM like_buttons WHERE uid='$username'"); $check_like_numrows = mysql_num_rows($check_like_button); if ($check_like_numrows >= 1) { //Do Nothing } else { $date = date("Y-m-d"); $create_button = mysql_query("INSERT INTO like_buttons VALUES ('', '$username', 'http://localhost/mydesign/$username', '$date', '$username')"); $insert_like = mysql_query("INSERT INTO likes VALUES('','$username','-1','$username')"); } ?>
's Profile
's Talents
$value) { $i++; $getFriendQuery = mysql_query("SELECT * FROM users WHERE username='$value' LIMIT 1"); $getFriendRow = mysql_fetch_assoc($getFriendQuery); $friendUsername = $getFriendRow['username']; $friendProfilePic = $getFriendRow['profile_pic']; if ($friendProfilePic == "") { echo "\"$friendUsername's"; } else { echo "\"$friendUsername's"; } } } else{ echo $username. " has no friends yet"; // And add a space at the beggining of the string too :) } ?>
's Albums