MODS.DB9.DK

[william91]

Hi,
I have install Categories hierarchy Mod
Categories hierarchy Mod change some code in admin/admin_forumauth.php, so i can't find the code below:

Code: Select all

#
#-----[ OPEN ]------------------------------------------
#
admin/admin_forumauth.php

#
#-----[ FIND ]------------------------------------------
#
//
// Get required information, either all forums if
// no id was specified or just the requsted if it
// was
//
$sql = "SELECT f.*
      FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
      WHERE c.cat_id = f.cat_id   $forum_sql
   ORDER BY c.cat_order ASC, f.forum_order ASC";
if ( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, "Couldn't obtain forum list", "", __LINE__, __FILE__, $sql);
}

$forum_rows = $db->sql_fetchrowset($result);
$db->sql_freeresult($result);

#
#-----[ REPLACE WITH ]------------------------------------------
#
//
// Get required information, either all forums if
// no id was specified or just the requsted if it
// was
//
$sql = "SELECT f.*
   FROM " . FORUMS_TABLE . " f
   WHERE f.cat_id=0
   $forum_sql
   ORDER BY f.forum_name ASC";
if ( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, "Couldn't obtain special pages list", "", __LINE__, __FILE__, $sql);
}
$forum_rows = $db->sql_fetchrowset($result);
$db->sql_freeresult($result);

$sql = "SELECT f.*
   FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
   WHERE c.cat_id = f.cat_id
   $forum_sql
   ORDER BY c.cat_order ASC, f.forum_order ASC";
if ( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, "Couldn't obtain forum list", "", __LINE__, __FILE__, $sql);
}
$forum_rows = array_merge($forum_rows,$db->sql_fetchrowset($result));
$db->sql_freeresult($result);

How can i do? i only can find:

Code: Select all

//
// Get required information, either all forums if
// no id was specified or just the requsted if it
// was
//
//-- mod : categories hierarchy --------------------------------------------------------------------
//-- delete
// $sql = "SELECT f.*
//   FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
//   WHERE c.cat_id = f.cat_id
//   $forum_sql
//   ORDER BY c.cat_order ASC, f.forum_order ASC";
// if ( !($result = $db->sql_query($sql)) )
// {
//   message_die(GENERAL_ERROR, "Couldn't obtain forum list", "", __LINE__, __FILE__, $sql);
// }
//
// $forum_rows = $db->sql_fetchrowset($result);
// $db->sql_freeresult($result);
//-- fin mod : categories hierarchy ----------------------------------------------------------------


Please help me
Thanks

~william91

[william91]

Hi,
then i try to install it...but follow, it have

Code: Select all

Couldn't obtain special pages list

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE forum_id = -101 ORDER BY f.forum_name ASC' at line 4

SELECT f.* FROM phpbb_forums f WHERE f.cat_id=0 WHERE forum_id = -101 ORDER BY f.forum_name ASC

Line : 209
File : d:\appserv\www\phpbb\admin\admin_forumauth.php

And.......I think this problem is categories hierarchy can not work with this mod.......

Please Help me.....

bye
~william91

[Chavez]

HM everybody has solve this problem? I've got it too.

[TERMINATRIX]

Oh, YES !! Waiting for a solution about this myself -

[sitherious]

same problem here

[sitherious]

will this ever get fixed?

[darkrick]

well, seeing that it was originally posted in september 2003, i'm going to go with "no".

[Kinfule]

i hope someone can fix this