diff options
| -rw-r--r-- | site/app/Http/Controllers/LookupController.php | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/site/app/Http/Controllers/LookupController.php b/site/app/Http/Controllers/LookupController.php index 5215704..3a876a9 100644 --- a/site/app/Http/Controllers/LookupController.php +++ b/site/app/Http/Controllers/LookupController.php @@ -16,11 +16,11 @@ class LookupController extends Controller { */ public function showPage(Request $request) { - - $query = "SELECT name, shop, spirit_type FROM all_view WHERE short_url = ? LIMIT 1)"; - - $data = DB::table('all_view')->select('name', 'shop', 'spirit_type')->where('url', "https://l.fuselkoenig.de/" . Input::get('short_url'))->limit(1)->get(); #$query, "https://l.fuselkoenig.de/" . Input::get('short_url')); - - return response()->json($data); + // Used by external linkshorter for better reporting in web analytics. + $query = "SELECT name, shop, spirit_type FROM all_view WHERE short_url = ? LIMIT 1)"; + + $data = DB::table('all_view')->select('name', 'shop', 'spirit_type')->where('url', "https://l.fuselkoenig.de/" . Input::get('short_url'))->limit(1)->get(); + + return response()->json($data); } } |