lms-promotionlist.php.patch

   1 --- modules/promotionlist.php   2011/03/02 10:31:05     1.1
   2 +++ modules/promotionlist.php   2011/03/21 07:57:57     1.2
   3 @@ -21,14 +21,14 @@
   4   *  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307,
   5   *  USA.
   6   *
   7 - *  $Id$
   8 + *  $Id$
   9   */
  10
  11  $layout['pagetitle'] = trans('Promotions List');
  12
  13  $promolist = $DB->GetAll('SELECT p.id, p.name, p.description, disabled,
  14                         (SELECT COUNT(*) FROM promotionschemas
  15 -                               WHERE p.id = promotionid) AS schemas,
  16 +                               WHERE p.id = promotionid) AS scs,
  17                         (SELECT COUNT(DISTINCT a.tariffid)
  18                             FROM promotionassignments a
  19                                 JOIN promotionschemas s ON (s.id = a.promotionschemaid)