Breaking News: Grepper is joining You.com. Read the official announcement!

php mysql advanced full login system with admin features

constantino Guerrico answered on October 3, 2022 Popularity 1/10 Helpfulness 1/10

answer php mysql advanced full login system with admin features

php mysql advanced full login system with admin features

Comment

#
#  dbtables.sql
#
#  Simplifies the task of creating all the database tables
#  used by the login system.
#
#  Can be run from command prompt by typing:
#
#  mysql -u yourusername -D yourdatabasename < dbtables.sql
#
#  That's with dbtables.sql in the mysql bin directory, but
#  you can just include the path to dbtables.sql and that's
#  fine too.
#
#  Written by: Jpmaster77 a.k.a. The Grandmaster of C++ (GMC)
#  Last Updated: August 13, 2004
#
#

#  Table structure for users table
#
DROP TABLE IF EXISTS users;
CREATE TABLE users (

 username varchar(30) primary key,
 password varchar(32),
 userid varchar(32),
 userlevel tinyint(1) unsigned not null,
 email varchar(50),
 timestamp int(11) unsigned not null
);
#
#  Table structure for active users table
#
DROP TABLE IF EXISTS active_users;
CREATE TABLE active_users (

 username varchar(30) primary key,
 timestamp int(11) unsigned not null
);
#
#  Table structure for active guests table
#
DROP TABLE IF EXISTS active_guests;
CREATE TABLE active_guests (

 ip varchar(15) primary key,
 timestamp int(11) unsigned not null
);
#
#  Table structure for banned users table
#
DROP TABLE IF EXISTS banned_users;
CREATE TABLE banned_users (

 username varchar(30) primary key,
 timestamp int(11) unsigned not null
);

Popularity 1/10 Helpfulness 1/10 Language sql

Source: evolt.org

Tags: admin login-system mysql php sql

Link to this answer
Share Copy Link

Contributed on Oct 03 2022

constantino Guerrico

0 Answers Avg Quality 2/10

php mysql advanced full login system with admin features

Contents

More Related Answers

php mysql advanced full login system with admin features

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.