XPressME Integration Kit

Trac

source: trunk/blocks/block_common.php @ 122

Last change on this file since 122 was 63, checked in by toemon, 16 years ago

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

File size: 2.5 KB
RevLine 
[35]1<?php
2
3if( ! function_exists( 'yes_no_radio_option' ) ) :
4function yes_no_radio_option($option_name,$label,$value,$yes = '',$no= ''){
5        if (empty( $yes ))  $yes = _YES ;
6        if (empty( $no ))  $no = _NO ;
7        $form = $label.' : ';
8        if ($value){
9                $form .= "<input type='radio' name='". $option_name . "' value='1' checked='checked' />" . $yes. "; " ;
10                $form .= "<input type='radio' name='". $option_name . "' value='0' />". $no ;
11        }else{
12                $form .= "<input type='radio' name='". $option_name . "' value='1' />" . $yes. "; " ;
13                $form .= "<input type='radio' name='". $option_name . "' value='0' checked='checked' />". $no ;
14        }               
15    return $form;
16       
17}
18endif;
19
20if(!function_exists("dropdown_cats_options")):
21function dropdown_cats_options($sort_column = 'ID', $sort_order = 'asc', $selected=array())
22{
[63]23    $mydirpath = dirname(dirname(__FILE__));
24        $mydirname = basename( dirname( dirname( __FILE__ ) ) ) ;
25        if ($mydirname == 'wordpress'){
26                $wp_prefix = 'wp_';
[35]27        } else {
[63]28                $wp_prefix = $mydirname . '_';
[35]29        }
[63]30        $xoopsDB =& Database::getInstance();
[35]31        $myts =& MyTextSanitizer::getInstance();
32    $selected = is_array($selected)?$selected:array($selected);
33    $sort_column = 'cat_'.$sort_column;
[63]34        include $mydirpath.'/wp-includes/version.php';
[35]35        if ($wp_db_version < 6124) {
[63]36                $db_xpress_categories = $xoopsDB->prefix($wp_prefix . 'categories');
[35]37                $query = "
38                SELECT cat_ID, cat_name, category_nicename,category_parent
[63]39                FROM $db_xpress_categories
[35]40                WHERE cat_ID > 0
41                ";
[63]42                $query .= " ORDER BY $sort_column $sort_order";
[35]43
44    } else {
[63]45        $db_xpress_terms = $xoopsDB->prefix($wp_prefix . 'terms');
46        $db_xpress_term_taxonomy = $xoopsDB->prefix($wp_prefix . 'term_taxonomy');
[35]47        $query = "
[63]48                        SELECT $db_xpress_terms.term_id as cat_ID , $db_xpress_terms.name as cat_name , $db_xpress_term_taxonomy.taxonomy
49                        FROM $db_xpress_terms LEFT JOIN $db_xpress_term_taxonomy ON $db_xpress_terms.term_id = $db_xpress_term_taxonomy.term_id
50                        WHERE $db_xpress_term_taxonomy.taxonomy = 'category'
[35]51        ";
52                $query .= " ORDER BY $sort_column $sort_order";
53    }
[63]54        $res =  $xoopsDB->query($query, 0, 0);
55    if ($res !== false){
56                while($row = $xoopsDB->fetchArray($res)){
57            $cat_name = $row['cat_name'];
58            $cat_ID = $row['cat_ID'];
59            echo "\t<option value=\"".$cat_ID."\"";
60            if (in_array($cat_ID, $selected))
[35]61                echo ' selected="selected"';
62            echo '>';
63            echo $myts->htmlspecialchars($cat_name);
64            echo "</option>\n";
65        }
66    }
67    return;
68}
69endif;
70
71
72
73?>
Note: See TracBrowser for help on using the repository browser.