API tools faq
paste
Advertisement
Guest User

unban.php.

a guest
Nov 5th, 2017
181
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.78 KB | None | 0 0
raw download clone embed print report
  1. <title>Cerere unban - <?php echo Config::$_SITE_NAME; ?></title>
  2. </div>
  3. <div class="main-content">
  4. <div class="main-content-inner">
  5. <div class="breadcrumbs" id="breadcrumbs">
  6. <script type="text/javascript">
  7. try{ace.settings.check('breadcrumbs' , 'fixed')}catch(e){}
  8. </script>
  9.  
  10. <ul class="breadcrumb">
  11. <li>
  12. <i class="ace-icon fa fa-home home-icon"></i>
  13. <a href="<?php echo Config::$_PAGE_URL; ?>">Home</a>
  14. </li>
  15. <li class="active">
  16. <a href="<?php echo Config::$_PAGE_URL; ?>unban">Unban requests</a>
  17. </li>
  18. </ul><!-- /.breadcrumb -->
  19.  
  20. <div class="nav-search" id="nav-search">
  21. <form method="POST" action="search">
  22. <span class="input-icon">
  23. <input type="text" placeholder="Search ..." name="sname" id="username" type="submit" class="nav-search-input" autocomplete="on">
  24. <i class="ace-icon fa fa-search nav-search-icon"></i>
  25. </span>
  26. </form>
  27. </div> <!-- /.nav-search -->
  28. </div>
  29.  
  30. <div class="page-content">
  31. <div class="row-fluid">
  32.  
  33. <?php
  34. if(!defined('panel'))
  35. die('Nope.');
  36. if(!isset($_SESSION['user'])) {
  37. echo '<meta http-equiv="refresh" content="0;URL=\''.Config::$_PAGE_URL.'login\'/>'; } else {
  38. if(!isset($_GET['id'])) {
  39. if(!isset($_GET['request'])) {
  40. ?>
  41.  
  42. <h2>Your Unban Requests</h2>
  43. <div class="row">
  44. <div class="col-xs-12 center">
  45. <div class="table-responsive" style="margin-left: 30px">
  46. <table id="sample-table-1" class="table table-striped table-bordered table-hover">
  47. <thead>
  48. <tr>
  49. <th>Title</th>
  50. <th>
  51. <i class="icon-time bigger-110 hidden-480"></i>
  52. Date
  53. </th>
  54. <th class="hidden-480">Status</th>
  55. </tr>
  56. </thead>
  57. <tbody>
  58. <?php
  59. $q = Config::$g_con->prepare("SELECT * FROM `unban_requests` WHERE `tip` = 1 AND `user` = ? ORDER BY `id` DESC, `status` DESC");
  60. $q->execute(array(Config::getData('users', 'name', $_SESSION['user'])));
  61. while($row = $q->fetch(PDO::FETCH_OBJ)) { ?>
  62. <tr>
  63. <td><a href="<?php echo Config::$_PAGE_URL ?>unban/?id=<?php echo $row->id ?>"> Unban request - <?php echo $row->user ?></a></td>
  64. <td><?php echo $row->data ?></td>
  65. <td><?php echo (!$row->status ? "Open" : "Closed") ?></td>
  66. </tr>
  67. <?php } ?>
  68. </tbody>
  69. </table>
  70. </div>
  71. </div>
  72. </div>
  73.  
  74. <form method="GET" action="">
  75. <input class="btn btn-small btn-danger" type="submit" name="request" value="New unban request">
  76. </form>
  77. <br>
  78.  
  79. <?php if(Config::getData('users', 'Admin', $_SESSION['user']) >= 6) {?>
  80. <div class="row">
  81. <div class="col-xs-12 center">
  82. <div class="table-responsive" style="margin-left: 30px">
  83. <table id="sample-table-1" class="table table-striped table-bordered table-hover">
  84. <thead>
  85. <tr>
  86. <th>Title</th>
  87. <th>
  88. <i class="icon-time bigger-110 hidden-480"></i>
  89. Date
  90. </th>
  91. <th class="hidden-480">Status</th>
  92. </tr>
  93. </thead>
  94. <tbody>
  95. <?php
  96. $q = Config::$g_con->prepare("SELECT * FROM `unban_requests` WHERE `tip` = 1 ORDER BY `id` DESC, `status` DESC");
  97. $q->execute();
  98. while($row = $q->fetch(PDO::FETCH_OBJ)) { ?>
  99. <tr>
  100. <td><a href="<?php echo Config::$_PAGE_URL ?>unban/?id=<?php echo $row->id ?>"> Unban request - <?php echo $row->user ?></a></td>
  101. <td><?php echo $row->data ?></td>
  102. <td><?php echo (!$row->status ? "Open" : "Closed") ?></td>
  103. </tr>
  104. <?php } ?>
  105. </tbody>
  106. </table>
  107. </div>
  108. </div>
  109. <?php }
  110. } else {
  111. $nume = Config::$g_con->prepare("SELECT `user` FROM `unban_requests` WHERE `user` = ? AND `status` = 0 AND `tip` = 1");
  112. $nume->execute(array(Config::getData("users", "name", $_SESSION['user'])));
  113. if($nume->rowCount()) {
  114. echo Config::message("yellow", "Ai depus deja o cerere. Vei primi un r&#259;spuns &#238;n cel mai scurt timp posibil. <a href='".Config::$_PAGE_URL."unban'>« Go back </a>");
  115. } else {
  116. $q = Config::$g_con->prepare("SELECT * FROM `bans` WHERE `PlayerName`=:name AND `Active` = 1");
  117. $q->execute(array(":name" => Config::getData('users', 'name', $_SESSION['user'])));
  118. if(!$q->rowCount()) echo '<div class="alert alert-danger">You are not banned. </div>';
  119. else {
  120. if(isset($_POST['submit'])) {
  121.  
  122.  
  123.  
  124. echo '<br>';
  125. while($row = $q->fetch(PDO::FETCH_OBJ)) {
  126.  
  127. @$text = htmlspecialchars($_POST['text']);
  128.  
  129. //@$text = htmlspecialchars($_POST['text']);
  130. $user = Config::getData('users', 'name', $_SESSION['user']);
  131. $qp = Config::$g_con->prepare("INSERT INTO `unban_requests`(`id`, `text`, `tip`, `user`, `data`, `status`, `idd`) VALUES ('', ?, 1, ?, CURRENT_TIMESTAMP, 0, id)");
  132. $qp->execute(array($text,$user));
  133. echo Config::message('success', '<center> Cererea a fost trimis&#259;. Vei fi redirec&#355;ionat &#238;n 5 secunde. </center>');
  134. // mysql_query("INSERT INTO email (text, playerid) VALUES ('Your unban request has been created.', '".Config::getData('users', 'id', $_SESSION['user'])."'");
  135. echo '<br>';
  136. echo '<meta http-equiv="refresh" content="5;URL=\''.Config::$_PAGE_URL.'unban\'/>';
  137.  
  138. } } else {
  139.  
  140. while($roww2 = $q->fetch(PDO::FETCH_OBJ)) {
  141. ?>
  142. <div class="span8">
  143.  
  144. <div class="alert alert-warning">
  145. Daca stii ca ai fost sanctionat corect, nu are rost sa faci cererea de unban. Nu vei fi debanat.
  146. </div>
  147.  
  148.  
  149. <h4>Creaza cerere unban</h4>
  150. <hr>
  151. <form method="POST" action="" accept-charset="UTF-8">
  152. Banat de: <b><?php echo $roww2->AdminName ?></b><br/>
  153. Motiv ban: <b><?php echo $roww2->Reason ?></b><br/>
  154. Data banului: <b><?php echo $roww2->BanTimeDate ?></b><br/>
  155. <?php if($roww2->Permanent == 1) {
  156. $expira = "permanent";
  157. } else {
  158. $expira = "". gmdate("Y-m-d H:i:s", $roww2->Time) ."";
  159. } ?>
  160. Banul expira pe: <b><?php echo $expira ?></b><br/>
  161.  
  162.  
  163.  
  164.  
  165. <br/>
  166. <label for="text">Detalii: </label><br />
  167. <textarea class="form-control" rows="5" name="text" cols="50" id="text"></textarea>
  168. <br/>
  169.  
  170.  
  171. <input class="btn btn-small btn-danger" type="submit" name="submit" value="Creaza cerere unban">
  172.  
  173. </form>
  174. </div>
  175.  
  176. <div class="span4">
  177. <h4>Info</h4>
  178. <ul>
  179. <li>Poate dura pana la 24 de ore pana se va raspunde la cererea de unban</li>
  180. <li>Daca ti s-a raspuns la cererea de unban si ti s-a zis ca banul ramane, nu crea alta.</li>
  181. </ul>
  182.  
  183. <?php }
  184. }
  185. }
  186. }
  187. }
  188. } else {
  189. /* --- verificare pentru a nu posta daca cererea nu-i apartine ---
  190. if(Config::getData("users", "Admin", $_SESSION['user']) < 6) {
  191. $p = Config::$g_con->prepare("SELECT `id` FROM `unban_requests` WHERE `user` = :user AND `id` = :id");
  192. $p->bindParam(":user", Config::getData("users", "Name", $_SESSION['user']), PDO::PARAM_STR, 24);
  193. $p->bindParam(":id", $_GET['id'], PDO::PARAM_INT);
  194. $p->execute();
  195. if(!$p->rowCount()) {
  196. header("Location: ".Config::$_PAGE_URL.'unban');
  197. }
  198.  
  199. }*/
  200. if(isset($_POST['submit']) && @$_POST['submit'] == 'Accepta' && (Config::getData("users", "Admin", $_SESSION['user'])) >= 6) {
  201. $q = Config::$g_con->prepare("SELECT * FROM `unban_requests` WHERE `id`= ? AND `tip` = 1");
  202. $id = $_GET['id'];
  203. $q->execute(array($id));
  204. while($row = $q->fetch(PDO::FETCH_OBJ)) {
  205. $close = Config::$g_con->prepare("INSERT INTO emails (Message, playerid, LinkPanel, giverid) VALUES
  206. ('Cererea ta de unban a fost acceptata de adminul ".Config::getData('users', 'name', $_SESSION['user']).".', '".Config::getID('users', 'id', $row->user)."', 'unban?id=".$id."', '".Config::getID('users', 'id', $_SESSION['user'])."')");
  207. //$q->bindParam(":id", $id, PDO::PARAM_INT);
  208. $close->execute(); }
  209. $user = Config::getData("unban_requests", "user", $_GET['id']);
  210. $acc = Config::$g_con->prepare("UPDATE `bans` SET `Active` = 0 WHERE `PlayerName` = ?");
  211. $acc->execute(array($user));
  212. $close = Config::$g_con->prepare("UPDATE `unban_requests` SET `status` = 1 WHERE `id` = ?");
  213. $close->execute(array($_GET['id']));
  214. }
  215. if(isset($_POST['submit']) && @$_POST['submit'] == 'Respinge' && (Config::getData("users", "Admin", $_SESSION['user'])) >= 6) {
  216. $q = Config::$g_con->prepare("SELECT * FROM `unban_requests` WHERE `id`= ? AND `tip` = 1");
  217. $id = $_GET['id'];
  218. $q->execute(array($id));
  219. while($row = $q->fetch(PDO::FETCH_OBJ)) {
  220. $close = Config::$g_con->prepare("INSERT INTO emails (Message, playerid, LinkPanel, giverid) VALUES
  221. ('Cererea ta de unban a fost inchisa de adminul ".Config::getData('users', 'name', $_SESSION['user']).". Daca a fost respinsa si postezi din nou, vei primi suspend in panel.',
  222. '".Config::getID('users', 'id', $row->user)."',
  223. 'unban?id=".$id."',
  224. '".Config::getID('users', 'id', $_SESSION['user'])."')");
  225. $close->execute(array($id)); }
  226. $close = Config::$g_con->prepare("UPDATE `unban_requests` SET `status` = 1 WHERE `id` = ?");
  227. $close->execute(array($_GET['id']));
  228. }
  229. if(isset($_POST['submit']) && @$_POST['submit'] == 'Post' && isset($_POST['text'])) {
  230. $text = htmlspecialchars($_POST['text']);
  231. $user = Config::getData("users", "name", $_SESSION['user']);
  232. $id = $_GET['id'];
  233. if(!empty($text) && strlen($text) >= 5) {
  234. $q = Config::$g_con->prepare("INSERT INTO `reply_requests`(`id`, `text`, `tip`, `user`, `data`, `status`, `idd`) VALUES ('', ?, 0, ?, CURRENT_TIMESTAMP, 0, ?)");
  235. $q->execute(array($text,$user,$id));
  236. }
  237. }
  238.  
  239. if(isset($_POST['submit']) && @$_POST['submit'] == 'Sterge' && (Config::getData("users", "Admin", $_SESSION['user'])) >= 6) {
  240. $q = Config::$g_con->prepare("SELECT * FROM `unban_requests` WHERE `id`=? AND `tip` = 1");
  241. $id = $_GET['id'];
  242. $q->execute(array($id));
  243. while($row = $q->fetch(PDO::FETCH_OBJ)) {
  244. $close = Config::$g_con->prepare("DELETE FROM `unban_requests` WHERE `id` = ?");
  245. $close->execute(array($_GET['id']));
  246. }
  247. echo '<meta http-equiv="refresh" content="0;URL=\''.Config::$_PAGE_URL.'unban\'/>';
  248. }
  249. $q = Config::$g_con->prepare("SELECT * FROM `unban_requests` WHERE `id`= ? AND `tip` = 1");
  250. $id = $_GET['id'];
  251. $q->execute(array($id));
  252. while($row = $q->fetch(PDO::FETCH_OBJ)) {
  253.  
  254. echo '<div class="span6">
  255. <h4>Unban request</h4>
  256.  
  257. Nickname: <a href="'.Config::$_PAGE_URL.'profile/'.Config::getID('users', 'name', $row->user).'">'.$row->user.'</a><br/>
  258. Level: '.Config::getID("users", "Level", $row->user).'<br/>
  259. Faction: '.Config::getID("users", "Member", $row->user).'<br/>
  260. Hours played: '.Config::getID("users", "ConnectedTime", $row->user).'
  261. <hr>
  262. '. $row->text .'<br/>
  263. <hr>
  264. Topic status: <b>'.($row->status ? "<b> Closed </b>" : "<b> Open </b>").'</b><br>';
  265. $q = Config::$g_con->prepare("SELECT * FROM `bans` WHERE `PlayerName`= ? AND `Active` = 1");
  266. $q->execute(array(Config::getID('users', 'name', $row->user)));
  267. while($row1 = $q->fetch(PDO::FETCH_OBJ)) {
  268. echo 'Ban type: <b>'.($row1->IPBan ? "<b> IP Ban </b>" : "<b> Normal Ban </b>").'</b><br/>';
  269. }
  270. echo'<hr>
  271.  
  272. </div>';
  273. echo "<div class='span6'>
  274.  
  275. <div class='widget-box'>
  276. <div class='widget-header'>
  277. <h4 class='widget-title lighter smaller'>
  278. <i class='icon-rss red'></i>
  279. Comments
  280. </h5>
  281. </div>
  282. <div class='widget-body'>
  283. <div class='widget-main no-padding'>
  284. <div class='dialogs'>
  285. ";
  286. $idd_count = Config::$g_con->prepare("SELECT * FROM `reply_requests` WHERE `idd`= ?");
  287. $idd_count->execute(array($_GET['id']));
  288. if(!$idd_count->rowCount())
  289. echo "
  290. <div class='itemdiv dialogdiv'>
  291. <div class='body'>
  292. Momentan nu exist&#259; niciun r&#259;spuns la aceast&#259; cerere.
  293. </div>
  294. </div>
  295. ";
  296. else {
  297. $query = Config::$g_con->prepare("SELECT * FROM `reply_requests` WHERE `idd`= ? AND `tip` = 0 ORDER BY `id` ASC");
  298. $query->execute(array($_GET['id']));
  299. while($r = $query->fetch(PDO::FETCH_OBJ)) {
  300. ?>
  301. <div class='itemdiv dialogdiv'>
  302. <div class='user'>
  303. <img alt="<?php echo $r->user ?>'s Avatar" src="<?php echo Config::$_PAGE_URL ?>assets/images/avatars/<?php echo (Config::getID("users", "Model", $r->user)) ?>.png"/>
  304. </div>
  305. <div class='body'>
  306. <div class='time'>
  307. <i class='icon-time'></i>
  308. <span class='green'>
  309. <?php echo $r->data ?>
  310. </span>
  311. </div>
  312. <div class='text'>
  313. <p>
  314. <a href="<?php echo Config::$_PAGE_URL ?>profile/<?php echo Config::getID("users", "name", $r->user) ?>"><?php echo $r->user ?></a> <?php if(((Config::getID("users", "Admin", $r->user)) >0)) { ?><span class='label label-info arrowed arrowed-in-right'>Admin</span><?php } ?>
  315. <br/>
  316. <?php echo $r->text ?>
  317. <span class='pull-right'>
  318. </span>
  319. </p>
  320. </div>
  321. </div>
  322. </div>
  323. <?php }
  324. }
  325. echo "
  326. </div>
  327. </div>
  328. ";
  329. if(!Config::getData("unban_requests", "status", $_GET['id'])) {
  330. echo "
  331. <form class='form-horizontal' method='POST' style='margin: 0 15px 20px 60px;' action='".Config::$_PAGE_URL."unban/?id=".htmlspecialchars($_GET['id'])."'>
  332. <h5>Leave a reply</h5>
  333. <textarea class='input-block-level' placeholder='reply text...' name='text'></textarea>
  334. <br/>
  335.  
  336. <input type='submit' name='submit' class='btn btn-small btn-danger' value='Post'/>
  337. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  338. ";
  339. if(Config::getData("users", "Admin", $_SESSION['user']) >= 6) {
  340. echo "
  341. <input type='submit' name='submit' class='btn btn-small btn-success' value='Accepta'/>
  342. <input type='submit' name='submit' class='btn btn-small btn-yellow' value='Respinge'/>
  343. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  344. <input type='submit' name='submit' class='btn btn-small btn-danger' value='Sterge'/>
  345. <br>
  346. <font size='0.8px'>
  347. <i> * Acceptă - se scoate banul şi cererea se închide </i>
  348. <br>
  349. <i> * Respinge - banul rămâne şi cererea se închide </i>
  350. </font>
  351. "; } echo "
  352. </form>";
  353. } else {
  354. echo '
  355. <form class="form-horizontal" method="POST" style="margin: 0 15px 20px 60px;" action="".Config::$_PAGE_URL."unban/?id=".$_GET["id"]."">
  356. <h5>Leave a reply</h5>
  357. <textarea class="input-block-level" placeholder="You can\'t reply to this topic, reason: This topic is closed." name="text" disabled></textarea>
  358. <br/>
  359. <input type="submit" name="submit" class="btn btn-small btn-danger" value="Post" disabled style="color: white;"/>
  360. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  361. </form>';
  362. }
  363. echo "
  364. </div>
  365. </div>
  366. </div>";
  367. echo '</div>';
  368. }
  369. }
  370. }
  371. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!