Changeset 273

Timestamp:

09/24/10 17:01:15 (20 months ago)

Author:

fuze

Message:

При вступлении в клуб выполнялся сомнительный и "весомый" запрос, в следствие чего возникали "тормоза".
Переписал запрос - рейтинг клуба равен сумме всех рейтингов юзеров клуба.

Location:

branches/fuze/core

Files:

• lib_clubs.php (modified) (1 diff)
• lib_karma.php (modified) (1 diff)

branches/fuze/core/lib_clubs.php

@@ -24 +24 @@
 function setClubRating($club_id){
     $inDB = cmsDatabase::getInstance();
-        $sql = "SELECT SUM( r.points ) AS rating
-                        FROM cms_user_clubs u, cms_clubs c, cms_ratings r
-                        LEFT JOIN cms_photo_files f ON r.item_id = f.id AND r.target = 'photo'
-                        LEFT JOIN cms_blog_posts p ON r.item_id = p.id AND r.target = 'blogpost'
-                        WHERE u.club_id = $club_id AND (f.user_id = u.user_id OR p.user_id = u.user_id)";
+        $sql = "SELECT SUM( u.rating ) AS rating
+                        FROM cms_user_clubs c
+                        LEFT JOIN cms_users u ON u.id = c.user_id
+                        WHERE c.club_id = '$club_id'";
         $rs = $inDB->query($sql);
         if (@$inDB->num_rows($rs)){

branches/fuze/core/lib_karma.php

@@ -20 +20 @@
     if (!is_int($club_id)){ return; }
 
-    $sql = "SELECT SUM( r.points ) AS rating
-            FROM cms_user_clubs u, cms_clubs c, cms_ratings r
-            LEFT JOIN cms_photo_files f ON r.item_id = f.id AND r.target = 'photo'
-            LEFT JOIN cms_blog_posts p ON r.item_id = p.id AND r.target = 'blogpost'
-            WHERE u.club_id = '$club_id' AND (f.user_id = u.user_id OR p.user_id = u.user_id)";
+    $sql = "SELECT SUM( u.rating ) AS rating
+                        FROM cms_user_clubs c
+                        LEFT JOIN cms_users u ON u.id = c.user_id
+                        WHERE c.club_id = '$club_id'";
     
     $rs = $inDB->query($sql);