Файл: slando.icu/system/cron99990_pirat/1_day.php
Строк: 76
<?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("Не могу подключиться к серверу БД");
mysqli_query ($link,"set names utf8");
$in_game = time() - 87000;
mysqli_query($link,"UPDATE `users` SET `zabralpodar`='0',`obmengold`='0' where `authtime` > '$in_game'");
mysqli_query($link,"TRUNCATE `clans_jobs`");
$time=time()-3*24*60*60;
$rinok=mysqli_query($link,"SELECT * FROM `rinok` WHERE `time`<'$time' ");
while($pak = mysqli_fetch_array($rinok))
{
if($pak['tipint']==0){$id_v=$pak['tip'];if ($id_v == 1) {$res='lumber';}if ($id_v== 2) {$res='tkani';}if ($id_v == 3) {$res='rom';}if ($id_v == 4) {$res='steel';}
if ($id_v == 5) {$res='money';}if ($id_v == 6) {$res='gold';}
if ($id_v == 7) {$res='caribi_money';$imr=144;}
mysqli_query($link,"UPDATE `users` SET `$res`=`$res`+'".num($pak['kol'])."' WHERE `id`='".num($pak['id_add'])."'");
mysqli_query($link,"DELETE FROM `rinok` WHERE `id`='".num($pak['id'])."'");
}elseif($pak['tipint']==1){$id_v=$pak['tip'];
if ($id_v == 1) {$res='kozha_akula_bik';}if ($id_v== 2) {$res='kozha_g_kit';}if ($id_v == 3) {$res='kost_bel_akula';}
if ($id_v == 4) {$res='kozha_kosatka';}if ($id_v == 5) {$res='kost_tigr_akula';}
if ($id_v == 6) {$res='kost_kit_akula';}if ($id_v == 7) {$res='kost_rif_akula';}if ($id_v == 8) {$res='kost_akul_molot';}
if ($id_v == 9) {$res='kozha_b_kit';}
mysqli_query($link,"UPDATE `users` SET `$res`=`$res`+'".num($pak['kol'])."' WHERE `id`='".num($pak['id_add'])."'");mysqli_query($link,"DELETE FROM `rinok` WHERE `id`='".num($pak['id'])."'");
}elseif($pak['tipint']==2){
mysqli_query($link,"UPDATE `inventar` SET `rinok`='0' WHERE `id`='".num($pak['tip'])."'");
mysqli_query($link,"DELETE FROM `rinok` WHERE `id`='".num($pak['id'])."'");
}
elseif($pak['tipint']==3){
mysqli_query($link,"UPDATE `inventar` SET `rinok`='0' WHERE `id`='".num($pak['tip'])."'");
mysqli_query($link,"DELETE FROM `rinok` WHERE `id`='".num($pak['id'])."'");
}
}
?>