function mylink_categories_selbox( $whr )
{
include_once dirname( dirname(__FILE__) ).'/class/mycategory.php' ;
$mycategory = new MyCategory( $this->mydirname, 'Show' ) ;
$category = array() ;
$idarray = $this->get_mylink_idarray() ;
if( empty( $idarray ) ) return array() ;
$sql = "SELECT d.cid, c.path FROM ".$this->table." d LEFT JOIN ".$this->cat_table." c ON d.cid=c.cid" ;
$sql .= " WHERE ( d.".$whr." ) AND ( ". $this->get_whr_mylink( $idarray )." ) ORDER BY c.cat_weight ASC" ;
$result = $this->db->query( $sql ) ;
while( $array = $this->db->fetchArray( $result ) ) {
foreach ( $array as $key=>$value ){
$$key = $value;
}
$catid = intval( $cid ) ;
$path_array = $mycategory->unserialize_my_path( $catid, $whr, $path ) ;
$category[ $catid ] = $mycategory->getPathFromId( $catid, $whr , $path_array ) ;
$category[ $catid ] .= " (".$this->total_mylink( $catid, $whr, 0, $idarray ).")" ;
}
return $category ;
}
