Advertisement
emanuele

Untitled

May 11th, 2013
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.63 KB | None | 0 0
  1. function boardsPosts($boards, $categories, $wanna_see_board = false)
  2. {
  3.     global $smcFunc;
  4.  
  5.     $clauses = array();
  6.     $clauseParameters = array();
  7.     if (!empty($categories))
  8.     {
  9.         $clauses[] = 'id_cat IN ({array_int:category_list})';
  10.         $clauseParameters['category_list'] = $categories;
  11.     }
  12.     if (!empty($boards))
  13.     {
  14.         $clauses[] = 'id_board IN ({array_int:board_list})';
  15.         $clauseParameters['board_list'] = $boards;
  16.     }
  17.  
  18.     if (empty($clauses))
  19.         return array();
  20.  
  21.     $request = $smcFunc['db_query']('', '
  22.         SELECT b.id_board, b.num_posts
  23.         FROM {db_prefix}boards AS b
  24.         WHERE ' . ($wanna_see_board ? '{query_wanna_see_board}' : '{query_see_board}') . '
  25.             AND b.' . implode(' OR b.', $clauses),
  26.         array_merge($clauseParameters, array(
  27.         ))
  28.     );
  29.     $return = array();
  30.     while ($row = $smcFunc['db_fetch_assoc']($request))
  31.         $return[$row['id_board']] = $row['num_posts'];
  32.     $smcFunc['db_free_result']($request);
  33.  
  34.     return $return;
  35. }
  36.  
  37. function boardsByCategories($categories, $wanna_see_board = false)
  38. {
  39.     global $smcFunc;
  40.  
  41.     $request = $smcFunc['db_query']('', '
  42.         SELECT b.id_board
  43.         FROM {db_prefix}boards AS b
  44.         WHERE ' . ($wanna_see_board ? '{query_wanna_see_board}' : '{query_see_board}') . (!empty($categories) ? '
  45.             AND b.id_cat IN ({array_int:id_cat})' : '
  46.             AND b.id_board != {int:recycle_board}'),
  47.         array(
  48.             'recycle_board' => !empty($modSettings['recycle_board']) ? $modSettings['recycle_board'] : 0,
  49.             'id_cat' => $categories,
  50.         )
  51.     );
  52.     $return = array();
  53.     while ($row = $smcFunc['db_fetch_assoc']($request))
  54.         $return[$row['id_board']] = $row['num_posts'];
  55.     $smcFunc['db_free_result']($request);
  56.  
  57.     return $return;
  58. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement