Page: 1 | Rating: Unrated [0] |
My Visitors Table
Good [+1]Toggle ReplyLink» neoform replied on Wed Sep 24, 2003 @ 5:14pm |
CREATE TABLE `visitors` (
`ip` varchar(15) NOT NULL default '', `user_id` int(10) NOT NULL default '0', `current_page` varchar(50) NOT NULL default '', `date` int(14) NOT NULL default '0', `browser` varchar(200) NOT NULL default '', `screen_rez` varchar(15) NOT NULL default '', `hits` int(10) NOT NULL default '0', `banned` int(1) NOT NULL default '0', PRIMARY KEY (`ip`) ) |
Good [+1]Toggle ReplyLink» Nuclear replied on Wed Sep 24, 2003 @ 5:24pm |
CREATE TABLE `dataWhois` (
`ip` varchar(15) NOT NULL default '', `alias` varchar(16) NOT NULL default '', `laston` int(12) NOT NULL default '0', `page` varchar(100) NOT NULL default '', `type` int(1) NOT NULL default '0', `url` varchar(255) NOT NULL default '', PRIMARY KEY (`ip`), UNIQUE KEY `alias` (`alias`) ) TYPE=MyISAM; |
Good [+1]Toggle ReplyLink» OMGSTFUDIEPLZKTX replied on Wed Sep 24, 2003 @ 5:34pm |
If this is for a listings of whos on the site:
CREATE TABLE `visitors` ( `visitor_id` INT( 4 ) UNSIGNED NOT NULL AUTO_INCREMENT , `user_id` INT( 4 ) UNSIGNED NOT NULL , `session_id` VARCHAR( 255 ) NOT NULL , `ipddr` VARCHAR( 15 ) NOT NULL , `login_time` DATETIME NOT NULL , `last_use` DATETIME NOT NULL , `location` VARCHAR( 255 ) NOT NULL , PRIMARY KEY ( `visitor_id` ) , INDEX ( `user_id` , `session_id` ) ); Then you compare last_use to login_time to figure out how long the user has been idle for. |
Good [+1]Toggle ReplyLink» neoform replied on Wed Sep 24, 2003 @ 7:25pm |
My Visitors Table
Page: 1 |
[ Top Of Page ] |
Post A Reply |
You must be logged in to post a reply.
[ Top Of Page ] |