[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4799: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4801: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4802: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4803: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
Tennessee Firearms Assoc. Inc. • View topic - Online restaurant database with Google Map
Page 1 of 1

Online restaurant database with Google Map

PostPosted: Thu Oct 07, 2010 5:57 pm
by wizardpc
After several months of coding, testing, and collaboration with other volunteers [most notably fl0at], we now have a searchable database that is user updatable.

http://www.tfaonline.org/restaurant

You may use that link on your desktop or your smartphone. We've tested with I believe every desktop browser as well as the default browsers for Android, iPhone, and Blackberry. Or, you can scan the QR Code below:
Image

The list comes from the state liquor board. IT ONLY CONTAINS PLACES WITH LIQUOR BY THE DRINK LICENSES. Restaurants with Beer-only permits may or may not be listed. If the restaurant is less than a year old, it may not be listed. If an address isn't correct, or a place that serves liquor isn't listed, note it here with as much information as possible and I'll add it.

Anyone may view the database, but to make changes you must register. A valid email address is required, and the same email may not be used more than once. Eventually, we'd like to integrate it with the forum's user database but being an all-volunteer force we haven't had the time to tackle that yet. When we do, membership to the forum will be required to update locations.

and are soliciting feedback.

Things we KNOW are quirky right now:
--In order to search on the main page, you must select a city first. Searching the entire state does not work.
--When logging in to make changes, you MUST select "Remember me." If you don't it'll just ask you to log in again.
--If you forget your password, you're out of luck. There isn't a reset function yet. Email me at wizardpc at wallsofthecity dot net if you forget your password and I'll nuke your account. You'll have to re-register.

Things we want to add, but haven't had the time yet:
--Automatic location tracking, with a search radius (for smartphones). That way, you just hit the link and it shows you all the liquor licensees within say 2 miles. Useful for marking restaurants you drive by, or picking a place to eat nearby.
--The ablilty for users to add locations. This will also be helpful for adding other businesses (CBL Malls, American Signature Furniture, Regions, etc)

Anything other than what I've listed here, fire away. If you decide to share this with other forums, I ask that you link to this post instead of the web page so they can see the explanations and caveats here.

Re: Online restaurant database with Google Map

PostPosted: Thu Oct 07, 2010 7:45 pm
by fl0at
Neat.

Although you can search the whole state, you just need to have the dropdown set to "Select a City" instead of "Entire State."

And, as soon as I shoot you a PM with the solution to this problem, it should be a fairly simple fix.

Awesome. Now if we can get JW to use it, Memphis will be almost taken care of...

Re: Online restaurant database with Google Map

PostPosted: Fri Oct 08, 2010 8:48 pm
by Butch Butler
This will be a Great Addition to The TFA website.I do have a question ,I just checked the map for Union City and it said 12 results found but only 9 ballons.Are some of the locations so close that they are covered by another ballon?
Will this be added to the TFA homepage or will you have to go through the forum?
Butch

Re: Online restaurant database with Google Map

PostPosted: Fri Oct 08, 2010 9:53 pm
by fl0at

Re: Online restaurant database with Google Map

PostPosted: Fri Oct 08, 2010 10:36 pm
by Butch Butler
Thanks,
Buckets and Los Portales are both in a strip mall.

Re: Online restaurant database with Google Map

PostPosted: Sat Oct 09, 2010 8:31 am
by David Lewis
Absolutely awsome work, guys! This is just great!!!

I'm making this an Announcement to keep it at the top of the subforum.

I already know of some places that I could update, so...

How does one register?

David

Re: Online restaurant database with Google Map

PostPosted: Sat Oct 09, 2010 10:17 am
by fl0at

Re: Online restaurant database with Google Map

PostPosted: Fri Oct 29, 2010 6:26 am
by wizardpc
Added QR Code.

Re: Problem joining

PostPosted: Wed Nov 03, 2010 9:56 am
by jwtownsend49
I had a problem. I wanted to enter some updates and tried to join. When I received the verification email, though, I clicked on the link but the verification did not occur. Now, I can't rejoin and I can't enter my updates.

Re: Online restaurant database with Google Map

PostPosted: Wed Nov 03, 2010 1:27 pm
by jwtownsend49
What difference does it make here if the signs conform or not? To me, if a sign says no firearms, no weapons, etc., I leave my gun outside and tell folks it's posted. I don't carry the Code with me, I don't have it memorized, AND I'm not up for challenging restaurant managers.

Re: Online restaurant database with Google Map

PostPosted: Wed Nov 03, 2010 3:44 pm
by David Lewis

Re: Online restaurant database with Google Map

PostPosted: Wed Nov 03, 2010 4:19 pm
by jwtownsend49
Thanks.

Some map updates

PostPosted: Fri Nov 12, 2010 11:22 am
by jwtownsend49
A couple of map updates: Cozymel's Coastal Grill and Jarrett's in Memphis have been closed a few months now.

Re: Online restaurant database with Google Map

PostPosted: Mon Jan 10, 2011 4:39 pm
by morg
How about a hot email key or notification system on changes.

I just saw that "wizardpc" labeled the downtown Nashville Joe's Crab Shack as not posted when if fact they have a non conforming sticker just inside the door. I would want pcwizard to know where I saw the sign and, therefore why I changed his/her setting.