Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™ Bug Reports
Author Message
technocrat
Life Cycles Becoming CPU Cycles


Joined: Jul 07, 2005
Posts: 511

PostPosted: Tue Jan 03, 2006 11:19 am Reply with quote

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

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! / Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message
technocrat
PostPosted: Tue Jan 03, 2006 1:02 pm Reply with quote

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
Former Admin in Good Standing


Joined: Oct 30, 2002
Posts: 1037
Location: RedNeck Land (known as Kentucky)

PostPosted: Sat Feb 11, 2006 1:17 am Reply with quote

Added for 2.4.2pl4

_________________
Bob Marion
Codito Ergo Sum
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Send e-mail Visit poster's website
technocrat
PostPosted: Sat Feb 11, 2006 9:35 am Reply with quote

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.
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™ Bug Reports

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©