* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
-if (!defined('LACONICA')) { exit(1) }
+if (!defined('LACONICA')) { exit(1); }
+
+require_once(INSTALLDIR.'/actions/showstream.php');
class AllAction extends ShowstreamAction {
$notice = DB_DataObject::factory('notice');
# XXX: chokety and bad
-
- $notice->whereAdd('EXISTS (SELECT subscribed from subscription where subscriber = {$profile->id})', 'OR');
- $notice->whereAdd('profile_id = {$profile->id}', 'OR');
+
+ $notice->whereAdd('EXISTS (SELECT subscribed from subscription where subscriber = '.$profile->id.' and subscribed = notice.profile_id)', 'OR');
+ $notice->whereAdd('profile_id = ' . $profile->id, 'OR');
$notice->orderBy('created DESC');
$page = $this->arg('page') || 1;
- $notice->limit((($page-1)*NOTICES_PER_PAGE) + 1, NOTICES_PER_PAGE);
+ $notice->limit((($page-1)*NOTICES_PER_PAGE), NOTICES_PER_PAGE);
$notice->find();
- common_start_element('div', 'notices');
+ common_element_start('div', 'notices');
while ($notice->fetch()) {
$this->show_notice($notice);
}
- common_end_element('div');
+ # XXX: show a link for the next page
+ common_element_end('div');
}
}