User:MrCalifornia/tvolt roadmap

From Wikipedia, the free encyclopedia

Contents

[edit] user

  • need email verification stuff
    • verify_email table

[edit] database tables

[edit] users

drop table if exists users;
create table users (
        id                      int             not null auto_increment,
        email                   varchar(255)    not null,
        username                varchar(50)     not null,
        hashed_password         char(40)        null,
        primary key (id)
);
  • Add "active"

[edit] views

[edit] register

Form Fields:

  • E-Mail Address
  • Username
  • Password

Validate:

  • E-Mail Address
    • Unique
  • Username
    • Unique
    • != E-Mail Address
    • != Any E-Mail Address in DB
    • Letters and Numbers Only
    • 4-30 Characters (?)
  • Password
    • 4-30 Characters (?)

[edit] login

Form Fields:

  • E-Mail Address or Username
  • Password

[edit] actions

[edit] logout

[edit] show

[edit] episode

[edit] history

[edit] show

[edit] episode

[edit] sitenews

[edit] stats

[edit] admin

[edit] users

[edit] talk

[edit] show

[edit] episode

[edit] blog