/** * Returns an array of ( * 'id' => $id (string), * 'title' => $title (string), * 'uri' => $uri (string), * 'date' => $date (int: Unix timestamp), * 'image_uri' => $image_uri (string) * ) */ public function getItemsByDate($category = '', $all_langs = FALSE) { global $_CONF, $_TABLES, $_MG_CONF; $entries = array(); if (Dataproxy::isAnon() and $this->isLoginRequired()) { return $entries; } if (empty(Dataproxy::$startDate) or empty(Dataproxy::$endDate)) { return $entries; } $sql = "SELECT media_id " . " FROM {$_TABLES['mg_media_albums']} " . "WHERE (album_id ='" . addslashes($category) . "') " . "ORDER BY media_order"; $result = DB_query($sql); if (DB_error()) { return $entries; } $media_ids = array(); while (($A = DB_fetchArray($result, FALSE)) !== FALSE) { $media_ids[] = "'" . $A['media_id'] . "'"; } if (count($media_ids) === 0) { return $entries; } $sql = "SELECT media_id, media_title, media_time " . " FROM {$_TABLES['mg_media']} " . "WHERE (media_id IN (" . implode(',', $media_ids) . "))" . " AND (media_time BETWEEN '" . Dataproxy::$startDate . "' AND '" . Dataproxy::$endDate . "') "; $result = DB_query($sql); if (DB_error()) { return $entries; } while (($A = DB_fetchArray($result, FALSE)) !== FALSE) { if (empty($A['media_title'])) { $A['media_title'] = $A['media_id']; } $entry = array(); $entry['id'] = stripslashes($A['media_id']); $entry['title'] = stripslashes($A['media_title']); $entry['uri'] = $_MG_CONF['site_url'] . '/media.php?s=' . urlencode($entry['id']); $entry['date'] = $A['media_time']; $entry['image_uri'] = FALSE; $entries[] = $entry; } return $entries; }