Internal Coldfusion/PHP Forum ProjectShort 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 printingno clipboard use only on specific forum, where users can paste text into the forumno print-screenno saving of pictures or filesonly one browser window open at a timeauthentication by user certificate and userid/passwordno cached content on user computerno right click and no menu in browserThe 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-pagesDetails: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 ServerColdfusion server to manage the web-site (not to make any fancy design)User login and security:1.The 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.2.The 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.4.Each 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.5.Users only has access to web-pages by userID and/or GroupID. Each web-page can be restricted by GroupID and UserID.User interface:1.Main webpage with links to list of video clips and for a. This has been designed, and can be modified.2.Forum with text only. Users can add new entries and reply to existing entries.3.Forum 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.4.Forum 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.5.Only admin and the user who made the entry/reply can modify an entry/reply6.All 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.7.When 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:1.Add users with name, password and certificate serial number2.Select users in Groups3.Add a user to a group4.Deleting users5.Delete users from groups by user or by group6.Select 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 forum7.Add a new forum8.Add a link on main pages linking to static web-pageAdditional:1.Make templates for static web-page, which includes the necessary inclusions for the security featuresTesting:1.The programmer getting the project must make complete testing of the functions and submit the test result.2.Testing must be done with Java 1.4, 1.5 and 1.6 installed on client computers3.Testing will be done by independent tester in addition to programmerCompletion of project:1.The project will be considered complete when the project has been tested and passed according to the project.2.and all source codes has been deliveredLayout 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:1.Transfer of existing data from MS-SQL to mySQL2.Conversion of existing ASP pages to Coldfusion3.User can request a certificate online4.Admin can issue certificates after request5.User can download certificate and install in computer6.Simple web-browser to use in Windows and Mac.Internal Coldfusion/PHP Forum ProjectShort 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 printingno clipboard use only on specific forum, where users can paste text into the forumno print-screenno saving of pictures or filesonly one browser window open at a timeauthentication by user certificate and userid/passwordno cached content on user computerno right click and no menu in browserThe 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-pagesDetails: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 ServerColdfusion server to manage the web-site (not to make any fancy design)User login and security:1.The 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.2.The 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.4.Each 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.5.Users only has access to web-pages by userID and/or GroupID. Each web-page can be restricted by GroupID and UserID.User interface:1.Main webpage with links to list of video clips and for a. This has been designed, and can be modified.2.Forum with text only. Users can add new entries and reply to existing entries.3.Forum 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.4.Forum 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.5.Only admin and the user who made the entry/reply can modify an entry/reply6.All 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.7.When 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:1.Add users with name, password and certificate serial number2.Select users in Groups3.Add a user to a group4.Deleting users5.Delete users from groups by user or by group6.Select 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 forum7.Add a new forum8.Add a link on main pages linking to static web-pageAdditional:1.Make templates for static web-page, which includes the necessary inclusions for the security featuresTesting:1.The programmer getting the project must make complete testing of the functions and submit the test result.2.Testing must be done with Java 1.4, 1.5 and 1.6 installed on client computers3.Testing will be done by independent tester in addition to programmerCompletion of project:1.The project will be considered complete when the project has been tested and passed according to the project.2.and all source codes has been deliveredLayout 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:1.Transfer of existing data from MS-SQL to mySQL2.Conversion of existing ASP pages to Coldfusion3.User can request a certificate online4.Admin can issue certificates after request5.User can download certificate and install in computer6.Simple web-browser to use in Windows and Mac.
