Файл: inc/db.php
Строк: 14
<?
mysql_connect('localhost','hound613_user','kha43kj4kj') or my_error();
mysql_select_db('hound613_db') or my_error();
mysql_query('SET NAMES utf8');
$query = mysql_query("SELECT * FROM `config` LIMIT 1");
$config = mysql_fetch_assoc($query);
if ($config['srok'] != 0) {
$del = time() - (86400 * $config['srok']);
$sql = "DELETE
FROM ads
WHERE `time`<='{$del}'";
$result = mysql_query($sql);
}
if ($config['vip'] != 0) {
if ($config['srok_vip'] != 0) {
$del = time() - (86400 * $config['srok_vip']);
$sql = "UPDATE ads SET `vip` = '0',
`time_vip` = '0'
WHERE `time_vip`<='{$del}' AND `vip` = '1'";
$result = mysql_query($sql);
}
}
if ($config['srok_vverh'] != 0) {
$del = time() - (86400 * $config['srok_vverh']);
$sql = "UPDATE ads SET `cvet` = '',
`time_vverh` = '0'
WHERE `time_verh`<='{$del}' AND `cvet` != ''";
$result = mysql_query($sql);
}
?>