/* * v1.00 * */ include("includes/startup.inc"); $query = array(); $query['select'] = "SELECT f.id AS id, f.name AS name, f.title AS title, c1.name AS category, f.director AS director, c2.name AS country, f.description AS description, f.link AS link, f.edition AS edition"; $query['from'] = "FROM {$config['baza_de_date']['prefix_tabel']}_films AS f LEFT JOIN {$config['baza_de_date']['prefix_tabel']}_categories AS c1 ON f.category = c1.id LEFT JOIN {$config['baza_de_date']['prefix_tabel']}_countries AS c2 ON f.country = c2.id"; $query['where'] = "WHERE TRUE"; $vars = ""; $condition = array(); if (isset($_GET['type'], $config['pagina']['tip_listare'][$_GET['type']])) { if ($_GET['type'] == "1") { // listare $title = preg_replace("/ @@@[0-9]+@@@/", "", $config['pagina']['tip_listare'][$_GET['type']]['titlu']); if (isset($_GET['edition']) && in_array($_GET['edition'], $config['pagina']['editie'])) { $title = preg_replace("/ @@@[0-9]+@@@/", " {$_GET['edition']}", $config['pagina']['tip_listare'][$_GET['type']]['titlu']); $vars = $_GET['edition']; $condition['edition'] = "f.edition = '{$_GET['edition']}'"; } } if ($_GET['type'] == "2") { // cautare // nefolosita if ($vars == "") { $vars = "type={$_GET['type']}"; } else { $vars = $vars . "&type={$_GET['type']}"; } $title = $config['pagina']['tip_listare'][$_GET['type']]['titlu']; if (isset($_GET['edition']) && in_array($_GET['edition'], $config['pagina']['editie'])) { if ($vars == "") { $vars = "edition={$_GET['edition']}"; } else { $vars = $vars . "&edition={$_GET['edition']}"; } $condition['edition'] = "f.edition = '{$_GET['edition']}'"; } if (isset($_GET['terms'])) { if ($vars == "") { $vars = "terms={$_GET['terms']}"; } else { $vars = $vars . "&terms={$_GET['terms']}"; } $condition['terms'] = "f.title LIKE '%{$_GET['terms']}%' OR c1.name LIKE '%{$_GET['terms']}%' OR f.director LIKE '%{$_GET['terms']}%' OR c2.name LIKE '%{$_GET['terms']}%' OR f.description LIKE '%{$_GET['terms']}%'"; foreach (explode(" ", $_GET['terms']) as $k => $v) { $condition['terms'] = $condition['terms'] . " OR f.title LIKE '%{$v}%' OR c1.name LIKE '%{$v}%' OR f.director LIKE '%{$v}%' OR c2.name LIKE '%{$v}%' OR f.description LIKE '%{$v}%'"; } } } } if (count($condition) != 0) { if (isset($condition['edition'])) { $query['where'] = $query['where'] . " AND ({$condition['edition']})"; } if (isset($condition['terms'])) { $query['where'] = $query['where'] . " AND ({$condition['terms']})"; } } $query['order'] = "ORDER BY f.title"; $db_query = array(); $db_query['citire_filme'] = "{$query['select']} {$query['from']} {$query['where']} {$query['order']}"; $db_result['citire_filme'] = query_db($db_query['citire_filme']); $results = mysqli_num_rows($db_result['citire_filme']); if ($results != 0) { if (isset($_GET['film'])) { $db_query['citire_film'] = "{$query['select']} {$query['from']} {$query['where']} AND (f.name = '{$_GET['film']}')"; $db_result['citire_film'] = query_db($db_query['citire_film']); if (mysqli_num_rows($db_result['citire_film']) != 0) { $db_array['citire_film'] = mysqli_fetch_assoc($db_result['citire_film']); } } if (! isset($db_array['citire_film'])) { $db_query['citire_film'] = "{$query['select']} {$query['from']} {$query['where']} ORDER BY RAND() LIMIT 1"; $db_result['citire_film'] = query_db($db_query['citire_film']); $db_array['citire_film'] = mysqli_fetch_assoc($db_result['citire_film']); } } else { $db_array['citire_film']['id'] = "0"; $db_array['citire_film']['title'] = "No signal"; $db_array['citire_film']['description'] = "your search returned 0 results"; $db_array['citire_film']['link'] = "c_T7NFpaK94"; $db_array['citire_film']['edition'] = $config['pagina']['editie'][0]; } ?>