diff options
| author | horus | 2018-06-18 15:54:46 +0200 |
|---|---|---|
| committer | horus | 2018-06-18 15:54:46 +0200 |
| commit | 88a2628258eb5ea79736338637ab8b5b83680c92 (patch) | |
| tree | 358f42ea14d417f8c5018a3f64f002d6414cd9ac /site/app/Http/Controllers/IndexController.php | |
| parent | ae873c6dbd8ee11e0d8beb88d76c8bf4258286b6 (diff) | |
| download | alkobote-88a2628258eb5ea79736338637ab8b5b83680c92.tar.gz | |
Fix card-overlay problem with links. (website)
Diffstat (limited to 'site/app/Http/Controllers/IndexController.php')
| -rw-r--r-- | site/app/Http/Controllers/IndexController.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/site/app/Http/Controllers/IndexController.php b/site/app/Http/Controllers/IndexController.php index 9023ac2..09ff3a2 100644 --- a/site/app/Http/Controllers/IndexController.php +++ b/site/app/Http/Controllers/IndexController.php @@ -25,7 +25,7 @@ class IndexController extends Controller { # subquery to get procent, because cheap spirits don't look good $query .= "(SELECT name, image_url, spirit_type, spirit_type AS url, spirit_type AS angebotsname, (SELECT MAX(procent) FROM " . $view . "_view) as procent, '' AS linktext FROM ". $view ."_view WHERE original_price > 19.98 ORDER BY procent DESC LIMIT 1)"; } - $query .= " UNION (SELECT 'Alle Angebote' as name, '/img/paw-400-400.png' as image_url, 'RSS-Feeds' as spirit_type, 'feeds' AS url, 'RSS-Feeds' AS angebotsname, (SELECT MAX(procent) FROM all_view) as procent, 'Zu den RSS-Feeds' AS linktext FROM all_view LIMIT 1)"; + $query .= " UNION (SELECT 'Alle Angebote' as name, '/img/feed-icon-gray.jpg' as image_url, 'RSS-Feeds' as spirit_type, 'feeds' AS url, 'RSS-Feeds' AS angebotsname, (SELECT MAX(procent) FROM all_view) as procent, 'Zu den RSS-Feeds' AS linktext FROM all_view LIMIT 1)"; $data = DB::select($query); |