sorry this is the right bit of code
PHP Code:
// ###################### Start Get Listings #######################
if ($action=="getlist") {
eval("\$navbar .= \"".gettemplate("trader_navbar")."\";");
$getinfo2 = $DB_site->query_first("SELECT * FROM traderclasssublist WHERE subid=$subid");
$catmain=$getinfo2[parentname];
$catmainid=$getinfo2[parentid];
$catsub=$getinfo2[subname];
$getinfo3 = $DB_site->query_first("SELECT * FROM traderclassmainlist WHERE id=$catmainid");
$getlist = $DB_site->query("SELECT * FROM traderlisting WHERE itemsubcatid=$subid and active=1 ORDER BY datelisted DESC");
while ($list4 = mysql_fetch_array($getlist)) {
$list4[finish]=vbdate($dateformat,$list4[dateexpire]);
$newlist="";
if ($list4[datelisted] > $bbuserinfo[lastvisit]) {
$newlist="color=red";
}
if (($counter++ % 2) != 0) {
$backcolor="{firstaltcolor}";
$bgclass="alt1";
} else {
$backcolor = "{secondaltcolor}";
$bgclass="alt2";
}
eval("\$itemlist .= \"".gettemplate("trader_itemlist_bit")."\";");
}
eval("dooutput(\"".gettemplate("trader_item_list")."\");");
}