Help with call to database in postbit hook

[Parker Clack]

I am trying to get a total of posts from the post table so that I can include that in my postbit template.

I have tried using the following in the postbit_start hook.

$postcount=$db->query_first("SELECT COUNT(*) AS posts FROM post WHERE postid AND post.visible=1");
$totalposts=$postcount[posts];

Which gets me an undefined call error in the postbit.php file.

Any ideas how to make this work?

Thanks,
Parker

[TigerWare]

Originally Posted by Parker Clack

$postcount=$db->query_first("SELECT COUNT(*) AS posts FROM post WHERE postid AND post.visible=1");
$totalposts=$postcount[posts];

Which gets me an undefined call error in the postbit.php file.

Any ideas how to make this work?

Your query returns a number not an array.

[Opserty]

Your query returns a number not an array.

No it doesn't...at least last time I tried something similar it didn't

Are you sure you want to run that query on every postbit?

Best would be to run the query say at the start of the page (e.g. showthread_start) and then use the variable in the postbit. (Note: You may need to use the $_GLOBALS['postcount']['posts'] variable to access the data)

[Dean C]

$thread[replycount] or $threadinfo[replycount]

One of those works, I can't remember which offhand. You don't need to run any queries.

[Opserty]

Hang on...what postcount are you trying to get? The total forum postcount or the postcount for the thread?

Your SQL doesn't make much sense.
[sql]SELECT COUNT(*) AS posts FROM post WHERE postid AND post.visible=1[/sql]


If its the number of replies to the thread then the above post is correct.

[TigerWare]

Originally Posted by Opserty

No it doesn't

That's a joke right?

--------------- Added [DATE]1196622101[/DATE] at [TIME]1196622101[/TIME] ---------------

Originally Posted by TigerWare

That's a joke right?

Nope, guess not, I just checked the madness from the API. Excuse me whilst I go and eat my monitor.

[Parker Clack]

It is to get the number of replies in a thread. Let say you have a thread with 10 total posts. I want to post the $totalpost count in that thread so it will say Post 1 of 10 or 5 of 10, etc.

Thanks,
Parker

[Dean C]

$thread[replycount] then No queries necessary

[Parker Clack]

Dean:

Thanks. To make the count correct though I created a hook in postbit_display_start and
used $postcount=$thread[replycount]+1;
Otherwise if there are 15 posts the 15th post shows up as Post 14 of 15.

Thanks again.

[Dean C]

Better than running a query for every post though