splitting new posts and replies in the users count

[shri]

Hi,

I have a situation where members mass post stuff which many a time is irrelevant ... just so that they can get an elevated user status on the board.

I have implemented a throttle where users with less than 30 posts can only post 1 new topic every 2 hours. They can post unlimited replies.

Do the developers see a problem if I split out the number of newthreads v/s number or replies in the user column, with only the number of newthreads being used to calculate the users status on the board?

Cheers,
Shri

[JamesUS]

It would certainly work. Just make a threadcount and replycount field in the user table and increment them in the same way that the normal post total field is incremented. Just use this query:
$DB_site->query("UPDATE user SET replycount=replycount+1 WHERE userid='$userid'");

[shri]

I ran the following code to split the new posts v/s replies and changed the code in newreply.

----------

<?
if (function_exists("set_time_limit")==1 and get_cfg_var("safe_mode")==0) {
  @set_time_limit(12000);
}

        require("./global.php");

        $users = $DB_site->query("select * from user where posts > 0 order by userid asc");

        while ($user_row = $DB_site->fetch_array($users))
                {
                $user_new_posts = $DB_site->query_first("select count(*) as new_posts from thread where postuserid=$user_row[userid] and forumid <> 61");
                $total_posts = $DB_site->query_first("select count(*) as posts from post where userid=$user_row[userid]");
                $user_replies = $total_posts[posts] - $user_new_posts[new_posts];
                echo "User: " . $user_row[username] ." - " . $user_row[userid] . " New: " . $user_new_posts[new_posts] . "Replies: " . $user_replies . "<br>";
        $DB_site->query("update user set posts=$user_new_posts[new_posts],replies=$user_replies where userid=$user_row[userid]");
                }
?>