Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- define("PAGE_NAME", "Warnings");
- require_once('class2.php');
- require_once("e107_handlers/userclass_class.php");
- require_once(HEADERF);
- mysql_connect("localhost", $mySQLuser, $mySQLpassword) or die(mysql_error());
- mysql_select_db("xtremejumps") or die(mysql_error());
- function add_userclass($userid, $class)
- {
- $query=mysql_query("SELECT user_class FROM e107_user WHERE user_id='".$userid."'");
- $classstring=mysql_result($query, 0, "user_class");
- $uc = new e_userclass;
- $uc->class_add($class, array($userid => $classstring));
- }
- function remove_userclass($userid, $class)
- {
- $query=mysql_query("SELECT user_class FROM e107_user WHERE user_id='".$userid."'");
- $classstring=mysql_result($query, 0, "user_class");
- $uc = new e_userclass;
- $uc->class_remove($class, array($userid => $classstring));
- }
- function expired($warn)
- {
- if($warn<time())
- {
- $return="<span style='color:red'>".date("Y-m-d",$warn)."</span>";
- }
- else
- {
- $return=date("Y-m-d",$warn);
- }
- return $return;
- }
- // display colorized legend
- $legend .= "<table style='text-align: center; width: 585px;margin: 0 auto;'>
- <br>
- <tr>
- <td style='background: #aaaaaa'> </td><td> <a href='".e_BASE."warnings.php?filter=4' style='color: #aaaaaa'> Commentban</a></td>
- </tr>
- <tr>
- <td style='background: #9C7B7B'> </td><td> <a href='".e_BASE."warnings.php?filter=5' style='color: #9C7B7B'> Warn and Commentban</a></td>
- </tr>
- <tr>
- <td style='background: orange'> </td><td> <a href='".e_BASE."warnings.php?filter=1' style='color: orange'> Warned</a></td>
- </tr>
- <tr>
- <td style='background: red'> </td><td> <a href='".e_BASE."warnings.php?filter=2' style='color: red'> Ban</a></td>
- </tr>
- <tr>
- <td style='background: black'> </td><td> <a href='".e_BASE."warnings.php?filter=3' style='color: black'> Perm Ban</a></td>
- </tr>
- </table> <br />";
- if (!check_class(17))
- {
- // display for people who aren't admins
- $text .= "<style>
- .balloon a:hover {background-color: #FFFF99;;color:#0000FF;}
- .balloon a:link span{display: none;}
- .balloon a:visited span{display: none;}
- .balloon a:hover span {
- position: absolute;
- margin:15px 0px 0px 20px;
- background-color: beige;
- max-width:400px;
- padding: 2px 10px 2px 10px;
- border: 1px solid #C0C0C0;
- font: normal 10px/12px verdana;
- text-decoration:none;
- color: #000;
- text-align:left;
- display: block;
- }
- </style>";
- $text .= $legend."
- <table cellpadding='3' cellspacing='0' style='width: 585px;margin: 0 auto; border: 2px solid #DA6D0A; text-align: center;'>
- <tr>
- <td class='caption'>Name:</td>
- <td class='caption'>Warn/Ban on:</td>
- <td class='caption'>Warn/Ban Expire:</td>
- </tr>";
- $filter = "";
- if ($_GET['filter'] == '1' ||
- $_GET['filter'] == '2' ||
- $_GET['filter'] == '3' ||
- $_GET['filter'] == '4' ||
- $_GET['filter'] == '5')
- $filter = "WHERE warnings='$_GET[filter]'";
- $result = mysql_query("SELECT * FROM xjbanlist $filter ORDER BY `warnings` ASC, `warnedon` DESC");
- $i = 0;
- // for reordering list of people
- $text_ = array();
- while ($row = mysql_fetch_array($result))
- {
- $nextweek = $row['fake_warnedon'] + (7 * 24 * 60 * 60);
- $now = strtotime(date("Y-m-d", $row['warnedon']));
- $nextmonth = strtotime("+1 month", $now);
- $warns = $row[warnings];
- $name = $row[name];
- $i++;
- if (($i%2) == 0) {
- $class="";
- } else {
- $class=" class=\"even\"";
- }
- $text_[$warnid] .= "<tr".$class.">";
- $warnid = $row['warnings'] * 1;
- if ($row['warnings'] == 1) {
- $name = "<div style='color:orange'>".$name."</div>";
- } elseif ($row['warnings'] == 2) {
- $name = "<div style='color:red'>".$name."</div>";
- } elseif ($row['warnings'] == 3) {
- $name = "<div style='color:black'>".$name."</div>";
- } elseif ($row['warnings'] == 4) {
- $name = "<div style='color:#AAAAAA'>".$name."</div>";
- } elseif ($row['warnings'] == 5) {
- $name = "<div style='color:#9C7B7B'>".$name."</div>";
- } else {
- $name = "<div style='color:green'>".$name."</div>";
- $name = $name;
- }
- $text_[$warnid] .= " <td id='$row[userid]' class='bodytable' style='text-align: center;'>
- <span class=\"balloon\">
- <a href=\"http://xtreme-jumps.eu/user.php?id.".$row[userid]."\"><strong>".$name."</strong>
- <span>Reason: ".$row[reason]."</span>
- </a>
- </span>
- </td>";
- if (!$row['warnedon']) {
- $text_[$warnid] .= "<td class='bodytable' style='text-align: center;'>n/a</td>";
- } else {
- $text_[$warnid] .= "<td class='bodytable' style='text-align: center;'>" . date("Y-m-d",$row['warnedon']) . "</td>";
- }
- if ($row['warnings'] == 2) {
- $text_[$warnid] .= "<td class='bodytable' style='text-align: center;'>" . expired($nextweek) . "</td>";
- } else if ($row['warnings'] == 1) {
- $text_[$warnid] .= "<td class='bodytable' style='text-align: center;'>" . expired($nextmonth) . "</td>";
- } else {
- $text_[$warnid] .= "<td class='bodytable' style='text-align: center;'>n/a</td>";
- }
- $text_[$warnid] .= "</tr>";
- }
- $text .= $text_[4].$text_[5].$text_[1].$text_[2].$text_[3]."</table>";
- }
- else
- {
- // admin view!
- if ($_GET['action'] == "add")
- {
- // special form for banning user
- $sql->db_Select("user", "user_name", "user_id = '".mysql_real_escape_string($_GET['userid'])."'");
- $row = $sql->db_Fetch();
- $text .= "
- <center><p><b><u>Add a new warning:</b></u></p><br></center>
- <form method='POST' action='".e_BASE."warnings.php?action=add'>
- <table class='bodytable' width='585px' align='center' style='border: 0px solid #DA6D0A;' cellpadding='0' cellspacing='0'>
- <tr>
- <td width='15%'>Name:</td>
- <td><input name='name' value=\"$row[user_name]\"/></td>
- </tr>
- <tr>
- <td width='15%'>UserID:</td>
- <td><input name='userid' value='".$_GET['userid']."'/></td>
- </tr>
- <tr>
- <td width='15%'>Warnings:</td>
- <td>
- <!--input name='warnings_' size='1' /> (1 for warned; 2 for 1 week ban; 3 for perm ban, 4 for 'Commentban')-->
- <input type='radio' name='warnings' value='1'>Warned</input><br/>
- <input type='radio' name='warnings' value='2'>Ban</input><br/>
- <input type='radio' name='warnings' value='3'>Perm ban</input><br/>
- <input type='radio' name='warnings' value='4'>Site Commentban</input><br/>
- <input type='radio' name='warnings' value='5'>Warning + site Commentban</input>
- </td>
- </tr>
- <tr>
- <td width='15%'>Bantime:</td>
- <td><input name='fake_warnedon' size='1' /> (in days, only works on warntype 2)</td>
- </tr>
- <tr>
- <td width='15%'>Reason:</td>
- <td><textarea name='reason' cols='40' rows='5' ></textarea></td>
- </tr>
- </table>
- <br>
- <center><input type='submit' name='submit' value='Submit warning ' /> <input type='button' name='back' value='Back' onClick='history.go(-1);return true;'/> </center>
- <br>
- </form>";
- // did admin change ban?
- if ($_POST['submit'])
- {
- if (!$_POST['name'])
- {
- $text .= "You must enter an user name.";
- }
- else if (!$_POST['userid'])
- {
- $text .= "You must enter an user id.";
- }
- else if (!$_POST['warnings'])
- {
- $text .= "You must enter the right ban.";
- }
- else if (!$_POST['reason'])
- {
- $text .= "You must enter the reason.";
- }
- else if ($_POST['warnings']==2 && !$_POST['fake_warnedon'])
- {
- $text .= "You must enter the bantime.";
- }
- else
- {
- $name = htmlspecialchars($_POST['name']);
- $userid = htmlspecialchars($_POST['userid']);
- $warnings = htmlspecialchars($_POST['warnings']);
- $reason = htmlspecialchars($_POST['reason']);
- $warnedon = time();
- if ($_POST['warnings'] == 4)
- {
- add_userclass($userid, 40);
- $fake_warnedon=time()+($_POST['fake_warnedon']*86400-604800);
- mysql_query("INSERT INTO xjbanlist (name, userid, warnedon, remwarned, weekbanon, remweekban, warnings, reason, fake_warnedon) VALUES('$name', '$userid', '$warnedon', '' , '', '', '$warnings','$reason', '$fake_warnedon');");
- mysql_query("INSERT INTO e107_warn_history (name, user_id, warnon, remon, warnings, reason, admin) VALUES('$name', '$userid', '$warnedon', '', '$warnings','$reason', '".USERID."');");
- }
- if ($_POST['warnings'] == 5)
- {
- // warn + Commentban
- add_userclass($userid, 40);
- add_userclass($userid, 10);
- mysql_query("INSERT INTO xjbanlist (name, userid, warnedon, remwarned, weekbanon, remweekban, warnings, reason, fake_warnedon) VALUES('$name', '$userid', '$warnedon', '' , '', '', '$warnings','$reason', '0');");
- mysql_query("INSERT INTO e107_warn_history (name, user_id, warnon, remon, warnings, reason, admin) VALUES('$name', '$userid', '$warnedon', '', '$warnings','$reason', '".USERID."');");
- }
- else if($_POST['warnings'] == 2 || $_POST['warnings'] == 3)
- {
- add_userclass($userid, 24);
- $fake_warnedon=time()+($_POST['fake_warnedon']*86400-604800);
- mysql_query("INSERT INTO xjbanlist (name, userid, warnedon, remwarned, weekbanon, remweekban, warnings, reason, fake_warnedon) VALUES('$name', '$userid', '$warnedon', '' , '', '', '$warnings','$reason', '$fake_warnedon');");
- mysql_query("INSERT INTO e107_warn_history (name, user_id, warnon, remon, warnings, reason, admin) VALUES('$name', '$userid', '$warnedon', '', '$warnings','$reason', '".USERID."');");
- mysql_query("UPDATE e107_user SET user_ban='1' WHERE user_id='".$userid."'");
- }
- else if ($_POST['warnings'] == 1)
- {
- add_userclass($userid, 10);
- mysql_query("INSERT INTO xjbanlist (name, userid, warnedon, remwarned, weekbanon, remweekban, warnings, reason, fake_warnedon) VALUES('$name', '$userid', '$warnedon', '' , '', '', '$warnings','$reason', '0');");
- mysql_query("INSERT INTO e107_warn_history (name, user_id, warnon, remon, warnings, reason, admin) VALUES('$name', '$userid', '$warnedon', '', '$warnings','$reason', '".USERID."');");
- }
- $file=fopen("upload_logs/[WARNINGS].log", "a");
- fwrite($file, date('F j, Y, g:i a', time()). "[ADD]".USERNAME."(".USERID.") added a warn to user $name ($userid)");
- fwrite($file, "\r\n");
- fclose($file);
- $text .= "Done! - <a href='".e_BASE."warnings.php'>Back</a>";
- }
- }
- }
- else if (isset($_GET['ignore_ban']))
- {
- $text = "Ignoring ban complaint";
- $sql->db_Select_gen("UPDATE ban_complaint SET resolved=2 WHERE userid='".$_GET['ignore_ban']."'") or die (mysql_error());
- }
- else if (isset($_GET['ignore_ip']))
- {
- $text = "Ignoring IP complaint";
- $sql->db_Select_gen("UPDATE ban_complaint SET resolved=2 WHERE ip='".$_GET['ignore_ip']."'") or die (mysql_error());
- }
- else if (isset($_GET['removeip']))
- {
- $text = "Removing ban for IP address ".$_GET['removeip']."<br/>";
- $sql->db_Delete("banlist", "banlist_ip='".$_GET['removeip']."'");
- $text .= "Resolving complaints for IP address ".$_GET['removeip']."<br/>";
- $sql->db_Select_gen("UPDATE ban_complaint SET resolved=1 WHERE ip='".$_GET['removeip']."'") or die (mysql_error());
- }
- else if (isset($_GET['removeban']))
- {
- $text = 'Removing user_ban setting<br />';
- $sql->db_Select_gen("UPDATE e107_user SET user_ban=0 WHERE user_id='".$_GET['removeban']."'") or die (mysql_error());
- $text .= 'Removing user from XJ ban list<br />';
- $sql->db_Select_gen("DELETE FROM xjbanlist WHERE userid='".$_GET['removeban']."'") or die (mysql_error());
- $text .= "Resolving complaints for IP address ".$_GET['removeip']."<br/>";
- $sql->db_Select_gen("UPDATE ban_complaint SET resolved=1 WHERE userid='".$_GET['removeban']."'") or die (mysql_error());
- remove_userclass($_GET['removeban'], 24);
- }
- else if ($_GET['action'] == 'remmute')
- {
- remove_userclass(mysql_real_escape_string($_GET['userid']), 40);
- $sql->db_Select_gen("DELETE FROM xjbanlist WHERE userid='".mysql_real_escape_string($_GET['userid'])."'") or die (mysql_error());
- echo 'Removed Commentban for user id='.$_GET['userid'];
- }
- else if ($_GET['action'] == 'remmute_special')
- {
- // this action is invoked on user with both warning and Commentban
- // only remove Commentban, keep warning
- remove_userclass(mysql_real_escape_string($_GET['userid']), 40);
- $sql->db_Select_gen("UPDATE xjbanlist SET `warnings`='1' WHERE userid='".mysql_real_escape_string($_GET['userid'])."'") or die (mysql_error());
- echo 'Removed Commentban for user id='.$_GET['userid'].', warning remains';
- }
- else if ($_GET['action'] == 'remwarn_special')
- {
- // this action is invoked on user with both warning and Commentban
- // only remove warning, keep Commentban
- remove_userclass(mysql_real_escape_string($_GET['id']), 10);
- $sql->db_Select_gen("UPDATE xjbanlist SET `warnings`='4' WHERE id='".mysql_real_escape_string($_GET['id'])."'") or die (mysql_error());
- echo 'Removed warning for ban id='.$_GET['id'].', warning remains';
- }
- else if ($_GET['action'] == "edit")
- {
- // special edit feature for existing ban
- $id = $_GET[id];
- $result = mysql_query("SELECT * FROM xjbanlist WHERE id = '$id'");
- $row = mysql_fetch_array($result);
- $text .= "<form method='POST' action='".e_BASE."warnings.php?action=edit'>
- <input name='id' value='".$row["id"]."' type='hidden'>
- <table class='bodytable' style='width: 100%; border: 2px solid #DA6D0A;' cellpadding='0' cellspacing='0'>
- <tr>
- <td width='15%'>Name:</td>
- <td><input name='name' value='".$row["name"]."' /></td>
- </tr>
- <tr>
- <td width='15%'>UserID:</td>
- <td><input name='userid' value='".$row["userid"]."' /></td>
- </tr>
- <tr>
- <td width='15%'>Warnings:</td>
- <td>
- <!--input name='warnings' size='1' value='".$row["warnings"]."' /> (1 for warned; 2 for 1 week ban; 3 for perm ban)-->
- <input type='radio' name='warnings' value='1' ".($row["warnings"] == 1 ? "checked='checked'" : "").">Warned</input><br/>
- <input type='radio' name='warnings' value='2' ".($row["warnings"] == 2 ? "checked='checked'" : "").">Ban</input><br/>
- <input type='radio' name='warnings' value='3' ".($row["warnings"] == 3 ? "checked='checked'" : "").">Perm ban</input><br/>
- <input type='radio' name='warnings' value='4' ".($row["warnings"] == 4 ? "checked='checked'" : "").">Site Commentban</input><br/>
- <input type='radio' name='warnings' value='5' ".($row["warnings"] == 5 ? "checked='checked'" : "").">Warning + site Commentban</input>
- </td>
- </tr>
- <tr>
- <td width='15%'>Bantime:</td>
- <td><input name='fake_warnedon' size='1' /> (in days, only works on warntype 2)</td>
- </tr>
- <tr>
- <td width='15%'>Reason:</td>
- <td><textarea name='reason' cols='40' rows='5' >".$row["reason"]."</textarea></td>
- </tr>
- <tr>
- <td><input type='submit' name='submit' value='Submit' /></td>
- </tr>
- </table>
- </form>";
- if ($_POST['submit'])
- {
- if (!$_POST['name'])
- {
- $text .= "You must enter an user name.";
- }
- elseif (!$_POST['warnings'])
- {
- $text .= "You must enter the right ban.";
- }
- elseif (!$_POST['userid'])
- {
- $text .= "You must enter the userid.";
- }
- elseif (!$_POST['reason'])
- {
- $text .= "You must enter the reason.";
- }
- elseif ($_POST['warnings']==2 && !$_POST['fake_warnedon'])
- {
- $text .= "You must enter the bantime.";
- }
- else
- {
- $name = htmlspecialchars($_POST['name']);
- $warnings = htmlspecialchars($_POST['warnings']);
- $reason = htmlspecialchars($_POST['reason']);
- $id = $_POST['id'];
- $userid = $_POST['userid'];
- $warnedon = time();
- // if ban
- if ($_POST['warnings'] == 3 || $_POST['warnings'] == 2)
- {
- // remove warn and Commentban classes and add ban class
- remove_userclass($userid, 10);
- remove_userclass($userid, 40);
- add_userclass($userid, 24);
- $fake_warnedon=time()+($_POST['fake_warnedon']*86400-604800);
- // update xjbanlist
- mysql_query("UPDATE xjbanlist SET
- `name` = '$name',
- `userid` = '$userid',
- `warnings` = '$warnings',
- `reason` = '$reason',
- `fake_warnedon` = '$fake_warnedon'
- WHERE id = '$id'");
- // set personal info
- mysql_query("UPDATE e107_user SET user_ban='1' WHERE user_id='".$userid."'");
- }
- else if ($_POST['warnings'] == 1)
- {
- // warning only, remove Commentban and ban
- remove_userclass($userid, 24);
- remove_userclass($userid, 40);
- add_userclass($userid, 10);
- mysql_query("UPDATE xjbanlist SET
- `name` = '$name',
- `userid` = '$userid',
- `warnings` = '$warnings',
- `reason` = '$reason'
- WHERE id = '$id'");
- mysql_query("UPDATE e107_user SET user_ban='0' WHERE user_id='".$userid."'");
- }
- else if ($_POST['warnings'] == 4)
- {
- // Commentban user
- // remove warn and ban
- remove_userclass($userid, 24);
- remove_userclass($userid, 10);
- add_userclass($userid, 40);
- mysql_query("UPDATE xjbanlist SET
- `name` = '$name',
- `userid` = '$userid',
- `warnings` = '$warnings',
- `reason` = '$reason'
- WHERE id = '$id'");
- mysql_query("UPDATE e107_user SET user_ban='0' WHERE user_id='".$userid."'");
- }
- else if ($_POST['warnings'] == 5)
- {
- // warn+Commentban combination
- // warning and Commentban, remove ban
- remove_userclass($userid, 24);
- add_userclass($userid, 10);
- add_userclass($userid, 40);
- mysql_query("UPDATE xjbanlist SET
- `name` = '$name',
- `userid` = '$userid',
- `warnings` = '$warnings',
- `reason` = '$reason'
- WHERE id = '$id'");
- mysql_query("UPDATE e107_user SET user_ban='0' WHERE user_id='".$userid."'");
- }
- $file=fopen("upload_logs/[WARNINGS].log", "a");
- fwrite($file, date('F j, Y, g:i a', time()). "[EDIT]".USERNAME."(".USERID.") edited the warn for user $name ($userid)");
- fwrite($file, "\r\n");
- fclose($file);
- $text .= "Done! - <a href='".e_BASE."warnings.php'>Back</a>";
- }
- }
- }
- else
- {
- $text .= "<style>
- .balloon a:hover {background-color: #FFFF99;;color:#0000FF;}
- .balloon a:link span{display: none;}
- .balloon a:visited span{display: none;}
- .balloon a:hover span {
- position: absolute;
- margin:15px 0px 0px 20px;
- background-color: beige;
- max-width:400px;
- padding: 2px 10px 2px 10px;
- border: 1px solid #C0C0C0;
- font: normal 10px/12px verdana;
- text-decoration:none;
- color: #000;
- text-align:left;
- display: block;
- }
- </style>";
- $text .= "
- <a href='".e_BASE."warnings.php?action=add'> Click here to add new user</a><br>";
- $text .= $legend."<table cellpadding='3' cellspacing='0' style='border: 2px solid #DA6D0A; text-align: center; width: 585px;margin: 0 auto;'>
- <tr>
- <td class='caption' style='width: 20%;'>Name:</td>
- <td class='caption' style='width: 15%;'>Warn/Ban on:</td>
- <td class='caption' style='width: 15%;'>Warn/Ban Expire:</td>
- <td class='caption'>Banned by</td>
- <td class='caption'>Edit:</td>
- <td class='caption' style='width: 15%;'>Options</td>
- </tr>";
- $filter = "";
- if ($_GET['filter'] == '1' ||
- $_GET['filter'] == '2' ||
- $_GET['filter'] == '3' ||
- $_GET['filter'] == '4' ||
- $_GET['filter'] == '5')
- $filter = "WHERE warnings='$_GET[filter]'";
- $result = mysql_query(" SELECT *
- FROM xjbanlist
- $filter
- ORDER BY CASE `warnings`
- WHEN 1 THEN 1
- WHEN 2 THEN 2
- WHEN 3 THEN 3
- WHEN 4 THEN -1
- WHEN 5 THEN 0
- END, `warnedon` DESC");
- $text_ = array();
- $i = 0;
- while ($row = mysql_fetch_array($result))
- {
- $nextweek = $row['fake_warnedon'] + (7 * 24 * 60 * 60);
- $now = strtotime(date("Y-m-d", $row['warnedon']));
- $nextmonth = strtotime("+1 month", $now);
- $name = $row[name];
- if (($i%2) == 0) {
- $class="";
- } else {
- $class=" class=\"even\"";
- }
- $i++;
- $text_[$warnid] .="<tr".$class.">";
- $warnid = $row['warnings'] * 1;
- if ($row['warnings'] == 1) {
- $name = "<div style='color:orange'>".$name."</div>";
- } elseif ($row['warnings'] == 2) {
- $name = "<div style='color:red'>".$name."</div>";
- } elseif ($row['warnings'] == 3) {
- $name = "<div style='color:black'>".$name."</div>";
- } elseif ($row['warnings'] == 4) {
- $name = "<div style='color:#AAAAAA'>".$name."</div>";
- } elseif ($row['warnings'] == 5) {
- $name = "<div style='color:#9C7B7B'>".$name."</div>";
- } else {
- $name = "<div style='color:green'>".$name."</div>";
- $name = $name;
- }
- $text_[$warnid] .= "<td id='$row[userid]' class='bodytable' style='text-align: left;'>
- <span class=\"balloon\">
- <a href=\"http://xtreme-jumps.eu/user.php?id.".$row[userid]."\"><strong>".$name."</strong>
- <span>Reason: ".$row[reason]."</span>
- </a>
- </span>
- </td>";
- if (!$row['warnedon']) {
- $text_[$warnid] .= "<td class='bodytable' style='text-align: center;'>n/a</td>";
- }
- else {
- $text_[$warnid] .= "<td class='bodytable' style='text-align: center;'>" . date("Y-m-d",$row['warnedon']) . "</td>";
- }
- if ($row['warnings'] == 2) {
- $text_[$warnid] .= "<td class='bodytable' style='text-align: center;'>" . expired($nextweek) . "</td>";
- }
- else if ($row['warnings'] == 1 || $row['warnings'] == 5) {
- $text_[$warnid] .= "<td class='bodytable' style='text-align: center;'>" . expired($nextmonth) . "</td>";
- }
- else {
- $text_[$warnid] .= "<td class='bodytable' style='text-align: center;'>n/a</td>";
- }
- $sql2->db_Query("SELECT * FROM e107_warn_history WHERE `warnon` = '" . $row['warnedon'] . "'") or die(mysql_error());
- $row2 = $sql2->db_Fetch(MYSQL_ASSOC);
- $text_[$warnid] .= "<td class='bodytable' style='text-align: left;' >" . userStyle($row2['admin']) . "</td>";
- $text_[$warnid] .= "<td class='bodytable' style='text-align: center;' ><a href='".e_BASE."warnings.php?action=edit&id=" . $row['id'] . "' style='text-align: center;'>Edit</a></td>";
- if ($row['warnings'] == 1) {
- $text_[$warnid] .= "<td class='bodytable'><a href='".e_BASE."warnings.php?action=remwarn&id=" . $row['id'] . "' style='text-align: center;'>Remove</a></td>";
- }
- elseif ($row['warnings'] == 2) {
- $text_[$warnid] .= "<td class='bodytable'><a href='".e_BASE."warnings.php?action=rem1week&id=" . $row['id'] . "' style='text-align: center;'>Remove</a></td>";
- }
- elseif ($row['warnings'] == 3) {
- if (ADMIN && (USERID == 46952 || USERID == 6542)) {
- $text_[$warnid] .= "<td class='bodytable'><a href='".e_BASE."warnings.php?action=remperm&id=" . $row['id'] . "' style='text-align: center;'>Remove</a></td>";
- }
- else {
- $text_[$warnid] .= "<td class='bodytable'>No access</td>";
- }
- }
- elseif ($row['warnings'] == 4) {
- $text_[$warnid] .= "<td class='bodytable'><a href='".e_BASE."warnings.php?action=remmute&userid=" . $row['userid'] . "' style='text-align: center;'>Remove Commentban</a></td>";
- }
- elseif ($row['warnings'] == 5) {
- $text_[$warnid] .= "<td class='bodytable'>
- <a href='".e_BASE."warnings.php?action=remwarn_special&id=" . $row['id'] . "' style='text-align: center;'>Remove warn</a>
- <a href='".e_BASE."warnings.php?action=remmute_special&userid=" . $row['userid'] . "' style='text-align: center;'>Remove Commentban</a>
- </td>";
- }
- else {
- $text_[$warnid] .= "<td class='bodytable'><a href='".e_BASE."warnings.php?action=addwarn&id=" . $row['id'] . "' style='text-align: center;'>Warn</a> | <a href='".e_BASE."warnings.php?action=add1week&id=" . $row['id'] . "'>Week</a> | <a href='".e_BASE."warnings.php?action=addperm&id=" . $row['id'] . "'>Perm</a> | <a href='".e_BASE."warnings.php?action=remuser&id=" . $row['id'] . "'>Del</a></td>";
- }
- $text_[$warnid] .= "</tr>";
- }
- $text .= $text_[4].$text_[5].$text_[1].$text_[2].$text_[3]."</table>";
- if ($_GET['id']) {$result = mysql_query("SELECT * FROM xjbanlist WHERE id='" . $_GET['id'] . "'");}
- if ($_GET['action'] == "addwarn") {
- if ($_GET['id']) {
- mysql_query("UPDATE xjbanlist SET warnedon='" . time() . "', warnings='1', remwarned='' WHERE id='" . $_GET['id'] . "'");
- if(mysql_num_rows($result)!=0)
- {
- $file=fopen("upload_logs/[WARNINGS].log", "a");
- fwrite($file, date('F j, Y, g:i a', time()). "[EDIT]".USERNAME."(".USERID.") added a warn to user ".mysql_result($result, 0, 'name')." (".mysql_result($result, 0, 'userid').")");
- fwrite($file, "\r\n");
- fclose($file);
- }
- $_GET['action']="d0n3";
- $text .= "<br />Done! - <a href='".e_BASE."warnings.php'>Back</a>";
- }
- }
- if ($_GET['action'] == "remwarn") {
- if ($_GET['id']) {
- $userid=mysql_result($result, 0, 'userid');
- mysql_query("DELETE FROM xjbanlist WHERE id='" . $_GET['id'] . "'");
- $file=fopen("upload_logs/[WARNINGS].log", "a");
- remove_userclass($userid, 10);
- remove_userclass($userid, 24);
- if(mysql_num_rows($result)!=0)
- {
- fwrite($file, date('F j, Y, g:i a', time()). "[REMOVE]".USERNAME."(".USERID.") removed user ".mysql_result($result, 0, 'name')." (".$userid.")");
- fwrite($file, "\r\n");
- fclose($file);
- }
- $_GET['action']="d0n3";
- //mysql_query("UPDATE xjbanlist SET warnedon='', warnings='0', remwarned='" . time() . "' WHERE id='" . $_GET['id'] . "'");
- $text .= "<br />Done! - <a href='".e_BASE."warnings.php'>Back</a>";
- }
- }
- if ($_GET['action'] == "add1week") {
- if ($_GET['id']) {
- mysql_query("UPDATE xjbanlist SET warnedon='" . time() . "', warnings='2', remwarned='', fake_warnedon='".time()."' WHERE id='" . $_GET['id'] . "'");
- if(mysql_num_rows($result)!=0)
- {
- $file=fopen("upload_logs/[WARNINGS].log", "a");
- fwrite($file, date('F j, Y, g:i a', time()). "[EDIT]".USERNAME."(".USERID.") added bantime to user ".mysql_result($result, 0, 'name')." (".mysql_result($result, 0, 'userid').")");
- fwrite($file, "\r\n");
- fclose($file);
- }
- $_GET['action']="d0n3";
- $text .= "<br />Done! - <a href='".e_BASE."warnings.php'>Back</a>";
- }
- }
- if ($_GET['action'] == "rem1week") {
- if ($_GET['id']) {
- $userid=mysql_result($result, 0, 'userid');
- mysql_query("DELETE FROM xjbanlist WHERE id='" . $_GET['id'] . "'");
- mysql_query("UPDATE e107_user SET user_ban='0' WHERE user_id='".$userid."'");
- remove_userclass($userid, 10);
- remove_userclass($userid, 24);
- if(mysql_num_rows($result)!=0)
- {
- $file=fopen("upload_logs/[WARNINGS].log", "a");
- fwrite($file, date('F j, Y, g:i a', time()). "[EDIT]".USERNAME."(".USERID.") removed bantime for user ".mysql_result($result, 0, 'name')." (".mysql_result($result, 0, 'userid').")");
- fwrite($file, "\r\n");
- fclose($file);
- }
- $_GET['action']="d0n3";
- //mysql_query("UPDATE xjbanlist SET warnedon='', warnings='0', remwarned='" . time() . "' WHERE id='" . $_GET['id'] . "'");
- $text .= "<br />Done! - <a href='".e_BASE."warnings.php'>Back</a>";
- }
- }
- if ($_GET['action'] == "addperm") {
- if ($_GET['id']) {
- mysql_query("UPDATE xjbanlist SET warnedon='" . time() . "', warnings='3', remwarned='' WHERE id='" . $_GET['id'] . "'");
- $userid=mysql_result($result, 0, 'userid');
- mysql_query("UPDATE e107_user SET user_ban='1' WHERE user_id='".$userid."'");
- remove_userclass($userid, 10);
- add_userclass($userid, 24);
- if(mysql_num_rows($result)!=0)
- {
- $file=fopen("upload_logs/[WARNINGS].log", "a");
- fwrite($file, date('F j, Y, g:i a', time()). "[EDIT]".USERNAME."(".USERID.") permbanned user ".mysql_result($result, 0, 'name')." (".mysql_result($result, 0, 'userid').")");
- fwrite($file, "\r\n");
- fclose($file);
- }
- $_GET['action']="d0n3";
- $text .= "<br />Done! - <a href='".e_BASE."warnings.php'>Back</a>";
- }
- }
- if ($_GET['action'] == "remperm") {
- if ($_GET['id']) {
- $userid=mysql_result($result, 0, 'userid');
- mysql_query("DELETE FROM xjbanlist WHERE id='" . $_GET['id'] . "'");
- mysql_query("UPDATE e107_user SET user_ban='0' WHERE user_id='".$userid."'");
- remove_userclass($userid, 10);
- remove_userclass($userid, 24);
- if(mysql_num_rows($result)!=0)
- {
- $file=fopen("upload_logs/[WARNINGS].log", "a");
- fwrite($file, date('F j, Y, g:i a', time()). "[REMOVE]".USERNAME."(".USERID.") removed perm ban for ".mysql_result($result, 0, 'name')." (".mysql_result($result, 0, 'userid').")");
- fwrite($file, "\r\n");
- fclose($file);
- }
- $_GET['action']="d0n3";
- //mysql_query("UPDATE xjbanlist SET warnedon='', warnings='0', remwarned='" . time() . "' WHERE id='" . $_GET['id'] . "'");
- $text .= "<br />Done! - <a href='".e_BASE."warnings.php'>Back</a>";
- }
- }
- if ($_GET['action'] == "remuser") {
- if ($_GET['id']) {
- mysql_query("DELETE FROM xjbanlist WHERE id='" . $_GET['id'] . "'");
- if(mysql_num_rows($result)!=0)
- {
- $file=fopen("upload_logs/[WARNINGS].log", "a");
- fwrite($file, date('F j, Y, g:i a', time()). "[REMOVE]".USERNAME."(".USERID.") removed user ".mysql_result($result, 0, 'name')." (".mysql_result($result, 0, 'userid').") from list");
- fwrite($file, "\r\n");
- fclose($file);
- }
- $_GET['action']="d0n3";
- $text .= "<br />Done! - <a href='".e_BASE."warnings.php'>Back</a>";
- }
- }
- // special complaint table
- if (ADMIN)
- {
- $admintext = "<table class='fborder' style='width: 585px;margin: 0 auto; text-align: center' cellspacing='0'>
- <br>
- <tr>
- <th colspan='6' class='caption' style='text-align:center'>Ban complaints - unresolved</th>
- </tr>
- </tr>
- <th class='caption' style='text-align:center'>ID/name</th>
- <th class='caption' style='text-align:center'>IP address</th>
- <th class='caption' style='text-align:center'>Ban reason</th>
- <th class='caption' style='text-align:center'>Complaint</th>
- <th class='caption' style='text-align:center' width='13%'>Options</th>
- </tr>";
- $sql->db_Select_gen("
- SELECT ban_complaint.*, u.user_name, u.user_ban, ebl.*
- FROM ban_complaint
- LEFT JOIN e107_user AS u ON u.user_id = ban_complaint.userid
- LEFT JOIN e107_banlist AS ebl ON ebl.banlist_ip = ban_complaint.ip
- WHERE resolved = 0");
- $i = 0;
- while ($row = $sql->db_Fetch())
- {
- $class="";
- if (($i%2) == 1) $class=" class=\"even\"";
- $reason = "";
- if ($row['user_ban'] == 1)
- {
- $reason = "Admin ban $row[admin]";
- $removetype = "removeban";
- $removedata = $row['userid'];
- $removetext = "Remove ban";
- $ignorelink = "<a style='color: red' href='".e_BASE."warnings.php?ignore_ban=$row[userid]' title='This will ignore this complaint and won't unban user'>Ignore</a>";
- }
- else
- {
- $reason = "IP ban: ".$row['banlist_reason'];
- $removetype = "removeip";
- $removedata = $row['ip'];
- $removetext = "Remove IP";
- $ignorelink = "<a style='color: red' href='".e_BASE."warnings.php?ignore_ip=$row[ip]' title='This will ignore this complaint and won't unban IP'>Ignore</a>";
- }
- $admintext .= "
- <tr $class title='Date/Time of complaint: $row[date], $row[time]'>
- <td><a href='user.php?id.$row[userid]'>$row[userid], $row[user_name]</a></td>
- <td>$row[ip]</td>
- <td>$reason</td>
- <td style='word-break: break-word'>".htmlEntities($row[complaint], ENT_QUOTES)."</td>
- <td><a href='".e_BASE."warnings.php?$removetype=$removedata' title='Remove all bans for this IP'>$removetext</a><br/>$ignorelink</td>
- </tr>
- ";
- $i++;
- }
- $admintext .= "</table><hr />";
- $text = $admintext.$text;
- }
- }
- }
- $ns->tablerender(PAGE_NAME, $text);
- require_once(FOOTERF);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement