311589 Private Forum Project

Internal Coldfusion/PHP Forum Project Short description: The project will be used on an internal web-site in a company. There will be no access from outside, only from Intranet. There is currently two separate web-servers – one old web server for forum and discussions (Based on WinNT, MS-SQL and ASP) – another new web server for video clips using Quicktime (based on Mac Server OS X 10.5). The project is to move the old server for forum and discussions to the new server, so make a unified web-site for the users. The design is simple, no flashy design on the web-pages. Due to the sensitive nature of the discussions (budgets, plans, sales tactics), there are several limitations for the users: no printing no clipboard use – only on specific forum, where users can paste text into the forum no print-screen no saving of pictures or files only one browser window open at a time authentication by user certificate and userid/password no cached content on user computer no right click and no menu in browser The web-pages on the new server is partially made in Dreamweaver, and then optimized by hand. The project is meant be made completely in Dreamweaver, to enable the administrators to make minor changes and make static web-pages Details: Platform: Apple OS X Server 10.5, Apache ver. 1.3 as installed by OS X Server (can be upgraded), mySQL Server as installed by OS X Server Coldfusion server to manage the web-site (not to make any fancy design) User login and security: [login to view URL] user must have a certificate issued by the server. If the user has more than one certificate, the user must select which certificate to use. [login to view URL] user has unique userID and password, which has to match entries in the user table. The certificate Serial number is also in the user table and must match as well. 3.A user can belong to one or more GroupID. [login to view URL] user session must have an sessionID. If the sessionID does not match on each web-page, the user is logged out and the session closed. [login to view URL] only has access to web-pages by userID and/or GroupID. Each web-page can be restricted by GroupID and UserID. User interface: [login to view URL] webpage with links to list of video clips and for a. This has been designed, and can be modified. [login to view URL] with text only. Users can add new entries and reply to existing entries. [login to view URL] with text and pictures. Users can add new entries and reply to existing entries. Pictures can be uploaded to en entry and a reply. Subtext to each picture can be entered. The pictures will be uploaded in various formats and sizes. The web-site must convert the pictures to jpg., the same size and optimize the filesize. [login to view URL] with text and pdf-files. Users can add new entries and reply to existing entries. PDF-files can be uploaded to en entry and a reply. The PDF files must be converted to pictures – one picture for each PDF-page. When the user select a PDF file, he will be presented with the pictures, one page at a time. [login to view URL] admin and the user who made the entry/reply can modify an entry/reply [login to view URL] forums must be listed with 10 to 25 entries per page. The number of entries can be set by the admin globally, and for each forum as override for the global setting. [login to view URL] a forum has more than the specified number of entries, there should be links to go to First, previous nn, next nn and last page of the forum. Administration functions – these pages must on be accessible by users in the admin group: [login to view URL] users with name, password and certificate serial number [login to view URL] users in Groups [login to view URL] a user to a group [login to view URL] users [login to view URL] users from groups – by user or by group [login to view URL] groups/users to each web-page. If a forum has restrictions, all the entries and replies in that forum must inherit the access from the main forum [login to view URL] a new forum [login to view URL] a link on main pages linking to static web-page Additional: [login to view URL] templates for static web-page, which includes the necessary inclusions for the security features Testing: [login to view URL] programmer getting the project must make complete testing of the functions and submit the test result. [login to view URL] must be done with Java 1.4, 1.5 and 1.6 installed on client computers [login to view URL] will be done by independent tester in addition to programmer Completion of project: [login to view URL] project will be considered complete when the project has been tested and passed according to the project. [login to view URL] all source codes has been delivered Layout for the web-pages will be provided to the programmer. Detailed information about the existing web-pages will also be provided. Database and table structures will be provided, and developed with the programmer. Next step for future projects – not included in this project: Upon successful completion of the project, these additional works should be done: [login to view URL] of existing data from MS-SQL to mySQL [login to view URL] of existing ASP pages to Coldfusion [login to view URL] can request a certificate online [login to view URL] can issue certificates after request [login to view URL] can download certificate and install in computer [login to view URL] web-browser to use in Windows and Mac.