<?
define('DB_HOST', 'localhost'); // сервер
define('DB_NAME', 'foc673_login'); // имя базы
define('DB_USER', 'foc673_login'); // пользователь
define('DB_PASS', 'pass'); // пароль
$pdo = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME.";charset=UTF8", DB_USER, DB_PASS);
$pdo->query('SET NAMES utf8');
$lord = 5;
$date_lord1 = strtotime('09:00');
$date_lord2 = strtotime('16:00');
$date_lord3 = strtotime('23:00');
if(time() <= $date_lord1){
$date_lord_derev = strtotime('09:00');
}elseif(time() <= $date_lord2){
$date_lord_derev = strtotime('16:00');
}elseif(time() <= $date_lord3){
$date_lord_derev = strtotime('23:00');
}else{
$date_lord_derev = strtotime('next day 09:00');
}
$lord_cron = $pdo->query("SELECT * FROM `lord` WHERE `start` = '0' ORDER BY `id` DESC")->fetch();
$pdo->prepare("INSERT INTO `lord` SET `time`= ?,`start`= ?, `time2`= ?")->execute(array($date_lord_derev,0,$date_lord_derev+(60*$lord)));
if($lord_cron['time'] <= time()){
$pdo->prepare("UPDATE `lord` SET `start` = ? WHERE `id` = ?")->execute(array(1,$lord_cron['id']));
}
$lord_cron_delit = $pdo->query("SELECT * FROM `lord` WHERE `start` = '1' ORDER BY `id` DESC")->fetch();
$pdo->prepare("DELETE FROM `lord_member` WHERE `battle` = ?")->execute(array(($lord_cron_delit['id'] - 1)));
?>