Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $conn = mysqli_connect('хост', 'юзер', 'пароль', 'база');
- date_default_timezone_set('Europe/Moscow');
- if (!$conn) exit('[CONNECTION ERROR]');
- $nick = trim(htmlspecialchars(mysqli_real_escape_string($conn, $_POST['nick'])));
- $server = trim(htmlspecialchars(mysqli_real_escape_string($conn, $_POST['server'])));
- $hwid = trim(htmlspecialchars(mysqli_real_escape_string($conn, $_POST['hwid'])));
- if (!empty($nick) & !empty($server) & !empty($hwid)) {
- $result = $conn->query("SELECT * FROM `accounts` WHERE `nick` = '".$nick."' AND `server` = '".$server."' AND `hwid` = '".$hwid."'");
- if (mysqli_num_rows($result) == 0) {
- $conn->query("INSERT INTO `accounts` (`server`, `nick`, `hwid`, `status`, `date`) VALUES ('" . $server . "', '" . $nick . "', '" . $hwid . "', '0' , '" . date('Y/m/d H:i:s') . "')");
- $status = array(
- "status" => "added"
- );
- echo json_encode( $status );
- } else {
- $result_get_status = $conn->query("SELECT * FROM `accounts` WHERE `nick` = '".$nick."' AND `server` = '".$server."' AND `hwid` = '".$hwid."' AND `status` = '1'");
- if (mysqli_num_rows($result_get_status) == 1) {
- $status = array(
- "status" => "1"
- );
- echo json_encode( $status );
- } else {
- $status = array(
- "status" => "0"
- );
- echo json_encode( $status );
- }
- $result_get_status->close();
- }
- $result->close();
- } else {
- echo "Не введены данные";
- }
- $conn->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement