review.php 1.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. <?php
  2. require_once($_SERVER['DOCUMENT_ROOT'] . "/modules/core/header.php");
  3. require_once($_SERVER['DOCUMENT_ROOT'] . "/modules/core/staff.php");
  4. if(empty($_GET['app_id']))
  5. {
  6. header("location: ./admin/applications");
  7. exit;
  8. }
  9. $link = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);
  10. if($link === false)
  11. {
  12. die("ERROR: Could not connect. " . mysqli_connect_error());
  13. }
  14. $app_id = $_GET['app_id'];
  15. $user_check_query = "SELECT `id` FROM application WHERE `id` = '$app_id' AND `status` != '1' AND `accepted` != '1' AND `reviewed_by` = '-1'";
  16. $result = mysqli_query($link, $user_check_query);
  17. $rowcount = $result->num_rows;
  18. if($rowcount == 0)
  19. {
  20. header("location: ./admin/applications");
  21. exit();
  22. }
  23. mysqli_free_result($result);
  24. $data = date("d-m-Y h:i:s");
  25. $user_check_query = "UPDATE application SET `status` = '1', `reviewed_by` = '$playersqlid', `date_of_review` = '$data' WHERE `id` = '$app_id' LIMIT 1";
  26. $result = mysqli_query($link, $user_check_query);
  27. mysqli_free_result($result);
  28. header("location: ./admin/application/$app_id");
  29. ?>