I have a straight forward php script that I need modified. Currently if you visit www.p o t s p a c [url removed, login to view] and click BROWSE you will see some members, however the zip code feature isn't working properly. If someone selects the United States and enters a zipcode and distance to search by, the members will not be filtered.
I would like for the code to be written in this type of way:
If user enters zip code and distance for search, first a calculation is performed to show which other zipcodes are within that distance of the zipcode entered.
Next the other search options will only see the profiles which are in the zipcodes that were previously determined to be within the specified distance.
There is no reason to perform multiple queries on all 39000 members if we already know most won't be displayed because they aren't within distance.
Also I would prefer to have either the zipcode with distance active, while the STATE dropdown is disabled, or vice versa. I'd prefer not to confuse ourselves by allowing the user to select both a state and also a zipcode/distance. I do want both features to stay, but I would like it so that if a user has started using one, the other is greyed out. If both aren't being used, than perhaps they will both not be grey?
An example would be if I enter my zip code as 06010 then the script should first calculate which zipcodes in the zipcode database are within the specified distance. If I specified 5 miles, there will obviously be fewer zipcodes in that range than if I had chosen 20 miles.
Now the script will only use these results when performing the other queries.
---------------Step 2 of this project---------------
I've made some changes to the code myself so that when my users upload photos, they can check a box if the photo is XRATED. This puts a 1 in a database field for that photo.
I would like a search option (checkbox) put on the browse form so users can search for ONLY PROFILES WITH XRATED PICS. In order to use this option, the user must be paying, so if they try to check the box it should pop open a small window that says that you must be a paying member, and have our paypal link to become a paying member. At this point the box should uncheck, etc. because they can't use this feature if they're not paying. FYI the member paying status is in the database as well. :) I'm not the best programmer in the world, but I imagine the way to do this would be to first do a DISTINCT query to see which user accounts have photos which are marked XRATED. Then the rest of the queries will be based off of those results (only users with xrated photos).
Finally, I would like something created so that when a user has a photo as xrated and it is a primary photo, they will get a RED NOTE on the edit photos page that warns them that their account is in jeopardy of being removed if they continue to have an XRATED photo as their primary.
If you want me to pick your bid, please show some past relevant experience with extensive php forms use and or zip code calculators, etc.