list($linkedimages) = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT COUNT(galleryid) FROM flobase_character_gallery WHERE characterid='{$character->data['characterid']}'"));
$linkedimages = intval($linkedimages);
#var_dump(count($linkedimages));
if ($linkedimages < 1) {
$imagelist = "<div class='small'>" . $flolang->sprintf($flolang->gallery_overview_error_character_noimages, $florensia->escape($character->data['charname'])) . " <a href='" . $florensia->outlink(array("gallery", "upload"), $character->merge_opt_link(array("character" => $character->data['charname']))) . "'>{$flolang->gallery_link_uploadimages}</a>.</div>";
$pagetitle = "<div class='subtitle' style='margin-bottom:3px;'><a href='" . $florensia->outlink(array("gallery")) . "'>{$flolang->gallery_pagetitle_gallery}</a> > {$flolang->gallery_pagetitle_character} > <a href='" . $florensia->outlink(array("characterdetails", $character->data['charname']), $character->merge_opt_link()) . "'>" . $florensia->escape($character->data['charname']) . "</a></div>";
} else {
//images found!
$pageselect = $florensia->pageselect($linkedimages, array("gallery", "c", $character->data['charname']), $pageselectoption, $galleryimagelimit);
$pagetitle = "<div class='subtitle' style='margin-bottom:3px;'><a href='" . $florensia->outlink(array("gallery")) . "'>{$flolang->gallery_pagetitle_gallery}</a> > {$flolang->gallery_pagetitle_character} > <a href='" . $florensia->outlink(array("characterdetails", $character->data['charname']), $character->merge_opt_link()) . "'>" . $florensia->escape($character->data['charname']) . "</a></div>";
$dbimagequery = "SELECT * FROM flobase_character_gallery as c, flobase_gallery as g WHERE c.galleryid=g.galleryid AND c.characterid='{$character->data['characterid']}' {$dborderby} LIMIT " . $pageselect['pagestart'] . ",{$galleryimagelimit}";
}
$tabbar['details'] = array("link" => $florensia->outlink(array("characterdetails", $character->data['charname']), $character->merge_opt_link()), "name" => $flolang->tabbar_title_characterdetails, "desc" => $flolang->tabbar_desc_characterdetails);
$tabbar['gallery'] = array("anchor" => "gallery", "name" => $flolang->tabbar_title_gallery, "desc" => $flolang->sprintf($flolang->tabbar_desc_gallery, $linkedimages));
// $tabbar['friends'] = array("link"=>$florensia->outlink(array("characterdetails", $character->data['charname']), $character->merge_opt_link(), array("anchor"=>"friends")), "name"=>$flolang->tabbar_title_character_friends, "desc"=>$flolang->sprintf($flolang->tabbar_desc_character_friends, "xxx"));
if ($character->is_owner() || $flouser->get_permission("character", "owneroverride")) {
$tabbar['settings'] = array("link" => $florensia->outlink(array("characterdetails", $character->data['charname']), $character->merge_opt_link(), array('anchor' => 'settings')), "name" => $flolang->tabbar_title_character_settings);
}
$tabbar = $florensia->tabbar($tabbar, array("starttab" => "gallery"));
$florensia->sitetitle("Character");
$florensia->sitetitle($character->data['charname']);
}
$pagetitle .= "<div class='subtitle' style='text-align:center; margin-bottom:15px; margin-top:10px;'>{$flolang->character_jumpto} " . $florensia->quicksearch() . "</div>";
} else {
//guild's images
if (!intval($_GET['guild'])) {
$pagetitle = "<div class='subtitle' style='margin-bottom:3px;'><a href='" . $florensia->outlink(array("gallery")) . "'>{$flolang->gallery_pagetitle_gallery}</a> > {$flolang->gallery_pagetitle_guild}</div>";
$notice = "<div class='small' style='margin-top:10px; border-bottom:1px solid; font-weight:bold;'>{$flolang->gallery_overview_error_guild_nosuchguild}</div>";
} else {
$guild = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT guildid, guildname, server FROM flobase_guild WHERE guildid='" . intval($_GET['guild']) . "'"));
list($linkedimages) = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT COUNT(galleryid) FROM flobase_guild_gallery WHERE guildid='{$guild['guildid']}'"));
$lastactivity .= "\n <div id='recentactivity_invisible' style='font-weight:normal; display:none;'>\n {$tmp['recentactivity_invisible']}\n <a href='javascript:switchlayer(\"recentactivity_visible,recentactivity_invisible\", \"recentactivity_visible\")'>{$flolang->notice_showless}</a>\n </div>\n ";
}
}
//else $lastactivity = "<div style='font-weight:normal;'>{$flolang->character_recentupdates_invisiblenotice}</div>";
$lastactivity = "\n <div class='subtitle small' style='padding:10px; margin-bottom:15px;'>\n {$lastactivity}\n </div>\n ";
//any uploaded pictures?
list($characterimages) = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT COUNT(*) FROM flobase_character_gallery WHERE characterid='{$character->data['characterid']}'"));
$galleryoptlink = $character->merge_opt_link(array());
$tabbar['details'] = array("anchor" => "details", "name" => $flolang->tabbar_title_characterdetails, "desc" => $flolang->tabbar_desc_characterdetails);
$tabbar['gallery'] = array("link" => $florensia->outlink(array("gallery", "c", $character->data['charname']), $galleryoptlink), "name" => $flolang->tabbar_title_gallery, "desc" => $flolang->sprintf($flolang->tabbar_desc_gallery, $characterimages));
//$tabbar['friends'] = array("anchor"=>"friends", "name"=>$flolang->tabbar_title_character_friends, "desc"=>$flolang->sprintf($flolang->tabbar_desc_character_friends, "xxx");
//verified? if not show link to verify, otherwhise verified-notice and, if user is the registered and verified owner, show settings-tag
if (!$character->data['ownerid'] && !$character->is_archiv()) {
$verifiednotice = "<a href='" . $florensia->outlink(array("charapi", "verify", $character->data['charname'])) . "'>{$flolang->character_api_verify_link_fromcharacterdetails}</a>";
}
if ($character->is_owner()) {
//settings-tab
$tabbar['settings'] = array("anchor" => "settings", "name" => $flolang->tabbar_title_character_settings);
if ($flouser->get_permission("character", "moderate") && $character->data['ownerid']) {
$verifiednotice = $flouserdata->get_username($character->data['ownerid']);
}
//saving settings
if ($_POST['save_settings']) {
//handling of avatar
$avatarpath = "{$florensia->root_abs}/pictures/character_avatars/{$character->data['characterid']}";
if ($_POST['rm_avatar'] && is_file($avatarpath)) {
if (unlink($avatarpath)) {
if (!MYSQL_QUERY("UPDATE flobase_character_data SET avatar_size='' WHERE characterid='{$character->data['characterid']}'")) {
$error = true;
}
$character->data['avatar_size'] = "";
