function get_categories_list( $top=0 ) { require_once dirname( dirname(__FILE__) ).'/class/mycategory.php' ; $mycategory = new MyCategory( $this->mydirname, 'Show' ) ; $ret = array() ; $ret[''] = '------' ; $result = $this->db->query( "SELECT cid, title, child FROM ".$this->cat_table." WHERE pid='0' ORDER BY cat_weight ASC" ) ; while( $array = $this->db->fetchArray( $result ) ) { foreach ( $array as $key=>$value ){ $$key = $value; } $id =intval( $cid ) ; $ret[ $id ] = $this->myts->makeTboxData4Show( $title ) ; if( empty( $top ) ) { $arr = $mycategory->unserialize_my_child( $id, '', $child ) ; foreach ( $arr as $child ) { $child_id = intval( $child['cid'] ) ; $child['prefix'] = str_replace( ".","--", $child['prefix'] ) ; $ret[ $child_id ] = $child['prefix']." " . $this->myts->makeTboxData4Show( $child['title'] ) ; } } } return $ret ; }
function get_copy_target_category( $target_dirname ) { require_once dirname( dirname(__FILE__) ).'/class/mycategory.php' ; $mycategory = new MyCategory( $target_dirname, 'Show' ) ; $category = "" ; $sql = "SELECT cid, title, child FROM ".$this->db->prefix( $target_dirname."_cat" )." WHERE pid='0' ORDER BY cat_weight ASC" ; $result = $this->db->query( $sql ); while( list( $id, $name, $child_array ) = $this->db->fetchRow( $result ) ) { $cid = intval( $id ); $category .= "<option value='$cid'>".$this->myts->makeTboxData4Show( $name )."</option>\n" ; $arr = $mycategory->unserialize_my_child( $cid, '', $child_array ) ; foreach ( $arr as $child ) { $child_id = intval( $child['cid'] ) ; $child['prefix'] = str_replace( ".","--", $child['prefix'] ) ; $category .= "<option value='$child_id'>".$child['prefix']." ".$this->myts->makeTboxData4Show( $child['title'] )."</option>\n" ; } } return $category ; }