Changeset 5568

Timestamp:

03/08/08 23:04:03 (10 months ago)

Author:

inureyes

Message:

#869

• 태그가 출력되지 않는 버그 패치
  

Files:

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

trunk/lib/model/blog.tag.php

@@ -42 +42 @@
     if ($skinSetting['tagboxAlign'] == 1) { // order by count
         if (doesHaveOwnership())
-            $tags = POD::queryAll("SELECT `name`, count(*) `cnt`, `id` FROM `{$database['prefix']}Tags` t 
+            $tags = POD::queryAll("SELECT `name`, count(*) `cnt`, id FROM `{$database['prefix']}Tags` t 
                 INNER JOIN `{$database['prefix']}TagRelations` r ON r.blogid = $blogid AND r.tag = t.id
                 GROUP BY r.tag 
                 ORDER BY cnt DESC $aux");
         else
-            $tags = POD::queryAll("SELECT `name`, count(*) `cnt`, `id` FROM `{$database['prefix']}Tags` t,
+            $tags = POD::queryAll("SELECT `name`, count(*) `cnt`, t.id FROM `{$database['prefix']}Tags` t,
                 `{$database['prefix']}TagRelations` r, 
                 `{$database['prefix']}Entries` e 
@@ -55 +55 @@
     } else if ($skinSetting['tagboxAlign'] == 2) {  // order by name
         if (doesHaveOwnership())
-            $tags = POD::queryAll("SELECT DISTINCT name, count(*) 'cnt', `id` FROM `{$database['prefix']}Tags` t, 
+            $tags = POD::queryAll("SELECT DISTINCT name, count(*) cnt, t.id FROM `{$database['prefix']}Tags` t, 
                 `{$database['prefix']}TagRelations` r 
                 WHERE t.id = r.tag AND r.blogid = $blogid 
@@ -61 +61 @@
                 ORDER BY t.name $aux");
         else
-            $tags = POD::queryAll("SELECT DISTINCT name, count(*) `cnt`, `id` FROM `{$database['prefix']}Tags` t, 
+            $tags = POD::queryAll("SELECT DISTINCT name, count(*) cnt, t.id FROM `{$database['prefix']}Tags` t, 
                 `{$database['prefix']}TagRelations` r,
                 `{$database['prefix']}Entries` e 
@@ -69 +69 @@
     } else { // random
         if (doesHaveOwnership())
-            $tags = POD::queryAll("SELECT `name`, count(*) `cnt`, `id` FROM `{$database['prefix']}Tags` t,
+            $tags = POD::queryAll("SELECT name, count(*) cnt, t.id 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
-            $tags = POD::queryAll("SELECT `name`, count(*) `cnt`, `id` FROM `{$database['prefix']}Tags` t,
+            $tags = POD::queryAll("SELECT name, count(*) cnt, t.id FROM `{$database['prefix']}Tags` t,
                 `{$database['prefix']}TagRelations` r,
                 `{$database['prefix']}Entries` e
@@ -87 +87 @@
     global $database;
     if (doesHaveOwnership())
-        $names = POD::queryAll("SELECT `id`,`name` FROM `{$database['prefix']}Tags` t, 
+        $names = POD::queryAll("SELECT t.id,name FROM `{$database['prefix']}Tags` t, 
             `{$database['prefix']}TagRelations` r 
             WHERE t.id = r.tag AND r.blogid = $blogid 
@@ -94 +94 @@
             LIMIT 2000");
     else
-        $names = POD::queryAll("SELECT `id`,`name` FROM `{$database['prefix']}Tags` t, 
+        $names = POD::queryAll("SELECT t.id,name FROM `{$database['prefix']}Tags` t, 
             `{$database['prefix']}TagRelations` r,
             `{$database['prefix']}Entries` e