Changeset 4568

Timestamp:

10/15/07 18:29:11 (2 years ago)

Author:

inureyes

Message:

#711

• 불필요한 쿼리 삭제
• 엔트리 모델의 참조 수정 준비

Location:

trunk/lib/model

Files:

• blog.entry.php (modified) (1 diff)
• blog.service.php (modified) (1 diff)

trunk/lib/model/blog.entry.php

@@ -770 +770 @@
     global $database;
     $blogid = getBlogId();
-    $entries = DBQuery::queryAll("SELECT id, visibility FROM {$database['prefix']}Entries WHERE blogid = $blogid AND draft = 0 AND visibility < 0 AND published < UNIX_TIMESTAMP()");
+    $entries = DBQuery::queryAll("SELECT id, visibility 
+            FROM {$database['prefix']}Entries 
+            WHERE blogid = $blogid AND draft = 0 AND visibility < 0 AND published < UNIX_TIMESTAMP()");
     if (count($entries) == 0)
         return;
     foreach ($entries as $i => $entry) {
-        $result = DBQuery::query("UPDATE {$database['prefix']}Entries SET visibility = 0 WHERE blogid = $blogid AND id = {$entry['id']} AND draft = 0");
+        $result = DBQuery::query("UPDATE {$database['prefix']}Entries 
+                SET visibility = 0 
+                WHERE blogid = $blogid AND id = {$entry['id']} AND draft = 0");
         if ($entry['visibility'] == -3) {
-            if ($result && (mysql_affected_rows() > 0) && setEntryVisibility($entry['id'], 2))
+            if ($result && setEntryVisibility($entry['id'], 2))
                 setEntryVisibility($entry['id'], 3);
         }
         else {
-            if ($result && (mysql_affected_rows() > 0))
+            if ($result)
                 setEntryVisibility($entry['id'], abs($entry['visibility']));
         }

trunk/lib/model/blog.service.php

@@ -10 +10 @@
     global $database;
     $query = new TableQuery($database['prefix'] . 'BlogSettings');
-    if($query->doesExist()) {
-        $query->setQualifier('name','name');
-        $query->setQualifier('value', $name, true);
-        return $query->getCell('blogid');
-    }
+    $query->setQualifier('name','name');
+    $query->setQualifier('value', $name, true);
+    return $query->getCell('blogid');
     return false;
 }