}
$querycharacter = MYSQL_QUERY("SELECT SQL_CALC_FOUND_ROWS charname, levelland, levelsea, levelsum, guild, guildid, guildgrade, jobclass, gender, server, lastupdate FROM flobase_character_data AS d, flobase_character AS c WHERE d.characterid = c.characterid {$dbwhere} {$dborderby} LIMIT {$startpage}, 70");
list($foundrows) = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT FOUND_ROWS()"));
$pageselect = $florensia->pageselect($foundrows, array("ranking"), array("order" => $_GET['order'], "class" => $_GET['class'], "server" => $_GET['server']), 70);
for ($i = $pageselect['pagestart'] + 1; $character = MYSQL_FETCH_ARRAY($querycharacter); $i++) {
if ($character['gender'] == "m") {
$gender = "<img src='{$florensia->layer_rel}/gender_male.gif' border='0' alt='male' style='height:12px;'>";
} else {
$gender = "<img src='{$florensia->layer_rel}/gender_female.gif' border='0' alt='female' style='height:12px;'>";
}
if (strlen($character['guild'])) {
if ($character['guildid']) {
$guild = "<a href='" . $florensia->outlink(array('guilddetails', $character['guildid'], $character['server'], $character['guild'])) . "'>" . $florensia->escape($character['guild']) . "</a>";
} else {
$guild = $florensia->escape($character['guild']);
}
if ($character['guildgrade']) {
$guild = class_character::guildgrade($character['guildgrade']) . " " . $guild;
}
} else {
$guild = "";
}
$characterlist .= $florensia->adsense(20);
$characterlist .= "\n\t\t<div class='shortinfo_" . $florensia->change() . "'>\n\t\t\t<table style='width:100%'><tr>\n\t\t\t\t<td style='width:35px; text-align:right;'>{$i}.</td>\n\t\t\t\t<td style='width:50px; text-align:right;'>" . intval($character['levelsum']) . "</td>\n\t\t\t\t<td style='width:50px; text-align:right;'>" . intval($character['levelland']) . " <img src='{$florensia->layer_rel}/land.gif' style='height:11px;'></td>\n\t\t\t\t<td style='width:50px; padding-right:10px; text-align:right;'>" . intval($character['levelsea']) . " <img src='{$florensia->layer_rel}/sealv.gif' style='height:11px;'></td>\n\t\t\t\t<td>{$gender} <a href='" . $florensia->outlink(array("characterdetails", $character['charname'])) . "'>" . $florensia->escape($character['charname']) . "</a></td>\n\t\t\t\t<td style='width:150px'>" . $florensia->escape($character['jobclass']) . "</td>\n\t\t\t\t<td style='width:140px'>{$guild}</td>\n\t\t\t\t<td style='width:90px'><a href='" . $florensia->outlink(array('statistics', $character['server'])) . "'>" . $florensia->escape($character['server']) . "</a></td>\n\t\t\t\t<td style='text-align:right; padding-right:3px; width:100px'>" . $flolang->sprintf($flolang->character_lastupdate, timetamp2string(date("U") - $character['lastupdate'], "m")) . "</td>\n\t\t\t</tr></table>\n\t\t</div>\n\t";
}
foreach ($florensia->validserver as $server) {
$validserverlinks[] = "<a href='" . $florensia->outlink(array('statistics', $server)) . "'>{$server}</a>";
}
$content = "\n<div class='subtitle'><a href='{$florensia->root}/statistics'>{$flolang->statistic_sitetitle}</a> > {$flolang->statistic_ranking_sitetitle}</div>\n<div class='subtitle small' style='font-weight:normal; margin-bottom:15px;'>" . $flolang->sprintf($flolang->statistic_notice_seealso, join(", ", $validserverlinks)) . "</div>\n\n<div class='bordered' style='font-weight:bold; margin-bottom:15px;'>\n\t" . $florensia->quick_select("ranking", array(), array($flolang->statistic_ranking_quickselect_orderby => $orderbyselect, $flolang->statistic_ranking_quickselect_filterjobclass => $classfilter, $flolang->statistic_ranking_quickselect_filterserver => $serverfilter)) . "\n</div>\n<div style='margin-bottom:8px;'>" . $pageselect['selectbar'] . "</div>\n<div class='subtitle' style='margin-bottom:7px;'>\n\t<table style='width:100%'><tr>\n\t\t<td style='width:35px; text-align:right;'>#</td>\n\t\t<td style='width:50px; text-align:right;'><img src='{$florensia->layer_rel}/land.gif' style='height:13px;'>+<img src='{$florensia->layer_rel}/sealv.gif' style='height:13px;'></td>\n\t\t<td style='width:50px; text-align:right;'><img src='{$florensia->layer_rel}/land.gif' style='height:13px;'></td>\n\t\t<td style='width:50px; padding-right:10px; text-align:right;'><img src='{$florensia->layer_rel}/sealv.gif' style='height:13px;'></td>\n\t\t<td>{$flolang->character_title_charname}</td>\n\t\t<td style='width:150px'>{$flolang->character_title_jobclass}</td>\n\t\t<td style='width:140px'>{$flolang->character_title_guild}</td>\n\t\t<td style='width:90px'>{$flolang->character_title_server}</td>\n\t\t<td style='text-align:right; padding-right:3px; width:100px'>{$flolang->character_title_lastupdate}</td>\n\t</tr></table>\n</div>\n<div class='small'>{$characterlist}</div>\n<div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n";
$florensia->sitetitle("Ranking");
$florensia->output_page($content);
}
}
}
$queryentry = MYSQL_QUERY("SELECT ts.creator, ts.timestamp, g.guildname, g.guildid, g.server, g.memberamount, c.charname, d.guildgrade, u.uid, u.email\nFROM flobase_teamspeak AS ts\nINNER JOIN flobase_guild AS g ON ( g.guildid = ts.guildid )\nLEFT JOIN (\nflobase_character_data AS d\nINNER JOIN flobase_character AS c ON ( d.characterid = c.characterid AND (guildgrade='5' OR ownerid!='0'))\nLEFT JOIN forum_users AS u ON ( u.uid = d.ownerid )\n) ON ( ts.guildid = d.guildid ) ORDER BY g.guildname, d.guildgrade DESC");
//hell ya! - you know what I mean, don't you!?
$tmpguild = 0;
while ($entry = MYSQL_FETCH_ARRAY($queryentry)) {
$linkclass = "";
if (!$entry['memberamount']) {
$linkclass = "class='archiv'";
}
$guildlink = "<a {$linkclass} href='" . $florensia->outlink(array("guilddetails", $entry['guildid'], $entry['server'], $entry['guildname'])) . "'>" . $florensia->escape($entry['guildname']) . "</a>";
if ($tmpguild != $entry['guildid']) {
$bg = $bg == "background-color:#396087;" ? "background-color:#496f96;" : "background-color:#396087;";
$removecheckbox = "<input type='checkbox' name='remove_{$entry['guildid']}' value='{$entry['guildid']}' style='padding:0px; margin:0px;'>";
$addedby = $flouserdata->get_username($entry['creator']);
$addeddate = date("m.d.y", $entry['timestamp']);
$tmpguild = $entry['guildid'];
} else {
unset($guildlink, $entry['server'], $entry['memberamount'], $removecheckbox, $addedby, $addeddate);
}
$username = $entry['uid'] ? $flouserdata->get_username($entry['uid']) : "";
if (!$flouser->get_permission("teamspeak", "mail")) {
unset($entry['email']);
}
$list .= "\n\t<tr>\n\t\t<td style='{$bg} text-align:right; padding-right:5px;'>{$removecheckbox}</td>\n\t\t<td style='{$bg}'>{$guildlink}</td>\n\t\t<td style='{$bg}'>" . $florensia->escape($entry['server']) . "</td>\n\t\t<td style='{$bg} text-align:right; padding-right:5px;'>{$entry['memberamount']}</td>\n\t\t<td style='{$bg}'>" . class_character::guildgrade($entry['guildgrade']) . " <a href='" . $florensia->outlink(array("characterdetails", $entry['charname'])) . "'>" . $florensia->escape($entry['charname']) . "</a></td>\n\t\t<td style='{$bg}'>{$username}</td>\n\t\t<td style='{$bg}'>" . $florensia->escape($entry['email']) . "</td>\n\t\t<td style='{$bg}'>{$addedby}</td>\n\t\t<td style='{$bg} text-align:right; padding-right:5px;'>{$addeddate}</td>\n\t</tr>\t\n\t";
}
$content = "\n<div class='subtitle' style='margin-bottom:10px;'><a href='{$florensia->root}/admincp.php'>AdminCP</a> > Teamspeak</div>\n<form action='{$florensia->root}/adminteamspeak.php' method='POST'>\n\t<table style='width:100%; font-weight:normal;' class='small subtitle'>\n\t\t<tr>\n\t\t\t<td style='border-bottom:1px solid; font-weight:bold; width:15px;'></td>\n\t\t\t<td style='border-bottom:1px solid; font-weight:bold;'>Guildname</td>\n\t\t\t<td style='border-bottom:1px solid; font-weight:bold;'>Server</td>\n\t\t\t<td style='border-bottom:1px solid; font-weight:bold; text-align:right; padding-right:5px;'>Member</td>\n\t\t\t<td style='border-bottom:1px solid; font-weight:bold;'>Leader</td>\n\t\t\t<td style='border-bottom:1px solid; font-weight:bold;'>Owner</td>\n\t\t\t<td style='border-bottom:1px solid; font-weight:bold;'>Email</td>\n\t\t\t<td style='border-bottom:1px solid; font-weight:bold;'>Added by</td>\n\t\t\t<td style='border-bottom:1px solid; font-weight:bold; text-align:right; padding-right:5px;'>Created</td>\n\t\t</tr>\n\t\t{$list}\n\t</table>\n\t<div style='float:right; padding:3px; padding-top:5px;'><input type='submit' name='do_remove' value='Remove selected'></div>\n\t<div class='subtitle small' style='padding:2px;'>\n\t\t\t<input type='text' name='guildid'>\n\t\t\t<input type='submit' name='do_add' value='Add GuildID to list'>\n\t</div>\n</form>\n";
$florensia->sitetitle("AdminCP");
$florensia->sitetitle("Teamspeak");
$florensia->output_page($content);
$character = new class_character($character);
if ($character->data['gender'] == "m") {
$gender = "<img src='{$florensia->layer_rel}/gender_male.gif' border='0' alt='male' style='height:12px;'>";
} else {
$gender = "<img src='{$florensia->layer_rel}/gender_female.gif' border='0' alt='female' style='height:12px;'>";
}
$server = "<a href='{$florensia->root}/statistics/" . $florensia->escape($character->data['server']) . "'>" . $florensia->escape($character->data['server']) . "</a>";
if ($character->data['guildid']) {
$guild = "<a href='" . $florensia->outlink(array("guilddetails", $character->data['guildid'], $character->data['server'], $character->data['guild'])) . "'>" . $florensia->escape($character->data['guild']) . "</a>";
} elseif ($character->data['guild']) {
$guild = $florensia->escape($character->data['guild']);
} else {
unset($guild);
}
if ($guild && $character->data['guildgrade']) {
$guild .= " " . class_character::guildgrade($character->data['guildgrade']);
}
$characterlist .= "\n\t <div class='small shortinfo_" . $florensia->change() . "'>\n <table style='width:100%'><tr>\n <td style='width:50px; text-align:right;'>" . intval($character->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;'>" . intval($character->data['levelsea']) . " <img src='{$florensia->layer_rel}/sealv.gif' style='height:11px;' alt='Sea'></td>\n <td style='width:20px;'>{$guildgrade}</td>\n <td>{$gender} " . $character->get_link() . "</td>\n <td style='width:160px'>" . $florensia->escape($character->data['jobclass']) . "</td>\n <td style='width:150px'>{$guild}</td>\n <td style='width:90px'>{$server}</td>\n <td style='text-align:right; padding-right:3px; width:130px'>" . $flolang->sprintf($flolang->character_lastupdate, timetamp2string(date("U") - $character->data['lastupdate'], "m")) . "</td>\n </tr></table>\n </div>";
}
if (!strlen($characterlist)) {
$characterlist = "<div class='small shortinfo_" . $florensia->change() . "' style='text-align:center;'>{$flolang->character_userprofile_overview_verifiedlist_empty}</div>";
}
$qr = MYSQL_QUERY("SELECT charname, timestamp, accepted, moderated, comment FROM flobase_character_verification as v, flobase_character as c WHERE userid='{$userid}' AND v.characterid=c.characterid ORDER BY timestamp DESC");
unset($requestlist);
while ($r = MYSQL_FETCH_ARRAY($qr)) {
list($moduserid, $modtimestamp) = explode("-", $r['moderated']);
unset($status, $moderated, $comment);
switch (intval($r['accepted'])) {
case -1:
$status = $flolang->character_userprofile_overview_requestlist_pending;
break;
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>";
} else {
$guildlink = "<a href='" . $florensia->outlink(array("guilddetails", $recent['guildid'], $recent['server'], $recent['guildname'])) . "' class='archiv'>" . $florensia->escape($recent['guildname']) . "</a>";
}
$charname = "<a href='" . $florensia->outlink(array("characterdetails", $recent['charname'])) . "'>" . $florensia->escape($recent['charname']) . "</a>";
$serverlink = "<a href='" . $florensia->outlink(array("statistics", $recent['server'])) . "'>" . $florensia->escape($recent['server']) . "</a>";
if ($tmptime > $recent['timestamp']) {
$timestamp = $flolang->sprintf($flolang->character_lastupdate, timetamp2string(date("U") - $recent['timestamp']));
$tmptime = $recent['timestamp'];
} else {
$timestamp = "";
}
$oldguildgrade = $recent['oldguildgrade'] ? class_character::guildgrade($recent['oldguildgrade']) : "";
$newguildgrade = $recent['newguildgrade'] ? class_character::guildgrade($recent['newguildgrade']) : "";
switch ($recent['action']) {
case "j":
$recentupdates .= "<tr><td style='width:110px;'>{$timestamp}</td><td>" . $flolang->sprintf($flolang->character_recentupdates_joinguild, $charname, $guildlink . " " . $newguildgrade) . " ({$serverlink})</td></tr>";
break;
case "l":
$recentupdates .= "<tr><td style='width:110px;'>{$timestamp}</td><td>" . $flolang->sprintf($flolang->character_recentupdates_leftguild, $charname, $guildlink . " " . $oldguildgrade) . " ({$serverlink})</td></tr>";
break;
case "a":
$recentupdates .= "<tr><td style='width:110px;'>{$timestamp}</td><td>" . $flolang->sprintf($flolang->character_recentupdates_addguild, $charname, $guildlink . " " . $newguildgrade) . " ({$serverlink})</td></tr>";
break;
}
}
$recentupdates = "\n <div class='small subtitle' style='margin-top:15px;'>\n {$flolang->character_overview_recentupdates}\n <table style='width:100%; font-weight:normal;'>\n {$recentupdates}\n </table>\n </div>";
$pagetitle = "<div class='subtitle' style='margin-bottom:10px;'><a href='{$florensia->root}/guilddetails'>{$flolang->guild_sitetitle}</a></div>";
}
