Flood DB Entry

technocrat · Involved Joined: Jul 07, 2005 Posts: 492

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()."')");

technocrat · Involved Joined: Jul 07, 2005 Posts: 492

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']."'");

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

Added for 2.4.2pl4

technocrat · Involved Joined: Jul 07, 2005 Posts: 492

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.