protected function __construct($aSystem)
{
parent::__construct($aSystem);
$this->_aQueryParts = array('fields' => "`ID`, `EntryUri`, `DateTime`", 'field_date' => "DateTime", 'field_date_type' => "timestamp", 'table' => "`bx_ads_main`", 'join' => "", 'where' => "AND `Status` = 'active' AND `AllowView` = '" . BX_DOL_PG_ALL . "'", 'order' => " `DateTime` ASC ");
$this->_oModule = BxDolModule::getInstance('BxAdsModule');
}
protected function __construct($aSystem)
{
parent::__construct($aSystem);
$this->_aQueryParts = array('fields' => "`ID`, `EntryUri`, `Date`, `EventStart`, `EventEnd`", 'field_date' => "Date", 'field_date_type' => "timestamp", 'table' => "`bx_events_main`", 'join' => "", 'where' => "AND `Status` = 'approved' AND `allow_view_event_to` = '" . BX_DOL_PG_ALL . "'", 'order' => " `Date` ASC ");
$this->_oModule = BxDolModule::getInstance('BxEventsModule');
}
protected function __construct($aSystem)
{
parent::__construct($aSystem);
$this->_aQueryParts = array('fields' => "`id`, `uri`, `created`", 'field_date' => "created", 'field_date_type' => "timestamp", 'table' => "`bx_groups_main`", 'join' => "", 'where' => "AND `status` = 'approved' AND `allow_view_group_to` = '" . BX_DOL_PG_ALL . "'", 'order' => " `created` ASC ");
$this->_oModule = BxDolModule::getInstance('BxGroupsModule');
}
protected function __construct($aSystem)
{
parent::__construct($aSystem);
$this->_aQueryParts = array('fields' => "`PostID`, `PostUri`, `PostDate`", 'field_date' => "PostDate", 'field_date_type' => "timestamp", 'table' => "`bx_blogs_posts`", 'join' => "", 'where' => "AND `PostStatus` = 'approval' AND `allowView` = '" . BX_DOL_PG_ALL . "'", 'order' => " `PostDate` ASC ");
$this->_oModule = BxDolModule::getInstance('BxBlogsModule');
}
protected function __construct($aSystem)
{
parent::__construct($aSystem);
$this->_aQueryParts = array('fields' => "`ID`, `Uri`, `Date`, `Owner`", 'field_date' => "Date", 'field_date_type' => "timestamp", 'table' => "`sys_albums`", 'join' => "", 'where' => "AND `Type` = 'bx_videos' AND `Status` = 'active' AND `ObjCount` > 0 AND `AllowAlbumView` = '" . BX_DOL_PG_ALL . "'", 'order' => " `Date` ASC ");
$this->_oModule = BxDolModule::getInstance('BxVideosModule');
}
protected function __construct($aSystem)
{
parent::__construct($aSystem);
$this->_aQueryParts = array('fields' => "`ID`, `DateLastEdit`", 'field_date' => "DateLastEdit", 'field_date_type' => "datetime", 'table' => "`Profiles`", 'join' => "", 'where' => "AND `Profiles`.`Status` = 'Active' AND `allow_view_to` = '" . BX_DOL_PG_ALL . "' AND (`Profiles`.`Couple` = 0 OR `Profiles`.`Couple` > `Profiles`.`ID`)", 'order' => " `DateLastNav` ASC ");
}
protected function __construct($aSystem)
{
parent::__construct($aSystem);
$this->_aQueryParts = array('fields' => "`id`, `uri`, `date`", 'field_date' => "date", 'field_date_type' => "timestamp", 'table' => "`bx_fdb_entries`", 'join' => "", 'where' => "AND `status` = '" . BX_TD_STATUS_ACTIVE . "'", 'order' => " `date` ASC ");
$this->_oModule = BxDolModule::getInstance('BxFdbModule');
}
protected function __construct($aSystem)
{
parent::__construct($aSystem);
$this->_aQueryParts = array('fields' => "`e`.`ID`, `e`.`Uri`, `e`.`Date`", 'field_date' => "Date", 'field_date_type' => "timestamp", 'table' => "`RayVideoFiles` AS `e`", 'join' => " INNER JOIN `sys_albums_objects` AS `o` ON (`o`.`id_object` = `e`.`ID`)\n INNER JOIN `sys_albums` AS `a` ON (`a`.`Type` = 'bx_videos' AND `a`.`Status` = 'active' AND `a`.`AllowAlbumView` = '" . BX_DOL_PG_ALL . "' AND `a`.`ID` = `o`.`id_album`)", 'where' => "AND `e`.`Status` = 'approved'", 'order' => " `e`.`Date` ASC ");
$this->_oModule = BxDolModule::getInstance('BxVideosModule');
}
protected function __construct($aSystem)
{
parent::__construct($aSystem);
$this->_aQueryParts = array('fields' => "`id_poll`, `poll_date`", 'field_date' => "poll_date", 'field_date_type' => "timestamp", 'table' => "`bx_poll_data`", 'join' => "", 'where' => "AND `poll_status` = 'active' AND `allow_view_to` = '" . BX_DOL_PG_ALL . "'", 'order' => " `poll_date` ASC ");
$this->_oModule = BxDolModule::getInstance('BxPollModule');
}
protected function __construct($aSystem, &$oModule)
{
parent::__construct($aSystem);
$this->_oModule = $oModule;
$this->_aQueryParts = array('fields' => "`id`, `uri`, `when`", 'field_date' => "when", 'field_date_type' => "timestamp", 'table' => "`" . $this->_oModule->_oConfig->getDbPrefix() . "entries`", 'join' => "", 'where' => "AND `status` = '" . BX_TD_STATUS_ACTIVE . "'", 'order' => " `when` ASC ");
}
protected function __construct($aSystem)
{
parent::__construct($aSystem);
}
protected function __construct($aSystem)
{
parent::__construct($aSystem);
$this->_aQueryParts = array('fields' => "`id`, `entryUri`, `date`", 'field_date' => "date", 'field_date_type' => "timestamp", 'table' => "`bx_sites_main`", 'join' => "", 'where' => "AND `status` = 'approved' AND `allowView` = '" . BX_DOL_PG_ALL . "'", 'order' => " `date` ASC ");
$this->_oModule = BxDolModule::getInstance('BxSitesModule');
}
protected function __construct($aSystem)
{
parent::__construct($aSystem);
$this->_aQueryParts = array('fields' => "`Name`, 0 AS `Date`", 'field_date' => "Date", 'field_date_type' => "timestamp", 'table' => "`sys_page_compose_pages`", 'join' => "", 'where' => "AND `System` = 0", 'order' => " `Order` ASC ");
}
protected function __construct($aSystem)
{
parent::__construct($aSystem);
$this->_aQueryParts = array('fields' => "`t`.`topic_id`, `t`.`topic_uri`, `t`.`last_post_when`", 'field_date' => "last_post_when", 'field_date_type' => "timestamp", 'table' => "`bx_forum_topic` AS `t`", 'join' => " INNER JOIN `bx_forum` AS `f` ON (`f`.`forum_id` = `t`.`forum_id` AND `f`.`forum_type` = 'public')", 'where' => "AND `t`.`topic_hidden` = 0 AND `t`.`topic_posts` > 0", 'order' => " `t`.`last_post_when` ASC ");
}
