PageRenderTime 82ms CodeModel.GetById 24ms RepoModel.GetById 1ms app.codeStats 0ms

/forum/Sources/ManageMembers.php

https://github.com/leftnode/nooges.com
PHP | 1316 lines | 1043 code | 106 blank | 167 comment | 160 complexity | 7c9138b5586552ec2fb8db45b4a34652 MD5 | raw file
    

  1. <?php

    2. 

  2. /**********************************************************************************

    3. 

  3. * ManageMembers.php                                                               *

    4. 

  4. ***********************************************************************************

    5. 

  5. * SMF: Simple Machines Forum                                                      *

    6. 

  6. * Open-Source Project Inspired by Zef Hemel (zef@zefhemel.com)                    *

    7. 

  7. * =============================================================================== *

    8. 

  8. * Software Version:           SMF 2.0 RC2                                         *

    9. 

  9. * Software by:                Simple Machines (http://www.simplemachines.org)     *

    10. 

  10. * Copyright 2006-2009 by:     Simple Machines LLC (http://www.simplemachines.org) *

    11. 

  11. *           2001-2006 by:     Lewis Media (http://www.lewismedia.com)             *

    12. 

  12. * Support, News, Updates at:  http://www.simplemachines.org                       *

    13. 

  13. ***********************************************************************************

    14. 

  14. * This program is free software; you may redistribute it and/or modify it under   *

    15. 

  15. * the terms of the provided license as published by Simple Machines LLC.          *

    16. 

  16. *                                                                                 *

    17. 

  17. * This program is distributed in the hope that it is and will be useful, but      *

    18. 

  18. * WITHOUT ANY WARRANTIES; without even any implied warranty of MERCHANTABILITY    *

    19. 

  19. * or FITNESS FOR A PARTICULAR PURPOSE.                                            *

    20. 

  20. *                                                                                 *

    21. 

  21. * See the "license.txt" file for details of the Simple Machines license.          *

    22. 

  22. * The latest version can always be found at http://www.simplemachines.org.        *

    23. 

  23. **********************************************************************************/

    24. 

  24. 

    25. 

  25. if (!defined('SMF'))

    26. 

  26. 	die('Hacking attempt...');

    27. 

  27. 

    28. 

  28. /* // Show a list of members or a selection of members.

    29. 

  29. 

    30. 

  30. 	void ViewMembers()

    31. 

  31. 		- the main entrance point for the Manage Members screen.

    32. 

  32. 		- called by ?action=admin;area=viewmembers.

    33. 

  33. 		- requires the moderate_forum permission.

    34. 

  34. 		- loads the ManageMembers template and ManageMembers language file.

    35. 

  35. 		- calls a function based on the given sub-action.

    36. 

  36. 

    37. 

  37. 	void ViewMemberlist()

    38. 

  38. 		- shows a list of members.

    39. 

  39. 		- called by ?action=admin;area=viewmembers;sa=all or ?action=admin;area=viewmembers;sa=query.

    40. 

  40. 		- requires the moderate_forum permission.

    41. 

  41. 		- uses the view_members sub template of the ManageMembers template.

    42. 

  42. 		- allows sorting on several columns.

    43. 

  43. 		- handles deletion of selected members.

    44. 

  44. 		- handles the search query sent by ?action=admin;area=viewmembers;sa=search.

    45. 

  45. 

    46. 

  46. 	void SearchMembers()

    47. 

  47. 		- search the member list, using one or more criteria.

    48. 

  48. 		- called by ?action=admin;area=viewmembers;sa=search.

    49. 

  49. 		- requires the moderate_forum permission.

    50. 

  50. 		- uses the search_members sub template of the ManageMembers template.

    51. 

  51. 		- form is submitted to action=admin;area=viewmembers;sa=query.

    52. 

  52. 

    53. 

  53. 	void MembersAwaitingActivation()

    54. 

  54. 		- show a list of members awaiting approval or activation.

    55. 

  55. 		- called by ?action=admin;area=viewmembers;sa=browse;type=approve or

    56. 

  56. 		  ?action=admin;area=viewmembers;sa=browse;type=activate.

    57. 

  57. 		- requires the moderate_forum permission.

    58. 

  58. 		- uses the admin_browse sub template of the ManageMembers template.

    59. 

  59. 		- allows instant approval or activation of (a selection of) members.

    60. 

  60. 		- list can be sorted on different columns.

    61. 

  61. 		- form submits to ?action=admin;area=viewmembers;sa=approve.

    62. 

  62. 

    63. 

  63. 	void AdminApprove()

    64. 

  64. 		- handles the approval, rejection, activation or deletion of members.

    65. 

  65. 		- called by ?action=admin;area=viewmembers;sa=approve.

    66. 

  66. 		- requires the moderate_forum permission.

    67. 

  67. 		- redirects to ?action=admin;area=viewmembers;sa=browse with the same parameters

    68. 

  68. 		  as the calling page.

    69. 

  69. 

    70. 

  70. 	int jeffsdatediff(int old)

    71. 

  71. 		- nifty function to calculate the number of days ago a given date was.

    72. 

  72. 		- requires a unix timestamp as input, returns an integer.

    73. 

  73. 		- in honour of Jeff Lewis, the original creator of...this function.

    74. 

  74. 		- the returned number of days is based on the forum time.

    75. 

  75. */

    76. 

  76. 

    77. 

  77. function ViewMembers()

    78. 

  78. {

    79. 

  79. 	global $txt, $scripturl, $context, $modSettings, $smcFunc;

    80. 

  80. 

    81. 

  81. 	$subActions = array(

    82. 

  82. 		'all' => array('ViewMemberlist', 'moderate_forum'),

    83. 

  83. 		'approve' => array('AdminApprove', 'moderate_forum'),

    84. 

  84. 		'browse' => array('MembersAwaitingActivation', 'moderate_forum'),

    85. 

  85. 		'search' => array('SearchMembers', 'moderate_forum'),

    86. 

  86. 		'query' => array('ViewMemberlist', 'moderate_forum'),

    87. 

  87. 	);

    88. 

  88. 

    89. 

  89. 	// Default to sub action 'index' or 'settings' depending on permissions.

    90. 

  90. 	$_REQUEST['sa'] = isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']]) ? $_REQUEST['sa'] : 'all';

    91. 

  91. 

    92. 

  92. 	// We know the sub action, now we know what you're allowed to do.

    93. 

  93. 	isAllowedTo($subActions[$_REQUEST['sa']][1]);

    94. 

  94. 

    95. 

  95. 	// Load the essentials.

    96. 

  96. 	loadLanguage('ManageMembers');

    97. 

  97. 	loadTemplate('ManageMembers');

    98. 

  98. 

    99. 

  99. 	// Get counts on every type of activation - for sections and filtering alike.

    100. 

  100. 	$request = $smcFunc['db_query']('', '

    101. 

  101. 		SELECT COUNT(*) AS total_members, is_activated

    102. 

  102. 		FROM {db_prefix}members

    103. 

  103. 		WHERE is_activated != {int:is_activated}

    104. 

  104. 		GROUP BY is_activated',

    105. 

  105. 		array(

    106. 

  106. 			'is_activated' => 1,

    107. 

  107. 		)

    108. 

  108. 	);

    109. 

  109. 	$context['activation_numbers'] = array();

    110. 

  110. 	$context['awaiting_activation'] = 0;

    111. 

  111. 	$context['awaiting_approval'] = 0;

    112. 

  112. 	while ($row = $smcFunc['db_fetch_assoc']($request))

    113. 

  113. 		$context['activation_numbers'][$row['is_activated']] = $row['total_members'];

    114. 

  114. 	$smcFunc['db_free_result']($request);

    115. 

  115. 

    116. 

  116. 	foreach ($context['activation_numbers'] as $activation_type => $total_members)

    117. 

  117. 	{

    118. 

  118. 		if (in_array($activation_type, array(0, 2)))

    119. 

  119. 			$context['awaiting_activation'] += $total_members;

    120. 

  120. 		elseif (in_array($activation_type, array(3, 4, 5)))

    121. 

  121. 			$context['awaiting_approval'] += $total_members;

    122. 

  122. 	}

    123. 

  123. 

    124. 

  124. 	// For the page header... do we show activation?

    125. 

  125. 	$context['show_activate'] = (!empty($modSettings['registration_method']) && $modSettings['registration_method'] == 1) || !empty($context['awaiting_activation']);

    126. 

  126. 

    127. 

  127. 	// What about approval?

    128. 

  128. 	$context['show_approve'] = (!empty($modSettings['registration_method']) && $modSettings['registration_method'] == 2) || !empty($context['awaiting_approval']);

    129. 

  129. 

    130. 

  130. 	// Setup the admin tabs.

    131. 

  131. 	$context[$context['admin_menu_name']]['tab_data'] = array(

    132. 

  132. 		'title' => $txt['admin_members'],

    133. 

  133. 		'help' => 'view_members',

    134. 

  134. 		'description' => $txt['admin_members_list'],

    135. 

  135. 		'tabs' => array(),

    136. 

  136. 	);

    137. 

  137. 

    138. 

  138. 	$context['tabs'] = array(

    139. 

  139. 		'viewmembers' => array(

    140. 

  140. 			'label' => $txt['view_all_members'],

    141. 

  141. 			'description' => $txt['admin_members_list'],

    142. 

  142. 			'url' => $scripturl . '?action=admin;area=viewmembers;sa=all',

    143. 

  143. 			'is_selected' => $_REQUEST['sa'] == 'all',

    144. 

  144. 		),

    145. 

  145. 		'search' => array(

    146. 

  146. 			'label' => $txt['mlist_search'],

    147. 

  147. 			'description' => $txt['admin_members_list'],

    148. 

  148. 			'url' => $scripturl . '?action=admin;area=viewmembers;sa=search',

    149. 

  149. 			'is_selected' => $_REQUEST['sa'] == 'search' || $_REQUEST['sa'] == 'query',

    150. 

  150. 		),

    151. 

  151. 		'approve' => array(

    152. 

  152. 			'label' => sprintf($txt['admin_browse_awaiting_approval'], $context['awaiting_approval']),

    153. 

  153. 			'description' => $txt['admin_browse_approve_desc'],

    154. 

  154. 			'url' => $scripturl . '?action=admin;area=viewmembers;sa=browse;type=approve',

    155. 

  155. 			'is_selected' => false,

    156. 

  156. 		),

    157. 

  157. 		'activate' => array(

    158. 

  158. 			'label' => sprintf($txt['admin_browse_awaiting_activate'], $context['awaiting_activation']),

    159. 

  159. 			'description' => $txt['admin_browse_activate_desc'],

    160. 

  160. 			'url' => $scripturl . '?action=admin;area=viewmembers;sa=browse;type=activate',

    161. 

  161. 			'is_selected' => false,

    162. 

  162. 			'is_last' => true,

    163. 

  163. 		),

    164. 

  164. 	);

    165. 

  165. 

    166. 

  166. 	// Sort out the tabs for the ones which may not exist!

    167. 

  167. 	if (!$context['show_activate'] && ($_REQUEST['sa'] != 'browse' || $_REQUEST['type'] != 'activate'))

    168. 

  168. 	{

    169. 

  169. 		$context['tabs']['approve']['is_last'] = true;

    170. 

  170. 		unset($context['tabs']['activate']);

    171. 

  171. 	}

    172. 

  172. 	if (!$context['show_approve'] && ($_REQUEST['sa'] != 'browse' || $_REQUEST['type'] != 'approve'))

    173. 

  173. 	{

    174. 

  174. 		if (!$context['show_activate'] && ($_REQUEST['sa'] != 'browse' || $_REQUEST['type'] != 'activate'))

    175. 

  175. 			$context['tabs']['search']['is_last'] = true;

    176. 

  176. 		unset($context['tabs']['approve']);

    177. 

  177. 	}

    178. 

  178. 

    179. 

  179. 	$subActions[$_REQUEST['sa']][0]();

    180. 

  180. }

    181. 

  181. 

    182. 

  182. // View all members.

    183. 

  183. function ViewMemberlist()

    184. 

  184. {

    185. 

  185. 	global $txt, $scripturl, $context, $modSettings, $sourcedir, $smcFunc, $user_info;

    186. 

  186. 

    187. 

  187. 	// Set the current sub action.

    188. 

  188. 	$context['sub_action'] = $_REQUEST['sa'];

    189. 

  189. 

    190. 

  190. 	// Are we performing a delete?

    191. 

  191. 	if (isset($_POST['delete_members']) && !empty($_POST['delete']) && allowedTo('profile_remove_any'))

    192. 

  192. 	{

    193. 

  193. 		checkSession();

    194. 

  194. 

    195. 

  195. 		// Clean the input.

    196. 

  196. 		foreach ($_POST['delete'] as $key => $value)

    197. 

  197. 		{

    198. 

  198. 			$_POST['delete'][$key] = (int) $value;

    199. 

  199. 			// Don't delete yourself, idiot.

    200. 

  200. 			if ($value == $user_info['id'])

    201. 

  201. 				unset($_POST['delete'][$key]);

    202. 

  202. 		}

    203. 

  203. 

    204. 

  204. 		if (!empty($_POST['delete']))

    205. 

  205. 		{

    206. 

  206. 			// Delete all the selected members.

    207. 

  207. 			require_once($sourcedir . '/Subs-Members.php');

    208. 

  208. 			deleteMembers($_POST['delete'], true);

    209. 

  209. 		}

    210. 

  210. 	}

    211. 

  211. 

    212. 

  212. 	if ($context['sub_action'] == 'query' && !empty($_REQUEST['params']) && empty($_POST))

    213. 

  213. 		$_POST += @unserialize(base64_decode($_REQUEST['params']));

    214. 

  214. 

    215. 

  215. 	// Check input after a member search has been submitted.

    216. 

  216. 	if ($context['sub_action'] == 'query')

    217. 

  217. 	{

    218. 

  218. 		// Retrieving the membergroups and postgroups.

    219. 

  219. 		$context['membergroups'] = array(

    220. 

  220. 			array(

    221. 

  221. 				'id' => 0,

    222. 

  222. 				'name' => $txt['membergroups_members'],

    223. 

  223. 				'can_be_additional' => false

    224. 

  224. 			)

    225. 

  225. 		);

    226. 

  226. 		$context['postgroups'] = array();

    227. 

  227. 

    228. 

  228. 		$request = $smcFunc['db_query']('', '

    229. 

  229. 			SELECT id_group, group_name, min_posts

    230. 

  230. 			FROM {db_prefix}membergroups

    231. 

  231. 			WHERE id_group != {int:moderator_group}

    232. 

  232. 			ORDER BY min_posts, CASE WHEN id_group < {int:newbie_group} THEN id_group ELSE 4 END, group_name',

    233. 

  233. 			array(

    234. 

  234. 				'moderator_group' => 3,

    235. 

  235. 				'newbie_group' => 4,

    236. 

  236. 			)

    237. 

  237. 		);

    238. 

  238. 		while ($row = $smcFunc['db_fetch_assoc']($request))

    239. 

  239. 		{

    240. 

  240. 			if ($row['min_posts'] == -1)

    241. 

  241. 				$context['membergroups'][] = array(

    242. 

  242. 					'id' => $row['id_group'],

    243. 

  243. 					'name' => $row['group_name'],

    244. 

  244. 					'can_be_additional' => true

    245. 

  245. 				);

    246. 

  246. 			else

    247. 

  247. 				$context['postgroups'][] = array(

    248. 

  248. 					'id' => $row['id_group'],

    249. 

  249. 					'name' => $row['group_name']

    250. 

  250. 				);

    251. 

  251. 		}

    252. 

  252. 		$smcFunc['db_free_result']($request);

    253. 

  253. 

    254. 

  254. 		// Some data about the form fields and how they are linked to the database.

    255. 

  255. 		$params = array(

    256. 

  256. 			'mem_id' => array(

    257. 

  257. 				'db_fields' => array('id_member'),

    258. 

  258. 				'type' => 'int',

    259. 

  259. 				'range' => true

    260. 

  260. 			),

    261. 

  261. 			'age' => array(

    262. 

  262. 				'db_fields' => array('birthdate'),

    263. 

  263. 				'type' => 'age',

    264. 

  264. 				'range' => true

    265. 

  265. 			),

    266. 

  266. 			'posts' => array(

    267. 

  267. 				'db_fields' => array('posts'),

    268. 

  268. 				'type' => 'int',

    269. 

  269. 				'range' => true

    270. 

  270. 			),

    271. 

  271. 			'reg_date' => array(

    272. 

  272. 				'db_fields' => array('date_registered'),

    273. 

  273. 				'type' => 'date',

    274. 

  274. 				'range' => true

    275. 

  275. 			),

    276. 

  276. 			'last_online' => array(

    277. 

  277. 				'db_fields' => array('last_login'),

    278. 

  278. 				'type' => 'date',

    279. 

  279. 				'range' => true

    280. 

  280. 			),

    281. 

  281. 			'gender' => array(

    282. 

  282. 				'db_fields' => array('gender'),

    283. 

  283. 				'type' => 'checkbox',

    284. 

  284. 				'values' => array('0', '1', '2'),

    285. 

  285. 			),

    286. 

  286. 			'activated' => array(

    287. 

  287. 				'db_fields' => array('CASE WHEN is_activated IN (1, 11) THEN 1 ELSE 0 END'),

    288. 

  288. 				'type' => 'checkbox',

    289. 

  289. 				'values' => array('0', '1'),

    290. 

  290. 			),

    291. 

  291. 			'membername' => array(

    292. 

  292. 				'db_fields' => array('member_name', 'real_name'),

    293. 

  293. 				'type' => 'string'

    294. 

  294. 			),

    295. 

  295. 			'email' => array(

    296. 

  296. 				'db_fields' => array('email_address'),

    297. 

  297. 				'type' => 'string'

    298. 

  298. 			),

    299. 

  299. 			'website' => array(

    300. 

  300. 				'db_fields' => array('website_title', 'website_url'),

    301. 

  301. 				'type' => 'string'

    302. 

  302. 			),

    303. 

  303. 			'location' => array(

    304. 

  304. 				'db_fields' => array('location'),

    305. 

  305. 				'type' => 'string'

    306. 

  306. 			),

    307. 

  307. 			'ip' => array(

    308. 

  308. 				'db_fields' => array('member_ip'),

    309. 

  309. 				'type' => 'string'

    310. 

  310. 			),

    311. 

  311. 			'messenger' => array(

    312. 

  312. 				'db_fields' => array('icq', 'aim', 'yim', 'msn'),

    313. 

  313. 				'type' => 'string'

    314. 

  314. 			)

    315. 

  315. 		);

    316. 

  316. 		$range_trans = array(

    317. 

  317. 			'--' => '<',

    318. 

  318. 			'-' => '<=',

    319. 

  319. 			'=' => '=',

    320. 

  320. 			'+' => '>=',

    321. 

  321. 			'++' => '>'

    322. 

  322. 		);

    323. 

  323. 

    324. 

  324. 		// !!! Validate a little more.

    325. 

  325. 

    326. 

  326. 		// Loop through every field of the form.

    327. 

  327. 		$query_parts = array();

    328. 

  328. 		$where_params = array();

    329. 

  329. 		foreach ($params as $param_name => $param_info)

    330. 

  330. 		{

    331. 

  331. 			// Not filled in?

    332. 

  332. 			if (!isset($_POST[$param_name]) || $_POST[$param_name] === '')

    333. 

  333. 				continue;

    334. 

  334. 

    335. 

  335. 			// Make sure numeric values are really numeric.

    336. 

  336. 			if (in_array($param_info['type'], array('int', 'age')))

    337. 

  337. 				$_POST[$param_name] = (int) $_POST[$param_name];

    338. 

  338. 			// Date values have to match the specified format.

    339. 

  339. 			elseif ($param_info['type'] == 'date')

    340. 

  340. 			{

    341. 

  341. 				// Check if this date format is valid.

    342. 

  342. 				if (preg_match('/^\d{4}-\d{1,2}-\d{1,2}$/', $_POST[$param_name]) == 0)

    343. 

  343. 					continue;

    344. 

  344. 

    345. 

  345. 				$_POST[$param_name] = strtotime($_POST[$param_name]);

    346. 

  346. 			}

    347. 

  347. 

    348. 

  348. 			// Those values that are in some kind of range (<, <=, =, >=, >).

    349. 

  349. 			if (!empty($param_info['range']))

    350. 

  350. 			{

    351. 

  351. 				// Default to '=', just in case...

    352. 

  352. 				if (empty($range_trans[$_POST['types'][$param_name]]))

    353. 

  353. 					$_POST['types'][$param_name] = '=';

    354. 

  354. 

    355. 

  355. 				// Handle special case 'age'.

    356. 

  356. 				if ($param_info['type'] == 'age')

    357. 

  357. 				{

    358. 

  358. 					// All people that were born between $lowerlimit and $upperlimit are currently the specified age.

    359. 

  359. 					$datearray = getdate(forum_time());

    360. 

  360. 					$upperlimit = sprintf('%04d-%02d-%02d', $datearray['year'] - $_POST[$param_name], $datearray['mon'], $datearray['mday']);

    361. 

  361. 					$lowerlimit = sprintf('%04d-%02d-%02d', $datearray['year'] - $_POST[$param_name] - 1, $datearray['mon'], $datearray['mday']);

    362. 

  362. 					if (in_array($_POST['types'][$param_name], array('-', '--', '=')))

    363. 

  363. 					{

    364. 

  364. 						$query_parts[] = ($param_info['db_fields'][0]) . ' > {string:' . $param_name . '_minlimit}';

    365. 

  365. 						$where_params[$param_name . '_minlimit'] = ($_POST['types'][$param_name] == '--' ? $upperlimit : $lowerlimit);

    366. 

  366. 					}

    367. 

  367. 					if (in_array($_POST['types'][$param_name], array('+', '++', '=')))

    368. 

  368. 					{

    369. 

  369. 						$query_parts[] = ($param_info['db_fields'][0]) . ' <= {string:' . $param_name . '_pluslimit}';

    370. 

  370. 						$where_params[$param_name . '_pluslimit'] = ($_POST['types'][$param_name] == '++' ? $lowerlimit : $upperlimit);

    371. 

  371. 

    372. 

  372. 						// Make sure that members that didn't set their birth year are not queried.

    373. 

  373. 						$query_parts[] = ($param_info['db_fields'][0]) . ' > {date:dec_zero_date}';

    374. 

  374. 						$where_params['dec_zero_date'] = '0004-12-31';

    375. 

  375. 					}

    376. 

  376. 				}

    377. 

  377. 				// Special case - equals a date.

    378. 

  378. 				elseif ($param_info['type'] == 'date' && $_POST['types'][$param_name] == '=')

    379. 

  379. 				{

    380. 

  380. 					$query_parts[] = $param_info['db_fields'][0] . ' > ' . $_POST[$param_name] . ' AND ' . $param_info['db_fields'][0] . ' < ' . ($_POST[$param_name] + 86400);

    381. 

  381. 				}

    382. 

  382. 				else

    383. 

  383. 					$query_parts[] = $param_info['db_fields'][0] . ' ' . $range_trans[$_POST['types'][$param_name]] . ' ' . $_POST[$param_name];

    384. 

  384. 			}

    385. 

  385. 			// Checkboxes.

    386. 

  386. 			elseif ($param_info['type'] == 'checkbox')

    387. 

  387. 			{

    388. 

  388. 				// Each checkbox or no checkbox at all is checked -> ignore.

    389. 

  389. 				if (!is_array($_POST[$param_name]) || count($_POST[$param_name]) == 0 || count($_POST[$param_name]) == count($param_info['values']))

    390. 

  390. 					continue;

    391. 

  391. 

    392. 

  392. 				$query_parts[] = ($param_info['db_fields'][0]) . ' IN ({array_string:' . $param_name . '_check})';

    393. 

  393. 				$where_params[$param_name . '_check'] = $_POST[$param_name];

    394. 

  394. 			}

    395. 

  395. 			else

    396. 

  396. 			{

    397. 

  397. 				// Replace the wildcard characters ('*' and '?') into MySQL ones.

    398. 

  398. 				$_POST[$param_name] = strtolower(strtr($smcFunc['htmlspecialchars']($_POST[$param_name], ENT_QUOTES), array('%' => '\%', '_' => '\_', '*' => '%', '?' => '_')));

    399. 

  399. 

    400. 

  400. 				$query_parts[] = '(' . implode( ' LIKE {string:' . $param_name . '_normal} OR ', $param_info['db_fields']) . ' LIKE {string:' . $param_name . '_normal})';

    401. 

  401. 				$where_params[$param_name . '_normal'] = '%' . $_POST[$param_name] . '%';

    402. 

  402. 			}

    403. 

  403. 		}

    404. 

  404. 

    405. 

  405. 		// Set up the membergroup query part.

    406. 

  406. 		$mg_query_parts = array();

    407. 

  407. 

    408. 

  408. 		// Primary membergroups, but only if at least was was not selected.

    409. 

  409. 		if (!empty($_POST['membergroups'][1]) && count($context['membergroups']) != count($_POST['membergroups'][1]))

    410. 

  410. 		{

    411. 

  411. 			$mg_query_parts[] = 'mem.id_group IN ({array_int:group_check})';

    412. 

  412. 			$where_params['group_check'] = $_POST['membergroups'][1];

    413. 

  413. 		}

    414. 

  414. 

    415. 

  415. 		// Additional membergroups (these are only relevant if not all primary groups where selected!).

    416. 

  416. 		if (!empty($_POST['membergroups'][2]) && (empty($_POST['membergroups'][1]) || count($context['membergroups']) != count($_POST['membergroups'][1])))

    417. 

  417. 			foreach ($_POST['membergroups'][2] as $mg)

    418. 

  418. 			{

    419. 

  419. 				$mg_query_parts[] = 'FIND_IN_SET({int:add_group_' . $mg . '}, mem.additional_groups)';

    420. 

  420. 				$where_params['add_group_' . $mg] = $mg;

    421. 

  421. 			}

    422. 

  422. 

    423. 

  423. 		// Combine the one or two membergroup parts into one query part linked with an OR.

    424. 

  424. 		if (!empty($mg_query_parts))

    425. 

  425. 			$query_parts[] = '(' . implode(' OR ', $mg_query_parts) . ')';

    426. 

  426. 

    427. 

  427. 		// Get all selected post count related membergroups.

    428. 

  428. 		if (!empty($_POST['postgroups']) && count($_POST['postgroups']) != count($context['postgroups']))

    429. 

  429. 		{

    430. 

  430. 			$query_parts[] = 'id_post_group IN ({array_int:post_groups})';

    431. 

  431. 			$where_params['post_groups'] = $_POST['postgroups'];

    432. 

  432. 		}

    433. 

  433. 

    434. 

  434. 		// Construct the where part of the query.

    435. 

  435. 		$where = empty($query_parts) ? '1' : implode('

    436. 

  436. 			AND ', $query_parts);

    437. 

  437. 

    438. 

  438. 		$search_params = base64_encode(serialize($_POST));

    439. 

  439. 	}

    440. 

  440. 	else

    441. 

  441. 		$search_params = null;

    442. 

  442. 

    443. 

  443. 	// Construct the additional URL part with the query info in it.

    444. 

  444. 	$context['params_url'] = $context['sub_action'] == 'query' ? ';sa=query;params=' . $search_params : '';

    445. 

  445. 

    446. 

  446. 	// Get the title and sub template ready..

    447. 

  447. 	$context['page_title'] = $txt['admin_members'];

    448. 

  448. 

    449. 

  449. 	$listOptions = array(

    450. 

  450. 		'id' => 'member_list',

    451. 

  451. 		'items_per_page' => $modSettings['defaultMaxMembers'],

    452. 

  452. 		'base_href' => $scripturl . '?action=admin;area=viewmembers' . $context['params_url'],

    453. 

  453. 		'default_sort_col' => 'user_name',

    454. 

  454. 		'get_items' => array(

    455. 

  455. 			'file' => $sourcedir . '/Subs-Members.php',

    456. 

  456. 			'function' => 'list_getMembers',

    457. 

  457. 			'params' => array(

    458. 

  458. 				isset($where) ? $where : '1=1',

    459. 

  459. 				isset($where_params) ? $where_params : array(),

    460. 

  460. 			),

    461. 

  461. 		),

    462. 

  462. 		'get_count' => array(

    463. 

  463. 			'file' => $sourcedir . '/Subs-Members.php',

    464. 

  464. 			'function' => 'list_getNumMembers',

    465. 

  465. 			'params' => array(

    466. 

  466. 				isset($where) ? $where : '1=1',

    467. 

  467. 				isset($where_params) ? $where_params : array(),

    468. 

  468. 			),

    469. 

  469. 		),

    470. 

  470. 		'columns' => array(

    471. 

  471. 			'id_member' => array(

    472. 

  472. 				'header' => array(

    473. 

  473. 					'value' => $txt['member_id'],

    474. 

  474. 				),

    475. 

  475. 				'data' => array(

    476. 

  476. 					'db' => 'id_member',

    477. 

  477. 					'class' => 'windowbg',

    478. 

  478. 					'style' => 'text-align: center;',

    479. 

  479. 				),

    480. 

  480. 				'sort' => array(

    481. 

  481. 					'default' => 'id_member',

    482. 

  482. 					'reverse' => 'id_member DESC',

    483. 

  483. 				),

    484. 

  484. 			),

    485. 

  485. 			'user_name' => array(

    486. 

  486. 				'header' => array(

    487. 

  487. 					'value' => $txt['username'],

    488. 

  488. 				),

    489. 

  489. 				'data' => array(

    490. 

  490. 					'sprintf' => array(

    491. 

  491. 						'format' => '<a href="' . strtr($scripturl, array('%' => '%%')) . '?action=profile;u=%1$d">%2$s</a>',

    492. 

  492. 						'params' => array(

    493. 

  493. 							'id_member' => false,

    494. 

  494. 							'member_name' => false,

    495. 

  495. 						),

    496. 

  496. 					),

    497. 

  497. 				),

    498. 

  498. 				'sort' => array(

    499. 

  499. 					'default' => 'member_name',

    500. 

  500. 					'reverse' => 'member_name DESC',

    501. 

  501. 				),

    502. 

  502. 			),

    503. 

  503. 			'display_name' => array(

    504. 

  504. 				'header' => array(

    505. 

  505. 					'value' => $txt['display_name'],

    506. 

  506. 				),

    507. 

  507. 				'data' => array(

    508. 

  508. 					'sprintf' => array(

    509. 

  509. 						'format' => '<a href="' . strtr($scripturl, array('%' => '%%')) . '?action=profile;u=%1$d">%2$s</a>',

    510. 

  510. 						'params' => array(

    511. 

  511. 							'id_member' => false,

    512. 

  512. 							'real_name' => false,

    513. 

  513. 						),

    514. 

  514. 					),

    515. 

  515. 				),

    516. 

  516. 				'sort' => array(

    517. 

  517. 					'default' => 'real_name',

    518. 

  518. 					'reverse' => 'real_name DESC',

    519. 

  519. 				),

    520. 

  520. 			),

    521. 

  521. 			'email' => array(

    522. 

  522. 				'header' => array(

    523. 

  523. 					'value' => $txt['email_address'],

    524. 

  524. 				),

    525. 

  525. 				'data' => array(

    526. 

  526. 					'sprintf' => array(

    527. 

  527. 						'format' => '<a href="mailto:%1$s">%1$s</a>',

    528. 

  528. 						'params' => array(

    529. 

  529. 							'email_address' => true,

    530. 

  530. 						),

    531. 

  531. 					),

    532. 

  532. 					'class' => 'windowbg',

    533. 

  533. 				),

    534. 

  534. 				'sort' => array(

    535. 

  535. 					'default' => 'email_address',

    536. 

  536. 					'reverse' => 'email_address DESC',

    537. 

  537. 				),

    538. 

  538. 			),

    539. 

  539. 			'ip' => array(

    540. 

  540. 				'header' => array(

    541. 

  541. 					'value' => $txt['ip_address'],

    542. 

  542. 				),

    543. 

  543. 				'data' => array(

    544. 

  544. 					'sprintf' => array(

    545. 

  545. 						'format' => '<a href="' . strtr($scripturl, array('%' => '%%')) . '?action=trackip;searchip=%1$s">%1$s</a>',

    546. 

  546. 						'params' => array(

    547. 

  547. 							'member_ip' => false,

    548. 

  548. 						),

    549. 

  549. 					),

    550. 

  550. 				),

    551. 

  551. 				'sort' => array(

    552. 

  552. 					'default' => 'INET_ATON(member_ip)',

    553. 

  553. 					'reverse' => 'INET_ATON(member_ip) DESC',

    554. 

  554. 				),

    555. 

  555. 			),

    556. 

  556. 			'last_active' => array(

    557. 

  557. 				'header' => array(

    558. 

  558. 					'value' => $txt['viewmembers_online'],

    559. 

  559. 				),

    560. 

  560. 				'data' => array(

    561. 

  561. 					'function' => create_function('$rowData', '

    562. 

  562. 						global $txt;

    563. 

  563. 

    564. 

  564. 						// Calculate number of days since last online.

    565. 

  565. 						if (empty($rowData[\'last_login\']))

    566. 

  566. 							$difference = $txt[\'never\'];

    567. 

  567. 						else

    568. 

  568. 						{

    569. 

  569. 							$num_days_difference = jeffsdatediff($rowData[\'last_login\']);

    570. 

  570. 

    571. 

  571. 							// Today.

    572. 

  572. 							if (empty($num_days_difference))

    573. 

  573. 								$difference = $txt[\'viewmembers_today\'];

    574. 

  574. 

    575. 

  575. 							// Yesterday.

    576. 

  576. 							elseif ($num_days_difference == 1)

    577. 

  577. 								$difference = sprintf(\'1 %1$s\', $txt[\'viewmembers_day_ago\']);

    578. 

  578. 

    579. 

  579. 							// X days ago.

    580. 

  580. 							else

    581. 

  581. 								$difference = sprintf(\'%1$d %2$s\', $num_days_difference, $txt[\'viewmembers_days_ago\']);

    582. 

  582. 						}

    583. 

  583. 

    584. 

  584. 						// Show it in italics if they\'re not activated...

    585. 

  585. 						if ($rowData[\'is_activated\'] % 10 != 1)

    586. 

  586. 							$difference = sprintf(\'<em title="%1$s">%2$s</em>\', $txt[\'not_activated\'], $difference);

    587. 

  587. 

    588. 

  588. 						return $difference;

    589. 

  589. 					'),

    590. 

  590. 				),

    591. 

  591. 				'sort' =>  array(

    592. 

  592. 					'default' => 'last_login DESC',

    593. 

  593. 					'reverse' => 'last_login',

    594. 

  594. 				),

    595. 

  595. 			),

    596. 

  596. 			'posts' => array(

    597. 

  597. 				'header' => array(

    598. 

  598. 					'value' => $txt['member_postcount'],

    599. 

  599. 				),

    600. 

  600. 				'data' => array(

    601. 

  601. 					'db' => 'posts',

    602. 

  602. 				),

    603. 

  603. 				'sort' =>  array(

    604. 

  604. 					'default' => 'posts',

    605. 

  605. 					'reverse' => 'posts DESC',

    606. 

  606. 				),

    607. 

  607. 			),

    608. 

  608. 			'check' => array(

    609. 

  609. 				'header' => array(

    610. 

  610. 					'value' => '<input type="checkbox" onclick="invertAll(this, this.form);" class="input_check" />',

    611. 

  611. 				),

    612. 

  612. 				'data' => array(

    613. 

  613. 					'function' => create_function('$rowData', '

    614. 

  614. 						global $user_info;

    615. 

  615. 

    616. 

  616. 						return \'<input type="checkbox" name="delete[]" value="\' . $rowData[\'id_member\'] . \'" class="input_check" \' . ($rowData[\'id_member\'] == $user_info[\'id\'] || $rowData[\'id_group\'] == 1 || in_array(1, explode(\',\', $rowData[\'additional_groups\'])) ? \'disabled="disabled"\' : \'\') . \' />\';

    617. 

  617. 					'),

    618. 

  618. 					'class' => 'windowbg',

    619. 

  619. 					'style' => 'text-align: center',

    620. 

  620. 				),

    621. 

  621. 			),

    622. 

  622. 		),

    623. 

  623. 		'form' => array(

    624. 

  624. 			'href' => $scripturl . '?action=admin;area=viewmembers' . $context['params_url'],

    625. 

  625. 			'include_start' => true,

    626. 

  626. 			'include_sort' => true,

    627. 

  627. 		),

    628. 

  628. 		'additional_rows' => array(

    629. 

  629. 			array(

    630. 

  630. 				'position' => 'below_table_data',

    631. 

  631. 				'value' => '<input type="submit" name="delete_members" value="' . $txt['admin_delete_members'] . '" onclick="return confirm(\'' . $txt['confirm_delete_members'] . '\');" class="button_submit" />',

    632. 

  632. 				'class' => 'titlebg',

    633. 

  633. 				'style' => 'text-align: right;',

    634. 

  634. 			),

    635. 

  635. 		),

    636. 

  636. 	);

    637. 

  637. 

    638. 

  638. 	// Without not enough permissions, don't show 'delete members' checkboxes.

    639. 

  639. 	if (!allowedTo('profile_remove_any'))

    640. 

  640. 		unset($listOptions['cols']['check'], $listOptions['form'], $listOptions['additional_rows']);

    641. 

  641. 

    642. 

  642. 	require_once($sourcedir . '/Subs-List.php');

    643. 

  643. 	createList($listOptions);

    644. 

  644. 

    645. 

  645. 	$context['sub_template'] = 'show_list';

    646. 

  646. 	$context['default_list'] = 'member_list';

    647. 

  647. }

    648. 

  648. 

    649. 

  649. // Search the member list, using one or more criteria.

    650. 

  650. function SearchMembers()

    651. 

  651. {

    652. 

  652. 	global $context, $txt, $smcFunc;

    653. 

  653. 

    654. 

  654. 	// Get a list of all the membergroups and postgroups that can be selected.

    655. 

  655. 	$context['membergroups'] = array(

    656. 

  656. 		array(

    657. 

  657. 			'id' => 0,

    658. 

  658. 			'name' => $txt['membergroups_members'],

    659. 

  659. 			'can_be_additional' => false

    660. 

  660. 		)

    661. 

  661. 	);

    662. 

  662. 	$context['postgroups'] = array();

    663. 

  663. 

    664. 

  664. 	$request = $smcFunc['db_query']('', '

    665. 

  665. 		SELECT id_group, group_name, min_posts

    666. 

  666. 		FROM {db_prefix}membergroups

    667. 

  667. 		WHERE id_group != {int:moderator_group}

    668. 

  668. 		ORDER BY min_posts, CASE WHEN id_group < {int:newbie_group} THEN id_group ELSE 4 END, group_name',

    669. 

  669. 		array(

    670. 

  670. 			'moderator_group' => 3,

    671. 

  671. 			'newbie_group' => 4,

    672. 

  672. 		)

    673. 

  673. 	);

    674. 

  674. 	while ($row = $smcFunc['db_fetch_assoc']($request))

    675. 

  675. 	{

    676. 

  676. 		if ($row['min_posts'] == -1)

    677. 

  677. 			$context['membergroups'][] = array(

    678. 

  678. 				'id' => $row['id_group'],

    679. 

  679. 				'name' => $row['group_name'],

    680. 

  680. 				'can_be_additional' => true

    681. 

  681. 			);

    682. 

  682. 		else

    683. 

  683. 			$context['postgroups'][] = array(

    684. 

  684. 				'id' => $row['id_group'],

    685. 

  685. 				'name' => $row['group_name']

    686. 

  686. 			);

    687. 

  687. 	}

    688. 

  688. 	$smcFunc['db_free_result']($request);

    689. 

  689. 

    690. 

  690. 	$context['page_title'] = $txt['admin_members'];

    691. 

  691. 	$context['sub_template'] = 'search_members';

    692. 

  692. }

    693. 

  693. 

    694. 

  694. // List all members who are awaiting approval / activation

    695. 

  695. function MembersAwaitingActivation()

    696. 

  696. {

    697. 

  697. 	global $txt, $context, $scripturl, $modSettings, $smcFunc;

    698. 

  698. 	global $sourcedir;

    699. 

  699. 

    700. 

  700. 	// Not a lot here!

    701. 

  701. 	$context['page_title'] = $txt['admin_members'];

    702. 

  702. 	$context['sub_template'] = 'admin_browse';

    703. 

  703. 	$context['browse_type'] = isset($_REQUEST['type']) ? $_REQUEST['type'] : (!empty($modSettings['registration_method']) && $modSettings['registration_method'] == 1 ? 'activate' : 'approve');

    704. 

  704. 	if (isset($context['tabs'][$context['browse_type']]))

    705. 

  705. 		$context['tabs'][$context['browse_type']]['is_selected'] = true;

    706. 

  706. 

    707. 

  707. 	// Allowed filters are those we can have, in theory.

    708. 

  708. 	$context['allowed_filters'] = $context['browse_type'] == 'approve' ? array(3, 4, 5) : array(0, 2);

    709. 

  709. 	$context['current_filter'] = isset($_REQUEST['filter']) && in_array($_REQUEST['filter'], $context['allowed_filters']) && !empty($context['activation_numbers'][$_REQUEST['filter']]) ? (int) $_REQUEST['filter'] : -1;

    710. 

  710. 

    711. 

  711. 	// Sort out the different sub areas that we can actually filter by.

    712. 

  712. 	$context['available_filters'] = array();

    713. 

  713. 	foreach ($context['activation_numbers'] as $type => $amount)

    714. 

  714. 	{

    715. 

  715. 		// We have some of these...

    716. 

  716. 		if (in_array($type, $context['allowed_filters']) && $amount > 0)

    717. 

  717. 			$context['available_filters'][] = array(

    718. 

  718. 				'type' => $type,

    719. 

  719. 				'amount' => $amount,

    720. 

  720. 				'desc' => isset($txt['admin_browse_filter_type_' . $type]) ? $txt['admin_browse_filter_type_' . $type] : '?',

    721. 

  721. 				'selected' => $type == $context['current_filter']

    722. 

  722. 			);

    723. 

  723. 	}

    724. 

  724. 

    725. 

  725. 	// If the filter was not sent, set it to whatever has people in it!

    726. 

  726. 	if ($context['current_filter'] == -1 && !empty($context['available_filters'][0]['amount']))

    727. 

  727. 		$context['current_filter'] = $context['available_filters'][0]['type'];

    728. 

  728. 

    729. 

  729. 	// This little variable is used to determine if we should flag where we are looking.

    730. 

  730. 	$context['show_filter'] = ($context['current_filter'] != 0 && $context['current_filter'] != 3) || count($context['available_filters']) > 1;

    731. 

  731. 

    732. 

  732. 	// The columns that can be sorted.

    733. 

  733. 	$context['columns'] = array(

    734. 

  734. 		'id_member' => array('label' => $txt['admin_browse_id']),

    735. 

  735. 		'member_name' => array('label' => $txt['admin_browse_username']),

    736. 

  736. 		'email_address' => array('label' => $txt['admin_browse_email']),

    737. 

  737. 		'member_ip' => array('label' => $txt['admin_browse_ip']),

    738. 

  738. 		'date_registered' => array('label' => $txt['admin_browse_registered']),

    739. 

  739. 	);

    740. 

  740. 

    741. 

  741. 	// Are we showing duplicate information?

    742. 

  742. 	if (isset($_GET['showdupes']))

    743. 

  743. 		$_SESSION['showdupes'] = (int) $_GET['showdupes'];

    744. 

  744. 	$context['show_duplicates'] = !empty($_SESSION['showdupes']);

    745. 

  745. 

    746. 

  746. 	// Determine which actions we should allow on this page.

    747. 

  747. 	if ($context['browse_type'] == 'approve')

    748. 

  748. 	{

    749. 

  749. 		// If we are approving deleted accounts we have a slightly different list... actually a mirror ;)

    750. 

  750. 		if ($context['current_filter'] == 4)

    751. 

  751. 			$context['allowed_actions'] = array(

    752. 

  752. 				'reject' => $txt['admin_browse_w_approve_deletion'],

    753. 

  753. 				'ok' => $txt['admin_browse_w_reject'],

    754. 

  754. 			);

    755. 

  755. 		else

    756. 

  756. 			$context['allowed_actions'] = array(

    757. 

  757. 				'ok' => $txt['admin_browse_w_approve'],

    758. 

  758. 				'okemail' => $txt['admin_browse_w_approve'] . ' ' . $txt['admin_browse_w_email'],

    759. 

  759. 				'require_activation' => $txt['admin_browse_w_approve_require_activate'],

    760. 

  760. 				'reject' => $txt['admin_browse_w_reject'],

    761. 

  761. 				'rejectemail' => $txt['admin_browse_w_reject'] . ' ' . $txt['admin_browse_w_email'],

    762. 

  762. 			);

    763. 

  763. 	}

    764. 

  764. 	elseif ($context['browse_type'] == 'activate')

    765. 

  765. 		$context['allowed_actions'] = array(

    766. 

  766. 			'ok' => $txt['admin_browse_w_activate'],

    767. 

  767. 			'okemail' => $txt['admin_browse_w_activate'] . ' ' . $txt['admin_browse_w_email'],

    768. 

  768. 			'delete' => $txt['admin_browse_w_delete'],

    769. 

  769. 			'deleteemail' => $txt['admin_browse_w_delete'] . ' ' . $txt['admin_browse_w_email'],

    770. 

  770. 			'remind' => $txt['admin_browse_w_remind'] . ' ' . $txt['admin_browse_w_email'],

    771. 

  771. 		);

    772. 

  772. 

    773. 

  773. 

    774. 

  774. 	// Create an option list for actions allowed to be done with selected members.

    775. 

  775. 	$allowed_actions = '

    776. 

  776. 			<option selected="selected" value="">' . $txt['admin_browse_with_selected'] . ':</option>

    777. 

  777. 			<option value="" disabled="disabled">-----------------------------</option>';

    778. 

  778. 	foreach ($context['allowed_actions'] as $key => $desc)

    779. 

  779. 		$allowed_actions .= '

    780. 

  780. 			<option value="' . $key . '">' . $desc . '</option>';

    781. 

  781. 

    782. 

  782. 

    783. 

  783. 	// Setup the Javascript function for selecting an action for the list.

    784. 

  784. 	$javascript = '

    785. 

  785. 		function onSelectChange()

    786. 

  786. 		{

    787. 

  787. 			if (document.forms.postForm.todo.value == "")

    788. 

  788. 				return;

    789. 

  789. 

    790. 

  790. 			var message = "";';

    791. 

  791. 

    792. 

  792. 	// We have special messages for approving deletion of accounts - it's surprisingly logical - honest.

    793. 

  793. 	if ($context['current_filter'] == 4)

    794. 

  794. 		$javascript .= '

    795. 

  795. 			if (document.forms.postForm.todo.value.indexOf("reject") != -1)

    796. 

  796. 				message = "' . $txt['admin_browse_w_delete'] . '";

    797. 

  797. 			else

    798. 

  798. 				message = "' . $txt['admin_browse_w_reject'] . '";';

    799. 

  799. 	// Otherwise a nice standard message.

    800. 

  800. 	else

    801. 

  801. 		$javascript .= '

    802. 

  802. 			if (document.forms.postForm.todo.value.indexOf("delete") != -1)

    803. 

  803. 				message = "' . $txt['admin_browse_w_delete'] . '";

    804. 

  804. 			else if (document.forms.postForm.todo.value.indexOf("reject") != -1)

    805. 

  805. 				message = "' . $txt['admin_browse_w_reject'] . '";

    806. 

  806. 			else if (document.forms.postForm.todo.value == "remind")

    807. 

  807. 				message = "' . $txt['admin_browse_w_remind'] . '";

    808. 

  808. 			else

    809. 

  809. 				message = "' . ($context['browse_type'] == 'approve' ? $txt['admin_browse_w_approve'] : $txt['admin_browse_w_activate']) . '";';

    810. 

  810. 	$javascript .= '

    811. 

  811. 			if (confirm(message + " ' . $txt['admin_browse_warn'] . '"))

    812. 

  812. 				document.forms.postForm.submit();

    813. 

  813. 		}';

    814. 

  814. 

    815. 

  815. 	$listOptions = array(

    816. 

  816. 		'id' => 'approve_list',

    817. 

  817. 		'items_per_page' => $modSettings['defaultMaxMembers'],

    818. 

  818. 		'base_href' => $scripturl . '?action=admin;area=viewmembers;sa=browse;type=' . $context['browse_type'] . (!empty($context['show_filter']) ? ';filter=' . $context['current_filter'] : ''),

    819. 

  819. 		'default_sort_col' => 'date_registered',

    820. 

  820. 		'get_items' => array(

    821. 

  821. 			'file' => $sourcedir . '/Subs-Members.php',

    822. 

  822. 			'function' => 'list_getMembers',

    823. 

  823. 			'params' => array(

    824. 

  824. 				'is_activated = {int:activated_status}',

    825. 

  825. 				array('activated_status' => $context['current_filter']),

    826. 

  826. 				$context['show_duplicates'],

    827. 

  827. 			),

    828. 

  828. 		),

    829. 

  829. 		'get_count' => array(

    830. 

  830. 			'file' => $sourcedir . '/Subs-Members.php',

    831. 

  831. 			'function' => 'list_getNumMembers',

    832. 

  832. 			'params' => array(

    833. 

  833. 				'is_activated = {int:activated_status}',

    834. 

  834. 				array('activated_status' => $context['current_filter']),

    835. 

  835. 			),

    836. 

  836. 		),

    837. 

  837. 		'columns' => array(

    838. 

  838. 			'id_member' => array(

    839. 

  839. 				'header' => array(

    840. 

  840. 					'value' => $txt['member_id'],

    841. 

  841. 				),

    842. 

  842. 				'data' => array(

    843. 

  843. 					'db' => 'id_member',

    844. 

  844. 					'class' => 'windowbg',

    845. 

  845. 					'style' => 'text-align: center;',

    846. 

  846. 				),

    847. 

  847. 				'sort' => array(

    848. 

  848. 					'default' => 'id_member',

    849. 

  849. 					'reverse' => 'id_member DESC',

    850. 

  850. 				),

    851. 

  851. 			),

    852. 

  852. 			'user_name' => array(

    853. 

  853. 				'header' => array(

    854. 

  854. 					'value' => $txt['username'],

    855. 

  855. 				),

    856. 

  856. 				'data' => array(

    857. 

  857. 					'sprintf' => array(

    858. 

  858. 						'format' => '<a href="' . strtr($scripturl, array('%' => '%%')) . '?action=profile;u=%1$d">%2$s</a>',

    859. 

  859. 						'params' => array(

    860. 

  860. 							'id_member' => false,

    861. 

  861. 							'member_name' => false,

    862. 

  862. 						),

    863. 

  863. 					),

    864. 

  864. 				),

    865. 

  865. 				'sort' => array(

    866. 

  866. 					'default' => 'member_name',

    867. 

  867. 					'reverse' => 'member_name DESC',

    868. 

  868. 				),

    869. 

  869. 			),

    870. 

  870. 			'email' => array(

    871. 

  871. 				'header' => array(

    872. 

  872. 					'value' => $txt['email_address'],

    873. 

  873. 				),

    874. 

  874. 				'data' => array(

    875. 

  875. 					'sprintf' => array(

    876. 

  876. 						'format' => '<a href="mailto:%1$s">%1$s</a>',

    877. 

  877. 						'params' => array(

    878. 

  878. 							'email_address' => true,

    879. 

  879. 						),

    880. 

  880. 					),

    881. 

  881. 					'class' => 'windowbg',

    882. 

  882. 				),

    883. 

  883. 				'sort' => array(

    884. 

  884. 					'default' => 'email_address',

    885. 

  885. 					'reverse' => 'email_address DESC',

    886. 

  886. 				),

    887. 

  887. 			),

    888. 

  888. 			'ip' => array(

    889. 

  889. 				'header' => array(

    890. 

  890. 					'value' => $txt['ip_address'],

    891. 

  891. 				),

    892. 

  892. 				'data' => array(

    893. 

  893. 					'sprintf' => array(

    894. 

  894. 						'format' => '<a href="' . strtr($scripturl, array('%' => '%%')) . '?action=trackip;searchip=%1$s">%1$s</a>',

    895. 

  895. 						'params' => array(

    896. 

  896. 							'member_ip' => false,

    897. 

  897. 						),

    898. 

  898. 					),

    899. 

  899. 				),

    900. 

  900. 				'sort' => array(

    901. 

  901. 					'default' => 'INET_ATON(member_ip)',

    902. 

  902. 					'reverse' => 'INET_ATON(member_ip) DESC',

    903. 

  903. 				),

    904. 

  904. 			),

    905. 

  905. 			'hostname' => array(

    906. 

  906. 				'header' => array(

    907. 

  907. 					'value' => $txt['hostname'],

    908. 

  908. 				),

    909. 

  909. 				'data' => array(

    910. 

  910. 					'function' => create_function('$rowData', '

    911. 

  911. 						global $modSettings;

    912. 

  912. 

    913. 

  913. 						return host_from_ip($rowData[\'member_ip\']);

    914. 

  914. 					'),

    915. 

  915. 					'class' => 'smalltext',

    916. 

  916. 				),

    917. 

  917. 			),

    918. 

  918. 			'date_registered' => array(

    919. 

  919. 				'header' => array(

    920. 

  920. 					'value' => $txt['date_registered'],

    921. 

  921. 				),

    922. 

  922. 				'data' => array(

    923. 

  923. 					'function' => create_function('$rowData', '

    924. 

  924. 						return timeformat($rowData[\'date_registered\']);

    925. 

  925. 					'),

    926. 

  926. 				),

    927. 

  927. 				'sort' =>  array(

    928. 

  928. 					'default' => 'date_registered DESC',

    929. 

  929. 					'reverse' => 'date_registered',

    930. 

  930. 				),

    931. 

  931. 			),

    932. 

  932. 			'duplicates' => array(

    933. 

  933. 				'header' => array(

    934. 

  934. 					'value' => $txt['duplicates'],

    935. 

  935. 					// Make sure it doesn't go too wide.

    936. 

  936. 					'style' => 'width: 20%',

    937. 

  937. 				),

    938. 

  938. 				'data' => array(

    939. 

  939. 					'function' => create_function('$rowData', '

    940. 

  940. 						global $scripturl, $txt;

    941. 

  941. 

    942. 

  942. 						$member_links = array();

    943. 

  943. 						foreach ($rowData[\'duplicate_members\'] as $member)

    944. 

  944. 						{

    945. 

  945. 							if ($member[\'id\'])

    946. 

  946. 								$member_links[] = \'<a href="\' . $scripturl . \'?action=profile;u=\' . $member[\'id\'] . \'" \' . (!empty($member[\'is_banned\']) ? \'style="color: red;"\' : \'\') . \'>\' . $member[\'name\'] . \'</a>\';

    947. 

  947. 							else

    948. 

  948. 								$member_links[] = $member[\'name\'] . \' (\' . $txt[\'guest\'] . \')\';

    949. 

  949. 						}

    950. 

  950. 						return implode (\', \', $member_links);

    951. 

  951. 					'),

    952. 

  952. 					'class' => 'smalltext',

    953. 

  953. 				),

    954. 

  954. 			),

    955. 

  955. 			'check' => array(

    956. 

  956. 				'header' => array(

    957. 

  957. 					'value' => '<input type="checkbox" onclick="invertAll(this, this.form);" class="input_check" />',

    958. 

  958. 				),

    959. 

  959. 				'data' => array(

    960. 

  960. 					'sprintf' => array(

    961. 

  961. 						'format' => '<input type="checkbox" name="todoAction[]" value="%1$d" class="input_check" />',

    962. 

  962. 						'params' => array(

    963. 

  963. 							'id_member' => false,

    964. 

  964. 						),

    965. 

  965. 					),

    966. 

  966. 					'class' => 'windowbg',

    967. 

  967. 					'style' => 'text-align: center',

    968. 

  968. 				),

    969. 

  969. 			),

    970. 

  970. 		),

    971. 

  971. 		'javascript' => $javascript,

    972. 

  972. 		'form' => array(

    973. 

  973. 			'href' => $scripturl . '?action=admin;area=viewmembers;sa=approve;type=' . $context['browse_type'],

    974. 

  974. 			'name' => 'postForm',

    975. 

  975. 			'include_start' => true,

    976. 

  976. 			'include_sort' => true,

    977. 

  977. 			'hidden_fields' => array(

    978. 

  978. 				'orig_filter' => $context['current_filter'],

    979. 

  979. 			),

    980. 

  980. 		),

    981. 

  981. 		'additional_rows' => array(

    982. 

  982. 			array(

    983. 

  983. 				'position' => 'below_table_data',

    984. 

  984. 				'value' => '

    985. 

  985. 					<div class="floatleft">

    986. 

  986. 						[<a href="' . $scripturl . '?action=admin;area=viewmembers;sa=browse;showdupes=' . ($context['show_duplicates'] ? 0 : 1) . ';type=' . $context['browse_type'] . (!empty($context['show_filter']) ? ';filter=' . $context['current_filter'] : '') . ';' . $context['session_var'] . '=' . $context['session_id'] . '">' . ($context['show_duplicates'] ? $txt['dont_check_for_duplicate'] : $txt['check_for_duplicate']) . '</a>]

    987. 

  987. 					</div>

    988. 

  988. 					<div class="floatright">

    989. 

  989. 						<select name="todo" onchange="onSelectChange();">

    990. 

  990. 							' . $allowed_actions . '

    991. 

  991. 						</select>

    992. 

  992. 						<noscript><input type="submit" value="' . $txt['go'] . '" class="button_submit" /></noscript>

    993. 

  993. 					</div>',

    994. 

  994. 				'class' => 'titlebg',

    995. 

  995. 			),

    996. 

  996. 		),

    997. 

  997. 	);

    998. 

  998. 

    999. 

  999. 	// Pick what column to actually include if we're showing duplicates.

    1000. 

  1000. 	if ($context['show_duplicates'])

    1001. 

  1001. 		unset($listOptions['columns']['email']);

    1002. 

  1002. 	else

    1003. 

  1003. 		unset($listOptions['columns']['duplicates']);

    1004. 

  1004. 

    1005. 

  1005. 	// Only show hostname on duplicates as it takes a lot of time.

    1006. 

  1006. 	if (!$context['show_duplicates'] || !empty($modSettings['disableHostnameLookup']))

    1007. 

  1007. 		unset($listOptions['columns']['hostname']);

    1008. 

  1008. 

    1009. 

  1009. 	// Is there any need to show filters?

    1010. 

  1010. 	if (isset($context['available_filters']) && count($context['available_filters']) > 1)

    1011. 

  1011. 	{

    1012. 

  1012. 		$filterOptions = '

    1013. 

  1013. 			<strong>' . $txt['admin_browse_filter_by'] . ':</strong>

    1014. 

  1014. 			<select name="filter" onchange="this.form.submit();">';

    1015. 

  1015. 		foreach ($context['available_filters'] as $filter)

    1016. 

  1016. 			$filterOptions .= '

    1017. 

  1017. 				<option value="' . $filter['type'] . '"' . ($filter['selected'] ? ' selected="selected"' : '') . '>' . $filter['desc'] . ' - ' . $filter['amount'] . ' ' . ($filter['amount'] == 1 ? $txt['user'] : $txt['users']) . '</option>';

    1018. 

  1018. 		$filterOptions .= '

    1019. 

  1019. 			</select>

    1020. 

  1020. 			<noscript><input type="submit" value="' . $txt['go'] . '" name="filter" class="button_submit" /></noscript>';

    1021. 

  1021. 		$listOptions['additional_rows'][] = array(

    1022. 

  1022. 			'position' => 'above_column_headers',

    1023. 

  1023. 			'value' => $filterOptions,

    1024. 

  1024. 			'style' => 'text-align: center;',

    1025. 

  1025. 			'class' => 'titlebg',

    1026. 

  1026. 		);

    1027. 

  1027. 	}

    1028. 

  1028. 

    1029. 

  1029. 	// What about if we only have one filter, but it's not the "standard" filter - show them what they are looking at.

    1030. 

  1030. 	if (!empty($context['show_filter']) && !empty($context['available_filters']))

    1031. 

  1031. 		$listOptions['additional_rows'][] = array(

    1032. 

  1032. 			'position' => 'above_column_headers',

    1033. 

  1033. 			'value' => '<span class="smalltext"><strong>' . $txt['admin_browse_filter_show'] . ':</strong> ' . $context['available_filters'][0]['desc'] . '</span>',

    1034. 

  1034. 			'style' => 'text-align: left;',

    1035. 

  1035. 			'class' => 'windowbg2',

    1036. 

  1036. 		);

    1037. 

  1037. 

    1038. 

  1038. 	// Now that we have all the options, create the list.

    1039. 

  1039. 	require_once($sourcedir . '/Subs-List.php');

    1040. 

  1040. 	createList($listOptions);

    1041. 

  1041. }

    1042. 

  1042. 

    1043. 

  1043. // Do the approve/activate/delete stuff

    1044. 

  1044. function AdminApprove()

    1045. 

  1045. {

    1046. 

  1046. 	global $txt, $context, $scripturl, $modSettings, $sourcedir, $language, $user_info, $smcFunc;

    1047. 

  1047. 

    1048. 

  1048. 	require_once($sourcedir . '/Subs-Post.php');

    1049. 

  1049. 

    1050. 

  1050. 	// We also need to the login languages here - for emails.

    1051. 

  1051. 	loadLanguage('Login');

    1052. 

  1052. 

    1053. 

  1053. 	// Sort out where we are going...

    1054. 

  1054. 	$browse_type = isset($_REQUEST['type']) ? $_REQUEST['type'] : (!empty($modSettings['registration_method']) && $modSettings['registration_method'] == 1 ? 'activate' : 'approve');

    1055. 

  1055. 	$current_filter = (int) $_REQUEST['orig_filter'];

    1056. 

  1056. 

    1057. 

  1057. 	// If we are applying a filter do just that - then redirect.

    1058. 

  1058. 	if (isset($_REQUEST['filter']) && $_REQUEST['filter'] != $_REQUEST['orig_filter'])

    1059. 

  1059. 		redirectexit('action=admin;area=viewmembers;sa=browse;type=' . $_REQUEST['type'] . ';sort=' . $_REQUEST['sort'] . ';filter=' . $_REQUEST['filter'] . ';start=' . $_REQUEST['start']);

    1060. 

  1060. 

    1061. 

  1061. 	// Nothing to do?

    1062. 

  1062. 	if (!isset($_POST['todoAction']) && !isset($_POST['time_passed']))

    1063. 

  1063. 		redirectexit('action=admin;area=viewmembers;sa=browse;type=' . $_REQUEST['type'] . ';sort=' . $_REQUEST['sort'] . ';filter=' . $current_filter . ';start=' . $_REQUEST['start']);

    1064. 

  1064. 

    1065. 

  1065. 	// Are we dealing with members who have been waiting for > set amount of time?

    1066. 

  1066. 	if (isset($_POST['time_passed']))

    1067. 

  1067. 	{

    1068. 

  1068. 		$timeBefore = time() - 86400 * (int) $_POST['time_passed'];

    1069. 

  1069. 		$condition = '

    1070. 

  1070. 			AND date_registered < {int:time_before}';

    1071. 

  1071. 	}

    1072. 

  1072. 	// Coming from checkboxes - validate the members passed through to us.

    1073. 

  1073. 	else

    1074. 

  1074. 	{

    1075. 

  1075. 		$members = array();

    1076. 

  1076. 		foreach ($_POST['todoAction'] as $id)

    1077. 

  1077. 			$members[] = (int) $id;

    1078. 

  1078. 		$condition = '

    1079. 

  1079. 			AND id_member IN ({array_int:members})';

    1080. 

  1080. 	}

    1081. 

  1081. 

    1082. 

  1082. 	// Get information on each of the members, things that are important to us, like email address...

    1083. 

  1083. 	$request = $smcFunc['db_query']('', '

    1084. 

  1084. 		SELECT id_member, member_name, real_name, email_address, validation_code, lngfile

    1085. 

  1085. 		FROM {db_prefix}members

    1086. 

  1086. 		WHERE is_activated = {int:activated_status}' . $condition . '

    1087. 

  1087. 		ORDER BY lngfile',

    1088. 

  1088. 		array(

    1089. 

  1089. 			'activated_status' => $current_filter,

    1090. 

  1090. 			'time_before' => empty($timeBefore) ? 0 : $timeBefore,

    1091. 

  1091. 			'members' => empty($members) ? array() : $members,

    1092. 

  1092. 		)

    1093. 

  1093. 	);

    1094. 

  1094. 

    1095. 

  1095. 	$member_count = $smcFunc['db_num_rows']($request);

    1096. 

  1096. 

    1097. 

  1097. 	// If no results then just return!

    1098. 

  1098. 	if ($member_count == 0)

    1099. 

  1099. 		redirectexit('action=admin;area=viewmembers;sa=browse;type=' . $_REQUEST['type'] . ';sort=' . $_REQUEST['sort'] . ';filter=' . $current_filter . ';start=' . $_REQUEST['start']);

    1100. 

  1100. 

    1101. 

  1101. 	$member_info = array();

    1102. 

  1102. 	$members = array();

    1103. 

  1103. 	// Fill the info array.

    1104. 

  1104. 	while ($row = $smcFunc['db_fetch_assoc']($request))

    1105. 

  1105. 	{

    1106. 

  1106. 		$members[] = $row['id_member'];

    1107. 

  1107. 		$member_info[] = array(

    1108. 

  1108. 			'id' => $row['id_member'],

    1109. 

  1109. 			'username' => $row['member_name'],

    1110. 

  1110. 			'name' => $row['real_name'],

    1111. 

  1111. 			'email' => $row['email_address'],

    1112. 

  1112. 			'language' => empty($row['lngfile']) || empty($modSettings['userLanguage']) ? $language : $row['lngfile'],

    1113. 

  1113. 			'code' => $row['validation_code']

    1114. 

  1114. 		);

    1115. 

  1115. 	}

    1116. 

  1116. 	$smcFunc['db_free_result']($request);

    1117. 

  1117. 

    1118. 

  1118. 	// Are we activating or approving the members?

    1119. 

  1119. 	if ($_POST['todo'] == 'ok' || $_POST['todo'] == 'okemail')

    1120. 

  1120. 	{

    1121. 

  1121. 		// Approve/activate this member.

    1122. 

  1122. 		$smcFunc['db_query']('', '

    1123. 

  1123. 			UPDATE {db_prefix}members

    1124. 

  1124. 			SET validation_code = {string:blank_string}, is_activated = {int:is_activated}

    1125. 

  1125. 			WHERE is_activated = {int:activated_status}' . $condition,

    1126. 

  1126. 			array(

    1127. 

  1127. 				'is_activated' => 1,

    1128. 

  1128. 				'time_before' => empty($timeBefore) ? 0 : $timeBefore,

    1129. 

  1129. 				'members' => empty($members) ? array() : $members,

    1130. 

  1130. 				'activated_status' => $current_filter,

    1131. 

  1131. 				'blank_string' => '',

    1132. 

  1132. 			)

    1133. 

  1133. 		);

    1134. 

  1134. 

    1135. 

  1135. 		// Do we have to let the integration code know about the activations?

    1136. 

  1136. 		if (isset($modSettings['integrate_activate']) && function_exists($modSettings['integrate_activate']))

    1137. 

  1137. 		{

    1138. 

  1138. 			foreach ($member_info as $member)

    1139. 

  1139. 				call_user_func($modSettings['integrate_activate'], $member['username']);

    1140. 

  1140. 		}

    1141. 

  1141. 

    1142. 

  1142. 		// Check for email.

    1143. 

  1143. 		if ($_POST['todo'] == 'okemail')

    1144. 

  1144. 		{

    1145. 

  1145. 			foreach ($member_info as $member)

    1146. 

  1146. 			{

    1147. 

  1147. 				$replacements = array(

    1148. 

  1148. 					'NAME' => $member['name'],

    1149. 

  1149. 					'USERNAME' => $member['username'],

    1150. 

  1150. 					'PROFILELINK' => $scripturl . '?action=profile;u=' . $member['id'],

    1151. 

  1151. 					'FORGOTPASSWORDLINK' => $scripturl . '?action=reminder',

    1152. 

  1152. 				);

    1153. 

  1153. 

    1154. 

  1154. 				$emaildata = loadEmailTemplate('admin_approve_accept', $replacements, $member['language']);

    1155. 

  1155. 				sendmail($member['email'], $emaildata['subject'], $emaildata['body'], null, null, false, 0);

    1156. 

  1156. 			}

    1157. 

  1157. 		}

    1158. 

  1158. 	}

    1159. 

  1159. 	// Maybe we're sending it off for activation?

    1160. 

  1160. 	elseif ($_POST['todo'] == 'require_activation')

    1161. 

  1161. 	{

    1162. 

  1162. 		require_once($sourcedir . '/Subs-Members.php');

    1163. 

  1163. 

    1164. 

  1164. 		// We have to do this for each member I'm afraid.

    1165. 

  1165. 		foreach ($member_info as $member)

    1166. 

  1166. 		{

    1167. 

  1167. 			// Generate a random activation code.

    1168. 

  1168. 			$validation_code = generateValidationCode();

    1169. 

  1169. 

    1170. 

  1170. 			// Set these members for activation - I know this includes two id_member checks but it's safer than bodging $condition ;).

    1171. 

  1171. 			$smcFunc['db_query']('', '

    1172. 

  1172. 				UPDATE {db_prefix}members

    1173. 

  1173. 				SET validation_code = {string:validation_code}, is_activated = {int:not_activated}

    1174. 

  1174. 				WHERE is_activated = {int:activated_status}

    1175. 

  1175. 					' . $condition . '

    1176. 

  1176. 					AND id_member = {int:selected_member}',

    1177. 

  1177. 				array(

    1178. 

  1178. 					'not_activated' => 0,

    1179. 

  1179. 					'activated_status' => $current_filter,

    1180. 

  1180. 					'selected_member' => $member['id'],

    1181. 

  1181. 					'validation_code' => $validation_code,

    1182. 

  1182. 					'time_before' => empty($timeBefore) ? 0 : $timeBefore,

    1183. 

  1183. 					'members' => empty($members) ? array() : $members,

    1184. 

  1184. 				)

    1185. 

  1185. 			);

    1186. 

  1186. 

    1187. 

  1187. 			$replacements = array(

    1188. 

  1188. 				'USERNAME' => $member['name'],

    1189. 

  1189. 				'ACTIVATIONLINK' => $scripturl . '?action=activate;u=' . $member['id'] . ';code=' . $validation_code,

    1190. 

  1190. 			);

    1191. 

  1191. 

    1192. 

  1192. 			$emaildata = loadEmailTemplate('admin_approve_activation', $replacements, $member['language']);

    1193. 

  1193. 			sendmail($member['email'], $emaildata['subject'], $emaildata['body'], null, null, false, 0);

    1194. 

  1194. 		}

    1195. 

  1195. 	}

    1196. 

  1196. 	// Are we rejecting them?

    1197. 

  1197. 	elseif ($_POST['todo'] == 'reject' || $_POST['todo'] == 'rejectemail')

    1198. 

  1198. 	{

    1199. 

  1199. 		require_once($sourcedir . '/Subs-Members.php');

    1200. 

  1200. 		deleteMembers($members);

    1201. 

  1201. 

    1202. 

  1202. 		// Send email telling them they aren't welcome?

    1203. 

  1203. 		if ($_POST['todo'] == 'rejectemail')

    1204. 

  1204. 		{

    1205. 

  1205. 			foreach ($member_info as $member)

    1206. 

  1206. 			{

    1207. 

  1207. 				$replacements = array(

    1208. 

  1208. 					'USERNAME' => $member['name'],

    1209. 

  1209. 				);

    1210. 

  1210. 

    1211. 

  1211. 				$emaildata = loadEmailTemplate('admin_approve_reject', $replacements, $member['language']);

    1212. 

  1212. 				sendmail($member['email'], $emaildata['subject'], $emaildata['body'], null, null, false, 1);

    1213. 

  1213. 			}

    1214. 

  1214. 		}

    1215. 

  1215. 	}

    1216. 

  1216. 	// A simple delete?

    1217. 

  1217. 	elseif ($_POST['todo'] == 'delete' || $_POST['todo'] == 'deleteemail')

    1218. 

  1218. 	{

    1219. 

  1219. 		require_once($sourcedir . '/Subs-Members.php');

    1220. 

  1220. 		deleteMembers($members);

    1221. 

  1221. 

    1222. 

  1222. 		// Send email telling them they aren't welcome?

    1223. 

  1223. 		if ($_POST['todo'] == 'deleteemail')

    1224. 

  1224. 		{

    1225. 

  1225. 			foreach ($member_info as $member)

    1226. 

  1226. 			{

    1227. 

  1227. 				$replacements = array(

    1228. 

  1228. 					'USERNAME' => $member['name'],

    1229. 

  1229. 				);

    1230. 

  1230. 

    1231. 

  1231. 				$emaildata = loadEmailTemplate('admin_approve_delete', $replacements, $member['language']);

    1232. 

  1232. 				sendmail($member['email'], $emaildata['subject'], $emaildata['body'], null, null, false, 1);

    1233. 

  1233. 			}

    1234. 

  1234. 		}

    1235. 

  1235. 	}

    1236. 

  1236. 	// Remind them to activate their account?

    1237. 

  1237. 	elseif ($_POST['todo'] == 'remind')

    1238. 

  1238. 	{

    1239. 

  1239. 		foreach ($member_info as $member)

    1240. 

  1240. 		{

    1241. 

  1241. 			$replacements = array(

    1242. 

  1242. 				'USERNAME' => $member['name'],

    1243. 

  1243. 				'ACTIVATIONLINK' => $scripturl . '?action=activate;u=' . $member['id'] . ';code=' . $member['code'],

    1244. 

  1244. 			);

    1245. 

  1245. 

    1246. 

  1246. 			$emaildata = loadEmailTemplate('admin_approve_remind', $replacements, $member['language']);

    1247. 

  1247. 			sendmail($member['email'], $emaildata['subject'], $emaildata['body'], null, null, false, 1);

    1248. 

  1248. 		}

    1249. 

  1249. 	}

    1250. 

  1250. 

    1251. 

  1251. 	// Back to the user's language!

    1252. 

  1252. 	if (isset($current_language) && $current_language != $user_info['language'])

    1253. 

  1253. 	{

    1254. 

  1254. 		loadLanguage('index');

    1255. 

  1255. 		loadLanguage('ManageMembers');

    1256. 

  1256. 	}

    1257. 

  1257. 

    1258. 

  1258. 	// Log what we did?

    1259. 

  1259. 	if (!empty($modSettings['modlog_enabled']) && (substr($_POST['todo'], 0, 2) == 'ok' || $_POST['todo'] == 'remind'))

    1260. 

  1260. 	{

    1261. 

  1261. 		$log_action = $_POST['todo'] == 'remind' ? 'remind_member' : 'approve_member';

    1262. 

  1262. 		$log_inserts = array();

    1263. 

  1263. 		foreach ($member_info as $member)

    1264. 

  1264. 		{

    1265. 

  1265. 			$log_inserts[] = array(

    1266. 

  1266. 				time(), 3, $user_info['id'], $user_info['ip'], $log_action,

    1267. 

  1267. 				0, 0, 0, serialize(array('member' => $member['id'])),

    1268. 

  1268. 			);

    1269. 

  1269. 		}

    1270. 

  1270. 		$smcFunc['db_insert']('',

    1271. 

  1271. 			'{db_prefix}log_actions',

    1272. 

  1272. 			array(

    1273. 

  1273. 				'log_time' => 'int', 'id_log' => 'int', 'id_member' => 'int', 'ip' => 'string-16', 'action' => 'string',

    1274. 

  1274. 				'id_board' => 'int', 'id_topic' => 'int', 'id_msg' => 'int', 'extra' => 'string-65534',

    1275. 

  1275. 			),

    1276. 

  1276. 			$log_inserts,

    1277. 

  1277. 			array('id_action')

    1278. 

  1278. 		);

    1279. 

  1279. 	}

    1280. 

  1280. 

    1281. 

  1281. 	// Although updateStats *may* catch this, best to do it manually just in case (Doesn't always sort out unapprovedMembers).

    1282. 

  1282. 	if (in_array($current_filter, array(3, 4)))

    1283. 

  1283. 		updateSettings(array('unapprovedMembers' => ($modSettings['unapprovedMembers'] > $member_count ? $modSettings['unapprovedMembers'] - $member_count : 0)));

    1284. 

  1284. 

    1285. 

  1285. 	// Update the member's stats. (but, we know the member didn't change their name.)

    1286. 

  1286. 	updateStats('member', false);

    1287. 

  1287. 

    1288. 

  1288. 	// If they haven't been deleted, update the post group statistics on them...

    1289. 

  1289. 	if (!in_array($_POST['todo'], array('delete', 'deleteemail', 'reject', 'rejectemail', 'remind')))

    1290. 

  1290. 		updateStats('postgroups', $members);

    1291. 

  1291. 

    1292. 

  1292. 	redirectexit('action=admin;area=viewmembers;sa=browse;type=' . $_REQUEST['type'] . ';sort=' . $_REQUEST['sort'] . ';filter=' . $current_filter . ';start=' . $_REQUEST['start']);

    1293. 

  1293. }

    1294. 

  1294. 

    1295. 

  1295. function jeffsdatediff($old)

    1296. 

  1296. {

    1297. 

  1297. 	// Get the current time as the user would see it...

    1298. 

  1298. 	$forumTime = forum_time();

    1299. 

  1299. 

    1300. 

  1300. 	// Calculate the seconds that have passed since midnight.

    1301. 

  1301. 	$sinceMidnight = date('H', $forumTime) * 60 * 60 + date('i', $forumTime) * 60 + date('s', $forumTime);

    1302. 

  1302. 

    1303. 

  1303. 	// Take the difference between the two times.

    1304. 

  1304. 	$dis = time() - $old;

    1305. 

  1305. 

    1306. 

  1306. 	// Before midnight?

    1307. 

  1307. 	if ($dis < $sinceMidnight)

    1308. 

  1308. 		return 0;

    1309. 

  1309. 	else

    1310. 

  1310. 		$dis -= $sinceMidnight;

    1311. 

  1311. 

    1312. 

  1312. 	// Divide out the seconds in a day to get the number of days.

    1313. 

  1313. 	return ceil($dis / (24 * 60 * 60));

    1314. 

  1314. }

    1315. 

  1315. 

    1316. 

  1316. ?>
    1317.