PostModeration.php 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621
  1. <?php
  2. /**
  3. * This file's job is to handle things related to post moderation.
  4. *
  5. * Simple Machines Forum (SMF)
  6. *
  7. * @package SMF
  8. * @author Simple Machines http://www.simplemachines.org
  9. * @copyright 2011 Simple Machines
  10. * @license http://www.simplemachines.org/about/smf/license.php BSD
  11. *
  12. * @version 2.0
  13. */
  14. if (!defined('SMF'))
  15. die('Hacking attempt...');
  16. /**
  17. * This is a handling function for all things post moderation...
  18. */
  19. function PostModerationMain()
  20. {
  21. global $sourcedir;
  22. //!!! We'll shift these later bud.
  23. loadLanguage('ModerationCenter');
  24. loadTemplate('ModerationCenter');
  25. // Probably need this...
  26. require_once($sourcedir . '/ModerationCenter.php');
  27. // Allowed sub-actions, you know the drill by now!
  28. $subactions = array(
  29. 'approve' => 'ApproveMessage',
  30. 'attachments' => 'UnapprovedAttachments',
  31. 'replies' => 'UnapprovedPosts',
  32. 'topics' => 'UnapprovedPosts',
  33. );
  34. // Pick something valid...
  35. if (!isset($_REQUEST['sa']) || !isset($subactions[$_REQUEST['sa']]))
  36. $_REQUEST['sa'] = 'replies';
  37. $subactions[$_REQUEST['sa']]();
  38. }
  39. /**
  40. * View all unapproved posts.
  41. */
  42. function UnapprovedPosts()
  43. {
  44. global $txt, $scripturl, $context, $user_info, $sourcedir, $smcFunc;
  45. $context['current_view'] = isset($_GET['sa']) && $_GET['sa'] == 'topics' ? 'topics' : 'replies';
  46. $context['page_title'] = $txt['mc_unapproved_posts'];
  47. // Work out what boards we can work in!
  48. $approve_boards = boardsAllowedTo('approve_posts');
  49. // If we filtered by board remove ones outside of this board.
  50. //!!! Put a message saying we're filtered?
  51. if (isset($_REQUEST['brd']))
  52. {
  53. $filter_board = array((int) $_REQUEST['brd']);
  54. $approve_boards = $approve_boards == array(0) ? $filter_board : array_intersect($approve_boards, $filter_board);
  55. }
  56. if ($approve_boards == array(0))
  57. $approve_query = '';
  58. elseif (!empty($approve_boards))
  59. $approve_query = ' AND m.id_board IN (' . implode(',', $approve_boards) . ')';
  60. // Nada, zip, etc...
  61. else
  62. $approve_query = ' AND 0';
  63. // We also need to know where we can delete topics and/or replies to.
  64. if ($context['current_view'] == 'topics')
  65. {
  66. $delete_own_boards = boardsAllowedTo('remove_own');
  67. $delete_any_boards = boardsAllowedTo('remove_any');
  68. $delete_own_replies = array();
  69. }
  70. else
  71. {
  72. $delete_own_boards = boardsAllowedTo('delete_own');
  73. $delete_any_boards = boardsAllowedTo('delete_any');
  74. $delete_own_replies = boardsAllowedTo('delete_own_replies');
  75. }
  76. $toAction = array();
  77. // Check if we have something to do?
  78. if (isset($_GET['approve']))
  79. $toAction[] = (int) $_GET['approve'];
  80. // Just a deletion?
  81. elseif (isset($_GET['delete']))
  82. $toAction[] = (int) $_GET['delete'];
  83. // Lots of approvals?
  84. elseif (isset($_POST['item']))
  85. foreach ($_POST['item'] as $item)
  86. $toAction[] = (int) $item;
  87. // What are we actually doing.
  88. if (isset($_GET['approve']) || (isset($_POST['do']) && $_POST['do'] == 'approve'))
  89. $curAction = 'approve';
  90. elseif (isset($_GET['delete']) || (isset($_POST['do']) && $_POST['do'] == 'delete'))
  91. $curAction = 'delete';
  92. // Right, so we have something to do?
  93. if (!empty($toAction) && isset($curAction))
  94. {
  95. checkSession('request');
  96. // Handy shortcut.
  97. $any_array = $curAction == 'approve' ? $approve_boards : $delete_any_boards;
  98. // Now for each message work out whether it's actually a topic, and what board it's on.
  99. $request = $smcFunc['db_query']('', '
  100. SELECT m.id_msg, m.id_member, m.id_board, m.subject, t.id_topic, t.id_first_msg, t.id_member_started
  101. FROM {db_prefix}messages AS m
  102. INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)
  103. LEFT JOIN {db_prefix}boards AS b ON (t.id_board = b.id_board)
  104. WHERE m.id_msg IN ({array_int:message_list})
  105. AND m.approved = {int:not_approved}
  106. AND {query_see_board}',
  107. array(
  108. 'message_list' => $toAction,
  109. 'not_approved' => 0,
  110. )
  111. );
  112. $toAction = array();
  113. $details = array();
  114. while ($row = $smcFunc['db_fetch_assoc']($request))
  115. {
  116. // If it's not within what our view is ignore it...
  117. if (($row['id_msg'] == $row['id_first_msg'] && $context['current_view'] != 'topics') || ($row['id_msg'] != $row['id_first_msg'] && $context['current_view'] != 'replies'))
  118. continue;
  119. $can_add = false;
  120. // If we're approving this is simple.
  121. if ($curAction == 'approve' && ($any_array == array(0) || in_array($row['id_board'], $any_array)))
  122. {
  123. $can_add = true;
  124. }
  125. // Delete requires more permission checks...
  126. elseif ($curAction == 'delete')
  127. {
  128. // Own post is easy!
  129. if ($row['id_member'] == $user_info['id'] && ($delete_own_boards == array(0) || in_array($row['id_board'], $delete_own_boards)))
  130. $can_add = true;
  131. // Is it a reply to their own topic?
  132. elseif ($row['id_member'] == $row['id_member_started'] && $row['id_msg'] != $row['id_first_msg'] && ($delete_own_replies == array(0) || in_array($row['id_board'], $delete_own_replies)))
  133. $can_add = true;
  134. // Someone elses?
  135. elseif ($row['id_member'] != $user_info['id'] && ($delete_any_boards == array(0) || in_array($row['id_board'], $delete_any_boards)))
  136. $can_add = true;
  137. }
  138. if ($can_add)
  139. $anItem = $context['current_view'] == 'topics' ? $row['id_topic'] : $row['id_msg'];
  140. $toAction[] = $anItem;
  141. // All clear. What have we got now, what, what?
  142. $details[$anItem] = array();
  143. $details[$anItem]["subject"] = $row['subject'];
  144. $details[$anItem]["topic"] = $row['id_topic'];
  145. $details[$anItem]["member"] = ($context['current_view'] == 'topics') ? $row['id_member_started'] : $row['id_member'];
  146. $details[$anItem]["board"] = $row['id_board'];
  147. }
  148. $smcFunc['db_free_result']($request);
  149. // If we have anything left we can actually do the approving (etc).
  150. if (!empty($toAction))
  151. {
  152. if ($curAction == 'approve')
  153. {
  154. approveMessages ($toAction, $details, $context['current_view']);
  155. }
  156. else
  157. {
  158. removeMessages ($toAction, $details, $context['current_view']);
  159. }
  160. }
  161. }
  162. // How many unapproved posts are there?
  163. $request = $smcFunc['db_query']('', '
  164. SELECT COUNT(*)
  165. FROM {db_prefix}messages AS m
  166. INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic AND t.id_first_msg != m.id_msg)
  167. INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
  168. WHERE m.approved = {int:not_approved}
  169. AND {query_see_board}
  170. ' . $approve_query,
  171. array(
  172. 'not_approved' => 0,
  173. )
  174. );
  175. list ($context['total_unapproved_posts']) = $smcFunc['db_fetch_row']($request);
  176. $smcFunc['db_free_result']($request);
  177. // What about topics? Normally we'd use the table alias t for topics but lets use m so we don't have to redo our approve query.
  178. $request = $smcFunc['db_query']('', '
  179. SELECT COUNT(m.id_topic)
  180. FROM {db_prefix}topics AS m
  181. INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
  182. WHERE m.approved = {int:not_approved}
  183. AND {query_see_board}
  184. ' . $approve_query,
  185. array(
  186. 'not_approved' => 0,
  187. )
  188. );
  189. list ($context['total_unapproved_topics']) = $smcFunc['db_fetch_row']($request);
  190. $smcFunc['db_free_result']($request);
  191. $context['page_index'] = constructPageIndex($scripturl . '?action=moderate;area=postmod;sa=' . $context['current_view'] . (isset($_REQUEST['brd']) ? ';brd=' . (int) $_REQUEST['brd'] : ''), $_GET['start'], $context['current_view'] == 'topics' ? $context['total_unapproved_topics'] : $context['total_unapproved_posts'], 10);
  192. $context['start'] = $_GET['start'];
  193. // We have enough to make some pretty tabs!
  194. $context[$context['moderation_menu_name']]['tab_data'] = array(
  195. 'title' => $txt['mc_unapproved_posts'],
  196. 'help' => 'postmod',
  197. 'description' => $txt['mc_unapproved_posts_desc'],
  198. );
  199. // Update the tabs with the correct number of posts.
  200. $context['menu_data_' . $context['moderation_menu_id']]['sections']['posts']['areas']['postmod']['subsections']['posts']['label'] .= ' (' . $context['total_unapproved_posts'] . ')';
  201. $context['menu_data_' . $context['moderation_menu_id']]['sections']['posts']['areas']['postmod']['subsections']['topics']['label'] .= ' (' . $context['total_unapproved_topics'] . ')';
  202. // If we are filtering some boards out then make sure to send that along with the links.
  203. if (isset($_REQUEST['brd']))
  204. {
  205. $context['menu_data_' . $context['moderation_menu_id']]['sections']['posts']['areas']['postmod']['subsections']['posts']['add_params'] = ';brd=' . (int) $_REQUEST['brd'];
  206. $context['menu_data_' . $context['moderation_menu_id']]['sections']['posts']['areas']['postmod']['subsections']['topics']['add_params'] = ';brd=' . (int) $_REQUEST['brd'];
  207. }
  208. // Get all unapproved posts.
  209. $request = $smcFunc['db_query']('', '
  210. SELECT m.id_msg, m.id_topic, m.id_board, m.subject, m.body, m.id_member,
  211. IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.smileys_enabled,
  212. t.id_member_started, t.id_first_msg, b.name AS board_name, c.id_cat, c.name AS cat_name
  213. FROM {db_prefix}messages AS m
  214. INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)
  215. INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
  216. LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
  217. LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)
  218. WHERE m.approved = {int:not_approved}
  219. AND t.id_first_msg ' . ($context['current_view'] == 'topics' ? '=' : '!=') . ' m.id_msg
  220. AND {query_see_board}
  221. ' . $approve_query . '
  222. LIMIT ' . $context['start'] . ', 10',
  223. array(
  224. 'not_approved' => 0,
  225. )
  226. );
  227. $context['unapproved_items'] = array();
  228. for ($i = 1; $row = $smcFunc['db_fetch_assoc']($request); $i++)
  229. {
  230. // Can delete is complicated, let's solve it first... is it their own post?
  231. if ($row['id_member'] == $user_info['id'] && ($delete_own_boards == array(0) || in_array($row['id_board'], $delete_own_boards)))
  232. $can_delete = true;
  233. // Is it a reply to their own topic?
  234. elseif ($row['id_member'] == $row['id_member_started'] && $row['id_msg'] != $row['id_first_msg'] && ($delete_own_replies == array(0) || in_array($row['id_board'], $delete_own_replies)))
  235. $can_delete = true;
  236. // Someone elses?
  237. elseif ($row['id_member'] != $user_info['id'] && ($delete_any_boards == array(0) || in_array($row['id_board'], $delete_any_boards)))
  238. $can_delete = true;
  239. else
  240. $can_delete = false;
  241. $context['unapproved_items'][] = array(
  242. 'id' => $row['id_msg'],
  243. 'alternate' => $i % 2,
  244. 'counter' => $context['start'] + $i,
  245. 'href' => $scripturl . '?topic=' . $row['id_topic'] . '.msg' . $row['id_msg'] . '#msg' . $row['id_msg'],
  246. 'subject' => $row['subject'],
  247. 'body' => parse_bbc($row['body'], $row['smileys_enabled'], $row['id_msg']),
  248. 'time' => timeformat($row['poster_time']),
  249. 'poster' => array(
  250. 'id' => $row['id_member'],
  251. 'name' => $row['poster_name'],
  252. 'link' => $row['id_member'] ? '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['poster_name'] . '</a>' : $row['poster_name'],
  253. 'href' => $scripturl . '?action=profile;u=' . $row['id_member'],
  254. ),
  255. 'topic' => array(
  256. 'id' => $row['id_topic'],
  257. ),
  258. 'board' => array(
  259. 'id' => $row['id_board'],
  260. 'name' => $row['board_name'],
  261. ),
  262. 'category' => array(
  263. 'id' => $row['id_cat'],
  264. 'name' => $row['cat_name'],
  265. ),
  266. 'can_delete' => $can_delete,
  267. );
  268. }
  269. $smcFunc['db_free_result']($request);
  270. $context['sub_template'] = 'unapproved_posts';
  271. }
  272. /**
  273. * View all unapproved attachments.
  274. */
  275. function UnapprovedAttachments()
  276. {
  277. global $txt, $scripturl, $context, $user_info, $sourcedir, $smcFunc;
  278. $context['page_title'] = $txt['mc_unapproved_attachments'];
  279. // Once again, permissions are king!
  280. $approve_boards = boardsAllowedTo('approve_posts');
  281. if ($approve_boards == array(0))
  282. $approve_query = '';
  283. elseif (!empty($approve_boards))
  284. $approve_query = ' AND m.id_board IN (' . implode(',', $approve_boards) . ')';
  285. else
  286. $approve_query = ' AND 0';
  287. // Get together the array of things to act on, if any.
  288. $attachments = array();
  289. if (isset($_GET['approve']))
  290. $attachments[] = (int) $_GET['approve'];
  291. elseif (isset($_GET['delete']))
  292. $attachments[] = (int) $_GET['delete'];
  293. elseif (isset($_POST['item']))
  294. foreach ($_POST['item'] as $item)
  295. $attachments[] = (int) $item;
  296. // Are we approving or deleting?
  297. if (isset($_GET['approve']) || (isset($_POST['do']) && $_POST['do'] == 'approve'))
  298. $curAction = 'approve';
  299. elseif (isset($_GET['delete']) || (isset($_POST['do']) && $_POST['do'] == 'delete'))
  300. $curAction = 'delete';
  301. // Something to do, let's do it!
  302. if (!empty($attachments) && isset($curAction))
  303. {
  304. checkSession('request');
  305. // This will be handy.
  306. require_once($sourcedir . '/ManageAttachments.php');
  307. // Confirm the attachments are eligible for changing!
  308. $request = $smcFunc['db_query']('', '
  309. SELECT a.id_attach
  310. FROM {db_prefix}attachments AS a
  311. INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
  312. LEFT JOIN {db_prefix}boards AS b ON (m.id_board = b.id_board)
  313. WHERE a.id_attach IN ({array_int:attachments})
  314. AND a.approved = {int:not_approved}
  315. AND a.attachment_type = {int:attachment_type}
  316. AND {query_see_board}
  317. ' . $approve_query,
  318. array(
  319. 'attachments' => $attachments,
  320. 'not_approved' => 0,
  321. 'attachment_type' => 0,
  322. )
  323. );
  324. $attachments = array();
  325. while ($row = $smcFunc['db_fetch_assoc']($request))
  326. $attachments[] = $row['id_attach'];
  327. $smcFunc['db_free_result']($request);
  328. // Assuming it wasn't all like, proper illegal, we can do the approving.
  329. if (!empty($attachments))
  330. {
  331. if ($curAction == 'approve')
  332. ApproveAttachments($attachments);
  333. else
  334. removeAttachments(array('id_attach' => $attachments));
  335. }
  336. }
  337. // How many unapproved attachments in total?
  338. $request = $smcFunc['db_query']('', '
  339. SELECT COUNT(*)
  340. FROM {db_prefix}attachments AS a
  341. INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
  342. INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
  343. WHERE a.approved = {int:not_approved}
  344. AND a.attachment_type = {int:attachment_type}
  345. AND {query_see_board}
  346. ' . $approve_query,
  347. array(
  348. 'not_approved' => 0,
  349. 'attachment_type' => 0,
  350. )
  351. );
  352. list ($context['total_unapproved_attachments']) = $smcFunc['db_fetch_row']($request);
  353. $smcFunc['db_free_result']($request);
  354. $context['page_index'] = constructPageIndex($scripturl . '?action=moderate;area=attachmod;sa=attachments', $_GET['start'], $context['total_unapproved_attachments'], 10);
  355. $context['start'] = $_GET['start'];
  356. // Get all unapproved attachments.
  357. $request = $smcFunc['db_query']('', '
  358. SELECT a.id_attach, a.filename, a.size, m.id_msg, m.id_topic, m.id_board, m.subject, m.body, m.id_member,
  359. IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time,
  360. t.id_member_started, t.id_first_msg, b.name AS board_name, c.id_cat, c.name AS cat_name
  361. FROM {db_prefix}attachments AS a
  362. INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
  363. INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)
  364. INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
  365. LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
  366. LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)
  367. WHERE a.approved = {int:not_approved}
  368. AND a.attachment_type = {int:attachment_type}
  369. AND {query_see_board}
  370. ' . $approve_query . '
  371. LIMIT ' . $context['start'] . ', 10',
  372. array(
  373. 'not_approved' => 0,
  374. 'attachment_type' => 0,
  375. )
  376. );
  377. $context['unapproved_items'] = array();
  378. for ($i = 1; $row = $smcFunc['db_fetch_assoc']($request); $i++)
  379. {
  380. $context['unapproved_items'][] = array(
  381. 'id' => $row['id_attach'],
  382. 'alternate' => $i % 2,
  383. 'filename' => $row['filename'],
  384. 'size' => round($row['size'] / 1024, 2),
  385. 'time' => timeformat($row['poster_time']),
  386. 'poster' => array(
  387. 'id' => $row['id_member'],
  388. 'name' => $row['poster_name'],
  389. 'link' => $row['id_member'] ? '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['poster_name'] . '</a>' : $row['poster_name'],
  390. 'href' => $scripturl . '?action=profile;u=' . $row['id_member'],
  391. ),
  392. 'message' => array(
  393. 'id' => $row['id_msg'],
  394. 'subject' => $row['subject'],
  395. 'body' => parse_bbc($row['body']),
  396. 'time' => timeformat($row['poster_time']),
  397. 'href' => $scripturl . '?topic=' . $row['id_topic'] . '.msg' . $row['id_msg'] . '#msg' . $row['id_msg'],
  398. ),
  399. 'topic' => array(
  400. 'id' => $row['id_topic'],
  401. ),
  402. 'board' => array(
  403. 'id' => $row['id_board'],
  404. 'name' => $row['board_name'],
  405. ),
  406. 'category' => array(
  407. 'id' => $row['id_cat'],
  408. 'name' => $row['cat_name'],
  409. ),
  410. );
  411. }
  412. $smcFunc['db_free_result']($request);
  413. $context['sub_template'] = 'unapproved_attachments';
  414. }
  415. /**
  416. * Approve a post, just the one.
  417. */
  418. function ApproveMessage()
  419. {
  420. global $user_info, $topic, $board, $sourcedir, $smcFunc;
  421. checkSession('get');
  422. $_REQUEST['msg'] = (int) $_REQUEST['msg'];
  423. require_once($sourcedir . '/Subs-Post.php');
  424. isAllowedTo('approve_posts');
  425. $request = $smcFunc['db_query']('', '
  426. SELECT t.id_member_started, t.id_first_msg, m.id_member, m.subject, m.approved
  427. FROM {db_prefix}messages AS m
  428. INNER JOIN {db_prefix}topics AS t ON (t.id_topic = {int:current_topic})
  429. WHERE m.id_msg = {int:id_msg}
  430. AND m.id_topic = {int:current_topic}
  431. LIMIT 1',
  432. array(
  433. 'current_topic' => $topic,
  434. 'id_msg' => $_REQUEST['msg'],
  435. )
  436. );
  437. list ($starter, $first_msg, $poster, $subject, $approved) = $smcFunc['db_fetch_row']($request);
  438. $smcFunc['db_free_result']($request);
  439. // If it's the first in a topic then the whole topic gets approved!
  440. if ($first_msg == $_REQUEST['msg'])
  441. {
  442. approveTopics($topic, !$approved);
  443. if ($starter != $user_info['id'])
  444. logAction('approve_topic', array('topic' => $topic, 'subject' => $subject, 'member' => $starter, 'board' => $board));
  445. }
  446. else
  447. {
  448. approvePosts($_REQUEST['msg'], !$approved);
  449. if ($poster != $user_info['id'])
  450. logAction('approve', array('topic' => $topic, 'subject' => $subject, 'member' => $poster, 'board' => $board));
  451. }
  452. redirectexit('topic=' . $topic . '.msg' . $_REQUEST['msg']. '#msg' . $_REQUEST['msg']);
  453. }
  454. /**
  455. * Approve a batch of posts (or topics in their own right)
  456. *
  457. * @param $messages
  458. * @param $messageDetails
  459. * @param $current_view
  460. */
  461. function approveMessages($messages, $messageDetails, $current_view = 'replies')
  462. {
  463. global $sourcedir;
  464. require_once($sourcedir . '/Subs-Post.php');
  465. if ($current_view == 'topics')
  466. {
  467. approveTopics($messages);
  468. // and tell the world about it
  469. foreach ($messages as $topic)
  470. {
  471. logAction('approve_topic', array('topic' => $topic, 'subject' => $messageDetails[$topic]['subject'], 'member' => $messageDetails[$topic]['member'], 'board' => $messageDetails[$topic]['board']));
  472. }
  473. }
  474. else
  475. {
  476. approvePosts($messages);
  477. // and tell the world about it again
  478. foreach ($messages as $post)
  479. {
  480. logAction('approve', array('topic' => $messageDetails[$post]['topic'], 'subject' => $messageDetails[$post]['subject'], 'member' => $messageDetails[$post]['member'], 'board' => $messageDetails[$post]['board']));
  481. }
  482. }
  483. }
  484. /**
  485. * This is a helper function - basically approve everything!
  486. */
  487. function approveAllData()
  488. {
  489. global $smcFunc, $sourcedir;
  490. // Start with messages and topics.
  491. $request = $smcFunc['db_query']('', '
  492. SELECT id_msg
  493. FROM {db_prefix}messages
  494. WHERE approved = {int:not_approved}',
  495. array(
  496. 'not_approved' => 0,
  497. )
  498. );
  499. $msgs = array();
  500. while ($row = $smcFunc['db_fetch_row']($request))
  501. $msgs[] = $row[0];
  502. $smcFunc['db_free_result']($request);
  503. if (!empty($msgs))
  504. {
  505. require_once($sourcedir . '/Subs-Post.php');
  506. approvePosts($msgs);
  507. }
  508. // Now do attachments
  509. $request = $smcFunc['db_query']('', '
  510. SELECT id_attach
  511. FROM {db_prefix}attachments
  512. WHERE approved = {int:not_approved}',
  513. array(
  514. 'not_approved' => 0,
  515. )
  516. );
  517. $attaches = array();
  518. while ($row = $smcFunc['db_fetch_row']($request))
  519. $attaches[] = $row[0];
  520. $smcFunc['db_free_result']($request);
  521. if (!empty($attaches))
  522. {
  523. require_once($sourcedir . '/ManageAttachments.php');
  524. ApproveAttachments($attaches);
  525. }
  526. }
  527. /**
  528. * Remove a batch of messages (or topics)
  529. *
  530. * @param array $messages
  531. * @param array $messageDetails
  532. * @param string $current_view
  533. */
  534. function removeMessages($messages, $messageDetails, $current_view = 'replies')
  535. {
  536. global $sourcedir, $modSettings;
  537. require_once($sourcedir . '/RemoveTopic.php');
  538. if ($current_view == 'topics')
  539. {
  540. removeTopics($messages);
  541. // and tell the world about it
  542. foreach ($messages as $topic)
  543. // Note, only log topic ID in native form if it's not gone forever.
  544. logAction('remove', array(
  545. (empty($modSettings['recycle_enable']) || $modSettings['recycle_board'] != $messageDetails[$topic]['board'] ? 'topic' : 'old_topic_id') => $topic, 'subject' => $messageDetails[$topic]['subject'], 'member' => $messageDetails[$topic]['member'], 'board' => $messageDetails[$topic]['board']));
  546. }
  547. else
  548. {
  549. foreach ($messages as $post)
  550. {
  551. removeMessage($post);
  552. logAction('delete', array(
  553. (empty($modSettings['recycle_enable']) || $modSettings['recycle_board'] != $messageDetails[$post]['board'] ? 'topic' : 'old_topic_id') => $messageDetails[$post]['topic'], 'subject' => $messageDetails[$post]['subject'], 'member' => $messageDetails[$post]['member'], 'board' => $messageDetails[$post]['board']));
  554. }
  555. }
  556. }
  557. ?>