<?php
ini_set("magic_quotes_runtime", 0);
date_default_timezone_set("Brazil/East");
$servername = "mysql.hostinger.com.br";
$username = "u219386471_herox";
$password = "38782521a";
$dbname = "u219386471_herox";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$co = $_COOKIE['info'];
$info = explode("&", $co);
$usuario = $info[0];
$sql = "SELECT * FROM ban WHERE usuario='$usuario'";
$result = $conn->query($sql);
if($result->num_rows == 1){
    die("vc foi banido");
}
if(isset($_GET['env']) == 'true'){

$message = $_GET['msg'];
$data = date("d/m/y H:m:s");
if(strstr($message, ':limpar')){
$sql2 = "TRUNCATE chat_logs";
$conn->query($sql2);
exit;
} else if(strstr($message, ':ban')){
$ex = explode(" ",$message);
$sql2 = "INSERT INTO ban values(null,'$ex[1]','$ex[2]')";
$conn->query($sql2);
$sql2 = "INSERT INTO chat_logs values(null,'bot','O $ex[1] foi banido do projeto','$data')";
$conn->query($sql2);
exit();
} else if(strstr($message, ':desban')){
$ex = explode(" ",$message);
$sql2 = "DELETE FROM ban where usuario='$ex[1]'";
$conn->query($sql2);
$sql2 = "INSERT INTO chat_logs values(null,'bot','O $ex[1] foi desbanido do projeto','$data')";
$conn->query($sql2);
exit();
} if(strstr($message, ':kick')){
$ex = explode(" ",$message);
}
$sql2 = "INSERT INTO chat_logs values(null,'$usuario','$message','$data')";
$conn->query($sql2);
} else if(isset($_GET['get']) == 'true'){
if(!isset($_GET['id'])){
    die();
}
$id = $_GET['id'];
$a = array();
$per = 0;

$sql = "SELECT id, usuario, message, data FROM chat_logs ORDER BY id asc LIMIT $id,20";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $per = 1;
        $a[] = array(
        'id' => $row['id'],
        'usuario' => $row['usuario'],
        'message' => $row['message'],
        'data' => $row['data']
        );
    }
} else {
    $per = 0;
}
$sql1 = "SELECT id, usuario, message, data FROM chat_logs";
$result1 = $conn->query($sql1);
echo json_encode(array('per' => ''.$per.'','id' => $result1->num_rows,'message' => $a));
$conn->close();
}
?>