[Natch]

Originally Posted by SaN-DeeP

weird but i am getting this error:

 Database error in vBulletin 3.0.0: 
Invalid SQL: 
SELECT threadid, title, lastpost, postusername,lastposter,dateline 
FROM vb3_thread 
WHERE forumid IN(3, 4, 44, 5, 45, 6, 14, 52, 11, 10, 46, 13, 30, 33, 43, 34, 32, 31, 37, 38, 40, 42, 39, 41, 15, 16, 17, 18, 19, 7, 36, 21, 24, 35, 20, 22, 47, 48, 53, 49, 50, 51, 25, 26, 27)
AND thread.open <> 10
AND thread.visible = '1'		
ORDER BY lastpost 
DESC LIMIT 10 
 
mysql error: Unknown table 'thread' in where clause
mysql error number: 1109

changing few lines make it work:

 $getbeitraege= $DB_site->query("
  SELECT threadid, title, lastpost, postusername,lastposter,dateline  
  FROM " . TABLE_PREFIX . "thread 
  WHERE forumid IN(" . implode(', ', $forumids) . ")
  AND vb3_thread.open <> 10
  AND vb3_thread.visible = '1'		
  ORDER BY lastpost 
  DESC  LIMIT $limit 
 ");

You would be better off doing

FROM " . TABLE_PREFIX . "thread as thread

which would make the

... thread.open ... thread.visible ...

work regardless of the PREFIX value