Printable Version of Topic

Click here to view this topic in its original format

HTMLHelp Forums _ Server-side Scripting _ Need a little help with a Website Design

Posted by: Typhon Jul 25 2012, 01:45 AM

Currently, i am pretty knowledgeable with HTML, able to create some basic - intermediate stuff. Right now i am going to create a website for somewhat personal use along with some friends for something. Basically, it is going to be for a few games that we play.

I want to create a site that will allow us to track the games that we play with each other as well as match history. That way it isn't being done in a Google Doc and looks a little prettier tongue.gif

However, i have come across 2 hurdles, possibly 1, as they both might be related.

Basically, i know how i want the layout to be and what i want. It is going to be very simple, with sortable tables that will contain information about wins/losses etc. and also be searchable by name and sorted/searchable by the game that is played as well.

However, i kinda want to go the extra mile on this. Instead of going through the code on a regular basis and updating the tables with new matches, i want to be able to do this on the website.

So basically, i want to create a way i, and possibly someone else, could log into the website and be presented with a new option. The ability to add new people and new matches to the list. Further, i would like to be able to have it be something like this when i add a match.

Player A plays Player B
Player A beats Player B
Player A now has 23 wins
Player B now has 10 losses
Player A now has a total of 30 games played.
Player B now has a total of 22 games played.

All of this information i would like to be done through the website. I want to be able to type in the names of these players, signify what game they played, and who won, and then have it search through the lists/tables already present, and then update information based on that (so it isn't done manually, just initially to set things up) And finally to publish the new information on the website and searchable/sortable tables.

My 2 hurdles are the following:

How do i create a page, that allows people to do what i am saying (search and sort through various tables and stats) but then has a login form. When logged in, it would preset the same page but possibly with 2 or more additional buttons, something like "Add player" "Add a match" That would allow me to add a new player and new match to the lists.

How would i go the step further and have the site check the lists and tables for specific stats, and then update the new totals based on the information entered.

TLDR:

How do i create a site that has a page that people can look at, and a login form. Then when logged in, displays additional options?
How do i create a website that when logged in and using those additional options, checks data currently on the website, and does the needed mathematical calculations, and then updates the information (So it doesn't have to be done manually each time)


Thanks in advanced for the help.

P.S. i am not asking to be hand held on how to do this and be told line for line what i should put in the code. But if someone could just point me in the right direction, that would be great smile.gif
P.S.S. None of the stuff i am talking about or the site, needs to be super pretty right now. First things first, i want to get it functional, then later on i can make it pretty.

Posted by: pandy Jul 25 2012, 04:39 AM

You can't do that with HTML so I move this thread to Server-side Scripting. smile.gif

Posted by: Ephraim F. Moya Jul 25 2012, 09:01 AM

QUOTE(Typhon @ Jul 25 2012, 12:45 AM) *

Currently, i am pretty knowledgeable with HTML, able to create some basic - intermediate stuff. Right now i am going to create a website for somewhat personal use along with some friends for something. Basically, it is going to be for a few games that we play.

I want to create a site that will allow us to track the games that we play with each other as well as match history. That way it isn't being done in a Google Doc and looks a little prettier tongue.gif

However, i have come across 2 hurdles, possibly 1, as they both might be related.

Basically, i know how i want the layout to be and what i want. It is going to be very simple, with sortable tables that will contain information about wins/losses etc. and also be searchable by name and sorted/searchable by the game that is played as well.

However, i kinda want to go the extra mile on this. Instead of going through the code on a regular basis and updating the tables with new matches, i want to be able to do this on the website.

So basically, i want to create a way i, and possibly someone else, could log into the website and be presented with a new option. The ability to add new people and new matches to the list. Further, i would like to be able to have it be something like this when i add a match.

Player A plays Player B
Player A beats Player B
Player A now has 23 wins
Player B now has 10 losses
Player A now has a total of 30 games played.
Player B now has a total of 22 games played.

All of this information i would like to be done through the website. I want to be able to type in the names of these players, signify what game they played, and who won, and then have it search through the lists/tables already present, and then update information based on that (so it isn't done manually, just initially to set things up) And finally to publish the new information on the website and searchable/sortable tables.

My 2 hurdles are the following:

How do i create a page, that allows people to do what i am saying (search and sort through various tables and stats) but then has a login form. When logged in, it would preset the same page but possibly with 2 or more additional buttons, something like "Add player" "Add a match" That would allow me to add a new player and new match to the lists.

How would i go the step further and have the site check the lists and tables for specific stats, and then update the new totals based on the information entered.

TLDR:

How do i create a site that has a page that people can look at, and a login form. Then when logged in, displays additional options?
How do i create a website that when logged in and using those additional options, checks data currently on the website, and does the needed mathematical calculations, and then updates the information (So it doesn't have to be done manually each time)


Thanks in advanced for the help.

P.S. i am not asking to be hand held on how to do this and be told line for line what i should put in the code. But if someone could just point me in the right direction, that would be great smile.gif
P.S.S. None of the stuff i am talking about or the site, needs to be super pretty right now. First things first, i want to get it functional, then later on i can make it pretty.


This is quite a large undertaking.

What programming languages are you familiar with?

How much experience do you have with programming for the web?

Probably, the first thing you should do is re-write the pages you want with an eye towards modularity. Then examine those pages and see where you can start automating the process of writing for particular modules. For instance, what data are you going to have to keep together (in one database table) and what other data is going to require separate tables. A good place to start is by making an xml description of the data.

BTW The prettier it is the easier it is to write. Planning to write it sloppy and then making it pretty is just adding the sloppy step. Make it pretty to begin with.

Maybe someone else knows of a stock program that can be adapted to this job.

Posted by: Darin McGrew Jul 25 2012, 11:58 PM

Perhaps one of these CGI or PHP game management programs will meet your needs:
http://cgi.resourceindex.com/Programs_and_Scripts/Perl/Games/Game_Management/
http://php.resourceindex.com/Complete_Scripts/Games/Game_Management/

Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)