limiting postcount (spam)

[HakkieDEV]

Quite a few threads on my forum are being spammed as hell, mostly because people will get a higher postcount.

What I would like to do is allowing 1 reply per thread to be counted, all further replys are not counted in the postcount.

I created new counter, wich is a copy of the default postcount. This new counter will be shown instead of the default postcounter of vbulletin.

The code below is trying to find out if the user has replyed before, if not, add 1 postcount.
If the users has replyed before, simply do nothing (since he already got his 1 postcount)


Currently I have in newpost_complete:

PHP Code:

if ($type == 'reply') 
{ 
    if ($vbulletin->db->query_first( "SELECT postid FROM " . TABLE_PREFIX . "post WHERE userid='".$vbulletin->userinfo[userid]."'  AND threadid=$threadinfo[threadid]") != '')
    {
    }
    else
    {
        $vbulletin->db->query_write("UPDATE user SET newpostcounter=newpostcounter+1 WHERE userid=" . $vbulletin->userinfo['userid'] . "");
    }
} 


However, this doesn't work and I can't figure out why.

Anyone who could help me with this?

[harmor19]

Maybe this will help

PHP Code:

$getsomestuff = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "post WHERE userid='".$vbulletin->userinfo[userid]."'  AND threadid=$threadinfo[threadid]"); 

$posted = $db->num_rows($getsomestuff);
 if ($posted > 0) 
{
     
}
else
{
       $vbulletin->db->query_write("UPDATE user SET newpostcounter=newpostcounter+1 WHERE userid=" . $vbulletin->userinfo['userid'] . ""); 
} 


[HakkieDEV]

Doesn't work, it gives a redirection message like this:

-----------------
Redirecting...


This post is a duplicate of a post that you have posted in the last five minutes. You will be redirected to that thread.

Click here if your browser does not automatically redirect you.
------------------

Also, it doesn't update the newpostcount.