[wottech]

Originally Posted by Ken Iovino

If you wanted to do this is 3.5 using hooks you can. Open showthread.php and find around line: 923-924. You should see...

PHP Code:

$hook_query_fields = $hook_query_joins = '';
($hook = vBulletinHook::fetch_hook('showthread_query')) ? eval($hook) : false; 


Under that you will see a very large query, in that query you will notice the variables, $hook_query_fields, and $hook_query_joins. Thats your ticket into this query.

You would simple go into the plugins, add new plugin and write it like so: Plugin Name is "showthread_query"

PHP Code:

$hook_query_fields = ",tablename.rowname AS newname";
$hook_query_joins = "LEFT JOIN " . TABLE_PREFIX . "tablename AS newtable ON(tablename.rowname = post.rowname)"; 


Is there a way to add WHERE and ORDER statements to this query as well, using hooks?