1. My Smarty template website needs to be changed so that it gets longitude and latitude values from two newly added MySql tables (CitiesUSA and CitiesForeign). NOTE: ??The program MAY already contain full or partial code for obtaining non-USA longitude/latitudes from the CitiesForeign table (while also doing the alphabetical/digital conversion)?? If so, you may only need to modify that code to make it do the same thing for CitiesUSA table. (see [url removed, login to view] and [url removed, login to view]). 2. Convert the longitude/latitude fields in the CitiesUSA and CitiesForeign tables from alphabetical to digital. (see Zips USA Foreign [url removed, login to view]) 3. Delete all Zip Code drop downs blocks from the Sign-up...Edit Profile...and Profile Search pages. (see Input [url removed, login to view]) and ensure ALL location drop downs on these 3 pages function properly. 4. IMPORTANT: You must comment ALL code changes and supply me with a copy of all modified php, tpl, and sql files at the end of the contract. This contract MAY also require modifying these 4 tables: Cities, Counties, Countries, and Zips (see Cities Counties Countries [url removed, login to view]). CitiesUSA and CitiesForeign sql files are 10-13 Megs each...so you may have to do the work in my environment due to extremely long transfer times?
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Linux, Firefox 2.0+