Information about the current setup The present site has English in two places, in the jpg image files under www/images, and in the database in the Translation and FAQ tables. In order for the website to be translated, there needs to be the capability to choose image files and database text. VPS has the resources and responsibility to generate equivalent images in different languages, and enter the database text appropriate to the chosen language. The website however doesn’t have the capability to display this text correctly yet. At present text is loaded into the site from PHP calls to a MySQL database. Each row in the database has a unique descriptive name (LanguageID) which the appropriate PHP file calls depending on which page is being visited. This means that it is relatively easy for the website to be able to be translated, compared to the case where English text is embedded in lines of PHP code. Notes on the work • The project needs to run on all versions of firefox, IE 5-7. The website uses MySQL 4.1 for the database, and PHP 5. • Developers for the project must have a similar setup on their local machine as they will not be allowed access to VPSL’s website. • Developers should inspect the .php setup before making a bid. The site uses a Model View Controller system, but however does NOT use Cake PHP or PHP On Trax. The design is most similar to Ruby on Rails, but is not entirely like this either. • In doing the new work, developers will work within the existing framework as much as possible. Existing code will not be discarded if it is being used by the site. New code can be added that does not use the existing framework if necessary, however this must be commented to explain what it does and why this structure is chosen. Example setup instructions to get the site working locally • Install Wamp server, this installs PHP and apache • Copy the website files so that the files under www in the site go under wamp/www e.g. wamp/www/images • and “app??:, “config?? and “lib?? go under “wamp?? e.g. wamp/app • Under apache settings, enable mod_rewrite. This uses the .htaccess file supplied with the site. • You need to set up a local secure certificate to work with apache to test the shopping cart. There is info out there on how to do this, you don’t need to buy a secure certificate to test locally. • Change the database login to work with the local MySQL database. [url removed, login to view] has this info. Requirements 1. All the English text and images in the website can be replaced with text from another language. 2. There is a way for the user to change language when they arrive at the site. This may be a button, or tab but must fit in with the existing site. The language choice of the user must be stored for that session. (e.g. they don’t have to keep clicking on their chosen language each time they change page or click “refresh??) 3. This project includes getting Traditional Chinese to display correctly on the website, changes to things such as the database encoding will be needed for this. The font used is “PMingLiU?? a common Chinese font. An example of text that must display correctly on the site is:?? 不是免費的，但其他免費的有很多，它是把?? 4. The setup must be easily extended to other languages. Specifically the PHP/Database system must have the capability to display text in Spanish, Korean, and Japanese. This capability will be demonstrated by correctly displaying one sentence in each language in some part of the site. 5. There must be a simple and clear process for adding another language that VPS can follow without outside instruction. For example it might be something like: • Create a table called “Spanish Translation??. • Change the table to the correct encoding. • Enter the text into the database (VPS can already do this with the present system) • Save the image files in the folder www/images/Spanish • Add a few specified lines of PHP code in the sections that deal with the English and Chinese code • Add the Spanish flag or text to the website so users can see that another language is available.
The project needs to run on all versions of firefox, IE 5-7. The website uses MySQL 4.1 for the database, and PHP 5.