How to Count number of replies from a thread id?

[Mattwhf]

First off, thanks Lynne for this tutorial How to Create your own vBulletin 4 page because I could create my own best web hosting page on our hosting forum, but now I am wanting to enhance it by adding some new functions, for example, show number of reviews from a thread id on my forum to that page.

In my page, I have User comments ? I want to show number of replies from a thread which a web hosting company is having review on their own thread. i.e 6 User comments ?

Is it possible to count number of replies from a thread id?

I mean (on Lynne's tutorial page ) then the code to count that will be putted on test.php and I can push it into a variable to display on my vB template.

Any ideas?

Thanks in advance.

[In Omnibus]

First of all, that is not a vBulletin4 page. Even clicking on the Forums tab doesn't go to a vBulletin forum. It goes to an ad page, one I'd thank you to stop spamming here.

Secondly, unless users are replying multiple times in the thread, the number of replies is the number of user comments. That is displayed by default unless you've removed it.

[Mattwhf]

Originally Posted by In Omnibus

First of all, that is not a vBulletin4 page.

Why it is not a vBulletin 4 page?

As said, I created it from Lynne's guide.

Originally Posted by In Omnibus

Even clicking on the Forums tab doesn't go to a vBulletin forum.

I don't understand your meaning, can you share a screenshot to explain?

Originally Posted by In Omnibus

It goes to an ad page, one I'd thank you to stop spamming here.

It is not allowed to show a page like that on this forum?
I only want to explain what I wanted to add to my page, you can visit it but you can not need to click on any links on the page, just have a look.

Originally Posted by In Omnibus

Secondly, unless users are replying multiple times in the thread, the number of replies is the number of user comments. That is displayed by default unless you've removed it.

I still don't understand your answer and you seem didn't understand my question.
I mean I want to create a function to query number of replies in a thread (reviews) and showing it on each link on vB page. Just that.

Seem I could find a solution for this by this thread https://vborg.vbsupport.ru/showthread.php?t=41235

but still needing better solutions if possible.

Thanks

[MarkFL]

Suppose you have the threadid stored in the variable $threadid...then you can get an array containing information on the specified thread, using something like:

PHP Code:

$threadinfo = fetch_threadinfo($threadid); 


And then to get the number of replies for that thread, you could use:

PHP Code:

$replies = $threadinfo['replycount']; 


[Mattwhf]

Originally Posted by MarkFL

Suppose you have the threadid stored in the variable $threadid...then you can get an array containing information on the specified thread, using something like:

PHP Code:

$threadinfo = fetch_threadinfo($threadid); 


And then to get the number of replies for that thread, you could use:

PHP Code:

$replies = $threadinfo['replycount']; 


No, I think this will not show number of replies on my page because it is not a thread.

I am needing a query to show number of replies from 10 threads (for 10 hosting companies that I am listing on my page)

for example:

$id4895 = count_replies(4895);
$id7894 = count_replies(7894);
$id674 = count_replies(674);
$id4563 = count_replies(4563);
...

count_replies function will is a function that contained queries depends on thread id.
and on test.php I will assign these

$templater->register('id4895 ', $id4895 );
$templater->register('id7894 ', $id7894 );
$templater->register('id674 ', $id674);
....

After that I can show

{vb:raw id4895}

{vb:raw id4895}

{vb:raw id674}

on my template and they will show number of replies for each thread id.

The problem that I am caring is queries to get number of replies on each thread can make my forum or that page loads slowly or not.

Thanks

[MarkFL]

Originally Posted by Mattwhf

No, I think this will not show number of replies on my page because it is not a thread...

When the title of the thread refers to a thread id, then I assume you are talking about a thread.

[Mattwhf]

Originally Posted by MarkFL

When the title of the thread refers to a thread id, then I assume you are talking about a thread.

Yes but some people can ignore this or didn't read it carefully

Originally Posted by Mattwhf

First off, thanks Lynne for this tutorial How to Create your own vBulletin 4 page because I could create my own best web hosting page on our hosting forum, but now I am wanting to enhance it by adding some new functions, for example, show number of reviews from a thread id on my forum to that page.

Mean I need to show number of replies from a thread id on my forum but on my page that I created.

Of course is number of reviews = replies.

[MarkFL]

Originally Posted by Mattwhf

Yes but some people can ignore this or didn't read it carefully



Mean I need to show number of replies from a thread id on my forum but on my page that I created.

Of course is number of reviews = replies.

If you are trying to get the number of replies for a single thread, then using what I initially posted will work fine. However, if you are trying to get the number of replies for an array of threads, then using a custom query would be more efficient.

I would create an array to store the respective replycounts, where the keys are the thread ids and then simply pass this array to the template.

[Mattwhf]

Originally Posted by MarkFL

I would create an array to store the respective replycounts, where the keys are the thread ids and then simply pass this array to the template.

Would you mind sharing details/codes for this way?

I can solve this but it can not be a professional way thus that's why I ask this question here.

Thanks

[MarkFL]

Originally Posted by Mattwhf

Would you mind sharing details/codes for this way?

I can solve this but it can not be a professional way thus that's why I ask this question here.

Thanks

Okay, I would do something like this:

PHP Code:

$replycounts = array();

// Edit the following line to contain all threadids you wish to include.
$threadids = '674,4563,4895,7894';

$threads= $vbulletin->db->query_read("SELECT thread.*
    FROM " . TABLE_PREFIX . "thread AS thread
    WHERE threadid IN (" . $threadids . ")
");

while ($thread = $db->fetch_array($threads))
{
    $replycounts[$thread['threadid']] = $thread['replycount'];
} 


Now you can pass the $replycounts array to your template, and then display them from your template with:

{vb:raw replycounts.674}
{vb:raw replycounts.4563}
{vb:raw replycounts.4895}
{vb:raw replycounts.7894}

etc.

Does this make sense?