Файл: cron/logovo_sbros.php
Строк: 55
<?php
include "dbconfig.php" ;
include "function.php" ;
$table = "users" ;
$table1 = "table1" ;
mysql_connect($hostname, $username, $password) or die("Не могу создать соединение") ;
/* Выбираем базу данных. Если произойдет ошибка - вывести ее */
mysql_select_db($dbName) or die(mysql_error()) ;
mysql_query('SET character_set_connection = utf8') ;
mysql_query('SET character_set_client = utf8') ;
mysql_query('SET character_set_results = utf8') ;
mysql_query("TRUNCATE TABLE `logovo_pers`");
mysql_query("update pers_info set logovo='0' ");
$query = "SELECT * FROM `table1` where ((`gild_apteka`>'0')or (`gild_orug`>'0')or(`gild_skor`>'0')or(`gild_art`>'0')or(`gild_travnik`>'0')or(`gild_rudokop`>'0')or(`gild_digger`>'0')or(`gild_kuznec`>'0') )" ;
$sql1 = mysql_query($query) or die(mysql_error()) ;
$zoloto=0;
while($row = mysql_fetch_assoc($sql1)){
$query1 = "SELECT * FROM `time_online` where `name`='".$row['name']."' and `everyday`>'120'";
$sql11 = mysql_query($query1) or die(mysql_error()) ;
while($row1 = mysql_fetch_assoc($sql11)){
$zoloto=(($row['gild_apteka']+$row['gild_orug']+$row['gild_skor']+$row['gild_art']+$row['gild_travnik']+$row['gild_rudokop']+$row['gild_digger']+$row['gild_kuznec'])*100);
$z=$row['bank']+$zoloto;
mysql_query("update `table1` set `bank`='$z',`time_online`='0',`hosts`='0' where `name`='".$row['name']."'");
mysql_query("INSERT INTO `post` ( `name` , `text` , `date` , `otkogo`,`pro` ,`polyc`,`prochitano`)
VALUES (
'".$row['name']."', 'Вам гильдии выплатили $zoloto з.', '".time()."', 'Выплата гильдий','1','0','1'
)") or die(mysql_error()) ;
mysql_query("UPDATE `table1` SET `pismo`='1'WHERE `name`='" .
mysql_real_escape_string($row['name']) . "';") or die(mysql_error()) ;
;}
;}
//////////////////////////////////////////////////
$query = "SELECT * FROM `table1` " ;
$sql1 = mysql_query($query) or die(mysql_error()) ;
$zoloto=0;
while($row = mysql_fetch_assoc($sql1)){
$query1 = "SELECT * FROM `time_online` where `name`='".$row['name']."' and `everyday`>'120'";
$sql11 = mysql_query($query1) or die(mysql_error()) ;
while($row1 = mysql_fetch_assoc($sql11)){
$z=$row['dop_cent']+10;
mysql_query("update `table1` set `dop_cent`='$z',`time_online`='0',`hosts`='0' where `name`='".$row['name']."'");
mysql_query("INSERT INTO `post` ( `name` , `text` , `date` , `otkogo`,`pro` ,`polyc`,`prochitano`)
VALUES (
'".$row['name']."', 'Вам Начисленно 10 дополнительных центов', '".time()."', 'Выплата гильдий','1','0','1'
)") or die(mysql_error()) ;
mysql_query("UPDATE `table1` SET `pismo`='1'WHERE `name`='" .
mysql_real_escape_string($row['name']) . "';") or die(mysql_error()) ;
;}
;}
mysql_query("UPDATE `time_online` SET `everyday`='0' ;");
mysql_query("TRUNCATE TABLE `eday_pers_qw`");
?>