Air Compressor Bot
|
|
Home |
How it works |
Projects archive |
Contact Us Air Compressor Bot |
|
| The Career Path of Freelance Programming Jobs |
Simple database web application. |
 |
Bidding Time: |
26/06/2007 21:36 - 06/07/2007 00:00 |
Budget: |
$100-300 |
Status: |
Closed |
|
|
|
Job Type: |
|
Description: |
1. it contains four tables, business, hours, user, changes tables, all sql definition will be given as attached. 2. the web application must be written in php, use mysql as database, all web pages are tempalte driven. 3. the web page template contains a 728 x 90 graphic logo at the top, anything you can create. 4. use a clean, simple and modern Look and Feel templates. 5. user can log in using email and password. 6. user can retrieve password by email. (an php email script is also attached for reference.) 7. after log in, user can add a new business to his account. ( a php script does the db insert can be see as reference) 8. after log in, user can update the information of any business in his account. 9. after log in, user can deactive the status any business in his account to inactive. 10. after each of the 7-9 is exectuted, a row is inserted into the changes table with the following data. user id, time, action update, biz id, userip) what the application should not do. if a user is not logged in a session, he should not be allowed to any changes, in another word, the authentication is required before 4-6 can be executed, disallow hacking by methods such as enter the url with parameters. Before and after your bid, makes sure send me some reference of your previous work. 50% payment after it is finished and runs well on your test environment. 50% payment after it is installed and tested runs on my godaddy hosting. If you need to clearfy anything or have any question, pm me anytime. tables user with fields: userid(int), email(String), password (String), status(int, default 1), group(int, default 1), createdDate(time), lastLoginTime(Time), lastLoginIP(String) business with field, businessId(int, auto), names (String), userid(int, reference user table), address1(String), address2(String), city(String), state(String), postal code(String), phonenumber(10digit string), fax(10 digits string), comment(text). hours with field, businessId(int, reference business table), monday(String), tuesday(String), wednesday(String), thursday(String), friday(String), Saturaday(String), Sunday(String). potential values 11:00am-11:00pm, default closed. changes with fields: user id(int, reference user table), time (timestamp), action(String), businessID(int, reference business table), ip(String) Additional information submitted: 06/29/2007 at 11:28 EDT: 11. after log in, user can add up to 3 pictures to each of the business. each pictures needs to be smaller than 300K pictures with fields: id(int), businessID(int, /*the associated business reference business table*/), fileLocation(String, system file path), relativeURL(String, relativeURL) time (timestamp), add a preview page to show the business information. add a field max_business(int, default 10) to the user table, each user can add max of 10 business to its account. -1 means no limit. STOPzilla! Anti-Spyware Software
 Site Upgrade Website Design Improvement Ini Editor Drupal World Of Warcraft Itemdb CloneThis project is the proprietary information of .
Click here to remove this project from OUR database.
|
Operating System: |
Linux |
Database System: |
MySQL |
| <<< back |
|
| Home | Projects archive | RSS | Resources | Links | Contact Us | © 2004-2009 ProjectsList.biz /0.144 |