The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Code for adding multiple Prefixes
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 Code:
$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 "); |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|