Add membership script to your site

Discussion in 'Scripts' started by Rezo, Apr 11, 2006.

  1. #1
    Simple Member allows you to put up that much needed protective area on your web site where you don't want anyone snooping without first signing up. The code is too big so download it here. SQL Querry:
    
    DROP TABLE IF EXISTS `users`;
    CREATE TABLE `users` (
      `id` bigint(99) NOT NULL auto_increment,
      `uid` varchar(255) default NULL,
      `auth` varchar(255) default NULL,
      `pwd` varchar(255) default NULL,
      `email` varchar(255) default NULL,
      `fname` varchar(255) NOT NULL default '',
      `lname` varchar(255) NOT NULL default '',
      `addr` varchar(255) NOT NULL default '',
      `city` varchar(255) NOT NULL default '',
      `state` varchar(255) NOT NULL default '',
      `country` varchar(255) NOT NULL default '',
      `zipcode` varchar(255) NOT NULL default '',
      `phone` varchar(255) NOT NULL default '',
      `dateexpire` varchar(255) NOT NULL default '',
      `datesignup` varchar(255) NOT NULL default '',
      `paymethod` enum('paypal','2checkout') default NULL,
      `status` enum('active','expired') NOT NULL default 'expired',
      `type` enum('adm','mem','sing') NOT NULL default 'sing',
      `dt_changed` timestamp(14) NOT NULL,
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM;
    
    Code (markup):

     
    Rezo, Apr 11, 2006 IP