Java Chat Room with SQL 2000 database integration.

My site requires a Java Applet which allows users to interact with one another via a chat room with both public and private conversations. Users must login to a private section where only select members based on a specific SQL table are allowed in. Once logged into the chat room, the user must be uniquely identified and assigned certain rights. A specific user must have admin privileges which allow the admin to make selections, skip users, pause the draft, and set time limit for each round of the draft. The chat room users will be conducting a draft in which they must be assigned permission when it’s their turn to make a selection from the database. Therefore, some type of token or unique identifier must be passed to the active user who will then have permission to select an item. Users must be able to add selections to a queue from a designated SQL table, allowing them to automate their selection when their turn arrives or if they’re unable to attend the live draft. A time limit feature must also be instituted setting a specific limit in which each user must make the selection by. In the event that the user does not make their selection within the said period, the team is assigned the first available player from their queue or the highest rated item from the database. Once an item has been selected by a specific user, it must them register that product id in a specific table disallowing other users to select the same item. This applet/page must be robust in it ability to handle simultaneous users and multiple connections for different groups of people (i.e. group 1 has 12 users and group 2 has 25) all of which must be able to connect and use the said application without interruption. Lastly, this application must be able to connect to different database tables allowing different items to be searched and selected. Please take a look at the following links to get an idea of the layout and functionality: [login to view URL] [login to view URL] [login to view URL] Must Haves Java Chat Room with Public and Private Messaging Integration with multiple SQL 2000 tables Integration with existing ASP pages Admin Privileges Time Constraints Selection Queue Step-by-step deployment instructions from the Contractor ## Deliverables Ownership Upon completion and payment of this project all rights and ownership will be transferred to me and proper documentation must pass from the contractor. Support I would like the contractor to support the product for a period of time until all the bugs are worked out. This period will be determined by the functionality of the applet. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform Java, SQL 2000, ASP 3.0, Visual Basic, other technologies are also welcome but must provide the aforementioned functionality.