Advertisement
Guest User

Untitled

a guest
Aug 24th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.13 KB | None | 0 0
  1. <?php
  2. ini_set("magic_quotes_runtime", 0);
  3. date_default_timezone_set("Brazil/East");
  4. $servername = "mysql.hostinger.com.br";
  5. $username = "u219386471_herox";
  6. $password = "u219386471_herox";
  7. $dbname = "pr";
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9. if ($conn->connect_error) {
  10. die("Connection failed: " . $conn->connect_error);
  11. }
  12. $usuario = $husuario;
  13. $sql = "SELECT * FROM ban WHERE usuario='$usuario = $husuario;'";
  14. $result = $conn->query($sql);
  15. if($result->num_rows == 1){
  16. die("vc foi banido");
  17. }
  18. if(isset($_GET['env']) == 'true'){
  19.  
  20. $message = $_GET['msg'];
  21. $data = date("d/m/y H:m:s");
  22. if(strstr($message, ':limpar')){
  23. $sql2 = "TRUNCATE chat_logs";
  24. $conn->query($sql2);
  25. exit;
  26. } else if(strstr($message, ':ban')){
  27. $ex = explode(" ",$message);
  28. $sql2 = "INSERT INTO ban values(null,'$ex[1]','$ex[2]')";
  29. $conn->query($sql2);
  30. $sql2 = "INSERT INTO chat_logs values(null,'bot','O $ex[1] foi banido do projeto','$data')";
  31. $conn->query($sql2);
  32. exit();
  33. } else if(strstr($message, ':desban')){
  34. $ex = explode(" ",$message);
  35. $sql2 = "DELETE FROM ban where usuario='$ex[1]'";
  36. $conn->query($sql2);
  37. $sql2 = "INSERT INTO chat_logs values(null,'bot','O $ex[1] foi desbanido do projeto','$data')";
  38. $conn->query($sql2);
  39. exit();
  40. } if(strstr($message, ':kick')){
  41. $ex = explode(" ",$message);
  42. }
  43. $sql2 = "INSERT INTO chat_logs values(null,'$usuario = $husuario;','$message','$data')";
  44. $conn->query($sql2);
  45. } else if(isset($_GET['get']) == 'true'){
  46. if(!isset($_GET['id'])){
  47. die();
  48. }
  49. $id = $_GET['id'];
  50. $a = array();
  51. $per = 0;
  52.  
  53. $sql = "SELECT id, usuario, message, data FROM chat_logs ORDER BY id asc LIMIT $id,20";
  54. $result = $conn->query($sql);
  55.  
  56. if ($result->num_rows > 0) {
  57. while($row = $result->fetch_assoc()) {
  58. $per = 1;
  59. $a[] = array(
  60. 'id' => $row['id'],
  61. 'usuario' => $row['usuario'],
  62. 'message' => $row['message'],
  63. 'data' => $row['data']
  64. );
  65. }
  66. } else {
  67. $per = 0;
  68. }
  69. $sql1 = "SELECT id, usuario, message, data FROM chat_logs";
  70. $result1 = $conn->query($sql1);
  71. echo json_encode(array('per' => ''.$per.'','id' => $result1->num_rows,'message' => $a));
  72. $conn->close();
  73. }
  74. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement