Main Menu

sign-up page blog

Started by Gandalf, March 29, 2003, 10:48:05 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Gandalf

I'm gonna use this to make a log of the design process. Hopefully it will make tracking any errors that occur easy for people to spot!
*G*

Cake: Four large eggs. One cup semi-sweet chocolate chips. Three/four cups butter or margarine. One and two third cups granulated sugar. Two cups all purpose flour. Fish shaped ethyl benzene. Twelve medium geosynthetic membranes. Three tablespoons rhubarb, on fire.

Gandalf

ok. I've set a database up on red. created a user that can access this and locked it down to blackys ip. this user can only add edit delete and modify data anyway.

using phpmyadmin (I love this program!) I've created the following.

CREATE TABLE `players` (
`wonid` CHAR( 16 ) NOT NULL ,
`ip` CHAR( 15 ) NOT NULL ,
`tag` CHAR( 50 ) NOT NULL ,
`joindate` DATETIME NOT NULL ,
`password` CHAR( 8 ) NOT NULL
);

ok, we need e-mail to be stored as well.

ALTER TABLE `players` ADD `e-mail` LONGTEXT NOT NULL ;

changed date to a char field to make it human readable.

ALTER TABLE `players` CHANGE `joindate` `joindate` CHAR( 50 ) NOT NULL

and mysql names don't like - !!

ALTER TABLE `players` CHANGE `e-mail` `email` LONGTEXT NOT NULL

this'll be a good idea!

ALTER TABLE `players` ADD UNIQUE (
`wonid`
)
*G*

Cake: Four large eggs. One cup semi-sweet chocolate chips. Three/four cups butter or margarine. One and two third cups granulated sugar. Two cups all purpose flour. Fish shaped ethyl benzene. Twelve medium geosynthetic membranes. Three tablespoons rhubarb, on fire.

Gandalf

ok, that's the basic database sorted. It can have other tables or fields added as required. I've got a very basic page up that enters data into it.

There is no checking for correct e-mails or duplicate wonid's yet (just throws up an error) but this will follow.

I'm still learning php so this will be a 'try and see' method of coding :)
*G*

Cake: Four large eggs. One cup semi-sweet chocolate chips. Three/four cups butter or margarine. One and two third cups granulated sugar. Two cups all purpose flour. Fish shaped ethyl benzene. Twelve medium geosynthetic membranes. Three tablespoons rhubarb, on fire.

Stryker

-=[dMw]=-Stryker

Gandalf

ok, I hope to have a beta 0.0000001 version for people to play with later this evening.

It'll be on greenberry.co.uk

And it won't be pretty, just functional.

There will be two parts. 1 = first time registration. This is where you enter your details, and 2 = modify stuff. This is where you login and can change stuff like password, and e-mail. We need to decide on what we want peeps to change.

oh, and sorry for the delay in this. kinda forgot about it!  :oops:
*G*

Cake: Four large eggs. One cup semi-sweet chocolate chips. Three/four cups butter or margarine. One and two third cups granulated sugar. Two cups all purpose flour. Fish shaped ethyl benzene. Twelve medium geosynthetic membranes. Three tablespoons rhubarb, on fire.