- BTS#0000862: Fixed bug in SQL query on MySQL

[packages/lms.git] / lms-promotionlist.php.patch

diff --git a/lms-promotionlist.php.patch b/lms-promotionlist.php.patch
new file mode 100644 (file)
index 0000000..15ef977
--- /dev/null
+++ b/lms-promotionlist.php.patch
@@ -0,0 +1,19 @@
+--- modules/promotionlist.php  2011/03/02 10:31:05     1.1
++++ modules/promotionlist.php  2011/03/21 07:57:57     1.2
+@@ -21,14 +21,14 @@
+  *  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307,
+  *  USA.
+  *
+- *  $Id$
++ *  $Id$
+  */
+ 
+ $layout['pagetitle'] = trans('Promotions List');
+ 
+ $promolist = $DB->GetAll('SELECT p.id, p.name, p.description, disabled,
+                       (SELECT COUNT(*) FROM promotionschemas
+-                              WHERE p.id = promotionid) AS schemas,
++                              WHERE p.id = promotionid) AS scs,
+                       (SELECT COUNT(DISTINCT a.tariffid)
+                           FROM promotionassignments a
+                               JOIN promotionschemas s ON (s.id = a.promotionschemaid)