function putSidebarModStuff()
{
global $_newUI, $_auth;
if (isModerator() || $_auth["useid"] == 7) {
$found = false;
ob_start();
for ($isExtras = 0; $isExtras < 2; $isExtras++) {
$_objects = $isExtras ? "`extras`" : "`objects`";
// Bring attention to the abuse cases pending a moderator's decision.
$_tmpResult = sql_query("SELECT `objid`,`objTitle`,`abuid` FROM `abuses`,{$_objects}" . dbWhere(array("abuObj*" => "objid", "abuIsExtras" => $isExtras, "abuMod" => "?")) . "ORDER BY `abuSubmitDate` DESC LIMIT 5");
while ($rowData = mysql_fetch_assoc($_tmpResult)) {
?>
<div>
<?php
echo getIMG(url() . "images/emoticons/" . ($isExtras ? "star4.png" : "keydelete.gif"));
?>
<a href="<?php
echo url("abuse/" . $rowData["abuid"]);
?>
">
<?php
echo htmlspecialchars($rowData["objTitle"]);
?>
</a>
</div>
<?php
$found = true;
}
}
$ht = ob_get_contents();
ob_end_clean();
if ($found) {
if (isset($_newUI)) {
?>
<div class="ui2-layout-bg ui2-section-closed"><?php
echo _MODERATOR;
?>
</div>
<div class="ui2-section-body">
<?php
echo $ht;
?>
</div>
<?php
} else {
?>
<div class="caption error"><?php
echo _MODERATOR;
?>
<br /><?php
echo _ABUSE_LIST;
?>
:</div>
<div class="container2 mar_bottom">
<?php
echo $ht;
?>
</div>
<?php
}
}
}
if (isSModerator() || $_auth["useid"] == 7) {
$found = false;
ob_start();
$mod_count = 0;
$adm_count = 0;
for ($isExtras = 0; $isExtras < 2; $isExtras++) {
$_objects = $isExtras ? "`extras`" : "`objects`";
// Bring attention to the abuse cases pending a supermoderator's decision.
$_tmpResult = sql_query("SELECT `objid`,`objTitle`,`abuid` FROM `abuses`,{$_objects} " . "WHERE `abuObj` = `objid` AND `abuIsExtras` = '{$isExtras}' AND `abuMod` <> '?' AND `abusMod` = '?' " . "ORDER BY `abuSubmitDate` DESC LIMIT 5");
$_tmpResult_mod = sql_query("SELECT COUNT(*) FROM `abuses`,{$_objects} " . "WHERE `abuObj` = `objid` AND `abuIsExtras` = '{$isExtras}' AND `abuMod` = '?'");
$mod_count += mysql_result($_tmpResult_mod, 0);
$_tmpResult_adm = sql_query("SELECT COUNT(*) FROM `abuses`,{$_objects} " . "WHERE `abuObj` = `objid` AND `abuIsExtras` = '{$isExtras}' AND `abuMod` <> '?' AND `abusMod` <> '?' " . "AND `abuMod` <> `abusMod` AND `aburMod` = '?'");
$adm_count += mysql_result($_tmpResult_adm, 0);
while ($rowData = mysql_fetch_assoc($_tmpResult)) {
?>
<div>
<?php
echo getIMG(url() . "images/emoticons/" . ($isExtras ? "star4.png" : "keydelete.gif"));
?>
<a href="<?php
echo url("abuse/" . $rowData["abuid"]);
?>
">
<?php
echo htmlspecialchars($rowData["objTitle"]);
?>
</a>
</div>
<?php
$found = true;
}
}
if ($mod_count > 0) {
?>
<div<?php
echo $found ? ' class="sep"' : "";
?>
><?php
echo _ABUSE_WAIT_MODERATOR . ": " . $mod_count;
?>
</div>
<?php
$found = true;
}
if ($adm_count > 0) {
?>
<div<?php
echo $found ? ' class="sep"' : "";
?>
><?php
echo _ABUSE_WAIT_ADMINISTRATOR . ": " . $adm_count;
?>
</div>
<?php
$found = true;
}
$ht = ob_get_contents();
ob_end_clean();
if ($found) {
if (isset($_newUI)) {
?>
<div class="ui2-layout-bg ui2-section-closed"><?php
echo _SUPERMODERATOR;
?>
</div>
<div class="ui2-section-body">
<?php
echo $ht;
?>
</div>
<?php
} else {
?>
<div class="caption error"><?php
echo _SUPERMODERATOR;
?>
<br /><?php
echo _ABUSE_LIST;
?>
:</div>
<div class="container2 mar_bottom">
<?php
echo $ht;
?>
</div>
<?php
}
}
}
if (isAdmin() || $_auth["useid"] == 7) {
$found = false;
ob_start();
for ($isExtras = 0; $isExtras < 2; $isExtras++) {
$_objects = $isExtras ? "`extras`" : "`objects`";
// Bring attention to the abuse cases pending admin's decision.
$_tmpResult = sql_query("SELECT `objid`,`objTitle`,`abuid` FROM `abuses`,{$_objects} " . "WHERE `abuObj` = `objid` AND `abuMod` <> '?' AND `abusMod` <> '?' " . "AND `abuMod` <> `abusMod` AND `aburMod` = '?' " . "ORDER BY `abuSubmitDate` DESC LIMIT 5");
while ($rowData = mysql_fetch_assoc($_tmpResult)) {
?>
<div>
<?php
echo getIMG(url() . "images/emoticons/" . ($isExtras ? "star4.png" : "keydelete.gif"));
?>
<a href="<?php
echo url("abuse/" . $rowData["abuid"]);
?>
">
<?php
echo htmlspecialchars($rowData["objTitle"]);
?>
</a>
</div>
<?php
$found = true;
}
}
$ht = ob_get_contents();
ob_end_clean();
if ($found) {
if (isset($_newUI)) {
?>
<div class="ui2-layout-bg ui2-section-closed"><?php
echo _ADMINISTRATOR;
?>
</div>
<div class="ui2-section-body">
<?php
echo $ht;
?>
</div>
<?php
} else {
?>
<div class="caption error"><?php
echo _ADMINISTRATOR;
?>
<br /><?php
echo _ABUSE_LIST;
?>
:</div>
<div class="container2 mar_bottom">
<?php
echo $ht;
?>
</div>
<?php
}
}
}
}
$useData = mysql_fetch_assoc($result);
// This does not work until abuCreator is added. The addition of abuCreator will probably also result in other code modification.
$useData["abuseCases"] = intval(mysql_result(sql_query("SELECT COUNT(*) FROM `abuses` WHERE `abuCreator` = '" . $objData["objCreator"] . "'"), 0));
$useData["abusePercent"] = round(intval(mysql_result(sql_query("SELECT COUNT(*) FROM `abuses` WHERE `abuCreator` = '" . $objData["objCreator"] . "' AND ((`abuMod` = '-' AND `abusMod` = '-') OR (`aburMod` = '-'))"), 0)) / $useData["abuseCases"] * 100);
// Fetch reporter's data.
$result = sql_query("SELECT `useid`, `useUsername` FROM `users` " . "WHERE `useid` = '" . $objData["abuSubmitter"] . "' LIMIT 1");
$repData = mysql_fetch_assoc($result);
$repData["abuseCases"] = intval(mysql_result(sql_query("SELECT COUNT(*) FROM `abuses` WHERE `abuSubmitter` = '" . $objData["abuSubmitter"] . "'"), 0));
$repData["abusePercent"] = round(intval(mysql_result(sql_query("SELECT COUNT(*) FROM `abuses` WHERE `abuSubmitter` = '" . $objData["abuSubmitter"] . "' AND ((`abuMod` = '-' AND `abusMod` = '-') OR (`aburMod` = '-'))"), 0)) / $repData["abuseCases"] * 100);
// Determine the current user's access level.
$accessLevel = 0;
// No access.
if ($objData["abuMod"] == "?" && isModerator()) {
$accessLevel = 1;
// Moderator.
} elseif ($objData["abuMod"] != "?" && $objData["abusMod"] == "?" && isSModerator()) {
$accessLevel = 2;
// Supermoderator.
} elseif ($objData["abuMod"] != "?" && $objData["abusMod"] != "?" && $objData["abuMod"] != $objData["abusMod"] && isAdmin()) {
$accessLevel = 3;
// Administrator.
}
if ($objData["abuResolved"]) {
$accessLevel = 0;
}
// This abuse case is resolved.
if ($accessLevel > 0 && isset($_POST["submit"])) {
// Check if we got a correct decision: "+" or "-"
$decision = $_POST["decision"] == "+" ? "+" : ($_POST["decision"] == "-" ? "-" : "");
if ($decision) {
switch ($accessLevel) {
<div class="caption error"><?php
echo _MODERATOR;
?>
<br /><?php
echo _ABUSE_LIST;
?>
:</div>
<div class="container2 mar_bottom">
<?php
echo $ht;
?>
</div>
<?php
}
}
if (isSModerator()) {
$found = false;
ob_start();
$mod_count = 0;
$adm_count = 0;
for ($isExtras = 0; $isExtras < 2; $isExtras++) {
$_objects = $isExtras ? "`extras`" : "`objects`";
// Bring attention to the abuse cases pending a supermoderator's decision.
$result = mysql_query("SELECT `objid`,`objTitle`,`abuid` FROM `abuses`,{$_objects} " . "WHERE `abuObj` = `objid` AND `abuIsExtras` = '{$isExtras}' AND `abuMod` <> '?' AND `abusMod` = '?' " . "ORDER BY `abuSubmitDate` DESC LIMIT 5") or trigger_error(_ERR_MYSQL);
$result_mod = mysql_query("SELECT COUNT(*) FROM `abuses`,{$_objects} " . "WHERE `abuObj` = `objid` AND `abuIsExtras` = '{$isExtras}' AND `abuMod` = '?'") or trigger_error(_ERR_MYSQL);
$mod_count += mysql_result($result_mod, 0);
$result_adm = mysql_query("SELECT COUNT(*) FROM `abuses`,{$_objects} " . "WHERE `abuObj` = `objid` AND `abuIsExtras` = '{$isExtras}' AND `abuMod` <> '?' AND `abusMod` <> '?' " . "AND `abuMod` <> `abusMod` AND `aburMod` = '?'") or trigger_error(_ERR_MYSQL);
$adm_count += mysql_result($result_adm, 0);
while ($rowData = mysql_fetch_assoc($result)) {
?>
<div>
