Category Dropdown - Submit Page

[Wenchie]

Hi there,

If this is already here somewhere I apologize. I swear I searched for the answer before posting.

On the Submit Link page can the pipe and underscore...

|__Whatever

be removed from the Category dropdown menu? If so can you tell me what file I need to edit?

Thank you!

[yktan]

Hi Wenchie,

No worries, this question has never been asked before this. To totally remove the category indentation, do this:

Open \include\functions.php
Find:

function get_categs_tree($db, $id) {
	global $tables;
	static $categs = array ("0" => "[Top]");
	static $level = 0;
	$level ++;
	$rs = $db->Execute("SELECT ID, TITLE FROM {$tables['category']['name']} WHERE PARENT_ID = $id and SYMBOLIC <> 1 ORDER BY TITLE");
	while (!$rs->EOF) {
		$categs[$rs->Fields('ID')] = str_repeat('|', $level -1).'|___'.$rs->Fields('TITLE');
		get_categs_tree($db, $rs->Fields('ID'));
		$rs->MoveNext();
	}
	$level --;
	return $categs;
}

Replace with:

function get_categs_tree($db, $id) {
	global $tables;
	static $categs = array ("0" => "[Top]");
	static $level = 0;
	$level ++;
	$rs = $db->Execute("SELECT ID, TITLE FROM {$tables['category']['name']} WHERE PARENT_ID = $id and SYMBOLIC <> 1 ORDER BY TITLE");
	while (!$rs->EOF) {
		$categs[$rs->Fields('ID')] = $rs->Fields('TITLE');
		get_categs_tree($db, $rs->Fields('ID'));
		$rs->MoveNext();
	}
	$level --;
	return $categs;
}

This is based on PHPLD Rev 76. If you have an older version, the function might look slightly different but I'm sure you can implement the changes just as well.

Regards,
York Kie

[Wenchie]

Ahhh.. thank you so much!

Worked perfectly.

I really appreciate your help, and I love this directory. Everything with it has gone so smoothly. I can't begin to tell you how many I have tried to work with that haven't.

Great work!

[yktan]

Hi Wenchie, you're most welcome. Have fun with PHPLD

Regards,
York Kie

[tarheit]

Here is a version that will list the categories as:

• Category1 > Sub1
  Category1 > Sub2
  Category2
  Category3 > Sub1 > Sub1
  Category3 > Sub1 > Sub2
  etc...

It is based on version 2.0.0 RC5.2
(Perhaps this and the above alternate category listings could be a feature of version 3)

function get_categs_tree($db, $id, $previous='') {
    global $tables;
    static $categs = array ("0" => "[Top]");
    static $level = 0;
    $level ++;
    $rs = $db->Execute("SELECT ID, TITLE FROM {$tables['category']['name']} WHERE PARENT_ID = $id and SYMBOLIC <> 1 ORDER BY TITLE");

    while (!$rs->EOF) {
        if (empty($_SESSION['user_id']) ||$_SESSION['is_admin']) {
            $categs[$rs->Fields('ID')] =  $previous . $rs->Fields('TITLE');
        } else {
            if (in_array($rs->Fields('ID'),$_SESSION['user_permission_array'])){
                $categs[$rs->Fields('ID')] = $previous . $rs->Fields('TITLE');
            }
        }
        get_categs_tree($db, $rs->Fields('ID'), $previous . $rs->Fields('TITLE') . ' > ');

        $rs->MoveNext();
    }
    $level --;
    return $categs;
}

-Tim

[Shadowess]

Hiya!
I've tried both of the suggestions above and I keep getting an error:

Parse error: parse error, unexpected T_STRING in /include/functions.php on line 101

I was actually wondering, since you have figured out how to get rid of the category dropdown pipeline thing and have modifed it, how to change some things.

I would like to have my main categories in bold.
I would also like to have it set up like

Main Category
-Sub Category


Or something similar. I have been tinkering with this for a while and I haven't been able to effect only the Main category listing....(or only the subcat for that matter.)

Any help would be great!
~Shadowess

[fsmedia]

is there an updated version of this for 3.0 or will it work out of the box?

[alang]

Originally Posted by tarheit

Here is a version that will list the categories as:

• Category1 > Sub1
  Category1 > Sub2
  Category2
  Category3 > Sub1 > Sub1
  Category3 > Sub1 > Sub2
  etc...

It is based on version 2.0.0 RC5.2
(Perhaps this and the above alternate category listings could be a feature of version 3)

function get_categs_tree($db, $id, $previous='') {
    global $tables;
    static $categs = array ("0" => "[Top]");
    static $level = 0;
    $level ++;
    $rs = $db->Execute("SELECT ID, TITLE FROM {$tables['category']['name']} WHERE PARENT_ID = $id and SYMBOLIC <> 1 ORDER BY TITLE");

    while (!$rs->EOF) {
        if (empty($_SESSION['user_id']) ||$_SESSION['is_admin']) {
            $categs[$rs->Fields('ID')] =  $previous . $rs->Fields('TITLE');
        } else {
            if (in_array($rs->Fields('ID'),$_SESSION['user_permission_array'])){
                $categs[$rs->Fields('ID')] = $previous . $rs->Fields('TITLE');
            }
        }
        get_categs_tree($db, $rs->Fields('ID'), $previous . $rs->Fields('TITLE') . ' > ');

        $rs->MoveNext();
    }
    $level --;
    return $categs;
}

-Tim

is this work with the latest 3.05 version? I'd checked the code is slightly different.

[CyberGrenade]

Thanks for the MOD. Works great....

[mmastation]

awesome. this works great. thank you. using it on both my directories.

[jharri26]

I tried the mod and got Fatal error: Call to a member function on a non-object in /home/gamhoo/public_html/include/functions.php on line 109 which is $categs[$rs->Fields('ID')] = $previous . $rs->Fields('TITLE');/ I am using the latest directory software. Any help would be good, thanks

[Dudley]

Does anyone know how to get this to work with 3.06?

3.06 uses a different function

function get_regular_categs_tree($id=0)
{
   global $db, $tables;
   static $categs = array ("0" => "[Top]");
   static $level = 0;
   $level++;
   $rs = $db->Execute("SELECT `ID`, `TITLE` FROM `{$tables['category']['name']}` WHERE `PARENT_ID` = ".$db->qstr($id)." AND `STATUS` = '2' AND `SYMBOLIC` <> '1' ORDER BY `TITLE`");

   while (!$rs->EOF)
   {
      $categs[$rs->Fields('ID')] = str_repeat ('|&nbsp;&nbsp;&nbsp;', $level -1).'|___'.$rs->Fields('TITLE');
      get_regular_categs_tree($rs->Fields('ID'));
      $rs->MoveNext();
   }
   $level--;

   return $categs;
}

I tried modifying it in a similar manner to tarheit's example, but it doesn't work and causes a fatal error. Here is the modified code that does NOT work. What am I doing wrong?

function get_regular_categs_tree($id=0,$previous='')
{
   global $db, $tables;
   static $categs = array ("0" => "[Top]");
   static $level = 0;
   $level++;
   $rs = $db->Execute("SELECT `ID`, `TITLE` FROM `{$tables['category']['name']}` WHERE `PARENT_ID` = ".$db->qstr($id)." AND `STATUS` = '2' AND `SYMBOLIC` <> '1' ORDER BY `TITLE`");

   while (!$rs->EOF)
   {
      $categs[$rs->Fields('ID')] = $previous . $rs->Fields('TITLE');
      get_regular_categs_tree($db, $rs->Fields('ID'), $previous . $rs->Fields('TITLE') . ' > ');
      $rs->MoveNext();
   }
   $level--;

   return $categs;
}

I don't see what the $previous variable is supposed to do in tarheit's example, because a value is never assigned to it. It appears like it is supposed to pick up the main category name, but it is never assigned.

[Boby]

There is an error, when you call the function again withing the function:

PHP Code:

get_regular_categs_tree($db, $rs->Fields('ID'), $previous . $rs->Fields('TITLE') . ' > '); 


you are using the first parameter ($db) wrong, that is a deprecated param.

Use this:

PHP Code:

function get_regular_categs_tree($id=0,$previous='')
{
   global $db, $tables;

   static $categs = array ("0" => "[Top]");
   static $level = 0;
   $level++;
   $rs = $db->Execute("SELECT `ID`, `TITLE` FROM `{$tables['category']['name']}` WHERE `PARENT_ID` = ".$db->qstr($id)." AND `STATUS` = '2' AND `SYMBOLIC` <> '1' ORDER BY `TITLE`");

   while (!$rs->EOF)
   {
      $categs[$rs->Fields('ID')] = $previous . $rs->Fields('TITLE');
      get_regular_categs_tree($rs->Fields('ID'), $previous . $rs->Fields('TITLE') . ' > ');
      $rs->MoveNext();
   }
   $level--;

   return $categs;
} 


[Dudley]

Works great! You da man, Boby!

I assumed the problem had to do with the recursion looping, but the error message had to do with memory allocation and didn't give me enough info to pinpoint the problem.

[technomatters]

Hello All,

Thanks for the mode, but it is working at user side while submiting a link, but admin side its still showing the pipes model tree structure.

Anybody help me to figure out this.

Regards
Venkat

[xoom]

Thanks a lot, The mod its great

[slincoln]

Is this mod included in 3.11 or going to be in, 3.12?

Thank you....

[alexito]

I cant find this code:


function get_categs_tree($db, $id) {
global $tables;
static $categs = array ("0" => "[Top]");
static $level = 0;
$level ++;
$rs = $db->Execute("SELECT ID, TITLE FROM {$tables['category']['name']} WHERE PARENT_ID = $id and SYMBOLIC <> 1 ORDER BY TITLE");
while (!$rs->EOF) {
$categs[$rs->Fields('ID')] = str_repeat('|', $level -1).'|___'.$rs->Fields('TITLE');
get_categs_tree($db, $rs->Fields('ID'));
$rs->MoveNext();
}
$level --;
return $categs;
}


i'm using the version 3.0.5, can someone help me?

[alexito]

ok, problem solved