Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™
Author Message
jalex
New Member
New Member


Joined: Jan 08, 2005
Posts: 3

PostPosted: Sat Jan 08, 2005 6:21 am Reply with quote

I've succesfully put sentinel 2.1.2 over php nuke 7.6 and it worked brilliantly.

However I decided to upgrage sentinel to 2.1.3 because of the santy threat and it mashed up my database.

I lost the sommaire menu (now fixed)

But the biggest problem is with tracked IPs. The table no longer exists and I cant track IPs. Does anyone have a sql script to re-create the table?

Thanks in advance!
 
View user's profile Send private message
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Sat Jan 08, 2005 7:51 am Reply with quote

well i dont know what you did but sentinel still uses the table ..nsnst_tracked_ips
 
View user's profile Send private message
jalex
PostPosted: Sat Jan 08, 2005 8:13 am Reply with quote

The table ...nsnst_tracked_ips exists but there's no structure to it, so no ip data gets tracked. I've found the table creating script in the nsnst install php file, but I'm not that good on sql so wondered if anyone has a sql script version to recreate the table and prepopulate with any constants if necessary!
 
hitwalker
PostPosted: Sat Jan 08, 2005 8:20 am Reply with quote

well should be something like this..

Code:


CREATE TABLE `nuke_nsnst_tracked_ips` (
  `tid` int(10) NOT NULL auto_increment,
  `ip_addr` varchar(15) NOT NULL default '',
  `hostname` varchar(100) NOT NULL default '',
  `user_id` int(11) NOT NULL default '1',
  `username` varchar(60) NOT NULL default '',
  `user_agent` text NOT NULL,
  `date` int(20) NOT NULL default '0',
  `page` text NOT NULL,
  `x_forward_for` varchar(32) NOT NULL default '',
  `client_ip` varchar(32) NOT NULL default '',
  `remote_addr` varchar(32) NOT NULL default '',
  `remote_port` varchar(11) NOT NULL default '',
  `request_method` varchar(10) NOT NULL default '',
  `c2c` char(2) NOT NULL default '00',
  PRIMARY KEY  (`tid`),
  KEY `tid` (`tid`),
  KEY `maintracking` (`ip_addr`,`hostname`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
 
jalex
PostPosted: Sat Jan 08, 2005 8:29 am Reply with quote

That did it, many thanks!
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™

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 ©