ok fixed

replaced:
PHP Code:
while ($latestthread = $DB_site->fetch_array($threadsquery)) {
$title = unhtmlspecialchars($latestthread['title']);
$starter = $latestthread['postusername'];
$numreplies = $latestthread['replycount'];
$lastposter = $latestthread['lastposter'];
$mpostid= $latestpost['postid'];
$postdate=vbdate($dateformat,$latestpost[dateline]);
$posttime=vbdate($timeformat,$latestpost[dateline]);
$postforum=$latestthread['title'];
$postforumid=$latestthread['forumid'];
$gothreadid = $latestthread['threadid'];
if (($counter++ % 2) != 0) {
$threadbg="#F1F1F1";
} else {
$threadbg="#DFDFDF";
}
eval("\$threadbits .= \"".gettemplate('home_threadbit')."\";");
}
eval("\$threads = \"".gettemplate('home_threads')."\";");
}
with this
PHP Code:
while ($latestthread = $DB_site->fetch_array($threadsquery)) {
$result1 = $DB_site->query("SELECT postid,dateline,pagetext FROM post WHERE threadid='$latestthread[threadid]' order by dateline desc limit 1");
$latestpost = $DB_site->fetch_array($result1);
$result2 = $DB_site->query("SELECT title FROM forum WHERE forumid='$latestthread[forumid]' limit 1");
$latestforum = $DB_site->fetch_array($result2);
$title = $latestthread['title'];
$starter = $latestthread['postusername'];
$numreplies = $latestthread['replycount'];
$lastposter = $latestthread['lastposter'];
$mpostid= $latestpost['postid'];
$postdate=vbdate($dateformat,$latestpost[dateline]);
$posttime=vbdate($timeformat,$latestpost[dateline]);
$postforum=$latestforum['title'];
$postforumid=$latestthread['forumid'];
if ($latestthread['iconid']==0) { $icon=""; } else { $icon="<img src=\"https://vborg.vbsupport.ru/vbimages/icons/icon$latestthread[iconid].gif\" border=0>"; }
$gothreadid = $latestthread['threadid'];
if (($counter++ % 2) != 0) {
$threadbg="#F1F1F1";
} else {
$threadbg="#DFDFDF";
}
eval("\$threadbits .= \"".gettemplate('home_threadbit')."\";");
}
}
eval("\$threads = \"".gettemplate('home_threads')."\";");
I added this code from the old vBindex now its working.
but I have still the news problem.