Code for adding multiple Prefixes

[steeler7]

Hi,

This is actually code for vBadvanced to filter news items by Prefix. It works fine except that I want to add more than 1 prefix... I figured the code itself might be basic enough where someone with knowledge could help out

$getnewsids = $db->query_read("
SELECT $ratingsql threadid, firstpostid
FROM " . TABLE_PREFIX . "thread AS thread
WHERE visible = 1
AND thread.prefixid = 'X'
AND open != 10
AND (thread.forumid IN(" . implode(',', $mods['inforums']) . ")
" . iif(!empty($newstids), ' OR threadid IN(' . implode(',', $newstids) . ')') . "
)
" . iif($mod_options['portal_news_cutoffdate'], 'AND thread.dateline > ' . (TIMENOW - ($mod_options['portal_news_cutoffdate'] * 86400))) . "
ORDER BY " . iif($mod_options['portal_news_sticky'], 'sticky DESC,') . iif($mod_options['portal_news_orderby'] == 'postdateline', 'dateline', $mod_options['portal_news_orderby']) . " $mod_options[portal_news_direction]
$newslimit
");


whats in red is my prefix id. I tried duplicating another prefix next to it with and without a comma and no luck

[kh99]

I think you want to change it like this:

AND thread.prefixid IN ('X', 'Y', 'Z')

[steeler7]

Thanks for your response!

I give it a try and I got the following Database Error message..

Database error in vBulletin 4.1.7:

Invalid SQL:

SELECT threadid, firstpostid
FROM thread AS thread
WHERE visible = 1
AND thread.prefixid IN = ('Articles','News')
AND open != 10
AND (thread.forumid IN(53,7,42,15,22,47,29,30,31,41,35)

)

ORDER BY dateline DESC
LIMIT 5;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= ('Articles','News')

--------------- Added 1325607249 at 1325607249 ---------------

Nevermind, I forgot to get rid of "=". it works perfectly now.

THANK YOU !!! this was a big help and need on my end!