Restaurant review module
Hi, I am building a drupal site www.grancanariaguru.com. It is an information site for English speaking people in Gran Canaria and I would like a restaurant review section where:
1. There is a database of restaurants with food type, location, price etc. all with drop down menus
2. Users can search the database by field. I.e. show all fish restaurants in Las Palmas
3. Users can comment on restaurants already on the database, maybe even give star rating.
(and if possible) 4. Users can add new restaurants that get added after admin approval)
I have had a look through the modules available and can't see any that do this job (the book review module doesn't allow searching) . Does anyone know of any modules or combination of modules that could be used.
Any help would be hugely appreciated.
Thanks, Richard
I have tried writing it from scratch using PHP but it's not working very well. ( http://www.grancanariaguru.com/gran_canaria_restaurant_guide)

there is no one "restaurant
there is no one "restaurant review" module, but what you want can be easily created with drupal. Make a specific content type for restaurant including whatever cck fields you like (location, food, etc). You can use the fivestar module for ratings. You can use the modr8 module for moderating the addition of new restaurants. Enable comments on your restaurant content type for comments. You can use the views module to create listings of restaurants by different criteria (foods of a certain type, price range, rating, etc). You can also used views to place "exposed filters" on the pages which are the drop-downs that you mention.
Optionally, you may also want to look at the cck_facets and faceted_search modules.
===
"Give a man a fish and you feed him for a day.
Teach a man to fish and you feed him for a lifetime." -- Lao Tzu
"God helps those who help themselves." -- Benjamin Franklin
"Search is your best friend." -- Worldfallz
Thanks a lot, unfortunately
Thanks a lot, unfortunately I'm a bit of a Drupal newbie so I don't totally understand what you've written. If you've got time could you explain how I can start (Make a specific content type for restaurant including whatever cck fields you like (location, food, etc)). i.e. how do I make a specific content type? Thanks, Richard
Learning drupal is not a
Learning drupal is not a trivial task. You'll want to go through the docs... some I recommend are:
It's not likely a lot of what I say here will make much sense until you do that. But here's some more info.
Content types are page types-- you can format pages using fields for things like location, full name, anything you can think of really. The ability to create custom content types is built into drupal core (admin/content/types) but adding fields requires the http://drupal.org/project/cck module and some cck fields. Make a content type named "restaurant", add cck fields to it (you'll probably have to download some additional field types from the link i provided above) for the things you want people to enter (ie. location, food type, cost, link, rating, etc). Enable comments on the content type edit form. Most people use the fivestar module for ratings. You'll probably also want the pathauto and views modules in order to setup listings of retaurants like http://mysite.com/restaurants/new-york/italian etc.
In views you specify which fields you want to appear in your listings (like name, food type, cost, etc) and then "expose" those fields (in the views fieldset click the expose button) to make drop downs for filtering results available to users.
The facet modules I mention allow you to present nice groups of items based on the fields you define.
The best thing for you to do would be do a test install and try it out. Drupal really requires hands-on exposure to understand/learn it. if you have a shared hosting account drupal is easily installable via fantastico (though avoid automated installers at all costs for real sites). If not, grab one of the prepackaged lamp or wamp stacks to test drive it on a local machine.
===
"Give a man a fish and you feed him for a day.
Teach a man to fish and you feed him for a lifetime." -- Lao Tzu
"God helps those who help themselves." -- Benjamin Franklin
"Search is your best friend." -- Worldfallz
Thanks a lot
OK, I will begin the monster task of learning Drupal. Thanks a lot for your help, Richard