[35] | 1 | <?php |
---|
| 2 | |
---|
| 3 | if( ! function_exists( 'yes_no_radio_option' ) ) : |
---|
| 4 | function 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 | } |
---|
| 18 | endif; |
---|
| 19 | |
---|
| 20 | if(!function_exists("dropdown_cats_options")): |
---|
| 21 | function 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 | } |
---|
| 69 | endif; |
---|
| 70 | |
---|
| 71 | |
---|
| 72 | |
---|
| 73 | ?> |
---|