if ($exchangetype == "sell" or $exchangetype == "buy") {
$exchangedb = "AND flobase_usermarket.exchangetype='{$exchangetype}'";
$selectexchangetype[$exchangetype] = "selected='selected'";
if ($exchangetype == "buy") {
$marketsitetitle = "<div style='margin-bottom:5px;' class='subtitle'><a href='" . $florensia->outlink(array("market")) . "'>{$flolang->market_title_main}</a> > {$flolang->market_title_buy} {$serversitetitle}</div>";
} else {
$marketsitetitle = "<div style='margin-bottom:5px;' class='subtitle'><a href='" . $florensia->outlink(array("market")) . "'>{$flolang->market_title_main}</a> > {$flolang->market_title_sell} {$serversitetitle}</div>";
}
} else {
$marketsitetitle = "<div style='margin-bottom:5px;' class='subtitle'><a href='" . $florensia->outlink(array("market")) . "'>{$flolang->market_title_main}</a> > {$flolang->market_title_all} {$serversitetitle}</div>";
unset($exchangetype, $exchangedb);
}
$selectexchangetypeform = "\n\t\t<select name='cat'>\n\t\t\t<option value='all'>{$flolang->market_title_all}</option>\n\t\t\t<option value='sell' " . $selectexchangetype['sell'] . ">{$flolang->market_title_sell}</option>\n\t\t\t<option value='buy' " . $selectexchangetype['buy'] . ">{$flolang->market_title_buy}</option>\n\t\t</select>\n\t";
if ($_GET['search']) {
foreach (explode(" ", $_GET['search']) as $keyword) {
$searchstring[] = "server_item_idtable.name_{$stringtable->language} LIKE '%" . get_searchstring($keyword, 0) . "%'";
}
$searchstring = join(" AND ", $searchstring) . " AND";
$marketsitetitle = "<div style='margin-bottom:5px;' class='subtitle'><a href='" . $florensia->outlink(array("market")) . "'>{$flolang->market_title_main}</a> > " . $flolang->sprintf($flolang->market_title_searching, $florensia->escape($_GET['search'])) . " {$serversitetitle}</div>";
}
$query = "SELECT flobase_usermarket.id as marketid, flobase_usermarket.itemid as itemid FROM server_item_idtable, flobase_usermarket WHERE {$searchstring} server_item_idtable.itemid=flobase_usermarket.itemid {$exchangedb} {$serverdb} ORDER BY flobase_usermarket.createtime DESC";
$querystringlist = MYSQL_QUERY($query);
$entries = MYSQL_NUM_ROWS($querystringlist);
$pageselect = $florensia->pageselect($entries, array("market", $exchangetype), array($serverlink));
$querystringlist = MYSQL_QUERY($query . " LIMIT " . $pageselect['pagestart'] . "," . $florensia->pageentrylimit);
while ($itemlist = MYSQL_FETCH_ARRAY($querystringlist)) {
$content .= $florensia->adsense(8);
$item = new floclass_item($itemlist['itemid']);
$content .= "<div class='shortinfo_" . $florensia->change() . "'>" . $item->shortinfo(array("marketid" => $itemlist['marketid'])) . "</div>";
}
if (!$content) {
}
}
if ($_GET['itemid']) {
$item = new floclass_item($_GET['itemid']);
$addtoentry = $item->shortinfo();
foreach (explode(" ", $_GET['search']) as $keyword) {
$searchstring[] = "name_{$stringtable->language} LIKE '%" . get_searchstring($keyword, 0) . "%'";
}
$querystring = "SELECT " . $florensia->get_columnname("npcid", "npc") . " FROM server_npc WHERE " . join(" AND ", $searchstring) . " {$notyetincludedworkaround} AND npc_file='MonsterChar' ORDER BY name_{$stringtable->language}";
$formlink = $florensia->outlink(array("itemdetails", $_GET['itemid'], $stringtable->get_string($_GET['itemid'])), array(), array("anchor" => "droplist"));
$dropentryaddtolist = "\n\t\t\t<input type='hidden' value='" . $florensia->escape($_GET['itemid']) . "' name='itemid'>\n\t\t\t<input type='submit' value='{$flolang->droplist_search_npc}'>\n\t\t";
} else {
$npc = new floclass_npc($_GET['npcid']);
$addtoentry = $npc->shortinfo();
foreach (explode(" ", $_GET['search']) as $keyword) {
$searchstring[] = "name_{$stringtable->language} LIKE '%" . get_searchstring($keyword, 0) . "%'";
}
#ignore cashshoptables
$querystring = "SELECT itemid FROM server_item_idtable WHERE tableid!='cloakitem' AND tableid!='hatitem' AND tableid!='upgradehelpitem' AND tableid!='sealhelpbreakitem' AND " . join(" AND ", $searchstring) . " ORDER BY name_{$stringtable->language}";
$formlink = $florensia->outlink(array("npcdetails", $_GET['npcid'], $stringtable->get_string($_GET['npcid'])), array(), array("anchor" => "droplist"));
$dropentryaddtolist = "\n\t\t\t<input type='hidden' value='" . $florensia->escape($_GET['npcid']) . "' name='npcid'>\n\t\t\t<input type='submit' value='{$flolang->droplist_search_item}'>\n\t\t";
}
$querystringlist = MYSQL_QUERY($querystring);
for ($i = 1; $entrylist = MYSQL_FETCH_ARRAY($querystringlist); $i++) {
if ($_GET['itemid']) {
list($amount) = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT COUNT(d.dropid) FROM flobase_droplist as d, flobase_droplist_ratings as r WHERE d.dropid=r.dropid AND d.npcid='" . $entrylist[$florensia->get_columnname("npcid", "npc")] . "' AND d.itemid='" . mysql_real_escape_string($_GET['itemid']) . "' AND r.userid='{$flouser->userid}'"));
if ($amount) {
continue;
}
$npc = new floclass_npc($entrylist[$florensia->get_columnname("npcid", "npc")]);
$entryshortinfo = $npc->shortinfo();
if (!$imagesfound['COUNT(galleryid)']) {
$notice = "<div class='small'>" . $flolang->sprintf($flolang->gallery_overview_error_user_noimages, $flouserdata->get_username($userid)) . "</div>";
} else {
$pageselect = $florensia->pageselect($imagesfound['COUNT(galleryid)'], array("gallery", "u", $userid, $flouserdata->get_username($userid, array('rawoutput' => 1))), $pageselectoption, $galleryimagelimit);
$dbimagequery = "SELECT * FROM flobase_gallery WHERE " . join(" AND ", $dbwhere) . " {$dborderby} LIMIT {$pageselect['pagestart']},{$galleryimagelimit}";
}
$pagetitle = "<div class='subtitle' style='margin-bottom:3px;'><a href='" . $florensia->outlink(array("gallery")) . "'>{$flolang->gallery_pagetitle_gallery}</a> > {$flolang->gallery_pagetitle_user} > " . $flouserdata->get_username($userid) . "</div>";
$notice = "<div class='small' style='margin-top:10px; border-bottom:1px solid; font-weight:bold;'>" . $flolang->sprintf($flolang->gallery_overview_user_notice_foundimages, $imagesfound['COUNT(galleryid)'], $flouserdata->get_username($userid)) . "</div>";
$florensia->sitetitle("User");
$florensia->sitetitle($flouserdata->get_username($userid, array('rawoutput' => 1)));
}
} elseif ($_GET['search']) {
//search overview
$searchstring = array();
foreach (explode(" ", $_GET['search']) as $keyword) {
$searchstring[] = "name LIKE '%" . get_searchstring($keyword, 0) . "%'";
}
array_push($dbwhere, "(" . join(" AND ", $searchstring) . ")");
if (count($dbwhere)) {
$dbwhere = "WHERE " . join(" AND ", $dbwhere);
} else {
unset($dbwhere);
}
$imagesfound = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT COUNT(galleryid) FROM flobase_gallery {$dbwhere}"));
$pageselectoption['search'] = $_GET['search'];
$pageselect = $florensia->pageselect($imagesfound['COUNT(galleryid)'], array("gallery"), $pageselectoption, $galleryimagelimit);
$dbimagequery = "SELECT * FROM flobase_gallery {$dbwhere} {$dborderby} LIMIT {$pageselect['pagestart']},{$galleryimagelimit}";
$pagetitle = "<div class='subtitle' style='margin-bottom:3px;'><a href='" . $florensia->outlink(array("gallery")) . "'>{$flolang->gallery_pagetitle_gallery}</a></div>";
$notice = "<div class='small' style='margin-top:10px; border-bottom:1px solid; font-weight:bold;'>" . $flolang->sprintf($flolang->gallery_overview_search_notice_foundimages, $imagesfound['COUNT(galleryid)']) . "</div>";
$florensia->sitetitle("Search");
$florensia->sitetitle($_GET['search']);
}
}
$charlist .= "\n <div class='small shortinfo_" . $florensia->change() . "'>\n <table style='width:100%'><tr>\n <td style='width:50px; text-align:right;'>{$char->data['levelland']} <img src='{$florensia->layer_rel}/land.gif' style='height:11px;' alt='Land'></td>\n <td style='width:50px; padding-right:10px; text-align:right;'>{$char->data['levelsea']} <img src='{$florensia->layer_rel}/sealv.gif' style='height:11px;' alt='Sea'></td>\n <td>{$charname}</td>\n <td style='width:170px'>" . $florensia->escape($char->data['jobclass']) . "</td>\n <td style='width:150px'>{$guild}</td>\n <td style='width:100px'>{$server}</td>\n <td style='text-align:right; padding-right:3px; width:130px'>" . $flolang->sprintf($flolang->character_lastupdate, timetamp2string(date("U") - $char->data['lastupdate'], "m")) . "</td>\n </tr></table>\n </div>\n ";
}
$content = "\n <div class='subtitle' style='margin-bottom:10px;'><a href='{$florensia->root}/characterdetails'>{$flolang->character_sitetitle}</a></div>\n <div class='small' style='font-weight:bold; margin-bottom:10px; text-align:center;'>{$flolang->character_overview_selectchar}</div>\n <div class='subtitle' style='margin-bottom:7px;'>\n <table style='width:100%'><tr>\n <td style='width:50px; text-align:right;'><img src='{$florensia->layer_rel}/land.gif' style='height:13px;' alt='Land'></td>\n <td style='width:50px; padding-right:10px; text-align:right;'><img src='{$florensia->layer_rel}/sealv.gif' style='height:13px;' alt='Sea'></td>\n <td>{$flolang->character_title_charname}</td>\n <td style='width:170px'>{$flolang->character_title_jobclass}</td>\n <td style='width:150px'>{$flolang->character_title_guild}</td>\n <td style='width:100px'>{$flolang->character_title_server}</td>\n <td style='text-align:right; padding-right:3px; width:130px'>{$flolang->character_title_lastupdate}</td>\n </tr></table>\n </div>\n {$charlist}\n \n <div class='subtitle' style='text-align:center; margin-top:20px;'>{$flolang->character_jumpto} " . $florensia->quicksearch() . "</div>\n ";
$florensia->sitetitle("Characterdetails");
$florensia->output_page($content);
}
} else {
if (strlen($_GET['notfound']) or strlen($_GET['search'])) {
if ($_GET['notfound']) {
$_GET['search'] = $_GET['notfound'];
$notfoundnotice = "\n <div class='small subtitle warning' style='font-weight:normal; padding: 3px; background-image:url({$florensia->layer_rel}/gushiptes.png); background-repeat:no-repeat; background-position:780px 5px;'>\n <div style='padding-left:5px; padding-top:5px;'>" . $flolang->sprintf($flolang->character_api_notfound_long, $florensia->escape($_GET['notfound'])) . "</div>\n </div>";
}
$cachelimit = 99;
$querycharsearch = MYSQL_QUERY("SELECT charname, server, guild, guildid FROM flobase_character_data as d, flobase_character as c WHERE c.characterid=d.characterid AND charname LIKE '" . get_searchstring($_GET['search'], 0) . "%' ORDER BY charname LIMIT {$cachelimit}");
for ($i = 0; $charsearch = MYSQL_FETCH_ASSOC($querycharsearch); $i++) {
if ($charsearch['guildid']) {
$charsearch['guild'] = ", <a href='" . $florensia->outlink(array('guilddetails', $charsearch['guildid'], $charsearch['server'], $charsearch['guild'])) . "'>" . $florensia->escape($charsearch['guild']) . "</a>";
} elseif ($charsearch['guild']) {
$charsearch['guild'] = ", " . $florensia->escape($charsearch['guild']);
}
$cachedlist[$i % 3] .= "<a href='" . $florensia->outlink(array('characterdetails', $charsearch['charname'])) . "'>" . $florensia->escape($charsearch['charname']) . "</a>, " . $florensia->escape($charsearch['server']) . "{$charsearch['guild']}<br />";
}
if ($cachedlist) {
if ($_GET['notfound']) {
$notfoundnotice .= "<div style='margin-top:10px;'>" . $flolang->sprintf($flolang->character_api_notfound_cachedline, $cachelimit) . "</div>";
}
$cachedlist = "\n <div>\n <table style='width:100%; margin-top:5px; font-weight:normal;' class='subtitle'>\n <tr><td style='width:33%;'>{$cachedlist[0]}</td><td style='width:33%;'>{$cachedlist[1]}</td><td>{$cachedlist[2]}</td></tr>\n </table>\n </div>";
}
$searched = "<div class='borderd small' style='margin-top:15px;'>\n {$notfoundnotice}\n {$cachedlist}\n </div>";
if ($_GET['questtype'] == "sea") {
$queryquesttype = "{$and} server_questlist.questtype='s'";
$and = "AND";
} elseif ($_GET['questtype'] == "land") {
$queryquesttype = "{$and} server_questlist.questtype='l'";
$and = "AND";
} else {
$_GET['questtype'] = "all";
}
}
$questtypeselected[$_GET['questtype']] = "selected='selected'";
$selectoverviewquesttype = "\n\t\t<select name='questtype' class='small'>\n\t\t\t<option value='all'>{$flolang->questtype_all}</option>\n\t\t\t<option value='land' " . $questtypeselected['land'] . ">{$flolang->questtype_land}</option>\n\t\t\t<option value='sea' " . $questtypeselected['sea'] . ">{$flolang->questtype_sea}</option>\n\t\t</select>\n\t";
//search
if (isset($_GET['search']) && trim($_GET['search']) != "") {
foreach (explode(" ", $_GET['search']) as $keyword) {
$searchstring[] = "server_questlist.questtitle_{$classquesttext->language} LIKE '%" . get_searchstring($keyword, 0) . "%'";
}
$queryquestsearch .= "{$and} " . join(" AND ", $searchstring);
$searchtitle = "\n\t\t\t<div class='subtitle' style='margin-bottom:5px;'>" . $flolang->sprintf($flolang->questsearching, $florensia->escape($_GET['search'])) . "</div>\n\t\t";
}
$querystringquest = "SELECT * FROM server_questlist WHERE {$queryquestlevel} {$queryquesttype} {$queryquestsearch} ORDER BY questlevel, questtitle_" . $classquesttext->language;
$maxquests = MYSQL_NUM_ROWS(MYSQL_QUERY($querystringquest));
$pageselect = $florensia->pageselect($maxquests, array("questoverview", "level-" . intval($_GET['level']) . "-{$endlevel}", "type-{$_GET['questtype']}"));
$queryquestlist = MYSQL_QUERY($querystringquest . " LIMIT " . $pageselect['pagestart'] . "," . $florensia->pageentrylimit);
while ($questlist = MYSQL_FETCH_ARRAY($queryquestlist)) {
//workaround "deleted" quests
if ($classquest->get_shortinfo($questlist, array('npclink' => 1))) {
$content .= $florensia->adsense(13);
$content .= "\n\t\t\t\t<div class='shortinfo_" . $florensia->change() . "'>" . $classquest->get_shortinfo($questlist, array('npclink' => 1)) . "</div>\n\t\t\t";
}
}
<?php
require_once "./init.php";
if (!defined('is_florensia')) {
die('Hacking attempt');
}
// $flolang->load("market");
if ($_GET['search']) {
$content = "\n\t\t<div class='subtitle'><a href='" . $florensia->outlink(array("market")) . "'>{$flolang->market_title_main}</a></div>\n\t\t<div style='text-align:center; margin-bottom:15px;''>" . $florensia->quicksearch(array('language' => true)) . "</div>\n\t";
$query = "SELECT forum_users.uid as userid, forum_users.username as username FROM forum_users, flobase_usermarket WHERE forum_users.uid=flobase_usermarket.userid AND forum_users.username LIKE '%" . get_searchstring($_GET['search'], 0) . "%' GROUP BY forum_users.username";
$queryforumuser = MYSQL_QUERY($query);
$entries = MYSQL_NUM_ROWS($queryforumuser);
if ($entries == 1 && $globalentries > 1) {
$forumuser = MYSQL_FETCH_ARRAY($queryforumuser);
header("Location: " . $florensia->outlink(array("usermarket", $forumuser['userid'], $forumuser['username']), array("escape" => FALSE)));
die;
} elseif ($entries == 0) {
$content .= "\n\t\t\t<div class='bordered small' style='text-align:center; margin-bottom:15px;'>{$flolang->market_usermarket_search_ignorenotice}</div>\n\t\t\t<div style='text-align:center' class='warning'>{$flolang->market_noentries}</div>\n\t\t";
$florensia->output_page($content);
}
$pageselect = $florensia->pageselect($entries, array("usermarket"));
$queryforumuser = MYSQL_QUERY($query . " LIMIT " . $pageselect['pagestart'] . "," . $florensia->pageentrylimit);
while ($forumuser = MYSQL_FETCH_ARRAY($queryforumuser)) {
$marketentries = MYSQL_NUM_ROWS(MYSQL_QUERY("SELECT id FROM flobase_usermarket WHERE userid='{$forumuser['userid']}'"));
$userlist .= "<div class='shortinfo_" . $florensia->change() . " small'>\n\t\t\t\t\t\t<table style='width:100%'><tr>\n\t\t\t\t\t\t\t<td style='width:200px;'><a href='" . $florensia->outlink(array("usermarket", $forumuser['userid'], $forumuser['username'])) . "'>" . $florensia->escape($forumuser['username']) . "</a></td>\n\t\t\t\t\t\t\t<td>" . $flolang->sprintf($flolang->market_usermarket_search_user_entries, $marketentries) . "</td>\n\t\t\t\t\t\t</tr></table>\n\t\t\t\t\t</div>";
}
if (!$userlist) {
$userlist = "<div style='text-align:center' class='warning'>{$flolang->market_noentries}</div>";
}
$content .= "\n\t\t\t<div class='bordered small' style='text-align:center; margin-bottom:15px;'>{$flolang->market_usermarket_search_ignorenotice}</div>\n\t\t\t<div style='margin-bottom:10px;'>" . $pageselect['selectbar'] . "</div>\n\t\t\t{$userlist}\n\t\t\t<div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n\t";
$florensia->output_page($content);
$guildoverview = "\n <div class='small' style='float:right; font-weight:bold;'>{$verifiednotice}</div>\n <div style='margin-top:10px;'>{$tabbar['tabbar']}</div>\n <a name='details'></a>\n <div name='details'>\n {$guildlogo}\n <div class='subtitle small' style='min-height:190px; padding:5px;'>\n {$archivimage}\n {$guildranking}\n <div style='margin-right:150px;'>\n <table style='width:100%;'>\n <tr><td style='width:150px;'>{$flolang->guild_title_guildname}</td><td>" . $florensia->escape($guild['guildname']) . " " . floclass_guild::get_language_pic($guild['misc_language']) . "</td></tr>\n <tr><td>{$flolang->guild_title_server}</td><td><a href='{$florensia->root}/statistics/" . $florensia->escape($guild['server']) . "'>" . $florensia->escape($guild['server']) . "</a></td></tr>\n {$deletedguildnotice}\n {$memberlistoverall}\n {$guildcontactlist}\n </table>\n </div>\n {$privacynotice}\n </div>\n {$guilddescription}\n {$wantedlist}\n " . $florensia->adsense(0) . "\n </div>\n {$memberlist}\n {$latestactivity}\n {$guildsettings}\n {$tabbar['jscript']}\n ";
$pagetitle = "<div class='subtitle' style='margin-bottom:10px;'><a href='{$florensia->root}/guilddetails'>{$flolang->guild_sitetitle}</a> > <a href='" . $florensia->outlink(array('guildranking'), array('server' => $guild['server'], 'order' => 'name')) . "'>" . $florensia->escape($guild['server']) . "</a> > " . $florensia->escape($guild['guildname']) . "</div>";
$florensia->sitetitle($florensia->escape($guild['server']));
$florensia->sitetitle($florensia->escape($guild['guildname']));
} else {
$pagetitle = "<div class='subtitle' style='margin-bottom:10px;'><a href='{$florensia->root}/guilddetails'>{$flolang->guild_sitetitle}</a></div>";
$guildoverview = "<div class='warning'>" . $flolang->sprintf($flolang->guild_error_notfound, "<a href='" . $florensia->outlink(array('charapi')) . "' target='_blank'>{$flolang->character_api_form_guild_forceupdate_url_readwhy}</a>") . "</div>";
}
} elseif (strlen($_GET['search']) > 0) {
/*if (strlen($_GET['notfound']) OR strlen($_GET['search'])) {
if ($_GET['notfound']) {
$_GET['search'] = $_GET['notfound'];
$notfoundnotice = "<b>".$flolang->sprintf($flolang->character_api_notfound_long, $florensia->escape($_GET['notfound']))."</b>";
}*/
$cachelimit = 100;
$queryguildsearch = MYSQL_QUERY("SELECT memberamount, server, guildname, guildid FROM flobase_guild WHERE guildname LIKE '%" . get_searchstring($_GET['search'], 0) . "%' AND memberamount!='0' ORDER BY guildname LIMIT {$cachelimit}");
for ($i = 0; $guildsearch = MYSQL_FETCH_ASSOC($queryguildsearch); $i++) {
$cachedlist[$i % 3] .= "<a href='" . $florensia->outlink(array('guilddetails', $guildsearch['guildid'], $guildsearch['server'], $guildsearch['guildname'])) . "'>" . $florensia->escape($guildsearch['guildname']) . "</a>, " . $florensia->escape($guildsearch['server']) . " ({$guildsearch['memberamount']} Member)<br />";
}
if ($cachedlist) {
$cachedlist = "\n <div style='margin-top:10px;'>" . $flolang->sprintf($flolang->guild_api_notfound_cachedline, $cachelimit) . "</div>\n <div>\n <table style='width:100%; margin-top:5px; font-weight:normal;' class='subtitle'>\n <tr><td style='width:33%;'>{$cachedlist[0]}</td><td style='width:33%;'>{$cachedlist[1]}</td><td>{$cachedlist[2]}</td><td>{$cachedlist[3]}</td></tr>\n </table>\n </div>";
}
$searched = "<div class='borderd small' style='margin-top:15px;'>\n <div class='warning'>" . $flolang->sprintf($flolang->guild_error_notfound, "<a href='" . $florensia->outlink(array('charapi')) . "' target='_blank'>{$flolang->character_api_form_guild_forceupdate_url_readwhy}</a>") . "</div>\n {$cachedlist}\n </div>";
$pagetitle = "<div class='subtitle' style='margin-bottom:10px;'><a href='{$florensia->root}/guilddetails'>{$flolang->guild_sitetitle}</a></div>";
$florensia->sitetitle("Search");
} else {
$tmptime = date("U");
$queryrecent = MYSQL_QUERY("SELECT c.charname, l.action, l.guildid, g.guildname, g.server, l.timestamp, g.memberamount, l.oldguildgrade, l.newguildgrade FROM flobase_character_log_guild as l, flobase_guild as g, flobase_character as c , flobase_character_data as d WHERE timestamp>" . bcsub(date("U"), 60 * 60 * 48) . " AND l.guildid=g.guildid AND c.characterid=l.characterid AND d.characterid=l.characterid AND (g.priv_activity_guild='a' OR g.priv_activity_guild='') AND (d.priv_log_guild='' OR d.priv_log_guild='a') AND (l.action='l' OR l.action='a' OR l.action='j') ORDER BY timestamp DESC LIMIT 30");
while ($recent = MYSQL_FETCH_ARRAY($queryrecent)) {
if ($recent['memberamount']) {
$guildlink = "<a href='" . $florensia->outlink(array("guilddetails", $recent['guildid'], $recent['server'], $recent['guildname'])) . "'>" . $florensia->escape($recent['guildname']) . "</a>";
