Файл: online/riwar/Riwar.ru/cron_files/bon.php
Строк: 28
<?php
ob_start();
define ('dbhost', 'localhost');//сервер
define ('dbname', 'valryru_rt');//имя БД
define ('dbpass', 'akson1989');//пароль БД
define ('dbuser', 'valryru_rtus');//Пользователь БД
$mysql_connect = mysql_connect(dbhost, dbuser, dbpass) or die('Сайт не доступен ,возможно Вы не прописали БД!');
mysql_query('SET NAMES `utf8`', $mysql_connect);
mysql_select_db(dbname, $mysql_connect) or die('Нету подключения к БД');
$bossy = mysql_query("SELECT id,zola from `users` order by `id` desc");
while($b = mysql_fetch_assoc($bossy)){ if($b['zola'] < 0){
mysql_query("UPDATE `users` set `zola` = '".($b['zola']+50)."' where `id` = '".$b['id']."'");
$text = 'Нас более 500 рыцарей! и мы одни должны противостоять тьме! каждому рыцарю +50 золота!!';
$con = mysql_result(mysql_query("SELECT COUNT(id) FROM `message_c` WHERE `kogo` = '".$b['id']."' and `kto` = '1' LIMIT 1"),0);
if($con == 0) {
mysql_query("INSERT INTO `message_c` SET `kto` = '1', `kogo` = '".$b['id']."', `time` = '".time()."', `posl_time` = '".time()."'");
mysql_query("INSERT INTO `message_c` SET `kto` = '".$b['id']."', `kogo` = '1', `time` = '".time()."', `posl_time` = '".time()."'");
}
mysql_query("UPDATE `message_c` SET `posl_time`='".time()."' WHERE `kogo` = '1' and `kto`='".$b['id']."' limit 1");
mysql_query("UPDATE `message_c` SET `posl_time`='".time()."' WHERE `kto` = '1' and `kogo`='".$b['id']."' limit 1");
mysql_query("INSERT INTO `message` SET `text` = '".$text."', `kto` = '1', `komy` = '".$b['id']."', `time` = '".time()."', `readlen` = '0'");
}else{
mysql_query("UPDATE `users` set `zola` = '".($b['zola']+50)."' where `id` = '".$b['id']."'");
$text = 'Нас более 500 рыцарей! и мы одни должны противостоять тьме! каждому рыцарю +50 золота!!';
$con = mysql_result(mysql_query("SELECT COUNT(id) FROM `message_c` WHERE `kogo` = '".$b['id']."' and `kto` = '1' LIMIT 1"),0);
if($con == 0) {
mysql_query("INSERT INTO `message_c` SET `kto` = '1', `kogo` = '".$b['id']."', `time` = '".time()."', `posl_time` = '".time()."'");
mysql_query("INSERT INTO `message_c` SET `kto` = '".$b['id']."', `kogo` = '1', `time` = '".time()."', `posl_time` = '".time()."'");
}
mysql_query("UPDATE `message_c` SET `posl_time`='".time()."' WHERE `kogo` = '1' and `kto`='".$b['id']."' limit 1");
mysql_query("UPDATE `message_c` SET `posl_time`='".time()."' WHERE `kto` = '1' and `kogo`='".$b['id']."' limit 1");
mysql_query("INSERT INTO `message` SET `text` = '".$text."', `kto` = '1', `komy` = '".$b['id']."', `time` = '".time()."', `readlen` = '0'");
}
}
?>