Page 2 of 2

Re: Info

Posted: 2016 Oct 18 23:13
by DYaGesS
cron_remover.php

Code: Select all

<?php $mysqli = new mysqli("localhost", "root", "password", "amxbans"); $mysqli->query("DELETE FROM `amx_amxadmins` WHERE `expired` < '".time()."'");$mysqli->query("DELETE FROM `amx_admins_servers` WHERE `admin_id` NOT IN (SELECT a.id FROM `amx_amxadmins` a)");?>
--->

Code: Select all

<?php $mysqli = new mysqli("localhost", "root", "password", "amxbans"); $mysqli->query("DELETE FROM `amx_amxadmins` WHERE `expired` < '".time()."' AND `days` != 0");$mysqli->query("DELETE FROM `amx_admins_servers` WHERE `admin_id` NOT IN (SELECT a.id FROM `amx_amxadmins` a)");?>

Re: Info

Posted: 2016 Oct 19 00:25
by laimiukas3
working :)

-- 2016 Spa 19 02:32 --
Molvas wrote:Kiek matau reikia į crontaba failiuka duomenis surašyti, pabandysiu, ačiū.

P.S Per contrab -e auto daryti?
turbut taip

crontab -e

25 09 * * * php /var/www/cron/cron_remover.php 09:25 AM

service cron restart

Re: Info

Posted: 2016 Nov 01 16:43
by Minde
Sveiki vyriukai, matau išsprendėt problema su pasibaigusiu admin ištrynimu :) reiks ir man išbandyti. Kur ta faila rasti ir kur imesti cron_remover.php :)

Re: Info

Posted: 2016 Nov 01 16:57
by Zygis
tai gal cia unban/cron :D

Re: Info

Posted: 2016 Nov 01 17:33
by laimiukas3
Zygis wrote:tai gal cia unban/cron :D
rez sms sitmoja taip jis yra unban/cron bet ten istrindavo privilegijas jaigu budavo uzdetos visam tai geriau pries tai pasiziurekite ar atnaujino
o kurioje vietoje bus tas www/ php failas nesvarbu