$result = mysql_query($sql); while ($result && ($field = mysql_fetch_assoc($result))) { $_RESULT["films"][] = $field; } break; case "getpoplist": $count = isset($_REQUEST['count']) ? (int) $_REQUEST['count'] : 10; $sql = "SELECT ID, Name, Hit/(TO_DAYS(NOW()) - TO_DAYS(CreateDate) + 1) as Hit FROM films WHERE films.Hide=0 " . ($itemFilter ? "AND {$itemFilter}" : '') . " ORDER BY Hit DESC LIMIT 0,{$count}"; $result = mysql_query($sql); while ($result && ($field = mysql_fetch_assoc($result))) { $_RESULT["films"][] = $field; } break; case "inc_hit": if (isset($_REQUEST['filmid'])) { inc_hit($user["ID"], (int) $_REQUEST['filmid']); } break; case "update_imdbrating": $film = isset($_REQUEST['film']) ? (int) $_REQUEST['film'] : false; $service_url = "http://service.lanmediaservice.com/actions.php"; if (!$film) { $days = isset($_REQUEST['days']) ? (int) $_REQUEST['days'] : 30; $result = mysql_query("SELECT ID, CreateDate, imdbID FROM films WHERE UpdateDate<=(NOW()- INTERVAL {$days} DAY) AND (LENGTH(imdbID)>0) ORDER BY RAND()"); $_RESULT["films_to_update"] = array(); $films_to_update = array(); $updated_films = array(); $_RESULT["updated"] = 0; $query = array(); while ($result && ($field = mysql_fetch_assoc($result))) { preg_match("/(\\d+)/i", $field["imdbID"], $matches);
exit; } $result = mysql_select_db($config['mysqldb'], $idSQLConnection); if (!$result) { echo "Критическая ошибка на сервере. Ошибка при выборе базы данных."; exit; } if (isset($config['mysql_set_names'])) { mysql_query($config['mysql_set_names']); } $filmid = (int) $_REQUEST['filmid']; $fileid = isset($_REQUEST['fileid']) ? $wherefile = " AND files.ID = '" . mysql_real_escape_string($_REQUEST['fileid']) . "' " : ($wherefile = ""); $userid = isset($_REQUEST['uid']) ? (int) $_REQUEST['uid'] : 0; $v = isset($_REQUEST['v']) ? addslashes($_REQUEST['v']) : ""; if ($userid > 0) { inc_hit($userid, $filmid); } switch (strtolower($_REQUEST["player"])) { case "ftp": if ($filmid && getLeechProtectionCode(array($filmid, $_REQUEST['fileid'], $userid)) == $v) { $maxdownload = isset($config['max_ftp_download']) ? $config['max_ftp_download'] : 0; $today_hits = array(); $message = ""; if ($maxdownload) { $sql = "SELECT * FROM hits WHERE DateHit > NOW() - INTERVAL 1 DAY AND UserID={$userid}"; $result = mysql_query($sql); while ($result && ($field = mysql_fetch_assoc($result))) { $today_hits[] = $field["FilmID"]; } if (count($today_hits) > $maxdownload && !in_array($filmid, $today_hits)) { echo "Извините, Ваш лимит на сутки в {$maxdownload} закачек исчерпан.";