NukeSentinal 2.5 Fixes

phoenix-cms · Worker Joined: Aug 05, 2005 Posts: 139

hi guys there should be some fixes in sentinal so i post them here if you want to add this to next release as you may of missed it Bob.

Open: admin/modules/nukesentinel/ABPrintTracked.php

FIND:

Code:

$result = $db->sql_query("SELECT `user_id`, `username`, `ip_addr`, `hostname`, MAX(`date`), COUNT(*), MIN(`tid`), `c2c` FROM `".$prefix."_nsnst_tracked_ips` $modfilter GROUP BY 2,3,4 ORDER BY `ip_addr`");

REPLACE WITH:

Code:

$result = $db->sql_query("SELECT `user_id`, `username`, `ip_addr`, `ip_long`, MAX(`date`), COUNT(*), MIN(`tid`), `c2c` FROM `".$prefix."_nsnst_tracked_ips` $modfilter GROUP BY 2,3,4 ORDER BY `ip_addr`");

FIND:

Code:

while(list($userid,$username,$ipaddr,$hostnm,$lastview,$hits,$tid,$c2c) = $db->sql_fetchrow($result)){

REPLACE WITH:

Code:

while(list($userid,$username,$ipaddr,$ip_long,$lastview,$hits,$tid,$c2c) = $db->sql_fetchrow($result)){

FIND:

Code:

echo "<td align='center'>$hostnm</td>";

REPLACE WITH:

Code:

echo "<td align='center'>$ip_long</td>";

Open: admin/modules/nukesentinel/ABPrintTrackedPages.php

FIND:

Code:

$result = $db->sql_query("SELECT `hostname` FROM `".$prefix."_nsnst_tracked_ips` WHERE `user_id`='$user_id' AND `ip_addr`='$ip_addr'");

REPLACE WITH:

Code:

$result = $db->sql_query("SELECT `ip_long` FROM `".$prefix."_nsnst_tracked_ips` WHERE `user_id`='$user_id' AND `ip_addr`='$ip_addr'");

FIND:

Code:

list($hostname) = $db->sql_fetchrow($result);

REPLACE WITH

Code:

list($ip_long) = $db->sql_fetchrow($result);

FIND:

Code:

echo "<center>$ip_addr ($hostname)</center> ";

REPLACE WITH:

Code:

echo "<center>$ip_addr ($ip_long)</center> ";

Open: admin/modules/nukesentinel/ABTrackedPages.php

FIND:

Code:

$result = $db->sql_query("SELECT `hostname` FROM `".$prefix."_nsnst_tracked_ips` WHERE `user_id`='$user_id' AND `ip_addr`='$ip_addr'");

REPLACEWITH:

Code:

$result = $db->sql_query("SELECT `ip_long` FROM `".$prefix."_nsnst_tracked_ips` WHERE `user_id`='$user_id' AND `ip_addr`='$ip_addr'");

FIND:

Code:

list($hostname) = $db->sql_fetchrow($result);

REPLACE WITH:

Code:

list($ip_long) = $db->sql_fetchrow($result);

thanks

Steve

BobMarion · Posted: Thu Aug 03, 2006 2:06 pm

Your right, I did miss them and will add the corrections to the 2.5.01 on my desktop today

phoenix-cms · Worker Joined: Aug 05, 2005 Posts: 139

raven had quick check of your update, you attached one wrong file i think,
i speak with you soon anyway i hate work Sad

Steve

nb1 · Regular Joined: Mar 03, 2005 Posts: 94 Location: OZ

edit the nuke_nsnst_config table and change the version_number
I do not,completely understand all so update your nuke_nsnst_ip2country tables
does all need to be done even if you have a particular country ban?

utssace · Worker Joined: Feb 18, 2006 Posts: 155 Location: Virginia

I have applied this latest fix. BUT I am unclear about how to change the version number in the table.

I browsed the nuke_nsnst_config table, but couldn't find where the version number goes. I didn't see a version field.

Also, will this change fix the occurrances of 2.5.0 on the site (ie, in NS blocks and the admin panel)

montego · Posted: Sat Aug 05, 2006 11:32 pm

utssace,

Quote:

I browsed the nuke_nsnst_config table, but couldn't find where the version number goes. I didn't see a version field.

If you are using phpMyAdmin, most likely it is only showing you the first 30 records and it is on the second page. It is there...

Quote:

Also, will this change fix the occurrances of 2.5.0 on the site (ie, in NS blocks and the admin panel)

Yes.

nb1 · Regular Joined: Mar 03, 2005 Posts: 94 Location: OZ

I guess my question wasn't worth a reply

montego · Posted: Sun Aug 06, 2006 12:31 am

nb1 wrote:

I guess my question wasn't worth a reply

No need for the sarcasm. I missed your question.

Yes, given that 2.5.x now has a very strong reliance on the IP2C data, as we have seen in quite a few other threads, I strongly encourage everyone to keep their IP2County data up-to-date.

Bob has posted another update with 2.5.1 which should also be done.

gregexp · Posted: Sun Aug 06, 2006 12:31 am

I wouldnt say that at all.

This is just me personally, I didnt realize there was a question in there.

So heres an attempt to answer it, Updating the ip2country is always a good idea, It may undo a banning of an entire country but you now know that if you rebann the entire country, you wont be missing any ips that are located in that country so you may need to redo the banning, Its more dependant on HOW you banned the country that makes this answer so vague.

If you would please clarify as to your question.

And remember this is a support forum, people will answer to help, sometimes they cant or dont know and that just means that someone with either more time or knowledge would be better suited to answer your question, it does NOT mean your question was without merit or ,as you put it, worthy of a reply.

Sorry montego, I edited this to show we were typing at the same time.

nb1 · Regular Joined: Mar 03, 2005 Posts: 94 Location: OZ

Thank you very much montego

(so update your nuke_nsnst_ip2country tables
does all need to be done even if you have a particular country ban? ) was the
question darklord In case you missed it

And I refer people to this forum for help maybe my statement was a little short I don't see as well as others and have difficulties typing so sometimes Things does not come out as I intended for them to

utssace · Worker Joined: Feb 18, 2006 Posts: 155 Location: Virginia

Thx alot. Yep, now I know there are sometimes more than 1 page...hehe

FireATST · Posted: Sun Aug 06, 2006 11:00 am

When I attempt to do an SQL query of Moldova.sql I receive this error message:

SQL query:

INSERT INTO `nuke_nsnst_ip2country`
VALUES ( 1449840640, 1449840895, 1150779921, 'md', 'Moldova' ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1449840640-1449840895' for key 1

All the other sql's queries went just fine..... Question

FireATST · Posted: Sun Aug 06, 2006 11:03 am

hummm.....I tried doing an import of the file and it worked ok then instead of a select all, copy and paste in Sql window. BTW...I use Crimson Editor as a text editor.

nb1 · Regular Joined: Mar 03, 2005 Posts: 94 Location: OZ

Crimson Editor Is is a great little tool sometimes notepad or word will add some extra chatters I think that's the reason you should use something besides those two

FireATST · Posted: Sun Aug 06, 2006 1:04 pm

exactly why I use it.... Smile

utssace · Worker Joined: Feb 18, 2006 Posts: 155 Location: Virginia

I didn't do the copy & paste thing....to much work

I just imported each SQL file one at a time.

I also had a blurp with the Maldova file. I just refreshed my sign-in and imported it again & it worked.

Loki · Worker Joined: Oct 05, 2003 Posts: 102 Location: Illinois

utssace wrote:

I have applied this latest fix. BUT I am unclear about how to change the version number in the table.

I browsed the nuke_nsnst_config table, but couldn't find where the version number goes. I didn't see a version field.

Also, will this change fix the occurrances of 2.5.0 on the site (ie, in NS blocks and the admin panel)

Run this line through phpmyadmin

UPDATE nuke_nsnst_config SET config_value ='2.5.1' where config_name='version_number';