Changeset 63 for trunk

Timestamp:

Jan 6, 2009, 1:18:31 AM (16 years ago)

Author:

toemon

Message:

カテゴリー選択のあるブロックで、カテゴリリストを得るために、WPをロードするとcoolplayerプラグインでエラーになるので、WPをロードせずリストを得るように変更。

File:

• trunk/blocks/block_common.php (modified) (1 diff)

trunk/blocks/block_common.php

@@ -21 +21 @@
 function dropdown_cats_options($sort_column = 'ID', $sort_order = 'asc', $selected=array()) 
 {
-    global $wpdb, $wp_query, $wp_rewrite, $wp_roles;
-
-        $path = dirname(dirname(__FILE__)) . '/';
-        if (file_exists($path . 'wp-load.php')) {
-                require_once $path . 'wp-load.php';
+    $mydirpath = dirname(dirname(__FILE__));
+        $mydirname = basename( dirname( dirname( __FILE__ ) ) ) ;
+        if ($mydirname == 'wordpress'){
+                $wp_prefix = 'wp_';
         } else {
-                require_once $path . 'wp-config.php';
+                $wp_prefix = $mydirname . '_';
         }
-
+        $xoopsDB =& Database::getInstance();
         $myts =& MyTextSanitizer::getInstance();
     $selected = is_array($selected)?$selected:array($selected);
     $sort_column = 'cat_'.$sort_column;
+        include $mydirpath.'/wp-includes/version.php';
         if ($wp_db_version < 6124) {
+                $db_xpress_categories = $xoopsDB->prefix($wp_prefix . 'categories');
                 $query = "
                 SELECT cat_ID, cat_name, category_nicename,category_parent 
-                FROM $wpdb->categories 
+                FROM $db_xpress_categories 
                 WHERE cat_ID > 0 
                 ";
-        $query .= " ORDER BY $sort_column $sort_order";
+                $query .= " ORDER BY $sort_column $sort_order";
 
     } else {
+        $db_xpress_terms = $xoopsDB->prefix($wp_prefix . 'terms');
+        $db_xpress_term_taxonomy = $xoopsDB->prefix($wp_prefix . 'term_taxonomy');
         $query = "
-                        SELECT $wpdb->terms.term_id as cat_ID , $wpdb->terms.name as cat_name , $wpdb->term_taxonomy.taxonomy 
-                        FROM $wpdb->terms LEFT JOIN $wpdb->term_taxonomy ON $wpdb->terms.term_id = $wpdb->term_taxonomy.term_id 
-                        WHERE $wpdb->term_taxonomy.taxonomy = 'category' 
+                        SELECT $db_xpress_terms.term_id as cat_ID , $db_xpress_terms.name as cat_name , $db_xpress_term_taxonomy.taxonomy 
+                        FROM $db_xpress_terms LEFT JOIN $db_xpress_term_taxonomy ON $db_xpress_terms.term_id = $db_xpress_term_taxonomy.term_id 
+                        WHERE $db_xpress_term_taxonomy.taxonomy = 'category' 
         ";
                 $query .= " ORDER BY $sort_column $sort_order";
     }
-
-    $categories = $wpdb->get_results($query);
-    if ($categories) {
-        foreach ($categories as $category) {
-            $cat_name = apply_filters('list_cats', $category->cat_name, $category);
-            echo "\t<option value=\"".$category->cat_ID."\"";
-            if (in_array($category->cat_ID, $selected))
+        $res =  $xoopsDB->query($query, 0, 0);
+    if ($res !== false){
+                while($row = $xoopsDB->fetchArray($res)){
+            $cat_name = $row['cat_name'];
+            $cat_ID = $row['cat_ID'];
+            echo "\t<option value=\"".$cat_ID."\"";
+            if (in_array($cat_ID, $selected))
                 echo ' selected="selected"';
             echo '>';