Tweet
Ok,
Looks like we are on our own in this endeavor as repeated emails to IHOF Commish have gone unanswered -- heard the guy was pretty busy and I now believe it.
So I've stood up a dev server on my local network:
IIS_5
MySQL
PHP
http://www.phuchaphly.com/fof/imperi...tent/index.php
(make sure you refresh your cache - Jeff alerted me to a hideous NON CSS version this morning)
is the first visual rendering of the new site but I think I can make it even sexier with a 'team' of imperial troops
The backend of the website is going to be database driven and although I have an intermediate level of database design, I really need a guy who can analyze and suggest HOW we set the DB up.
The data that goes into that database has to be extracted from the HTML dumps that FOF produces
I have an HTML Parser that I think will work for us but I've yet to figure it out:
http://htmlparser.sourceforge.net/
I figure we should extract:
Teams
Players (FOF and TCY?)
Schedules
Results
Transactions
Injuries
Green Page
Standings
Stongest Man
Fastest Man
Statistics
Awards
I think these areas should cover all the things I've heard you guys want:
Dynamically Produced Player Cards
Dynamically Team Pages (separate from our external sites)
Schedules & Results right on front page
hell anything we want to do I guess
If we have some coders who would like to give extraction a shot; take the parser out for spin OR find a better one (IHOF has a custom parser) and see if you can extract the data.
I'm thinking the output format should be delimited in some way so that I can import it into the MySQL or an Access database so we can do the other part: PHP coding
I'm an ASP, VBScript novice but I'm convinced that PHP is the way we should go with our site BUT if we have good ASP coders around, I'm all for staying in that language. I have no idea if the Apache Web Server we run on can support it.
I'm more excited about the visual look of our site than the important stuff so I'm actually going to continue designing this weekend.
Any takers for conceptualizing the database? Any PHP or other coder guys here?
Looks like we are on our own in this endeavor as repeated emails to IHOF Commish have gone unanswered -- heard the guy was pretty busy and I now believe it.
So I've stood up a dev server on my local network:
IIS_5
MySQL
PHP
http://www.phuchaphly.com/fof/imperi...tent/index.php
(make sure you refresh your cache - Jeff alerted me to a hideous NON CSS version this morning)
is the first visual rendering of the new site but I think I can make it even sexier with a 'team' of imperial troops
The backend of the website is going to be database driven and although I have an intermediate level of database design, I really need a guy who can analyze and suggest HOW we set the DB up.
The data that goes into that database has to be extracted from the HTML dumps that FOF produces
I have an HTML Parser that I think will work for us but I've yet to figure it out:
http://htmlparser.sourceforge.net/
I figure we should extract:
Teams
Players (FOF and TCY?)
Schedules
Results
Transactions
Injuries
Green Page
Standings
Stongest Man
Fastest Man
Statistics
Awards
I think these areas should cover all the things I've heard you guys want:
Dynamically Produced Player Cards
Dynamically Team Pages (separate from our external sites)
Schedules & Results right on front page
hell anything we want to do I guess
If we have some coders who would like to give extraction a shot; take the parser out for spin OR find a better one (IHOF has a custom parser) and see if you can extract the data.
I'm thinking the output format should be delimited in some way so that I can import it into the MySQL or an Access database so we can do the other part: PHP coding
I'm an ASP, VBScript novice but I'm convinced that PHP is the way we should go with our site BUT if we have good ASP coders around, I'm all for staying in that language. I have no idea if the Apache Web Server we run on can support it.
I'm more excited about the visual look of our site than the important stuff so I'm actually going to continue designing this weekend.
Any takers for conceptualizing the database? Any PHP or other coder guys here?
Comment