ManagePermissions.php 74 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406
  1. <?php
  2. /**
  3. * ManagePermissions handles all possible permission stuff.
  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. * Dispaches to the right function based on the given subaction.
  18. * Checks the permissions, based on the sub-action.
  19. * Called by ?action=managepermissions.
  20. *
  21. * @uses ManagePermissions language file.
  22. */
  23. function ModifyPermissions()
  24. {
  25. global $txt, $scripturl, $context;
  26. loadLanguage('ManagePermissions+ManageMembers');
  27. loadTemplate('ManagePermissions');
  28. // Format: 'sub-action' => array('function_to_call', 'permission_needed'),
  29. $subActions = array(
  30. 'board' => array('PermissionByBoard', 'manage_permissions'),
  31. 'index' => array('PermissionIndex', 'manage_permissions'),
  32. 'modify' => array('ModifyMembergroup', 'manage_permissions'),
  33. 'modify2' => array('ModifyMembergroup2', 'manage_permissions'),
  34. 'quick' => array('SetQuickGroups', 'manage_permissions'),
  35. 'quickboard' => array('SetQuickBoards', 'manage_permissions'),
  36. 'postmod' => array('ModifyPostModeration', 'manage_permissions'),
  37. 'profiles' => array('EditPermissionProfiles', 'manage_permissions'),
  38. 'settings' => array('GeneralPermissionSettings', 'admin_forum'),
  39. );
  40. $_REQUEST['sa'] = isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']]) ? $_REQUEST['sa'] : (allowedTo('manage_permissions') ? 'index' : 'settings');
  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['permissions_title'],
  45. 'help' => 'permissions',
  46. 'description' => '',
  47. 'tabs' => array(
  48. 'index' => array(
  49. 'description' => $txt['permissions_groups'],
  50. ),
  51. 'board' => array(
  52. 'description' => $txt['permission_by_board_desc'],
  53. ),
  54. 'profiles' => array(
  55. 'description' => $txt['permissions_profiles_desc'],
  56. ),
  57. 'postmod' => array(
  58. 'description' => $txt['permissions_post_moderation_desc'],
  59. ),
  60. 'settings' => array(
  61. 'description' => $txt['permission_settings_desc'],
  62. ),
  63. ),
  64. );
  65. $subActions[$_REQUEST['sa']][0]();
  66. }
  67. /**
  68. * Sets up the permissions by membergroup index page.
  69. * Called by ?action=managepermissions
  70. * Creates an array of all the groups with the number of members and permissions.
  71. *
  72. * @uses ManagePermissions language file.
  73. * @uses ManagePermissions template file.
  74. * @uses ManageBoards template, permission_index sub-template.
  75. */
  76. function PermissionIndex()
  77. {
  78. global $txt, $scripturl, $context, $settings, $modSettings, $smcFunc;
  79. $context['page_title'] = $txt['permissions_title'];
  80. // Load all the permissions. We'll need them in the template.
  81. loadAllPermissions();
  82. // Also load profiles, we may want to reset.
  83. loadPermissionProfiles();
  84. // Are we going to show the advanced options?
  85. $context['show_advanced_options'] = empty($context['admin_preferences']['app']);
  86. // Determine the number of ungrouped members.
  87. $request = $smcFunc['db_query']('', '
  88. SELECT COUNT(*)
  89. FROM {db_prefix}members
  90. WHERE id_group = {int:regular_group}',
  91. array(
  92. 'regular_group' => 0,
  93. )
  94. );
  95. list ($num_members) = $smcFunc['db_fetch_row']($request);
  96. $smcFunc['db_free_result']($request);
  97. // Fill the context variable with 'Guests' and 'Regular Members'.
  98. $context['groups'] = array(
  99. -1 => array(
  100. 'id' => -1,
  101. 'name' => $txt['membergroups_guests'],
  102. 'num_members' => $txt['membergroups_guests_na'],
  103. 'allow_delete' => false,
  104. 'allow_modify' => true,
  105. 'can_search' => false,
  106. 'href' => '',
  107. 'link' => '',
  108. 'is_post_group' => false,
  109. 'color' => '',
  110. 'stars' => '',
  111. 'children' => array(),
  112. 'num_permissions' => array(
  113. 'allowed' => 0,
  114. // Can't deny guest permissions!
  115. 'denied' => '(' . $txt['permissions_none'] . ')'
  116. ),
  117. 'access' => false
  118. ),
  119. 0 => array(
  120. 'id' => 0,
  121. 'name' => $txt['membergroups_members'],
  122. 'num_members' => $num_members,
  123. 'allow_delete' => false,
  124. 'allow_modify' => true,
  125. 'can_search' => false,
  126. 'href' => $scripturl . '?action=moderate;area=viewgroups;sa=members;group=0',
  127. 'is_post_group' => false,
  128. 'color' => '',
  129. 'stars' => '',
  130. 'children' => array(),
  131. 'num_permissions' => array(
  132. 'allowed' => 0,
  133. 'denied' => 0
  134. ),
  135. 'access' => false
  136. ),
  137. );
  138. $postGroups = array();
  139. $normalGroups = array();
  140. // Query the database defined membergroups.
  141. $query = $smcFunc['db_query']('', '
  142. SELECT id_group, id_parent, group_name, min_posts, online_color, stars
  143. FROM {db_prefix}membergroups' . (empty($modSettings['permission_enable_postgroups']) ? '
  144. WHERE min_posts = {int:min_posts}' : '') . '
  145. ORDER BY id_parent = {int:not_inherited} DESC, min_posts, CASE WHEN id_group < {int:newbie_group} THEN id_group ELSE 4 END, group_name',
  146. array(
  147. 'min_posts' => -1,
  148. 'not_inherited' => -2,
  149. 'newbie_group' => 4,
  150. )
  151. );
  152. while ($row = $smcFunc['db_fetch_assoc']($query))
  153. {
  154. // If it's inherited, just add it as a child.
  155. if ($row['id_parent'] != -2)
  156. {
  157. if (isset($context['groups'][$row['id_parent']]))
  158. $context['groups'][$row['id_parent']]['children'][$row['id_group']] = $row['group_name'];
  159. continue;
  160. }
  161. $row['stars'] = explode('#', $row['stars']);
  162. $context['groups'][$row['id_group']] = array(
  163. 'id' => $row['id_group'],
  164. 'name' => $row['group_name'],
  165. 'num_members' => $row['id_group'] != 3 ? 0 : $txt['membergroups_guests_na'],
  166. 'allow_delete' => $row['id_group'] > 4,
  167. 'allow_modify' => $row['id_group'] > 1,
  168. 'can_search' => $row['id_group'] != 3,
  169. 'href' => $scripturl . '?action=moderate;area=viewgroups;sa=members;group=' . $row['id_group'],
  170. 'is_post_group' => $row['min_posts'] != -1,
  171. 'color' => empty($row['online_color']) ? '' : $row['online_color'],
  172. 'stars' => !empty($row['stars'][0]) && !empty($row['stars'][1]) ? str_repeat('<img src="' . $settings['images_url'] . '/' . $row['stars'][1] . '" alt="*" />', $row['stars'][0]) : '',
  173. 'children' => array(),
  174. 'num_permissions' => array(
  175. 'allowed' => $row['id_group'] == 1 ? '(' . $txt['permissions_all'] . ')' : 0,
  176. 'denied' => $row['id_group'] == 1 ? '(' . $txt['permissions_none'] . ')' : 0
  177. ),
  178. 'access' => false,
  179. );
  180. if ($row['min_posts'] == -1)
  181. $normalGroups[$row['id_group']] = $row['id_group'];
  182. else
  183. $postGroups[$row['id_group']] = $row['id_group'];
  184. }
  185. $smcFunc['db_free_result']($query);
  186. // Get the number of members in this post group.
  187. if (!empty($postGroups))
  188. {
  189. $query = $smcFunc['db_query']('', '
  190. SELECT id_post_group AS id_group, COUNT(*) AS num_members
  191. FROM {db_prefix}members
  192. WHERE id_post_group IN ({array_int:post_group_list})
  193. GROUP BY id_post_group',
  194. array(
  195. 'post_group_list' => $postGroups,
  196. )
  197. );
  198. while ($row = $smcFunc['db_fetch_assoc']($query))
  199. $context['groups'][$row['id_group']]['num_members'] += $row['num_members'];
  200. $smcFunc['db_free_result']($query);
  201. }
  202. if (!empty($normalGroups))
  203. {
  204. // First, the easy one!
  205. $query = $smcFunc['db_query']('', '
  206. SELECT id_group, COUNT(*) AS num_members
  207. FROM {db_prefix}members
  208. WHERE id_group IN ({array_int:normal_group_list})
  209. GROUP BY id_group',
  210. array(
  211. 'normal_group_list' => $normalGroups,
  212. )
  213. );
  214. while ($row = $smcFunc['db_fetch_assoc']($query))
  215. $context['groups'][$row['id_group']]['num_members'] += $row['num_members'];
  216. $smcFunc['db_free_result']($query);
  217. // This one is slower, but it's okay... careful not to count twice!
  218. $query = $smcFunc['db_query']('', '
  219. SELECT mg.id_group, COUNT(*) AS num_members
  220. FROM {db_prefix}membergroups AS mg
  221. INNER JOIN {db_prefix}members AS mem ON (mem.additional_groups != {string:blank_string}
  222. AND mem.id_group != mg.id_group
  223. AND FIND_IN_SET(mg.id_group, mem.additional_groups) != 0)
  224. WHERE mg.id_group IN ({array_int:normal_group_list})
  225. GROUP BY mg.id_group',
  226. array(
  227. 'normal_group_list' => $normalGroups,
  228. 'blank_string' => '',
  229. )
  230. );
  231. while ($row = $smcFunc['db_fetch_assoc']($query))
  232. $context['groups'][$row['id_group']]['num_members'] += $row['num_members'];
  233. $smcFunc['db_free_result']($query);
  234. }
  235. foreach ($context['groups'] as $id => $data)
  236. {
  237. if ($data['href'] != '')
  238. $context['groups'][$id]['link'] = '<a href="' . $data['href'] . '">' . $data['num_members'] . '</a>';
  239. }
  240. if (empty($_REQUEST['pid']))
  241. {
  242. $request = $smcFunc['db_query']('', '
  243. SELECT id_group, COUNT(*) AS num_permissions, add_deny
  244. FROM {db_prefix}permissions
  245. ' . (empty($context['hidden_permissions']) ? '' : ' WHERE permission NOT IN ({array_string:hidden_permissions})') . '
  246. GROUP BY id_group, add_deny',
  247. array(
  248. 'hidden_permissions' => !empty($context['hidden_permissions']) ? $context['hidden_permissions'] : array(),
  249. )
  250. );
  251. while ($row = $smcFunc['db_fetch_assoc']($request))
  252. if (isset($context['groups'][(int) $row['id_group']]) && (!empty($row['add_deny']) || $row['id_group'] != -1))
  253. $context['groups'][(int) $row['id_group']]['num_permissions'][empty($row['add_deny']) ? 'denied' : 'allowed'] = $row['num_permissions'];
  254. $smcFunc['db_free_result']($request);
  255. // Get the "default" profile permissions too.
  256. $request = $smcFunc['db_query']('', '
  257. SELECT id_profile, id_group, COUNT(*) AS num_permissions, add_deny
  258. FROM {db_prefix}board_permissions
  259. WHERE id_profile = {int:default_profile}
  260. ' . (empty($context['hidden_permissions']) ? '' : ' AND permission NOT IN ({array_string:hidden_permissions})') . '
  261. GROUP BY id_profile, id_group, add_deny',
  262. array(
  263. 'default_profile' => 1,
  264. 'hidden_permissions' => !empty($context['hidden_permissions']) ? $context['hidden_permissions'] : array(),
  265. )
  266. );
  267. while ($row = $smcFunc['db_fetch_assoc']($request))
  268. {
  269. if (isset($context['groups'][(int) $row['id_group']]) && (!empty($row['add_deny']) || $row['id_group'] != -1))
  270. $context['groups'][(int) $row['id_group']]['num_permissions'][empty($row['add_deny']) ? 'denied' : 'allowed'] += $row['num_permissions'];
  271. }
  272. $smcFunc['db_free_result']($request);
  273. }
  274. else
  275. {
  276. $_REQUEST['pid'] = (int) $_REQUEST['pid'];
  277. if (!isset($context['profiles'][$_REQUEST['pid']]))
  278. fatal_lang_error('no_access', false);
  279. // Change the selected tab to better reflect that this really is a board profile.
  280. $context[$context['admin_menu_name']]['current_subsection'] = 'profiles';
  281. $request = $smcFunc['db_query']('', '
  282. SELECT id_profile, id_group, COUNT(*) AS num_permissions, add_deny
  283. FROM {db_prefix}board_permissions
  284. WHERE id_profile = {int:current_profile}
  285. GROUP BY id_profile, id_group, add_deny',
  286. array(
  287. 'current_profile' => $_REQUEST['pid'],
  288. )
  289. );
  290. while ($row = $smcFunc['db_fetch_assoc']($request))
  291. {
  292. if (isset($context['groups'][(int) $row['id_group']]) && (!empty($row['add_deny']) || $row['id_group'] != -1))
  293. $context['groups'][(int) $row['id_group']]['num_permissions'][empty($row['add_deny']) ? 'denied' : 'allowed'] += $row['num_permissions'];
  294. }
  295. $smcFunc['db_free_result']($request);
  296. $context['profile'] = array(
  297. 'id' => $_REQUEST['pid'],
  298. 'name' => $context['profiles'][$_REQUEST['pid']]['name'],
  299. );
  300. }
  301. // We can modify any permission set apart from the read only, reply only and no polls ones as they are redefined.
  302. $context['can_modify'] = empty($_REQUEST['pid']) || $_REQUEST['pid'] == 1 || $_REQUEST['pid'] > 4;
  303. // Load the proper template.
  304. $context['sub_template'] = 'permission_index';
  305. createToken('admin-mpq');
  306. }
  307. /**
  308. * Handle permissions by board... more or less. :P
  309. */
  310. function PermissionByBoard()
  311. {
  312. global $context, $modSettings, $txt, $smcFunc, $sourcedir, $cat_tree, $boardList, $boards;
  313. $context['page_title'] = $txt['permissions_boards'];
  314. $context['edit_all'] = isset($_GET['edit']);
  315. // Saving?
  316. if (!empty($_POST['save_changes']) && !empty($_POST['boardprofile']))
  317. {
  318. checkSession('request');
  319. validateToken('admin-mpb');
  320. $changes = array();
  321. foreach ($_POST['boardprofile'] as $board => $profile)
  322. {
  323. $changes[(int) $profile][] = (int) $board;
  324. }
  325. if (!empty($changes))
  326. {
  327. foreach ($changes as $profile => $boards)
  328. $smcFunc['db_query']('', '
  329. UPDATE {db_prefix}boards
  330. SET id_profile = {int:current_profile}
  331. WHERE id_board IN ({array_int:board_list})',
  332. array(
  333. 'board_list' => $boards,
  334. 'current_profile' => $profile,
  335. )
  336. );
  337. }
  338. $context['edit_all'] = false;
  339. }
  340. // Load all permission profiles.
  341. loadPermissionProfiles();
  342. // Get the board tree.
  343. require_once($sourcedir . '/Subs-Boards.php');
  344. getBoardTree();
  345. // Build the list of the boards.
  346. $context['categories'] = array();
  347. foreach ($cat_tree as $catid => $tree)
  348. {
  349. $context['categories'][$catid] = array(
  350. 'name' => &$tree['node']['name'],
  351. 'id' => &$tree['node']['id'],
  352. 'boards' => array()
  353. );
  354. foreach ($boardList[$catid] as $boardid)
  355. {
  356. if (!isset($context['profiles'][$boards[$boardid]['profile']]))
  357. $boards[$boardid]['profile'] = 1;
  358. $context['categories'][$catid]['boards'][$boardid] = array(
  359. 'id' => &$boards[$boardid]['id'],
  360. 'name' => &$boards[$boardid]['name'],
  361. 'description' => &$boards[$boardid]['description'],
  362. 'child_level' => &$boards[$boardid]['level'],
  363. 'profile' => &$boards[$boardid]['profile'],
  364. 'profile_name' => $context['profiles'][$boards[$boardid]['profile']]['name'],
  365. );
  366. }
  367. }
  368. $context['sub_template'] = 'by_board';
  369. createToken('admin-mpb');
  370. }
  371. /**
  372. * Handles permission modification actions from the upper part of the
  373. * permission manager index.
  374. */
  375. function SetQuickGroups()
  376. {
  377. global $context, $smcFunc;
  378. checkSession();
  379. validateToken('admin-mpq', 'quick');
  380. loadIllegalPermissions();
  381. loadIllegalGuestPermissions();
  382. // Make sure only one of the quick options was selected.
  383. if ((!empty($_POST['predefined']) && ((isset($_POST['copy_from']) && $_POST['copy_from'] != 'empty') || !empty($_POST['permissions']))) || (!empty($_POST['copy_from']) && $_POST['copy_from'] != 'empty' && !empty($_POST['permissions'])))
  384. fatal_lang_error('permissions_only_one_option', false);
  385. if (empty($_POST['group']) || !is_array($_POST['group']))
  386. $_POST['group'] = array();
  387. // Only accept numeric values for selected membergroups.
  388. foreach ($_POST['group'] as $id => $group_id)
  389. $_POST['group'][$id] = (int) $group_id;
  390. $_POST['group'] = array_unique($_POST['group']);
  391. if (empty($_REQUEST['pid']))
  392. $_REQUEST['pid'] = 0;
  393. else
  394. $_REQUEST['pid'] = (int) $_REQUEST['pid'];
  395. // Fix up the old global to the new default!
  396. $bid = max(1, $_REQUEST['pid']);
  397. // No modifying the predefined profiles.
  398. if ($_REQUEST['pid'] > 1 && $_REQUEST['pid'] < 5)
  399. fatal_lang_error('no_access', false);
  400. // Clear out any cached authority.
  401. updateSettings(array('settings_updated' => time()));
  402. // No groups where selected.
  403. if (empty($_POST['group']))
  404. redirectexit('action=admin;area=permissions;pid=' . $_REQUEST['pid']);
  405. // Set a predefined permission profile.
  406. if (!empty($_POST['predefined']))
  407. {
  408. // Make sure it's a predefined permission set we expect.
  409. if (!in_array($_POST['predefined'], array('restrict', 'standard', 'moderator', 'maintenance')))
  410. redirectexit('action=admin;area=permissions;pid=' . $_REQUEST['pid']);
  411. foreach ($_POST['group'] as $group_id)
  412. {
  413. if (!empty($_REQUEST['pid']))
  414. setPermissionLevel($_POST['predefined'], $group_id, $_REQUEST['pid']);
  415. else
  416. setPermissionLevel($_POST['predefined'], $group_id);
  417. }
  418. }
  419. // Set a permission profile based on the permissions of a selected group.
  420. elseif ($_POST['copy_from'] != 'empty')
  421. {
  422. // Just checking the input.
  423. if (!is_numeric($_POST['copy_from']))
  424. redirectexit('action=admin;area=permissions;pid=' . $_REQUEST['pid']);
  425. // Make sure the group we're copying to is never included.
  426. $_POST['group'] = array_diff($_POST['group'], array($_POST['copy_from']));
  427. // No groups left? Too bad.
  428. if (empty($_POST['group']))
  429. redirectexit('action=admin;area=permissions;pid=' . $_REQUEST['pid']);
  430. if (empty($_REQUEST['pid']))
  431. {
  432. // Retrieve current permissions of group.
  433. $request = $smcFunc['db_query']('', '
  434. SELECT permission, add_deny
  435. FROM {db_prefix}permissions
  436. WHERE id_group = {int:copy_from}',
  437. array(
  438. 'copy_from' => $_POST['copy_from'],
  439. )
  440. );
  441. $target_perm = array();
  442. while ($row = $smcFunc['db_fetch_assoc']($request))
  443. $target_perm[$row['permission']] = $row['add_deny'];
  444. $smcFunc['db_free_result']($request);
  445. $inserts = array();
  446. foreach ($_POST['group'] as $group_id)
  447. foreach ($target_perm as $perm => $add_deny)
  448. {
  449. // No dodgy permissions please!
  450. if (!empty($context['illegal_permissions']) && in_array($perm, $context['illegal_permissions']))
  451. continue;
  452. if ($group_id == -1 && in_array($perm, $context['non_guest_permissions']))
  453. continue;
  454. if ($group_id != 1 && $group_id != 3)
  455. $inserts[] = array($perm, $group_id, $add_deny);
  456. }
  457. // Delete the previous permissions...
  458. $smcFunc['db_query']('', '
  459. DELETE FROM {db_prefix}permissions
  460. WHERE id_group IN ({array_int:group_list})
  461. ' . (empty($context['illegal_permissions']) ? '' : ' AND permission NOT IN ({array_string:illegal_permissions})'),
  462. array(
  463. 'group_list' => $_POST['group'],
  464. 'illegal_permissions' => !empty($context['illegal_permissions']) ? $context['illegal_permissions'] : array(),
  465. )
  466. );
  467. if (!empty($inserts))
  468. {
  469. // ..and insert the new ones.
  470. $smcFunc['db_insert']('',
  471. '{db_prefix}permissions',
  472. array(
  473. 'permission' => 'string', 'id_group' => 'int', 'add_deny' => 'int',
  474. ),
  475. $inserts,
  476. array('permission', 'id_group')
  477. );
  478. }
  479. }
  480. // Now do the same for the board permissions.
  481. $request = $smcFunc['db_query']('', '
  482. SELECT permission, add_deny
  483. FROM {db_prefix}board_permissions
  484. WHERE id_group = {int:copy_from}
  485. AND id_profile = {int:current_profile}',
  486. array(
  487. 'copy_from' => $_POST['copy_from'],
  488. 'current_profile' => $bid,
  489. )
  490. );
  491. $target_perm = array();
  492. while ($row = $smcFunc['db_fetch_assoc']($request))
  493. $target_perm[$row['permission']] = $row['add_deny'];
  494. $smcFunc['db_free_result']($request);
  495. $inserts = array();
  496. foreach ($_POST['group'] as $group_id)
  497. foreach ($target_perm as $perm => $add_deny)
  498. {
  499. // Are these for guests?
  500. if ($group_id == -1 && in_array($perm, $context['non_guest_permissions']))
  501. continue;
  502. $inserts[] = array($perm, $group_id, $bid, $add_deny);
  503. }
  504. // Delete the previous global board permissions...
  505. $smcFunc['db_query']('', '
  506. DELETE FROM {db_prefix}board_permissions
  507. WHERE id_group IN ({array_int:current_group_list})
  508. AND id_profile = {int:current_profile}',
  509. array(
  510. 'current_group_list' => $_POST['group'],
  511. 'current_profile' => $bid,
  512. )
  513. );
  514. // And insert the copied permissions.
  515. if (!empty($inserts))
  516. {
  517. // ..and insert the new ones.
  518. $smcFunc['db_insert']('',
  519. '{db_prefix}board_permissions',
  520. array('permission' => 'string', 'id_group' => 'int', 'id_profile' => 'int', 'add_deny' => 'int'),
  521. $inserts,
  522. array('permission', 'id_group', 'id_profile')
  523. );
  524. }
  525. // Update any children out there!
  526. updateChildPermissions($_POST['group'], $_REQUEST['pid']);
  527. }
  528. // Set or unset a certain permission for the selected groups.
  529. elseif (!empty($_POST['permissions']))
  530. {
  531. // Unpack two variables that were transported.
  532. list ($permissionType, $permission) = explode('/', $_POST['permissions']);
  533. // Check whether our input is within expected range.
  534. if (!in_array($_POST['add_remove'], array('add', 'clear', 'deny')) || !in_array($permissionType, array('membergroup', 'board')))
  535. redirectexit('action=admin;area=permissions;pid=' . $_REQUEST['pid']);
  536. if ($_POST['add_remove'] == 'clear')
  537. {
  538. if ($permissionType == 'membergroup')
  539. $smcFunc['db_query']('', '
  540. DELETE FROM {db_prefix}permissions
  541. WHERE id_group IN ({array_int:current_group_list})
  542. AND permission = {string:current_permission}
  543. ' . (empty($context['illegal_permissions']) ? '' : ' AND permission NOT IN ({array_string:illegal_permissions})'),
  544. array(
  545. 'current_group_list' => $_POST['group'],
  546. 'current_permission' => $permission,
  547. 'illegal_permissions' => !empty($context['illegal_permissions']) ? $context['illegal_permissions'] : array(),
  548. )
  549. );
  550. else
  551. $smcFunc['db_query']('', '
  552. DELETE FROM {db_prefix}board_permissions
  553. WHERE id_group IN ({array_int:current_group_list})
  554. AND id_profile = {int:current_profile}
  555. AND permission = {string:current_permission}',
  556. array(
  557. 'current_group_list' => $_POST['group'],
  558. 'current_profile' => $bid,
  559. 'current_permission' => $permission,
  560. )
  561. );
  562. }
  563. // Add a permission (either 'set' or 'deny').
  564. else
  565. {
  566. $add_deny = $_POST['add_remove'] == 'add' ? '1' : '0';
  567. $permChange = array();
  568. foreach ($_POST['group'] as $groupID)
  569. {
  570. if ($groupID == -1 && in_array($permission, $context['non_guest_permissions']))
  571. continue;
  572. if ($permissionType == 'membergroup' && $groupID != 1 && $groupID != 3 && (empty($context['illegal_permissions']) || !in_array($permission, $context['illegal_permissions'])))
  573. $permChange[] = array($permission, $groupID, $add_deny);
  574. elseif ($permissionType != 'membergroup')
  575. $permChange[] = array($permission, $groupID, $bid, $add_deny);
  576. }
  577. if (!empty($permChange))
  578. {
  579. if ($permissionType == 'membergroup')
  580. $smcFunc['db_insert']('replace',
  581. '{db_prefix}permissions',
  582. array('permission' => 'string', 'id_group' => 'int', 'add_deny' => 'int'),
  583. $permChange,
  584. array('permission', 'id_group')
  585. );
  586. // Board permissions go into the other table.
  587. else
  588. $smcFunc['db_insert']('replace',
  589. '{db_prefix}board_permissions',
  590. array('permission' => 'string', 'id_group' => 'int', 'id_profile' => 'int', 'add_deny' => 'int'),
  591. $permChange,
  592. array('permission', 'id_group', 'id_profile')
  593. );
  594. }
  595. }
  596. // Another child update!
  597. updateChildPermissions($_POST['group'], $_REQUEST['pid']);
  598. }
  599. redirectexit('action=admin;area=permissions;pid=' . $_REQUEST['pid']);
  600. }
  601. /**
  602. * Initializes the necessary to modify a membergroup's permissions.
  603. */
  604. function ModifyMembergroup()
  605. {
  606. global $context, $txt, $modSettings, $smcFunc, $sourcedir;
  607. if (!isset($_GET['group']))
  608. fatal_lang_error('no_access', false);
  609. $context['group']['id'] = (int) $_GET['group'];
  610. // Are they toggling the view?
  611. if (isset($_GET['view']))
  612. {
  613. $context['admin_preferences']['pv'] = $_GET['view'] == 'classic' ? 'classic' : 'simple';
  614. // Update the users preferences.
  615. require_once($sourcedir . '/Subs-Admin.php');
  616. updateAdminPreferences();
  617. }
  618. $context['view_type'] = !empty($context['admin_preferences']['pv']) && $context['admin_preferences']['pv'] == 'classic' ? 'classic' : 'simple';
  619. // It's not likely you'd end up here with this setting disabled.
  620. if ($_GET['group'] == 1)
  621. redirectexit('action=admin;area=permissions');
  622. loadAllPermissions($context['view_type']);
  623. loadPermissionProfiles();
  624. if ($context['group']['id'] > 0)
  625. {
  626. $result = $smcFunc['db_query']('', '
  627. SELECT group_name, id_parent
  628. FROM {db_prefix}membergroups
  629. WHERE id_group = {int:current_group}
  630. LIMIT 1',
  631. array(
  632. 'current_group' => $context['group']['id'],
  633. )
  634. );
  635. list ($context['group']['name'], $parent) = $smcFunc['db_fetch_row']($result);
  636. $smcFunc['db_free_result']($result);
  637. // Cannot edit an inherited group!
  638. if ($parent != -2)
  639. fatal_lang_error('cannot_edit_permissions_inherited');
  640. }
  641. elseif ($context['group']['id'] == -1)
  642. $context['group']['name'] = $txt['membergroups_guests'];
  643. else
  644. $context['group']['name'] = $txt['membergroups_members'];
  645. $context['profile']['id'] = empty($_GET['pid']) ? 0 : (int) $_GET['pid'];
  646. // If this is a moderator and they are editing "no profile" then we only do boards.
  647. if ($context['group']['id'] == 3 && empty($context['profile']['id']))
  648. {
  649. // For sanity just check they have no general permissions.
  650. $smcFunc['db_query']('', '
  651. DELETE FROM {db_prefix}permissions
  652. WHERE id_group = {int:moderator_group}',
  653. array(
  654. 'moderator_group' => 3,
  655. )
  656. );
  657. $context['profile']['id'] = 1;
  658. }
  659. $context['permission_type'] = empty($context['profile']['id']) ? 'membergroup' : 'board';
  660. $context['profile']['can_modify'] = !$context['profile']['id'] || $context['profiles'][$context['profile']['id']]['can_modify'];
  661. // Set up things a little nicer for board related stuff...
  662. if ($context['permission_type'] == 'board')
  663. {
  664. $context['profile']['name'] = $context['profiles'][$context['profile']['id']]['name'];
  665. $context[$context['admin_menu_name']]['current_subsection'] = 'profiles';
  666. }
  667. // Fetch the current permissions.
  668. $permissions = array(
  669. 'membergroup' => array('allowed' => array(), 'denied' => array()),
  670. 'board' => array('allowed' => array(), 'denied' => array())
  671. );
  672. // General permissions?
  673. if ($context['permission_type'] == 'membergroup')
  674. {
  675. $result = $smcFunc['db_query']('', '
  676. SELECT permission, add_deny
  677. FROM {db_prefix}permissions
  678. WHERE id_group = {int:current_group}',
  679. array(
  680. 'current_group' => $_GET['group'],
  681. )
  682. );
  683. while ($row = $smcFunc['db_fetch_assoc']($result))
  684. $permissions['membergroup'][empty($row['add_deny']) ? 'denied' : 'allowed'][] = $row['permission'];
  685. $smcFunc['db_free_result']($result);
  686. }
  687. // Fetch current board permissions...
  688. $result = $smcFunc['db_query']('', '
  689. SELECT permission, add_deny
  690. FROM {db_prefix}board_permissions
  691. WHERE id_group = {int:current_group}
  692. AND id_profile = {int:current_profile}',
  693. array(
  694. 'current_group' => $context['group']['id'],
  695. 'current_profile' => $context['permission_type'] == 'membergroup' ? 1 : $context['profile']['id'],
  696. )
  697. );
  698. while ($row = $smcFunc['db_fetch_assoc']($result))
  699. $permissions['board'][empty($row['add_deny']) ? 'denied' : 'allowed'][] = $row['permission'];
  700. $smcFunc['db_free_result']($result);
  701. // Loop through each permission and set whether it's checked.
  702. foreach ($context['permissions'] as $permissionType => $tmp)
  703. {
  704. foreach ($tmp['columns'] as $position => $permissionGroups)
  705. {
  706. foreach ($permissionGroups as $permissionGroup => $permissionArray)
  707. {
  708. foreach ($permissionArray['permissions'] as $perm)
  709. {
  710. // Create a shortcut for the current permission.
  711. $curPerm = &$context['permissions'][$permissionType]['columns'][$position][$permissionGroup]['permissions'][$perm['id']];
  712. if ($tmp['view'] == 'classic')
  713. {
  714. if ($perm['has_own_any'])
  715. {
  716. $curPerm['any']['select'] = in_array($perm['id'] . '_any', $permissions[$permissionType]['allowed']) ? 'on' : (in_array($perm['id'] . '_any', $permissions[$permissionType]['denied']) ? 'denied' : 'off');
  717. $curPerm['own']['select'] = in_array($perm['id'] . '_own', $permissions[$permissionType]['allowed']) ? 'on' : (in_array($perm['id'] . '_own', $permissions[$permissionType]['denied']) ? 'denied' : 'off');
  718. }
  719. else
  720. $curPerm['select'] = in_array($perm['id'], $permissions[$permissionType]['denied']) ? 'denied' : (in_array($perm['id'], $permissions[$permissionType]['allowed']) ? 'on' : 'off');
  721. }
  722. else
  723. {
  724. $curPerm['select'] = in_array($perm['id'], $permissions[$permissionType]['denied']) ? 'denied' : (in_array($perm['id'], $permissions[$permissionType]['allowed']) ? 'on' : 'off');
  725. }
  726. }
  727. }
  728. }
  729. }
  730. $context['sub_template'] = 'modify_group';
  731. $context['page_title'] = $txt['permissions_modify_group'];
  732. createToken('admin-mp');
  733. }
  734. /**
  735. * This function actually saves modifications to a membergroup's board permissions.
  736. */
  737. function ModifyMembergroup2()
  738. {
  739. global $modSettings, $smcFunc, $context;
  740. checkSession();
  741. validateToken('admin-mp');
  742. loadIllegalPermissions();
  743. $_GET['group'] = (int) $_GET['group'];
  744. $_GET['pid'] = (int) $_GET['pid'];
  745. // Cannot modify predefined profiles.
  746. if ($_GET['pid'] > 1 && $_GET['pid'] < 5)
  747. fatal_lang_error('no_access', false);
  748. // Verify this isn't inherited.
  749. if ($_GET['group'] == -1 || $_GET['group'] == 0)
  750. $parent = -2;
  751. else
  752. {
  753. $result = $smcFunc['db_query']('', '
  754. SELECT id_parent
  755. FROM {db_prefix}membergroups
  756. WHERE id_group = {int:current_group}
  757. LIMIT 1',
  758. array(
  759. 'current_group' => $_GET['group'],
  760. )
  761. );
  762. list ($parent) = $smcFunc['db_fetch_row']($result);
  763. $smcFunc['db_free_result']($result);
  764. }
  765. if ($parent != -2)
  766. fatal_lang_error('cannot_edit_permissions_inherited');
  767. $givePerms = array('membergroup' => array(), 'board' => array());
  768. // Guest group, we need illegal, guest permissions.
  769. if ($_GET['group'] == -1)
  770. {
  771. loadIllegalGuestPermissions();
  772. $context['illegal_permissions'] = array_merge($context['illegal_permissions'], $context['non_guest_permissions']);
  773. }
  774. // Prepare all permissions that were set or denied for addition to the DB.
  775. if (isset($_POST['perm']) && is_array($_POST['perm']))
  776. {
  777. foreach ($_POST['perm'] as $perm_type => $perm_array)
  778. {
  779. if (is_array($perm_array))
  780. {
  781. foreach ($perm_array as $permission => $value)
  782. if ($value == 'on' || $value == 'deny')
  783. {
  784. // Don't allow people to escalate themselves!
  785. if (!empty($context['illegal_permissions']) && in_array($permission, $context['illegal_permissions']))
  786. continue;
  787. $givePerms[$perm_type][] = array($_GET['group'], $permission, $value == 'deny' ? 0 : 1);
  788. }
  789. }
  790. }
  791. }
  792. // Insert the general permissions.
  793. if ($_GET['group'] != 3 && empty($_GET['pid']))
  794. {
  795. $smcFunc['db_query']('', '
  796. DELETE FROM {db_prefix}permissions
  797. WHERE id_group = {int:current_group}
  798. ' . (empty($context['illegal_permissions']) ? '' : ' AND permission NOT IN ({array_string:illegal_permissions})'),
  799. array(
  800. 'current_group' => $_GET['group'],
  801. 'illegal_permissions' => !empty($context['illegal_permissions']) ? $context['illegal_permissions'] : array(),
  802. )
  803. );
  804. if (!empty($givePerms['membergroup']))
  805. {
  806. $smcFunc['db_insert']('replace',
  807. '{db_prefix}permissions',
  808. array('id_group' => 'int', 'permission' => 'string', 'add_deny' => 'int'),
  809. $givePerms['membergroup'],
  810. array('id_group', 'permission')
  811. );
  812. }
  813. }
  814. // Insert the boardpermissions.
  815. $profileid = max(1, $_GET['pid']);
  816. $smcFunc['db_query']('', '
  817. DELETE FROM {db_prefix}board_permissions
  818. WHERE id_group = {int:current_group}
  819. AND id_profile = {int:current_profile}',
  820. array(
  821. 'current_group' => $_GET['group'],
  822. 'current_profile' => $profileid,
  823. )
  824. );
  825. if (!empty($givePerms['board']))
  826. {
  827. foreach ($givePerms['board'] as $k => $v)
  828. $givePerms['board'][$k][] = $profileid;
  829. $smcFunc['db_insert']('replace',
  830. '{db_prefix}board_permissions',
  831. array('id_group' => 'int', 'permission' => 'string', 'add_deny' => 'int', 'id_profile' => 'int'),
  832. $givePerms['board'],
  833. array('id_group', 'permission', 'id_profile')
  834. );
  835. }
  836. // Update any inherited permissions as required.
  837. updateChildPermissions($_GET['group'], $_GET['pid']);
  838. // Clear cached privs.
  839. updateSettings(array('settings_updated' => time()));
  840. redirectexit('action=admin;area=permissions;pid=' . $_GET['pid']);
  841. }
  842. /**
  843. * A screen to set some general settings for permissions.
  844. *
  845. * @param bool $return_config = false
  846. */
  847. function GeneralPermissionSettings($return_config = false)
  848. {
  849. global $context, $modSettings, $sourcedir, $txt, $scripturl, $smcFunc;
  850. // All the setting variables
  851. $config_vars = array(
  852. array('title', 'settings'),
  853. // Inline permissions.
  854. array('permissions', 'manage_permissions'),
  855. '',
  856. // A few useful settings
  857. array('check', 'permission_enable_deny', 0, $txt['permission_settings_enable_deny'], 'help' => 'permissions_deny'),
  858. array('check', 'permission_enable_postgroups', 0, $txt['permission_settings_enable_postgroups'], 'help' => 'permissions_postgroups'),
  859. );
  860. if ($return_config)
  861. return $config_vars;
  862. $context['page_title'] = $txt['permission_settings_title'];
  863. $context['sub_template'] = 'show_settings';
  864. // Needed for the inline permission functions, and the settings template.
  865. require_once($sourcedir . '/ManageServer.php');
  866. // Don't let guests have these permissions.
  867. $context['post_url'] = $scripturl . '?action=admin;area=permissions;save;sa=settings';
  868. $context['permissions_excluded'] = array(-1);
  869. // Saving the settings?
  870. if (isset($_GET['save']))
  871. {
  872. checkSession('post');
  873. saveDBSettings($config_vars);
  874. // Clear all deny permissions...if we want that.
  875. if (empty($modSettings['permission_enable_deny']))
  876. {
  877. $smcFunc['db_query']('', '
  878. DELETE FROM {db_prefix}permissions
  879. WHERE add_deny = {int:denied}',
  880. array(
  881. 'denied' => 0,
  882. )
  883. );
  884. $smcFunc['db_query']('', '
  885. DELETE FROM {db_prefix}board_permissions
  886. WHERE add_deny = {int:denied}',
  887. array(
  888. 'denied' => 0,
  889. )
  890. );
  891. }
  892. // Make sure there are no postgroup based permissions left.
  893. if (empty($modSettings['permission_enable_postgroups']))
  894. {
  895. // Get a list of postgroups.
  896. $post_groups = array();
  897. $request = $smcFunc['db_query']('', '
  898. SELECT id_group
  899. FROM {db_prefix}membergroups
  900. WHERE min_posts != {int:min_posts}',
  901. array(
  902. 'min_posts' => -1,
  903. )
  904. );
  905. while ($row = $smcFunc['db_fetch_assoc']($request))
  906. $post_groups[] = $row['id_group'];
  907. $smcFunc['db_free_result']($request);
  908. // Remove'em.
  909. $smcFunc['db_query']('', '
  910. DELETE FROM {db_prefix}permissions
  911. WHERE id_group IN ({array_int:post_group_list})',
  912. array(
  913. 'post_group_list' => $post_groups,
  914. )
  915. );
  916. $smcFunc['db_query']('', '
  917. DELETE FROM {db_prefix}board_permissions
  918. WHERE id_group IN ({array_int:post_group_list})',
  919. array(
  920. 'post_group_list' => $post_groups,
  921. )
  922. );
  923. $smcFunc['db_query']('', '
  924. UPDATE {db_prefix}membergroups
  925. SET id_parent = {int:not_inherited}
  926. WHERE id_parent IN ({array_int:post_group_list})',
  927. array(
  928. 'post_group_list' => $post_groups,
  929. 'not_inherited' => -2,
  930. )
  931. );
  932. }
  933. redirectexit('action=admin;area=permissions;sa=settings');
  934. }
  935. prepareDBSettingContext($config_vars);
  936. }
  937. /**
  938. * Set the permission level for a specific profile, group, or group for a profile.
  939. * @internal
  940. *
  941. * @param string $level
  942. * @param int $group
  943. * @param mixed $profile = null, int expected
  944. */
  945. function setPermissionLevel($level, $group, $profile = 'null')
  946. {
  947. global $smcFunc, $context;
  948. loadIllegalPermissions();
  949. loadIllegalGuestPermissions();
  950. // Levels by group... restrict, standard, moderator, maintenance.
  951. $groupLevels = array(
  952. 'board' => array('inherit' => array()),
  953. 'group' => array('inherit' => array())
  954. );
  955. // Levels by board... standard, publish, free.
  956. $boardLevels = array('inherit' => array());
  957. // Restrictive - ie. guests.
  958. $groupLevels['global']['restrict'] = array(
  959. 'search_posts',
  960. 'calendar_view',
  961. 'view_stats',
  962. 'who_view',
  963. 'profile_view_own',
  964. 'profile_identity_own',
  965. );
  966. $groupLevels['board']['restrict'] = array(
  967. 'poll_view',
  968. 'post_new',
  969. 'post_reply_own',
  970. 'post_reply_any',
  971. 'delete_own',
  972. 'modify_own',
  973. 'mark_any_notify',
  974. 'mark_notify',
  975. 'report_any',
  976. 'send_topic',
  977. );
  978. // Standard - ie. members. They can do anything Restrictive can.
  979. $groupLevels['global']['standard'] = array_merge($groupLevels['global']['restrict'], array(
  980. 'view_mlist',
  981. 'karma_edit',
  982. 'pm_read',
  983. 'pm_send',
  984. 'profile_view_any',
  985. 'profile_extra_own',
  986. 'profile_server_avatar',
  987. 'profile_upload_avatar',
  988. 'profile_remote_avatar',
  989. 'profile_remove_own',
  990. ));
  991. $groupLevels['board']['standard'] = array_merge($groupLevels['board']['restrict'], array(
  992. 'poll_vote',
  993. 'poll_edit_own',
  994. 'poll_post',
  995. 'poll_add_own',
  996. 'post_attachment',
  997. 'lock_own',
  998. 'remove_own',
  999. 'view_attachments',
  1000. ));
  1001. // Moderator - ie. moderators :P. They can do what standard can, and more.
  1002. $groupLevels['global']['moderator'] = array_merge($groupLevels['global']['standard'], array(
  1003. 'calendar_post',
  1004. 'calendar_edit_own',
  1005. 'access_mod_center',
  1006. 'issue_warning',
  1007. ));
  1008. $groupLevels['board']['moderator'] = array_merge($groupLevels['board']['standard'], array(
  1009. 'make_sticky',
  1010. 'poll_edit_any',
  1011. 'delete_any',
  1012. 'modify_any',
  1013. 'lock_any',
  1014. 'remove_any',
  1015. 'move_any',
  1016. 'merge_any',
  1017. 'split_any',
  1018. 'poll_lock_any',
  1019. 'poll_remove_any',
  1020. 'poll_add_any',
  1021. 'approve_posts',
  1022. ));
  1023. // Maintenance - wannabe admins. They can do almost everything.
  1024. $groupLevels['global']['maintenance'] = array_merge($groupLevels['global']['moderator'], array(
  1025. 'manage_attachments',
  1026. 'manage_smileys',
  1027. 'manage_boards',
  1028. 'moderate_forum',
  1029. 'manage_membergroups',
  1030. 'manage_bans',
  1031. 'admin_forum',
  1032. 'manage_permissions',
  1033. 'edit_news',
  1034. 'calendar_edit_any',
  1035. 'profile_identity_any',
  1036. 'profile_extra_any',
  1037. 'profile_title_any',
  1038. ));
  1039. $groupLevels['board']['maintenance'] = array_merge($groupLevels['board']['moderator'], array(
  1040. ));
  1041. // Standard - nothing above the group permissions. (this SHOULD be empty.)
  1042. $boardLevels['standard'] = array(
  1043. );
  1044. // Locked - just that, you can't post here.
  1045. $boardLevels['locked'] = array(
  1046. 'poll_view',
  1047. 'mark_notify',
  1048. 'report_any',
  1049. 'send_topic',
  1050. 'view_attachments',
  1051. );
  1052. // Publisher - just a little more...
  1053. $boardLevels['publish'] = array_merge($boardLevels['locked'], array(
  1054. 'post_new',
  1055. 'post_reply_own',
  1056. 'post_reply_any',
  1057. 'delete_own',
  1058. 'modify_own',
  1059. 'mark_any_notify',
  1060. 'delete_replies',
  1061. 'modify_replies',
  1062. 'poll_vote',
  1063. 'poll_edit_own',
  1064. 'poll_post',
  1065. 'poll_add_own',
  1066. 'poll_remove_own',
  1067. 'post_attachment',
  1068. 'lock_own',
  1069. 'remove_own',
  1070. ));
  1071. // Free for All - Scary. Just scary.
  1072. $boardLevels['free'] = array_merge($boardLevels['publish'], array(
  1073. 'poll_lock_any',
  1074. 'poll_edit_any',
  1075. 'poll_add_any',
  1076. 'poll_remove_any',
  1077. 'make_sticky',
  1078. 'lock_any',
  1079. 'remove_any',
  1080. 'delete_any',
  1081. 'split_any',
  1082. 'merge_any',
  1083. 'modify_any',
  1084. 'approve_posts',
  1085. ));
  1086. // Make sure we're not granting someone too many permissions!
  1087. foreach ($groupLevels['global'][$level] as $k => $permission)
  1088. {
  1089. if (!empty($context['illegal_permissions']) && in_array($permission, $context['illegal_permissions']))
  1090. unset($groupLevels['global'][$level][$k]);
  1091. if ($group == -1 && in_array($permission, $context['non_guest_permissions']))
  1092. unset($groupLevels['global'][$level][$k]);
  1093. }
  1094. if ($group == -1)
  1095. foreach ($groupLevels['board'][$level] as $k => $permission)
  1096. if (in_array($permission, $context['non_guest_permissions']))
  1097. unset($groupLevels['board'][$level][$k]);
  1098. // Reset all cached permissions.
  1099. updateSettings(array('settings_updated' => time()));
  1100. // Setting group permissions.
  1101. if ($profile === 'null' && $group !== 'null')
  1102. {
  1103. $group = (int) $group;
  1104. if (empty($groupLevels['global'][$level]))
  1105. return;
  1106. $smcFunc['db_query']('', '
  1107. DELETE FROM {db_prefix}permissions
  1108. WHERE id_group = {int:current_group}
  1109. ' . (empty($context['illegal_permissions']) ? '' : ' AND permission NOT IN ({array_string:illegal_permissions})'),
  1110. array(
  1111. 'current_group' => $group,
  1112. 'illegal_permissions' => !empty($context['illegal_permissions']) ? $context['illegal_permissions'] : array(),
  1113. )
  1114. );
  1115. $smcFunc['db_query']('', '
  1116. DELETE FROM {db_prefix}board_permissions
  1117. WHERE id_group = {int:current_group}
  1118. AND id_profile = {int:default_profile}',
  1119. array(
  1120. 'current_group' => $group,
  1121. 'default_profile' => 1,
  1122. )
  1123. );
  1124. $groupInserts = array();
  1125. foreach ($groupLevels['global'][$level] as $permission)
  1126. $groupInserts[] = array($group, $permission);
  1127. $smcFunc['db_insert']('insert',
  1128. '{db_prefix}permissions',
  1129. array('id_group' => 'int', 'permission' => 'string'),
  1130. $groupInserts,
  1131. array('id_group')
  1132. );
  1133. $boardInserts = array();
  1134. foreach ($groupLevels['board'][$level] as $permission)
  1135. $boardInserts[] = array(1, $group, $permission);
  1136. $smcFunc['db_insert']('insert',
  1137. '{db_prefix}board_permissions',
  1138. array('id_profile' => 'int', 'id_group' => 'int', 'permission' => 'string'),
  1139. $boardInserts,
  1140. array('id_profile', 'id_group')
  1141. );
  1142. }
  1143. // Setting profile permissions for a specific group.
  1144. elseif ($profile !== 'null' && $group !== 'null' && ($profile == 1 || $profile > 4))
  1145. {
  1146. $group = (int) $group;
  1147. $profile = (int) $profile;
  1148. if (!empty($groupLevels['global'][$level]))
  1149. {
  1150. $smcFunc['db_query']('', '
  1151. DELETE FROM {db_prefix}board_permissions
  1152. WHERE id_group = {int:current_group}
  1153. AND id_profile = {int:current_profile}',
  1154. array(
  1155. 'current_group' => $group,
  1156. 'current_profile' => $profile,
  1157. )
  1158. );
  1159. }
  1160. if (!empty($groupLevels['board'][$level]))
  1161. {
  1162. $boardInserts = array();
  1163. foreach ($groupLevels['board'][$level] as $permission)
  1164. $boardInserts[] = array($profile, $group, $permission);
  1165. $smcFunc['db_insert']('insert',
  1166. '{db_prefix}board_permissions',
  1167. array('id_profile' => 'int', 'id_group' => 'int', 'permission' => 'string'),
  1168. $boardInserts,
  1169. array('id_profile', 'id_group')
  1170. );
  1171. }
  1172. }
  1173. // Setting profile permissions for all groups.
  1174. elseif ($profile !== 'null' && $group === 'null' && ($profile == 1 || $profile > 4))
  1175. {
  1176. $profile = (int) $profile;
  1177. $smcFunc['db_query']('', '
  1178. DELETE FROM {db_prefix}board_permissions
  1179. WHERE id_profile = {int:current_profile}',
  1180. array(
  1181. 'current_profile' => $profile,
  1182. )
  1183. );
  1184. if (empty($boardLevels[$level]))
  1185. return;
  1186. // Get all the groups...
  1187. $query = $smcFunc['db_query']('', '
  1188. SELECT id_group
  1189. FROM {db_prefix}membergroups
  1190. WHERE id_group > {int:moderator_group}
  1191. ORDER BY min_posts, CASE WHEN id_group < {int:newbie_group} THEN id_group ELSE 4 END, group_name',
  1192. array(
  1193. 'moderator_group' => 3,
  1194. 'newbie_group' => 4,
  1195. )
  1196. );
  1197. while ($row = $smcFunc['db_fetch_row']($query))
  1198. {
  1199. $group = $row[0];
  1200. $boardInserts = array();
  1201. foreach ($boardLevels[$level] as $permission)
  1202. $boardInserts[] = array($profile, $group, $permission);
  1203. $smcFunc['db_insert']('insert',
  1204. '{db_prefix}board_permissions',
  1205. array('id_profile' => 'int', 'id_group' => 'int', 'permission' => 'string'),
  1206. $boardInserts,
  1207. array('id_profile', 'id_group')
  1208. );
  1209. }
  1210. $smcFunc['db_free_result']($query);
  1211. // Add permissions for ungrouped members.
  1212. $boardInserts = array();
  1213. foreach ($boardLevels[$level] as $permission)
  1214. $boardInserts[] = array($profile, 0, $permission);
  1215. $smcFunc['db_insert']('insert',
  1216. '{db_prefix}board_permissions',
  1217. array('id_profile' => 'int', 'id_group' => 'int', 'permission' => 'string'),
  1218. $boardInserts,
  1219. array('id_profile', 'id_group')
  1220. );
  1221. }
  1222. // $profile and $group are both null!
  1223. else
  1224. fatal_lang_error('no_access', false);
  1225. }
  1226. /**
  1227. * Load permissions into $context['permissions'].
  1228. * @internal
  1229. *
  1230. * @param string $loadType, options: 'classic' or 'simple'
  1231. */
  1232. function loadAllPermissions($loadType = 'classic')
  1233. {
  1234. global $context, $txt, $modSettings;
  1235. // List of all the groups dependant on the currently selected view - for the order so it looks pretty, yea?
  1236. // Note to Mod authors - you don't need to stick your permission group here if you don't mind SMF sticking it the last group of the page.
  1237. $permissionGroups = array(
  1238. 'membergroup' => array(
  1239. 'simple' => array(
  1240. 'view_basic_info',
  1241. 'use_pm_system',
  1242. 'post_calendar',
  1243. 'edit_profile',
  1244. 'delete_account',
  1245. 'use_avatar',
  1246. 'moderate_general',
  1247. 'administrate',
  1248. ),
  1249. 'classic' => array(
  1250. 'general',
  1251. 'pm',
  1252. 'calendar',
  1253. 'maintenance',
  1254. 'member_admin',
  1255. 'profile',
  1256. ),
  1257. ),
  1258. 'board' => array(
  1259. 'simple' => array(
  1260. 'make_posts',
  1261. 'make_unapproved_posts',
  1262. 'post_polls',
  1263. 'participate',
  1264. 'modify',
  1265. 'notification',
  1266. 'attach',
  1267. 'moderate',
  1268. ),
  1269. 'classic' => array(
  1270. 'general_board',
  1271. 'topic',
  1272. 'post',
  1273. 'poll',
  1274. 'notification',
  1275. 'attachment',
  1276. ),
  1277. ),
  1278. );
  1279. /* The format of this list is as follows:
  1280. 'membergroup' => array(
  1281. 'permissions_inside' => array(has_multiple_options, classic_view_group, simple_view_group(_own)*, simple_view_group_any*),
  1282. ),
  1283. 'board' => array(
  1284. 'permissions_inside' => array(has_multiple_options, classic_view_group, simple_view_group(_own)*, simple_view_group_any*),
  1285. );
  1286. */
  1287. $permissionList = array(
  1288. 'membergroup' => array(
  1289. 'view_stats' => array(false, 'general', 'view_basic_info'),
  1290. 'view_mlist' => array(false, 'general', 'view_basic_info'),
  1291. 'who_view' => array(false, 'general', 'view_basic_info'),
  1292. 'search_posts' => array(false, 'general', 'view_basic_info'),
  1293. 'karma_edit' => array(false, 'general', 'moderate_general'),
  1294. 'pm_read' => array(false, 'pm', 'use_pm_system'),
  1295. 'pm_send' => array(false, 'pm', 'use_pm_system'),
  1296. 'calendar_view' => array(false, 'calendar', 'view_basic_info'),
  1297. 'calendar_post' => array(false, 'calendar', 'post_calendar'),
  1298. 'calendar_edit' => array(true, 'calendar', 'post_calendar', 'moderate_general'),
  1299. 'admin_forum' => array(false, 'maintenance', 'administrate'),
  1300. 'manage_boards' => array(false, 'maintenance', 'administrate'),
  1301. 'manage_attachments' => array(false, 'maintenance', 'administrate'),
  1302. 'manage_smileys' => array(false, 'maintenance', 'administrate'),
  1303. 'edit_news' => array(false, 'maintenance', 'administrate'),
  1304. 'access_mod_center' => array(false, 'maintenance', 'moderate_general'),
  1305. 'moderate_forum' => array(false, 'member_admin', 'moderate_general'),
  1306. 'manage_membergroups' => array(false, 'member_admin', 'administrate'),
  1307. 'manage_permissions' => array(false, 'member_admin', 'administrate'),
  1308. 'manage_bans' => array(false, 'member_admin', 'administrate'),
  1309. 'send_mail' => array(false, 'member_admin', 'administrate'),
  1310. 'issue_warning' => array(false, 'member_admin', 'moderate_general'),
  1311. 'profile_view' => array(true, 'profile', 'view_basic_info', 'view_basic_info'),
  1312. 'profile_identity' => array(true, 'profile', 'edit_profile', 'moderate_general'),
  1313. 'profile_extra' => array(true, 'profile', 'edit_profile', 'moderate_general'),
  1314. 'profile_title' => array(true, 'profile', 'edit_profile', 'moderate_general'),
  1315. 'profile_remove' => array(true, 'profile', 'delete_account', 'moderate_general'),
  1316. 'profile_server_avatar' => array(false, 'profile', 'use_avatar'),
  1317. 'profile_upload_avatar' => array(false, 'profile', 'use_avatar'),
  1318. 'profile_remote_avatar' => array(false, 'profile', 'use_avatar'),
  1319. ),
  1320. 'board' => array(
  1321. 'moderate_board' => array(false, 'general_board', 'moderate'),
  1322. 'approve_posts' => array(false, 'general_board', 'moderate'),
  1323. 'post_new' => array(false, 'topic', 'make_posts'),
  1324. 'post_unapproved_topics' => array(false, 'topic', 'make_unapproved_posts'),
  1325. 'post_unapproved_replies' => array(true, 'topic', 'make_unapproved_posts', 'make_unapproved_posts'),
  1326. 'post_reply' => array(true, 'topic', 'make_posts', 'make_posts'),
  1327. 'merge_any' => array(false, 'topic', 'moderate'),
  1328. 'split_any' => array(false, 'topic', 'moderate'),
  1329. 'send_topic' => array(false, 'topic', 'moderate'),
  1330. 'make_sticky' => array(false, 'topic', 'moderate'),
  1331. 'move' => array(true, 'topic', 'moderate', 'moderate'),
  1332. 'lock' => array(true, 'topic', 'moderate', 'moderate'),
  1333. 'remove' => array(true, 'topic', 'modify', 'moderate'),
  1334. 'modify_replies' => array(false, 'topic', 'moderate'),
  1335. 'delete_replies' => array(false, 'topic', 'moderate'),
  1336. 'announce_topic' => array(false, 'topic', 'moderate'),
  1337. 'delete' => array(true, 'post', 'modify', 'moderate'),
  1338. 'modify' => array(true, 'post', 'modify', 'moderate'),
  1339. 'report_any' => array(false, 'post', 'participate'),
  1340. 'poll_view' => array(false, 'poll', 'participate'),
  1341. 'poll_vote' => array(false, 'poll', 'participate'),
  1342. 'poll_post' => array(false, 'poll', 'post_polls'),
  1343. 'poll_add' => array(true, 'poll', 'post_polls', 'moderate'),
  1344. 'poll_edit' => array(true, 'poll', 'modify', 'moderate'),
  1345. 'poll_lock' => array(true, 'poll', 'moderate', 'moderate'),
  1346. 'poll_remove' => array(true, 'poll', 'modify', 'moderate'),
  1347. 'mark_any_notify' => array(false, 'notification', 'notification'),
  1348. 'mark_notify' => array(false, 'notification', 'notification'),
  1349. 'view_attachments' => array(false, 'attachment', 'participate'),
  1350. 'post_unapproved_attachments' => array(false, 'attachment', 'make_unapproved_posts'),
  1351. 'post_attachment' => array(false, 'attachment', 'attach'),
  1352. ),
  1353. );
  1354. // All permission groups that will be shown in the left column on classic view.
  1355. $leftPermissionGroups = array(
  1356. 'general',
  1357. 'calendar',
  1358. 'maintenance',
  1359. 'member_admin',
  1360. 'topic',
  1361. 'post',
  1362. );
  1363. // We need to know what permissions we can't give to guests.
  1364. loadIllegalGuestPermissions();
  1365. // Some permissions are hidden if features are off.
  1366. $hiddenPermissions = array();
  1367. $relabelPermissions = array(); // Permissions to apply a different label to.
  1368. $relabelGroups = array(); // As above but for groups.
  1369. if (!in_array('cd', $context['admin_features']))
  1370. {
  1371. $hiddenPermissions[] = 'calendar_view';
  1372. $hiddenPermissions[] = 'calendar_post';
  1373. $hiddenPermissions[] = 'calendar_edit';
  1374. }
  1375. if (!in_array('w', $context['admin_features']))
  1376. $hiddenPermissions[] = 'issue_warning';
  1377. // Post moderation?
  1378. if (!$modSettings['postmod_active'])
  1379. {
  1380. $hiddenPermissions[] = 'approve_posts';
  1381. $hiddenPermissions[] = 'post_unapproved_topics';
  1382. $hiddenPermissions[] = 'post_unapproved_replies';
  1383. $hiddenPermissions[] = 'post_unapproved_attachments';
  1384. }
  1385. // If we show them on classic view we change the name.
  1386. else
  1387. {
  1388. // Relabel the topics permissions
  1389. $relabelPermissions['post_new'] = 'auto_approve_topics';
  1390. // Relabel the reply permissions
  1391. $relabelPermissions['post_reply'] = 'auto_approve_replies';
  1392. // Relabel the attachment permissions
  1393. $relabelPermissions['post_attachment'] = 'auto_approve_attachments';
  1394. }
  1395. // Provide a practical way to modify permissions.
  1396. call_integration_hook('integrate_load_permissions', array(&$permissionGroups, &$permissionList, &$leftPermissionGroups, &$hiddenPermissions, &$relabelPermissions));
  1397. $context['permissions'] = array();
  1398. $context['hidden_permissions'] = array();
  1399. foreach ($permissionList as $permissionType => $permissionList)
  1400. {
  1401. $context['permissions'][$permissionType] = array(
  1402. 'id' => $permissionType,
  1403. 'view' => $loadType,
  1404. 'columns' => array()
  1405. );
  1406. foreach ($permissionList as $permission => $permissionArray)
  1407. {
  1408. // If this is a guest permission we don't do it if it's the guest group.
  1409. if (isset($context['group']['id']) && $context['group']['id'] == -1 && in_array($permission, $context['non_guest_permissions']))
  1410. continue;
  1411. // What groups will this permission be in?
  1412. $own_group = $permissionArray[($loadType == 'classic' ? 1 : 2)];
  1413. $any_group = $loadType == 'simple' && !empty($permissionArray[3]) ? $permissionArray[3] : ($loadType == 'simple' && $permissionArray[0] ? $permissionArray[2] : '');
  1414. // First, Do these groups actually exist - if not add them.
  1415. if (!isset($permissionGroups[$permissionType][$loadType][$own_group]))
  1416. $permissionGroups[$permissionType][$loadType][$own_group] = true;
  1417. if (!empty($any_group) && !isset($permissionGroups[$permissionType][$loadType][$any_group]))
  1418. $permissionGroups[$permissionType][$loadType][$any_group] = true;
  1419. // What column should this be located into?
  1420. $position = $loadType == 'classic' && !in_array($own_group, $leftPermissionGroups) ? 1 : 0;
  1421. // If the groups have not yet been created be sure to create them.
  1422. $bothGroups = array('own' => $own_group);
  1423. $bothGroups = array();
  1424. // For guests, just reset the array.
  1425. if (!isset($context['group']['id']) || !($context['group']['id'] == -1 && $any_group))
  1426. $bothGroups['own'] = $own_group;
  1427. if ($any_group)
  1428. {
  1429. $bothGroups['any'] = $any_group;
  1430. }
  1431. foreach ($bothGroups as $group)
  1432. if (!isset($context['permissions'][$permissionType]['columns'][$position][$group]))
  1433. $context['permissions'][$permissionType]['columns'][$position][$group] = array(
  1434. 'type' => $permissionType,
  1435. 'id' => $group,
  1436. 'name' => $loadType == 'simple' ? (isset($txt['permissiongroup_simple_' . $group]) ? $txt['permissiongroup_simple_' . $group] : '') : $txt['permissiongroup_' . $group],
  1437. 'icon' => isset($txt['permissionicon_' . $group]) ? $txt['permissionicon_' . $group] : $txt['permissionicon'],
  1438. 'help' => isset($txt['permissionhelp_' . $group]) ? $txt['permissionhelp_' . $group] : '',
  1439. 'hidden' => false,
  1440. 'permissions' => array()
  1441. );
  1442. // This is where we set up the permission dependant on the view.
  1443. if ($loadType == 'classic')
  1444. {
  1445. $context['permissions'][$permissionType]['columns'][$position][$own_group]['permissions'][$permission] = array(
  1446. 'id' => $permission,
  1447. 'name' => !isset($relabelPermissions[$permission]) ? $txt['permissionname_' . $permission] : $txt[$relabelPermissions[$permission]],
  1448. 'show_help' => isset($txt['permissionhelp_' . $permission]),
  1449. 'note' => isset($txt['permissionnote_' . $permission]) ? $txt['permissionnote_' . $permission] : '',
  1450. 'has_own_any' => $permissionArray[0],
  1451. 'own' => array(
  1452. 'id' => $permission . '_own',
  1453. 'name' => $permissionArray[0] ? $txt['permissionname_' . $permission . '_own'] : ''
  1454. ),
  1455. 'any' => array(
  1456. 'id' => $permission . '_any',
  1457. 'name' => $permissionArray[0] ? $txt['permissionname_' . $permission . '_any'] : ''
  1458. ),
  1459. 'hidden' => in_array($permission, $hiddenPermissions),
  1460. );
  1461. }
  1462. else
  1463. {
  1464. foreach ($bothGroups as $group_type => $group)
  1465. {
  1466. $context['permissions'][$permissionType]['columns'][$position][$group]['permissions'][$permission . ($permissionArray[0] ? '_' . $group_type : '')] = array(
  1467. 'id' => $permission . ($permissionArray[0] ? '_' . $group_type : ''),
  1468. 'name' => isset($txt['permissionname_simple_' . $permission . ($permissionArray[0] ? '_' . $group_type : '')]) ? $txt['permissionname_simple_' . $permission . ($permissionArray[0] ? '_' . $group_type : '')] : $txt['permissionname_' . $permission],
  1469. 'help_index' => isset($txt['permissionhelp_' . $permission]) ? 'permissionhelp_' . $permission : '',
  1470. 'hidden' => in_array($permission, $hiddenPermissions),
  1471. );
  1472. }
  1473. }
  1474. if (in_array($permission, $hiddenPermissions))
  1475. {
  1476. if ($permissionArray[0])
  1477. {
  1478. $context['hidden_permissions'][] = $permission . '_own';
  1479. $context['hidden_permissions'][] = $permission . '_any';
  1480. }
  1481. else
  1482. $context['hidden_permissions'][] = $permission;
  1483. }
  1484. }
  1485. ksort($context['permissions'][$permissionType]['columns']);
  1486. }
  1487. // Check we don't leave any empty groups - and mark hidden ones as such.
  1488. foreach ($context['permissions'][$permissionType]['columns'] as $column => $groups)
  1489. foreach ($groups as $id => $group)
  1490. {
  1491. if (empty($group['permissions']))
  1492. unset($context['permissions'][$permissionType]['columns'][$column][$id]);
  1493. else
  1494. {
  1495. $foundNonHidden = false;
  1496. foreach ($group['permissions'] as $permission)
  1497. if (empty($permission['hidden']))
  1498. $foundNonHidden = true;
  1499. if (!$foundNonHidden)
  1500. $context['permissions'][$permissionType]['columns'][$column][$id]['hidden'] = true;
  1501. }
  1502. }
  1503. }
  1504. //
  1505. /**
  1506. * Initialize a form with inline permissions settings.
  1507. * It loads a context variables for each permission.
  1508. * This function is used by several settings screens to set specific permissions.
  1509. * @internal
  1510. *
  1511. * @param array $permissions
  1512. * @param array $excluded_groups = array()
  1513. *
  1514. * @uses ManagePermissions language
  1515. * @uses ManagePermissions template.
  1516. */
  1517. function init_inline_permissions($permissions, $excluded_groups = array())
  1518. {
  1519. global $context, $txt, $modSettings, $smcFunc;
  1520. loadLanguage('ManagePermissions');
  1521. loadTemplate('ManagePermissions');
  1522. $context['can_change_permissions'] = allowedTo('manage_permissions');
  1523. // Nothing to initialize here.
  1524. if (!$context['can_change_permissions'])
  1525. return;
  1526. // Load the permission settings for guests
  1527. foreach ($permissions as $permission)
  1528. $context[$permission] = array(
  1529. -1 => array(
  1530. 'id' => -1,
  1531. 'name' => $txt['membergroups_guests'],
  1532. 'is_postgroup' => false,
  1533. 'status' => 'off',
  1534. ),
  1535. 0 => array(
  1536. 'id' => 0,
  1537. 'name' => $txt['membergroups_members'],
  1538. 'is_postgroup' => false,
  1539. 'status' => 'off',
  1540. ),
  1541. );
  1542. $request = $smcFunc['db_query']('', '
  1543. SELECT id_group, CASE WHEN add_deny = {int:denied} THEN {string:deny} ELSE {string:on} END AS status, permission
  1544. FROM {db_prefix}permissions
  1545. WHERE id_group IN (-1, 0)
  1546. AND permission IN ({array_string:permissions})',
  1547. array(
  1548. 'denied' => 0,
  1549. 'permissions' => $permissions,
  1550. 'deny' => 'deny',
  1551. 'on' => 'on',
  1552. )
  1553. );
  1554. while ($row = $smcFunc['db_fetch_assoc']($request))
  1555. $context[$row['permission']][$row['id_group']]['status'] = $row['status'];
  1556. $smcFunc['db_free_result']($request);
  1557. $request = $smcFunc['db_query']('', '
  1558. SELECT mg.id_group, mg.group_name, mg.min_posts, IFNULL(p.add_deny, -1) AS status, p.permission
  1559. FROM {db_prefix}membergroups AS mg
  1560. LEFT JOIN {db_prefix}permissions AS p ON (p.id_group = mg.id_group AND p.permission IN ({array_string:permissions}))
  1561. WHERE mg.id_group NOT IN (1, 3)
  1562. AND mg.id_parent = {int:not_inherited}' . (empty($modSettings['permission_enable_postgroups']) ? '
  1563. AND mg.min_posts = {int:min_posts}' : '') . '
  1564. ORDER BY mg.min_posts, CASE WHEN mg.id_group < {int:newbie_group} THEN mg.id_group ELSE 4 END, mg.group_name',
  1565. array(
  1566. 'not_inherited' => -2,
  1567. 'min_posts' => -1,
  1568. 'newbie_group' => 4,
  1569. 'permissions' => $permissions,
  1570. )
  1571. );
  1572. while ($row = $smcFunc['db_fetch_assoc']($request))
  1573. {
  1574. // Initialize each permission as being 'off' until proven otherwise.
  1575. foreach ($permissions as $permission)
  1576. if (!isset($context[$permission][$row['id_group']]))
  1577. $context[$permission][$row['id_group']] = array(
  1578. 'id' => $row['id_group'],
  1579. 'name' => $row['group_name'],
  1580. 'is_postgroup' => $row['min_posts'] != -1,
  1581. 'status' => 'off',
  1582. );
  1583. $context[$row['permission']][$row['id_group']]['status'] = empty($row['status']) ? 'deny' : ($row['status'] == 1 ? 'on' : 'off');
  1584. }
  1585. $smcFunc['db_free_result']($request);
  1586. // Some permissions cannot be given to certain groups. Remove the groups.
  1587. foreach ($excluded_groups as $group)
  1588. {
  1589. foreach ($permissions as $permission)
  1590. {
  1591. if (isset($context[$permission][$group]))
  1592. unset($context[$permission][$group]);
  1593. }
  1594. }
  1595. }
  1596. /**
  1597. * Show a collapsible box to set a specific permission.
  1598. * The function is called by templates to show a list of permissions settings.
  1599. * Calls the template function template_inline_permissions().
  1600. *
  1601. * @param string $permission
  1602. */
  1603. function theme_inline_permissions($permission)
  1604. {
  1605. global $context;
  1606. $context['current_permission'] = $permission;
  1607. $context['member_groups'] = $context[$permission];
  1608. template_inline_permissions();
  1609. }
  1610. /**
  1611. * Save the permissions of a form containing inline permissions.
  1612. * @internal
  1613. *
  1614. * @param array $permissions
  1615. */
  1616. function save_inline_permissions($permissions)
  1617. {
  1618. global $context, $smcFunc;
  1619. // No permissions? Not a great deal to do here.
  1620. if (!allowedTo('manage_permissions'))
  1621. return;
  1622. // Almighty session check, verify our ways.
  1623. checkSession();
  1624. validateToken('admin-mp');
  1625. // Check they can't do certain things.
  1626. loadIllegalPermissions();
  1627. $insertRows = array();
  1628. foreach ($permissions as $permission)
  1629. {
  1630. if (!isset($_POST[$permission]))
  1631. continue;
  1632. foreach ($_POST[$permission] as $id_group => $value)
  1633. {
  1634. if (in_array($value, array('on', 'deny')) && (empty($context['illegal_permissions']) || !in_array($permission, $context['illegal_permissions'])))
  1635. $insertRows[] = array((int) $id_group, $permission, $value == 'on' ? 1 : 0);
  1636. }
  1637. }
  1638. // Remove the old permissions...
  1639. $smcFunc['db_query']('', '
  1640. DELETE FROM {db_prefix}permissions
  1641. WHERE permission IN ({array_string:permissions})
  1642. ' . (empty($context['illegal_permissions']) ? '' : ' AND permission NOT IN ({array_string:illegal_permissions})'),
  1643. array(
  1644. 'illegal_permissions' => !empty($context['illegal_permissions']) ? $context['illegal_permissions'] : array(),
  1645. 'permissions' => $permissions,
  1646. )
  1647. );
  1648. // ...and replace them with new ones.
  1649. if (!empty($insertRows))
  1650. $smcFunc['db_insert']('insert',
  1651. '{db_prefix}permissions',
  1652. array('id_group' => 'int', 'permission' => 'string', 'add_deny' => 'int'),
  1653. $insertRows,
  1654. array('id_group', 'permission')
  1655. );
  1656. // Do a full child update.
  1657. updateChildPermissions(array(), -1);
  1658. // Just in case we cached this.
  1659. updateSettings(array('settings_updated' => time()));
  1660. }
  1661. /**
  1662. * Load permissions profiles.
  1663. */
  1664. function loadPermissionProfiles()
  1665. {
  1666. global $context, $txt, $smcFunc;
  1667. $request = $smcFunc['db_query']('', '
  1668. SELECT id_profile, profile_name
  1669. FROM {db_prefix}permission_profiles
  1670. ORDER BY id_profile',
  1671. array(
  1672. )
  1673. );
  1674. $context['profiles'] = array();
  1675. while ($row = $smcFunc['db_fetch_assoc']($request))
  1676. {
  1677. // Format the label nicely.
  1678. if (isset($txt['permissions_profile_' . $row['profile_name']]))
  1679. $name = $txt['permissions_profile_' . $row['profile_name']];
  1680. else
  1681. $name = $row['profile_name'];
  1682. $context['profiles'][$row['id_profile']] = array(
  1683. 'id' => $row['id_profile'],
  1684. 'name' => $name,
  1685. 'can_modify' => $row['id_profile'] == 1 || $row['id_profile'] > 4,
  1686. 'unformatted_name' => $row['profile_name'],
  1687. );
  1688. }
  1689. $smcFunc['db_free_result']($request);
  1690. }
  1691. /**
  1692. * Add/Edit/Delete profiles.
  1693. */
  1694. function EditPermissionProfiles()
  1695. {
  1696. global $context, $txt, $smcFunc;
  1697. // Setup the template, first for fun.
  1698. $context['page_title'] = $txt['permissions_profile_edit'];
  1699. $context['sub_template'] = 'edit_profiles';
  1700. // If we're creating a new one do it first.
  1701. if (isset($_POST['create']) && trim($_POST['profile_name']) != '')
  1702. {
  1703. checkSession();
  1704. validateToken('admin-mpp');
  1705. $_POST['copy_from'] = (int) $_POST['copy_from'];
  1706. $_POST['profile_name'] = $smcFunc['htmlspecialchars']($_POST['profile_name']);
  1707. // Insert the profile itself.
  1708. $smcFunc['db_insert']('',
  1709. '{db_prefix}permission_profiles',
  1710. array(
  1711. 'profile_name' => 'string',
  1712. ),
  1713. array(
  1714. $_POST['profile_name'],
  1715. ),
  1716. array('id_profile')
  1717. );
  1718. $profile_id = $smcFunc['db_insert_id']('{db_prefix}permission_profiles', 'id_profile');
  1719. // Load the permissions from the one it's being copied from.
  1720. $request = $smcFunc['db_query']('', '
  1721. SELECT id_group, permission, add_deny
  1722. FROM {db_prefix}board_permissions
  1723. WHERE id_profile = {int:copy_from}',
  1724. array(
  1725. 'copy_from' => $_POST['copy_from'],
  1726. )
  1727. );
  1728. $inserts = array();
  1729. while ($row = $smcFunc['db_fetch_assoc']($request))
  1730. $inserts[] = array($profile_id, $row['id_group'], $row['permission'], $row['add_deny']);
  1731. $smcFunc['db_free_result']($request);
  1732. if (!empty($inserts))
  1733. $smcFunc['db_insert']('insert',
  1734. '{db_prefix}board_permissions',
  1735. array('id_profile' => 'int', 'id_group' => 'int', 'permission' => 'string', 'add_deny' => 'int'),
  1736. $inserts,
  1737. array('id_profile', 'id_group', 'permission')
  1738. );
  1739. }
  1740. // Renaming?
  1741. elseif (isset($_POST['rename']))
  1742. {
  1743. checkSession();
  1744. validateToken('admin-mpp');
  1745. // Just showing the boxes?
  1746. if (!isset($_POST['rename_profile']))
  1747. $context['show_rename_boxes'] = true;
  1748. else
  1749. {
  1750. foreach ($_POST['rename_profile'] as $id => $value)
  1751. {
  1752. $value = $smcFunc['htmlspecialchars']($value);
  1753. if (trim($value) != '' && $id > 4)
  1754. $smcFunc['db_query']('', '
  1755. UPDATE {db_prefix}permission_profiles
  1756. SET profile_name = {string:profile_name}
  1757. WHERE id_profile = {int:current_profile}',
  1758. array(
  1759. 'current_profile' => (int) $id,
  1760. 'profile_name' => $value,
  1761. )
  1762. );
  1763. }
  1764. }
  1765. }
  1766. // Deleting?
  1767. elseif (isset($_POST['delete']) && !empty($_POST['delete_profile']))
  1768. {
  1769. checkSession('post');
  1770. validateToken('admin-mpp');
  1771. $profiles = array();
  1772. foreach ($_POST['delete_profile'] as $profile)
  1773. if ($profile > 4)
  1774. $profiles[] = (int) $profile;
  1775. // Verify it's not in use...
  1776. $request = $smcFunc['db_query']('', '
  1777. SELECT id_board
  1778. FROM {db_prefix}boards
  1779. WHERE id_profile IN ({array_int:profile_list})
  1780. LIMIT 1',
  1781. array(
  1782. 'profile_list' => $profiles,
  1783. )
  1784. );
  1785. if ($smcFunc['db_num_rows']($request) != 0)
  1786. fatal_lang_error('no_access', false);
  1787. $smcFunc['db_free_result']($request);
  1788. // Oh well, delete.
  1789. $smcFunc['db_query']('', '
  1790. DELETE FROM {db_prefix}permission_profiles
  1791. WHERE id_profile IN ({array_int:profile_list})',
  1792. array(
  1793. 'profile_list' => $profiles,
  1794. )
  1795. );
  1796. }
  1797. // Clearly, we'll need this!
  1798. loadPermissionProfiles();
  1799. // Work out what ones are in use.
  1800. $request = $smcFunc['db_query']('', '
  1801. SELECT id_profile, COUNT(id_board) AS board_count
  1802. FROM {db_prefix}boards
  1803. GROUP BY id_profile',
  1804. array(
  1805. )
  1806. );
  1807. while ($row = $smcFunc['db_fetch_assoc']($request))
  1808. if (isset($context['profiles'][$row['id_profile']]))
  1809. {
  1810. $context['profiles'][$row['id_profile']]['in_use'] = true;
  1811. $context['profiles'][$row['id_profile']]['boards'] = $row['board_count'];
  1812. $context['profiles'][$row['id_profile']]['boards_text'] = $row['board_count'] > 1 ? sprintf($txt['permissions_profile_used_by_many'], $row['board_count']) : $txt['permissions_profile_used_by_' . ($row['board_count'] ? 'one' : 'none')];
  1813. }
  1814. $smcFunc['db_free_result']($request);
  1815. // What can we do with these?
  1816. $context['can_edit_something'] = false;
  1817. foreach ($context['profiles'] as $id => $profile)
  1818. {
  1819. // Can't delete special ones.
  1820. $context['profiles'][$id]['can_edit'] = isset($txt['permissions_profile_' . $profile['unformatted_name']]) ? false : true;
  1821. if ($context['profiles'][$id]['can_edit'])
  1822. $context['can_edit_something'] = true;
  1823. // You can only delete it if you can edit it AND it's not in use.
  1824. $context['profiles'][$id]['can_delete'] = $context['profiles'][$id]['can_edit'] && empty($profile['in_use']) ? true : false;
  1825. }
  1826. createToken('admin-mpp');
  1827. }
  1828. /**
  1829. * This function updates the permissions of any groups based off this group.
  1830. *
  1831. * @param mixed $parents (array or int)
  1832. * @param mixed $profile = null, int expected
  1833. */
  1834. function updateChildPermissions($parents, $profile = null)
  1835. {
  1836. global $smcFunc;
  1837. // All the parent groups to sort out.
  1838. if (!is_array($parents))
  1839. $parents = array($parents);
  1840. // Find all the children of this group.
  1841. $request = $smcFunc['db_query']('', '
  1842. SELECT id_parent, id_group
  1843. FROM {db_prefix}membergroups
  1844. WHERE id_parent != {int:not_inherited}
  1845. ' . (empty($parents) ? '' : 'AND id_parent IN ({array_int:parent_list})'),
  1846. array(
  1847. 'parent_list' => $parents,
  1848. 'not_inherited' => -2,
  1849. )
  1850. );
  1851. $children = array();
  1852. $parents = array();
  1853. $child_groups = array();
  1854. while ($row = $smcFunc['db_fetch_assoc']($request))
  1855. {
  1856. $children[$row['id_parent']][] = $row['id_group'];
  1857. $child_groups[] = $row['id_group'];
  1858. $parents[] = $row['id_parent'];
  1859. }
  1860. $smcFunc['db_free_result']($request);
  1861. $parents = array_unique($parents);
  1862. // Not a sausage, or a child?
  1863. if (empty($children))
  1864. return false;
  1865. // First off, are we doing general permissions?
  1866. if ($profile < 1 || $profile === null)
  1867. {
  1868. // Fetch all the parent permissions.
  1869. $request = $smcFunc['db_query']('', '
  1870. SELECT id_group, permission, add_deny
  1871. FROM {db_prefix}permissions
  1872. WHERE id_group IN ({array_int:parent_list})',
  1873. array(
  1874. 'parent_list' => $parents,
  1875. )
  1876. );
  1877. $permissions = array();
  1878. while ($row = $smcFunc['db_fetch_assoc']($request))
  1879. foreach ($children[$row['id_group']] as $child)
  1880. $permissions[] = array($child, $row['permission'], $row['add_deny']);
  1881. $smcFunc['db_free_result']($request);
  1882. $smcFunc['db_query']('', '
  1883. DELETE FROM {db_prefix}permissions
  1884. WHERE id_group IN ({array_int:child_groups})',
  1885. array(
  1886. 'child_groups' => $child_groups,
  1887. )
  1888. );
  1889. // Finally insert.
  1890. if (!empty($permissions))
  1891. {
  1892. $smcFunc['db_insert']('insert',
  1893. '{db_prefix}permissions',
  1894. array('id_group' => 'int', 'permission' => 'string', 'add_deny' => 'int'),
  1895. $permissions,
  1896. array('id_group', 'permission')
  1897. );
  1898. }
  1899. }
  1900. // Then, what about board profiles?
  1901. if ($profile != -1)
  1902. {
  1903. $profileQuery = $profile === null ? '' : ' AND id_profile = {int:current_profile}';
  1904. // Again, get all the parent permissions.
  1905. $request = $smcFunc['db_query']('', '
  1906. SELECT id_profile, id_group, permission, add_deny
  1907. FROM {db_prefix}board_permissions
  1908. WHERE id_group IN ({array_int:parent_groups})
  1909. ' . $profileQuery,
  1910. array(
  1911. 'parent_groups' => $parents,
  1912. 'current_profile' => $profile !== null && $profile ? $profile : 1,
  1913. )
  1914. );
  1915. $permissions = array();
  1916. while ($row = $smcFunc['db_fetch_assoc']($request))
  1917. foreach ($children[$row['id_group']] as $child)
  1918. $permissions[] = array($child, $row['id_profile'], $row['permission'], $row['add_deny']);
  1919. $smcFunc['db_free_result']($request);
  1920. $smcFunc['db_query']('', '
  1921. DELETE FROM {db_prefix}board_permissions
  1922. WHERE id_group IN ({array_int:child_groups})
  1923. ' . $profileQuery,
  1924. array(
  1925. 'child_groups' => $child_groups,
  1926. 'current_profile' => $profile !== null && $profile ? $profile : 1,
  1927. )
  1928. );
  1929. // Do the insert.
  1930. if (!empty($permissions))
  1931. {
  1932. $smcFunc['db_insert']('insert',
  1933. '{db_prefix}board_permissions',
  1934. array('id_group' => 'int', 'id_profile' => 'int', 'permission' => 'string', 'add_deny' => 'int'),
  1935. $permissions,
  1936. array('id_group', 'id_profile', 'permission')
  1937. );
  1938. }
  1939. }
  1940. }
  1941. /**
  1942. * Load permissions someone cannot grant.
  1943. */
  1944. function loadIllegalPermissions()
  1945. {
  1946. global $context;
  1947. $context['illegal_permissions'] = array();
  1948. if (!allowedTo('admin_forum'))
  1949. $context['illegal_permissions'][] = 'admin_forum';
  1950. if (!allowedTo('manage_membergroups'))
  1951. $context['illegal_permissions'][] = 'manage_membergroups';
  1952. if (!allowedTo('manage_permissions'))
  1953. $context['illegal_permissions'][] = 'manage_permissions';
  1954. }
  1955. /**
  1956. * Loads the permissions that can not be given to guests.
  1957. * Stores the permissions in $context['non_guest_permissions'].
  1958. */
  1959. function loadIllegalGuestPermissions()
  1960. {
  1961. global $context;
  1962. $context['non_guest_permissions'] = array(
  1963. 'delete_replies',
  1964. 'karma_edit',
  1965. 'poll_add_own',
  1966. 'pm_read',
  1967. 'pm_send',
  1968. 'profile_identity',
  1969. 'profile_extra',
  1970. 'profile_title',
  1971. 'profile_remove',
  1972. 'profile_server_avatar',
  1973. 'profile_upload_avatar',
  1974. 'profile_remote_avatar',
  1975. 'profile_view_own',
  1976. 'mark_any_notify',
  1977. 'mark_notify',
  1978. 'admin_forum',
  1979. 'manage_boards',
  1980. 'manage_attachments',
  1981. 'manage_smileys',
  1982. 'edit_news',
  1983. 'access_mod_center',
  1984. 'moderate_forum',
  1985. 'issue_warning',
  1986. 'manage_membergroups',
  1987. 'manage_permissions',
  1988. 'manage_bans',
  1989. 'move_own',
  1990. 'modify_replies',
  1991. 'send_mail',
  1992. 'approve_posts',
  1993. );
  1994. }
  1995. /**
  1996. * Present a nice way of applying post moderation.
  1997. */
  1998. function ModifyPostModeration()
  1999. {
  2000. global $context, $txt, $smcFunc, $modSettings;
  2001. // Just in case.
  2002. checkSession('get');
  2003. $context['page_title'] = $txt['permissions_post_moderation'];
  2004. $context['sub_template'] = 'postmod_permissions';
  2005. $context['current_profile'] = isset($_REQUEST['pid']) ? (int) $_REQUEST['pid'] : 1;
  2006. // Load all the permission profiles.
  2007. loadPermissionProfiles();
  2008. // Mappings, our key => array(can_do_moderated, can_do_all)
  2009. $mappings = array(
  2010. 'new_topic' => array('post_new', 'post_unapproved_topics'),
  2011. 'replies_own' => array('post_reply_own', 'post_unapproved_replies_own'),
  2012. 'replies_any' => array('post_reply_any', 'post_unapproved_replies_any'),
  2013. 'attachment' => array('post_attachment', 'post_unapproved_attachments'),
  2014. );
  2015. // Start this with the guests/members.
  2016. $context['profile_groups'] = array(
  2017. -1 => array(
  2018. 'id' => -1,
  2019. 'name' => $txt['membergroups_guests'],
  2020. 'color' => '',
  2021. 'new_topic' => 'disallow',
  2022. 'replies_own' => 'disallow',
  2023. 'replies_any' => 'disallow',
  2024. 'attachment' => 'disallow',
  2025. 'children' => array(),
  2026. ),
  2027. 0 => array(
  2028. 'id' => 0,
  2029. 'name' => $txt['membergroups_members'],
  2030. 'color' => '',
  2031. 'new_topic' => 'disallow',
  2032. 'replies_own' => 'disallow',
  2033. 'replies_any' => 'disallow',
  2034. 'attachment' => 'disallow',
  2035. 'children' => array(),
  2036. ),
  2037. );
  2038. // Load the groups.
  2039. $request = $smcFunc['db_query']('', '
  2040. SELECT id_group, group_name, online_color, id_parent
  2041. FROM {db_prefix}membergroups
  2042. WHERE id_group != {int:admin_group}
  2043. ' . (empty($modSettings['permission_enable_postgroups']) ? ' AND min_posts = {int:min_posts}' : '') . '
  2044. ORDER BY id_parent ASC',
  2045. array(
  2046. 'admin_group' => 1,
  2047. 'min_posts' => -1,
  2048. )
  2049. );
  2050. while ($row = $smcFunc['db_fetch_assoc']($request))
  2051. {
  2052. if ($row['id_parent'] == -2)
  2053. {
  2054. $context['profile_groups'][$row['id_group']] = array(
  2055. 'id' => $row['id_group'],
  2056. 'name' => $row['group_name'],
  2057. 'color' => $row['online_color'],
  2058. 'new_topic' => 'disallow',
  2059. 'replies_own' => 'disallow',
  2060. 'replies_any' => 'disallow',
  2061. 'attachment' => 'disallow',
  2062. 'children' => array(),
  2063. );
  2064. }
  2065. elseif (isset($context['profile_groups'][$row['id_parent']]))
  2066. $context['profile_groups'][$row['id_parent']]['children'][] = $row['group_name'];
  2067. }
  2068. $smcFunc['db_free_result']($request);
  2069. // What are the permissions we are querying?
  2070. $all_permissions = array();
  2071. foreach ($mappings as $perm_set)
  2072. $all_permissions = array_merge($all_permissions, $perm_set);
  2073. // If we're saving the changes then do just that - save them.
  2074. if (!empty($_POST['save_changes']) && ($context['current_profile'] == 1 || $context['current_profile'] > 4))
  2075. {
  2076. validateToken('admin-mppm');
  2077. // Start by deleting all the permissions relevant.
  2078. $smcFunc['db_query']('', '
  2079. DELETE FROM {db_prefix}board_permissions
  2080. WHERE id_profile = {int:current_profile}
  2081. AND permission IN ({array_string:permissions})
  2082. AND id_group IN ({array_int:profile_group_list})',
  2083. array(
  2084. 'profile_group_list' => array_keys($context['profile_groups']),
  2085. 'current_profile' => $context['current_profile'],
  2086. 'permissions' => $all_permissions,
  2087. )
  2088. );
  2089. // Do it group by group.
  2090. $new_permissions = array();
  2091. foreach ($context['profile_groups'] as $id => $group)
  2092. {
  2093. foreach ($mappings as $index => $data)
  2094. {
  2095. if (isset($_POST[$index][$group['id']]))
  2096. {
  2097. if ($_POST[$index][$group['id']] == 'allow')
  2098. {
  2099. // Give them both sets for fun.
  2100. $new_permissions[] = array($context['current_profile'], $group['id'], $data[0], 1);
  2101. $new_permissions[] = array($context['current_profile'], $group['id'], $data[1], 1);
  2102. }
  2103. elseif ($_POST[$index][$group['id']] == 'moderate')
  2104. $new_permissions[] = array($context['current_profile'], $group['id'], $data[1], 1);
  2105. }
  2106. }
  2107. }
  2108. // Insert new permissions.
  2109. if (!empty($new_permissions))
  2110. $smcFunc['db_insert']('',
  2111. '{db_prefix}board_permissions',
  2112. array('id_profile' => 'int', 'id_group' => 'int', 'permission' => 'string', 'add_deny' => 'int'),
  2113. $new_permissions,
  2114. array('id_profile', 'id_group', 'permission')
  2115. );
  2116. }
  2117. // Now get all the permissions!
  2118. $request = $smcFunc['db_query']('', '
  2119. SELECT id_group, permission, add_deny
  2120. FROM {db_prefix}board_permissions
  2121. WHERE id_profile = {int:current_profile}
  2122. AND permission IN ({array_string:permissions})
  2123. AND id_group IN ({array_int:profile_group_list})',
  2124. array(
  2125. 'profile_group_list' => array_keys($context['profile_groups']),
  2126. 'current_profile' => $context['current_profile'],
  2127. 'permissions' => $all_permissions,
  2128. )
  2129. );
  2130. while ($row = $smcFunc['db_fetch_assoc']($request))
  2131. {
  2132. foreach ($mappings as $key => $data)
  2133. {
  2134. foreach ($data as $index => $perm)
  2135. {
  2136. if ($perm == $row['permission'])
  2137. {
  2138. // Only bother if it's not denied.
  2139. if ($row['add_deny'])
  2140. {
  2141. // Full allowance?
  2142. if ($index == 0)
  2143. $context['profile_groups'][$row['id_group']][$key] = 'allow';
  2144. // Otherwise only bother with moderate if not on allow.
  2145. elseif ($context['profile_groups'][$row['id_group']][$key] != 'allow')
  2146. $context['profile_groups'][$row['id_group']][$key] = 'moderate';
  2147. }
  2148. }
  2149. }
  2150. }
  2151. }
  2152. $smcFunc['db_free_result']($request);
  2153. createToken('admin-mppm');
  2154. }
  2155. ?>