Sonderpreise - xtcCheckSpecials() - Performance

[Volker Strähle]

die Funktion xtcCheckSpecials() in includes/classes/xtcPrice.php:

  function xtcCheckSpecial($pID) {
    if ($this->cStatus['customers_status_specials'] == '1') {
      $product_query = xtDBquery("SELECT specials_new_products_price
                                    FROM ".TABLE_SPECIALS."
                                   WHERE products_id = '".$pID."'
                                     AND status = 1
                                     AND (start_date IS NULL 
                                          OR start_date <= NOW())
                                  AND (expires_date >= NOW() OR expires_date IS NULL)");
      if (xtc_db_num_rows($product_query, true) > 0) {
....

und in der DB dazu passend:

ALTER TABLE `specials` ADD INDEX(`start_date`);
ALTER TABLE `specials` ADD INDEX(`expires_date`);

[Gerhard Waldemair]

In 11975:

fix #826

[Torsten Riemer]

In 11976:

Addition on r11975 (fix #826)

[Gerhard Waldemair]

In 12022:

revised r11975 (fix #826)