Need a Joomla/MYSQL/Community Builder Pro
I need a Joomla/Community Builder expert that can implemenet a MYSQL database into my bar website: [url removed, login to view]
I have Community Builder installed in Joomla (1.5). I have an existing database of all the bars in the United States in an excell file. I need a search form created on the website where a person can search for a bar within xxx miles of their zip code. I also need the ability for the person to search by clicking a map of the United States. I created a demo image to show the basic search functions that I am looking for: [url removed, login to view]
I need the search results to display in 3 sections from top to bottom
1) Featured Bars
2) Verified Bars
3) Non-verified Bars
IE: Featured Bars display at the top of the search results. Verified Bars display below the featured bars and non-verified bars display below the verified bars.
I need the featured bar data to pull from a php page that I create manually. If there are no featured bars for the city area no data gets displayed. IE: If bar owners in Los Angeles pay to become a featured bar in their area I would enter their data manually into the los angeles featured bar php page. This featured page gets pulled via the database search if people search for bars in the los angeles area.
Verified bars are bar entries where the bar owner or manager has created an account and entered their bar information into our database manually through an online form. I need you to create this function also. This data needs to be approved by the admin before the entry gets entered into the actual database. The bar owner can also upload pictures of his bar that can be displayed on his bars profile page.
I would like the users (from the Community Builder logins) to have the ability to rate (from 1 to 5) the bar in question and leave a review for the particular bar. At the top of the bars review page I need the data to display the average rating for the bar. IE 4.5 stars, etc.
I also need the ability to use Advance Search Options:
I would like to have database entries with checkboxes were bar owners can enter information about their bar for:
We are primarily a:
Bowling Alley Bar
Wet T-Shirt Contests
These database entries should be part of the "advance search" function of the bar search page where the user can place checks in these boxes. IE: A user can place checks in the boxes to search for dance clubs and rave clubs within 10 miles of zipcode 12345, etc.
Payment via Paypal on completion
Please break down charges per section if possible.
Please send urls of websites with working custom databases that you have created.