1. Create a form in PHP with a layout? resembling the above? form that will interact with the poker-network database on my server and allow users to? securely insert record? data into a table. To give an idea of what I am looking for, the above graphic is a screen shot of an existing poker sites create private tournament utility. It is actually a tabbed page so physically it is a single page. I show two graphics to show the other details of the form.
2. Install and setup the poker-network payment system from the svn repository. The payment system must interact with? all relevent ? poker-network databases and keep a secure record of all financial transactions.
## Deliverables
Work with me to create a form in PHP that will interact with the poker-network database on my server. This form will be used to allow players to create private tournaments by selecting tournament variables from drop down lists.? Once a player selects the appropriate variables for the type of tourney he is hosting and commits to creating the tournament, the form will first verify that a positive private currency balance sufficient to cover the cost of the tournament exists (see number 5 below) and if true will then insert a new record containing the selected variables into the poker-network tourneys_schedule table.?
This form should be designed to be able to function either within poker-web or placed on another server and therefore be able to access the poker-network database remotely.? The form will be accessible through a link which will entail a minor mod to the poker-web main page where the link will be placed.
The following rules must all be applied.
Create a debian installer package that will automatically install the PHP form to work with poker-web and poker-network and:
1. The name of the private tournament to be created must be the screen name of the player who created it and concatenated with other tourney ID info which is yet to be determined.
?
2. The form will be accessible only by players who have signed in to poker-web.
?
3. Tournaments can only be created by players that carry a positive private currency balance.
4. Tournaments may be created by players through the use of this form only. They must not be able to circumvent this and gain access to the database by using other software such as MySQL Query Browser.? ? The Administrator is not included in this rule.
5. If the player has a positive private table currency balance, the form will interact with the player’s private table currency account (serial 3) and will debit the players account based on the number of seats in the tournament.? For example, a player creates a sit and go tournament that has a total of 25 seats. The player has? 57 PTC’s (Private Tournament Chips) in his account .? Upon creating the tournament, the form will deduct 25 PTC’s from his Private Currency account, leaving him with 32 PTC’s.
6. The form must require that the player create a password for private tournament access having at least 8 characters including at least one? capital letter and at least one number.
7. Drop down lists
? ? ? ? [login to view URL] forms drop down list data must be editable so? that I can make changes to it.
? ? ? ? [login to view URL] data viewable by the players must be comprehensive (understandable) and where needed convert the data to be compatible for insertion into the? tourneys_schedule table.
8. The form will be a tabbed form and have two tabs who’s function is similar to the graphic below.? A Sit n Go tab that players will use to create a Sit n Go tournaments and a Scheduled tab that players will use to create scheduled tournaments.
9. In the case of scheduled tournaments; the form will use a standard U.S. time format and convert that time into unix time for use by the poker server.
?
10.? The form will also automatically compensate for any time zone differences relative to the poker server and poker client.
11. The form will not allow a tournament to be created sooner than 30 minutes of the current time.
12. Other tweaks and modifications will no doubt be involved.
[login to view URL] forms interface? should? resemble the graphics at the top of the page or in the attached zip file.
14. The form will show the players private table currency amount in a conspicuous area.
15. The form will inform the player when thier balance is less than what is required to create the tournament and suggest that they deposit more funds.
The Payment System.?
If? it is possible, create a debian install package that will interact with the person installing it by gathering the necassary PayPal information and then automatically set up the system so that it works.
The payment system must keep record of all transactions within the poker-network database and this information should be accessable by the database administrator.