Example #1
0
myquery("UPDATE game_cron_log SET step='22. Очистка логов боев 2', timecron=" . time() . " WHERE id={$idcronlog}");
myquery("DELETE FROM game_combats_log_data WHERE boy NOT IN (SELECT DISTINCT boy FROM game_combats_log)");
myquery("UPDATE game_cron_log SET step='23.Очищение статистики денег и опыта', timecron=" . time() . " WHERE id={$idcronlog}");
myquery("DELETE FROM game_users_stat_gp WHERE game_users_stat_gp.timestamp<unix_timestamp(NOW() - INTERVAL 6 MONTH)");
myquery("DELETE FROM game_users_stat_exp WHERE game_users_stat_exp.timestamp<unix_timestamp(NOW() - INTERVAL 6 MONTH)");
myquery("UPDATE game_cron_log SET step='24. Управление лошадьми', timecron=" . time() . " WHERE id={$idcronlog}");
myquery("UPDATE game_users_horses SET life=GREATEST(0,life-1), golod=golod+1 WHERE used=1");
myquery("UPDATE game_cron_log SET step='25. Удаление игроков ПСЖ', timecron=" . time() . " WHERE id={$idcronlog}");
$users_psg = myquery("SELECT user_id FROM game_users_psg WHERE banned_date<=" . (time() - 60 * 60 * 24 * 28) . "");
$i = 0;
while (list($id) = mysql_fetch_array($users_psg)) {
    $check_items = myquery("select id, user_id from game_items where user_id='" . $id . "' and ((kleymo=2 and kleymo_id<>'" . $id . "') or kleymo=1)");
    if (mysql_num_rows($check_items) > 0) {
        while ($item = mysql_fetch_array($check_items)) {
            $Item = new Item();
            $Item->kleymo_return_from($item['id'], $item['user_id']);
        }
    }
    delete_user($id);
    $i++;
}
myquery("UPDATE game_cron_log SET step='26. Удаление игроков', timecron=" . time() . " WHERE id={$idcronlog}");
$i = 0;
$sel = myquery("SELECT game_users_archive.user_id, game_users_archive.name FROM game_users_archive,game_users_data WHERE game_users_archive.user_id=game_users_data.user_id AND game_users_archive.clevel=0 AND game_users_archive.exp<1000 AND game_users_data.last_visit>=" . (time() - 7 * 24 * 60 * 60) . "");
while (list($id, $name) = mysql_fetch_array($sel)) {
    delete_user($id, $name);
    $i++;
}
if ($da['mday'] == 1 and ($da['mon'] == 3 or $da['mon'] == 6 or $da['mon'] == 9 or $da['mon'] == 12)) {
    myquery("UPDATE game_cron_log SET step='27. Обновление сезонных предметов', timecron=" . time() . " WHERE id={$idcronlog}");
    $next = $da['mon'];