<![CDATA[PunBB Forums — Number of posts on frontpage?]]> https://punbb.informer.com/forums/topic/3160/number-of-posts-on-frontpage/ Mon, 02 Feb 2004 06:27:01 +0000 PunBB <![CDATA[Re: Number of posts on frontpage?]]> https://punbb.informer.com/forums/post/9426/#p9426 Maybe he is making a news script or a portal thing?

]]> Mon, 02 Feb 2004 06:27:01 +0000 https://punbb.informer.com/forums/post/9426/#p9426 <![CDATA[Re: Number of posts on frontpage?]]> https://punbb.informer.com/forums/post/8968/#p8968 Might I ask why you want to display the topic ID and the number of posts in that topic on the front page?

]]> Sun, 18 Jan 2004 14:34:53 +0000 https://punbb.informer.com/forums/post/8968/#p8968 <![CDATA[Re: Number of posts on frontpage?]]> https://punbb.informer.com/forums/post/8965/#p8965 Yes, just add the variable into the line like this:

<?php echo('Topic: '.$topic_id.' has '.$num_posts.' posts.'); ?>
]]> Sun, 18 Jan 2004 14:23:50 +0000 https://punbb.informer.com/forums/post/8965/#p8965 <![CDATA[Re: Number of posts on frontpage?]]> https://punbb.informer.com/forums/post/8964/#p8964 That's not completely what I meant.

I want to display the number of posts in the different topics like this:
Topic number 3160 has ... posts
Topic number 3170 has ... posts
and so on...

Is there a way of getting the $topic_id into 

<?php echo('Topic has '.$num_posts.' posts.'); ?>

this line of code, so I only have to run 

<?php $pun_root = './forums/';
require $pun_root.'include/common.php';

$result = $db->query('SELECT num_replies+1 FROM '.$db->prefix.'topics WHERE id='.$topic_id) or error('Unable to fetch topic info', __FILE__, __LINE__, $db->error());
$num_posts = intval($db->result($result, 0));?>

this code once at the top of the page and it will read the different topics?

Thanx in advance!

]]> Sun, 18 Jan 2004 14:16:35 +0000 https://punbb.informer.com/forums/post/8964/#p8964 <![CDATA[Re: Number of posts on frontpage?]]> https://punbb.informer.com/forums/post/8951/#p8951 Yes. Change

$topic_id = 3160;

to

$topic_id = '3160, 1222, 1446';

and

$result = $db->query('SELECT num_replies+1 FROM '.$db->prefix.'topics WHERE id='.$topic_id) or error('Unable to fetch topic info', __FILE__, __LINE__, $db->error());

to

$result = $db->query('SELECT num_replies+1 FROM '.$db->prefix.'topics WHERE id IN('.$topic_id.')') or error('Unable to fetch topic info', __FILE__, __LINE__, $db->error());

Then just edit $topic_id. It's a comma-separeted list of topic IDs.

]]> Sat, 17 Jan 2004 22:42:33 +0000 https://punbb.informer.com/forums/post/8951/#p8951 <![CDATA[Re: Number of posts on frontpage?]]> https://punbb.informer.com/forums/post/8950/#p8950 This works perfectly! smile

Is there any way of getting the number of posts of several different topics on the same page?

Thanx in advance!

]]> Sat, 17 Jan 2004 22:37:23 +0000 https://punbb.informer.com/forums/post/8950/#p8950 <![CDATA[Re: Number of posts on frontpage?]]> https://punbb.informer.com/forums/post/8948/#p8948 Do this. Include the following piece of code at the very top of your page (before <html> and all that).

<?php

$topic_id = 3160;

$pun_root = './forums/';
require $pun_root.'include/common.php';

$result = $db->query('SELECT num_replies+1 FROM '.$db->prefix.'topics WHERE id='.$topic_id) or error('Unable to fetch topic info', __FILE__, __LINE__, $db->error());
$num_posts = intval($db->result($result, 0));

?>

Then, when you want to display the text, just include this code:

<?php echo('Topic has '.$num_posts.' posts.'); ?>
]]> Sat, 17 Jan 2004 22:12:26 +0000 https://punbb.informer.com/forums/post/8948/#p8948 <![CDATA[Re: Number of posts on frontpage?]]> https://punbb.informer.com/forums/post/8945/#p8945 It works, but I get this error:


Warning: Cannot modify header information - headers already sent by (output started at ROOT/index.php:10) in ROOT/forum/include/functions.php on line 82
Topic has # posts.

Any idea on what this could be?

]]> Sat, 17 Jan 2004 19:03:48 +0000 https://punbb.informer.com/forums/post/8945/#p8945 <![CDATA[Re: Number of posts on frontpage?]]> https://punbb.informer.com/forums/post/8943/#p8943 Here's an example of how you could do it:

<?php

$topic_id = 3160;

$pun_root = './forums/';
require $pun_root.'include/common.php';

$result = $db->query('SELECT num_replies+1 FROM '.$db->prefix.'topics WHERE id='.$topic_id) or error('Unable to fetch topic info', __FILE__, __LINE__, $db->error());
$num_posts = intval($db->result($result, 0));

exit('Topic has '.$num_posts.' posts.');

?>

Just replace the value 3160 with the ID for the topic.

]]> Sat, 17 Jan 2004 17:59:26 +0000 https://punbb.informer.com/forums/post/8943/#p8943 <![CDATA[Number of posts on frontpage?]]> https://punbb.informer.com/forums/post/8938/#p8938 Could someone please tell me how I can show the number of posts for a specified topic on my frontpage?
The frontpage is in the root directory and the forum is in a seperate directory '/forum/'...

Example: Lets say this topic has 4 posts total. I want my frontpage to show me automatically how many posts this topic has, like this: (Topic has 4 Posts)

What code do I need to use? I tried using the extern.php file, but I'm not too experienced with php so I don't know exactly how to get this information...

Thanx in advance!
Supercharged.

]]> Sat, 17 Jan 2004 14:38:16 +0000 https://punbb.informer.com/forums/post/8938/#p8938