Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function boardsPosts($boards, $categories, $wanna_see_board = false)
- {
- global $smcFunc;
- $clauses = array();
- $clauseParameters = array();
- if (!empty($categories))
- {
- $clauses[] = 'id_cat IN ({array_int:category_list})';
- $clauseParameters['category_list'] = $categories;
- }
- if (!empty($boards))
- {
- $clauses[] = 'id_board IN ({array_int:board_list})';
- $clauseParameters['board_list'] = $boards;
- }
- if (empty($clauses))
- return array();
- $request = $smcFunc['db_query']('', '
- SELECT b.id_board, b.num_posts
- FROM {db_prefix}boards AS b
- WHERE ' . ($wanna_see_board ? '{query_wanna_see_board}' : '{query_see_board}') . '
- AND b.' . implode(' OR b.', $clauses),
- array_merge($clauseParameters, array(
- ))
- );
- $return = array();
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $return[$row['id_board']] = $row['num_posts'];
- $smcFunc['db_free_result']($request);
- return $return;
- }
- function boardsByCategories($categories, $wanna_see_board = false)
- {
- global $smcFunc;
- $request = $smcFunc['db_query']('', '
- SELECT b.id_board
- FROM {db_prefix}boards AS b
- WHERE ' . ($wanna_see_board ? '{query_wanna_see_board}' : '{query_see_board}') . (!empty($categories) ? '
- AND b.id_cat IN ({array_int:id_cat})' : '
- AND b.id_board != {int:recycle_board}'),
- array(
- 'recycle_board' => !empty($modSettings['recycle_board']) ? $modSettings['recycle_board'] : 0,
- 'id_cat' => $categories,
- )
- );
- $return = array();
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $return[$row['id_board']] = $row['num_posts'];
- $smcFunc['db_free_result']($request);
- return $return;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement