Counting users posts in particular forum?

[Simon Lloyd]

Oki'll explain everyting i have done:
opened AdminMyPhp then my db, selected vb_user and added ctoptip to it with the settings you gave, i then created a plugin as follows with newthread_post_complete as the hook

PHP Code:

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


i then created a template called postbit_ctoptip

PHP Code:

<if condition="$post['ctoptip']>= '1'">$post[ctoptip] Top Tips<br /></if> 


i then created another plugin with postbit_display_start as the hook

PHP Code:

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


i then used this in my postbit

PHP Code:

My Top Tip Count: $post[ctoptip] 


making a post via a form to the forum (id 52) does not produce an error nor does it increase the counter, making a post direct gave a db error as shown below

Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE user SET ctoptip = ctoptip + 1 WHERE userid=1;

MySQL Error : Table 'thexxxx_CCxxxx.user' doesn't exist
Error Number : 1146
Request Date : Sunday, February 1st 2009 @ 07:11:35 PM
Error Date : Sunday, February 1st 2009 @ 07:11:35 PM
Script : http://www.thecodecage.com/forumz/ne...ostthread&f=52
Referrer : http://www.thecodecage.com/forumz/ne...newthread&f=52
IP Address : xx.xxx.xxx.xx
Username : Simon Lloyd
Classname : vB_Database
MySQL Version : 5.0.67-community

The manual post posted ok, So i'm not sure what to do now?

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

could it be because userid 1 is an uneditable user?, it still doesn't explain no increments for the posts by form to the top tips forum (id 52).

[Lynne]

Ah, I don't use table prefixes, thus my query did not contain the table prefix. You need to change user to vb_user for your site.

Do you have the hook newthread_post_complete in your form? If not, you either need to add it (find it in the vb code and paste it when something similar is happening in your form code) or you need to add the code you put in the plugin directly into your form code.

[Simon Lloyd]

Originally Posted by Lynne

Ah, I don't use table prefixes, thus my query did not contain the table prefix. You need to change user to vb_user for your site.

Do you have the hook newthread_post_complete in your form? If not, you either need to add it (find it in the vb code and paste it when something similar is happening in your form code) or you need to add the code you put in the plugin directly into your form code.

Thanks once again!, you said

or you need to add the code you put in the plugin directly into your form code

which one of the plugins that i created?

[Lynne]

The one with the update query that uses the newthread_post_complete hook location. That is the one that isn't getting run because you don't have the hook location in your form.

[Simon Lloyd]

As for user i don't have user so cannot change is it for vb_user.....think i'm in over my head with this!

[Lynne]

I'm talking about in the query:

PHP Code:

UPDATE user SET ctoptip = ctoptip + 1 


To:

PHP Code:

UPDATE vb_user SET ctoptip = ctoptip + 1 


[Simon Lloyd]

Originally Posted by Lynne

I'm talking about in the query:

PHP Code:

UPDATE user SET ctoptip = ctoptip + 1 


To:

PHP Code:

UPDATE vb_user SET ctoptip = ctoptip + 1 


Ah!, thanks, see told you i'm no coder!, i'm going to get in touch with Bananalive (hopefully) to see about adding the hook to his form code.

Thanks for all your help!

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

BTW, changing the prefix worked for direct posts, it counts them and displays in the postbit, but the form delivery does not until i can get some help with where and how to deliver the hook location in the form code.

[Lynne]

You just need to add the hook location into your form. I've got it in my form (I didn't use a modification from here - I wrote my own). Just look at where it is in the current vb code and see if you have some similar code in your form and just add it in the same place.

[Simon Lloyd]

Originally Posted by Lynne

You just need to add the hook location into your form. I've got it in my form (I didn't use a modification from here - I wrote my own). Just look at where it is in the current vb code and see if you have some similar code in your form and just add it in the same place.

Lynne, thanks, the mod from Bananlive already has a couple of boxes when you create your form to add your plugin or hook code to it, so your code put in the box for befroe_submit worked like a charm, although i have found now that i will need to have some code that deletes from the count as i have had my first occurrence of that, editing the database regularly will be a definate no no!

[Lynne]

I run the queries I posted to get the initial count every night as a cron job (scheduled task) since I haven't written a plugin for deleted threads either.