Changeset 4782

Timestamp:

12/16/07 00:48:14 (3 years ago)

Author:

inureyes

Message:

#708

• [4759] 관련 수정 (2)

Files:

• trunk/lib/model/blog.statistics.php (modified) (2 diffs)

trunk/lib/model/blog.statistics.php

@@ -10 +10 @@
     if (!empty($result)) $stats['total'] = $result;
     
-    $result = DBQuery::queryColumn("SELECT date, visits FROM {$database['prefix']}DailyStatistics WHERE blogid = $blogid AND `date` in ('" . Timestamp::getDate()."','".Timestamp::getDate(time()-86400)."') ORDER BY date DESC");
-    var_dump($result);
-    $stats['today'] = (isset($result[0]) && $result[0]['date'] == Timestamp::getDate()) ? $result[0] : 0;
-    $stats['yesterday'] = (isset($result[1]) && $result[1]['date'] == Timestamp::getDate(time()-86400)) ? $result[1] : 0;
+    $result = DBQuery::queryColumn("SELECT date, visits FROM {$database['prefix']}DailyStatistics WHERE blogid = $blogid AND `date` in ('" . Timestamp::getDate()."','".Timestamp::getDate(time()-86400)."')");
+    $stat['today'] = $stat['yesterday'] = 0;
+    foreach($result as $data) {
+        if($data['date'] == Timestamp::getDate()) $stats['today'] = $data['date'];
+        if($data['date'] == Timestamp::getDate(time()-86400)) $stats['yesterday'] = $data['date'];
+    }
 
     return $stats;
@@ -71 +73 @@
         return;
     if (DBQuery::queryCount("INSERT INTO {$database['prefix']}SessionVisits values('$id', '{$_SERVER['REMOTE_ADDR']}', $blogid)") > 0) {
-        if(!DBQuery::execute("UPDATE {$database['prefix']}BlogStatistics SET visits = visits + 1 WHERE blogid = $blogid")) {
+        if(DBQuery::queryCount("UPDATE {$database['prefix']}BlogStatistics SET visits = visits + 1 WHERE blogid = $blogid") < 1) {
             DBQuery::execute("INSERT into {$database['prefix']}BlogStatistics values($blogid, 1)");
         }
         
         $period = Timestamp::getDate();
-        if(!DBQuery::execute("UPDATE {$database['prefix']}DailyStatistics SET visits = visits + 1 WHERE blogid = $blogid AND `date` = $period")) {
+        if(DBQuery::queryCount("UPDATE {$database['prefix']}DailyStatistics SET visits = visits + 1 WHERE blogid = $blogid AND `date` = $period") < 1) {
             DBQuery::execute("INSERT into {$database['prefix']}DailyStatistics values($blogid, $period, 1)");
         }