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
NoFantasy
Worker
Worker


Joined: Apr 26, 2005
Posts: 114

PostPosted: Fri Nov 03, 2006 8:22 pm Reply with quote

Data in ireland.data (in tables shipped with NS 2.5.03) at
1422917632||1423441919||1109653200||ie||
(84.208.0.0-84.215.255.255)
is belonging to Norway, not Ireland.

Not really sure where this data actually comes from originally, but i wanted you to know in any case.
 
View user's profile Send private message
BobMarion
Former Admin in Good Standing


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

PostPosted: Sat Nov 04, 2006 3:47 am Reply with quote

I'll make that change for the next ip2country dump. A large part of the ip2county db came from Only registered users can see links on this board! Get registered or login! . It didn't take long to figure out that it wasn't updated as well as updating from users so we stopped getting it from that source.

Everyso often I clear ranges to get updated info and I also collect info from people like yourself Smile

_________________
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
southern
Client


Joined: Jan 29, 2004
Posts: 591
Location: Texas

PostPosted: Sun Nov 05, 2006 10:14 am Reply with quote

I have a problem with the 'date' field in the ip2country table. I was importing the IP sql and got this error:
Code:


Error
SQL query:
INSERT INTO `nuke_nsnst_ip2country` ( `ip_lo` , `ip_hi` , `date` , `c2c` )
VALUES ( 982745088, 982753279, 1139120757, 'af' ) ;

MySQL said: 
#1054 - Unknown column 'date' in 'field list'

It seems I have no 'date' field. I looked at the nuke_nsnst_ip2country structure and I have:
Code:


ip_lo int(10)   UNSIGNED No 0               
ip_hi int(10)   UNSIGNED No 0               
c2c char(2) latin1_swedish_ci  No

So I need to fix it and insert the 'date' fueld before I can import the IP sql. Anyone got the code for this? Thanks!

_________________
Computer Science is no more about computers than astronomy is about telescopes.
- E. W. Dijkstra 
View user's profile Send private message Visit poster's website MSN Messenger ICQ Number
NoFantasy
PostPosted: Mon Nov 06, 2006 5:36 am Reply with quote

Code:
ALTER TABLE `nuke_nsnst_ip2country` ADD  `date` int(20) NOT NULL default '0' AFTER `ip_hi`
 
NoFantasy
PostPosted: Mon Nov 06, 2006 5:40 am Reply with quote

Hm, a bit in a hurry there, sorry...it will work, however it won't add any key like it's supposed to. Drop the nuke_nsnst_ip2country table, run
Code:
CREATE TABLE `nuke_nsnst_ip2country` (`ip_lo` int(10) unsigned NOT NULL default '0', `ip_hi` int(10) unsigned NOT NULL default '0', `date` int(20) NOT NULL default '0', `c2c` char(2) NOT NULL default '', PRIMARY KEY (`ip_lo`,`ip_hi`), KEY `c2c` (`c2c`), KEY `date` (`date`))
 
southern
PostPosted: Mon Nov 06, 2006 12:46 pm Reply with quote

NoFantasy wrote:
Hm, a bit in a hurry there, sorry...it will work, however it won't add any key like it's supposed to. Drop the nuke_nsnst_ip2country table, run
Code:
CREATE TABLE `nuke_nsnst_ip2country` (`ip_lo` int(10) unsigned NOT NULL default '0', `ip_hi` int(10) unsigned NOT NULL default '0', `date` int(20) NOT NULL default '0', `c2c` char(2) NOT NULL default '', PRIMARY KEY (`ip_lo`,`ip_hi`), KEY `c2c` (`c2c`), KEY `date` (`date`))


Thanks very much, NoFantasy. I'll do this Smile
 
southern
PostPosted: Mon Nov 06, 2006 1:24 pm Reply with quote

Worked perfect. I can now import IP sql all day lol
 
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 ©