Changeset 673

Timestamp:

03/14/10 17:51:51 (6 months ago)

Author:

inureyes

Message:

• statistics 컴포넌트 참조시 필드명 오류 문제 수정

Files:

• plugins/trunk/JP_PN_Blog_Statistics_Default/lib/statistics_inc.php (modified) (12 diffs)

plugins/trunk/JP_PN_Blog_Statistics_Default/lib/statistics_inc.php

@@ -8 +8 @@
 function getEntriesTotalCountDB($blogid){
     global $database, $configVal;
-    requireComponent('Textcube.Function.misc');
     $data = Misc::fetchConfigVal($configVal);
     if(is_null($data)){
@@ -19 +18 @@
 function getCommentCountDB($blogid){
     global $database, $configVal;
-    requireComponent('Textcube.Function.misc');
     $data = Misc::fetchConfigVal($configVal);
     if(is_null($data)) $data['repliesChk'] = 2;
@@ -29 +27 @@
         }
     }
-    return POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isFiltered = 0 {$commenterOutSql}");
+    return POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isfiltered = 0 {$commenterOutSql}");
 }
 
 function getGuestbookCountDB($blogid){
     global $database, $configVal;
-    requireComponent('Textcube.Function.misc');
     $data = Misc::fetchConfigVal($configVal);
     $repliesChk = ($data['repliesChk'] == 2)?" AND replier is NULL ":"";
-    return POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isFiltered = 0 {$commenterOutSql}");
+    return POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isfiltered = 0 {$commenterOutSql}");
 }
 
 function getTrackbackCountDB($blogid){
     global $database;
-    return POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid} AND entry > 0 AND type = 'trackback' AND isFiltered = 0");
+    return POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid} AND entry > 0 AND type = 'trackback' AND isfiltered = 0");
 }
 
 function getStatisticsDB($getDate, $getCount, $getMode){
     global $database, $blogid, $configVal;
-    requireComponent('Textcube.Function.misc');
     $data = Misc::fetchConfigVal($configVal);
     if(is_null($data)){
@@ -67 +63 @@
         if($getMode == "visit"){
             if(strlen($getCount) == 1) $getCount = "0".$getCount;
-            $getDateSQL  = ($getYear==9999)?"":" AND LEFT(date, 4) = '{$getYear}' ";
-            $getDateSQL .= " AND MID(date, 5,2) = '{$getMonth}' ";
-            $getDateSQL .= " AND MID(date, 7) = '{$getCount}' ";
-            $getDateKey  = " MID(date, 7) period, ";
+            $getDateSQL  = ($getYear==9999)?"":" AND LEFT(datemark, 4) = '{$getYear}' ";
+            $getDateSQL .= " AND MID(datemark, 5,2) = '{$getMonth}' ";
+            $getDateSQL .= " AND MID(datemark, 7) = '{$getCount}' ";
+            $getDateKey  = " MID(datemark, 7) period, ";
         }else{
             if(strlen($getCount) == 1) $getCount = "0".$getCount;
@@ -83 +79 @@
                 if(strlen($getCount) == 1) $getCount = "0".$getCount;
                 $getDateSQL  = "";
-                $getDateKey  = " LEFT(date, 4) period, ";
+                $getDateKey  = " LEFT(datemark, 4) period, ";
             }else{
                 if(strlen($getCount) == 1) $getCount = "0".$getCount;
-                $getDateSQL  = ($getYear==9999)?"":" AND LEFT(date, 4) = '{$getYear}' ";
-                $getDateSQL .= " AND MID(date, 5,2) = '{$getCount}' ";
-                $getDateKey  = " MID(date, 5,2) period, ";
+                $getDateSQL  = ($getYear==9999)?"":" AND LEFT(datemark, 4) = '{$getYear}' ";
+                $getDateSQL .= " AND MID(datemark, 5,2) = '{$getCount}' ";
+                $getDateKey  = " MID(datemark, 5,2) period, ";
             }
         }else{
@@ -111 +107 @@
         case "comment":
             if($getDate == "years" && !$getCount){
-                $targetRow = POD::queryAll("SELECT {$getDateKey} COUNT(*) count FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isFiltered = 0 {$commenterOutSql} {$getDateSQL} GROUP BY period ORDER BY period ASC");
-            }else{
-                $targetRow = POD::queryRow("SELECT {$getDateKey} COUNT(*) count FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isFiltered = 0 {$commenterOutSql} {$getDateSQL} GROUP BY period ORDER BY period ASC");
+                $targetRow = POD::queryAll("SELECT {$getDateKey} COUNT(*) count FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isfiltered = 0 {$commenterOutSql} {$getDateSQL} GROUP BY period ORDER BY period ASC");
+            }else{
+                $targetRow = POD::queryRow("SELECT {$getDateKey} COUNT(*) count FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isfiltered = 0 {$commenterOutSql} {$getDateSQL} GROUP BY period ORDER BY period ASC");
             }
             break;
         case "trackback":
             if($getDate == "years" && !$getCount){
-                $targetRow = POD::queryAll("SELECT {$getDateKey} COUNT(*) count FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid} AND entry > 0 AND type = 'trackback' AND isFiltered = 0 {$getDateSQL} GROUP BY period ORDER BY period ASC");
-            }else{
-                $targetRow = POD::queryRow("SELECT {$getDateKey} COUNT(*) count FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid} AND entry > 0 AND type = 'trackback' AND isFiltered = 0 {$getDateSQL} GROUP BY period ORDER BY period ASC");
+                $targetRow = POD::queryAll("SELECT {$getDateKey} COUNT(*) count FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid} AND entry > 0 AND type = 'trackback' AND isfiltered = 0 {$getDateSQL} GROUP BY period ORDER BY period ASC");
+            }else{
+                $targetRow = POD::queryRow("SELECT {$getDateKey} COUNT(*) count FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid} AND entry > 0 AND type = 'trackback' AND isfiltered = 0 {$getDateSQL} GROUP BY period ORDER BY period ASC");
             }
             break;
         case "guestbook":
             if($getDate == "years" && !$getCount){
-                $targetRow = POD::queryAll("SELECT {$getDateKey} COUNT(*) count FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isFiltered = 0 {$commenterOutSql} {$getDateSQL} GROUP BY period ORDER BY period ASC");
-            }else{
-                $targetRow = POD::queryRow("SELECT {$getDateKey} COUNT(*) count FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isFiltered = 0 {$commenterOutSql} {$getDateSQL} GROUP BY period ORDER BY period ASC");
+                $targetRow = POD::queryAll("SELECT {$getDateKey} COUNT(*) count FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isfiltered = 0 {$commenterOutSql} {$getDateSQL} GROUP BY period ORDER BY period ASC");
+            }else{
+                $targetRow = POD::queryRow("SELECT {$getDateKey} COUNT(*) count FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isfiltered = 0 {$commenterOutSql} {$getDateSQL} GROUP BY period ORDER BY period ASC");
             }
             break;
@@ -182 +178 @@
             break;
         case "comment":
-            $totalRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isFiltered = 0 {$commenterOutSql} {$getSQL}");
+            $totalRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isfiltered = 0 {$commenterOutSql} {$getSQL}");
             break;
         case "trackback":
-            $totalRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid} AND entry > 0 AND type = 'trackback' AND isFiltered = 0 {$getSQL}");
+            $totalRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid} AND entry > 0 AND type = 'trackback' AND isfiltered = 0 {$getSQL}");
             break;
         case "guestbook":
-            $totalRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isFiltered = 0 {$commenterOutSql} {$getSQL}");
+            $totalRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isfiltered = 0 {$commenterOutSql} {$getSQL}");
             break;
         case "tag":
@@ -306 +302 @@
             break;
         case "comment":
-            $totalRow = POD::queryRow("SELECT FROM_UNIXTIME(written, '%H') AS period, COUNT(*) AS count FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isFiltered = 0 {$commenterOutSql} {$getSQL} AND FROM_UNIXTIME(written, '%H') = '{$getHour}' GROUP BY period ORDER BY period ASC");
+            $totalRow = POD::queryRow("SELECT FROM_UNIXTIME(written, '%H') AS period, COUNT(*) AS count FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isfiltered = 0 {$commenterOutSql} {$getSQL} AND FROM_UNIXTIME(written, '%H') = '{$getHour}' GROUP BY period ORDER BY period ASC");
             break;
         case "trackback":
-            $totalRow = POD::queryRow("SELECT FROM_UNIXTIME(written, '%H') AS period, COUNT(*) AS count FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid} AND entry > 0 AND type = 'trackback' AND isFiltered = 0 {$getSQL} AND FROM_UNIXTIME(written, '%H') = '{$getHour}' GROUP BY period ORDER BY period ASC");
+            $totalRow = POD::queryRow("SELECT FROM_UNIXTIME(written, '%H') AS period, COUNT(*) AS count FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid} AND entry > 0 AND type = 'trackback' AND isfiltered = 0 {$getSQL} AND FROM_UNIXTIME(written, '%H') = '{$getHour}' GROUP BY period ORDER BY period ASC");
             break;
         case "guestbook":
-            $totalRow = POD::queryRow("SELECT FROM_UNIXTIME(written, '%H') AS period, COUNT(*) AS count FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isFiltered = 0 {$commenterOutSql} {$getSQL} AND FROM_UNIXTIME(written, '%H') = '{$getHour}' GROUP BY period ORDER BY period ASC");
+            $totalRow = POD::queryRow("SELECT FROM_UNIXTIME(written, '%H') AS period, COUNT(*) AS count FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isfiltered = 0 {$commenterOutSql} {$getSQL} AND FROM_UNIXTIME(written, '%H') = '{$getHour}' GROUP BY period ORDER BY period ASC");
             break;
         default:return false;
@@ -344 +340 @@
         $getSQL .= " AND EXTRACT(MONTH FROM FROM_UNIXTIME(c.written)) = '{$getMonth}' ";
     }
-    $totalRow = POD::queryAll("SELECT COUNT(c.entry) as comments, e.title as title, e.id as id FROM {$database['prefix']}Comments c LEFT JOIN {$database['prefix']}Entries e ON c.blogid = e.blogid AND c.entry = e.id AND e.draft = 0 WHERE c.blogid = $blogid AND c.entry > 0 AND c.isFiltered = 0 {$commenterOutSql} {$getVisibility} {$getSQL} GROUP BY c.entry ORDER BY comments DESC LIMIT 0, 10");
+    $totalRow = POD::queryAll("SELECT COUNT(c.entry) as comments, e.title as title, e.id as id FROM {$database['prefix']}Comments c LEFT JOIN {$database['prefix']}Entries e ON c.blogid = e.blogid AND c.entry = e.id AND e.draft = 0 WHERE c.blogid = $blogid AND c.entry > 0 AND c.isfiltered = 0 {$commenterOutSql} {$getVisibility} {$getSQL} GROUP BY c.entry ORDER BY comments DESC LIMIT 0, 10");
     return $totalRow;
 }
@@ -370 +366 @@
     switch($getMenu){
         case "comment":
-            $totalRow = POD::queryAll("SELECT name, COUNT(name) as namecnt FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isFiltered = 0 {$commenterOutSql} {$getSQL} GROUP BY name ORDER BY namecnt DESC LIMIT 0, 10");
+            $totalRow = POD::queryAll("SELECT name, COUNT(name) as namecnt FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isfiltered = 0 {$commenterOutSql} {$getSQL} GROUP BY name ORDER BY namecnt DESC LIMIT 0, 10");
             break;
         case "guestbook":
-            $totalRow = POD::queryAll("SELECT name, COUNT(name) as namecnt FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isFiltered = 0 {$commenterOutSql} {$getSQL} GROUP BY name ORDER BY namecnt DESC LIMIT 0, 10");
+            $totalRow = POD::queryAll("SELECT name, COUNT(name) as namecnt FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isfiltered = 0 {$commenterOutSql} {$getSQL} GROUP BY name ORDER BY namecnt DESC LIMIT 0, 10");
             break;
         case "commenter":
-            $totalRow = POD::queryAll("SELECT name, Max(homepage) as home, COUNT(name) as namecnt FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isFiltered = 0 {$commenterOutSql} {$getSQL} GROUP BY name ORDER BY namecnt DESC");
+            $totalRow = POD::queryAll("SELECT name, Max(homepage) as home, COUNT(name) as namecnt FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isfiltered = 0 {$commenterOutSql} {$getSQL} GROUP BY name ORDER BY namecnt DESC");
             break;
         case "guestbookcommenter":
-            $totalRow = POD::queryAll("SELECT name, Max(homepage) as home, COUNT(name) as namecnt FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isFiltered = 0 {$commenterOutSql} {$getSQL} GROUP BY name ORDER BY namecnt DESC");
+            $totalRow = POD::queryAll("SELECT name, Max(homepage) as home, COUNT(name) as namecnt FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isfiltered = 0 {$commenterOutSql} {$getSQL} GROUP BY name ORDER BY namecnt DESC");
             break;
         default:return false;
@@ -396 +392 @@
         $getSQL .= " AND EXTRACT(MONTH FROM FROM_UNIXTIME(t.written)) = '{$getMonth}' ";
     }
-    $totalRow = POD::queryAll("SELECT COUNT(t.entry) as trackbacks, e.title as title, e.id as id FROM {$database['prefix']}RemoteResponses t LEFT JOIN {$database['prefix']}Entries e ON t.blogid = e.blogid AND t.entry = e.id AND e.draft = 0 WHERE t.blogid = $blogid AND t.entry > 0 AND t.type = 'trackback' AND t.isFiltered = 0 {$getSQL} GROUP BY t.entry ORDER BY trackbacks DESC LIMIT 0, 10");
+    $totalRow = POD::queryAll("SELECT COUNT(t.entry) as trackbacks, e.title as title, e.id as id FROM {$database['prefix']}RemoteResponses t LEFT JOIN {$database['prefix']}Entries e ON t.blogid = e.blogid AND t.entry = e.id AND e.draft = 0 WHERE t.blogid = $blogid AND t.entry > 0 AND t.type = 'trackback' AND t.isfiltered = 0 {$getSQL} GROUP BY t.entry ORDER BY trackbacks DESC LIMIT 0, 10");
     return $totalRow;
 }
@@ -523 +519 @@
             break;
         case "comment":
-            $totalRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isFiltered = 0 {$commenterOutSql} {$quartersSQL}");
+            $totalRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry > 0 AND isfiltered = 0 {$commenterOutSql} {$quartersSQL}");
             break;
         case "trackback":
-            $totalRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid} AND entry > 0 AND type = 'trackback' AND isFiltered = 0 {$quartersSQL}");
+            $totalRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}RemoteResponses WHERE blogid = {$blogid} AND entry > 0 AND type = 'trackback' AND isfiltered = 0 {$quartersSQL}");
             break;
         case "guestbook":
-            $totalRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isFiltered = 0 {$commenterOutSql} {$quartersSQL}");
+            $totalRow = POD::queryCell("SELECT COUNT(*) FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry = 0 AND isfiltered = 0 {$commenterOutSql} {$quartersSQL}");
             break;
         case "visit":