Firstly, this is a thread ONLY for the design of our signup system. Please put any branchoffs in their own thread. I feel this is critical to our success as a shity hard to manage system will break us far quickly than this could make us.
I have the following requirments off the top of my head. I've outlined functionality based on what we want from this wonid data base system, our goals etc. Please comment and help develop this spec peeps.
To help you understand the functionality of these pages you need to know when we go live the games servers will only let peeps on who have:
A) A matching wonid game tag combo in our database.
B) The server password.
1) Signup page.
1.1) users sign up with their wonid and email address.
1.2) users only get the password for these webpages via return email to their provided address. Also the game server password will only be included in this email, plus instructions to visit the "edit details" page to enter their game tag (player name).
1.3) This page also outlines they will be authenticated on the game server by their wonid and tag combo. Keep this short so people actually read it!
2) Edit Details page.
2.1) This is a page that requires the user's wonid and password from function 1.1.
2.2) Once logged on they may edit their registered tag name.
2.3)To prevend wonid abuse they can ONLY edit their tag name. A new wonid means a new registration. (this way we can have a simple report that outlines tags being used under multiple won ids.
3) Fun stuff.
In time I hope we could add a stats pages for wonids, dates joined etc etc. Not neccessarily for the public's viewing, mainly for us.
Database storing wonids is as follows:
database name: pcs
table: players
column: wonid char(16)
column: ip char(15) (used only by p2)
column: tag char(50)
column: joindate tba
column: password char(8)
notice how they can only enter a game tag using their password that we assign to get onto the details page.
Hence they can only get onto the servers once we know we have a valid email address. This is all automated so requires no work on our part.
QUESTION: do we allow hotmail, msn and google email accounts used as a means of contact? I've seen some sites of late that only allow ISP accounts.
Quotenotice how they can only enter a game tag using their password that we assign to get onto the details page.
Hence they can only get onto the servers once we know we have a valid email address. This is all automated so requires no work on our part.
QUESTION: do we allow hotmail, msn and google email accounts used as a means of contact? I've seen some sites of late that only allow ISP accounts.
Regarding the e-mail I think we should avoid the largest spambanks. The message we send is pretty important to them and shouldn't be hidden amongst junk mail.
Good work Stryker! :thumbsup:
ok, I've posted in the other thread about my requirements before seeing this one! I'll copy here and remove the other post.
ok, I've got icq installed now (at home, not at work) so can talk on that.
Where will the signup pages/database be held? Blackadder seems the logical choice. If so, can I have an account on there so I can ftp and stuff.
As soon as that is sorted I'll get to work on the member sign-up pages.
Are you happy with that high-level requirment gandy? its all quiet straight forward. I'd imagine as your designing it you may develop the need for some more columns in the database or indeed more tables.
Yes the pages should go on blackadder. Sadako, can you give him the details and perhaps a folder within the existing site for the pages please?
Also gandy, the database is on another server..... the crappy debian install on blackadder has been giving me grief regarding mysql.
I look forward to a few icq exchanges this weekend then. remember im 28096688 and you have all my numbers? if not then for starters my home line is 01922 447346
Quote
Yes the pages should go on blackadder. Sadako, can you give him the details and perhaps a folder within the existing site for the pages please?
Signed sealed delivered.
yeah got it. ok will this ftp acct allow me access to the forums? (please, please! So much easier with a graphical gui. ok, ok, I'm a minion of bill and command line stuff has been purged from my memory :)
I'll talk this weekend about the mysql stuff. I can host it on red if you want (have already got phpmyadmin on that and love it) to make it easier for me to configure.
Quoteyeah got it. ok will this ftp acct allow me access to the forums?
Nope. I think the forum is on a different machine (or dir that I can't access). Talk to Doggers or Strikeher.
I take it that the database will store the valid email addresses? That way we might be able to kill 2 birds with one stone - it could provide the Admins with a way of contacting a registered player that hasn't registered at the forums.....
Would a new email address force a new registration? How are you going to vaildate a changed email address without the server pw being changed?
Just a couple of potentially non-relevant thoughts....
TL. 8)
Quotenotice how they can only enter a game tag using their password that we assign to get onto the details page.
Hence they can only get onto the servers once we know we have a valid email address. This is all automated so requires no work on our part.
Bugger i could have been the man who gave out passwords ie:- Strykerbackstabbingteamateshootingit......bit long but i think it works.
Seriously i have so little knowledge on this stuff ill leave it to the men that know....But if any graphic/piccies need doing just ask. (seems the only thing im not too bad at)
yeah, graphics would be good. make it look nice and all that. when the basic page is done, you can have a look and 'beautify' :)
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
);
now to start on the pages. I'll try to get most of it sorted today, but will be out this afternoon (mothers day - and she wants a water butt! odd :? )
QuoteI take it that the database will store the valid email addresses? That way we might be able to kill 2 birds with one stone - it could provide the Admins with a way of contacting a registered player that hasn't registered at the forums.....
Would a new email address force a new registration? How are you going to vaildate a changed email address without the server pw being changed?
Just a couple of potentially non-relevant thoughts....
TL. 8)
Bump.
How are we doing on this matter? After last nights incident it feels important that we get thing in use.
Please give us an update.
Cheers,
An update would be helpful as it would give us some valuable info for issues such as last nights rogue player etc. At least we would know then whether or not they were registered.
TL. 8)
it kind of tapered off sadako. I think the ball is firmly in Gandy's court so blame him :-)
The server plugin is working so we just need to eatablish some procedure and then the webpages for admining the database.
I'll see what he says and we can take it from there.