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; }