Forum-Subforum Post Count

[Admin]

PHP Code:

$invposts=$DB_site->query_first("SELECT replycount FROM forum WHERE forumid=1");
$invthreads=$DB_site->query_first("SELECT COUNT(*) AS threadcount FROM thread WHERE forumid=1"); 


Now use $invposts[replycount] and $invthreads[threadcount].
The thread count doesn't show up. Grr...

[Admin]

Oh wait, they do show up. I had the wrong forumid set for me.

[webhost]

I am working now, I changed the id the replycount/post show up correctly and the threadcount shows zero, should have a number of 107 according to forum and database. This what I havw in forumhome template.

PHP Code:



<tr>
<td bgcolor="#FFFFFF" colspan="6"><normalfont color="{categoryfontcolor}"><p align="left"> Look under here for all information pretaining to WNG listed here. Includes News Releases, Court Proceedings, Raytheon and other.<br>$invposts[replycount] <br>$invthreads[threadcount]<br><br>

Information Here:<b><a href="http://forums.realwebhost.net/forumdisplay.php?forumid=29">Latest News Items</a></b></p></normalfont></td>
</tr> 


[Admin]

Oh right, you have subforums IN the subforums... hold on.

[Admin]

Sorry, here it is:

PHP Code:

$invposts=$DB_site->query_first("SELECT replycount FROM forum WHERE forumid=29");
$invthreads=$DB_site->query_first("SELECT count(*) AS threadcount FROM thread WHERE forumid=66 OR forumid=23 OR forumid=36 OR forumid=27 OR forumid=25 OR forumid=21 OR forumid=24 OR forumid=87"); 


[webhost]

Thanks that did it I'm sure you probably have something better to do with your time.

Question later on if I wanted to do this again on another forum. Would I just put the same lines again in index.php but change
$invposts and $invthreads to something like $inv1posts and $inv1threads ?

Thanks again
Joey

[Admin]

Yeah, and don't forget the new IDs.

[QUOTE]Originally posted by webhost
Thanks that did it I'm sure you probably have something better to do with your time.

[webhost]

Firefly
Questions

First the thread count works great but for some reason when I update my counters it wipes out 70% of the threads in this forum.

Second where I installed this post and thread count on my forum, Is there away also I could add some code in the forumhome template along with what I have made already to show the last post not in each sub forum but only the last post in that group of sub forums?
Joey

[Admin]

PHP Code:

// dates for subs
$hiddenforum=$DB_site->query_first("SELECT lastpost FROM forum WHERE forumid=1 OR forumid=2 ORDER BY lastpost DESC LIMIT 1");
if ($hiddenforum['lastpost']>0) {
 $hiddenforum['lastpostdate']=vbdate($dateformat,$hiddenforum['lastpost']);
 $hiddenforum['lastposttime']=vbdate($timeformat,$hiddenforum['lastpost']);
} else {
 $hiddenforum['lastpostdate']='Never';
 $hiddenforum['lastposttime']='';
} 


I think that should work. (replace the forumids of course)
Use $hiddenforum[lastpostdate] and $hiddenforum[lastposttime].

[webhost]

Database error in vBulletin: Invalid SQL: SELECT lastpost FROM forum WHERE forumid=87 OR forumid=24 OR forumid=23 OR forumid=36 OR forumid=27 OR forumid=21 forumid=25 ORDER BY lastpost DESC LIMIT 1
mysql error:
mysql error number:
Date: Thursday 06th of September 2001 07:46:28 AM
Script: /
Referer:
This is where I placed in index.php

PHP Code:

$boardviews = $DB_site->query_first(" 
SELECT SUM(views) AS threadviews FROM thread"); 
$totalviews = number_format($boardviews[threadviews]);

$invposts=$DB_site->query_first("SELECT replycount FROM forum WHERE forumid=29");
$invthreads=$DB_site->query_first("SELECT count(*) AS threadcount FROM thread WHERE forumid=66 OR forumid=23 OR forumid=36 OR forumid=27 OR forumid=25 OR forumid=21 OR forumid=24 OR forumid=87");

 // dates for subs
$hiddenforum=$DB_site->query_first("SELECT lastpost FROM forum WHERE forumid=87 OR forumid=24 OR forumid=23 OR forumid=36 OR forumid=27 OR forumid=21 forumid=25 ORDER BY lastpost DESC LIMIT 1");
if ($hiddenforum['lastpost']>0) {
 $hiddenforum['lastpostdate']=vbdate($dateformat,$hiddenforum['lastpost']);
 $hiddenforum['lastposttime']=vbdate($timeformat,$hiddenforum['lastpost']);
} else {
 $hiddenforum['lastpostdate']='Never';
 $hiddenforum['lastposttime']='';
}

// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid'];