query("SELECT * FROM friends WHERE user_to='{$_USER['id']}' AND arefriends='0' ORDER BY id DESC") or die($conn->errorInfo()[2]); ?>

Statistics

Friends:
0
Profile Views:
0
Place Visits:
0
Model Views:
0
Knockouts:
0
Wipeouts:
0

Showcase

prepare($usersQuery); $stmt->bindParam(':creator_id', $_USER['id'], PDO::PARAM_INT); $stmt->execute(); $usersResult = $stmt->fetchAll(); $thejlol = count($usersResult); if ($thejlol == 0) { ?>

You don't have any places.

 Public

Visit Online
Visited 0 times (0 last week)
<?=htmlentities($rowUser['name']);?>
prepare("SELECT * FROM friends WHERE (`user_from` = :user_id AND `arefriends`='1') OR (`user_to` = :user_id AND `arefriends`='1')"); $friendnew->bindParam(':user_id', $_USER['id'], PDO::PARAM_INT); $friendnew->execute(); $friendcountm = $friendnew->rowCount(); ?>

My friends See all (Edit)

prepare("SELECT * FROM friends WHERE (`user_from` = :user_id AND `arefriends`='1') OR (`user_to` = :user_id AND `arefriends`='1')"); $check->bindParam(':user_id', $_USER['id'], PDO::PARAM_INT); $check->execute(); $usercount = $check->rowCount(); $numberofpages = ceil($usercount/$resultsperpage); $page = 1; $thispagefirstresult = ($page-1)*$resultsperpage; $friendq = $conn->prepare("SELECT * FROM friends WHERE (`user_from` = :user_id AND `arefriends`='1') OR (`user_to` = :user_id AND `arefriends`='1') LIMIT :pagefirstresult, :resultsperpage"); $friendq->bindParam(':user_id', $_USER['id'], PDO::PARAM_INT); $friendq->bindParam(':pagefirstresult', $thispagefirstresult, PDO::PARAM_INT); $friendq->bindParam(':resultsperpage', $resultsperpage, PDO::PARAM_INT); $friendq->execute() or die(print_r($conn->errorInfo(), true)); $friendnew = $conn->prepare("SELECT * FROM friends WHERE (`user_from` = :user_id AND `arefriends`='1') OR (`user_to` = :user_id AND `arefriends`='1')"); $friendnew->bindParam(':user_id', $_USER['id'], PDO::PARAM_INT); $friendnew->execute() or die(print_r($conn->errorInfo(), true)); $friendcount = $friendnew->rowCount(); if ($friendcount < 1) { echo "

You don't have any $sitename friends.

"; } else { echo "
"; $total = 0; $row = 0; while ($friend = $friendq->fetch(PDO::FETCH_ASSOC)) { if ($total <= 5) { $friendid = 0; if ($friend['user_from'] == $_USER['id']) { $friendid = $friend['user_to']; } else { $friendid = $friend['user_from']; } $friend_online = $conn->prepare("SELECT * FROM users WHERE id=:friendid"); $friend_online->bindParam(':friendid', $friendid, PDO::PARAM_INT); $friend_online->execute() or die(print_r($conn->errorInfo(), true)); $finfo = $friend_online->fetch(PDO::FETCH_ASSOC); $usr = $conn->prepare("SELECT * FROM users WHERE id=:friendid LIMIT :pagefirstresult,:resultsperpage"); $usr->bindParam(':friendid', $friendid, PDO::PARAM_INT); $usr->bindParam(':pagefirstresult', $thispagefirstresult, PDO::PARAM_INT); $usr->bindParam(':resultsperpage', $resultsperpage, PDO::PARAM_INT); $usr->execute() or $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $row = $usr->fetch(PDO::FETCH_ASSOC); // Fetch the result as an associative array echo "
"; $total++; $row++; if ($row >= 3) { echo "
"; $row = 0; } }} echo "
"; } ?>
\"{$row['username']}\"
"; $onlinetest = ($finfo['lastseen'] + 300 <= time()) ? "" : ""; echo "$onlinetest {$row['username']}

Favorites

This user does not have any favorites for this type
Category: 

My Friend Requests

 rowCount() < 1) { die ("

You don't have any $sitename Friend Requests.

"); } ?> fetch(PDO::FETCH_ASSOC)) { $stmt = $conn->prepare("SELECT * FROM users WHERE id=:user_id"); $stmt->bindParam(':user_id', $message['user_from']); $stmt->execute(); $userrrrr = $stmt->fetch(PDO::FETCH_ASSOC); $binner = ""; $bouter = ""; echo ""; } ?>
$binner{$userrrrr['username']}$bouter