ManageNews.php 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104
  1. <?php
  2. /**
  3. * This file manages... the news. :P
  4. *
  5. * Simple Machines Forum (SMF)
  6. *
  7. * @package SMF
  8. * @author Simple Machines http://www.simplemachines.org
  9. * @copyright 2014 Simple Machines and individual contributors
  10. * @license http://www.simplemachines.org/about/smf/license.php BSD
  11. *
  12. * @version 2.1 Alpha 1
  13. */
  14. if (!defined('SMF'))
  15. die('No direct access...');
  16. /**
  17. * The news dispatcher; doesn't do anything, just delegates.
  18. * This is the entrance point for all News and Newsletter screens.
  19. * Called by ?action=admin;area=news.
  20. * It does the permission checks, and calls the appropriate function
  21. * based on the requested sub-action.
  22. */
  23. function ManageNews()
  24. {
  25. global $context, $txt, $scripturl;
  26. // First, let's do a quick permissions check for the best error message possible.
  27. isAllowedTo(array('edit_news', 'send_mail', 'admin_forum'));
  28. loadTemplate('ManageNews');
  29. // Format: 'sub-action' => array('function', 'permission')
  30. $subActions = array(
  31. 'editnews' => array('EditNews', 'edit_news'),
  32. 'mailingmembers' => array('SelectMailingMembers', 'send_mail'),
  33. 'mailingcompose' => array('ComposeMailing', 'send_mail'),
  34. 'mailingsend' => array('SendMailing', 'send_mail'),
  35. 'settings' => array('ModifyNewsSettings', 'admin_forum'),
  36. );
  37. call_integration_hook('integrate_manage_news', array(&$subActions));
  38. // Default to sub action 'main' or 'settings' depending on permissions.
  39. $_REQUEST['sa'] = isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']]) ? $_REQUEST['sa'] : (allowedTo('edit_news') ? 'editnews' : (allowedTo('send_mail') ? 'mailingmembers' : 'settings'));
  40. // Have you got the proper permissions?
  41. isAllowedTo($subActions[$_REQUEST['sa']][1]);
  42. // Create the tabs for the template.
  43. $context[$context['admin_menu_name']]['tab_data'] = array(
  44. 'title' => $txt['news_title'],
  45. 'help' => 'edit_news',
  46. 'description' => $txt['admin_news_desc'],
  47. 'tabs' => array(
  48. 'editnews' => array(
  49. ),
  50. 'mailingmembers' => array(
  51. 'description' => $txt['news_mailing_desc'],
  52. ),
  53. 'settings' => array(
  54. 'description' => $txt['news_settings_desc'],
  55. ),
  56. ),
  57. );
  58. // Force the right area...
  59. if (substr($_REQUEST['sa'], 0, 7) == 'mailing')
  60. $context[$context['admin_menu_name']]['current_subsection'] = 'mailingmembers';
  61. $subActions[$_REQUEST['sa']][0]();
  62. }
  63. /**
  64. * Let the administrator(s) edit the news items for the forum.
  65. * It writes an entry into the moderation log.
  66. * This function uses the edit_news administration area.
  67. * Called by ?action=admin;area=news.
  68. * Requires the edit_news permission.
  69. * Can be accessed with ?action=admin;sa=editnews.
  70. *
  71. * @uses ManageNews template, edit_news sub template.
  72. */
  73. function EditNews()
  74. {
  75. global $txt, $modSettings, $context, $sourcedir, $scripturl;
  76. global $smcFunc;
  77. require_once($sourcedir . '/Subs-Post.php');
  78. // The 'remove selected' button was pressed.
  79. if (!empty($_POST['delete_selection']) && !empty($_POST['remove']))
  80. {
  81. checkSession();
  82. // Store the news temporarily in this array.
  83. $temp_news = explode("\n", $modSettings['news']);
  84. // Remove the items that were selected.
  85. foreach ($temp_news as $i => $news)
  86. if (in_array($i, $_POST['remove']))
  87. unset($temp_news[$i]);
  88. // Update the database.
  89. updateSettings(array('news' => implode("\n", $temp_news)));
  90. $context['saved_successful'] = true;
  91. logAction('news');
  92. }
  93. // The 'Save' button was pressed.
  94. elseif (!empty($_POST['save_items']))
  95. {
  96. checkSession();
  97. foreach ($_POST['news'] as $i => $news)
  98. {
  99. if (trim($news) == '')
  100. unset($_POST['news'][$i]);
  101. else
  102. {
  103. $_POST['news'][$i] = $smcFunc['htmlspecialchars']($_POST['news'][$i], ENT_QUOTES);
  104. preparsecode($_POST['news'][$i]);
  105. }
  106. }
  107. // Send the new news to the database.
  108. updateSettings(array('news' => implode("\n", $_POST['news'])));
  109. $context['saved_successful'] = true;
  110. // Log this into the moderation log.
  111. logAction('news');
  112. }
  113. // We're going to want this for making our list.
  114. require_once($sourcedir . '/Subs-List.php');
  115. $context['page_title'] = $txt['admin_edit_news'];
  116. // Use the standard templates for showing this.
  117. $listOptions = array(
  118. 'id' => 'news_lists',
  119. 'get_items' => array(
  120. 'function' => 'list_getNews',
  121. ),
  122. 'columns' => array(
  123. 'news' => array(
  124. 'header' => array(
  125. 'value' => $txt['admin_edit_news'],
  126. ),
  127. 'data' => array(
  128. 'function' => create_function('$news', '
  129. if (is_numeric($news[\'id\']))
  130. return \'<textarea id="data_\' . $news[\'id\'] . \'" rows="3" cols="50" name="news[]" style="\' . (isBrowser(\'is_ie8\') ? \'width: 635px; max-width: 85%; min-width: 85%\' : \'width 100%;margin 0 5em\') . \';">\' . $news[\'unparsed\'] . \'</textarea>
  131. <br>
  132. <div class="floatleft" id="preview_\' . $news[\'id\'] . \'"></div>\';
  133. else
  134. return $news[\'unparsed\'];
  135. '),
  136. 'style' => 'width: 50%;',
  137. ),
  138. ),
  139. 'preview' => array(
  140. 'header' => array(
  141. 'value' => $txt['preview'],
  142. ),
  143. 'data' => array(
  144. 'function' => create_function('$news', '
  145. return \'<div id="box_preview_\' . $news[\'id\'] . \'" style="overflow: auto; width: 100%; height: 10ex;">\' . $news[\'parsed\'] . \'</div>\';
  146. '),
  147. 'style' => 'width: 45%;',
  148. ),
  149. ),
  150. 'check' => array(
  151. 'header' => array(
  152. 'value' => '<input type="checkbox" onclick="invertAll(this, this.form);" class="input_check">',
  153. 'class' => 'centercol',
  154. ),
  155. 'data' => array(
  156. 'function' => create_function('$news', '
  157. if (is_numeric($news[\'id\']))
  158. return \'<input type="checkbox" name="remove[]" value="\' . $news[\'id\'] . \'" class="input_check">\';
  159. else
  160. return \'\';
  161. '),
  162. 'class' => 'centercol',
  163. ),
  164. ),
  165. ),
  166. 'form' => array(
  167. 'href' => $scripturl . '?action=admin;area=news;sa=editnews',
  168. 'hidden_fields' => array(
  169. $context['session_var'] => $context['session_id'],
  170. ),
  171. ),
  172. 'additional_rows' => array(
  173. array(
  174. 'position' => 'bottom_of_list',
  175. 'value' => '
  176. <span id="moreNewsItems_link" class="floatleft" style="display: none;">
  177. <a class="button_link" href="javascript:void(0);" onclick="addNewsItem(); return false;">' . $txt['editnews_clickadd'] . '</a>
  178. </span>
  179. <input type="submit" name="save_items" value="' . $txt['save'] . '" class="button_submit">
  180. <input type="submit" name="delete_selection" value="' . $txt['editnews_remove_selected'] . '" onclick="return confirm(\'' . $txt['editnews_remove_confirm'] . '\');" class="button_submit">',
  181. ),
  182. ),
  183. 'javascript' => '
  184. document.getElementById(\'list_news_lists_last\').style.display = "none";
  185. document.getElementById("moreNewsItems_link").style.display = "";
  186. var last_preview = 0;
  187. $(document).ready(function () {
  188. $("div[id ^= \'preview_\']").each(function () {
  189. var preview_id = $(this).attr(\'id\').split(\'_\')[1];
  190. if (last_preview < preview_id)
  191. last_preview = preview_id;
  192. make_preview_btn(preview_id);
  193. });
  194. });
  195. function make_preview_btn (preview_id)
  196. {
  197. $("#preview_" + preview_id).addClass("button_link");
  198. $("#preview_" + preview_id).text(\'' . $txt['preview'] . '\').click(function () {
  199. $.ajax({
  200. type: "POST",
  201. url: "' . $scripturl . '?action=xmlhttp;sa=previews;xml",
  202. data: {item: "newspreview", news: $("#data_" + preview_id).val()},
  203. context: document.body,
  204. success: function(request){
  205. if ($(request).find("error").text() == \'\')
  206. $(document).find("#box_preview_" + preview_id).html($(request).text());
  207. else
  208. $(document).find("#box_preview_" + preview_id).text(\'' . $txt['news_error_no_news'] . '\');
  209. },
  210. });
  211. });
  212. }
  213. function addNewsItem ()
  214. {
  215. last_preview++;
  216. $("#list_news_lists_last").before(' . javaScriptEscape('
  217. <tr class="windowbg') . ' + (last_preview % 2 == 0 ? \'\' : \'2\') + ' . javaScriptEscape('">
  218. <td style="width: 50%;">
  219. <textarea id="data_') . ' + last_preview + ' . javaScriptEscape('" rows="3" cols="65" name="news[]" style="' . (isBrowser('is_ie8') ? 'width: 635px; max-width: 85%; min-width: 85%' : 'width: 95%') . ';"></textarea>
  220. <br>
  221. <div class="floatleft" id="preview_') . ' + last_preview + ' . javaScriptEscape('"></div>
  222. </td>
  223. <td style="width: 45%;">
  224. <div id="box_preview_') . ' + last_preview + ' . javaScriptEscape('" style="overflow: auto; width: 100%; height: 10ex;"></div>
  225. </td>
  226. <td></td>
  227. </tr>') . ');
  228. make_preview_btn(last_preview);
  229. }',
  230. );
  231. // Create the request list.
  232. createList($listOptions);
  233. // And go!
  234. loadTemplate('ManageNews');
  235. $context['sub_template'] = 'news_lists';
  236. }
  237. /**
  238. * Prepares an array of the forum news items for display in the template
  239. *
  240. * @return array
  241. */
  242. function list_getNews()
  243. {
  244. global $modSettings;
  245. $admin_current_news = array();
  246. // Ready the current news.
  247. foreach (explode("\n", $modSettings['news']) as $id => $line)
  248. $admin_current_news[$id] = array(
  249. 'id' => $id,
  250. 'unparsed' => un_preparsecode($line),
  251. 'parsed' => preg_replace('~<([/]?)form[^>]*?[>]*>~i', '<em class="smalltext">&lt;$1form&gt;</em>', parse_bbc($line)),
  252. );
  253. $admin_current_news['last'] = array(
  254. 'id' => 'last',
  255. 'unparsed' => '<div id="moreNewsItems"></div>
  256. <noscript><textarea rows="3" cols="65" name="news[]" style="' . (isBrowser('is_ie8') ? 'width: 635px; max-width: 85%; min-width: 85%' : 'width: 85%') . ';"></textarea></noscript>',
  257. 'parsed' => '<div id="moreNewsItems_preview"></div>',
  258. );
  259. return $admin_current_news;
  260. }
  261. /**
  262. * This function allows a user to select the membergroups to send their
  263. * mailing to.
  264. * Called by ?action=admin;area=news;sa=mailingmembers.
  265. * Requires the send_mail permission.
  266. * Form is submitted to ?action=admin;area=news;mailingcompose.
  267. *
  268. * @uses the ManageNews template and email_members sub template.
  269. */
  270. function SelectMailingMembers()
  271. {
  272. global $txt, $context, $modSettings, $smcFunc;
  273. // Is there any confirm message?
  274. $context['newsletter_sent'] = isset($_SESSION['newsletter_sent']) ? $_SESSION['newsletter_sent'] : '';
  275. $context['page_title'] = $txt['admin_newsletters'];
  276. $context['sub_template'] = 'email_members';
  277. $context['groups'] = array();
  278. $postGroups = array();
  279. $normalGroups = array();
  280. // If we have post groups disabled then we need to give a "ungrouped members" option.
  281. if (empty($modSettings['permission_enable_postgroups']))
  282. {
  283. $context['groups'][0] = array(
  284. 'id' => 0,
  285. 'name' => $txt['membergroups_members'],
  286. 'member_count' => 0,
  287. );
  288. $normalGroups[0] = 0;
  289. }
  290. // Get all the extra groups as well as Administrator and Global Moderator.
  291. $request = $smcFunc['db_query']('', '
  292. SELECT mg.id_group, mg.group_name, mg.min_posts
  293. FROM {db_prefix}membergroups AS mg' . (empty($modSettings['permission_enable_postgroups']) ? '
  294. WHERE mg.min_posts = {int:min_posts}' : '') . '
  295. GROUP BY mg.id_group, mg.min_posts, mg.group_name
  296. ORDER BY mg.min_posts, CASE WHEN mg.id_group < {int:newbie_group} THEN mg.id_group ELSE 4 END, mg.group_name',
  297. array(
  298. 'min_posts' => -1,
  299. 'newbie_group' => 4,
  300. )
  301. );
  302. while ($row = $smcFunc['db_fetch_assoc']($request))
  303. {
  304. $context['groups'][$row['id_group']] = array(
  305. 'id' => $row['id_group'],
  306. 'name' => $row['group_name'],
  307. 'member_count' => 0,
  308. );
  309. if ($row['min_posts'] == -1)
  310. $normalGroups[$row['id_group']] = $row['id_group'];
  311. else
  312. $postGroups[$row['id_group']] = $row['id_group'];
  313. }
  314. $smcFunc['db_free_result']($request);
  315. // If we have post groups, let's count the number of members...
  316. if (!empty($postGroups))
  317. {
  318. $query = $smcFunc['db_query']('', '
  319. SELECT mem.id_post_group AS id_group, COUNT(*) AS member_count
  320. FROM {db_prefix}members AS mem
  321. WHERE mem.id_post_group IN ({array_int:post_group_list})
  322. GROUP BY mem.id_post_group',
  323. array(
  324. 'post_group_list' => $postGroups,
  325. )
  326. );
  327. while ($row = $smcFunc['db_fetch_assoc']($query))
  328. $context['groups'][$row['id_group']]['member_count'] += $row['member_count'];
  329. $smcFunc['db_free_result']($query);
  330. }
  331. if (!empty($normalGroups))
  332. {
  333. // Find people who are members of this group...
  334. $query = $smcFunc['db_query']('', '
  335. SELECT id_group, COUNT(*) AS member_count
  336. FROM {db_prefix}members
  337. WHERE id_group IN ({array_int:normal_group_list})
  338. GROUP BY id_group',
  339. array(
  340. 'normal_group_list' => $normalGroups,
  341. )
  342. );
  343. while ($row = $smcFunc['db_fetch_assoc']($query))
  344. $context['groups'][$row['id_group']]['member_count'] += $row['member_count'];
  345. $smcFunc['db_free_result']($query);
  346. // Also do those who have it as an additional membergroup - this ones more yucky...
  347. $query = $smcFunc['db_query']('', '
  348. SELECT mg.id_group, COUNT(*) AS member_count
  349. FROM {db_prefix}membergroups AS mg
  350. INNER JOIN {db_prefix}members AS mem ON (mem.additional_groups != {string:blank_string}
  351. AND mem.id_group != mg.id_group
  352. AND FIND_IN_SET(mg.id_group, mem.additional_groups) != 0)
  353. WHERE mg.id_group IN ({array_int:normal_group_list})
  354. GROUP BY mg.id_group',
  355. array(
  356. 'normal_group_list' => $normalGroups,
  357. 'blank_string' => '',
  358. )
  359. );
  360. while ($row = $smcFunc['db_fetch_assoc']($query))
  361. $context['groups'][$row['id_group']]['member_count'] += $row['member_count'];
  362. $smcFunc['db_free_result']($query);
  363. }
  364. // Any moderators?
  365. $request = $smcFunc['db_query']('', '
  366. SELECT COUNT(DISTINCT id_member) AS num_distinct_mods
  367. FROM {db_prefix}moderators
  368. LIMIT 1',
  369. array(
  370. )
  371. );
  372. list ($context['groups'][3]['member_count']) = $smcFunc['db_fetch_row']($request);
  373. $smcFunc['db_free_result']($request);
  374. $context['can_send_pm'] = allowedTo('pm_send');
  375. loadJavascriptFile('suggest.js', array('default_theme' => true, 'defer' => false), 'smf_suggest');
  376. }
  377. /**
  378. * Prepare subject and message of an email for the preview box
  379. * Used in ComposeMailing and RetrievePreview (Xml.php)
  380. */
  381. function prepareMailingForPreview ()
  382. {
  383. global $context, $smcFunc, $modSettings, $scripturl, $user_info, $txt;
  384. loadLanguage('Errors');
  385. $processing = array('preview_subject' => 'subject', 'preview_message' => 'message');
  386. // Use the default time format.
  387. $user_info['time_format'] = $modSettings['time_format'];
  388. $variables = array(
  389. '{$board_url}',
  390. '{$current_time}',
  391. '{$latest_member.link}',
  392. '{$latest_member.id}',
  393. '{$latest_member.name}'
  394. );
  395. $html = $context['send_html'];
  396. // We might need this in a bit
  397. $cleanLatestMember = empty($context['send_html']) || $context['send_pm'] ? un_htmlspecialchars($modSettings['latestRealName']) : $modSettings['latestRealName'];
  398. foreach ($processing as $key => $post)
  399. {
  400. $context[$key] = !empty($_REQUEST[$post]) ? $_REQUEST[$post] : '';
  401. if (empty($context[$key]) && empty($_REQUEST['xml']))
  402. $context['post_error']['messages'][] = $txt['error_no_' . $post];
  403. elseif (!empty($_REQUEST['xml']))
  404. continue;
  405. preparsecode($context[$key]);
  406. if ($html)
  407. {
  408. $enablePostHTML = $modSettings['enablePostHTML'];
  409. $modSettings['enablePostHTML'] = $context['send_html'];
  410. $context[$key] = parse_bbc($context[$key]);
  411. $modSettings['enablePostHTML'] = $enablePostHTML;
  412. }
  413. // Replace in all the standard things.
  414. $context[$key] = str_replace($variables,
  415. array(
  416. !empty($context['send_html']) ? '<a href="' . $scripturl . '">' . $scripturl . '</a>' : $scripturl,
  417. timeformat(forum_time(), false),
  418. !empty($context['send_html']) ? '<a href="' . $scripturl . '?action=profile;u=' . $modSettings['latestMember'] . '">' . $cleanLatestMember . '</a>' : ($context['send_pm'] ? '[url=' . $scripturl . '?action=profile;u=' . $modSettings['latestMember'] . ']' . $cleanLatestMember . '[/url]' : $cleanLatestMember),
  419. $modSettings['latestMember'],
  420. $cleanLatestMember
  421. ), $context[$key]);
  422. }
  423. }
  424. /**
  425. * Shows a form to edit a forum mailing and its recipients.
  426. * Called by ?action=admin;area=news;sa=mailingcompose.
  427. * Requires the send_mail permission.
  428. * Form is submitted to ?action=admin;area=news;sa=mailingsend.
  429. *
  430. * @uses ManageNews template, email_members_compose sub-template.
  431. */
  432. function ComposeMailing()
  433. {
  434. global $txt, $sourcedir, $context, $smcFunc, $scripturl;
  435. // Setup the template!
  436. $context['page_title'] = $txt['admin_newsletters'];
  437. $context['sub_template'] = 'email_members_compose';
  438. $context['subject'] = !empty($_POST['subject']) ? $_POST['subject'] : $smcFunc['htmlspecialchars']($context['forum_name'] . ': ' . $txt['subject']);
  439. $context['message'] = !empty($_POST['message']) ? $_POST['message'] : $smcFunc['htmlspecialchars']($txt['message'] . "\n\n" . $txt['regards_team'] . "\n\n" . '{$board_url}');
  440. // Needed for the WYSIWYG editor.
  441. require_once($sourcedir . '/Subs-Editor.php');
  442. // Now create the editor.
  443. $editorOptions = array(
  444. 'id' => 'message',
  445. 'value' => $context['message'],
  446. 'height' => '175px',
  447. 'width' => '100%',
  448. 'labels' => array(
  449. 'post_button' => $txt['sendtopic_send'],
  450. ),
  451. 'preview_type' => 2,
  452. 'required' => true,
  453. );
  454. create_control_richedit($editorOptions);
  455. // Store the ID for old compatibility.
  456. $context['post_box_name'] = $editorOptions['id'];
  457. if (isset($context['preview']))
  458. {
  459. require_once($sourcedir . '/Subs-Post.php');
  460. $context['recipients']['members'] = !empty($_POST['members']) ? explode(',', $_POST['members']) : array();
  461. $context['recipients']['exclude_members'] = !empty($_POST['exclude_members']) ? explode(',', $_POST['exclude_members']) : array();
  462. $context['recipients']['groups'] = !empty($_POST['groups']) ? explode(',', $_POST['groups']) : array();
  463. $context['recipients']['exclude_groups'] = !empty($_POST['exclude_groups']) ? explode(',', $_POST['exclude_groups']) : array();
  464. $context['recipients']['emails'] = !empty($_POST['emails']) ? explode(';', $_POST['emails']) : array();
  465. $context['email_force'] = !empty($_POST['email_force']) ? 1 : 0;
  466. $context['total_emails'] = !empty($_POST['total_emails']) ? (int) $_POST['total_emails'] : 0;
  467. $context['send_pm'] = !empty($_POST['send_pm']) ? 1 : 0;
  468. $context['send_html'] = !empty($_POST['send_html']) ? '1' : '0';
  469. return prepareMailingForPreview();
  470. }
  471. // Start by finding any members!
  472. $toClean = array();
  473. if (!empty($_POST['members']))
  474. $toClean[] = 'members';
  475. if (!empty($_POST['exclude_members']))
  476. $toClean[] = 'exclude_members';
  477. if (!empty($toClean))
  478. {
  479. require_once($sourcedir . '/Subs-Auth.php');
  480. foreach ($toClean as $type)
  481. {
  482. // Remove the quotes.
  483. $_POST[$type] = strtr($_POST[$type], array('\\"' => '"'));
  484. preg_match_all('~"([^"]+)"~', $_POST[$type], $matches);
  485. $_POST[$type] = array_unique(array_merge($matches[1], explode(',', preg_replace('~"[^"]+"~', '', $_POST[$type]))));
  486. foreach ($_POST[$type] as $index => $member)
  487. if (strlen(trim($member)) > 0)
  488. $_POST[$type][$index] = $smcFunc['htmlspecialchars']($smcFunc['strtolower'](trim($member)));
  489. else
  490. unset($_POST[$type][$index]);
  491. // Find the members
  492. $_POST[$type] = implode(',', array_keys(findMembers($_POST[$type])));
  493. }
  494. }
  495. if (isset($_POST['member_list']) && is_array($_POST['member_list']))
  496. {
  497. $members = array();
  498. foreach ($_POST['member_list'] as $member_id)
  499. $members[] = (int) $member_id;
  500. $_POST['members'] = implode(',', $members);
  501. }
  502. if (isset($_POST['exclude_member_list']) && is_array($_POST['exclude_member_list']))
  503. {
  504. $members = array();
  505. foreach ($_POST['exclude_member_list'] as $member_id)
  506. $members[] = (int) $member_id;
  507. $_POST['exclude_members'] = implode(',', $members);
  508. }
  509. // Clean the other vars.
  510. SendMailing(true);
  511. // We need a couple strings from the email template file
  512. loadLanguage('EmailTemplates');
  513. // Get a list of all full banned users. Use their Username and email to find them. Only get the ones that can't login to turn off notification.
  514. $request = $smcFunc['db_query']('', '
  515. SELECT DISTINCT mem.id_member
  516. FROM {db_prefix}ban_groups AS bg
  517. INNER JOIN {db_prefix}ban_items AS bi ON (bg.id_ban_group = bi.id_ban_group)
  518. INNER JOIN {db_prefix}members AS mem ON (bi.id_member = mem.id_member)
  519. WHERE (bg.cannot_access = {int:cannot_access} OR bg.cannot_login = {int:cannot_login})
  520. AND (bg.expire_time IS NULL OR bg.expire_time > {int:current_time})',
  521. array(
  522. 'cannot_access' => 1,
  523. 'cannot_login' => 1,
  524. 'current_time' => time(),
  525. )
  526. );
  527. while ($row = $smcFunc['db_fetch_assoc']($request))
  528. $context['recipients']['exclude_members'][] = $row['id_member'];
  529. $smcFunc['db_free_result']($request);
  530. $request = $smcFunc['db_query']('', '
  531. SELECT DISTINCT bi.email_address
  532. FROM {db_prefix}ban_items AS bi
  533. INNER JOIN {db_prefix}ban_groups AS bg ON (bg.id_ban_group = bi.id_ban_group)
  534. WHERE (bg.cannot_access = {int:cannot_access} OR bg.cannot_login = {int:cannot_login})
  535. AND (COALESCE(bg.expire_time, 1=1) OR bg.expire_time > {int:current_time})
  536. AND bi.email_address != {string:blank_string}',
  537. array(
  538. 'cannot_access' => 1,
  539. 'cannot_login' => 1,
  540. 'current_time' => time(),
  541. 'blank_string' => '',
  542. )
  543. );
  544. $condition_array = array();
  545. $condition_array_params = array();
  546. $count = 0;
  547. while ($row = $smcFunc['db_fetch_assoc']($request))
  548. {
  549. $condition_array[] = '{string:email_' . $count . '}';
  550. $condition_array_params['email_' . $count++] = $row['email_address'];
  551. }
  552. $smcFunc['db_free_result']($request);
  553. if (!empty($condition_array))
  554. {
  555. $request = $smcFunc['db_query']('', '
  556. SELECT id_member
  557. FROM {db_prefix}members
  558. WHERE email_address IN(' . implode(', ', $condition_array) .')',
  559. $condition_array_params
  560. );
  561. while ($row = $smcFunc['db_fetch_assoc']($request))
  562. $context['recipients']['exclude_members'][] = $row['id_member'];
  563. $smcFunc['db_free_result']($request);
  564. }
  565. // Did they select moderators - if so add them as specific members...
  566. if ((!empty($context['recipients']['groups']) && in_array(3, $context['recipients']['groups'])) || (!empty($context['recipients']['exclude_groups']) && in_array(3, $context['recipients']['exclude_groups'])))
  567. {
  568. $request = $smcFunc['db_query']('', '
  569. SELECT DISTINCT mem.id_member AS identifier
  570. FROM {db_prefix}members AS mem
  571. INNER JOIN {db_prefix}moderators AS mods ON (mods.id_member = mem.id_member)
  572. WHERE mem.is_activated = {int:is_activated}',
  573. array(
  574. 'is_activated' => 1,
  575. )
  576. );
  577. while ($row = $smcFunc['db_fetch_assoc']($request))
  578. {
  579. if (in_array(3, $context['recipients']))
  580. $context['recipients']['exclude_members'][] = $row['identifier'];
  581. else
  582. $context['recipients']['members'][] = $row['identifier'];
  583. }
  584. $smcFunc['db_free_result']($request);
  585. }
  586. // For progress bar!
  587. $context['total_emails'] = count($context['recipients']['emails']);
  588. $request = $smcFunc['db_query']('', '
  589. SELECT COUNT(*)
  590. FROM {db_prefix}members',
  591. array(
  592. )
  593. );
  594. list ($context['total_members']) = $smcFunc['db_fetch_row']($request);
  595. $smcFunc['db_free_result']($request);
  596. // Clean up the arrays.
  597. $context['recipients']['members'] = array_unique($context['recipients']['members']);
  598. $context['recipients']['exclude_members'] = array_unique($context['recipients']['exclude_members']);
  599. }
  600. /**
  601. * Handles the sending of the forum mailing in batches.
  602. * Called by ?action=admin;area=news;sa=mailingsend
  603. * Requires the send_mail permission.
  604. * Redirects to itself when more batches need to be sent.
  605. * Redirects to ?action=admin;area=news;sa=mailingmembers after everything has been sent.
  606. *
  607. * @param bool $clean_only = false; if set, it will only clean the variables, put them in context, then return.
  608. * @uses the ManageNews template and email_members_send sub template.
  609. */
  610. function SendMailing($clean_only = false)
  611. {
  612. global $txt, $sourcedir, $context, $smcFunc;
  613. global $scripturl, $modSettings, $user_info;
  614. if (isset($_POST['preview']))
  615. {
  616. $context['preview'] = true;
  617. return ComposeMailing();
  618. }
  619. // How many to send at once? Quantity depends on whether we are queueing or not.
  620. // @todo Might need an interface? (used in Post.php too with different limits)
  621. $num_at_once = 1000;
  622. // If by PM's I suggest we half the above number.
  623. if (!empty($_POST['send_pm']))
  624. $num_at_once /= 2;
  625. checkSession();
  626. // Where are we actually to?
  627. $context['start'] = isset($_REQUEST['start']) ? $_REQUEST['start'] : 0;
  628. $context['email_force'] = !empty($_POST['email_force']) ? 1 : 0;
  629. $context['send_pm'] = !empty($_POST['send_pm']) ? 1 : 0;
  630. $context['total_emails'] = !empty($_POST['total_emails']) ? (int) $_POST['total_emails'] : 0;
  631. $context['send_html'] = !empty($_POST['send_html']) ? '1' : '0';
  632. $context['parse_html'] = !empty($_POST['parse_html']) ? '1' : '0';
  633. //One can't simply nullify things around
  634. if (empty($_REQUEST['total_members']))
  635. {
  636. $request = $smcFunc['db_query']('', '
  637. SELECT COUNT(*)
  638. FROM {db_prefix}members',
  639. array(
  640. )
  641. );
  642. list ($context['total_members']) = $smcFunc['db_fetch_row']($request);
  643. $smcFunc['db_free_result']($request);
  644. }
  645. else
  646. {
  647. $context['total_members'] = (int) $_REQUEST['total_members'];
  648. }
  649. // Create our main context.
  650. $context['recipients'] = array(
  651. 'groups' => array(),
  652. 'exclude_groups' => array(),
  653. 'members' => array(),
  654. 'exclude_members' => array(),
  655. 'emails' => array(),
  656. );
  657. // Have we any excluded members?
  658. if (!empty($_POST['exclude_members']))
  659. {
  660. $members = explode(',', $_POST['exclude_members']);
  661. foreach ($members as $member)
  662. if ($member >= $context['start'])
  663. $context['recipients']['exclude_members'][] = (int) $member;
  664. }
  665. // What about members we *must* do?
  666. if (!empty($_POST['members']))
  667. {
  668. $members = explode(',', $_POST['members']);
  669. foreach ($members as $member)
  670. if ($member >= $context['start'])
  671. $context['recipients']['members'][] = (int) $member;
  672. }
  673. // Cleaning groups is simple - although deal with both checkbox and commas.
  674. if (isset($_POST['groups']))
  675. {
  676. if (is_array($_POST['groups']))
  677. {
  678. foreach ($_POST['groups'] as $group => $dummy)
  679. $context['recipients']['groups'][] = (int) $group;
  680. }
  681. else
  682. {
  683. $groups = explode(',', $_POST['groups']);
  684. foreach ($groups as $group)
  685. $context['recipients']['groups'][] = (int) $group;
  686. }
  687. }
  688. // Same for excluded groups
  689. if (isset($_POST['exclude_groups']))
  690. {
  691. if (is_array($_POST['exclude_groups']))
  692. {
  693. foreach ($_POST['exclude_groups'] as $group => $dummy)
  694. $context['recipients']['exclude_groups'][] = (int) $group;
  695. }
  696. else
  697. {
  698. $groups = explode(',', $_POST['exclude_groups']);
  699. foreach ($groups as $group)
  700. $context['recipients']['exclude_groups'][] = (int) $group;
  701. }
  702. }
  703. // Finally - emails!
  704. if (!empty($_POST['emails']))
  705. {
  706. $addressed = array_unique(explode(';', strtr($_POST['emails'], array("\n" => ';', "\r" => ';', ',' => ';'))));
  707. foreach ($addressed as $curmem)
  708. {
  709. $curmem = trim($curmem);
  710. if ($curmem != '' && preg_match('~^[0-9A-Za-z=_\'+\-/\.]*@[\w\-]+(\.[\w\-]+)*(\.[\w]{2,6})$~', $curmem) !== 0)
  711. $context['recipients']['emails'][$curmem] = $curmem;
  712. }
  713. }
  714. // If we're only cleaning drop out here.
  715. if ($clean_only)
  716. return;
  717. require_once($sourcedir . '/Subs-Post.php');
  718. // We are relying too much on writing to superglobals...
  719. $_POST['subject'] = !empty($_POST['subject']) ? $_POST['subject'] : '';
  720. $_POST['message'] = !empty($_POST['message']) ? $_POST['message'] : '';
  721. // Save the message and its subject in $context
  722. $context['subject'] = $smcFunc['htmlspecialchars']($_POST['subject'], ENT_QUOTES);
  723. $context['message'] = $smcFunc['htmlspecialchars']($_POST['message'], ENT_QUOTES);
  724. // Prepare the message for sending it as HTML
  725. if (!$context['send_pm'] && !empty($_POST['send_html']))
  726. {
  727. // Prepare the message for HTML.
  728. if (!empty($_POST['parse_html']))
  729. $_POST['message'] = str_replace(array("\n", ' '), array('<br>' . "\n", '&nbsp; '), $_POST['message']);
  730. // This is here to prevent spam filters from tagging this as spam.
  731. if (preg_match('~\<html~i', $_POST['message']) == 0)
  732. {
  733. if (preg_match('~\<body~i', $_POST['message']) == 0)
  734. $_POST['message'] = '<html><head><title>' . $_POST['subject'] . '</title></head>' . "\n" . '<body>' . $_POST['message'] . '</body></html>';
  735. else
  736. $_POST['message'] = '<html>' . $_POST['message'] . '</html>';
  737. }
  738. }
  739. if (empty($_POST['message']) || empty($_POST['subject']))
  740. {
  741. $context['preview'] = true;
  742. return ComposeMailing();
  743. }
  744. // Use the default time format.
  745. $user_info['time_format'] = $modSettings['time_format'];
  746. $variables = array(
  747. '{$board_url}',
  748. '{$current_time}',
  749. '{$latest_member.link}',
  750. '{$latest_member.id}',
  751. '{$latest_member.name}'
  752. );
  753. // We might need this in a bit
  754. $cleanLatestMember = empty($_POST['send_html']) || $context['send_pm'] ? un_htmlspecialchars($modSettings['latestRealName']) : $modSettings['latestRealName'];
  755. // Replace in all the standard things.
  756. $_POST['message'] = str_replace($variables,
  757. array(
  758. !empty($_POST['send_html']) ? '<a href="' . $scripturl . '">' . $scripturl . '</a>' : $scripturl,
  759. timeformat(forum_time(), false),
  760. !empty($_POST['send_html']) ? '<a href="' . $scripturl . '?action=profile;u=' . $modSettings['latestMember'] . '">' . $cleanLatestMember . '</a>' : ($context['send_pm'] ? '[url=' . $scripturl . '?action=profile;u=' . $modSettings['latestMember'] . ']' . $cleanLatestMember . '[/url]' : $cleanLatestMember),
  761. $modSettings['latestMember'],
  762. $cleanLatestMember
  763. ), $_POST['message']);
  764. $_POST['subject'] = str_replace($variables,
  765. array(
  766. $scripturl,
  767. timeformat(forum_time(), false),
  768. $modSettings['latestRealName'],
  769. $modSettings['latestMember'],
  770. $modSettings['latestRealName']
  771. ), $_POST['subject']);
  772. $from_member = array(
  773. '{$member.email}',
  774. '{$member.link}',
  775. '{$member.id}',
  776. '{$member.name}'
  777. );
  778. // If we still have emails, do them first!
  779. $i = 0;
  780. foreach ($context['recipients']['emails'] as $k => $email)
  781. {
  782. // Done as many as we can?
  783. if ($i >= $num_at_once)
  784. break;
  785. // Don't sent it twice!
  786. unset($context['recipients']['emails'][$k]);
  787. // Dammit - can't PM emails!
  788. if ($context['send_pm'])
  789. continue;
  790. $to_member = array(
  791. $email,
  792. !empty($_POST['send_html']) ? '<a href="mailto:' . $email . '">' . $email . '</a>' : $email,
  793. '??',
  794. $email
  795. );
  796. sendmail($email, str_replace($from_member, $to_member, $_POST['subject']), str_replace($from_member, $to_member, $_POST['message']), null, 'news', !empty($_POST['send_html']), 5);
  797. // Done another...
  798. $i++;
  799. }
  800. if ($i < $num_at_once)
  801. {
  802. // Need to build quite a query!
  803. $sendQuery = '(';
  804. $sendParams = array();
  805. if (!empty($context['recipients']['groups']))
  806. {
  807. // Take the long route...
  808. $queryBuild = array();
  809. foreach ($context['recipients']['groups'] as $group)
  810. {
  811. $sendParams['group_' . $group] = $group;
  812. $queryBuild[] = 'mem.id_group = {int:group_' . $group . '}';
  813. if (!empty($group))
  814. {
  815. $queryBuild[] = 'FIND_IN_SET({int:group_' . $group . '}, mem.additional_groups) != 0';
  816. $queryBuild[] = 'mem.id_post_group = {int:group_' . $group . '}';
  817. }
  818. }
  819. if (!empty($queryBuild))
  820. $sendQuery .= implode(' OR ', $queryBuild);
  821. }
  822. if (!empty($context['recipients']['members']))
  823. {
  824. $sendQuery .= ($sendQuery == '(' ? '' : ' OR ') . 'mem.id_member IN ({array_int:members})';
  825. $sendParams['members'] = $context['recipients']['members'];
  826. }
  827. $sendQuery .= ')';
  828. // If we've not got a query then we must be done!
  829. if ($sendQuery == '()')
  830. {
  831. // Set a confirmation message.
  832. $_SESSION['newsletter_sent'] = 'queue_done';
  833. redirectexit('action=admin;area=news;sa=mailingmembers');
  834. }
  835. // Anything to exclude?
  836. if (!empty($context['recipients']['exclude_groups']) && in_array(0, $context['recipients']['exclude_groups']))
  837. $sendQuery .= ' AND mem.id_group != {int:regular_group}';
  838. if (!empty($context['recipients']['exclude_members']))
  839. {
  840. $sendQuery .= ' AND mem.id_member NOT IN ({array_int:exclude_members})';
  841. $sendParams['exclude_members'] = $context['recipients']['exclude_members'];
  842. }
  843. // Force them to have it?
  844. if (empty($context['email_force']))
  845. $sendQuery .= ' AND mem.notify_announcements = {int:notify_announcements}';
  846. // Get the smelly people - note we respect the id_member range as it gives us a quicker query.
  847. $result = $smcFunc['db_query']('', '
  848. SELECT mem.id_member, mem.email_address, mem.real_name, mem.id_group, mem.additional_groups, mem.id_post_group
  849. FROM {db_prefix}members AS mem
  850. WHERE ' . $sendQuery . '
  851. AND mem.is_activated = {int:is_activated}
  852. ORDER BY mem.id_member ASC
  853. LIMIT {int:start}, {int:atonce}',
  854. array_merge($sendParams, array(
  855. 'start' => $context['start'],
  856. 'atonce' => $num_at_once,
  857. 'regular_group' => 0,
  858. 'notify_announcements' => 1,
  859. 'is_activated' => 1,
  860. ))
  861. );
  862. while ($row = $smcFunc['db_fetch_assoc']($result))
  863. {
  864. // What groups are we looking at here?
  865. if (empty($row['additional_groups']))
  866. $groups = array($row['id_group'], $row['id_post_group']);
  867. else
  868. $groups = array_merge(
  869. array($row['id_group'], $row['id_post_group']),
  870. explode(',', $row['additional_groups'])
  871. );
  872. // Excluded groups?
  873. if (array_intersect($groups, $context['recipients']['exclude_groups']))
  874. continue;
  875. // We might need this
  876. $cleanMemberName = empty($_POST['send_html']) || $context['send_pm'] ? un_htmlspecialchars($row['real_name']) : $row['real_name'];
  877. // Replace the member-dependant variables
  878. $message = str_replace($from_member,
  879. array(
  880. $row['email_address'],
  881. !empty($_POST['send_html']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $cleanMemberName . '</a>' : ($context['send_pm'] ? '[url=' . $scripturl . '?action=profile;u=' . $row['id_member'] . ']' . $cleanMemberName . '[/url]' : $cleanMemberName),
  882. $row['id_member'],
  883. $cleanMemberName,
  884. ), $_POST['message']);
  885. $subject = str_replace($from_member,
  886. array(
  887. $row['email_address'],
  888. $row['real_name'],
  889. $row['id_member'],
  890. $row['real_name'],
  891. ), $_POST['subject']);
  892. // Send the actual email - or a PM!
  893. if (!$context['send_pm'])
  894. sendmail($row['email_address'], $subject, $message, null, 'news', !empty($_POST['send_html']), 5);
  895. else
  896. sendpm(array('to' => array($row['id_member']), 'bcc' => array()), $subject, $message);
  897. }
  898. $smcFunc['db_free_result']($result);
  899. }
  900. $context['start'] = $context['start'] + $num_at_once;
  901. if (empty($context['recipients']['emails']) && ($context['start'] >= $context['total_members']))
  902. {
  903. // Log this into the admin log.
  904. logAction('newsletter', array(), 'admin');
  905. $_SESSION['newsletter_sent'] = 'queue_done';
  906. redirectexit('action=admin;area=news;sa=mailingmembers');
  907. }
  908. // Working out progress is a black art of sorts.
  909. $percentEmails = $context['total_emails'] == 0 ? 0 : ((count($context['recipients']['emails']) / $context['total_emails']) * ($context['total_emails'] / ($context['total_emails'] + $context['total_members'])));
  910. $percentMembers = ($context['start'] / $context['total_members']) * ($context['total_members'] / ($context['total_emails'] + $context['total_members']));
  911. $context['percentage_done'] = round(($percentEmails + $percentMembers) * 100, 2);
  912. $context['page_title'] = $txt['admin_newsletters'];
  913. $context['sub_template'] = 'email_members_send';
  914. }
  915. /**
  916. * Set general news and newsletter settings and permissions.
  917. * Called by ?action=admin;area=news;sa=settings.
  918. * Requires the forum_admin permission.
  919. *
  920. * @uses ManageNews template, news_settings sub-template.
  921. * @param bool $return_config = false
  922. */
  923. function ModifyNewsSettings($return_config = false)
  924. {
  925. global $context, $sourcedir, $txt, $scripturl;
  926. $config_vars = array(
  927. array('title', 'settings'),
  928. // Inline permissions.
  929. array('permissions', 'edit_news', 'help' => ''),
  930. array('permissions', 'send_mail'),
  931. '',
  932. // Just the remaining settings.
  933. array('check', 'xmlnews_enable', 'onclick' => 'document.getElementById(\'xmlnews_maxlen\').disabled = !this.checked;'),
  934. array('int', 'xmlnews_maxlen', 'subtext' => $txt['xmlnews_maxlen_note'], 10),
  935. );
  936. call_integration_hook('integrate_modify_news_settings', array(&$config_vars));
  937. if ($return_config)
  938. return $config_vars;
  939. $context['page_title'] = $txt['admin_edit_news'] . ' - ' . $txt['settings'];
  940. $context['sub_template'] = 'show_settings';
  941. // Needed for the settings template.
  942. require_once($sourcedir . '/ManageServer.php');
  943. // Wrap it all up nice and warm...
  944. $context['post_url'] = $scripturl . '?action=admin;area=news;save;sa=settings';
  945. $context['permissions_excluded'] = array(-1);
  946. // Add some javascript at the bottom...
  947. addInlineJavascript('
  948. document.getElementById("xmlnews_maxlen").disabled = !document.getElementById("xmlnews_enable").checked;', true);
  949. // Saving the settings?
  950. if (isset($_GET['save']))
  951. {
  952. checkSession();
  953. call_integration_hook('integrate_save_news_settings');
  954. saveDBSettings($config_vars);
  955. $_SESSION['adm-save'] = true;
  956. redirectexit('action=admin;area=news;sa=settings');
  957. }
  958. // We need this for the in-line permissions
  959. createToken('admin-mp');
  960. prepareDBSettingContext($config_vars);
  961. }
  962. ?>