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'] = "";