require_once 'mysql.inc.php'; require_once 'functions.inc.php'; require_once 'table.inc.php'; print_header(); ?>
print_banner(); $today = mktime(0, 0, 0, date('m'), date('d'), date('Y')); $query = 'SELECT tor.id, tor.name, tor.seeds, tor.peers, tor.size, tor.time_added, tor.info, track.registered, cat.name AS cat, cat.id AS cat_id '; $query .= 'FROM torrents AS tor '; $query .= 'LEFT JOIN trackers AS track '; $query .= 'ON tor.id_tracker = track.id '; $query .= 'LEFT JOIN subcategories AS sub '; $query .= 'ON tor.id_subcategory = sub.id '; $query .= 'LEFT JOIN categories AS cat '; $query .= 'ON sub.id_category = cat.id '; $query .= 'WHERE tor.time_added >= "'.$today.'" '; $query .= 'ORDER BY '.get_table_order('cat ASC').', tor.time_added DESC '; $result = mysql_query($query) or die('Error in SQL query: '.mysql_error()); echo '