public function getChildCategories($pid = FALSE, $all_langs = FALSE)
{
global $_CONF, $_TABLES;
$entries = array();
if ($pid !== FALSE) {
return $entries;
}
$sql = "SELECT forum_id, forum_name FROM {$_TABLES['gf_forums']} " . " WHERE (is_hidden = '0') ";
if (!Dataproxy::isRoot()) {
$current_groups = SEC_getUserGroups(Dataproxy::uid());
$sql .= "AND (grp_id IN (" . implode(',', $current_groups) . ")) ";
}
$sql .= "ORDER BY forum_order";
$result = DB_query($sql);
if (DB_error()) {
return $entries;
}
while (($A = DB_fetchArray($result, FALSE)) !== FALSE) {
$entry = array();
$entry['id'] = (int) $A['forum_id'];
$entry['pid'] = FALSE;
$entry['title'] = stripslashes($A['forum_name']);
$entry['uri'] = $_CONF['site_url'] . '/forum/index.php?forum=' . $entry['id'];
$entry['date'] = FALSE;
$entry['image_uri'] = FALSE;
$entries[] = $entry;
}
return $entries;
}
/**
* @param $pid int/string/boolean id of the parent category. FALSE means
* the top category (with no parent)
* @return array(
* 'id' => $id (string),
* 'pid' => $pid (string: id of its parent)
* 'title' => $title (string),
* 'uri' => $uri (string),
* 'date' => $date (int: Unix timestamp),
* 'image_uri' => $image_uri (string)
* )
*/
public function getChildCategories($pid = FALSE, $all_langs = FALSE)
{
global $_CONF, $_TABLES, $_MG_CONF;
$entries = array();
if (Dataproxy::isAnon() and $this->isLoginRequired()) {
return $entries;
}
if ($pid === FALSE) {
$pid = 0;
}
$sql = "SELECT album_id, album_title, album_parent, last_update " . " FROM {$_TABLES['mg_albums']} " . "WHERE (album_parent = '" . addslashes($pid) . "') ";
if (!Dataproxy::isRoot()) {
$sql .= COM_getPermSQL('AND ', Dataproxy::uid()) . " AND (hidden = '0') ";
}
$sql .= " ORDER BY album_order";
$result = DB_query($sql);
if (DB_error()) {
return $entries;
}
while (($A = DB_fetchArray($result)) !== FALSE) {
$entry = array();
$entry['id'] = $A['album_id'];
$entry['pid'] = $A['album_parent'];
$entry['title'] = stripslashes($A['album_title']);
$entry['uri'] = $_MG_CONF['site_url'] . '/album.php?aid=' . $entry['id'];
$entry['date'] = $A['last_update'];
$entry['image_uri'] = FALSE;
$entries[] = $entry;
}
return $entries;
}
/**
* 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;
$entries = array();
if (empty(Dataproxy::$startDate) or empty(Dataproxy::$endDate)) {
return $entries;
}
$sql_date = "AND (UNIX_TIMESTAMP(date) BETWEEN '" . Dataproxy::$startDate . "' AND '" . Dataproxy::$endDate . "') ";
if (Dataproxy::$isGL150) {
if (Dataproxy::$isGL170) {
$sql = "SELECT pid, topic, UNIX_TIMESTAMP(modified) AS day " . " FROM {$_TABLES['polltopics']} " . "WHERE (UNIX_TIMESTAMP(modified) BETWEEN '" . Dataproxy::$startDate . "' AND '" . Dataproxy::$endDate . "') ";
} else {
$sql = "SELECT pid, topic, UNIX_TIMESTAMP(date) AS day " . " FROM {$_TABLES['polltopics']} " . "WHERE (1 = 1) " . $sql_date;
}
if (!Dataproxy::isRoot()) {
$sql .= COM_getPermSQL('AND', Dataproxy::uid());
}
$sql .= " ORDER BY pid";
$result = DB_query($sql);
if (DB_error()) {
return $entries;
}
while (($A = DB_fetchArray($result, FALSE)) !== FALSE) {
$entry = array();
$entry['id'] = $A['pid'];
$entry['title'] = stripslashes($A['topic']);
$entry['uri'] = $_CONF['site_url'] . '/polls/index.php?pid=' . urlencode($entry['id']);
$entry['date'] = $A['day'];
$entry['image_uri'] = FALSE;
$entries[] = $entry;
}
} else {
$sql = "SELECT qid, question, UNIX_TIMESTAMP(date) AS day " . "FROM {$_TABLES['pollquestions']} " . "WHERE (1 = 1) " . $sql_date;
if (!Dataproxy::isRoot()) {
$sql .= COM_getPermSQL('AND', Dataproxy::uid());
}
$sql .= " ORDER BY qid";
$result = DB_query($sql);
if (DB_error()) {
return $entries;
}
while (($A = DB_fetchArray($result, FALSE)) !== FALSE) {
$entry = array();
$entry['id'] = $A['qid'];
$entry['title'] = stripslashes($A['question']);
$entry['uri'] = $_CONF['site_url'] . '/polls/index.php?qid=' . urlencode($entry['id']) . '&aid=-1';
$entry['date'] = $A['day'];
$entry['image_uri'] = FALSE;
$entries[] = $entry;
}
}
return $entries;
}
/**
* 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($tid = '', $all_langs = FALSE)
{
global $_CONF, $_TABLES;
$entries = array();
if (empty(Dataproxy::$startDate) or empty(Dataproxy::$endDate)) {
return $entries;
}
$sql = "SELECT sid, title, UNIX_TIMESTAMP(date) AS day " . " FROM {$_TABLES['stories']} " . "WHERE (draft_flag = 0) AND (date <= NOW()) " . " AND (UNIX_TIMESTAMP(date) BETWEEN '" . Dataproxy::$startDate . "' AND '" . Dataproxy::$endDate . "') ";
if (!empty($tid)) {
$sql .= "AND (tid = '" . addslashes($tid) . "') ";
}
if (!Dataproxy::isRoot()) {
$sql .= COM_getTopicSql('AND', Dataproxy::uid()) . COM_getPermSql('AND', Dataproxy::uid());
if (function_exists('COM_getLangSQL') and $all_langs === FALSE) {
$sql .= COM_getLangSQL('sid', 'AND');
}
}
$result = DB_query($sql);
if (DB_error()) {
return $entries;
}
while (($A = DB_fetchArray($result, FALSE)) !== FALSE) {
$entry = array();
$entry['id'] = stripslashes($A['sid']);
$entry['title'] = stripslashes($A['title']);
$entry['uri'] = COM_buildUrl($_CONF['site_url'] . '/article.php?story=' . stripslashes($A['sid']));
$entry['date'] = $A['day'];
$entry['imageurl'] = FALSE;
$entries[] = $entry;
}
return $entries;
}
/**
* @param $all_langs boolean: true = all languages, true = current language
* 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($event_type = '', $all_langs = false)
{
global $_CONF, $_TABLES;
$entries = array();
if (empty(Dataproxy::$startDate) or empty(Dataproxy::$endDate)) {
return $entries;
}
$sql = "SELECT eid, title, UNIX_TIMESTAMP(datestart) AS day1, " . " UNIX_TIMESTAMP(timestart) AS day2 " . "FROM {$_TABLES['eventsjp']} " . "WHERE (UNIX_TIMESTAMP(datestart) BETWEEN '" . Dataproxy::$startDate . "' AND '" . Dataproxy::$endDate . "') ";
if (!empty($event_type)) {
$sql .= "AND (event_type = '" . addslashes($event_type) . "') ";
}
if (!Dataproxy::isRoot()) {
$sql .= COM_getPermSql('AND', Dataproxy::uid());
}
$sql .= " ORDER BY day1 DESC, day2 DESC";
$result = DB_query($sql);
if (DB_error()) {
return $entries;
}
while (($A = DB_fetchArray($result, FALSE)) !== FALSE) {
$entry = array();
$entry['id'] = $A['eid'];
$entry['title'] = stripslashes($A['title']);
$entry['uri'] = $_CONF['site_url'] . '/calendarjp/event.php?eid=' . $entry['id'];
$entry['date'] = (int) $A['day1'] + (int) $A['day2'];
$entry['image_uri'] = FALSE;
$entries[] = $entry;
}
return $entries;
}
/**
* 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($cid = '', $all_langs = FALSE)
{
global $_CONF, $_TABLES;
$entries = array();
if (empty(Dataproxy::$startDate) or empty(Dataproxy::$endDate)) {
return $entries;
}
$sql = "SELECT f.lid, f.title, f.logourl, f.date " . " FROM {$_TABLES['downloads']} AS f " . " LEFT JOIN {$_TABLES['downloadcategories']} AS c " . " ON f.cid = c.cid " . "WHERE (f.is_released = 1) " . " AND (f.is_listing = 1) " . " AND (f.date <= UNIX_TIMESTAMP(NOW())) " . " AND (f.date BETWEEN '" . Dataproxy::$startDate . "' AND '" . Dataproxy::$endDate . "') ";
if (!empty($cid)) {
$sql .= " AND (c.is_enabled = 1) " . " AND (f.cid = '" . addslashes($cid) . "') ";
if ($all_langs === FALSE) {
$sql .= COM_getLangSQL('cid', 'AND', 'c');
}
}
if (!Dataproxy::isRoot()) {
$sql .= COM_getPermSQL('AND', Dataproxy::uid(), 2, 'c');
}
$result = DB_query($sql);
if (DB_error()) {
return $entries;
}
while (($A = DB_fetchArray($result, FALSE)) !== FALSE) {
$entry = array();
$entry['id'] = $A['lid'];
$entry['title'] = stripslashes($A['title']);
$entry['uri'] = COM_buildUrl($_CONF['site_url'] . '/downloads/index.php?id=' . $entry['id']);
$entry['date'] = (int) $A['date'];
$entry['image_uri'] = $A['logourl'];
$entries[] = $entry;
}
return $entries;
}
/**
* 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($cid = '', $all_langs = FALSE)
{
global $_CONF, $_TABLES, $_FM_TABLES;
$entries = array();
if (empty(Dataproxy::$startDate) or empty(Dataproxy::$endDate)) {
return $entries;
}
$sql = "SELECT lid, f.title, logourl, date " . " FROM {$_FM_TABLES['filemgmt_filedetail']} AS f " . " LEFT JOIN {$_FM_TABLES['filemgmt_cat']} AS c " . " ON f.cid = c.cid " . "WHERE (date BETWEEN '" . Dataproxy::$startDate . "' AND '" . Dataproxy::$endDate . "') ";
if (!empty($cid)) {
$sql .= "AND (f.cid = '" . addslashes($cid) . "') ";
}
if (!Dataproxy::isRoot()) {
$sql .= "AND (c.grp_access IN (" . implode(',', SEC_getUserGroups(Dataproxy::uid())) . "))";
}
$result = DB_query($sql);
if (DB_error()) {
return $entries;
}
while (($A = DB_fetchArray($result, FALSE)) !== FALSE) {
$entry = array();
$entry['id'] = $A['lid'];
$entry['title'] = stripslashes($A['title']);
$entry['uri'] = $_CONF['site_url'] . '/filemgmt/index.php?id=' . $entry['id'];
$entry['date'] = $A['date'];
$entry['image_uri'] = FALSE;
$entries[] = $entry;
}
return $entries;
}
/**
* 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($tid = '', $all_langs = FALSE)
{
global $_CONF, $_TABLES;
$retval = array();
if (empty(Dataproxy::$startDate) or empty(Dataproxy::$endDate)) {
return $retval;
}
// Collects sids
$sql = "SELECT id " . " FROM {$_TABLES['topic_assignments']} " . "WHERE (type= 'article') AND (tdefault = 1) ";
if (!empty($tid)) {
$sql .= " AND (tid = '" . addslashes($tid) . "') ";
}
if (!Dataproxy::isRoot()) {
$sql .= COM_getTopicSql('AND', Dataproxy::uid());
}
$result = DB_query($sql);
if (DB_error()) {
return $retval;
} else {
$sids = array();
while (($A = DB_fetchArray($result, FALSE)) !== FALSE) {
$sids[] = addslashes($A['id']);
}
if (count($sids) === 0) {
return $retval;
}
}
$sql = "SELECT sid, title, UNIX_TIMESTAMP(date) AS day " . " FROM {$_TABLES['stories']} " . "WHERE (draft_flag = 0) AND (date <= NOW()) " . " AND (UNIX_TIMESTAMP(date) BETWEEN '" . Dataproxy::$startDate . "' AND '" . Dataproxy::$endDate . "') " . " AND (sid IN ('" . implode("', '", $sids) . "')) ";
if (!Dataproxy::isRoot()) {
$sql .= COM_getPermSql('AND', Dataproxy::uid());
if ($all_langs === FALSE) {
$sql .= COM_getLangSQL('sid', 'AND');
}
}
$sql .= " ORDER BY date DESC ";
$result = DB_query($sql);
if (DB_error()) {
return $retval;
}
while (($A = DB_fetchArray($result, FALSE)) !== FALSE) {
$entry = array();
$entry['id'] = stripslashes($A['sid']);
$entry['title'] = stripslashes($A['title']);
$entry['uri'] = COM_buildUrl($_CONF['site_url'] . '/article.php?story=' . stripslashes($A['sid']));
$entry['date'] = $A['day'];
$entry['imageurl'] = FALSE;
$retval[] = $entry;
}
return $retval;
}
/**
* @note This function ignores static pages which are displayed in the
* center blok.
* @refer $_SP_CONF['sort_by']
*
* 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, $_SP_CONF;
$entries = array();
if (empty(Dataproxy::$startDate) or empty(Dataproxy::$endDate)) {
return $entries;
}
if (Dataproxy::$isGL170) {
$sql = "SELECT sp_id, sp_title, UNIX_TIMESTAMP(modified) AS day " . " FROM {$_TABLES['staticpage']} " . "WHERE (UNIX_TIMESTAMP(modified) BETWEEN '" . Dataproxy::$startDate . "' AND '" . Dataproxy::$endDate . "') ";
} else {
$sql = "SELECT sp_id, sp_title, UNIX_TIMESTAMP(sp_date) AS day " . " FROM {$_TABLES['staticpage']} " . "WHERE (UNIX_TIMESTAMP(sp_date) BETWEEN '" . Dataproxy::$startDate . "' AND '" . Dataproxy::$endDate . "') ";
}
if ($this->_isSP162) {
$sql .= "AND (draft_flag = 0) ";
}
if (!Dataproxy::isRoot()) {
$sql .= COM_getPermSql('AND', Dataproxy::uid());
}
if (in_array($_SP_CONF['sort_by'], array('id', 'title', 'date'))) {
$crit = $_SP_CONF['sort_by'];
} else {
$crit = 'id';
}
$crit = 'sp_' . $crit;
if (Dataproxy::$isGL170 and $crit === 'sp_date') {
$crit = 'modified';
}
$sql .= " ORDER BY " . $crit;
$result = DB_query($sql);
if (DB_error()) {
return $entries;
}
while (($A = DB_fetchArray($result, FALSE)) !== FALSE) {
$entry = array();
$entry['id'] = stripslashes($A['sp_id']);
$entry['title'] = stripslashes($A['sp_title']);
$entry['uri'] = COM_buildURL($_CONF['site_url'] . '/staticpages/index.php?page=' . rawurlencode($entry['id']));
$entry['date'] = $A['day'];
$entry['image_uri'] = FALSE;
$entries[] = $entry;
}
return $entries;
}
/**
* 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;
$entries = array();
if (empty(Dataproxy::$startDate) or empty(Dataproxy::$endDate)) {
return $entries;
}
$sql = "SELECT lid, title, UNIX_TIMESTAMP(date) AS date_u " . "FROM {$_TABLES['links']} " . "WHERE (UNIX_TIMESTAMP(date) BETWEEN '" . Dataproxy::$startDate . "' AND '" . Dataproxy::$endDate . "') ";
if (!empty($category)) {
if (Dataproxy::$isGL150) {
// for GL-1.5.0+
$sql .= "AND (cid = '" . addslashes($category) . "') ";
} else {
// for - GL-1.5.0
$sql .= "AND (category = '" . addslashes($category) . "') ";
}
}
if (!Dataproxy::isRoot()) {
$sql .= COM_getPermSQL('AND', Dataproxy::uid());
}
$sql .= "ORDER BY date_u DESC";
$result = DB_query($sql);
if (DB_error()) {
return $entries;
}
while (($A = DB_fetchArray($result, FALSE)) !== FALSE) {
$entry = array();
$A = array_map('stripslashes', $A);
$entry['id'] = $A['lid'];
$entry['title'] = $A['title'];
$entry['uri'] = COM_buildURL($_CONF['site_url'] . '/links/portal.php?what=link&item=' . urlencode($this->toUtf8($entry['id'])));
$entry['date'] = $A['date_u'];
$entry['image_uri'] = FALSE;
$entries[] = $entry;
}
return $entries;
}
