We are a company currently developing some new poker software and for this we need an affiliate and administration web-based interface. The game itself is not 100% complete yet, however most of the SQL database is. You will get the database schemas needed for developing the affiliate and admin and will in cooperation with us be able to define new tables and/or change existing to accommodate the system. All development is very much preferred to be done in JAVA 1.5 and HIBERNATE 1.2 ([url removed, login to view]) as our server system is running on pure JAVA with hibernate database management. In the case of the web interface we have currently been reviewing two different solutions to speed up the process. First choice is SUN's JSCreator ([url removed, login to view]) this could be implemented in pure JAVA or with JBoss. Our second choice is JBoss' JPortal or any other JAVA solution with template support and Hibernate. Optional this can be done in PHP if time and money factor is greatly reduced. ------------------------------------------------------------------------------------------ AFFILIATE WEBSITE Basically we define what we need as an affiliate site as that of [url removed, login to view] (pokerroom/network affiliate site). There may be a few additions/changes, but an affiliate site is pretty much the same no matter what. We also want a good looking design as this will be visited by many clients. ------------------------------------------------------------------------------------------ ADMINISTRATION WEBSITE This list of tasks is not limited to these examples. Minor additions might be necessary. Generate tax report: According to gaming law each month a tax statement must be generated to the authority. Manage Player Information: End user accounts can be created and existing accounts can be modified. Administrators are required to enter a reason or 'note' for any modifications that are made to end user accounts. This allows an administrator to view a complete snapshot of all changes on an end user's account including reasons for why each change was made, when the change was made and who made the change. Manage Financial Account: The management system provides services that allow the administrator to manage an end user's financial account by making account adjustments, deposits and/or withdrawals. A number of different reports exist to view account activity including game winnings, game losses, deposits and withdrawals. Each report allows the administrator to search specific time and date ranges. Hand Histories: The management system provides detailed hand histories of all games (real and play money). The hand histories show the community cards, all the cards that were dealt to each player and the complete order of action. Access History (Log): Administrators can view a complete access log that shows the date, time and duration of each end user session. A new end user session starts as soon as an end user opens the Game Client. The access log shows all games an end user played during a 'session' along with the amount won or lost. Query Manager: The query manager allows administrators to build custom queries that will retrieve a list of end users based on the criteria specified. Using the query manager, administrators can select the search criteria as well as the information they would like returned for each end user. This is very useful for sending targeted email campaigns using the Email Manager. Email Manager: The email manager allows administrators to create emails and have them sent to a selected group of end users at a set time. Using the query manager, the administrator first enters the search criteria to retrieve a list of end users to form the distribution list. Once the distribution list has been created, the administrator creates the body of the email and sets the schedule for delivery. Delivery schedules can be recurring (repeatedly sent at a set time) or non-recurring (sent once at the desired schedule). Player Communication: Using the management system, administrators can create system messages and graphic based messages that will be displayed to the end users in the game environ at the schedule set out by the administrator. For example, an administrator could create a new advertisement to advertise an upcoming tournament and schedule a pop-up message to be displayed when the client is launched or have the message displayed at a set time each day. Cashier/Financial Systems: The cashier allows users to withdrawal and deposit funds through the game client. All financial transactions are closely tracked and can be monitored using the administration system. Table Creation: The system allows administrators to create and start new tables for use in their game environment. The process has been expedited by allowing administrators to create table templates that define the betting structure for each table. Once a template is created, the administrators can create any number of tables at one time using our table creation wizard.. Auto Start/Stop of Table: To help manage when tables start and stop, the system will allow administrators to set tables to 'auto start'. Predicting exact user usage levels can be difficult, hence the importance of this very intuitive feature for attracting and maintaining a high number of users. The auto start/stop feature allows tables of the same game type and betting structure to be automatically started when the existing tables are nearly full or automatically stopped when a certain number of tables are no longer in use. Tournament creations: See table creations. Table Schedules: Tables and groups of tables can be set to start and stop at specific times and dates. For example, a set of tables can be set to start on Friday afternoon and stop on Sunday evening – thereby allowing them to run for a weekend promotion. Tournament schedules: See above. Prices and payout structure: Define different price structures, payouts and additional information regarding those events/prices.