What's up - I currently run (excuse the ugliness!) http://www.MLBFreeAgents.net - I built the system of feeds from the ground up with a mix of manually editing the mysql databases and a makeshift proprietary shell that can do the updating of feeds manually.
It keeps track of signings, trades and other baseball moves.
I want to move it over the wordpress - or another CMS - and am wondering if I can port this over. Here's some of the functionality that I have created -
1. Multiple RSS feeds (trades, rumors, signings, etc.).
2. A list of players available sorted by position.
2a. The ability, when a player retires - or - signs with a team, to mark that player as signed - and his assigned team.
2b. List the signings accordingly. See this page for an example - http://mlbfreeagents.net/positions.php?pos=1
The starting pitchers available are listed on the top - then the players who have signed are listed under "Starting Pitchers Signed Thus Far" - and players that have retired are listed under "Starting Pitchers Retired Thus Far"
Currently I have 2 boolean fields (IsSigned and IsRetired) - the first query (available players) looks for players that have IsSigned and IsRetired set to false, the second query looks for IsSigned=True and the third looks for IsRetired=True and lists it accordingly.
Basically that's all that I am looking to be able to do - and would love to migrate over the wordpress. Let me know if you have trouble understanding what I am trying to accomplish!
Thanks so much.