$dbresult = '';
if ($pagelimit < 100000 || $startelement > 0) {
$dbresult = $db->SelectLimit($query1, $pagelimit, $startelement);
} else {
$dbresult = $db->Execute($query1);
}
// build a list of news id's so we can preload stuff from other tables.
$result_ids = array();
while ($dbresult && !$dbresult->EOF) {
$result_ids[] = $dbresult->fields['news_id'];
$dbresult->MoveNext();
}
if ($dbresult) {
$dbresult->MoveFirst();
}
news_ops::preloadFieldData($result_ids);
while ($dbresult && !$dbresult->EOF) {
$row = $dbresult->fields;
$onerow = new stdClass();
$onerow->author_id = $row['author_id'];
if ($onerow->author_id > 0) {
$onerow->author = $row['username'];
$onerow->authorname = $row['first_name'] . ' ' . $row['last_name'];
} else {
if ($onerow->author_id == 0) {
$onerow->author = $this->Lang('anonymous');
$onerow->authorname = $this->Lang('unknown');
} else {
$feu = $this->GetModuleInstance('FrontEndUsers');
if ($feu) {
$uinfo = $feu->GetUserInfo($onerow->author_id * -1);
