Выпадающий список вместо дерева - страница 3 - SOBI2

<select name="sobi2SlectedCatsID[]" size="1" class="inputbox">
	<option value="108">ЗНАКОМСТВО -&gt; Другое</option>
        ......................................
	<option value="93">УСЛУГИ -&gt; Юридические и Нотариальные</option>
</select>

.inputbox {
background: white url(../images/inputbox.png) repeat-x top center;
border: solid 1px #AFAFAF;
max-width: 400px;
margin: 2px;
padding: 2px;
}

<?php
defined( '_SOBI2_' ) || exit("Restricted access");

global $sobiLastChildId;
$sobiLastChildId=0;
global $sobiLastChildTree;
$sobiLastChildTree='';
global $sobiTmpList;
$sobiTmpList=array();

function getSobiCatsDrop ( $parent = 1, $wordlimit=10, $delimiter='|')
{
	global $sobiLastChildId;
	global $sobiLastChildTree;
	global $sobiTmpList;
    $config =& sobi2Config::getInstance();
    $database =& $config->getDb();
    $published = null;
    if ( $parent < 1 ) 
	{$parent = 1;}
    if ( ! ( defined( '_SOBI2_ADMIN' ) ) ) 
	{$published = " published = 1 AND ";}
    $query = "SELECT relations.catid " . "FROM `#__sobi2_categories`" . "LEFT JOIN `#__sobi2_cats_relations` AS relations ON `#__sobi2_categories`.catid = relations.catid " . "WHERE `parentid` = {$parent} AND `published` = 1 ORDER BY `#__sobi2_categories`.name ASC ";
    $config->database->setQuery( $query );
    $cids = $config->database->loadResultArray();
    if( $config->database->getErrorNum() ) 
	{trigger_error( "DB reports: " . $config->database->stderr(), E_USER_WARNING );}
    if(sizeof($cids)>0) 
	{
      $ids = ( ! empty( $cids ) )? implode( " , ", $cids ) : null;
      $query = "SELECT * FROM #__sobi2_categories WHERE catid IN({$ids}) AND published = 1 ORDER BY name ASC";//ORDER BY {$config->catsOrdering}";
      $config->database->setQuery( $query );
    }
    $return = $config->database->loadObjectList();
    if ( $config->database->getErrorNum() ) 
	{trigger_error( "DB reports: " . $config->database->stderr(), E_USER_WARNING );}
    $catList1 = array();
    if( !empty( $return ) )
	{
        foreach( $return as $category ) 
	    {
			$category->name = $config->jsAddSlashes( $config->getSobiStr( $category->name ) );
            $category->name = $config->getSobiStr($category->name);
			$sobiLastChildTree=$category->name;
			if(strlen($category->name)>$wordlimit && $wordlimit>0)
			{$sobiLastChildTree=mb_substr(trim($category->name), 0, $wordlimit).'... ';}
			$sobiLastChildId=$category->catid;
			getSobiTreeData($category->catid, $wordlimit, $delimiter);
        }
    }
	$catList1=$sobiTmpList;
    $catList1 = sobiHTML::selectList( $catList1, "sobi2SlectedCatsID[]", 'size="1" class="inputbox"' , 'value', 'text' );
    $returnVal = "<tr><td>Выберите категорию:</td><td>{$catList1}</td>";
    return $returnVal;
}


function getSobiTreeData ( $parent = 1, $wordlimit=8, $delimiter='|')
{
	global $sobiLastChildId;
	global $sobiLastChildTree;
	global $sobiTmpList;
	
    $config =& sobi2Config::getInstance();
    $database =& $config->getDb();
    $published = null;
    if ( $parent > 1 ) 
	{
		if ( ! ( defined( '_SOBI2_ADMIN' ) ) ) 
		{$published = " published = 1 AND ";}
		$query = "SELECT relations.catid " . "FROM `#__sobi2_categories`" . "LEFT JOIN `#__sobi2_cats_relations` AS relations ON `#__sobi2_categories`.catid = relations.catid " . "WHERE `parentid` = {$parent} AND `published` = 1 ORDER BY `#__sobi2_categories`.name ASC";
		$config->database->setQuery( $query );
		$cids = $config->database->loadResultArray();
		if( $config->database->getErrorNum() ) 
		{trigger_error( "DB reports: " . $config->database->stderr(), E_USER_WARNING );}
		if(sizeof($cids)>0) 
		{
		  $ids = ( ! empty( $cids ) )? implode( " , ", $cids ) : null;
		  $query = "SELECT * FROM #__sobi2_categories WHERE catid IN({$ids}) AND published = 1 ORDER BY name ASC";//ORDER BY {$config->catsOrdering}";
		  $config->database->setQuery( $query );
		}
		$return = $config->database->loadObjectList();
		if ( $config->database->getErrorNum() ) 
		{trigger_error( "DB reports: " . $config->database->stderr(), E_USER_WARNING );}
		
		if( !empty( $return ) )
		{
			foreach( $return as $category ) 
			{
				$category->name = $config->jsAddSlashes( $config->getSobiStr( $category->name ) );
				$category->name = $config->getSobiStr($category->name);
				if(strlen($category->name)>$wordlimit && $wordlimit>0)
				{$category->name=mb_substr(trim($category->name), 0, $wordlimit).'... ';}
				$tmpStr1=$sobiLastChildTree;
				$sobiLastChildTree.=$delimiter.' '.$category->name.' ';
				$tmpStr2=$sobiLastChildTree;
				
				$q = "SELECT relations.catid " . "FROM `#__sobi2_categories`" . "LEFT JOIN `#__sobi2_cats_relations` AS relations ON `#__sobi2_categories`.catid = relations.catid " . "WHERE `parentid` = {$category->catid} AND `published` = 1 ORDER BY `#__sobi2_categories`.name ASC";
				$config->database->setQuery( $q );
				$res = $config->database->loadResultArray();
				if( $config->database->getErrorNum() ) 
				{trigger_error( "DB reports: " . $config->database->stderr(), E_USER_WARNING );}
				if(empty($res))
				{
					$sobiLastChildTree=trim($sobiLastChildTree);
					$sobiLastChildId=(int)$category->catid;
					if($sobiLastChildId>0 && strlen($sobiLastChildTree)>0)
					{$sobiTmpList[]=sobiHTML::makeOption( $sobiLastChildId, $sobiLastChildTree );}
				}
				else
				{
					$sobiLastChildId=$category->catid;
					getSobiTreeData($category->catid, $wordlimit, $delimiter);
				}
				$sobiLastChildTree=$tmpStr1;
			}
		}
	}
}

?>