| Page: 1 | Rating: Unrated [0] |
My Visitors Table
| Good [+1]Toggle ReplyLink» neoform a répondu le Wed 24 Sep, 2003 @ 5:14pm |
 Coolness: 339815 | 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 a répondu le Wed 24 Sep, 2003 @ 5:24pm |
 Coolness: 2604135 | 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 a répondu le Wed 24 Sep, 2003 @ 5:34pm |
 Coolness: 66665 | 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 a répondu le Wed 24 Sep, 2003 @ 7:25pm |
| Coolness: 339815 | yeah, i'll show you how i do the unique IP per user table.. |
My Visitors Table
| Page: 1 |
[ Haut de la page ] |
Poster Une Réponse |
Vous devez être connecté pour soumettre une réponse.
[ Haut de la page ] |
