Sentinel and PHP nuke ?

New Member Joined: Jan 08, 2005 Posts: 3

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!

Sells PC To Pay For Divorce Joined: Posts: 5661

well i dont know what you did but sentinel still uses the table ..nsnst_tracked_ips

Posted: Sat Jan 08, 2005 8:13 am

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!

Posted: Sat Jan 08, 2005 8:20 am

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 ;

Posted: Sat Jan 08, 2005 8:29 am

That did it, many thanks!