'; html::buildFooter(); exit; } }else{ echo 'No username specified
'; html::buildFooter(); exit; } $stmt = $GLOBALS['dbcon']->prepare('SELECT * FROM users WHERE username = :username;'); $stmt->bindParam(':username', $username, PDO::PARAM_STR); $stmt->execute(); if ($stmt->rowCount() == 0) { echo 'User not found'; html::buildFooter(); exit; } $result = $stmt->fetch(PDO::FETCH_ASSOC); $userID = $result['id']; $p_username = $result['username']; if ($result['banned'] == 1) { echo 'This user has been suspended'; html::buildFooter(); exit; } echo ''; $stmtr = $GLOBALS['dbcon']->prepare("SELECT id FROM `profile_views` WHERE `viewer` = :id AND `profile` = :pid;"); $stmtr->bindParam(':id', $GLOBALS['userTable']['id'], PDO::PARAM_INT); $stmtr->bindParam(':pid', $userID, PDO::PARAM_INT); $stmtr->execute(); if ($stmtr->rowCount() == 0) { $found = false; }else{ $found = true; } if ($found == false and $loggedIn == true) { $result['profileviews'] = $result['profileviews']+1; $query = "INSERT INTO `profile_views` (`viewer`, `profile`) VALUES (:userId, :profile);"; $stmt = $GLOBALS['dbcon']->prepare($query); $stmt->bindParam(':profile', $userID, PDO::PARAM_INT); $stmt->bindParam(':userId', $GLOBALS['userTable']['id'], PDO::PARAM_INT); $stmt->execute(); $stmt = $GLOBALS['dbcon']->prepare("UPDATE users SET profileviews = profileviews + 1 WHERE id = :id"); $stmt->bindParam(':id', $userID, PDO::PARAM_INT); $stmt->execute(); } ?>

● ') { if ($GLOBALS['loggedIn']) { $stmt = $GLOBALS['dbcon']->prepare("SELECT * FROM gameJoins WHERE uid = :id"); $stmt->bindParam(':id', $result['id'], PDO::PARAM_INT); $stmt->execute(); $resultGame = $stmt->fetch(PDO::FETCH_ASSOC); echo ' In Game || Follow
'; }else{ echo ' In Game
'; } } ?> Send Message'; context::buildFriendButton($result['id']); echo '
'; } } ?>

'.context::secureString($result['about']).''; } ?>

Statistics

Join Date:

Last Seen:

Forum Posts:

Profile views:

Groups

prepare("SELECT * FROM groups WHERE cuid = :id;"); $stmt->bindParam(':id', $userID, PDO::PARAM_INT); $stmt->execute(); foreach($stmt as $result) { $count++; echo ''.context::secureString($result['name']).' '; } $stmt = $GLOBALS['dbcon']->prepare("SELECT * FROM group_members WHERE uid = :id;"); $stmt->bindParam(':id', $userID, PDO::PARAM_INT); $stmt->execute(); foreach($stmt as $result) { $count++; $stmt = $GLOBALS['dbcon']->prepare("SELECT * FROM groups WHERE id = :id"); $gId = $result['gid']; $stmt->bindParam(':id', $gId, PDO::PARAM_INT); $stmt->execute(); $resultGroupM = $stmt->fetch(PDO::FETCH_ASSOC); echo ''.context::secureString($resultGroupM['name']).' '; } if ($count == 0) { echo '
This user is not in any group.
'; } ?>

Friends

prepare("SELECT * FROM friends WHERE userId1 = :id;"); $stmtc->bindParam(':id', $userID, PDO::PARAM_INT); $stmtc->execute(); $stmt = $GLOBALS['dbcon']->prepare("SELECT * FROM friends WHERE userId1 = :id ORDER BY id DESC LIMIT 8;"); $stmt->bindParam(':id', $userID, PDO::PARAM_INT); $stmt->execute(); if ($stmt->rowCount() == 0) { echo 'This user has no friends.'; }else{ echo '
'; } echo ''; foreach($stmt as $result) { $userId = $result['userId2']; $stmt = $GLOBALS['dbcon']->prepare("SELECT username, imgTime, lastSeen, id FROM users WHERE id = :id"); $stmt->bindParam(':id', $userId, PDO::PARAM_INT); $stmt->execute(); $resultuser = $stmt->fetch(PDO::FETCH_ASSOC); $username = $resultuser['username']; if (strlen($username) > 10) { $username = substr($username, 0, 7) . '...'; } echo '

'; echo '
'; echo context::getOnline($resultuser); echo ''.htmlentities($username, ENT_QUOTES, "UTF-8").'

'; } if ($stmt->rowCount() > 0) { echo '
'; } if ($stmtc->rowCount() > 8) { echo 'Show all friends'; } ?>

Badges

prepare("SELECT badgeId FROM badges WHERE uid = :id"); $stmt->bindParam(':id', $userID, PDO::PARAM_INT); $stmt->execute(); if ($stmt->rowCount() == 0) { echo 'This user has no badges.'; } $name = ""; $description = ""; foreach($stmt as $resultBadge) { if ($resultBadge['badgeId'] == 1) { $name = "Administrator"; $description = "Owned by the administrators of Graphictoria. Owners of this badge control the whole entire website and can change everything. Users who do not have this badge are not administrators."; } if ($resultBadge['badgeId'] == 2) { $name = "Administrator"; $description = "Owned by the administrators of Graphictoria. Owners of this badge control the whole entire website and can change everything. Users who do not have this badge are not administrators."; } if ($resultBadge['badgeId'] == 3) { $name = "Moderator"; $description = "Owned by the moderators of Graphictoria. Owners of this badge moderate the website. Users who do not have this badge are not moderators."; } if ($resultBadge['badgeId'] == 4) { $name = "Forumer"; $description = "Owned by the active forumers who managed to get 1000 posts!"; } if ($resultBadge['badgeId'] == 5) { $name = "Member"; $description = "This badge is owned by every single user of Graphictoria and proves that you have played Graphictoria."; } if ($resultBadge['badgeId'] == 6) { $name = "Roblox Staff"; $description = "This badge is only awarded to verified, legitimate Roblox staff members."; } if ($resultBadge['badgeId'] == 7) { $name = "Before 100"; $description = "Owned by the very first 100 users of Graphictoria. Users with this badge know the story of how we came to be."; } if ($resultBadge['badgeId'] == 8) { $name = "Gamer"; $description = "This user has successfully joined a game at least once"; } echo '

'.$name.'

'; } ?>

Inventory

Hats Heads Faces T-Shirts Shirts Pants Gear