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™ v2.5.x
Author Message
phoenix-cms
Worker
Worker


Joined: Aug 05, 2005
Posts: 139

PostPosted: Thu Aug 03, 2006 5:39 am Reply with quote

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><b>$ip_addr ($hostname)</b></center><br>";


REPLACE WITH:

Code:
echo "<center><b>$ip_addr ($ip_long)</b></center><br>";


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

_________________
Evo 3.0 Developer & nukecops.com Admin
Image
coming soon Only registered users can see links on this board! Get registered or login! Smile 
View user's profile Send private message Send e-mail
BobMarion
Former Admin in Good Standing


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

PostPosted: Thu Aug 03, 2006 1:06 pm Reply with quote

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

_________________
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
phoenix-cms
PostPosted: Fri Aug 04, 2006 9:03 pm Reply with quote

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
Regular


Joined: Mar 03, 2005
Posts: 94
Location: OZ

PostPosted: Sat Aug 05, 2006 3:04 am Reply with quote

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?

_________________
Member Of The Windows Vista help and Support Community 
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
utssace
Worker
Worker


Joined: Feb 18, 2006
Posts: 155
Location: Virginia

PostPosted: Sat Aug 05, 2006 8:36 pm Reply with quote

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)
 
View user's profile Send private message Visit poster's website
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9449
Location: Arizona

PostPosted: Sat Aug 05, 2006 10:32 pm Reply with quote

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.

_________________
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 Visit poster's website
nb1
PostPosted: Sat Aug 05, 2006 11:20 pm Reply with quote

I guess my question wasn't worth a reply
 
montego
PostPosted: Sat Aug 05, 2006 11:31 pm Reply with quote

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
The Mouse Is Extension Of Arm


Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol

PostPosted: Sat Aug 05, 2006 11:31 pm Reply with quote

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.

_________________
For those who stand shall NEVER fall and those who fall shall RISE once more!! 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
nb1
PostPosted: Sat Aug 05, 2006 11:52 pm Reply with quote

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
PostPosted: Sun Aug 06, 2006 6:21 am Reply with quote

Thx alot. Yep, now I know there are sometimes more than 1 page...hehe
 
FireATST
RavenNuke(tm) Development Team


Joined: Jun 12, 2004
Posts: 637
Location: Ohio

PostPosted: Sun Aug 06, 2006 10:00 am Reply with quote

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
 
View user's profile Send private message Visit poster's website MSN Messenger ICQ Number
FireATST
PostPosted: Sun Aug 06, 2006 10:03 am Reply with quote

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
PostPosted: Sun Aug 06, 2006 11:25 am Reply with quote

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
PostPosted: Sun Aug 06, 2006 12:04 pm Reply with quote

exactly why I use it....Smile
 
utssace
PostPosted: Sun Aug 06, 2006 4:54 pm Reply with quote

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
Worker


Joined: Oct 05, 2003
Posts: 107
Location: Illinois

PostPosted: Mon Aug 21, 2006 6:24 pm Reply with quote

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';
 
View user's profile Send private message Visit poster's website
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™ v2.5.x

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 ©