ManagePermissions.php 74 KB

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