Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include "l/info.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);
- }
- $usuario = $husuario;
- echo $usuario;
- $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();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement