Where this hook edit should go...

[harmor19]

I am doing something similiar and I received that error as well.

The first thing when I get off work is checking if "global $db, $vbulletin;" work.

[Princeton]

I'm not sure what you are trying to do but why not use a JOIN in showthread.php
$hook_query_fields, $hook_query_joins in 'showthread_query' hook

then add

PHP Code:

$check = false;
if custom_userid and custom_threadid exist
{
$check = true;
} 


in 'showthread_postbit_create' hook

[Logikos]

Well I decided to add this condition around the query:

PHP Code:

if ($thread['firstpostid'] == $post['postid'])
{

} 


That seemed to do the trick. Now I have 13 queries running instead of 23.