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>