num_rows; if($rowcount > 0) { $result2 = mysqli_fetch_array($res, MYSQLI_ASSOC); $playerID = $result2['playerID']; $friendName = $result2['friendName']; $friendPending = $result2['friendPending']; $user_check_query = "UPDATE `notifications` SET `read` = '1' WHERE `read` = '0' AND `friend` = '$friend_id' LIMIT 1"; $res = mysqli_query($link, $user_check_query); mysqli_free_result($res); if($friendName == $username) { $friendName = $result2['playerName']; } $show_stuff = true; if($friendPending == 0) { $friend_already_accepted = true; } else { if(isset($_GET['accept'])) { $user_check_query = "UPDATE ucp_friends SET friendPending = '0' WHERE ID = '$friend_id' LIMIT 1"; $res = mysqli_query($link, $user_check_query); mysqli_free_result($res); $user_check_query = "INSERT INTO `notifications` (`master`, `sender`, `friend`, `read`) VALUES ('$playerID', '$username', '-1', '1')"; $res = mysqli_query($link, $user_check_query); mysqli_free_result($res); $friend_accepted = true; $show_stuff = false; } } } else $show_stuff = false; mysqli_free_result($res); ?>