Flood DB Entry

registered · Posted: Tue Jan 03, 2006 11:19 am

includes/nukesentinel.php

Has:

Code:

$db->sql_query('INSERT INTO `'.$prefix."_nsnst_flood` (`ip`, `lastpost`) VALUES (`".$nsnst_const['remote_ip']."`, `".time()."`)");

Which causes an error because its trying to look for a field due to the ` in values so it should be:

Code:

$db->sql_query('INSERT INTO `'.$prefix."_nsnst_flood` (`ip`, `lastpost`) VALUES ('".$nsnst_const['remote_ip']."', '".time()."')");

Posted: Tue Jan 03, 2006 1:02 pm

Couple more

Find:

Code:

$checkrow = $db->sql_query('SELECT `lastpost` FROM `'.$prefix."_nsnst_flood` WHERE `ip` = `".$nsnst_const['remote_ip']."`");

Replace with:

Code:

$checkrow = $db->sql_query('SELECT `lastpost` FROM `'.$prefix."_nsnst_flood` WHERE `ip` = '".$nsnst_const['remote_ip']."'");

Find:

Code:

$db->sql_query('UPDATE `'.$prefix."_nsnst_flood` SET `lastpost` = `".time()."` WHERE `ip` = `".$nsnst_const['remote_ip']."`");

Replace with:

Code:

$db->sql_query('UPDATE `'.$prefix."_nsnst_flood` SET `lastpost` = '".time()."' WHERE `ip` = '".$nsnst_const['remote_ip']."'");

registered · Posted: Sat Feb 11, 2006 1:17 am

Added for 2.4.2pl4

Posted: Sat Feb 11, 2006 9:35 am

This is even more messed up beyond just fixing that code. The whole function has code in it that isnt right. You might want to look at everything in there very closely.