Total number of views for all posts per member

[Logtenberg]

I want to give members the satisfaction of seeing how many views all their posts have received.

i.e.
Total views of all your posts: 34500

Anyone one know if this hack has been done?

[Admin]

So, to sum all the views of the threads started by the person viewing the page? Not hard at all.
Tell me if this is what you want.

[Logtenberg]

I was going to put this information in their control panel, for each members own private reference.

[Logtenberg]

I have just realized that this is a more important requirement for my message boards then I thought.

If no one knows how to do it, can anyone point me to a hack that is similar?

I must say, that this would be a great hack. - It could double for a points program. - The person must be the thread starter however to count the impressions towards their total...

thanks.

[christec]

Something like this:

PHP Code:

$DB_site->query("SELECT count(views) FROM thread WHERE postusername=$bbuserinfo[username]"); 


[Admin]

$yourviews=$DB_site->query_first("SELECT SUM(views) AS totalviews FROM thread WHERE postuserid='$bbuserinfo[userid]'");

is more like it.

[christec]

OK, how about a short, quick explanation of "query_first".

[Admin]

$DB_site->query() is just like mysql_query().

$DB_site->query_first() is the same as the above, only it returns the first row in the result.

For example if you want to find out someone's username, you can do this:

$userinfo=$DB_site->query_first("SELECT username FROM user WHERE userid='$userid'");

And then you can just use $userinfo[username].

But if you do it this way (the wrong way):

$userinfo=$DB_site->query("SELECT username FROM user WHERE userid='$userid'");

(i.e using query instead of query_first)
You must do $DB_site->fetch_array(), because the result in this case it a 2D array.

Am I making sense here?

[Lesane]

Thanks Firefly, learned something 2day

Why not making a new forum where the php guys can add their little tutorials like this one above?

[christec]

Originally posted by FireFly
Am I making sense here?

Crystal clear!
One more question, which file is this object defined in?

Thank You