Hello all!

Well I am working on the SQL database at the moment that the website will work from and so this will be what all other functionality is drawn from. This is currently what I plan to do:

Every member will have a profile page that they will update, which will include all the same information as before, Steam ID, Name, Email etc etc etc. This will be done by the user creating an account and entering all these details (which I will then validate to ensure we only have members on the roster). This will then automatically add all your details and your photo to the roster, and the display of members on the right of the page.

In regards to recording matches, there will be a SQL table which will link to the Members table (the roster). This means when members are logged in they can record a new match with images and select which members from the roster played. In the match log the user entering the results will need to enter the following information:
- Number of player per side
- PCW or what league
- Screen-shots of the results
- End Score
- Members who played (from a list options taking from the roster with the option of 'Mixer' if a non member played).
- The opposition's name.
- Home or Away
- Who was leading the match
- Comments (for example was there a lot of lag?
- S666 of the match (for the user entering the result to select who they thought played best, with the option of N/A if everyone was terrible...).
- Sniper of the match (for the user entering the result to select who they thought was the best long range shot, does not need to be a AWP, also allows for N/A).
- CQC Master (for the user entering the result to select who they thought was the best player in close combat, also allows for N/A)
- S666 member of Shame (for the member who played worse, was abusive or 'rage quite') - This will not be displayed public but instead just recorded and used in review by admins)

This will then keep statics which can be displayed on the website for the most active (played the most matches), best sniper, best in close range etc. Also the 5 latests match results will be automatically displayed on the left hand side of every page.

There will also be a news table in the database which will allow select users to post news items on to front page with the option to email members the news item.

The last table will simply retain all our server information (including vent) when we have our game servers and who is contributing funds to the servers. These details will again be automatically displayed on the left side of every page on the website.

What do people think of these ideas? Anything you think should be removed or added? Please let me know soon, as once I start coding with the database in place, it will be a pain to change anything!

not sure about the best range and close combat player, may be too difficult to judge, also player of shame isnt best idea... maybe having a database just to record any1 whining, rage quiting etc... for u to collect, but maybe not calling it s666 player of shame

We would certainly need some guidelines as to how to judge who did best at what, perhaps it should be revised to record exceptional performances rather than just 'pretty good' performances.

Also, do we want to record who, if anyone, lead the match? That's a more objective determination.

S666 of shame issue:
Okay, well I can name it anything you want What do you think would be a better name? I wont display this statistic on the website, it will just be for website admins to see. Perhaps I should also allow for a 'Reason' to be added as to why the player was selected?

Best Players issue:
Yes I think it could be hard to decide, so i suggest that if you do not know who to put as best player in any of the fields, just ask those who played for an agreement, and if one cant be met, simply put down as 'N/A'. What do you think?

I think that this is awsome and will work brilliant!

This is quite funny actually. You know you said you wanted to try and sell this once it's complete.

I had someone I know who runs a server company contact me asking for more details on the clan package I was working on...

Turned out he contacted the wrong guy and meant to speak to someone at gamersgfx. I told him what we were doing and that we could maybe do it for cheaper. I'll send him your way Ieuan!

Funny how he was after exactly what you were doing!

Ah good, well if he has any ideas on what he would like to see in the system, he should contact me ASAP. What is his steam/MSN? And thanks for sending my way

I think the list of players and how they have done in mixes and matches then that was you get the 5 best payers of the week to play the wars andthe others get there chance to improve in the mixes and pcw's i think that would be quite fun as it would make you play better to get into the war??

But if they had got a score of : 0 for 12 or 1 for 12 they should get dropped for at least 1 game **cough** **cough** Blackop's lol :-)

Possible to do...but maybe add that later, I am having to make a cut off in the design change otherwise it will never get done!