Social Groups - Post Count

[Brandy-Dw]

I'm currently using vbulletin version 4.1.0

And i'm curious how to make it so that social group posts add to a members post count and how social group posts add to the forum post count.

Would be very helpful if someone could help me with this...

thank you

--------------- Added [DATE]1298222000[/DATE] at [TIME]1298222000[/TIME] ---------------

anyone?... please..

[induslady]

Hello,

As am too interested in this feature? Any ideas?

[Badshah93]

To count social group posts in user total posts

Create New Plugin

HooK: group_message_post_complete

Title: ur wish

Code

$db->query_write("UPDATE ".TABLE_PREFIX."user set posts = posts+1 
where userid = ".$vbulletin->userinfo['userid']."");

and don't forgot to make plugin active.

[induslady]

Hello Sherif,

Thanks for sharing the plugin code.

After activating this plugin do I need to run "Maintenance>Update Counters > Update Post Counts"?

[Badshah93]

Originally Posted by induslady

Hello Sherif,

Thanks for sharing the plugin code.

After activating this plugin do I need to run "Maintenance>Update Counters > Update Post Counts"?

no it will count the social group post as main post from now onwards..

[induslady]

Hello,

Can you tell me SQL query that I could run it one time so that the user's post count includes the social group messages prior to this plugin?

[Mooff]

Wouldn't 'Update Post Counts' remove all +1 numbers the plugin added?

[Lynne]

Originally Posted by Mooff

Wouldn't 'Update Post Counts' remove all +1 numbers the plugin added?

Yep.

If you wanted to really do this right, you would create a new field in the user table to keep track of the number of group posts. Then just add them together for the template. That will be a bit more involved though and won't just be a couple of little plugins.

[induslady]

Hi Lynne, I tried this plugin :


Hook Location : postbit_display_start

code:

PHP Code:

$usersid = $this->post['userid'];
$fpost = $this->post['posts'];
$gmessage = mysql_query("SELECT gmid FROM " . TABLE_PREFIX . "groupmessage WHERE postuserid='$usersid' AND state='visible'");
    $gpost = mysql_num_rows($gmessage);
        $totalpost = $fpost + $gpost; 


Here post.posts is the total post count of user from forum postings and the query gets the post count from social group message an both are added.
Used this variable totalpost in the postbit template but not getting the desired result.

Can you let me know how to fix this.

[Lynne]

What exactly seems to be the problem?

You do realize that that will create one additional query per post per page, correct?