Changeset 5665

Timestamp:

03/28/08 10:25:19 (10 months ago)

Author:

jparker

Message:

#877

• iPhone / iPod Touch 접근 URL 변경. (http://example.com/i)로 접근.
  
  • 관련 : http://forum.tattersite.com/ko/viewtopic.php?pid=25787
    
• Tag 관련 함수명 변경, 추후 인기도, 이름순, 임의로 선택할 수 있게하기 위함.
  

Location:

trunk

Files:

• interface/i (moved) (moved from trunk/interface/iphone)
• interface/i/index.php (modified) (1 diff)
• lib/suri.php (modified) (1 diff)
• lib/view/iphoneView.php (modified) (1 diff)
• style/iphone/iphone.css (modified) (1 diff)

trunk/interface/i/index.php

@@ -68 +68 @@
             <ul class="tag_list">
                 <?php
-                    $tags = printIphoneRandomTags($blogid, 100);
-                    print printIphoneRandomTagsView($tags); 
+                    $tags = printIphoneTags($blogid, 'random', 100);
+                    print printIphoneTagsView($tags);   
                 ?>  
             </ul>

trunk/lib/suri.php

@@ -146 +146 @@
     $blogURL .= '/m';
 }else if (defined('__TEXTCUBE_IPHONE__')) {
-    $blogURL .= '/iphone';
+    $blogURL .= '/i';
 }
 unset($url, $domain);

trunk/lib/view/iphoneView.php

@@ -135 +135 @@
 }
 
-function printIphoneRandomTags($blogid, $max = 10) {
+function printIphoneTags($blogid, $flag = 'random', $max = 10) {
     global $database, $skinSetting;
     $tags = array();
-    $aux = "limit {$max}";
-    if (doesHaveOwnership()){
-        $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, t.id FROM `{$database['prefix']}Tags` t,
-            `{$database['prefix']}TagRelations` r,
-            `{$database['prefix']}Entries` e
-            WHERE r.entry = e.id AND e.visibility > 0 AND t.id = r.tag AND r.blogid = $blogid 
-            GROUP BY r.tag 
-            ORDER BY RAND() $aux");
+    $aux = "limit $max";
+    if ($flag == 'count') { // order by count
+            $tags = POD::queryAll("SELECT `name`, count(*) `cnt`, t.id FROM `{$database['prefix']}Tags` t,
+                `{$database['prefix']}TagRelations` r, 
+                `{$database['prefix']}Entries` e 
+                WHERE r.entry = e.id AND e.visibility > 0 AND t.id = r.tag AND r.blogid = $blogid 
+                GROUP BY r.tag 
+                ORDER BY `cnt` DESC $aux");
+    } else if ($flag == 'name') {  // order by name
+            $tags = POD::queryAll("SELECT DISTINCT name, count(*) cnt, t.id FROM `{$database['prefix']}Tags` t, 
+                `{$database['prefix']}TagRelations` r,
+                `{$database['prefix']}Entries` e 
+                WHERE r.entry = e.id AND e.visibility > 0 AND t.id = r.tag AND r.blogid = $blogid 
+                GROUP BY r.tag 
+                ORDER BY t.name $aux");
+    } else { // random
+            $tags = POD::queryAll("SELECT name, count(*) cnt, t.id FROM `{$database['prefix']}Tags` t,
+                `{$database['prefix']}TagRelations` r,
+                `{$database['prefix']}Entries` e
+                WHERE r.entry = e.id AND e.visibility > 0 AND t.id = r.tag AND r.blogid = $blogid 
+                GROUP BY r.tag 
+                ORDER BY RAND() $aux");
     }
     return $tags;
 }
-function printIphoneRandomTagsView($tags) {
+
+function printIphoneTagsView($tags) {
     global $blogURL, $service;
     ob_start();

trunk/style/iphone/iphone.css

@@ -613 +613 @@
     text-align:justify;
     list-style:none;
-    position: relative;
 }
 body > ul > li.panel > .content > ul.tag_list > li{
     display:inline;
     list-style:none;
-    line-height:2.5em
+    line-height:1.4em;
     margin:0;
     padding:0 5px;