Snitz Forums 2000 - Questions about "basic statistics mod" and more

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 MOD-Group

MOD Add-On Forum (W/O Code)

Questions about "basic statistics mod" and more

New Topic

Topic Locked

Printer Friendly

Author

Topic

skogizz
Starting Member

Sweden
25 Posts

Posted - 03 January 2005 : 13:04:36

I have downloaded the basic_statistics_mod from snitzbitz and now I wonder how to modify the script little so it could count archived posts?

I don't mind to have 2 diffrent pages, one that counts "normal" posts (like the mod does now) and another page for the same mode that does count the archived posts...

Would be very happy if someone could point me in the right direction.

I also wonder if someone could give me some hints how the code should look if I want a page that just tells me the sum of posts in a certain forum (and not just the total of all forums like the scrips out there now does)

Any help would be VERY nice!

/Fredrik

skogizz
Starting Member

Sweden
25 Posts

Posted - 04 January 2005 : 04:50:26

I have tried to edit the SQL-syntax and include the forum_id for the forum room I just want to be counted but it just gives me error.

I guess there can't be two "WHERE" argument in a statement...?

strSql = "SELECT COUNT(REPLY_ID) AS PostCount FROM " & strTablePrefix & "TOPICS INNER JOIN " & strTablePrefix & "REPLY ON " & strTablePrefix & "TOPICS.TOPIC_ID = " & strTablePrefix & "REPLY.TOPIC_ID WHERE T_DATE LIKE '" & intYear & strMonth & "%' OR R_DATE LIKE '" & intYear & strMonth & "%' & WHERE FORUM_ID = 2"

What I'm trying to do is the count only the posts in forum with id 2 (one of 16 forum rooms)

Edited by - skogizz on 04 January 2005 04:51:57

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.23 seconds.