$noteslistcontent = "\n <a name='usernotes'></a>\n <div name='usernotes' class='small'>\n <div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n {$noteslistcontent}\n <div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n </div>\n ";
}
if ($userid == $flouser->userid or $flouser->get_permission("watch_log")) {
$querystring = "SELECT class, classid FROM flobase_addition WHERE entrystatus LIKE '%,{$userid},%'";
$flagsquery = MYSQL_QUERY($querystring);
$amountflags = MYSQL_NUM_ROWS($flagsquery);
$tabbar['flags']['desc'] = $flolang->sprintf($flolang->contributed_tabbar_desc_flags, $amountflags);
$pageselect = $florensia->pageselect($amountflags, array("contributed", $userid, $username), array('anchor' => 'flags'), 20);
$flagsquery = MYSQL_QUERY($querystring . " ORDER BY class LIMIT " . $pageselect['pagestart'] . ",20");
while ($flags = MYSQL_FETCH_ARRAY($flagsquery)) {
switch ($flags['class']) {
case "npc":
$npc = new floclass_npc($flags['classid']);
$flagscontent .= "<div class='shortinfo_" . $florensia->change() . "'>" . $npc->shortinfo() . "</div>";
break;
case "item":
$item = new floclass_item($flags['classid']);
$flagscontent .= "<div class='shortinfo_" . $florensia->change() . "'>" . $item->shortinfo() . "</div>";
break;
case "quest":
$flagscontent .= "<div class='shortinfo_" . $florensia->change() . "'>" . $classquest->get_shortinfo($flags['classid']) . "</div>";
break;
}
}
$flagscontent = "\n <a name='flags'></a>\n <div name='flags'>\n <div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n {$flagscontent}\n <div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n </div>\n ";
}
$tabbar = $florensia->tabbar($tabbar);
$content = "\n <div style='margin-bottom:5px;' class='subtitle'>" . $flouserdata->get_username($contributeduser->userid) . " > {$flolang->contributed_pagetitle}</div>\n {$tabbar['tabbar']}\n {$maplistcontent}\n {$droplistcontent}\n {$noteslistcontent}\n {$flagscontent}\n {$tabbar['jscript']}\n";
$florensia->sitetitle($flolang->contributed_pagetitle);
$florensia->sitetitle($florensia->escape($username));
$florensia->output_page($content);
if (isset($item->data[$florensia->get_columnname("getrandomboxitem0id", "item")])) {
for ($i = 0; $i < 100; $i++) {
if ($item->data[$florensia->get_columnname("getrandomboxitem{$i}id", "item")] == "#" or $item->data[$florensia->get_columnname("getrandomboxitem{$i}count", "item")] == "0" or $item->data[$florensia->get_columnname("getrandomboxitem{$i}probability", "item")] == "0") {
break;
} elseif ($item->data[$florensia->get_columnname("getrandomboxitem{$i}id", "item")] == "money") {
#$probability[$i] = $item->data[$florensia->get_columnname("getrandomboxitem{$i}probability", "item")];
$getrandomboxitem .= "\n\t\t\t\t\t\t<div class='shortinfo_" . $florensia->change() . "'>\n\t\t\t\t\t\t\t<table width='100%' style='border-collapse:0px; border-spacing:0px; padding:0px;'>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td style='vertical-align:top; color:rgb(153,204,255);' colspan='3'>Gelt</td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td rowspan='2' style='width:32px; vertical-align:top'></td>\n\t\t\t\t\t\t\t\t\t<td style='width:10px;'></td><td class='small' style='vertical-align:top'>{$flolang->itemrandomboxcount} " . $item->data[$florensia->get_columnname("getrandomboxitem{$i}count", "item")] . "</td>\n\t\t\t\t\t\t\t\t</tr>";
# <tr>
# <td style='width:10px;'></td><td class='small' style='vertical-align:top'>{$flolang->itemrandomboxprobability}: ".bcdiv($item->data[$florensia->get_columnname("getrandomboxitem{$i}probability", "item")], 100, 3)."%</td>
# </tr>
$getrandomboxitem .= "\t</table>\n\t\t\t\t\t\t</div>";
continue;
}
#$probability[$i] = $item->data[$florensia->get_columnname("getrandomboxitem{$i}probability", "item")];
#$getrandomboxitem .= "<div class='shortinfo_".$florensia->change()."'>".$classitem->get_shortinfo($item->data[$florensia->get_columnname("getrandomboxitem{$i}id", "item")], array(), array('Count'=>$item->data[$florensia->get_columnname("getrandomboxitem{$i}count", "item")], $flolang->itemrandomboxprobability=>bcdiv($item->data[$florensia->get_columnname("getrandomboxitem{$i}probability", "item")], 100, 3)."%"))."</div>";
$itembox = new floclass_item($item->data[$florensia->get_columnname("getrandomboxitem{$i}id", "item")]);
$getrandomboxitem .= "<div class='shortinfo_" . $florensia->change() . "'>" . $itembox->shortinfo(array(), array('Count' => $item->data[$florensia->get_columnname("getrandomboxitem{$i}count", "item")])) . "</div>";
}
}
if (isset($getrandomboxitem)) {
$randomboxitem = "\n\t\t\t\t\t<div class='bordered' style='margin-top:5px;'>{$flolang->itemrandomboxsubtitle}</div>\n\t\t\t\t\t{$getrandomboxitem}\n\t\t\t\t";
}
//droplist
$ignoredroplist = array('cloakitem', 'hatitem');
/*if ($recipeoverview_targettickets) {
//created by recipe, no drops
$tabbar['droplist']['inactive'] = true;
$tabbar['droplist']['desc'] = $flolang->tabbar_desc_droplist_producedbyrecipe;
}elseif*/
if (!in_array($item->data['tableid'], $ignoredroplist)) {
$droplist = "\n\t\t\t\t\t<div name='droplist' style='margin-bottom:15px; margin-top:15px;'>" . $classdroplist->get_droplist($item->data[$florensia->get_columnname("itemid", "item")], "item") . "</div>\n\t\t\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();
$checkbox = "droplist_thumpsup_" . $florensia->escape($_GET['itemid']) . "_" . $entrylist[$florensia->get_columnname("npcid", "npc")] . "_x";
} else {
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='" . mysql_real_escape_string($_GET['npcid']) . "' AND d.itemid='" . $entrylist['itemid'] . "' AND r.userid='{$flouser->userid}'"));
if ($amount) {
continue;
}
$item = new floclass_item($entrylist['itemid']);
$entryshortinfo = $item->shortinfo();
$checkbox = "droplist_thumpsup_" . $entrylist['itemid'] . "_" . $florensia->escape($_GET['npcid']) . "_x";
}
$content .= $florensia->adsense(10);
$colorchange = $florensia->change();
$content .= "\n\t\t\t\t\t<div style='margin-bottom:5px;'>\n\t\t\t\t\t\t<table style='width:100%' class='small'>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class='shortinfo_{$colorchange}' style='text-align:center; vertical-align:middle; width:50px;'>\n\t\t\t\t\t\t\t\t\t<input type='checkbox' value='1' name='{$checkbox}'>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td style='width:10px;'></td>\n\t\t\t\t\t\t\t\t<td class='shortinfo_{$colorchange}' style='vertical-align:top;'>\n\t\t\t\t\t\t\t\t\t{$entryshortinfo}\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t</div>\n\t\t\t";
if ($i > 30) {
$content .= "<div style='text-align:center' class='warning'>{$flolang->droplist_addform_toomanyresults}</div>";
break;
}
}
if (!$content) {
$content = "<div style='text-align:center' class='warning'>{$flolang->droplist_addform_noentrys}</div>";
}
$content = "\n\t\t\t<div class='bordered' style='margin-bottom:15px;'>{$addtoentry}</div>\n\n\t\t\t<div class='bordered small' style='text-align:right'>\n\t\t\t\t<form action='{$florensia->root}/droplist.php' method='get'>\n\t\t\t\t\t<input type='text' name='search' value='" . $florensia->escape($_GET['search']) . "'>\n\t\t\t\t\t<input type='hidden' value='{$stringtable->language}' name='names'>\n\t\t\t\t\t{$dropentryaddtolist}\n\t\t\t\t</form>\n\t\t\t</div>\n\n\t\t\t<div class='subtitle' style='margin-bottom:5px; margin-top:5px; height:5px;'></div>\n\t\t\t<form action='{$formlink}' method='post'>\n\t\t\t\t{$content}\n\t\t\t\t<div><input type='submit' value='{$flolang->droplist_addform_doverify}' name='do_verify'></div>\n\t\t\t</form>\n\t\t";
$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) {
$content = "<div style='text-align:center' class='warning'>{$flolang->market_noentries}</div>";
}
$content = "\n\t\t{$marketsitetitle}\n\t\t<div style='text-align:center; margin-bottom:5px;'>" . $florensia->quick_select('marketsearch', array('cat' => $exchangetype, 'search' => $_GET['search']), array($flolang->market_title_listitems => $selectexchangetypeform), $settings = array('namesselect' => 1, 'serverselect' => 1)) . "</div>\n\t\t<div style='margin-bottom:10px;'>" . $pageselect['selectbar'] . "</div>\n\t\t{$content}\n\t\t<div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n\t";
}
$content = "<div style='text-align:center; margin-bottom:15px;''>" . $florensia->quicksearch(array('language' => true)) . "</div>\n\t\t{$content}\n\t";
$florensia->output_page($content);
$news_views = $flolang->sprintf($flolang->news_views, $forumnews['views']);
eval("\$news_temp .= \"{$newstemplate}\";");
}
$news .= "\n\t\t<div style='border-bottom:1px #88a9d4 solid; font-weight:bold; margin-top:5px;'>" . $startpagethread[2] . " <a href='{$florensia->forumurl}/syndication.php?fid=" . intval($startpagethread[1]) . "&limit=15'><img src='{$florensia->layer_rel}/rssfeed.png' border='0' style='height:13px;'></a></div>\n\t\t<div>\n\t\t\t<table style='width:100%; border-collapse:0px; border-spacing:0px; padding:0px;' class='small'>\n\t\t\t\t{$news_temp}\n\t\t\t<tr>\n\t\t\t\t<td style='text-align:right' colspan='4'><a href='http://forum.florensia-base.com/forum-" . intval($startpagethread[1]) . ".html' target='_blank'>{$flolang->news_listall}</a></td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t</div>";
}
//---------- market
$classusermarket->refresh();
for ($i = 1; $i <= 2; $i++) {
if ($i == 1) {
$exchangetype = "sell";
} else {
$exchangetype = "buy";
}
$querynewest = MYSQL_QUERY("SELECT id as marketid, itemid FROM flobase_usermarket WHERE exchangetype='{$exchangetype}' ORDER BY createtime DESC LIMIT 4");
while ($newest = MYSQL_FETCH_ARRAY($querynewest)) {
$item = new floclass_item($newest['itemid']);
$newestlist[$exchangetype] .= "<div class='shortinfo_" . $florensia->change() . "'>" . $item->shortinfo(array("marketid" => $newest['marketid'], "namemaxlength" => 30)) . "</div>";
}
if (!$newestlist[$exchangetype]) {
$newestlist[$exchangetype] = "<div class='bordered' style='text-align:center;'>{$flolang->market_noentries}</div>";
}
}
//newest
$market = "\n\t\t<div class='subtitle'style='margin-top:30px;'><a href='" . $florensia->outlink(array("market")) . "'>{$flolang->market_title_main}</a> > {$flolang->market_title_newest} <a href='{$florensia->root}/market_en.rss'><img src='{$florensia->layer_rel}/rssfeed.png' border='0' style='height:13px;'></a></div>\n\t\t<div>\n\t\t\t<table style='width:100%;' class='small'>\n\t\t\t\t<tr><td class='bordered' style='text-align:center; width:49%; font-weight:bold;'>{$flolang->market_subtitle_sell}</td><td></td><td class='bordered' style='text-align:center; width:49%; font-weight:bold;'>{$flolang->market_subtitle_buy}</td></tr>\n\t\t\t\t<tr><td colspan='3' style='height:2px;'></td></tr>\n\t\t\t\t<tr><td>{$newestlist['sell']}</td><td></td><td>{$newestlist['buy']}</td></tr>\n\t\t\t</table>\n\t\t</div>\n\t";
//$florensia->notice("<div class='warning' style='margin-bottom:10px;'>{$flolang->signature_api_failnotice}</div>");
$searchlangtmp = array('fr', 'nl', 'pl', 'it', 'ru');
foreach ($searchlangtmp as $langkey) {
$searchlang[] = "<img src='{$florensia->layer_rel}/flags/png/" . $flolang->lang[$langkey]->flagid . ".png' alt='" . $flolang->lang[$langkey]->languagename . "' title='" . $flolang->lang[$langkey]->languagename . "' style='border:none; margin-top:3px; margin-bottom:3px;'>";
}
$searchlang[] = "<img src='{$florensia->layer_rel}/flags/png/jp.png' alt='Japanese' title='Japanese' style='border:none; margin-top:3px; margin-bottom:3px;'>";
##### donate-graphic
function get_droplist($dbid, $act = "item")
{
global $flolang, $florensia, $stringtable, $flouser, $flouserdata, $classquest, $classvote;
//db-work
foreach ($_POST as $postkey => $postvalue) {
if (preg_match('/^droplist_(thumpsup|thumpsdown|withdraw|selected)_([a-z0-9]+)_([a-z0-9]+)_x$/', $postkey, $dbkey)) {
if ($dbkey[1] == "selected") {
if (!$_POST['do_selected'] or !($_POST['action_selected'] == "thumpsdown" or $_POST['action_selected'] == "thumpsup" or $_POST['action_selected'] == "withdraw" or $flouser->get_permission("mod_droplist", "delete") && $_POST['action_selected'] == "delete" or $flouser->get_permission("mod_droplist", "verify") && ($_POST['action_selected'] == "verified" or $_POST['action_selected'] == "unverified"))) {
next;
}
$dbkey[1] = $_POST['action_selected'];
}
$florensia->notice($this->updateentry($dbkey[2], $dbkey[3], $dbkey[1]));
}
}
if ($act == "item") {
$querystring = "SELECT d.dropid, itemid, npcid, thumpsup, thumpsdown, COUNT(v.userid) as vusers, COUNT(q.questid) as quests FROM flobase_droplist as d LEFT JOIN flobase_droplist_verified as v ON (v.dropid=d.dropid) LEFT JOIN flobase_droplist_quest as q ON (q.dropid=d.dropid) WHERE itemid='" . mysql_real_escape_string($dbid) . "' GROUP BY d.dropid ORDER BY thumpsup DESC, thumpsdown";
$droplisttitle = $flolang->sprintf($flolang->droplist_title_npc, $stringtable->get_string($dbid, array('protectionsmall' => 1)));
$dropentryaddtolist = "\n\t\t\t\t\t<input type='hidden' value='" . $florensia->escape($dbid) . "' name='itemid'>\n\t\t\t\t\t<input type='submit' value='{$flolang->droplist_search_npc}'>\n\t\t\t\t";
} else {
$querystring = "SELECT d.dropid, itemid, npcid, thumpsup, thumpsdown, COUNT(v.userid) as vusers, COUNT(q.questid) as quests FROM flobase_droplist as d LEFT JOIN flobase_droplist_verified as v ON (v.dropid=d.dropid) LEFT JOIN flobase_droplist_quest as q ON (q.dropid=d.dropid) WHERE npcid='" . mysql_real_escape_string($dbid) . "' GROUP BY d.dropid ORDER BY thumpsup DESC, thumpsdown";
$droplisttitle = $flolang->sprintf($flolang->droplist_title_item, $stringtable->get_string($dbid, array('protectionsmall' => 1)));
$dropentryaddtolist = "\n\t\t\t\t\t<input type='hidden' value='" . $florensia->escape($dbid) . "' name='npcid'>\n\t\t\t\t\t<input type='submit' value='{$flolang->droplist_search_item}'>\n\t\t\t\t";
}
$querydroplist = MYSQL_QUERY($querystring);
while ($droplist = MYSQL_FETCH_ARRAY($querydroplist)) {
if ($act == "item") {
$npc = new floclass_npc($droplist['npcid']);
$dropentrydetails = $npc->shortinfo();
$adminlogfileid = "{npc:{$droplist['npcid']}}/{item:{$dbid}}";
} else {
$item = new floclass_item($droplist['itemid']);
$dropentrydetails = $item->shortinfo(array('marketlist' => true));
$adminlogfileid = "{npc:{$dbid}}/{item:{$droplist['itemid']}}";
}
$colorchange = 1;
unset($smallentrynotice, $adminverifiedlist);
$droplistlevel = "normal";
if ($droplist['quests']) {
$questquery = MYSQL_QUERY("SELECT questid, droprate FROM flobase_droplist_quest WHERE dropid='{$droplist['dropid']}'");
while ($questdrop = MYSQL_FETCH_ARRAY($questquery)) {
$smallentrynotice = "<br />" . $flolang->sprintf($flolang->droplist_list_notice_questentry, bcdiv(intval($questdrop['droprate']), 10) . "%") . " [<a href='" . $florensia->outlink(array("questdetails", $questdrop['questid'], $classquest->get_title($questdrop['questid']))) . "'>Q</a>]";
}
$colorchange = "droplist_questentry";
$droplistlevel = "questentry";
}
if ($droplist['vusers']) {
$smallentrynotice .= "<br />{$flolang->droplist_list_notice_verifiedentry}";
$colorchange = "droplist_verified";
$droplistlevel = "verified";
}
if ($smallentrynotice) {
$smallentrynotice = "<span style='font-size:90%;'>{$smallentrynotice}</span>";
}
$droplist['thumpsdown'] = 0 - $droplist['thumpsdown'];
if ($flouser->userid) {
$vote = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT rating, timestamp FROM flobase_droplist_ratings WHERE dropid='{$droplist['dropid']}' AND userid='{$flouser->userid}'"));
if ($vote) {
if ($vote['rating'] > 0) {
$droplist['thumpsup'] = "<span style='text-decoration:underline;''>{$droplist['thumpsup']}</span>";
} else {
$droplist['thumpsdown'] = "<span style='text-decoration:underline;'>{$droplist['thumpsdown']}</span>";
}
$verifydetails = "\n\t\t\t\t\t\t\t\t" . $flolang->sprintf($flolang->droplist_quick_verify_alreadyverified_notice, date("m.d.Y", $vote['timestamp'])) . "<br />\n\t\t\t\t\t\t\t\t<span style='font-weight:bold; font-size:150%;'>{$droplist['thumpsup']}/{$droplist['thumpsdown']}</span>\n\t\t\t\t\t\t\t\t<input type='image' name='droplist_withdraw_{$droplist['itemid']}_{$droplist['npcid']}' src='{$florensia->layer_rel}/withdraw.gif' style='background-color:transparent; border:0px; height:18px;'>\n\t\t\t\t\t\t\t";
} else {
$verifydetails = "\n\t\t\t\t\t\t\t\t\t<input type='image' name='droplist_thumpsup_{$droplist['itemid']}_{$droplist['npcid']}' src='{$florensia->layer_rel}/thumpsup.gif' style='background-color:transparent; border:0px; width:15px; height:18px;'>\n\t\t\t\t\t\t\t\t\t<span style='font-weight:bold; font-size:150%; margin-left:4px; margin-right:4px;'>{$droplist['thumpsup']}/{$droplist['thumpsdown']}</span>\n\t\t\t\t\t\t\t\t\t<input type='image' name='droplist_thumpsdown_{$droplist['itemid']}_{$droplist['npcid']}' src='{$florensia->layer_rel}/thumpsdown.gif' style='background-color:transparent; border:0px; width:15px; height:18px;'>\n\t\t\t\t\t\t\t";
}
} else {
$verifydetails = "<span style='font-weight:bold; font-size:150%; margin-left:4px; margin-right:4px;'>{$droplist['thumpsup']}/{$droplist['thumpsdown']}</span><br />{$flolang->droplist_quick_notloggedin}";
}
if ($flouser->get_permission("add_droplist")) {
$quickselect = "<input type='checkbox' name='droplist_selected_{$droplist['itemid']}_{$droplist['npcid']}_x' value='1'>";
} else {
unset($quickselect);
}
if ($flouser->get_permission("mod_droplist", "contributed")) {
$rating = array("up" => array(), "down" => array());
$userquery = MYSQL_QUERY("SELECT r.timestamp, r.userid, r.rating, v.userid as verified FROM flobase_droplist_ratings as r LEFT JOIN flobase_droplist_verified as v ON (v.dropid=r.dropid AND v.userid=r.userid) WHERE r.dropid='{$droplist['dropid']}' ORDER BY r.timestamp");
while ($user = MYSQL_FETCH_ARRAY($userquery)) {
$cat = $user['rating'] > 0 ? "up" : "down";
if ($user['verified']) {
$rating[$cat][] = date("m.d.y", $user['timestamp']) . ": <span style='text-decoration:underline;'>" . $flouserdata->get_username($user['userid']) . "</span>";
} else {
$rating[$cat][] = date("m.d.y", $user['timestamp']) . ": " . $flouserdata->get_username($user['userid']);
}
}
$contributed = "\n\t\t\t\t\t\t\t<table class='small' style='width:100%'>\n\t\t\t\t\t\t\t\t<tr><td style='text-align:center; width:50%;'><img src='{$florensia->layer_rel}/thumpsup.gif' alt='ThumpsUp' style='width:10px; height:13px;'></td><td style='text-align:center;'><img src='{$florensia->layer_rel}/thumpsdown.gif' alt='ThumpsDown' style='width:10px; height:13px;'></td></tr>\n\t\t\t\t\t\t\t\t<tr><td>" . join("<br>", $rating['up']) . "</td><td>" . join("<br>", $rating['down']) . "</td></tr>\n\t\t\t\t\t\t\t</table>";
$adminuserlist = "\n\t\t\t\t\t\t\t\t\t<td style='width:5px;'></td>\n\t\t\t\t\t\t\t\t\t<td class='shortinfo_{$colorchange}' style='width:10px; vertical-align:top;'>\n\t\t\t\t\t\t\t\t\t\t<span " . popup("<div class='shortinfo_{$colorchange}' style='width:450px'>{$contributed}</div>", "LEFT, MOUSEOFF, STICKY") . ">C</span>\n\t\t\t\t\t\t\t\t\t\t<a href='{$florensia->root}/adminlog?section=droplist&logvalue=" . urlencode($adminlogfileid) . "' target='_blank'>L</a>\n\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t";
} else {
unset($adminuserlist);
}
$droplistcontent[$droplistlevel] .= $florensia->adsense(8) . "\n\t\t\t\t\t\t<div style='margin-bottom:5px;'>\n\t\t\t\t\t\t\t<table style='width:100%' class='small'>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td class='shortinfo_{$colorchange}' style='vertical-align:top; width:650px;'>\n\t\t\t\t\t\t\t\t\t\t{$dropentrydetails}\n\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t\t<td style='width:15px;'>{$quickselect}</td>\n\t\t\t\t\t\t\t\t\t<td class='shortinfo_{$colorchange}' style='text-align:center; vertical-align:middle;'>\n\t\t\t\t\t\t\t\t\t\t{$verifydetails}\n\t\t\t\t\t\t\t\t\t\t{$smallentrynotice}\n\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t\t{$adminuserlist}\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t";
}
unset($quickselect);
if (!$droplistcontent) {
$droplistcontent = "<div class='small bordered' style='text-align:center;'>{$flolang->droplist_list_noentry}</div>";
} else {
$droplistcontent = $droplistcontent['verified'] . $droplistcontent['questentry'] . $droplistcontent['normal'];
if ($flouser->get_permission("add_droplist") or $flouser->get_permission("mod_droplist", "verify") or $flouser->get_permission("mod_droplist", "delete")) {
$quickselect = "\n\t\t\t\t\t\t<div class='small subtitle' style='padding:2px; text-align:right;'>\n\t\t\t\t\t\t\t<select name='action_selected'>\n\t\t\t\t\t\t\t\t<option value='thumpsup'>{$flolang->droplist_quick_thumpsup}</option>\n\t\t\t\t\t\t\t\t<option value='thumpsdown'>{$flolang->droplist_quick_thumpsdown}</option>\n\t\t\t\t\t\t\t\t<option value='withdraw'>{$flolang->droplist_quick_withdraw}</option>";
if ($flouser->get_permission("mod_droplist", "delete")) {
$quickselect .= "<option value='delete'>{$flolang->droplist_quick_delete}</option>";
}
if ($flouser->get_permission("mod_droplist", "verify")) {
$quickselect .= "\n\t\t\t\t\t\t\t\t\t\t<option value='verified'>{$flolang->droplist_quick_verify}</option>\n\t\t\t\t\t\t\t\t\t\t<option value='unverified'>{$flolang->droplist_quick_unverify}</option>\n\t\t\t\t\t\t\t\t\t";
}
$quickselect .= "</select>\n\t\t\t\t\t\t\t<input type='submit' name='do_selected' value='{$flolang->droplist_quick_submit}'>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t";
}
}
$whatsthat = "<div style='width:300px;'>\n\t\t\t\t<div class='small shortinfo_" . $florensia->change() . "'>" . $flolang->droplist_whatsthis_title . "</div>\n\t\t\t\t<div class='small'>" . $flolang->droplist_whatsthis_text . "</div>\n\t\t\t</div>\n\t\t\t";
return "\n\t\t\t\t<div class='subtitle small' style='text-align:center'>{$droplisttitle} (<span class='small' style='font-weight:normal;' " . popup($whatsthat) . ">{$flolang->droplist_whatsthis_title}</span>)</div>\n\t\t\t\t<div>\n\t\t\t\t\t<form action='" . $florensia->escape($florensia->request_uri(array(), 'droplist')) . "' method='post'>\n\t\t\t\t\t{$droplistcontent}\n\t\t\t\t\t{$quickselect}\n\t\t\t\t\t</form>\n\t\t\t\t</div>\n\t\t\t\t<div class='subtitle small' style='padding:2px; text-align:right'>\n\t\t\t\t\t<form action='{$florensia->root}/droplist.php' method='get'>\n\t\t\t\t\t\t{$flolang->droplist_list_addentry}\n\t\t\t\t\t\t<input type='text' name='search'>\n\t\t\t\t\t\t<input type='hidden' value='{$stringtable->language}' name='names'>\n\t\t\t\t\t\t{$dropentryaddtolist}\n\t\t\t\t\t</form>\n\t\t\t\t</div>\n\t\t\t";
}
$classusermarket->updateentry($dbkey[2], $dbkey[3], $dbkey[1], $postvalue);
}
}
}
}
for ($i = 1; $i <= 2; $i++) {
if ($i == 1) {
$exchangetype = "sell";
} else {
$exchangetype = "buy";
}
$x = 0;
$querynewest = MYSQL_QUERY("SELECT id as marketid, itemid, exchange, exchangetype FROM flobase_usermarket WHERE exchangetype='{$exchangetype}' AND userid='{$forumuser['uid']}' ORDER BY createtime DESC");
while ($newest = MYSQL_FETCH_ARRAY($querynewest)) {
$colorchange = $florensia->change();
$item = new floclass_item($newest['itemid']);
$marketshortinfo = $item->shortinfo(array("marketid" => $newest['marketid'], 'fullmarketexchange' => 1)) . "\n\t\t\t\t\t<table class='small' style='width:100%'>\n\t\t\t\t\t\t<tr><td>" . $parser->parse_message($newest['exchange'], array("allow_mycode" => 1, "filter_badwords" => 1)) . "</td></tr>\n\t\t\t\t\t</table>\n\t\t\t";
if (!$ownmarket) {
$newestlist[$exchangetype]['content'] .= "\n\t\t\t\t\t<div class='shortinfo_{$colorchange}'>{$marketshortinfo}</div>";
} else {
$newestlist[$exchangetype]['content'] .= "\n\t\t\t\t\t<div style='margin-bottom:5px;'>\n\t\t\t\t\t\t<table style='width:100%' class='small'>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class='shortinfo_{$colorchange}' style='vertical-align:top; width:650px;'>\n\t\t\t\t\t\t\t\t\t{$marketshortinfo}\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td style='width:10px;'></td>\n\t\t\t\t\t\t\t\t<td class='shortinfo_{$colorchange}' style='vertical-align:bottom;'>\n\t\t\t\t\t\t\t\t\t<table style='width:100%;'>\n\t\t\t\t\t\t\t\t\t\t<tr><td style='text-align:right;'>{$flolang->market_private_submit_delete}</td><td style='text-align:right;'><input type='checkbox' name='delete_{$newest['exchangetype']}_{$newest['itemid']}' value='1'></td></tr>\n\t\t\t\t\t\t\t\t\t\t<tr><td style='text-align:right;'>{$flolang->market_private_submit_extend}</td><td style='text-align:right;'><select name='extend_{$newest['exchangetype']}_{$newest['itemid']}'>{$timespan}</select></td></tr>\n\t\t\t\t\t\t\t\t\t\t<tr><td colspan='2' style='height:10px;'></td></tr>\n\t\t\t\t\t\t\t\t\t\t<tr><td colspan='2' style='text-align:center;'><input type='submit' name='do_update_all' value='{$flolang->market_private_submit_updateall}'></td></tr>\n\t\t\t\t\t\t\t\t\t\t<tr><td colspan='2' style='height:15px;'></td></tr>\n\t\t\t\t\t\t\t\t\t\t<tr><td colspan='2' style='text-align:right;'><a href='{$florensia->root}/usermarket.php?exchangetype={$exchangetype}&update={$newest['itemid']}'>{$flolang->market_usermarket_updatelink}</a></td></tr>\n\t\t\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t</div>";
}
$x++;
}
$newestlist[$exchangetype]['amount'] = $x;
}
//newest
$content = "\n\t\t<div class='subtitle'><a href='" . $florensia->outlink(array("market")) . "'>{$flolang->market_title_main}</a> > " . $flolang->sprintf($flolang->market_details_info_usermarketplace, $florensia->escape($forumuser['username'])) . "</div>\n\t\t\n\t\t<div class='small bordered' style='margin-bottom:15px;'>{$flolang->market_contactnotice}</div>\n\t\t{$newestlist['sell']['content']}\n\t\t{$newestlist['buy']['content']}\n\t";
if (!$newestlist['sell']['content'] && !$newestlist['buy']['content']) {
$content .= "<div class='bordered' style='text-align:center;'>{$flolang->market_noentries}</div>";
}
function create_diff_overview($dbtable, $subdiff)
{
global $florensia, $stringtable, $classquest, $flolang;
if (preg_match('/^server_item_(.+)$/', $dbtable, $itemcat)) {
$this->difflist['items']['title'] = $flolang->diff_subtitle_items;
foreach (get_object_vars($subdiff->new) as $newkey => $newvalue) {
$item = new floclass_item($newkey);
$this->difflist['items']['new'] .= "\n \t\t\t\t\t\t\t\t<div><a href='" . $florensia->outlink(array("itemdetails", $newvalue, $stringtable->get_string($newvalue)), array("escape" => FALSE)) . "' target='_blank' " . popup("<div class='shortinfo_" . $florensia->change() . "' style='width:600px;'>" . $item->shortinfo() . "</div>") . ">" . $stringtable->get_string($newvalue, array("protectionsmall" => 1, "protectionlink" => 1)) . "</a></div>\n \t\t\t\t\t\t\t";
}
foreach (get_object_vars($subdiff->diff) as $newkey => $newvalue) {
unset($changes);
foreach ($newvalue as $changekey => $change) {
$changekey_lang = $florensia->get_columnname_backwards($changekey, 'item');
if (preg_match("/{$changekey_lang}/", $changekey) && !preg_match("/^name_/", $changekey_lang)) {
continue;
}
$changes .= "<tr><td style='width:24%; border-right:1px #88a9d4 solid;'>{$changekey_lang}:</td><td style='width:38%; border-right:1px #88a9d4 solid;'>{$change->oldversion}</td><td>{$change->newversion}</td></tr>";
}
if (!$changes) {
continue;
}
$this->difflist['items']['diff'] .= "\n \t\t\t\t\t\t\t\t<div><a href='" . $florensia->outlink(array("itemdetails", $newkey, $stringtable->get_string($newkey)), array("escape" => FALSE)) . "' target='_blank' " . popup("<div class='shortinfo_" . $florensia->change() . "' style='width:600px;'><table style='width:100%;'>{$changes}</table></div>") . ">" . $stringtable->get_string($newkey, array("protectionsmall" => 1, "protectionlink" => 1)) . "</a></div>\n \t\t\t\t\t\t\t";
}
} elseif ($dbtable == "server_npc") {
$this->difflist['npcs']['title'] = $flolang->diff_subtitle_npcs;
foreach (get_object_vars($subdiff->new) as $newkey => $newvalue) {
$npc = new floclass_npc($newkey);
$this->difflist['npcs']['new'] .= "\n \t\t\t\t\t\t\t\t<div><a href='" . $florensia->outlink(array("npcdetails", $newvalue, $stringtable->get_string($newvalue)), array("escape" => FALSE)) . "' target='_blank' " . popup("<div class='shortinfo_" . $florensia->change() . "' style='width:600px;'>" . $npc->shortinfo() . "</div>") . ">" . $stringtable->get_string($newvalue, array("protectionsmall" => 1, "protectionlink" => 1)) . "</a></div>\n \t\t\t\t\t\t\t";
}
foreach (get_object_vars($subdiff->diff) as $newkey => $newvalue) {
unset($changes);
foreach ($newvalue as $changekey => $change) {
$changekey_lang = $florensia->get_columnname_backwards($changekey, 'npc');
if (preg_match("/{$changekey_lang}/", $changekey) && !preg_match("/^name_/", $changekey_lang)) {
continue;
}
$changes .= "<tr><td style='width:150px; border-right:1px #88a9d4 solid;'>{$changekey_lang}:</td><td style='width:225px; border-right:1px #88a9d4 solid;'>{$change->oldversion}</td><td>{$change->newversion}</td></tr>";
}
if (!$changes) {
continue;
}
$this->difflist['npcs']['diff'] .= "\n \t\t\t\t\t\t\t\t<div><a href='" . $florensia->outlink(array("npcdetails", $newkey, $stringtable->get_string($newkey)), array("escape" => FALSE)) . "' target='_blank' " . popup("<div class='shortinfo_" . $florensia->change() . "' style='width:600px;'><table style='width:100%;'>{$changes}</table></div>") . ">" . $stringtable->get_string($newkey, array("protectionsmall" => 1, "protectionlink" => 1)) . "</a></div>\n \t\t\t\t\t\t\t";
}
} elseif ($dbtable == "server_map") {
$this->difflist['maps']['title'] = $flolang->diff_subtitle_maps;
foreach (get_object_vars($subdiff->new) as $newkey => $newvalue) {
$this->difflist['maps']['new'] .= "\n \t\t\t\t\t\t\t\t<div><a href='" . $florensia->outlink(array("mapdetails", $newvalue, $stringtable->get_string($newvalue)), array("escape" => FALSE)) . "' target='_blank' " . popup("<div class='shortinfo_" . $florensia->change() . "' style='text-align:center; width:300px;'>" . $florensia->mapprotection($newvalue, $stringtable->get_string($newvalue), "", array('maxwidth' => 300)) . "</div>") . ">" . $stringtable->get_string($newvalue, array("protectionsmall" => 1, "protectionlink" => 1)) . "</a></div>\n \t\t\t\t\t\t\t";
}
foreach (get_object_vars($subdiff->diff) as $newkey => $newvalue) {
$this->difflist['maps']['diff'] .= "\n \t\t\t\t\t\t\t\t<div><a href='" . $florensia->outlink(array("mapdetails", $newkey, $stringtable->get_string($newkey)), array("escape" => FALSE)) . "' target='_blank' " . popup("<div class='shortinfo_" . $florensia->change() . "' style='text-align:center; width:300px;'>" . $florensia->mapprotection($newkey, $stringtable->get_string($newkey), "", array('maxwidth' => 300)) . "</div>") . ">" . $stringtable->get_string($newkey, array("protectionsmall" => 1, "protectionlink" => 1)) . "</a></div>\n \t\t\t\t\t\t\t";
}
} elseif ($dbtable == "server_questlist") {
$this->difflist['quests']['title'] = $flolang->diff_subtitle_quests;
foreach (get_object_vars($subdiff->new) as $newkey => $newvalue) {
$this->difflist['quests']['new'] .= "\n \t\t\t\t\t\t\t\t<div><a href='" . $florensia->outlink(array("questdetails", $newvalue, $classquest->get_title($newvalue)), array("escape" => FALSE)) . "' target='_blank' " . popup("<div class='shortinfo_" . $florensia->change() . "' style='width:650px;'>" . $classquest->get_shortinfo($newvalue) . "</div>") . ">" . $classquest->get_title($newkey) . "</a></div>\n \t\t\t\t\t\t\t";
}
foreach (get_object_vars($subdiff->diff) as $newkey => $newvalue) {
$this->difflist['quests']['diff'] .= "\n \t\t\t\t\t\t\t\t<div><a href='" . $florensia->outlink(array("questdetails", $newkey, $classquest->get_title($newkey)), array("escape" => FALSE)) . "' target='_blank' " . popup("<div class='shortinfo_" . $florensia->change() . "' style='width:650px;'>" . $classquest->get_shortinfo($newkey) . "</div>") . ">" . $classquest->get_title($newkey) . "</a></div>\n \t\t\t\t\t\t\t";
}
} elseif ($dbtable == "server_skill") {
$this->difflist['skill']['title'] = "Skills";
foreach (get_object_vars($subdiff->new) as $newkey => $newvalue) {
$this->difflist['skill']['new'] .= "\n \t\t\t\t\t\t\t\t<div><span " . popup("<div class='shortinfo_" . $florensia->change() . "' style='width:600px;'><div style='min-height:55px;'>" . $florensia->detailsprotection(substr($newkey, 0, -2) . substr($newkey, -2), "skill") . "</div></div>") . ">Lvl:" . substr($newkey, -2) . " " . $stringtable->get_string($newkey, array("protectionsmall" => 1)) . "</span></div>\n \t\t\t\t\t\t\t";
}
foreach (get_object_vars($subdiff->diff) as $newkey => $newvalue) {
$this->difflist['skill']['diff'] .= "\n \t\t\t\t\t\t\t\t<div><span " . popup("<div class='shortinfo_" . $florensia->change() . "' style='width:600px;'><div style='min-height:55px;'>" . $florensia->detailsprotection(substr($newkey, 0, -2) . substr($newkey, -2), "skill") . "</div></div>") . ">Lvl:" . substr($newkey, -2) . " " . $stringtable->get_string($newkey, array("protectionsmall" => 1)) . "</span></div>\n \t\t\t\t\t\t\t";
}
} elseif ($dbtable == "server_spell") {
$this->difflist['spell']['title'] = "Spells";
foreach (get_object_vars($subdiff->new) as $newkey => $newvalue) {
$this->difflist['spell']['new'] .= "\n \t\t\t\t\t\t\t\t<div><span " . popup("<div class='shortinfo_" . $florensia->change() . "' style='width:600px;'><div style='min-height:55px;'>" . $florensia->detailsprotection(substr($newkey, 0, -2) . substr($newkey, -2), "spell") . "</div></div>") . ">Lvl:" . substr($newkey, -2) . " " . $stringtable->get_string($newkey, array("protectionsmall" => 1)) . "</span></div>\n \t\t\t\t\t\t\t";
}
foreach (get_object_vars($subdiff->diff) as $newkey => $newvalue) {
$this->difflist['spell']['diff'] .= "\n \t\t\t\t\t\t\t\t<div><span " . popup("<div class='shortinfo_" . $florensia->change() . "' style='width:600px;'><div style='min-height:55px;'>" . $florensia->detailsprotection(substr($newkey, 0, -2) . substr($newkey, -2), "spell") . "</div></div>") . ">Lvl:" . substr($newkey, -2) . " " . $stringtable->get_string($newkey, array("protectionsmall" => 1)) . "</span></div>\n \t\t\t\t\t\t\t";
}
}
}