1
0

ban.php 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. <?php
  2. require_once($_SERVER['DOCUMENT_ROOT'] . "/modules/core/header.php");
  3. require_once($_SERVER['DOCUMENT_ROOT'] . "/modules/core/staff.php");
  4. $link = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);
  5. if($link === false)
  6. {
  7. die("ERROR: Could not connect. " . mysqli_connect_error());
  8. }
  9. $app_id = $_SESSION['viewingapp'];
  10. if(empty($_POST['verdict'])) $verdict = "None";
  11. else $verdict = $_POST['verdict'];
  12. $clean_verdict = $verdict;
  13. $verdict = mysqli_escape_string($link, $verdict);
  14. $user_check_query = "SELECT `master`, `char_name`, `ip_address` FROM application WHERE `id` = '$app_id' AND `status` != '2' AND `accepted` != '2' AND `reviewed_by` != '-1'";
  15. $result = mysqli_query($link, $user_check_query);
  16. $rowcount = $result->num_rows;
  17. if($rowcount == 0)
  18. {
  19. header("location: ./admin/applications");
  20. exit();
  21. }
  22. $result2 = mysqli_fetch_array($result, MYSQLI_ASSOC);
  23. $master = $result2['master'];
  24. $char_name = $result2['char_name'];
  25. $ip_address = $result2['ip_address'];
  26. mysqli_free_result($result);
  27. $data = date("d-m-Y h:i:s");
  28. $user_check_query = "UPDATE application SET `status` = '2', `accepted` = '2', `reason` = '$verdict', `date_of_verdict` = '$data' WHERE `id` = '$app_id' LIMIT 1";
  29. $result = mysqli_query($link, $user_check_query);
  30. mysqli_free_result($result);
  31. $master_name = returnMaster($link, $master);
  32. issueBan($link, $master_name, $username, $verdict, $ip_address, 1);
  33. insertBanLog($link, $ip_address, $char_name, $username, $verdict, $master);
  34. mysqli_close($link);
  35. //Discord_AlertStaff("$username has denied application **#$app_id** and banned the applicant for '$clean_verdict'.");
  36. header("location: ./admin/application/$app_id");
  37. ?>