Файл: phpfile/time_online.php
Строк: 27
<?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') ;
$pasttt=time()-900;
$pasttt=time()-900;
$querywse = "SELECT * FROM `table1` where `timme`>'$pasttt' " ;
$sqlwse = mysql_query($querywse) or die(mysql_error()) ;
;
while ($row0 = mysql_fetch_array($sqlwse))
{
$querywse2 = "SELECT * FROM `time_online` where `name` ='".$row0['name']."' " ;
$sqlwse2 = mysql_query($querywse2) or die(mysql_error()) ;
;
while ($row01 = mysql_fetch_array($sqlwse2))
{
$row01['everyday']+=15;
mysql_query("
UPDATE `time_online` SET `everyday`='".$row01['everyday']."' WHERE `name` ='".$row01['name']."' LIMIT 1 ;");
mysql_query("UPDATE `table1` SET `time_online`='".$row01['everyday']."' WHERE `name`='" .
mysql_real_escape_string($row0['name']) . "' LIMIT 1") or die(mysql_error()) ;
}
;}
?>