if ($id != NULL) { $__database->query("\n\t\t\tDELETE FROM\n\t\t\t\tfriend_list\n\t\t\tWHERE\n\t\t\t\t(\n\t\t\t\t\taccount_id = " . $id . "\n\t\t\t\t\tAND\n\t\t\t\t\tfriend_id = " . $_loginaccount->GetId() . "\n\t\t\t\t)\n\t\t\t\tOR\n\t\t\t\t(\n\t\t\t\t\tfriend_id = " . $id . "\n\t\t\t\t\tAND\n\t\t\t\t\taccount_id = " . $_loginaccount->GetId() . "\n\t\t\t\t)"); if ($__database->affected_rows == 1) { // Send mail? ?> <p class="alert-info alert fademeout">Successfully denied <?php echo $name; ?> 's friend request!<p> <?php } } } elseif (isset($_GET['invite'])) { $name = $_GET['invite']; $id = GetAccountID($name); if ($id != NULL && GetFriendStatus($_loginaccount->GetID(), $id) == 'NO_FRIENDS') { $__database->query("\n\t\t\tINSERT INTO\n\t\t\t\tfriend_list\n\t\t\tVALUES\n\t\t\t(\n\t\t\t\t" . $_loginaccount->GetID() . ",\n\t\t\t\t" . $id . ",\n\t\t\t\tNOW(),\n\t\t\t\tNULL\n\t\t\t)"); if ($__database->affected_rows == 1) { // Send mail? ?> <p class="alert-info alert fademeout">Successfully sent <?php echo $name; ?> a friend request!<p> <?php } } } } require_once __DIR__ . '/../avatar_faces.php'; $twitterenabled = $_loginaccount->GetConfigurationOption('twitter_oauth_token');
die; } $character_info = $q->fetch_assoc(); $character_account_id = GetCharacterAccountId($character_info['id'], CURRENT_LOCALE); $character_info['guildname'] = ''; $q2 = $__char_db->query("\nSELECT\n\tg.name\nFROM\n\tcharacters c\nLEFT JOIN\n\tguild_members gm\n\tON\n\t\tgm.character_id = c.id\nLEFT JOIN\n\tguilds g\n\tON\n\t\tg.id = gm.guild_id\nWHERE\n\tc.internal_id = " . $character_info['internal_id']); if ($q2->num_rows == 1) { // Try to fetch guildname $row2 = $q2->fetch_row(); if ($row2[0] !== null) { $character_info['guildname'] = $row2[0]; } } $q2->free(); // Check character status $friend_status = $_loggedin ? $character_account_id == $_loginaccount->GetID() ? 'FOREVER_ALONE' : GetFriendStatus($_loginaccount->GetID(), $character_account_id) : 'NO_FRIENDS'; $status = GetCharacterStatus($character_info['id'], CURRENT_LOCALE); if ($status == 1 && (!$_loggedin || $_loggedin && $friend_status != 'FRIENDS' && $friend_status != 'FOREVER_ALONE' && $_loginaccount->GetAccountRank() < RANK_MODERATOR)) { ?> <center> <img src="//<?php echo $locale_domain; ?> /inc/img/no-character.gif" /> <p>Only friends are allowed to view this character!</p> </center> <?php require_once __DIR__ . '/../inc/footer.php'; die; } elseif ($status == 2 && ($_loggedin && $friend_status != 'FOREVER_ALONE' && $_loginaccount->GetAccountRank() < RANK_MODERATOR)) { // displays the same error as not found to not tell if exists or not.
<?php $main_character = $__url_useraccount->GetMainCharacterName(); $main_character_image = $main_character !== null ? '//' . $main_character['locale'] . '.' . $domain . '/avatar/' . $main_character['name'] : ''; $is_self = $_loggedin && $__url_useraccount->GetID() == $_loginaccount->GetID(); $friend_status = $_loggedin ? GetFriendStatus($_loginaccount->GetID(), $__url_useraccount->GetID()) : ''; $playerrank = $__url_useraccount->GetAccountRank(); ?> <style type="text/css"> .avatar { width:200px; } .name { font-weight: bold; font-family: Helvetica, sans-serif; font-size: 24px; letter-spacing: 0px; } .name_extra { font-weight: 200; letter-spacing: normal; font-size: 15px; } hr { margin: 0 auto; border: 0;