Changeset 4683

Timestamp:

11/13/07 00:36:48 (12 months ago)

Author:

inureyes

Message:

#236

• checkup 루틴 주석 추가
  
• 키워드 관련 쿼리 수정
  
• 링크 부분에서 캐시 추가
  
• setup에서 table 생성루틴 추가
  

Location:

trunk

Files:

• blog/checkup/index.php (modified) (1 diff)
• lib/model/blog.keyword.php (modified) (5 diffs)
• lib/model/blog.link.php (modified) (2 diffs)
• setup.php (modified) (1 diff)

trunk/blog/checkup/index.php

@@ -951 +951 @@
 }
 
-// Common parts.
+/***** Common parts. *****/
 if(doesHaveOwnership() && $blogids = DBQuery::queryColumn("SELECT blogid FROM {$database['prefix']}PageCacheLog")) {
     $changed = true;

trunk/lib/model/blog.keyword.php

@@ -8 +8 @@
     $name = tc_escape_string($name);
     $visibility = doesHaveOwnership() ? '' : 'AND visibility > 0';
-    if ($result = DBQuery::query("SELECT * FROM {$database['prefix']}Entries WHERE blogid = $blogid AND draft = 0 $visibility AND category = -1 AND title = '$name'"))
-        return mysql_fetch_array($result);
+    if ($result = DBQuery::queryAll("SELECT * FROM {$database['prefix']}Entries WHERE blogid = $blogid AND draft = 0 $visibility AND category = -1 AND title = '$name'"))
+        return $result;
     return false;   
 }
@@ -23 +23 @@
     $names = array();
     $visibility = doesHaveOwnership() ? '' : 'AND visibility > 0';
-    $result = DBQuery::query("SELECT title FROM {$database['prefix']}Entries WHERE blogid = $blogid AND draft = 0 $visibility AND category = -1 ORDER BY char_length(title) DESC");
-    while (list($name) = mysql_fetch_array($result))
-        array_push($names, $name);
+    $names = DBQuery::queryColumn("SELECT title FROM {$database['prefix']}Entries WHERE blogid = $blogid AND draft = 0 $visibility AND category = -1 ORDER BY char_length(title) DESC");
     return $names;
 }
@@ -32 +30 @@
     global $database;
     $visibility = doesHaveOwnership() ? '' : 'AND visibility > 0';
-    return DBQuery::queryAll("SELECT * FROM {$database['prefix']}Entries WHERE blogid = $blogid AND draft = 0 $visibility AND category = -1 ORDER BY title ASC");
+    return DBQuery::queryAll("SELECT * 
+        FROM {$database['prefix']}Entries 
+        WHERE blogid = $blogid 
+            AND draft = 0 $visibility 
+            AND category = -1 
+        ORDER BY title ASC");
 }
 
@@ -57 +60 @@
     $keyword = tc_escape_string($keyword);
     $visibility = doesHaveOwnership() ? '' : 'AND visibility > 1';
-    return DBQuery::queryAll("SELECT * 
+    return DBQuery::queryRow("SELECT * 
             FROM {$database['prefix']}Entries 
             WHERE blogid = $blogid 
@@ -63 +66 @@
                 AND category = -1 
                 AND title = '$keyword' 
-            ORDER BY published DESC LIMIT 1");
+            ORDER BY published DESC");
 }
 

trunk/lib/model/blog.link.php

@@ -4 +4 @@
 /// See the GNU General Public License for more details. (/doc/LICENSE, /doc/COPYRIGHT)
 
+global $__gCacheLink;
+$__gCacheLink = array();
+
 function getLinks($blogid) {
-    global $database;
-    $links = array();
-    if ($result = DBQuery::queryAll("SELECT * FROM {$database['prefix']}Links WHERE blogid = $blogid ORDER BY name")) {
-        foreach($result as $link)
-            array_push($links, $link);
+    global $database, $__gCacheLink;
+    if(empty($__gCacheLink)) {
+        if ($result = DBQuery::queryAll("SELECT * 
+            FROM {$database['prefix']}Links 
+            WHERE blogid = $blogid 
+            ORDER BY name")) {
+            $__gCacheLink = array();
+            foreach($result as $link) {
+                array_push($__gCacheLink, $link);
+            }
+        }
     }
-    return $links;
+    return $__gCacheLink;
 }
 
@@ -20 +29 @@
 
 function getLink($blogid, $id) {
-    global $database;
-    return DBQuery::queryRow("SELECT * FROM {$database['prefix']}Links WHERE blogid = $blogid AND id = $id");
+    global $database, $__gCacheLink;
+    return DBQuery::queryRow("SELECT * FROM {$database['prefix']}Links WHERE blogid = $blogid and id = $id");
 }
 

trunk/setup.php

@@ -1209 +1209 @@
   rss varchar(255) NOT NULL default '',
   written int(11) NOT NULL default '0',
+  visibility tinyint(4) NOT NULL default '2',
+  xfn varchar(128) NOT NULL default '',
   PRIMARY KEY  (id),
   UNIQUE KEY blogid (blogid,url)