Community Add-Ons

with example for product_listing.php and products_new.php

I get this in admin:

Specials - offer of the hour

Products Special Price Status Happy Hours Status Happy Hours Price Action
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1

select p.products_id, pd.products_name, p.products_price, hhs.specials_id, hhs.specials_new_products_price, hhs.specials_date_added, hhs.specials_last_modified, hhs.expires_date, hhs.happy_hours_beginning_date, hhs.happy_hours_end_date, hhs.happy_hours_beginning_time, hhs.happy_hours_end_time, hhs.specials_price_happy_hours, hhs.date_status_change, hhs.status, hhs.status_happy_hours, hhs.date_status_change_happy_hours from products p, happy_hours_specials_basic hhs, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = hhs.products_id order by pd.products_name limit -20, 20

[TEP STOP]

adapted for Separate Pricing Per Customer v4.1.1 2005/03/20

Feature: Seperate Beginning Happy Hour Date, End Date Happy Hour and Start Time Happy Hours, End Time Happy Hour


The offer of the hour - Das Angebot der Stunde

See here: http://www.cooleshops.de/happy_hours/

In the Admin under catalog - "specials" can specify daily for each hour the offers to each operator of a Shop. You can administer "specials" and "offer of the hour" at the same time.

Im Admin unter Katalog - "Sonderangebote" kann jeder Shopbetreiber täglich für jede Stunde die Angebote festlegen. Gleichzeitige Administration von "Sonderangeboten" und "Angebot der Stunde" .