Changeset 54 for trunk/wp-content/plugins/xpressme/include/custom_functions.php

Timestamp:

Dec 28, 2008, 2:28:17 AM (15 years ago)

Author:

toemon

Message:

最近の記事内容ブロック　実装
概要処理の部分と、閲覧数の部分は未完です。

File:

• trunk/wp-content/plugins/xpressme/include/custom_functions.php (modified) (2 diffs)

trunk/wp-content/plugins/xpressme/include/custom_functions.php

@@ -218 +218 @@
 // Retrieves post views given a post ID or post object. 
 function xpress_post_views_count($post_id=0,$format= '',$show = true) {
-        global $table_prefix;
+        global $xoops_db;
 
         static $post_cache_views;
@@ -230 +230 @@
         if($post_id==0) return null;
         if(!isset($post_cache_views[$post_id])){
-        $sql = "SELECT post_views FROM " . $table_prefix . "views" . " WHERE post_id=$post_id";
-        if (!$result = $GLOBALS["xoopsDB"]->query($sql)) {
+        $sql = "SELECT post_views FROM " . get_xoops_prefix() . "views" . " WHERE post_id=$post_id";
+        $post_views = $xoops_db->get_var($sql);
+        if (!$post_views) {
                 $post_cache_views[$post_id] = 0;
         }else{
-                $row = $GLOBALS["xoopsDB"]->fetchArray($result);
-                $post_cache_views[$post_id] = $row["post_views"];
+                $post_cache_views[$post_id] = $post_views;
         }
         }