[SURVEY]Would You prefer a hack with or without files modifications ?

[Andreas]

Hooks showthread_query_postids and showthread_query

[grog6]

But how can I modify this query with the hook ?

If I add a query to this hook, it's the same thing that if I added it to the file ?
How could I modify the query in the file ? I don't understand ...

[amykhar]

It allows you to add extra columns to the query without adding a new query.

[grog6]

An example amy ?

You're interesting me !

[Andreas]

You can use the variables $hook_query_fields to add new fields, $hook_query_joins to add joins and $hook_query_where to add conditions.

Example

PHP Code:

$hook_query_fields .= ", mytable.foobar1, mytable.foobar2";
$hook_query_joins .= " JOIN " . TABLE_PREFIX . "mytable ON (mytable.userid=user.userid)"; 


[grog6]

Thanks Andreas

Can this (by replacing variable's name) be done in every hook ?

How could I have known it if you had not said it to me ? Isn't there a guide "the perferct vbulletin hacker's guide ?"

[Andreas]

No, only in special query Hooks.

Well, you could just take a look at the source files - they are fully documented and the query Hooks as well as the variables are clearly visible there

[grog6]

OK, thank you

Other replies for the survey now, else my thread will be moved to an other forum ...