Файл: slando.icu/system/cron99990_pirat/1_h.php
Строк: 40
<?php
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
function send_mess($id_add,$id_poluchat,$text)
{
GLOBAL $link;
$aq2 = mysqli_query($link,"select DISTINCT id,id_poluchat,id_add from `dialog` WHERE `id_poluchat`='$id_poluchat' and `id_add`='$id_add' or `id_add`='$id_poluchat' and `id_poluchat`='$id_add' ");
if (mysqli_num_rows($aq2)=='0'){
mysqli_query($link,"INSERT INTO `dialog` (`id`,`id_add`,`id_poluchat`,`time`)VALUES ('','$id_add','$id_poluchat','".time()."')");
$aq2 = mysqli_query($link,"select DISTINCT id,id_poluchat,id_add from `dialog` WHERE `id_poluchat`='$id_poluchat' and `id_add`='$id_add' or `id_add`='$id_poluchat' and `id_poluchat`='$id_add' ");
}
$aq2 =mysqli_fetch_array($aq2);
mysqli_query($link,"UPDATE `dialog` SET `time`='".time()."' WHERE `id`='".num($aq2['id'])."' ");
mysqli_query($link,"INSERT INTO `msg` (`id`,`id_add`,`id_poluchat`,`text`,`time`,`dialog`)VALUES ('','$id_add','$id_poluchat','$text','".time()."','".num($aq2['id'])."')");
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
function vvod($vvod){GLOBAL $link; return trim(mysqli_real_escape_string($link,$vvod));}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
function vivod($vivod){return trim(htmlspecialchars(stripslashes($vivod)));}
/*** подключение ***/
$link=mysqli_connect('localhost','db1533816919','bembem','db1533816919') or die("Не могу подключиться к серверу БД");
$timemw=time()-31*24*60*60;
mysqli_query($link,"DELETE FROM `clans_chat` WHERE `date`<='$timem'");
mysqli_query($link,"DELETE FROM `logi_users` WHERE `data`<='$timemw'");
$timem=time()-500*60*60;
mysqli_query($link,"DELETE FROM `msg` WHERE `time`<='$timem'");
$timemw=time()-3*31*24*60*60;
mysqli_query($link,"DELETE FROM `logi_ip` WHERE `data`<='$timemw'");
$timemw=time()-200*60*60;
mysqli_query($link,"DELETE FROM `clans_log` WHERE `date`<='$timemw' limit 500");
$timemw=time()-12*60*60;
mysqli_query($link,"DELETE FROM `chat` WHERE `date`<='$timemw'");
mysqli_query($link,"TRUNCATE `logi_user`");
mysqli_query($link,"TRUNCATE `travel_chat`");
mysqli_query($link,"TRUNCATE `aborgazh_logi`");
?>