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;Очень надо, для зачетной работы по предмету
Simple Member
by: http://free-php.net
# Requirements
-- PHP 4 (http://www.php.net)
-- MySQL (http://www.mysql.com)
# MySQL Database Setup
-- Open sql.txt in the main Simple Member folder.
-- Paste the contents into a tool that can execute SQL commands for your MySQL DB
# Installation
-- Follow the MySQL Database Setup Before Continuing
-- Open main.php in the root folder and modify the settings for your server
-- Upload to your server
# How to Use Simple Member
-- At this time there are no admin utilities to view, edit, remove your members, etc.
-- The login / add member script is located at http://domain/to/main/path/index.php
# TROUBLE SHOOTING
-- Make sure that you have created the required database table (users)
-- Make sure all paths are correct in each file use full paths if necessary.
кто может сделать на пиво кину бабла) Народ, войдите в мою ситуейшен) помогите)
