Changeset 3701

Timestamp:

07/18/07 21:42:48 (3 years ago)

Author:

coolengineer

Message:

• #454
• 랜덤태그를 queryColumn을 사용하여 구할 수 있도록 수정

Files:

• trunk/lib/model/blog.tag.php (modified) (11 diffs)

trunk/lib/model/blog.tag.php

@@ -40 +40 @@
     if ($skinSetting['tagboxAlign'] == 1) { // order by count
         if (doesHaveOwnership())
-            $result = DBQuery::query("SELECT `name`, count(*) `cnt` FROM `{$database['prefix']}Tags` t, 
+            $tags = DBQuery::queryColumn("SELECT `name`, count(*) `cnt` FROM `{$database['prefix']}Tags` t, 
                 `{$database['prefix']}TagRelations` r 
                 WHERE t.id = r.tag and r.blogid = $blogid 
@@ -46 +46 @@
                 ORDER BY cnt DESC $aux");
         else
-            $result = DBQuery::query("SELECT `name`, count(*) `cnt` FROM `{$database['prefix']}Tags` t, 
+            $tags = DBQuery::queryColumn("SELECT `name`, count(*) `cnt` FROM `{$database['prefix']}Tags` t, 
                 `{$database['prefix']}TagRelations` r, 
                 `{$database['prefix']}Entries` e 
@@ -54 +54 @@
     } else if ($skinSetting['tagboxAlign'] == 2) {  // order by name
         if (doesHaveOwnership())
-            $result = DBQuery::query("SELECT DISTINCT name FROM `{$database['prefix']}Tags` t, 
+            $tags = DBQuery::queryColumn("SELECT DISTINCT name FROM `{$database['prefix']}Tags` t, 
                 `{$database['prefix']}TagRelations` r 
                 WHERE t.id = r.tag AND r.blogid = $blogid 
@@ -60 +60 @@
                 ORDER BY t.name $aux");
         else
-            $result = DBQuery::query("SELECT DISTINCT name FROM `{$database['prefix']}Tags` t, 
+            $tags = DBQuery::queryColumn("SELECT DISTINCT name FROM `{$database['prefix']}Tags` t, 
                 `{$database['prefix']}TagRelations` r,
                 `{$database['prefix']}Entries` e 
@@ -68 +68 @@
     } else { // random
         if (doesHaveOwnership())
-            $result = DBQuery::query("SELECT `name` FROM `{$database['prefix']}Tags` t,
+            $tags = DBQuery::queryColumn("SELECT `name` FROM `{$database['prefix']}Tags` t,
                 `{$database['prefix']}TagRelations` r
                 WHERE t.id = r.tag AND r.blogid = $blogid
                 GROUP BY r.tag ORDER BY RAND() $aux");
         else
-            $result = DBQuery::query("SELECT `name` FROM `{$database['prefix']}Tags` t,
+            $tags = DBQuery::queryColumn("SELECT `name` FROM `{$database['prefix']}Tags` t,
                 `{$database['prefix']}TagRelations` r,
                 `{$database['prefix']}Entries` e
@@ -79 +79 @@
                 GROUP BY r.tag 
                 ORDER BY RAND() $aux");
-    }
-    if ($result) {
-        while (list($tag) = mysql_fetch_row($result))
-            array_push($tags, $tag);
     }
     return $tags;
@@ -117 +113 @@
     $max = $min = 0;
     if (doesHaveOwnership())
-        $result = DBQuery::query("SELECT count(r.entry) `cnt` FROM `{$database['prefix']}TagRelations` r 
+        $max = DBQuery::queryCell("SELECT count(r.entry) `cnt` FROM `{$database['prefix']}TagRelations` r 
             WHERE r.blogid = $blogid 
             GROUP BY r.tag 
@@ -123 +119 @@
             DESC LIMIT 1");
     else
-        $result = DBQuery::query("SELECT count(r.entry) `cnt` FROM `{$database['prefix']}TagRelations` r,
+        $max = DBQuery::queryCell("SELECT count(r.entry) `cnt` FROM `{$database['prefix']}TagRelations` r,
             `{$database['prefix']}Entries` e 
             WHERE r.entry = e.id AND e.visibility > 0 AND r.blogid = $blogid 
@@ -129 +125 @@
             ORDER BY `cnt` 
             DESC LIMIT 1");
-    if ($result) {
-        if (list($count) = mysql_fetch_array($result))
-            $max = $count;
-    }
-    if (doesHaveOwnership())
-        $result = DBQuery::query("SELECT count(r.entry) `cnt` FROM `{$database['prefix']}TagRelations` r 
+    if (doesHaveOwnership())
+        $min = DBQuery::query("SELECT count(r.entry) `cnt` FROM `{$database['prefix']}TagRelations` r 
             WHERE r.blogid = $blogid 
             GROUP BY r.tag 
@@ -140 +132 @@
             LIMIT 1");
     else
-        $result = DBQuery::query("SELECT count(r.entry) `cnt` FROM `{$database['prefix']}TagRelations` r, 
+        $min = DBQuery::query("SELECT count(r.entry) `cnt` FROM `{$database['prefix']}TagRelations` r, 
             `{$database['prefix']}Entries` e 
             WHERE r.entry = e.id AND e.visibility > 0 AND r.blogid = $blogid 
@@ -146 +138 @@
             ORDER BY `cnt` 
             LIMIT 1");
-    if ($result) {
-        if (list($count) = mysql_fetch_array($result))
-            $min = $count;
-    }
+    $max = $max == null ? 0 : $max;
+    $min = $min == null ? 0 : $min;
     return array($max, $min);
 }