Changeset 1121 for trunk/admin/rating.php

Timestamp:

Apr 5, 2006, 12:29:35 AM (18 years ago)

Author:

plg

Message:

feature deleted: code for categories link was too complicated for such a
simple fature. Replaced by static association. Links are not persistent
anymore.

modification removed: #image_category.is_storage replaced by
#images.storage_category_id as in branche 1.5..

File:

• trunk/admin/rating.php (modified) (1 diff)

trunk/admin/rating.php

@@ -183 +183 @@
        i.tn_ext,
        i.average_rate,
+       i.storage_category_id,
        MAX(r.date)          AS recently_rated,
        COUNT(r.rate)        AS nb_rates,
        SUM(r.rate)          AS sum_rates,
-       ROUND(STD(r.rate),2) AS std_rates,
-       ic.category_id       AS storage_category_id
+       ROUND(STD(r.rate),2) AS std_rates
   FROM '.RATE_TABLE.' AS r
     LEFT JOIN '.IMAGES_TABLE.' AS i ON r.element_id = i.id
-    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON ic.image_id = i.id
   WHERE 1 = 1 ' . $display_filter . '
-    AND ic.is_storage = \'true\'
   GROUP BY r.element_id
   ORDER BY ' . $available_order_by[$order_by_index][1] .'