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).