Counting users posts in particular forum?

[Simon Lloyd]

Hi all, i have an add on by Bananalive (easy forms), this add on posts the contents of a form to a particular forum, the post shows it was posted by the user but it doesnt add to the post count, however, is it possible to count the posts in that forum per user and show the count in the users info in postbit?

So for arguments sake, you would have Username then under that age....etc then Top Tip Count xx (Top Tips is the forum that users will have submitted the form), i'm no coder but quite capable of doing as instructed, i have made some template changes myself with no problem but nothing very special.

Any ideas?

[Lynne]

I did that on my site. I added a couple of columns to the user table for the counts to go in and then created a plugin (newthread_post_complete) so if they posted in xx forum, it increased this new column number. I never really finished it to delete threads if the thread is deleted, so I made a quick php script to run as a cron when I feel like it to do a recount.

[Simon Lloyd]

Originally Posted by Lynne

I did that on my site. I added a couple of columns to the user table for the counts to go in and then created a plugin (newthread_post_complete) so if they posted in xx forum, it increased this new column number. I never really finished it to delete threads if the thread is deleted, so I made a quick php script to run as a cron when I feel like it to do a recount.

Lynne, thanks for the response, i know i have a couple of hundred posts but they were either asking questions or answering something i actually knew about!

Could you possibly give me a blow by blow on how to?, i am very capable of doing as instructed but need some help on how.

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

EDIT: The posts won't be deleted (or at least they shouldn't) the forum is purely to recieve the form, members only have viewing rights to the forum nothing else.

[Lynne]

Um, yikes! I posted the wrong response in this thread. That was meant to go into another thread. Sometimes I just CANNOT multitask!!!

OK, let's see.... I keep count for two different reasons, one in forum a&b, another in forum c&d. I added two columns to the user table - ttdtrader_s and ttdtrader_v - int(10), unsigned, not null, default 0. Then created a plugin at newthread_post_complete with the following code:

PHP Code:

if (in_array($foruminfo['forumid'], array(a,b))) { 
    $db->query_write("UPDATE user SET ttdtrader_s = ttdtrader_s + 1 WHERE userid=" . $vbulletin->userinfo['userid']); 
} 
if (in_array($foruminfo['forumid'], array(c,d))) { 
    $db->query_write("UPDATE user SET ttdtrader_v = ttdtrader_v + 1 WHERE userid=" . $vbulletin->userinfo['userid']); 
} 


To initially do the count, I ran a couple of queries - I actually wrote them into a Scheduled Task so I can run it easily:

PHP Code:

$vbulletin->db->query("
    UPDATE " . TABLE_PREFIX . "user
    SET user.ttdtrader_s = (SELECT count(*) FROM " . TABLE_PREFIX . "thread WHERE thread.postuserid = user.userid AND forumid IN ('a','b') AND sticky=0)"
);
$vbulletin->db->query("
    UPDATE " . TABLE_PREFIX . "user
    SET user.ttdtrader_v = (SELECT count(*) FROM " . TABLE_PREFIX . "thread WHERE thread.postuserid = user.userid AND forumid IN ('c','d') AND sticky=0)"
); 


[Simon Lloyd]

Lynne, thanks for sticking with this!, i created a table using:

PHP Code:

CREATE TABLE ctoptip (count INT(10) UNSIGNED NOT NULL);
INSERT INTO ctoptip SET count = 0; 


and created aplugin as instructed with

PHP Code:

if (in_array($foruminfo['forumid'], array(52))) { 
    $db->query_write("UPDATE user SET ctoptip = ctoptip + 1 WHERE userid=" . $vbulletin->userinfo['userid']); 
} 


where can i put the rest so that it updates in the postbit for the user everytime the create the post via the form?

[Lynne]

I did NOT create a new table, I just added two new columns to the user table so the variables would be available to me whenever the userinfo was grabbed. You can do it your way, but you will have to make sure to modify the queries where needed to get the variables you want (like in the postbit you are talking about).

[Simon Lloyd]

Ok, i deleted that new table and added to the vb_user table (when setting up vbulletin i chose vb as the prefix for the database) could you tell me where i need to put the next section of code in order for it to show in the Postbit and always update when they fill that form in? ( i know its only half of the next section of code as i am only working with one forum id52)

[Lynne]

Say your new column is called "simon1", it will be available as $post[simon1] in the postbit templates. What I did is create a new template (I had a few lines for mine), say postbit_simon with the new values in there:

<if condition="$post['simon1']>= '1'">$post[simon1] Threads in Simon's forum<br /></if>

Then I created a plugin using postbit_display_start to insert that line using a template hook:

PHP Code:

eval('$template_hook[postbit_userinfo_right] .= " ' . fetch_template('postbit_simon1') . '";'); 


If you only have the one line in the template, you can probably just do it directly in that plugin:

PHP Code:

if ($post[simon1] >= '1') {
eval('$template_hook[postbit_userinfo_right] .= "$post[simon1] Threads in Simon\'s forum<br />";');
} 


(NOT tested, but it's something like that. html must be escaped properly if using that method.)

If you use that method, don't forget to also cache the template. (Well, you don't have to, but it's good practice.)

[Simon Lloyd]

Lynne, thanks again for the help, i can't get it to work, i added a column called ctoptip i created a template like you said (called postbit_ctoptip) and the new plugin but it shows nothing?

Its getting frustrating now, like i said i'm no coder!

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

I made a post directly in the forum and got a db error user doesn't exist

[Lynne]

user doesn't exist? But there is nothing in there to do with the user. What was the exact error? And what is the exact code/template code your are using?