FUDforum: How To » Can we count views as well as posts?

Home » FUDforum » How To » Can we count views as well as posts?

Show: Today's Messages :: Polls :: Message Navigator

Re: Can we count views as well as posts? [message #17939 is a reply to message #17938]

Mon, 26 April 2004 18:01

Ilia

Messages: 13241
Registered: January 2002

Karma:

Senior Member
Administrator
Core Developer

All of FUDforum's tables have prefix, if you didn't change it during installation it is probably "fud26_". When I am referring to the "thread" table, I would actually be referring to the table called fud26_thread.

Instead of looping through each thread, you'd execute a single query that would get your either the total number of views for all threads or threads inside 1 forum.

ex. SELECT SUM(views) FROM fud26_thread WHERE forum_id=1;
SELECT forum_id,SUM(views) FROM fud26_thread GROUP BY forum_id;

Beyond that your description is fairly accurate.

FUDforum Core Developer

Report message to a moderator

[Message index]

		Can we count views as well as posts? By: WilliamBurns on Fri, 23 April 2004 23:52
		Re: Can we count views as well as posts? By: Ilia on Sat, 24 April 2004 20:54
		Re: Can we count views as well as posts? By: WilliamBurns on Sun, 25 April 2004 19:34
		Re: Can we count views as well as posts? By: Ilia on Sun, 25 April 2004 19:38
		Re: Can we count views as well as posts? By: WilliamBurns on Mon, 26 April 2004 17:37
		Re: Can we count views as well as posts? By: Ilia on Mon, 26 April 2004 18:01

Previous Topic:	Installer Logic
Next Topic:	How to Change User Profiles Globally

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 03:59:40 GMT 2024

Total time taken to generate the page: 0.03803 seconds