PageRenderTime 56ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 1ms

/wp-content/plugins/simple-forum/admin/panel-forums/support/sfa-forums-save.php

https://bitbucket.org/crypticrod/sr_wp_code
PHP | 1165 lines | 910 code | 175 blank | 80 comment | 204 complexity | c19465f9eb0c038c9ee01c98b8dbab8b MD5 | raw file
Possible License(s): AGPL-1.0, GPL-2.0, LGPL-2.1, GPL-3.0, LGPL-2.0, AGPL-3.0 
    

  1. <?php

    2. 

  2. /*

    3. 

  3. Simple:Press

    4. 

  4. Admin Forums Data Sae Support Functions

    5. 

  5. $LastChangedDate: 2011-01-08 08:42:25 -0700 (Sat, 08 Jan 2011) $

    6. 

  6. $Rev: 5277 $

    7. 

  7. */

    8. 

  8. 

    9. 

  9. if (preg_match('#' . basename(__FILE__) . '#', $_SERVER['PHP_SELF']))

    10. 

  10. {

    11. 

  11. 	die('Access Denied');

    12. 

  12. }

    13. 

  13. 

    14. 

  14. function sfa_save_forums_create_group()

    15. 

  15. {

    16. 

  16. 	global $wpdb;

    17. 

  17. 

    18. 

  18.     check_admin_referer('forum-adminform_groupnew', 'forum-adminform_groupnew');

    19. 

  19. 

    20. 

  20.     $ug_list = array_unique($_POST['usergroup_id']);

    21. 

  21.     $perm_list = $_POST['role'];

    22. 

  22. 

    23. 

  23.     # fail if any user groups arent assigned a permission

    24. 

  24. 	for ($x=0; $x<count($perm_list); $x++)

    25. 

  25. 	{

    26. 

  26. 		if ($perm_list[$x] == -1)

    27. 

  27. 		{

    28. 

  28. 	        $mess = __("All User Groups Must Be Assigned A Default Permission", "sforum");

    29. 

  29.     	    return $mess;

    30. 

  30. 		}

    31. 

  31. 	}

    32. 

  32. 

    33. 

  33.     $seq = ($wpdb->get_var("SELECT MAX(group_seq) FROM ".SFGROUPS) + 1);

    34. 

  34.     $groupdata = array();

    35. 

  35. 

    36. 

  36.     if (empty($_POST['group_name']))

    37. 

  37.     {

    38. 

  38.         $groupdata['group_name'] = __("New Forum Group", "sforum");

    39. 

  39.     } else

    40. 

  40.     {

    41. 

  41.         $groupdata['group_name'] = sf_filter_title_save(trim($_POST['group_name']));

    42. 

  42.     }

    43. 

  43.     if (empty($_POST['group_seq']))

    44. 

  44.     {

    45. 

  45.         $groupdata['group_seq'] = $seq;

    46. 

  46.     } else

    47. 

  47.     {

    48. 

  48.     	if (is_numeric($_POST['group_seq']))

    49. 

  49.     	{

    50. 

  50.  	       $groupdata['group_seq'] = sf_esc_int($_POST['group_seq']);

    51. 

  51.     	} else {

    52. 

  52. 	        $mess = __("New Group Creation Failed - Sequence Must Be An Integer!", "sforum");

    53. 

  53.     		return $mess;

    54. 

  54.     	}

    55. 

  55.     }

    56. 

  56. 

    57. 

  57. 	if (!empty($_POST['group_icon']))

    58. 

  58. 	{

    59. 

  59. 		# Check new icon exists

    60. 

  60. 		$groupdata['group_icon'] = sf_filter_title_save(trim($_POST['group_icon']));

    61. 

  61. 		$path = SFCUSTOM.$groupdata['group_icon'];

    62. 

  62. 		if (!file_exists($path))

    63. 

  63. 		{

    64. 

  64. 			$mess = sprintf(__("Custom Icon '%s' does not exist", "sforum"), $groupdata['group_icon']);

    65. 

  65. 			return $mess;

    66. 

  66. 		}

    67. 

  67. 	} else {

    68. 

  68. 		$groupdata['group_icon'] = NULL;

    69. 

  69. 	}

    70. 

  70. 

    71. 

  71.     $groupdata['group_desc'] = sf_filter_text_save(trim($_POST['group_desc']));

    72. 

  72.     $groupdata['group_message'] = sf_filter_text_save(trim($_POST['group_message']));

    73. 

  73. 

    74. 

  74.     # check if we need to shuffle sequence numbers

    75. 

  75.     if ($groupdata['group_seq'] < $seq)

    76. 

  76.     {

    77. 

  77.         $groups = sf_get_groups_all();

    78. 

  78.         foreach ($groups as $group)

    79. 

  79.         {

    80. 

  80.             if ($group->group_seq >= $groupdata['group_seq'])

    81. 

  81.             {

    82. 

  82.                 sfa_bump_group_seq($group->group_id, ($group->group_seq + 1));

    83. 

  83.             }

    84. 

  84.         }

    85. 

  85.     }

    86. 

  86. 

    87. 

  87.     # create the group

    88. 

  88. 	$sql ="INSERT INTO ".SFGROUPS." (group_name, group_desc, group_seq, group_icon, group_message) ";

    89. 

  89. 	$sql.="VALUES ('".$groupdata['group_name']."', '".$groupdata['group_desc']."', ".$groupdata['group_seq'].", '".$groupdata['group_icon']."', '".$groupdata['group_message']."');";

    90. 

  90.     $success = $wpdb->query($sql);

    91. 

  91.     $group_id = $wpdb->insert_id;

    92. 

  92. 

    93. 

  93.  	# save the default permissions for the group

    94. 

  94. 	for( $x=0; $x<count($ug_list); $x++)

    95. 

  95. 	{

    96. 

  96. 		sfa_add_defpermission_row($group_id, $ug_list[$x], $perm_list[$x]);

    97. 

  97. 	}

    98. 

  98. 

    99. 

  99.     if ($success == false)

    100. 

  100.     {

    101. 

  101.         $mess = __("New Group Creation Failed!", "sforum");

    102. 

  102.     } else {

    103. 

  103.         $mess = __("New Forum Group Created", "sforum");

    104. 

  104.     }

    105. 

  105. 

    106. 

  106.     return $mess;

    107. 

  107. }

    108. 

  108. 

    109. 

  109. function sfa_save_forums_create_forum()

    110. 

  110. {

    111. 

  111. 	global $wpdb;

    112. 

  112. 

    113. 

  113.     check_admin_referer('forum-adminform_forumnew', 'forum-adminform_forumnew');

    114. 

  114. 

    115. 

  115.     $forumdata = array();

    116. 

  116. 

    117. 

  117. 	if($_POST['forumtype'] == 1)

    118. 

  118. 	{

    119. 

  119. 		# Standard forum

    120. 

  120. 	    $forumdata['group_id'] = sf_esc_int($_POST['group_id']);

    121. 

  121. 	} else {

    122. 

  122. 		# Sub forum

    123. 

  123. 		$parentforum = $wpdb->get_row("SELECT * FROM ".SFFORUMS." WHERE forum_id=".sf_esc_int($_POST['forum_id']));

    124. 

  124. 		$forumdata['group_id'] = $parentforum->group_id;

    125. 

  125. 	}

    126. 

  126. 

    127. 

  127.     $seq = $wpdb->get_var("SELECT MAX(forum_seq) FROM ".SFFORUMS." WHERE group_id=".$forumdata['group_id']) + 1;

    128. 

  128.     if(!isset($_POST['forum_seq']) || sf_esc_int($_POST['forum_seq'] == 0))

    129. 

  129.     {

    130. 

  130.     	$forumdata['forum_seq'] = $seq;

    131. 

  131.     } else {

    132. 

  132. 		$forumdata['forum_seq'] = sf_esc_int($_POST['forum_seq']);

    133. 

  133. 	}

    134. 

  134. 

    135. 

  135.     $forumdata['forum_desc'] = sf_filter_text_save(trim($_POST['forum_desc']));

    136. 

  136. 

    137. 

  137.     $forumdata['forum_status'] = 0;

    138. 

  138.     if (isset($_POST['forum_status']))

    139. 

  139.     {

    140. 

  140.         $forumdata['forum_status'] = 1;

    141. 

  141. 	}

    142. 

  142. 

    143. 

  143.     $forumdata['post_ratings'] = 0;

    144. 

  144.     if (isset($_POST['sfforum_ratings']))

    145. 

  145.     {

    146. 

  146.         $forumdata['post_ratings'] = 1;

    147. 

  147. 	}

    148. 

  148. 

    149. 

  149.     $forumdata['use_tags'] = 0;

    150. 

  150.     if (isset($_POST['forum_tags']))

    151. 

  151.     {

    152. 

  152.         $forumdata['use_tags'] = 1;

    153. 

  153. 	}

    154. 

  154. 

    155. 

  155.     $forumdata['forum_rss_private'] = 0;

    156. 

  156.     if (isset($_POST['forum_private']))

    157. 

  157.     {

    158. 

  158.         $forumdata['forum_rss_private'] = 1;

    159. 

  159.     }

    160. 

  160. 

    161. 

  161.     $forumdata['forum_sitemap'] = 0;

    162. 

  162.     if (isset($_POST['forum_sitemap']))

    163. 

  163.     {

    164. 

  164.         $forumdata['forum_sitemap'] = 1;

    165. 

  165.     }

    166. 

  166. 

    167. 

  167.     if (empty($_POST['forum_name']))

    168. 

  168.     {

    169. 

  169.         $forumdata['forum_name'] = __("New Forum", "sforum");

    170. 

  170.     } else {

    171. 

  171.         $forumdata['forum_name'] = sf_filter_title_save(trim($_POST['forum_name']));

    172. 

  172.     }

    173. 

  173. 

    174. 

  174.     $forumdata['forum_message'] = sf_filter_text_save(trim($_POST['forum_message']));

    175. 

  175. 

    176. 

  176. 	if (!empty($_POST['forum_icon']))

    177. 

  177. 	{

    178. 

  178. 		# Check new icon exists

    179. 

  179. 		$forumdata['forum_icon'] = sf_filter_title_save(trim($_POST['forum_icon']));

    180. 

  180. 		$path = SFCUSTOM.$forumdata['forum_icon'];

    181. 

  181. 		if (!file_exists($path))

    182. 

  182. 		{

    183. 

  183. 			$mess = sprintf(__("Custom Icon '%s' does not exist", "sforum"), $forumdata['forum_icon']);

    184. 

  184. 			return $mess;

    185. 

  185. 		}

    186. 

  186. 	} else {

    187. 

  187. 		$forumdata['forum_icon'] = NULL;

    188. 

  188. 	}

    189. 

  189. 

    190. 

  190. 	if ($_POST['forum_topic_status'] == '' || $_POST['forum_topic_status'] == __('None', 'sforum'))

    191. 

  191. 	{

    192. 

  192. 		$forumdata['topic_status_set'] = 0;

    193. 

  193. 	} else {

    194. 

  194. 		$forumdata['topic_status_set'] = sf_esc_int($_POST['forum_topic_status']);

    195. 

  195. 	}

    196. 

  196.     # check if we need to shuffle sequence numbers

    197. 

  197.     if ($forumdata['forum_seq'] < $seq)

    198. 

  198.     {

    199. 

  199.         $forums = sfa_get_forums_in_group($forumdata['group_id']);

    200. 

  200.         foreach ($forums as $forum)

    201. 

  201.         {

    202. 

  202.             if ($forum->forum_seq >= $forumdata['forum_seq'])

    203. 

  203.             {

    204. 

  204.                 sfa_bump_forum_seq($forum->forum_id, ($forum->forum_seq + 1));

    205. 

  205.             }

    206. 

  206.         }

    207. 

  207.     }

    208. 

  208. 

    209. 

  209.     # create the forum

    210. 

  210. 	if($_POST['forumtype'] == 2)

    211. 

  211. 	{

    212. 

  212. 		$parentdata = $parentforum->forum_id;

    213. 

  213. 	} else {

    214. 

  214. 		$parentdata = '0';

    215. 

  215. 	}

    216. 

  216. 

    217. 

  217. 	# do slug

    218. 

  218. 	if(!isset($_POST['thisforumslug']) || empty($_POST['thisforumslug']))

    219. 

  219. 	{

    220. 

  220. 		$forumslug = sf_create_slug($forumdata['forum_name'], 'forum');

    221. 

  221. 	} else {

    222. 

  222. 		$forumslug = $_POST['thisforumslug'];

    223. 

  223. 	}

    224. 

  224. 

    225. 

  225. 	$sql = "INSERT INTO ".SFFORUMS." (forum_name, forum_slug, forum_desc, group_id, forum_status, forum_seq, forum_rss_private, forum_icon, topic_status_set, post_ratings, use_tags, parent, forum_message, in_sitemap) ";

    226. 

  226. 	$sql.= "VALUES ('".$forumdata['forum_name']."', '".$forumslug."', '".$forumdata['forum_desc']."', ".$forumdata['group_id'].", ".$forumdata['forum_status'].", ".$forumdata['forum_seq'].", ".$forumdata['forum_rss_private'].", '".$forumdata['forum_icon']."', ".$forumdata['topic_status_set'].", ".$forumdata['post_ratings'].", ".$forumdata['use_tags'].", ".$parentdata.", '".$forumdata['forum_message']."', ".$forumdata['forum_sitemap'].");";

    227. 

  227. 	$thisforum = $wpdb->query($sql);

    228. 

  228. 

    229. 

  229. 	# now check the slug was populated and if not replace with forum id

    230. 

  230. 	if (empty($forumslug))

    231. 

  231. 	{

    232. 

  232. 		$forumid = $wpdb->insert_id;

    233. 

  233. 		$forumslug = 'forum-'.$forumid;

    234. 

  234. 		$thisforum = $wpdb->query("UPDATE ".SFFORUMS." SET forum_slug='".$forumslug."' WHERE forum_id=".$forumid);

    235. 

  235. 	}

    236. 

  236.     $success = $thisforum;

    237. 

  237.     $forum_id = $wpdb->insert_id;

    238. 

  238. 

    239. 

  239. 	# Id subforum add it as child to the parent

    240. 

  240. 	if($_POST['forumtype'] == 2)

    241. 

  241. 	{

    242. 

  242. 		$children = array();

    243. 

  243. 		$list = $wpdb->get_results("SELECT forum_id FROM ".SFFORUMS." WHERE parent=".$parentforum->forum_id." ORDER BY forum_seq");

    244. 

  244. 		foreach($list as $id)

    245. 

  245. 		{

    246. 

  246. 			$children[]=$id->forum_id;

    247. 

  247. 		}

    248. 

  248. 		$wpdb->query("UPDATE ".SFFORUMS." SET children='".serialize($children)."' WHERE forum_id=".$parentforum->forum_id);

    249. 

  249. 	}

    250. 

  250. 

    251. 

  251.     # add the user group permission sets

    252. 

  252.     $usergroup_id_list = array_unique($_POST['usergroup_id']);

    253. 

  253.     $role_list = $_POST['role'];

    254. 

  254. 	$perm_prob = false;

    255. 

  255. 	for ($x=0; $x<count($usergroup_id_list); $x++)

    256. 

  256. 	{

    257. 

  257. 		$usergroup_id = sf_esc_int($usergroup_id_list[$x]);

    258. 

  258. 		$role = $role_list[$x];

    259. 

  259.    		if ($role == -1)

    260. 

  260. 	    {

    261. 

  261. 			$defrole = sfa_get_defpermissions_role($forumdata['group_id'], $usergroup_id);

    262. 

  262. 			if ($defrole == '')

    263. 

  263. 			{

    264. 

  264. 		    	$perm_prob = true;

    265. 

  265. 		    } else {

    266. 

  266. 				sfa_add_permission_data($forum_id, $usergroup_id, $defrole);

    267. 

  267. 		    }

    268. 

  268.     	} else {

    269. 

  269. 			sfa_add_permission_data($forum_id, $usergroup_id, $role);

    270. 

  270. 		}

    271. 

  271.     }

    272. 

  272. 

    273. 

  273. 	# get affected members

    274. 

  274. 	$members = $wpdb->get_results("

    275. 

  275. 		SELECT DISTINCT user_id

    276. 

  276. 		FROM ".SFMEMBERSHIPS."

    277. 

  277. 		WHERE usergroup_id IN (

    278. 

  278. 			SELECT usergroup_id

    279. 

  279. 			FROM ".SFPERMISSIONS."

    280. 

  280. 			WHERE forum_id = ".$forum_id."

    281. 

  281. 		)

    282. 

  282. 	");

    283. 

  283. 	sfc_rebuild_members_pm($members);

    284. 

  284. 

    285. 

  285. 	# if the forum was created, signal success - doesnt check user group permission set though

    286. 

  286.     if ($success == false)

    287. 

  287.     {

    288. 

  288.         $mess = __("New Forum Creation Failed!", "sforum");

    289. 

  289.     } else {

    290. 

  290. 		if ($perm_prob)

    291. 

  291. 		{

    292. 

  292.         	$mess = __("New Forum Created - Permission Sets Not Properly Set For All User Groups!", "sforum");

    293. 

  293. 	    } else {

    294. 

  294.         	$mess = __("New Forum Created!", "sforum");

    295. 

  295. 		}

    296. 

  296.     }

    297. 

  297. 

    298. 

  298. 	sfa_clean_forum_children();

    299. 

  299. 	sfa_resequence_forums($forumdata['group_id'], 0);

    300. 

  300. 

    301. 

  301.     return $mess;

    302. 

  302. }

    303. 

  303. 

    304. 

  304. # function to add a permission set globally to all forum

    305. 

  305. function sfa_save_forums_global_perm()

    306. 

  306. {

    307. 

  307. 	global $wpdb;

    308. 

  308. 

    309. 

  309.     check_admin_referer('forum-adminform_globalpermissionnew', 'forum-adminform_globalpermissionnew');

    310. 

  310. 

    311. 

  311. 	if ($_POST['usergroup_id'] != -1 && $_POST['role'] != -1)

    312. 

  312. 	{

    313. 

  313. 	    $usergroup_id = sf_esc_int($_POST['usergroup_id']);

    314. 

  314.     	$permission = sf_esc_int($_POST['role']);

    315. 

  315. 

    316. 

  316. 		# loop through all the groups

    317. 

  317. 		$groups = sf_get_groups_all();

    318. 

  318.   	  	if ($groups)

    319. 

  319.   	  	{

    320. 

  320.   	  		$mess = '';

    321. 

  321.         	foreach ($groups as $group)

    322. 

  322.         	{

    323. 

  323.             	# use group permission set helper function to actually set the permission set

    324. 

  324.             	$mess.= sfa_set_group_permission($group->group_id, $usergroup_id, $permission);

    325. 

  325.             }

    326. 

  326. 

    327. 

  327. 			#update pm flag

    328. 

  328. 			$members = $wpdb->get_results("SELECT user_id FROM ".SFMEMBERSHIPS.' WHERE usergroup_id='.$usergroup_id);

    329. 

  329. 			sfc_rebuild_members_pm($members);

    330. 

  330.         } else {

    331. 

  331.         	$mess = __("There are no Groups or Forum!  No Permission Set Added!", "sforum");

    332. 

  332.     	}

    333. 

  333. 	} else {

    334. 

  334. 		$mess = __("Adding User Group Permission Set Failed!", "sforum");

    335. 

  335. 	}

    336. 

  336. 

    337. 

  337.     return $mess;

    338. 

  338. }

    339. 

  339. 

    340. 

  340. # function to add a permission set to every forum within a group

    341. 

  341. function sfa_save_forums_group_perm()

    342. 

  342. {

    343. 

  343. 	global $wpdb;

    344. 

  344. 

    345. 

  345.     check_admin_referer('forum-adminform_grouppermissionnew', 'forum-adminform_grouppermissionnew');

    346. 

  346. 

    347. 

  347. 	if(isset($_POST['group_id']) && $_POST['usergroup_id'] != -1 && $_POST['role'] != -1)

    348. 

  348. 	{

    349. 

  349. 	    $group_id = sf_esc_int($_POST['group_id']);

    350. 

  350. 	    $usergroup_id = sf_esc_int($_POST['usergroup_id']);

    351. 

  351. 	    $permission = sf_esc_int($_POST['role']);

    352. 

  352. 

    353. 

  353. 		#update pm flag

    354. 

  354. 	    $mess = sfa_set_group_permission($group_id, $usergroup_id, $permission);

    355. 

  355. 		$members = $wpdb->get_results("SELECT user_id FROM ".SFMEMBERSHIPS.' WHERE usergroup_id='.$usergroup_id);

    356. 

  356. 		sfc_rebuild_members_pm($members);

    357. 

  357. 	} else {

    358. 

  358. 		$mess = __("Adding User Group Permission Set Failed!", "sforum");

    359. 

  359. 	}

    360. 

  360. 

    361. 

  361. 	return $mess;

    362. 

  362. }

    363. 

  363. 

    364. 

  364. # helper function to loop through all forum in a group and add a permission set

    365. 

  365. function sfa_set_group_permission($group_id, $usergroup_id, $permission)

    366. 

  366. {

    367. 

  367. 	global $wpdb;

    368. 

  368. 

    369. 

  369.     $forums = sfa_get_forums_in_group($group_id);

    370. 

  370. 

    371. 

  371.     if ($forums)

    372. 

  372.     {

    373. 

  373.     	$mess = '';

    374. 

  374.         foreach ($forums as $forum)

    375. 

  375.         {

    376. 

  376.             # If user group has a current permission set for this forum, remove the old one before adding the new one

    377. 

  377.             $current = $wpdb->get_row("SELECT * FROM ".SFPERMISSIONS." WHERE forum_id=".$forum->forum_id." AND usergroup_id=".$usergroup_id);

    378. 

  378. 

    379. 

  379.             if ($current)

    380. 

  380.             {

    381. 

  381.                 sfa_remove_permission_data($current->permission_id);

    382. 

  382.             }

    383. 

  383. 

    384. 

  384.             # add the new permission set

    385. 

  385.             $success = sfa_add_permission_data($forum->forum_id, $usergroup_id, $permission);

    386. 

  386. 

    387. 

  387.             if ($success == false)

    388. 

  388.             {

    389. 

  389.                 $mess.= sf_filter_title_display($forum->forum_name) . ": ". __("Adding User Group Permission Set Failed!", "sforum") . '<br />';

    390. 

  390.             } else {

    391. 

  391.                 $mess.= sf_filter_title_display($forum->forum_name) . ": ". __("User Group Permission Set Added to Forum!", "sforum") . '<br />';

    392. 

  392.             }

    393. 

  393.         }

    394. 

  394.     } else {

    395. 

  395.         $mess = __("Group has no Members!  No Permission Sets Added!", "sforum");

    396. 

  396.     }

    397. 

  397. 

    398. 

  398.     return $mess;

    399. 

  399. }

    400. 

  400. 

    401. 

  401. # function to remove all permission set from all forum

    402. 

  402. function sfa_save_forums_remove_perms()

    403. 

  403. {

    404. 

  404. 	global $wpdb;

    405. 

  405. 

    406. 

  406.     check_admin_referer('forum-adminform_allpermissionsdelete', 'forum-adminform_allpermissionsdelete');

    407. 

  407. 

    408. 

  408. 	# remove all permission set

    409. 

  409.     $wpdb->query("TRUNCATE TABLE ".SFPERMISSIONS);

    410. 

  410. 

    411. 

  411. 	# only admins can PM now

    412. 

  412. 	$wpdb->query("UPDATE ".SFMEMBERS." SET pm = 0 WHERE admin = 0");

    413. 

  413. 

    414. 

  414.     $mess = __("All Permission Sets Removed.", "sforum");

    415. 

  415. 

    416. 

  416.     return $mess;

    417. 

  417. }

    418. 

  418. 

    419. 

  419. # function to add a new permission set to a forum

    420. 

  420. function sfa_save_forums_forum_perm()

    421. 

  421. {

    422. 

  422. 	global $wpdb;

    423. 

  423. 

    424. 

  424.     check_admin_referer('forum-adminform_permissionnew', 'forum-adminform_permissionnew');

    425. 

  425. 

    426. 

  426. 	if (isset($_POST['forum_id']) && $_POST['usergroup_id'] != -1 && $_POST['role'] != -1)

    427. 

  427. 	{

    428. 

  428. 		$usergroup_id = sf_esc_int($_POST['usergroup_id']);

    429. 

  429. 		$forum_id = sf_esc_int($_POST['forum_id']);

    430. 

  430. 		$permission = sf_esc_int($_POST['role']);

    431. 

  431. 

    432. 

  432. 		# If user group has a current permission set for this forum, remove the old one before adding the new one

    433. 

  433. 		$current = $wpdb->get_row("SELECT * FROM ".SFPERMISSIONS." WHERE forum_id=".$forum_id." AND usergroup_id=".$usergroup_id);

    434. 

  434. 

    435. 

  435. 		if ($current)

    436. 

  436. 		{

    437. 

  437. 			sfa_remove_permission_data($current->permission_id);

    438. 

  438. 		}

    439. 

  439. 

    440. 

  440. 		# add the new permission set

    441. 

  441. 		$success = sfa_add_permission_data($forum_id, $usergroup_id, $permission);

    442. 

  442. 		if ($success == false)

    443. 

  443. 		{

    444. 

  444. 			$mess = __("Adding User Group Permission Set Failed!", "sforum");

    445. 

  445. 		} else {

    446. 

  446. 			$mess = __("User Group Permission Set Added to Forum", "sforum");

    447. 

  447. 			$members = $wpdb->get_results("SELECT user_id FROM ".SFMEMBERSHIPS." WHERE usergroup_id = ".$usergroup_id." AND forum_id = ".$forum_id);

    448. 

  448. 			sfc_rebuild_members_pm($members);

    449. 

  449. 		}

    450. 

  450. 	} else {

    451. 

  451. 		$mess = __("Adding User Group Permission Set Failed!", "sforum");

    452. 

  452. 	}

    453. 

  453. 

    454. 

  454.     return $mess;

    455. 

  455. }

    456. 

  456. 

    457. 

  457. function sfa_save_forums_delete_forum()

    458. 

  458. {

    459. 

  459. 	global $wpdb;

    460. 

  460. 

    461. 

  461.     check_admin_referer('forum-adminform_forumdelete', 'forum-adminform_forumdelete');

    462. 

  462. 

    463. 

  463.     $group_id = sf_esc_int($_POST['group_id']);

    464. 

  464.     $forum_id = sf_esc_int($_POST['forum_id']);

    465. 

  465.     $cseq = sf_esc_int($_POST['cforum_seq']);

    466. 

  466. 

    467. 

  467. 	# get affected members

    468. 

  468. 	$members = $wpdb->get_results("

    469. 

  469. 		SELECT DISTINCT user_id

    470. 

  470. 		FROM ".SFMEMBERSHIPS."

    471. 

  471. 		WHERE usergroup_id IN (

    472. 

  472. 			SELECT usergroup_id

    473. 

  473. 			FROM ".SFPERMISSIONS."

    474. 

  474. 			WHERE forum_id = ".$forum_id."

    475. 

  475. 		)

    476. 

  476. 	");

    477. 

  477. 

    478. 

  478. 	# If subforum or parent remove the relationship first.

    479. 

  479. 	# Read the 'children' from the database because it is serialised

    480. 

  480. 	$children = $wpdb->get_var("SELECT children FROM ".SFFORUMS." WHERE forum_id=".$forum_id);

    481. 

  481. 	if($children)

    482. 

  482. 	{

    483. 

  483. 		$children = unserialize($children);

    484. 

  484. 		foreach($children as $child)

    485. 

  485. 		{

    486. 

  486. 			$wpdb->query("UPDATE ".SFFORUMS." SET parent = null WHERE forum_id=".sf_esc_int($child));

    487. 

  487. 		}

    488. 

  488. 	}

    489. 

  489. 	if($_POST['parent'])

    490. 

  490. 	{

    491. 

  491. 		$parentforum=$wpdb->get_var("SELECT children FROM ".SFFORUMS." WHERE forum_id=".sf_esc_int($_POST['parent']));

    492. 

  492. 		$children = unserialize($parentforum);

    493. 

  493. 		if(count($children) == 1)

    494. 

  494. 		{

    495. 

  495. 			$wpdb->query("UPDATE ".SFFORUMS." SET children = null WHERE forum_id=".sf_esc_int($_POST['parent']));

    496. 

  496. 		} else {

    497. 

  497. 			$newlist=array();

    498. 

  498. 			foreach($children as $child)

    499. 

  499. 			{

    500. 

  500. 				if($child != $forum_id) $newlist[]=$child;

    501. 

  501. 			}

    502. 

  502. 			$wpdb->query("UPDATE ".SFFORUMS." SET children = '".serialize($newlist)."' WHERE forum_id=".sf_esc_int($_POST['parent']));

    503. 

  503. 		}

    504. 

  504. 	}

    505. 

  505. 

    506. 

  506. 	# need to delete all topics in the forum using standard routine to clean up behind it

    507. 

  507. 	$topics = $wpdb->get_results("SELECT topic_id FROM ".SFTOPICS." WHERE forum_id=".$forum_id);

    508. 

  508. 	if ($topics)

    509. 

  509. 	{

    510. 

  510. 		foreach ($topics as $topic)

    511. 

  511. 		{

    512. 

  512. 			sf_delete_topic($topic->topic_id, false);

    513. 

  513. 		}

    514. 

  514. 	}

    515. 

  515. 

    516. 

  516. 	# now delete the forum itself

    517. 

  517. 	$wpdb->query("DELETE FROM ".SFFORUMS." WHERE forum_id=".$forum_id);

    518. 

  518. 

    519. 

  519. 	# remove permissions for this forum

    520. 

  520. 	$perms = sfa_get_forum_permissions($forum_id);

    521. 

  521. 	if ($perms)

    522. 

  522. 	{

    523. 

  523. 		foreach ($perms as $perm)

    524. 

  524. 		{

    525. 

  525. 			sfa_remove_permission_data($perm->permission_id);

    526. 

  526. 		}

    527. 

  527. 	}

    528. 

  528. 

    529. 

  529. 	# update pm flag for affected members

    530. 

  530. 	sfc_rebuild_members_pm($members);

    531. 

  531. 

    532. 

  532.     # need to iterate through the groups

    533. 

  533.     $forums = sfa_get_forums_in_group($group_id);

    534. 

  534.     foreach ($forums as $forum)

    535. 

  535.     {

    536. 

  536.         if ($forum->forum_seq > $cseq)

    537. 

  537.         {

    538. 

  538.             sfa_bump_forum_seq($forum->forum_id, ($forum->forum_seq - 1));

    539. 

  539.         }

    540. 

  540.     }

    541. 

  541. 

    542. 

  542. 	$mess = "Forum Deleted!";

    543. 

  543. 

    544. 

  544. 	sfa_clean_forum_children();

    545. 

  545. 	sfa_resequence_forums($group_id, 0);

    546. 

  546. 

    547. 

  547.     return $mess;

    548. 

  548. }

    549. 

  549. 

    550. 

  550. function sfa_save_forums_delete_group()

    551. 

  551. {

    552. 

  552. 	global $wpdb;

    553. 

  553. 

    554. 

  554.     check_admin_referer('forum-adminform_groupdelete', 'forum-adminform_groupdelete');

    555. 

  555. 

    556. 

  556.     $group_id = sf_esc_int($_POST['group_id']);

    557. 

  557.     $cseq = sf_esc_int($_POST['cgroup_seq']);

    558. 

  558. 

    559. 

  559. 	# get affected members

    560. 

  560. 	$members = $wpdb->get_results("

    561. 

  561. 		SELECT DISTINCT user_id

    562. 

  562. 		FROM ".SFMEMBERSHIPS."

    563. 

  563. 		WHERE usergroup_id IN (

    564. 

  564. 			SELECT usergroup_id

    565. 

  565. 			FROM ".SFPERMISSIONS."

    566. 

  566. 			WHERE forum_id IN (

    567. 

  567. 				SELECT forum_id

    568. 

  568. 				FROM ".SFFORUMS."

    569. 

  569. 				WHERE group_id = ".$group_id."

    570. 

  570. 			)

    571. 

  571. 		)

    572. 

  572. 	");

    573. 

  573. 

    574. 

  574. 	# remove permissions for each forum in group

    575. 

  575. 	$forums = sfa_get_forums_in_group($group_id);

    576. 

  576. 	if ($forums)

    577. 

  577. 	{

    578. 

  578. 		foreach ($forums as $forum)

    579. 

  579. 		{

    580. 

  580. 			# remove permissions for this forum

    581. 

  581. 			$perms = sfa_get_forum_permissions($forum->forum_id);

    582. 

  582. 			if ($perms)

    583. 

  583. 			{

    584. 

  584. 				foreach ($perms as $perm)

    585. 

  585. 				{

    586. 

  586. 					sfa_remove_permission_data($perm->permission_id);

    587. 

  587. 				}

    588. 

  588. 			}

    589. 

  589. 		}

    590. 

  590. 	}

    591. 

  591. 

    592. 

  592. 	# rebuild pm column for affected members

    593. 

  593. 	sfc_rebuild_members_pm($members);

    594. 

  594. 

    595. 

  595. 	# select all the forums in the group

    596. 

  596. 	$forums = sfa_get_forums_in_group($group_id);

    597. 

  597. 

    598. 

  598. 	# remove the topics and posts in each forum

    599. 

  599. 	foreach ($forums as $forum)

    600. 

  600. 	{

    601. 

  601. 		# need to delete all topics in the forum using standard routine to clean up behind it

    602. 

  602. 		$topics = $wpdb->get_results("SELECT topic_id FROM ".SFTOPICS." WHERE forum_id=".$forum->forum_id);

    603. 

  603. 		if ($topics)

    604. 

  604. 		{

    605. 

  605. 			foreach ($topics as $topic)

    606. 

  606. 			{

    607. 

  607. 				sf_delete_topic($topic->topic_id, false);

    608. 

  608. 			}

    609. 

  609. 		}

    610. 

  610. 	}

    611. 

  611. 

    612. 

  612. 	#now remove the forums themselves

    613. 

  613. 	$wpdb->query("DELETE FROM ".SFFORUMS." WHERE group_id=".$group_id);

    614. 

  614. 	# and finaly remove the group

    615. 

  615. 	$wpdb->query("DELETE FROM ".SFGROUPS." WHERE group_id=".$group_id);

    616. 

  616. 

    617. 

  617.     # need to iterate through the groups

    618. 

  618.     $groups = sf_get_groups_all();

    619. 

  619.     foreach ($groups as $group)

    620. 

  620.     {

    621. 

  621.         if ($group->group_seq > $cseq)

    622. 

  622.         {

    623. 

  623.             sfa_bump_group_seq($group->group_id, ($group->group_seq - 1));

    624. 

  624.         }

    625. 

  625.     }

    626. 

  626. 

    627. 

  627. 	# remove the default permissions for the group being deleted

    628. 

  628. 	$wpdb->query("DELETE FROM ".SFDEFPERMISSIONS." WHERE group_id=".$group_id);

    629. 

  629. 

    630. 

  630.     $mess = __("Group Deleted", "sforum");

    631. 

  631. 

    632. 

  632.     return $mess;

    633. 

  633. }

    634. 

  634. 

    635. 

  635. # function to delete an existing permission set for a forum

    636. 

  636. function sfa_save_forums_delete_perm()

    637. 

  637. {

    638. 

  638. 	global $wpdb;

    639. 

  639. 

    640. 

  640.     check_admin_referer('forum-adminform_permissiondelete', 'forum-adminform_permissiondelete');

    641. 

  641. 

    642. 

  642.     $permission_id = sf_esc_int($_POST['permission_id']);

    643. 

  643. 

    644. 

  644. 	# get affected members

    645. 

  645. 	$members = $wpdb->get_results("

    646. 

  646. 		SELECT DISTINCT user_id

    647. 

  647. 		FROM ".SFMEMBERSHIPS."

    648. 

  648. 		WHERE usergroup_id = (

    649. 

  649. 			SELECT usergroup_id

    650. 

  650. 			FROM ".SFPERMISSIONS."

    651. 

  651. 			WHERE permission_id = ".$permission_id."

    652. 

  652. 		)

    653. 

  653. 	");

    654. 

  654. 

    655. 

  655. 	# remove the permission set from the forum

    656. 

  656.     $success = sfa_remove_permission_data($permission_id);

    657. 

  657.     if ($success == false)

    658. 

  658.     {

    659. 

  659.         $mess = __("Permission Set Delete Failed!", "sforum");

    660. 

  660.     } else {

    661. 

  661.         $mess = __("Permission Set Deleted", "sforum");

    662. 

  662. 

    663. 

  663.         # rebuild pm flag for affected members

    664. 

  664. 		sfc_rebuild_members_pm($members);

    665. 

  665.     }

    666. 

  666. 

    667. 

  667.     return $mess;

    668. 

  668. }

    669. 

  669. 

    670. 

  670. function sfa_save_forums_edit_forum()

    671. 

  671. {

    672. 

  672. 	global $wpdb;

    673. 

  673. 

    674. 

  674.     check_admin_referer('forum-adminform_forumedit', 'forum-adminform_forumedit');

    675. 

  675. 

    676. 

  676.     $forumdata = array();

    677. 

  677.     $forum_id = sf_esc_int($_POST['forum_id']);

    678. 

  678.     $forumdata['forum_name'] = sf_filter_title_save(trim($_POST['forum_name']));

    679. 

  679. 	if(!empty($_POST['thisforumslug']))

    680. 

  680. 	{

    681. 

  681. 		$forumdata['forum_slug'] = sf_create_slug($_POST['thisforumslug'], 'forum', false);

    682. 

  682. 	} else {

    683. 

  683. 		$forumdata['forum_slug'] = sf_create_slug($forumdata['forum_name'], 'forum');

    684. 

  684. 	}

    685. 

  685.     $forumdata['forum_desc'] = sf_filter_text_save(trim($_POST['forum_desc']));

    686. 

  686. 

    687. 

  687. 	if(!isset($_POST['forum_seq']) || sf_esc_int($_POST['forum_seq'] == 0))

    688. 

  688. 	{

    689. 

  689. 		$mess = __("Unable to Save until Display Position is set", "sforum");

    690. 

  690. 		return $mess;

    691. 

  691. 	} else {

    692. 

  692. 	    $forumdata['forum_seq'] = sf_esc_int($_POST['forum_seq']);

    693. 

  693. 	}

    694. 

  694. 

    695. 

  695.     $forumdata['group_id'] = sf_esc_int($_POST['group_id']);

    696. 

  696. 

    697. 

  697.     $forumdata['forum_status'] = 0;

    698. 

  698.     if (isset($_POST['forum_status']))

    699. 

  699.     {

    700. 

  700.         $forumdata['forum_status'] = 1;

    701. 

  701. 	}

    702. 

  702. 

    703. 

  703.     $forumdata['use_tags'] = 0;

    704. 

  704.     if (isset($_POST['forum_tags']))

    705. 

  705.     {

    706. 

  706.         $forumdata['use_tags'] = 1;

    707. 

  707. 	}

    708. 

  708. 

    709. 

  709.     $forumdata['post_ratings'] = 0;

    710. 

  710.     if (isset($_POST['forum_ratings']))

    711. 

  711.     {

    712. 

  712.         $forumdata['post_ratings'] = 1;

    713. 

  713.     }

    714. 

  714. 

    715. 

  715.     $forumdata['forum_rss_private'] = 0;

    716. 

  716.     if (isset($_POST['forum_private']))

    717. 

  717.     {

    718. 

  718.         $forumdata['forum_rss_private'] = 1;

    719. 

  719.     }

    720. 

  720. 

    721. 

  721.     $forumdata['forum_sitemap'] = 0;

    722. 

  722.     if (isset($_POST['forum_sitemap']))

    723. 

  723.     {

    724. 

  724.         $forumdata['forum_sitemap'] = 1;

    725. 

  725.     }

    726. 

  726. 

    727. 

  727. 	if (!empty($_POST['forum_icon']))

    728. 

  728. 	{

    729. 

  729. 		# Check new icon exists

    730. 

  730. 		$forumdata['forum_icon'] = sf_filter_title_save(trim($_POST['forum_icon']));

    731. 

  731. 		$path = SFCUSTOM.$forumdata['forum_icon'];

    732. 

  732. 		if (!file_exists($path))

    733. 

  733. 		{

    734. 

  734. 			$mess = sprintf(__("Custom Icon '%s' does not exist", "sforum"), $forumdata['forum_icon']);

    735. 

  735. 			return $mess;

    736. 

  736. 		}

    737. 

  737. 	} else {

    738. 

  738. 		$forumdata['forum_icon'] = NULL;

    739. 

  739. 	}

    740. 

  740. 

    741. 

  741. 	if (isset($_POST['forum_topic_status']))

    742. 

  742. 	{

    743. 

  743. 		if ($_POST['forum_topic_status'] == '')

    744. 

  744. 		{

    745. 

  745. 			$forumdata['topic_status_set'] = 0;

    746. 

  746. 

    747. 

  747. 			# remove from all topics in the forum

    748. 

  748. 			$wpdb->query("UPDATE ".SFTOPICS." SET topic_status_flag=0 WHERE forum_id=".$forum_id);

    749. 

  749. 		} else {

    750. 

  750.             $forumdata['topic_status_set'] = $_POST['forum_topic_status'];

    751. 

  751. 		}

    752. 

  752. 	} else {

    753. 

  753. 		$forumdata['topic_status_set'] = sf_esc_int($_POST['cforum_topic_status']);

    754. 

  754. 	}

    755. 

  755. 

    756. 

  756. 	if (isset($_POST['forum_rss']))

    757. 

  757. 	{

    758. 

  758. 		$forumdata['forum_rss'] = sf_filter_save_cleanurl($_POST['forum_rss']);

    759. 

  759. 	} else {

    760. 

  760. 		$forumdata['forum_rss'] = sf_filter_save_cleanurl($_POST['cforum_rss']);

    761. 

  761. 	}

    762. 

  762. 

    763. 

  763.     $forumdata['forum_message'] = sf_filter_text_save(trim($_POST['forum_message']));

    764. 

  764. 

    765. 

  765.     if (($forumdata['forum_name'] == sf_filter_title_display($_POST['cforum_name'])) &&

    766. 

  766. 		($forumdata['forum_slug'] == $_POST['cforum_slug']) &&

    767. 

  767. 		($forumdata['forum_seq'] == $_POST['cforum_seq']) &&

    768. 

  768. 		($forumdata['group_id'] == $_POST['cgroup_id']) &&

    769. 

  769. 		($forumdata['forum_status'] == $_POST['cforum_status']) &&

    770. 

  770. 		($forumdata['use_tags'] == $_POST['cforum_tags']) &&

    771. 

  771. 		($forumdata['post_ratings'] == $_POST['cforum_ratings']) &&

    772. 

  772. 		($forumdata['forum_rss_private'] == $_POST['cforum_rss_private'])  &&

    773. 

  773. 		($forumdata['forum_desc'] == $_POST['cforum_desc']) &&

    774. 

  774. 		($forumdata['forum_icon'] == $_POST['cforum_icon']) &&

    775. 

  775. 		($forumdata['forum_topic_status'] == $_POST['cforum_topic_status']) &&

    776. 

  776. 		($forumdata['forum_message'] == $_POST['cforum_message']) &&

    777. 

  777. 		($forumdata['forum_sitemap'] == $_POST['cforum_sitemap']) &&

    778. 

  778. 		($forumdata['forum_rss'] == $_POST['cforum_rss']))

    779. 

  779.     {

    780. 

  780.         $mess = __("No Data Changed", "sforum");

    781. 

  781.         return $mess;

    782. 

  782.     }

    783. 

  783. 

    784. 

  784.     # has the forum changed to a new group

    785. 

  785.     if ($forumdata['group_id'] != $_POST['cgroup_id'])

    786. 

  786.     {

    787. 

  787.         # let's resequence old group list first

    788. 

  788.         $forums = $wpdb->get_results("SELECT forum_id, forum_seq FROM ".SFFORUMS." WHERE group_id=".sf_esc_int($_POST['cgroup_id'])." AND forum_id <> ".$forum_id." ORDER BY forum_seq;");

    789. 

  789.         $cnt = count($forums);

    790. 

  790.         for ($i = 0; $i < $cnt; $i++)

    791. 

  791.         {

    792. 

  792.             sfa_bump_forum_seq($forums[$i]->forum_id, ($i + 1));

    793. 

  793.         }

    794. 

  794. 

    795. 

  795.         # now we can make room in new group

    796. 

  796.         $seq = $wpdb->get_var("SELECT MAX(forum_seq) FROM ".SFFORUMS." WHERE group_id=". $forumdata['group_id']) + 1;

    797. 

  797.         if ($forumdata['forum_seq'] < $seq)

    798. 

  798.         {

    799. 

  799.             $forums = sfa_get_forums_in_group($forumdata['group_id']);

    800. 

  800.             foreach ($forums as $forum)

    801. 

  801.             {

    802. 

  802.                 if ($forum->forum_seq >= $forumdata['forum_seq'])

    803. 

  803.                 {

    804. 

  804.                     sfa_bump_forum_seq($forum->forum_id, ($forum->forum_seq + 1));

    805. 

  805.                 }

    806. 

  806.             }

    807. 

  807.         }

    808. 

  808.     } else {

    809. 

  809.         # same group but has the seq changed?

    810. 

  810.         if ($forumdata['forum_seq'] != $_POST['cforum_seq'])

    811. 

  811.         {

    812. 

  812.             $forums = $wpdb->get_results("SELECT forum_id, forum_seq FROM ".SFFORUMS." WHERE group_id=".sf_esc_int($_POST['cgroup_id'])." AND forum_id <> ".$forum_id." ORDER BY forum_seq;");

    813. 

  813.             $cnt = count($forums);

    814. 

  814.             for ($i = 0; $i < $cnt; $i++)

    815. 

  815.             {

    816. 

  816.                 if (($i + 1) < $forumdata['forum_seq'])

    817. 

  817.                 {

    818. 

  818.                     sfa_bump_forum_seq($forums[$i]->forum_id, ($i + 1));

    819. 

  819.                 } else {

    820. 

  820.                     sfa_bump_forum_seq($forums[$i]->forum_id, ($i + 2));

    821. 

  821.                 }

    822. 

  822.             }

    823. 

  823.         }

    824. 

  824.     }

    825. 

  825. 

    826. 

  826.     # Finally - we can save the updated forum record!

    827. 

  827. 	if(empty($forumdata['forum_slug']))

    828. 

  828. 	{

    829. 

  829. 		$forumslug = sf_create_slug($forumdata['forum_name'], 'forum');

    830. 

  830. 		if(empty($forumslug)) $forumslug = 'forum-'.$forum_id;

    831. 

  831. 	} else {

    832. 

  832. 		$forumslug = $forumdata['forum_slug'];

    833. 

  833. 	}

    834. 

  834. 

    835. 

  835. 	# Let's make sure parent is set

    836. 

  836. 	if($_POST['forumtype'] == 1)

    837. 

  837. 	{

    838. 

  838. 		$parent = 0;

    839. 

  839. 	} else {

    840. 

  840. 		$parent = sf_esc_int($_POST['forum_parent']);

    841. 

  841. 	}

    842. 

  842. 

    843. 

  843. 	$sql = "UPDATE ".SFFORUMS." SET ";

    844. 

  844. 	$sql.= 'forum_name="'.$forumdata['forum_name'].'", ';

    845. 

  845. 	$sql.= 'forum_slug="'.$forumslug.'", ';

    846. 

  846. 	$sql.= 'forum_desc="'.$forumdata['forum_desc'].'", ';

    847. 

  847. 	$sql.= 'group_id='.$forumdata['group_id'].', ';

    848. 

  848. 	$sql.= 'forum_status='.$forumdata['forum_status'].', ';

    849. 

  849. 	$sql.= 'use_tags='.$forumdata['use_tags'].', ';

    850. 

  850. 	$sql.= 'post_ratings='.$forumdata['post_ratings'].', ';

    851. 

  851. 	$sql.= 'forum_rss_private='.$forumdata['forum_rss_private'].', ';

    852. 

  852. 	$sql.= 'forum_icon="'.$forumdata['forum_icon'].'", ';

    853. 

  853. 	$sql.= 'topic_status_set='.$forumdata['topic_status_set'].', ';

    854. 

  854. 	$sql.= 'forum_rss="'.$forumdata['forum_rss'].'", ';

    855. 

  855. 	$sql.= 'in_sitemap="'.$forumdata['forum_sitemap'].'", ';

    856. 

  856. 	$sql.= 'parent='.$parent.', ';

    857. 

  857. 	$sql.= 'forum_message="'.$forumdata['forum_message'].'", ';

    858. 

  858. 	$sql.= 'forum_seq='.$forumdata['forum_seq']." ";

    859. 

  859. 	$sql.= "WHERE forum_id=".$forum_id.";";

    860. 

  860.     $success = $wpdb->query($sql);

    861. 

  861.     if ($success == false)

    862. 

  862.     {

    863. 

  863.         $mess = __("Forum Record Update Failed!", "sforum");

    864. 

  864.     } else {

    865. 

  865.         $mess = __("Forum Record Updated", "sforum");

    866. 

  866.     }

    867. 

  867. 

    868. 

  868. 	sfa_clean_forum_children();

    869. 

  869. 	sfa_resequence_forums($forumdata['group_id'], 0);

    870. 

  870. 

    871. 

  871.     return $mess;

    872. 

  872. }

    873. 

  873. 

    874. 

  874. function sfa_save_forums_edit_group()

    875. 

  875. {

    876. 

  876. 	global $wpdb;

    877. 

  877. 

    878. 

  878.     check_admin_referer('forum-adminform_groupedit', 'forum-adminform_groupedit');

    879. 

  879. 

    880. 

  880.     $groupdata = array();

    881. 

  881.     $group_id = sf_esc_int($_POST['group_id']);

    882. 

  882.     $groupdata['group_name'] = sf_filter_title_save(trim($_POST['group_name']));

    883. 

  883.     $groupdata['group_seq'] = sf_filter_title_save(trim($_POST['group_seq']));

    884. 

  884.     $groupdata['group_desc'] = sf_filter_text_save(trim($_POST['group_desc']));

    885. 

  885.     $groupdata['group_message'] = sf_filter_text_save(trim($_POST['group_message']));

    886. 

  886. 

    887. 

  887.     $ug_list = array_unique($_POST['usergroup_id']);

    888. 

  888.     $perm_list = $_POST['role'];

    889. 

  889. 

    890. 

  890. 	if (!empty($_POST['group_icon']))

    891. 

  891. 	{

    892. 

  892. 		# Check new icon exists

    893. 

  893. 		$groupdata['group_icon'] = sf_filter_title_save(trim($_POST['group_icon']));

    894. 

  894. 		$path = SFCUSTOM.$groupdata['group_icon'];

    895. 

  895. 		if (!file_exists($path))

    896. 

  896. 		{

    897. 

  897. 			$mess = sprintf(__("Custom Icon '%s' does not exist", "sforum"), $groupdata['group_icon']);

    898. 

  898. 			return $mess;

    899. 

  899. 		}

    900. 

  900. 	} else {

    901. 

  901. 		$groupdata['group_icon'] = NULL;

    902. 

  902. 	}

    903. 

  903. 

    904. 

  904. 	if (isset($_POST['group_rss']))

    905. 

  905. 	{

    906. 

  906. 		$groupdata['group_rss'] = sf_filter_save_cleanurl($_POST['group_rss']);

    907. 

  907. 	} else {

    908. 

  908. 		$groupdata['group_rss'] = sf_filter_save_cleanurl($_POST['cgroup_rss']);

    909. 

  909. 	}

    910. 

  910. 

    911. 

  911.     # fail if any user groups arent assigned a permission

    912. 

  912. 	for ($x=0; $x<count($perm_list); $x++)

    913. 

  913. 	{

    914. 

  914. 		if ($perm_list[$x] == -1)

    915. 

  915. 		{

    916. 

  916. 	        $mess = __("All User Groups Must Be Assigned A Default Permission", "sforum");

    917. 

  917.     	    return $mess;

    918. 

  918. 		}

    919. 

  919. 	}

    920. 

  920. 

    921. 

  921. 	# save the default permissions for the group

    922. 

  922. 	for ($x=0; $x<count($ug_list); $x++)

    923. 

  923. 	{

    924. 

  924. 		if (sfa_get_defpermissions_role($group_id, $ug_list[$x]))

    925. 

  925. 		{

    926. 

  926. 			$sql = "

    927. 

  927. 				UPDATE ".SFDEFPERMISSIONS."

    928. 

  928. 				SET permission_role=$perm_list[$x]

    929. 

  929. 				WHERE group_id=$group_id AND usergroup_id=$ug_list[$x]";

    930. 

  930. 			$wpdb->query($sql);

    931. 

  931. 		} else {

    932. 

  932. 			sfa_add_defpermission_row($group_id, $ug_list[$x], $perm_list[$x]);

    933. 

  933. 		}

    934. 

  934. 	}

    935. 

  935. 

    936. 

  936.     if ($groupdata['group_name'] == $_POST['cgroup_name'] &&

    937. 

  937. 		$groupdata['group_seq'] == $_POST['cgroup_seq'] &&

    938. 

  938. 		$groupdata['group_desc'] == $_POST['cgroup_desc'] &&

    939. 

  939. 		$groupdata['group_rss'] == $_POST['cgroup_rss'] &&

    940. 

  940. 		$groupdata['group_message'] == $_POST['cgroup_message'] &&

    941. 

  941. 		$groupdata['group_icon'] == $_POST['cgroup_icon'])

    942. 

  942.     {

    943. 

  943.         $mess = __("No Data Changed", "sforum");

    944. 

  944.     } else {

    945. 

  945. 	    # has the sequence changed?

    946. 

  946. 	    if ($groupdata['group_seq'] != $_POST['cgroup_seq'])

    947. 

  947. 	    {

    948. 

  948. 	        # need to iterate through the groups to change sequence number

    949. 

  949. 	        $groups = $wpdb->get_results("SELECT group_id, group_seq FROM ".SFGROUPS." WHERE group_id <> ".$group_id." ORDER BY group_seq;");

    950. 

  950. 	        $cnt = count($groups);

    951. 

  951. 	        for ($i = 0; $i < $cnt; $i++)

    952. 

  952. 	        {

    953. 

  953. 	            if (($i + 1) < $groupdata['group_seq'])

    954. 

  954. 	            {

    955. 

  955. 	                sfa_bump_group_seq($groups[$i]->group_id, ($i + 1));

    956. 

  956. 	            } else {

    957. 

  957. 	                sfa_bump_group_seq($groups[$i]->group_id, ($i + 2));

    958. 

  958. 	            }

    959. 

  959. 	        }

    960. 

  960. 	    }

    961. 

  961. 

    962. 

  962. 		$sql = "UPDATE ".SFGROUPS." SET ";

    963. 

  963. 		$sql.= 'group_name="'.$groupdata['group_name'].'", ';

    964. 

  964. 		$sql.= 'group_desc="'.$groupdata['group_desc'].'", ';

    965. 

  965. 		$sql.= 'group_icon="'.$groupdata['group_icon'].'", ';

    966. 

  966. 		$sql.= 'group_rss="'.$groupdata['group_rss'].'", ';

    967. 

  967. 		$sql.= 'group_message="'.$groupdata['group_message'].'", ';

    968. 

  968. 		$sql.= 'group_seq='.$groupdata['group_seq']." ";

    969. 

  969. 		$sql.= "WHERE group_id=".$group_id.";";

    970. 

  970. 	    $success = $wpdb->query($sql);

    971. 

  971. 	    if ($success == false)

    972. 

  972. 	    {

    973. 

  973. 	        $mess = __("Group Record Update Failed!", "sforum");

    974. 

  974. 	    } else {

    975. 

  975. 	        $mess = __("Forum Group Record Updated", "sforum");

    976. 

  976. 	    }

    977. 

  977.     }

    978. 

  978. 

    979. 

  979.     return $mess;

    980. 

  980. }

    981. 

  981. 

    982. 

  982. # function to update an existing permission set for a forum

    983. 

  983. function sfa_save_forums_edit_perm()

    984. 

  984. {

    985. 

  985. 	global $wpdb;

    986. 

  986. 

    987. 

  987.     check_admin_referer('forum-adminform_permissionedit', 'forum-adminform_permissionedit');

    988. 

  988. 

    989. 

  989.     $permissiondata = array();

    990. 

  990.     $permission_id = sf_esc_int($_POST['permission_id']);

    991. 

  991.     $permissiondata['permission_role'] = sf_esc_int($_POST['role']);

    992. 

  992. 

    993. 

  993.     # dont do anything if the permission set wasnt actually updated

    994. 

  994.     if ($permissiondata['permission_role'] == $_POST['ugroup_perm'])

    995. 

  995.     {

    996. 

  996.         $mess = __("No Data Changed", "sforum");

    997. 

  997.         return;

    998. 

  998.     }

    999. 

  999. 

    1000. 

  1000. 	# save the updated permission set info

    1001. 

  1001. 	$sql = "UPDATE ".SFPERMISSIONS." SET ";

    1002. 

  1002. 	$sql.= 'permission_role="'.$permissiondata['permission_role'].'" ';

    1003. 

  1003. 	$sql.= "WHERE permission_id=".$permission_id.";";

    1004. 

  1004.     $success = $wpdb->query($sql);

    1005. 

  1005.     if ($success == false)

    1006. 

  1006.     {

    1007. 

  1007.         $mess = __("Permission Set Update Failed!", "sforum");

    1008. 

  1008.     } else {

    1009. 

  1009.         $mess = __("Permission Set Updated", "sforum");

    1010. 

  1010. 

    1011. 

  1011. 		# get affected members

    1012. 

  1012. 		$members = $wpdb->get_results("

    1013. 

  1013. 			SELECT DISTINCT user_id

    1014. 

  1014. 			FROM ".SFMEMBERSHIPS."

    1015. 

  1015. 			WHERE usergroup_id = (

    1016. 

  1016. 				SELECT usergroup_id

    1017. 

  1017. 				FROM ".SFPERMISSIONS."

    1018. 

  1018. 				WHERE permission_id = ".$permission_id."

    1019. 

  1019. 			)

    1020. 

  1020. 		");

    1021. 

  1021. 		sfc_rebuild_members_pm($members);

    1022. 

  1022.     }

    1023. 

  1023. 

    1024. 

  1024.     return $mess;

    1025. 

  1025. }

    1026. 

  1026. 

    1027. 

  1027. function sfa_bump_group_seq($id, $seq)

    1028. 

  1028. {

    1029. 

  1029. 	global $wpdb;

    1030. 

  1030. 

    1031. 

  1031. 	$sql = "UPDATE ".SFGROUPS." SET ";

    1032. 

  1032. 	$sql.= 'group_seq='.$seq." ";

    1033. 

  1033. 	$sql.= "WHERE group_id=".$id.";";

    1034. 

  1034. 

    1035. 

  1035. 	$wpdb->query($sql);

    1036. 

  1036. 	return;

    1037. 

  1037. }

    1038. 

  1038. 

    1039. 

  1039. function sfa_bump_forum_seq($id, $seq)

    1040. 

  1040. {

    1041. 

  1041. 	global $wpdb;

    1042. 

  1042. 

    1043. 

  1043. 	$sql = "UPDATE ".SFFORUMS." SET ";

    1044. 

  1044. 	$sql.= 'forum_seq='.$seq." ";

    1045. 

  1045. 	$sql.= "WHERE forum_id=".$id.";";

    1046. 

  1046. 

    1047. 

  1047. 	$wpdb->query($sql);

    1048. 

  1048. 	return;

    1049. 

  1049. }

    1050. 

  1050. 

    1051. 

  1051. function sfa_add_permission_data($forum_id, $usergroup_id, $permission)

    1052. 

  1052. {

    1053. 

  1053. 	global $wpdb;

    1054. 

  1054. 

    1055. 

  1055. 	$forumid = esc_sql($forum_id);

    1056. 

  1056. 	$usergroupid = esc_sql($usergroup_id);

    1057. 

  1057. 	$perm = esc_sql($permission);

    1058. 

  1058. 

    1059. 

  1059. 	$sql ="INSERT INTO ".SFPERMISSIONS." (forum_id, usergroup_id, permission_role) ";

    1060. 

  1060. 	$sql.="VALUES ('".$forumid."', '".$usergroupid."', '".$perm."');";

    1061. 

  1061. 

    1062. 

  1062. 	return $wpdb->query($sql);

    1063. 

  1063. }

    1064. 

  1064. 

    1065. 

  1065. function sfa_add_defpermission_row($group_id, $usergroup_id, $role)

    1066. 

  1066. {

    1067. 

  1067. 	global $wpdb;

    1068. 

  1068. 

    1069. 

  1069. 	$sql = "

    1070. 

  1070. 		INSERT INTO ".SFDEFPERMISSIONS."

    1071. 

  1071. 		(group_id, usergroup_id, permission_role)

    1072. 

  1072. 		VALUES

    1073. 

  1073. 		($group_id, $usergroup_id, $role)";

    1074. 

  1074. 

    1075. 

  1075. 	return $wpdb->query($sql);

    1076. 

  1076. }

    1077. 

  1077. 

    1078. 

  1078. function sfa_resequence_forums($groupid, $parent)

    1079. 

  1079. {

    1080. 

  1080. 	global $sequence;

    1081. 

  1081. 

    1082. 

  1082. 	$forums = sfa_get_group_forums_by_parent($groupid, $parent);

    1083. 

  1083. 

    1084. 

  1084. 	if($forums)

    1085. 

  1085. 	{

    1086. 

  1086. 		foreach ($forums as $forum)

    1087. 

  1087. 		{

    1088. 

  1088. 			$sequence++;

    1089. 

  1089. 			sfa_bump_forum_seq($forum->forum_id, $sequence);

    1090. 

  1090. 

    1091. 

  1091. 			if($forum->children)

    1092. 

  1092. 			{

    1093. 

  1093. 				$childlist = array(unserialize($forum->children));

    1094. 

  1094. 				if(count($childlist) > 0)

    1095. 

  1095. 				{

    1096. 

  1096. 					sfa_resequence_forums($groupid, $forum->forum_id);

    1097. 

  1097. 				}

    1098. 

  1098. 			}

    1099. 

  1099. 		}

    1100. 

  1100. 	}

    1101. 

  1101. 	return;

    1102. 

  1102. }

    1103. 

  1103. 

    1104. 

  1104. function sfa_clean_forum_children()

    1105. 

  1105. {

    1106. 

  1106. 	global $wpdb;

    1107. 

  1107. 

    1108. 

  1108. 	# Remove all chil records from forums

    1109. 

  1109. 	$wpdb->query("UPDATE ".SFFORUMS." set children=''");

    1110. 

  1110. 

    1111. 

  1111. 	# Now get ALL forums

    1112. 

  1112. 	$forums = $wpdb->get_results("SELECT forum_id, parent FROM ".SFFORUMS);

    1113. 

  1113. 	if($forums)

    1114. 

  1114. 	{

    1115. 

  1115. 		foreach($forums as $forum)

    1116. 

  1116. 		{

    1117. 

  1117. 			if($forum->parent != 0)

    1118. 

  1118. 			{

    1119. 

  1119. 				$childlist = $wpdb->get_row("SELECT group_id, children FROM ".SFFORUMS." WHERE forum_id=".$forum->parent);

    1120. 

  1120. 				if($childlist->children)

    1121. 

  1121. 				{

    1122. 

  1122. 					$children=unserialize($childlist->children);

    1123. 

  1123. 				} else {

    1124. 

  1124. 					$children = array();

    1125. 

  1125. 				}

    1126. 

  1126. 				$children[]=$forum->forum_id;

    1127. 

  1127. 				$wpdb->query("UPDATE ".SFFORUMS." set children='".serialize($children)."' WHERE forum_id=".$forum->parent);

    1128. 

  1128. 				$wpdb->query("UPDATE ".SFFORUMS." set group_id=".$childlist->group_id." WHERE forum_id=".$forum->forum_id);

    1129. 

  1129. 			}

    1130. 

  1130. 		}

    1131. 

  1131. 	}

    1132. 

  1132. 	return;

    1133. 

  1133. }

    1134. 

  1134. 

    1135. 

  1135. function sfa_save_forums_global_rss()

    1136. 

  1136. {

    1137. 

  1137. 	global $wpdb;

    1138. 

  1138. 

    1139. 

  1139.     check_admin_referer('forum-adminform_globalrss', 'forum-adminform_globalrss');

    1140. 

  1140. 

    1141. 

  1141. 	# update the globla rss replacement url

    1142. 

  1142. 	sf_update_option('sfallRSSurl', sf_filter_save_cleanurl($_POST['sfallrssurl']));

    1143. 

  1143.     $mess = __("Global RSS Settings Updated!", "sforum");

    1144. 

  1144. 

    1145. 

  1145.     return $mess;

    1146. 

  1146. }

    1147. 

  1147. 

    1148. 

  1148. function sfa_save_forums_global_rssset()

    1149. 

  1149. {

    1150. 

  1150. 	global $wpdb;

    1151. 

  1151. 

    1152. 

  1152.     check_admin_referer('forum-adminform_globalrssset', 'forum-adminform_globalrssset');

    1153. 

  1153. 

    1154. 

  1154.     $private = sf_esc_int($_POST['sfglobalrssset']);

    1155. 

  1155. 

    1156. 

  1156. 	$sql = "UPDATE ".SFFORUMS." SET ";

    1157. 

  1157. 	$sql.= 'forum_rss_private='.$private;

    1158. 

  1158. 	$success = $wpdb->query($sql);

    1159. 

  1159. 

    1160. 

  1160.     $mess = __("Global RSS Settings Updated!", "sforum");

    1161. 

  1161. 

    1162. 

  1162.     return $mess;

    1163. 

  1163. }

    1164. 

  1164. 

    1165. 

  1165. ?>
    1166.