Topic: Category block

[iobit]

Hello,
can you create a block for show category forum (like music, game...)in portal?
thanks.

PS: great work simplyportal 

[grafitus]

http://simpleportal.net/index.php?topic=8653.msg46252#msg46252

I did not try it. But you can try and put the result here.

[iobit]

Thanks fantastic!!  ,
is there a way to see the number of posts in each category?
thanks again

[grafitus]

Try this:

Code: (Find) [Select]

', $boards[$boardid]['name'], '</a>

Code: (Replace) [Select]

', $boards[$boardid]['name'], '</a> (', $boards[$boardid]['count_posts'], ')

[iobit]

I view all numbers 1

name category 1
name category 1
name category 1
name category 1

[grafitus]

Sorry, we need to do more operations.

Code: (Find) [Select]

foreach ($boardList[$catid] as $boardid)
{

Code: (Replace) [Select]

foreach ($boardList[$catid] as $boardid)
{
// Sorry this is hard method for server. But easy. :)
$request = db_query("
SELECT numPosts
FROM {$db_prefix}boards
WHERE ID_BOARD = $boardid", __FILE__, __LINE__);
list ($num_posts) = mysql_fetch_row($request);
mysql_free_result($request);

Code: (Find) [Select]

', $boards[$boardid]['name'], '</a>

Code: (Replace) [Select]

', $boards[$boardid]['name'], '</a> (', $num_posts, ')

[[SiNaN]]

Try this:

Code: (Find) [Select]

', $boards[$boardid]['name'], '</a>

Code: (Replace) [Select]

', $boards[$boardid]['name'], '</a> (', $boards[$boardid]['count_posts'], ')

Change 'count_posts' as 'posts' and it should work.

[iobit]

Sorry, we need to do more operations.

Code: (Find) [Select]

foreach ($boardList[$catid] as $boardid)
{

Code: (Replace) [Select]

foreach ($boardList[$catid] as $boardid)
{
// Sorry this is hard method for server. But easy. :)
$request = db_query("
SELECT numPosts
FROM {$db_prefix}boards
WHERE ID_BOARD = $boardid", __FILE__, __LINE__);
list ($num_posts) = mysql_fetch_row($request);
mysql_free_result($request);

Code: (Find) [Select]

', $boards[$boardid]['name'], '</a>

Code: (Replace) [Select]

', $boards[$boardid]['name'], '</a> (', $num_posts, ')

work but i have this: Read Before Posting (1) ()

[iobit]

Try this:

Code: (Find) [Select]

', $boards[$boardid]['name'], '</a>

Code: (Replace) [Select]

', $boards[$boardid]['name'], '</a> (', $boards[$boardid]['count_posts'], ')

Change 'count_posts' as 'posts' and it should work.

instead, this: Read Before Posting  ()

[[SiNaN]]

instead, this: Read Before Posting  ()

Sorry. I thought you were using SMF 2.0 versions. For 1.1 versions, you need this extra edit:

Sources/Subs-Boards.php

Code: (Find) [Select]

b.countPosts,

Code: (Replace) [Select]

b.countPosts, b.numPosts,

Code: (Find) [Select]

'count_posts' => empty($row['countPosts']),

Code: (Replace) [Select]

'count_posts' => empty($row['countPosts']),
'posts' => $row['numPosts'],

[iobit]

now have this: Read Before Posting (1) (1)

[[SiNaN]]

Can you paste here what you have now? (the whole code)

[iobit]

Code: [Select]

global $cat_tree, $boards, $boardList, $scripturl, $sourcedir, $user_info, $db_prefix;

$block_parameters = array(
'num_children' => 'int',
);

if ($return_parameters)
return $block_parameters;

$child_depth = !empty($parameters['num_children']) ? (int) $parameters['num_children'] - 1 : -1;

require_once($sourcedir . '/Subs-Boards.php');
getBoardTree();

// Remobe any boards this user can't actually see.
$temp_boards = $boards;
$request = db_query("
SELECT b.ID_BOARD
FROM {$db_prefix}boards AS b
WHERE !($user_info[query_see_board])", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
unset($temp_boards[$row['ID_BOARD']]);
mysql_free_result($request);

echo '
<div style="padding-left:2px;">';

foreach ($cat_tree as $catid => $tree)
{
echo '
<span class="sp_navigation_block_cat" style="font-weight:bold;"><a href="', $scripturl, '?action=forum#', $tree['node']['id'], '">', $tree['node']['name'], '</a></span><br />';

foreach ($boardList[$catid] as $boardid)
{
// Sorry this is hard method for server. But easy. :)
$request = db_query("
SELECT numPosts
FROM {$db_prefix}boards
WHERE ID_BOARD = $boardid", __FILE__, __LINE__);
list ($num_posts) = mysql_fetch_row($request);
mysql_free_result($request);


$prefix = '';
for ($i=0; $i<=$boards[$boardid]['level']; $i++)
$prefix .= '-';

echo '
', $prefix, '<span class="sp_navigation_block_board"><a href="', $scripturl, '?board=', $boards[$boardid]['id'], '">', $boards[$boardid]['name'], '</a> (', $num_posts, ') (', $boards[$boardid]['posts'], ')</span><br />';
}
}

echo '
</div>';

[[SiNaN]]

Use this one:

Code: [Select]

global $cat_tree, $boards, $boardList, $scripturl, $sourcedir, $user_info, $db_prefix;

$block_parameters = array(
'num_children' => 'int',
);

if ($return_parameters)
return $block_parameters;

$child_depth = !empty($parameters['num_children']) ? (int) $parameters['num_children'] - 1 : -1;

require_once($sourcedir . '/Subs-Boards.php');
getBoardTree();

// Remobe any boards this user can't actually see.
$temp_boards = $boards;
$request = db_query("
SELECT b.ID_BOARD
FROM {$db_prefix}boards AS b
WHERE !($user_info[query_see_board])", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
unset($temp_boards[$row['ID_BOARD']]);
mysql_free_result($request);

echo '
<div style="padding-left:2px;">';

foreach ($cat_tree as $catid => $tree)
{
echo '
<span class="sp_navigation_block_cat" style="font-weight:bold;"><a href="', $scripturl, '?action=forum#', $tree['node']['id'], '">', $tree['node']['name'], '</a></span><br />';

foreach ($boardList[$catid] as $boardid)
{
$prefix = '';
for ($i=0; $i<=$boards[$boardid]['level']; $i++)
$prefix .= '-';

echo '
', $prefix, '<span class="sp_navigation_block_board"><a href="', $scripturl, '?board=', $boards[$boardid]['id'], '">', $boards[$boardid]['name'], '</a> (', $boards[$boardid]['posts'], ')</span><br />';
}
}

echo '
</div>';

[iobit]

are you fantastic  work very fine  thanks thanks thanks

[[SiNaN]]

You're welcome.

[wille]

This code gives error "Fatal error: Call to undefined function db_query()" with SMF 2.0.2 and SP 2.3.5

Can't figure how to fix it...

[Tricky]

Same "Fatal Error"

[iobit]

Hello,
please can anyone update this code for version 2.3.5?

Thanks.

Code: [Select]

global $cat_tree, $boards, $boardList, $scripturl, $sourcedir, $user_info, $db_prefix;

$block_parameters = array(
'num_children' => 'int',
);

if ($return_parameters)
return $block_parameters;

$child_depth = !empty($parameters['num_children']) ? (int) $parameters['num_children'] - 1 : -1;

require_once($sourcedir . '/Subs-Boards.php');
getBoardTree();

// Remobe any boards this user can't actually see.
$temp_boards = $boards;
$request = db_query("
SELECT b.ID_BOARD
FROM {$db_prefix}boards AS b
WHERE !($user_info[query_see_board])", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
unset($temp_boards[$row['ID_BOARD']]);
mysql_free_result($request);

echo '
<div style="padding-left:2px;">';

foreach ($cat_tree as $catid => $tree)
{
echo '
<span class="sp_navigation_block_cat" style="font-weight:bold;"><a href="', $scripturl, '?action=forum#', $tree['node']['id'], '">', $tree['node']['name'], '</a></span><br />';

foreach ($boardList[$catid] as $boardid)
{
$prefix = '';
for ($i=0; $i<=$boards[$boardid]['level']; $i++)
$prefix .= '-';

echo '
', $prefix, '<span class="sp_navigation_block_board"><a href="', $scripturl, '?board=', $boards[$boardid]['id'], '">', $boards[$boardid]['name'], '</a> (', $boards[$boardid]['posts'], ')</span><br />';
}
}

echo '
</div>';