$query = "SELECT a.*, u.name AS author, u.usertype"
$query = "SELECT a.*, UNIX_TIMESTAMP(a.created) AS created_t, UNIX_TIMESTAMP(a.modified) AS modified_t, u.name AS author, u.usertype"
// load individual item creator class $item = new FeedItem(); // item info $item->title = $item_title; $item->link = $item_link; $item->description = $item_description; $item->source = $info[ 'link' ];
// load individual item creator class $item = new FeedItem(); // item info $item->date = ($row->modified_t > 0) ? $row->modified_t : $row->created_t; $item->title = $item_title; $item->link = $item_link; $item->description = $item_description; $item->source = $info[ 'link' ];
$this->unix = 0;
$this->unix = $dateString;
$query .= "\n LEFT JOIN #__users u ON u.id = a.created_by" ."\n WHERE a.state = '1' AND a.access = '29'" ."\n AND a.sectionid !='0'" ."\n AND a.id !='53'" ."\n AND ( a.publish_up = '1979-12-19 00:00:00' OR a.publish_up <= '". $now ."' )" ."\n AND ( a.publish_down = '2060-01-01 00:00:00' OR a.publish_down >= '". $now ."' )";