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;
