I would like to have a new database and site put togehter. If it would make it easier for you to modify our current code I have the source code for it and I can send it to you if we choose your bid. The unsent items link is for the admins to view orders that need to be sent out. I would like that taken out of the new site. I can explain the store portion of the site later in this message.
For the player area we would like:
A sign up area where players can go to this page to sign up for a player account to play in our weekly events at their favorite bar.
A log in area for players that are already signed up.
A link where players can register for upcoming tournaments.
A link for players to go through items in the store.
For the bar area we would like:
A log in area.
A link for bars to distribute points to players. This area must be searchable for bars to search for the player username or player id number.
A link to report an error if they have a problem.
A link to the signup page where bars can add players that haven't signed up via the web yet.
For the admin section we would need:
A log in area.
A way to add new bars with a username, password, business name, city, state, and zip.
A way to add points to those bars.
A way to add "special tournaments" for players to register in from their player account. Special tournaments happen 4 to 6 times a year where we allow players to "buy in" with the points they have accumulated. We would need a way to add those tournaments and it would be listed in the player section under upcoming tournamnets and they would be able to register if they have enough points.
A way to add players and change those player accounts when necessary. This also must be searchable by name and id number so we can search for players since we will have around 5,000 players when it's all said and done.
A way to add and remove items from a store. The pages for the store would have 8 products per page and create pages dynamically. This would not have to be searchable as we will only have 50 or so products. Players are only able to purchase these items with points so there is no need for SSL or any other certificates. When adding these items there would need to be a place for us to put an item id, description, price (in points), image url with the image always being justified to the left. If it is possible to create some sort of shopping cart where they can add multiple items into their cart and checkout when they have all of the items they want.
If you have any other questions please let me know.