Author: Jason Ashdown

Basic Info

• Home
• Getting Started
• Features
• Screenshots
• Change Log
• Function list
• Database Schema
• URI System
• Examples
• F.A.Q

Config

• CI Config
• cl_auth.php

Controllers

• Auth

Libraries

• CL_Auth.php
• Session.php
• CL_Validation.php

Language

• english/cl_val_lang.php

Models

• Group URI
• Groups
• Users
• Users_Temp
• Users_Autologin

Plugins

• CL Captcha

Database Schema

ci_sessions

CREATE TABLE IF NOT EXISTS `ci_sessions` (
  `session_user_id` mediumint(9) NOT NULL default '0',
  `session_id` varchar(40) collate utf8_bin NOT NULL default '0',
  `ip_address` varchar(16) collate utf8_bin NOT NULL default '0',
  `user_agent` varchar(150) collate utf8_bin NOT NULL,
  `last_page` varchar(150) collate utf8_bin NOT NULL,
  `last_activity` int(10) unsigned NOT NULL default '0',
  `session_data` text collate utf8_bin,
  PRIMARY KEY  (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

users

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL auto_increment,
  `group_id` int(11) NOT NULL default '0',
  `user_ip` varchar(40) collate utf8_bin NOT NULL,
  `username` varchar(25) collate utf8_bin NOT NULL,
  `username_clean` varchar(25) collate utf8_bin NOT NULL,
  `password` varchar(34) collate utf8_bin NOT NULL,
  `email` varchar(100) collate utf8_bin NOT NULL,
  `banned` varchar(1) collate utf8_bin NOT NULL default '0',
  `ban_reason` varchar(255) collate utf8_bin default NULL,
  `login_attempts` mediumint(1) unsigned NOT NULL default '0',
  `newpass` varchar(34) collate utf8_bin default NULL,
  `newpass_key` varchar(32) collate utf8_bin default NULL,
  `newpass_time` datetime default NULL,
  `active_time` mediumint(8) unsigned NOT NULL default '0',
  `last_visit` datetime NOT NULL default '0000-00-00 00:00:00',
  `created` timestamp NOT NULL default '0000-00-00 00:00:00',
  `modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

users_autologin

CREATE TABLE IF NOT EXISTS `user_autologin` (
  `key_id` char(32) collate utf8_bin NOT NULL,
  `user_id` mediumint(8) NOT NULL default '0',
  `user_agent` varchar(150) collate utf8_bin NOT NULL,
  `last_ip` varchar(40) collate utf8_bin NOT NULL,
  `last_login` int(11) NOT NULL default '0',
  PRIMARY KEY  (`key_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

user_profile

CREATE TABLE IF NOT EXISTS `user_profile` (
  `user_id` int(11) NOT NULL,
  `fullname` varchar(50) default NULL,
  `location` varchar(25) default NULL,
  `website` varchar(100) default NULL,
  `occupation` varchar(50) default NULL,
  `introduction` text,
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

user_temp

CREATE TABLE IF NOT EXISTS `user_temp` (
  `id` int(11) NOT NULL auto_increment,
  `user_ip` varchar(40) collate utf8_bin NOT NULL,
  `username` varchar(255) collate utf8_bin NOT NULL,
  `username_clean` varchar(255) collate utf8_bin NOT NULL,
  `password` varchar(34) collate utf8_bin NOT NULL,
  `email` varchar(100) collate utf8_bin NOT NULL,
  `activation_key` varchar(50) collate utf8_bin NOT NULL,
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;