How do I make an automod system?

[philvia]

so when a message get's marked 5 times it automatically deleted that message or topic automatcially without a mod/admin being around. Can someone write the actuall part to put in the script? If not the just tell me how.

any help is greatly appreciated.

[sijis]

i hope you are keeping track of how many times the topic is being marked. I'm going to assume the mysql database field is called 'views'.

so my sql would look something like this:

$sql = "SELECT * FROM table";
$query = mysql_query($sql);

while($row=mysql_fetch_array($query)){
    if($row['views'] == 5){
        mysql_query("DELETE FROM table WHERE field = " . $row['id'])   

    }
   // otherwise continue....
}

hope that helps.

[philvia]

i'll post back in this topic if it worked.