function getAllPublished($limit=0, $start=0, $topic=0, $ihome=0, $asobject=true)
{
$db =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$ret = array();
$sql = "SELECT * FROM ".$db->prefix("stories")." WHERE published > 0 AND published <= ".time()." AND (expired = 0 OR expired > ".time().")";
if ( !empty($topic) ) {
$sql .= " AND topicid=".intval($topic)." AND (ihome=1 OR ihome=0)";
} else {
if ( $ihome == 0 ) {
$sql .= " AND ihome=0";
}
}
if (!empty($uid) && intval($uid) > 0) {
$sql .= ' AND uid='.$uid;
}
$sql .= " ORDER BY published DESC";
$result = $db->query($sql,intval($limit),intval($start));
while ( $myrow = $db->fetchArray($result) ) {
if ( $asobject ) {
$ret[] = new NewsStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->makeTboxData4Show($myrow['title']);
}
}
return $ret;
}