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!
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`
)
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 :)
cool, where is it?
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: