d1nka , 
<?php
include_once('db.php');
//ONLINE
$timeout = time() - 3600;
$online = $db->query("SELECT `id` FROM `users` WHERE online > '$timeout'")->num_rows;
$db->query("Update game_data set online='$online'");
function BBcodeLog($msg)
{
$msg = preg_replace('#\[item](.*?)\[/item]#si', '{$1}', $msg);
$msg = preg_replace('#\[mob](.*?)\[/mob]#si', '{$1}', $msg);
$msg = preg_replace('#\[usr=([0-9]+)\](.*?)\[/usr]#si', '$2{$1}', $msg);
return $msg;
}
/*-----------========---------*/
$reqDndMapLog = $db->query("SELECT * FROM dnd_map_log order by id desc");
while($dsa=$reqDndMapLog->fetch_array()){
$lxy = explode(':',$dsa[cord]);
$map = $db->query("SELECT name from dnd_map where id='$lxy[0]' limit 1")->fetch_array();
$textDndMapLogFile .= '['.date("H:i:s j.n.Y", $dsa[time]).'] : '.BBcodeLog(htmlspecialchars_decode($dsa[text])).' : ['.$map[name].' '.$lxy[2].'-'.$lxy[3]."]\n\n";
}
$dndMapLogNameFile = PATH.'log/dnd_map_log_'.date('n_Y',time()).'.log';
$textDndMapLogFile .= file_get_contents($dndMapLogNameFile) . PHP_EOL;
file_put_contents($dndMapLogNameFile, $textDndMapLogFile);/*---------=============-----------*/
$reqOrenda = $db->query("SELECT `item`,`usr` from `vesh_item` where `orenda`>='1' and `orenda_time_end`<'".time()."'");
if ($reqOrenda->num_rows>0) {
while ($mag=$reqOrenda->fetch_array()) {
$db->query("DELETE from `vesh_item` where `item`='$mag[item]' limit 1");
$db->query("UPDATE `users` set `time_vost_harak`='0' where `id`='$mag[usr]' limit 1");
}
}
$db->query("DELETE from `vesh_trade_area` where `orenda`>='1' and `orenda_time_end`<'".time()."'");
$db->query("DELETE from `vesh_sklad` where `orenda`>='1' and `orenda_time_end`<'".time()."'");
$db->query("DELETE from `vesh_sklad_side` where `orenda`>='1' and `orenda_time_end`<'".time()."'");
$timeVip = time();
$db->query("DELETE from `users_vip` where `day_end`<'$timeVip'");
?>
Kruk (13 фев 2024, в 18:05) d1nka , <?php
include_once('db.php');
//ONLINE
$timeout = time() - 3600;
$online = $db->query("SELECT `id` FROM `users` WHERE online > '$timeout'")->num_rows;
$db->query("Update game_data set online='$online'");
function BBcodeLog($msg)
{
$msg = preg_replace('#\[item](.*?)\[/item]#si', '{$1}', $msg);
$msg = preg_replace('#\[mob](.*?)\[/mob]#si', '{$1}', $msg);
$msg = preg_replace('#\[usr=([0-9]+)\](.*?)\[/usr]#si', '$2{$1}', $msg);
return $msg;
}
/*-----------========---------*/
$reqDndMapLog = $db->query("SELECT * FROM dnd_map_log order by id desc");
while($dsa=$reqDndMapLog->fetch_array()){
$lxy = explode(':',$dsa[cord]);
$map = $db->query("SELECT name from dnd_map where id='$lxy[0]' limit 1")->fetch_array();
$textDndMapLogFile .= '['.date("H:i:s j.n.Y", $dsa[time]).'] : '.BBcodeLog(htmlspecialchars_decode($dsa[text])).' : ['.$map[name].' '.$lxy[2].'-'.$lxy[3]."]\n\n";
}
$dndMapLogNameFile = PATH.'log/dnd_map_log_'.date('n_Y',time()).'.log';
$textDndMapLogFile .= file_get_contents($dndMapLogNameFile) . PHP_EOL;
file_put_contents($dndMapLogNameFile, $textDndMapLogFile);/*---------=============-----------*/
$reqOrenda = $db->query("SELECT `item`,`usr` from `vesh_item` where `orenda`>='1' and `orenda_time_end`<'".time()."'");
if ($reqOrenda->num_rows>0) {
while ($mag=$reqOrenda->fetch_array()) {
$db->query("DELETE from `vesh_item` where `item`='$mag[item]' limit 1");
$db->query("UPDATE `users` set `time_vost_harak`='0' where `id`='$mag[usr]' limit 1");
}
}
$db->query("DELETE from `vesh_trade_area` where `orenda`>='1' and `orenda_time_end`<'".time()."'");
$db->query("DELETE from `vesh_sklad` where `orenda`>='1' and `orenda_time_end`<'".time()."'");
$db->query("DELETE from `vesh_sklad_side` where `orenda`>='1' and `orenda_time_end`<'".time()."'");
$timeVip = time();
$db->query("DELETE from `users_vip` where `day_end`<'$timeVip'");
?>