Total number of views for all posts per member

[Admin]

Like all $DB_site, db_mysql.php.

[christec]

Duh! I should have known, my brain is enjoying the holiday.
Thanks again

[Logtenberg]

Originally posted by FireFly

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

is more like it.

Hey Firefly,

Where exactly does this code go? I put it in one of the cp templates and that didn't work.

Thanks!

[Admin]

In index.php, add this:

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

right before this:

// get newest member

Now use $yourviews in your forumhome template to show the number.

[squawell]

FireFly~~

can it show up in postbit~~

i want to do that u know how to do that??

[Admin]

Yeah I do, but it takes too much resource.

[squawell]

i know~~but i still want to know~

can u tell me how to do that??plz~~

[Admin]

In functions.php, find this:

		eval("\$post[profile] = \"".gettemplate("postbit_profile")."\";");

after that, add this:

$countviews=$DB_site->query_first("SELECT SUM(views) AS views FROM thread WHERE postuserid='$post[userid]'");
$post[hisviews]=number_format($countviews['views']);

Now you can use $post[hisviews] in your postbit template.

This hack is bad for your server! I don't advice using it!

[squawell]

thankz FireFly ur advice~~~

u let me know more about vbb hack's code~~

and i just want to know if i want to do what should i do??

that's all~~

[Logtenberg]

Thanks for your advice on this matter firefly.

I would like to insert the total views into the control panel for the member as well as in the "forumhome_pmloggedin" template.

It doesn't seem to work when I insert this code into that template. Can you tell me what I need to do to get this to work?

thanks.