Advertisement
Guest User

Untitled

a guest
Jun 21st, 2020
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.44 KB | None | 0 0
  1. <?php
  2. $conn = mysqli_connect('хост', 'юзер', 'пароль', 'база');
  3. date_default_timezone_set('Europe/Moscow');
  4. if (!$conn) exit('[CONNECTION ERROR]');
  5.  
  6. $nick = trim(htmlspecialchars(mysqli_real_escape_string($conn, $_POST['nick'])));
  7. $server = trim(htmlspecialchars(mysqli_real_escape_string($conn, $_POST['server'])));
  8. $hwid = trim(htmlspecialchars(mysqli_real_escape_string($conn, $_POST['hwid'])));
  9.  
  10. if (!empty($nick) & !empty($server) & !empty($hwid)) {
  11. $result = $conn->query("SELECT * FROM `accounts` WHERE `nick` = '".$nick."' AND `server` = '".$server."' AND `hwid` = '".$hwid."'");
  12. if (mysqli_num_rows($result) == 0) {
  13. $conn->query("INSERT INTO `accounts` (`server`, `nick`, `hwid`, `status`, `date`) VALUES ('" . $server . "', '" . $nick . "', '" . $hwid . "', '0' , '" . date('Y/m/d H:i:s') . "')");
  14. $status = array(
  15. "status" => "added"
  16. );
  17. echo json_encode( $status );
  18. } else {
  19. $result_get_status = $conn->query("SELECT * FROM `accounts` WHERE `nick` = '".$nick."' AND `server` = '".$server."' AND `hwid` = '".$hwid."' AND `status` = '1'");
  20. if (mysqli_num_rows($result_get_status) == 1) {
  21. $status = array(
  22. "status" => "1"
  23. );
  24. echo json_encode( $status );
  25. } else {
  26. $status = array(
  27. "status" => "0"
  28. );
  29. echo json_encode( $status );
  30. }
  31. $result_get_status->close();
  32. }
  33. $result->close();
  34. } else {
  35. echo "Не введены данные";
  36. }
  37. $conn->close();
  38. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement