double post abusers fix started, need some coding help

feeblebmx

hey everyone...

i'm running a version of phpbb under nuke and i'm having a little problem right now with people who double post a lot, or do many multiple posts. when i fix something people always seem to try to find some other way they can fool around.

anyway i am running a very light version of the forum so i can't just turn on flood control. instead i'm writing a little bit of code to go in before the new post is written into the database to check for a match against the latest post in the database.

here is what i have so far:

global $sql, $dbi;

$sql = sql_query("SELECT post_text FROM nuke_posts_text ORDER BY post_id DESC LIMIT 1", $dbi);

$post_text = sql_fetch_row($sql, $dbi);

if($message == "$post_text") {
error_die("Error - You already posted \"$post_text\" once. Isn\'t once enough?");
}

i am doing something really wrong here so far, it just returns the value of $post_text from the database as 'Array'.

if you can be of any help thanks in advance.

-j.

benkillin

thats because sql_fetch_row returns an array... try using $post_text['rowname']

feeblebmx

hi thanks...

i listened to what you said and thought, 'damn that makes sense, it returns an array because that's what that function is supposed to do'. i tried looking around for a function that would just return the contents of the table i wanted but coundn't find anything. finally i decided to go with the flow and take the array and do something with that. then i realized that the forum already does this on the 'view topic' page... duh! anyway i took what you said and looked at some code i found in the 'view topic' file to show me how to use your idea and came up with this:

##########################
global $sql, $dbi;
$sql = mysql_query("SELECT post_text FROM nuke_posts_text ORDER BY post_id DESC LIMIT 1", $dbi);
$post_text = mysql_fetch_array($sql);
if($post_text[post_text] == $message) {
error_die("Error - You already posted \"$message\" once. Isn't once enough?");
}
##########################

i had to reverse the order of "$post_text[post_text] == $message" because with $message first it just made message equal $post_text. once i switched them around it stopped doing that.

the code works great, i stuck it as the last thing before it inserts a new post into the database in the 'post a reply' file and in the 'post a new topic' file so people can't double post or post over and over. now i'll see what other trouble the people on my forum can get into.

thanks very much for the help!

benkillin

I am glad I could help you so much!