MySQL

Hi,
The Missing Slate is a quarterly art and literary journal publishing high quality pieces of both genres. Because of the extensive focus on the visual, we're looking to update our current look to something that caters toward that. The system is Wordpress and we have our own domain and subdomains. If the work's done well, there will be subdomains to update in the future as well (would rather work with one person throughout).
The WP theme will be provided to you which you will tweak and customize. We're looking for a gallery plugin to be installed as well and any other suggestions you have will be taken into consideration.
If there are questions or clarifications, please make that clear BEFORE bidding.
Good luck!
Requirements Interview Answers:

To help you bid more accurately, the employer was interviewed about the requirements for this project. Below are their answers.

Untitled Page

//<![CDATA[
var theForm = document.forms['form1'];
if (!theForm) {
theForm = document.form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>

Project Type:
What kind of work do you need done?Software related (Includes desktop applications and internet websites)
Project Parts:
What do you want the worker to do on this project?

Requirements:
The worker will analyze the problem and propose a software-based solution to the problem.
Programming:
The worker will take the requirements and translate them into the language of the computer (and test it).
User installation:
The installer will move the software from the place it was created (which is called the development or QC environment) to where you will use it (which is called the production environment). The installer then tests the software to make sure that the installation was done properly and completely.

Req. Doc. Type:
What kind of documentation do you want for this project?Formal documentation - After talking back and forth, the worker creates a formal document and/or prototype, as follows:Prototype: The analyst will create a non-working mockup of all pages/screens in the final software. Creating a prototype makes it easier for the user to visualize the final software, and reduces misunderstandings.
Program Type:
What kind of software should the worker create (and/or install)?An internet web-site: This software runs on a web server and users will access it using their internet browser.
Internet web-site info

Design and functionality:
What does the programming of this project involve?Design: Create the layout of the pages (or modify the layout of existing pages).Program Functionality: Making the website "work".
Modeling another site:
Do you wish to model another site? No
Size of website:
How many pages need to be created/edited in this website?Approximately 2.
Programming Language:
What programming language(s) do you want your website written in?I do know the language(s).Languages(s):PHPXML/XSL
Database:
Will this project include a database?Yes, it does include a database.Details:MySQL -- version(s): 5
Browser Type(s)/Version(s):
Which browser/version combinations must this website support?IE 8.0Firefox 3.6Safari 41Other. Details: Chrome
Server Hosting Environment:
What is your server hosting environment?I have a server at a 3rd party hosting company.The name of the hosting company is: iPageThe server's shared/dedicated status is: Shared with other people.Component Compatibility Protection:Sometimes a worker may create features on the website that rely on componentswhich work fine on their own server, but won't work with your 3rd party hosting company's server. There are many reasons for this including version incompatibility, restricted permissions, etc... vWorker.com normally requires that the worker verify in advance that your 3rd party hosting provider will support the components.  If they do not, then they are responsible for any incompatibilities, rather than you. Do you want this protection on your project?Yes, I require the worker to query my hosting company in advance, to ensure that they support all components which the worker uses in the final solution (including supporting the anticipated version #s, allowing components to run under their potentially restricted security model, etc.)
Server Hosting Environment:
Will the worker develop "live" on your server?Other / not sure/ or need advice. Details: There is a development subdomain created for this purpose. It'll be the safest thing to work on our own environment which will ensure all components, plugins etc confirm with our server. It'll also be easier to port from subdomain to main website.
Physical installation:
Who will perform the physical installation?The worker will perform the physical installation, and will be given all necessary permissions to do so.
Legal:
1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future).
2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables):
2b) Any website server-side deliverables must be installed in ready-to-run condition in the employer's environment (unless overridden otherwise by the employer elsewhere in this contract.
2c) If there are any server-side deliverables (intended to only exist in one place in the employer's environment) then they must be installed by the winning worker in ready-to-run condition (unless specified elsewhere by the employer).
2d) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the employer).
3) Employer will receive exclusive and complete copyrights to all work paid for. All paid for deliverables will be considered 'work made for hire' under U.S. Copyright law.
3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.

Design a Dating Site with all features the same as badoo.com.
We will use MySQL v5.1.52

Thank You
Requirements Interview Answers:

To help you bid more accurately, the employer was interviewed about the requirements for this project. Below are their answers.

Untitled Page

//<![CDATA[
var theForm = document.forms['form1'];
if (!theForm) {
theForm = document.form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>

Project Type:
What kind of work do you need done?Software related (Includes desktop applications and internet websites)
Project Parts:
What do you want the worker to do on this project?

Requirements:
The worker will analyze the problem and propose a software-based solution to the problem.
Programming:
The worker will take the requirements and translate them into the language of the computer (and test it).
User installation:
The installer will move the software from the place it was created (which is called the development or QC environment) to where you will use it (which is called the production environment). The installer then tests the software to make sure that the installation was done properly and completely.

Req. Doc. Type:
What kind of documentation do you want for this project?Formal documentation - After talking back and forth, the worker creates a formal document and/or prototype, as follows:Prototype: The analyst will create a non-working mockup of all pages/screens in the final software. Creating a prototype makes it easier for the user to visualize the final software, and reduces misunderstandings.Requirements Document: The analyst will create a document describing everything the final software will do (other than what is documented in the prototype...if the employer required one).
Program Type:
What kind of software should the worker create (and/or install)?An internet web-site: This software runs on a web server and users will access it using their internet browser.
Internet web-site info

Design and functionality:
What does the programming of this project involve?Design: Create the layout of the pages (or modify the layout of existing pages).Program Functionality: Making the website "work".
Modeling another site:
Do you wish to model another site? Yes: www.badoo.com
Please note that the looks of this project must NOT look like badoo.com but the features should be the same.

Size of website:
How many pages need to be created/edited in this website?I don't know. Other info:Please create an account on Badoo.com, you will see all the features my project should include. 
Programming Language:
What programming language(s) do you want your website written in?I don't know what language (and need the worker's assistance to suggest it).Other info:Just check badoo.com and let me know what language they use.
Database:
Will this project include a database?Yes, it does include a database.Details:MySQL -- version(s): 5.1.52
Browser Type(s)/Version(s):
Which browser/version combinations must this website support?IE 8.0IE 7.0Firefox 3.6Safari 41Other. Details: Opera and Crome
Server Hosting Environment:
What is your server hosting environment?I have a server at a 3rd party hosting company.The name of the hosting company is: Host GatorThe server's shared/dedicated status is: Shared with other people.Component Compatibility Protection:Sometimes a worker may create features on the website that rely on componentswhich work fine on their own server, but won't work with your 3rd party hosting company's server. There are many reasons for this including version incompatibility, restricted permissions, etc... vWorker.com normally requires that the worker verify in advance that your 3rd party hosting provider will support the components.  If they do not, then they are responsible for any incompatibilities, rather than you. Do you want this protection on your project?Yes, I require the worker to query my hosting company in advance, to ensure that they support all components which the worker uses in the final solution (including supporting the anticipated version #s, allowing components to run under their potentially restricted security model, etc.)
Server Hosting Environment:
Will the worker develop "live" on your server?Other / not sure/ or need advice. Details: The worker will have access to my server when needed. My server has NO Traffic at this time. 
Physical installation:
Who will perform the physical installation?The worker will perform the physical installation, and will be given all necessary permissions to do so.
Legal:
1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future).
2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables):
2b) Any website server-side deliverables must be installed by the worker in ready-to-run condition in the employer's environment.
2c) Any website server-side deliverables must be provided with complete instructions and assistance so that the employer may install them in ready-to-run condition in the employer's environment.
2d) Any website server-side deliverables must be installed as described elsewhere by the employer.
2e) If there are any server-side deliverables (intended to only exist in one place in the employer's environment) then they must be installed by the worker in ready-to-run condition (unless specified elsewhere by the employer).
2f) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the employer).
3) All deliverables will be considered 'work made for hire' under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased.
3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.

We are looking to put the newsletter email service back on our own server.
We have been looking at the commercial offerings eg
Mailchimp
Aweber
Constant Contact
They are starting to have feature bloat or not offer what we want.
We have designers in-house and have no need for lots of pre-done designs.
We are looking for a clean easy to use system that doesList management
Load email list - csv format
Use column headings as Merge Tags, for both subject line and body copy
Graphs of opens, bounces etc
Track the campaign's performance
Who opened your messages (who didn't)
Which links were clicked (and by whom)
How many people unsubscribed
Csv output of bounces, unsubscribes to allow management of main databaseCampain Management
Campaign Archives
Autoresponders to create and schedule automated messages
Use new or existing list
Template controlled by paste in code or previous template code (automatically generate text ver from html)
Preview of email newsletter in browser and send test email to manual email address
Control of email fields:- subject line, from field, reply email field etc
Check outgoing emails for bad email format, duplicates, suppress bad and duplicates and report in statsCampaign Archives
Structure to manage lists, templates, and email campaigns, basic search by name, date etc
Software to be web based control panel with basic security, password login
Will be run on standard LAMP linux hosting, the email delivery will need to be controlled so as not to degrade server bandwidth, either automatic monitoring, or campaign delivered in 500 email batches every 5min in the background.
Requirements Interview Answers:

To help you bid more accurately, the employer was interviewed about the requirements for this project. Below are their answers.

Untitled Page

//<![CDATA[
var theForm = document.forms['form1'];
if (!theForm) {
theForm = document.form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>

Project Type:
What kind of work do you need done?Software related (Includes desktop applications and internet websites)
Project Parts:
What do you want the worker to do on this project?

Requirements:
The worker will analyze the problem and propose a software-based solution to the problem.
Programming:
The worker will take the requirements and translate them into the language of the computer (and test it).
User installation:
The installer will move the software from the place it was created (which is called the development or QC environment) to where you will use it (which is called the production environment). The installer then tests the software to make sure that the installation was done properly and completely.

Req. Doc. Type:
What kind of documentation do you want for this project?Formal documentation - After talking back and forth, the worker creates a formal document and/or prototype, as follows:Requirements Document: The analyst will create a document describing everything the final software will do (other than what is documented in the prototype...if the employer required one).
Program Type:
What kind of software should the worker create (and/or install)?An internet web-site: This software runs on a web server and users will access it using their internet browser.
Internet web-site info

Design and functionality:
What does the programming of this project involve?Design: Create the layout of the pages (or modify the layout of existing pages).Program Functionality: Making the website "work".
Modeling another site:
Do you wish to model another site? Yes: http://mailchimp.com/
http://www.aweber.com/
http://www.constantcontact.com/index.jsp
We want a simple to use version of these, without all the social media bells and whistles, or split testing etc
Core functions:-
List management
Template management
Email sending, instant and schedule (our larger lists are 3000+ so limiting the send rate in the background to not strain the server resources is required)
preview and send of test email
Delivery stats, graphical and csv export to enable main database update, and further action of results, eg list cleaning of bounces, further campaigns for opens etc
Size of website:
How many pages need to be created/edited in this website?I don't know. Other info:Basic password protection of site
As it is for internal company use a tab for each function
Include basic html editor for the template area eg tinyMCE.
We do the design for our templates in full editors so paste in code is all that is required
Programming Language:
What programming language(s) do you want your website written in?I don't know what language (and need the worker's assistance to suggest it).Other info:I have usually seen this as a php / mySQL combo with pear packages
However if you have another preference that runs on standard linux hosting
We will probably take a hostmonster / hostgater package as these are std configurations and you know what you are dealing with.
Database:
Will this project include a database?Yes, it does include a database.Details:MySQL -- version(s): version 5+
Browser Type(s)/Version(s):
Which browser/version combinations must this website support?IE 8.0Firefox 3.6Other. Details: chrome, there shouldn't be anything in something this basic that causes browser problems
Server Hosting Environment:
What is your server hosting environment?I don't know and need the worker to suggest a 3rd party hosting company server.Details:I am thinking of a basic hosting package on Hostmonster / Hostgater
unless you have experience with an inexpensive host you want to recommend.
Server Hosting Environment:
Will the worker develop "live" on your server?No. The worker is responsible for creating their own development and/or qc environment.
Physical installation:
Who will perform the physical installation?The worker will perform the physical installation, and will be given all necessary permissions to do so.
Legal:
1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future).
2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables):
2b) Any website server-side deliverables must be installed in ready-to-run condition in the employer's environment (unless overridden otherwise by the employer elsewhere in this contract.
2c) If there are any server-side deliverables (intended to only exist in one place in the employer's environment) then they must be installed by the winning worker in ready-to-run condition (unless specified elsewhere by the employer).
2d) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the employer).
3) Employer will receive exclusive and complete copyrights to all work paid for. All paid for deliverables will be considered 'work made for hire' under U.S. Copyright law.
3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.

BACKGROUND INFORMATIONI recently had three Facebook social apps / plugins added to my website: Facebook Login, Facepile and Friendfinder. Unfortunately, the coder didn't provide me with access to the Facebook Developer Account, so I can’t make any changes. Also, from what I've been told the site is now at risk because anyone with access could just delete the apps via the Facebook account and the apps would stop working on my site. PROJECT REQUIREMENTSThere are two parts to this project: 1) I need a need a talented PHP coder with plenty of experience integrating Facebook social apps that understands the problem and can provide a solution. It was suggested that in order to fix this I just need to make a new Facebook Developer Account and change the APP ID in the site code to the one for the new account. Since I’m unfamiliar with the inner workings of the apps I have no idea if this would fix the problem and need a second opinion.2) Once a solution has been found I need the coder to go ahead and make the changes. ADDITIONAL INFORMATIONThe website is coded in PHP and uses a MySQL database. The Facebook login and Facepile apps / plugins have been modified slightly so that they work better with the site features. Due to the modifications made I want the code to remain unchanged (with the exception of the ID).
Worker: On pay-for-deliverable
projects, all deliverables must be
uploaded to
vWorker.com before the
deadline(s)Â…with no exceptions. If
this contract makes it impossible
to do this (for example if it is
for a service that cannot be
uploaded), then do not start
this project. Otherwise, you
may find
yourself unprotected by the
payment guarantee.
Instead, ask the employer
to switch this project to
pay-for-time, so you are
guaranteed payment. If the
employer will not switch this, then
please alert us.
(Click here for more details...)

Example of unprotected/un-guaranteed work:
Imagine that this project is to
install something on the employers
website.
You do the work but upload nothing
to vWorker.com (because it takes too
long,
or you cannot). As long as there is
no dispute, you will not notice the
potential problem. But if the
employer disputes what you did then
we must make sure you delivered to the
triple-point-guarantee (100% to-contract: and
done in the industry exepcted manner, and
by the deadline). If the employer
does not allow us access to their
website, or accidentally/deliberately
changes the work you did on their
website, when we go to test it, we
will see that it does not work.
Then you would have no proof that
you delivered the final deliverables,
lose the arbitration, the escrowed
funds and receive a poor rating
(which will say “testing showed
the final deliverables did not
work”).
So for this reason,
you should have instead followed
the above instructions and
switched it to pay-for-time.
Had you done this, we would simply
have checked the Accutimcard to
make sure you punched-in the time
and were working on it. You would
have been paid for every hour
you worked.

Remember that contacting the other party outside of the site (by email, phone, etc.) on all outsourcing pay-for-deliverables projects violation of both the employer and worker agreements.
vWorker.com monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.

Categories:

The categories were created by the employer, but sometimes mistakes occur.
If any of these categories are incorrect, please
report it and let us know.

Like everything else on this page, these categories are part of the original contract
for this project.

Web development, Database, Languages, Operating systems / platforms, PHP, Other (Technology), Web services, MySQL, Other (Web development), Javascript, Emergency!, Emergency production fix/patch, Other (Emergency), Other (operating system/platform), Technology, Web programming, Other (web programming), Software Development, Scripts and utilities, Tech details
Legal:
1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future). 2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables): 2b) Any website server-side deliverables must be installed in ready-to-run condition in the employer's environment (unless overridden otherwise by the employer elsewhere in this contract. 2c) If there are any server-side deliverables (intended to only exist in one place in the employer's environment) then they must be installed by the winning worker in ready-to-run condition (unless specified elsewhere by the employer). 2d) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the employer). 3) Employer will receive exclusive and complete copyrights to all work paid for. All paid for deliverables will be considered 'work made for hire' under U.S. Copyright law. 3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.

I am looking for someone who can create a login page that will "loginshare" with WHMCS. Someone who has WHMCS experience is preferred.
In other words, a client signs up with our services through WHMCS. After that, the client can login with his WHMCS username/password on our custom website.
This job is for the creation of the login share system. You will need to create a login page. After you login, there will only need to be a logout option. When a user logs out, the session will need to end. If a user visits the site again he will need to log back in. There does not need to be any design. Only a simple white login page, a white page after login, and a logout option after being logged in.
Please do not bid the maximum hours/price or your bid will be ignored.Remember that contacting the other party outside of the site (by email, phone, etc.) on all outsourcing pay-for-deliverables projects violation of both the employer and worker agreements.
vWorker.com monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.

Categories:

The categories were created by the employer, but sometimes mistakes occur.
If any of these categories are incorrect, please
report it and let us know.

Like everything else on this page, these categories are part of the original contract
for this project.

Web development, User interface (UI) programming, Database, Languages, PHP, Web services, MySQL, Technology, Web programming, Other (web programming), Software Development, Scripts and utilities, Other (Software development), Tech details
Legal:
1) Deliverables include not just the final work but also complete source files as well (so that the employer can modify them in the future).
2) Quality: (Applies to outsourcing projects only) If you present a sample of your past work to the employer, your final deliverables MUST match or exceed that same level of quality.
3) Employer will receive exclusive and complete copyrights to all work paid for. All paid for deliverables will be considered 'work made for hire' under U.S. Copyright law.
3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.

Hi,
Need a serverside programmer.
We need following server programming/work in php & mysql for an iPhone App --
push notification on server side, rss feed (events, alerts) on server side (I suppose this is ready but with no pagination - twitter like "load more"), place/local synchronization with server, options synchronization with server
these are the integration flows
--
Need to start right, should be an easy job.
Budget around $20-50 max! lesser the better!
Regards,
PB.
Worker: On pay-for-deliverable
projects, all deliverables must be
uploaded to
vWorker.com before the
deadline(s)Â…with no exceptions. If
this contract makes it impossible
to do this (for example if it is
for a service that cannot be
uploaded), then do not start
this project. Otherwise, you
may find
yourself unprotected by the
payment guarantee.
Instead, ask the employer
to switch this project to
pay-for-time, so you are
guaranteed payment. If the
employer will not switch this, then
please alert us.
(Click here for more details...)

Example of unprotected/un-guaranteed work:
Imagine that this project is to
install something on the employers
website.
You do the work but upload nothing
to vWorker.com (because it takes too
long,
or you cannot). As long as there is
no dispute, you will not notice the
potential problem. But if the
employer disputes what you did then
we must make sure you delivered to the
triple-point-guarantee (100% to-contract: and
done in the industry exepcted manner, and
by the deadline). If the employer
does not allow us access to their
website, or accidentally/deliberately
changes the work you did on their
website, when we go to test it, we
will see that it does not work.
Then you would have no proof that
you delivered the final deliverables,
lose the arbitration, the escrowed
funds and receive a poor rating
(which will say “testing showed
the final deliverables did not
work”).
So for this reason,
you should have instead followed
the above instructions and
switched it to pay-for-time.
Had you done this, we would simply
have checked the Accutimcard to
make sure you punched-in the time
and were working on it. You would
have been paid for every hour
you worked.

Remember that contacting the other party outside of the site (by email, phone, etc.) on all outsourcing pay-for-deliverables projects violation of both the employer and worker agreements.
vWorker.com monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.

Categories:

The categories were created by the employer, but sometimes mistakes occur.
If any of these categories are incorrect, please
report it and let us know.

Like everything else on this page, these categories are part of the original contract
for this project.

Web development, Database, Languages, PHP, Web services, MySQL, Technology, Web programming, Tech details
Legal:
1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future).
2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables):
2b) Any website server-side deliverables must be installed in ready-to-run condition in the employer's environment (unless overridden otherwise by the employer elsewhere in this contract.
2c) If there are any server-side deliverables (intended to only exist in one place in the employer's environment) then they must be installed by the winning worker in ready-to-run condition (unless specified elsewhere by the employer).
2d) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the employer).
3) Employer will receive exclusive and complete copyrights to all work paid for. All paid for deliverables will be considered 'work made for hire' under U.S. Copyright law.
3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.

I need tool that retrieves XML data and extracts specific information within that data and saves it in a MYSQL database.
Requirements Interview Answers:

To help you bid more accurately, the employer was interviewed about the requirements for this project. Below are their answers.

Untitled Page

//<![CDATA[
var theForm = document.forms['form1'];
if (!theForm) {
theForm = document.form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>

Project Type:
What kind of work do you need done?Software related (Includes desktop applications and internet websites)
Project Parts:
What do you want the worker to do on this project?

Requirements:
The worker will analyze the problem and propose a software-based solution to the problem.
Programming:
The worker will take the requirements and translate them into the language of the computer (and test it).
User installation:
The installer will move the software from the place it was created (which is called the development or QC environment) to where you will use it (which is called the production environment). The installer then tests the software to make sure that the installation was done properly and completely.

Req. Doc. Type:
What kind of documentation do you want for this project?Informal documentation - As the employer talks back and forth about the project with the worker, those conversations become the requirements.Remember to communicate ALL of the details of your project on the vWorker.com site. If you don't, and there is a dispute, then important details of the contract will not be documented and cannot be taken into account in arbitration. If you feel you MUST go offsite (for example, using the phone or IM) then afterwards post everything onsite and get the other party to post that they agree to those contractual terms.
Program Type:
What kind of software should the worker create (and/or install)?An internet web-site: This software runs on a web server and users will access it using their internet browser.
Internet web-site info

Design and functionality:
What does the programming of this project involve?Design: Create the layout of the pages (or modify the layout of existing pages).Program Functionality: Making the website "work".
Modeling another site:
Do you wish to model another site? No
Size of website:
How many pages need to be created/edited in this website?Approximately 3.
Programming Language:
What programming language(s) do you want your website written in?I do know the language(s).Languages(s):PerlPHP
Database:
Will this project include a database?Yes, it does include a database.Details:MySQL -- version(s): 5
Browser Type(s)/Version(s):
Which browser/version combinations must this website support?IE 8.0IE 7.0IE 6.0Firefox 3.6Firefox 3.0Safari 41
Server Hosting Environment:
What is your server hosting environment?I have my own in-house server.
Server Hosting Environment:
Will the worker develop "live" on your server?No. The worker is responsible for creating their own development and/or qc environment.
Physical installation:
Who will perform the physical installation?I will perform the physical installation. The worker is only responsible for providing instructions and assistance regarding what I must do. I understand and agree that if the worker provides adequate instructions, but I am unable to follow them, then this is a valid reason for them to miss the final deadline without penalty (in arbitration).
Legal:
1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future). 2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables): 2b) Any website server-side deliverables must be installed in ready-to-run condition in the employer's environment (unless overridden otherwise by the employer elsewhere in this contract. 2c) If there are any server-side deliverables (intended to only exist in one place in the employer's environment) then they must be installed by the winning worker in ready-to-run condition (unless specified elsewhere by the employer). 2d) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the employer). 3) Employer will receive exclusive and complete copyrights to all work paid for. All paid for deliverables will be considered 'work made for hire' under U.S. Copyright law. 3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.

WARNING: this is for an adult website.
I have attached the current project (very simple, 1 file php).
It downloads an xml file, and updates or inserts all models into a table 'sexier'
and all images into 'sexier_images'
The XML file can be called with man queryIDs:
http://example.com/getxml.asp?queryid=1
...
http://example.com/getxml.asp?queryid=140
Queries are for different categories...
For example:
queryid 1 =amature
queryid 2 = lesbian
The same user can be listed in multiple queryids (categories).
So, I would like to add a new table:
sexier_categories
In that table, I would like to keep a list of all categories each model is in.
No select statements are allowed... All inserts should be done with: INSERT ... ON DUPLICATE KEY UPDATE: http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
Worker: On pay-for-deliverable
projects, all deliverables must be
uploaded to
vWorker.com before the
deadline(s)Â…with no exceptions. If
this contract makes it impossible
to do this (for example if it is
for a service that cannot be
uploaded), then do not start
this project. Otherwise, you
may find
yourself unprotected by the
payment guarantee.
Instead, ask the employer
to switch this project to
pay-for-time, so you are
guaranteed payment. If the
employer will not switch this, then
please alert us.
(Click here for more details...)

Example of unprotected/un-guaranteed work:
Imagine that this project is to
install something on the employers
website.
You do the work but upload nothing
to vWorker.com (because it takes too
long,
or you cannot). As long as there is
no dispute, you will not notice the
potential problem. But if the
employer disputes what you did then
we must make sure you delivered to the
triple-point-guarantee (100% to-contract: and
done in the industry exepcted manner, and
by the deadline). If the employer
does not allow us access to their
website, or accidentally/deliberately
changes the work you did on their
website, when we go to test it, we
will see that it does not work.
Then you would have no proof that
you delivered the final deliverables,
lose the arbitration, the escrowed
funds and receive a poor rating
(which will say “testing showed
the final deliverables did not
work”).
So for this reason,
you should have instead followed
the above instructions and
switched it to pay-for-time.
Had you done this, we would simply
have checked the Accutimcard to
make sure you punched-in the time
and were working on it. You would
have been paid for every hour
you worked.

Remember that contacting the other party outside of the site (by email, phone, etc.) on all outsourcing pay-for-deliverables projects violation of both the employer and worker agreements.
vWorker.com monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.

Categories:

The categories were created by the employer, but sometimes mistakes occur.
If any of these categories are incorrect, please
report it and let us know.

Like everything else on this page, these categories are part of the original contract
for this project.

Web development, Database, Languages, PHP, XML/XSL, MySQL, Other (Web development), Technology, Web programming, Other (web programming), Tech details

Additional Files:

This project includes IMPORTANT additional attached files. Please download and read fully before bidding.
3 kb

Legal:
1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future).
2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables):
2b) Any website server-side deliverables must be installed in ready-to-run condition in the employer's environment (unless overridden otherwise by the employer elsewhere in this contract.
2c) If there are any server-side deliverables (intended to only exist in one place in the employer's environment) then they must be installed by the winning worker in ready-to-run condition (unless specified elsewhere by the employer).
2d) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the employer).
3) Employer will receive exclusive and complete copyrights to all work paid for. All paid for deliverables will be considered 'work made for hire' under U.S. Copyright law.
3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.