~azzar1/unity/add-show-desktop-key : contents of www/php/phpBB3/includes/ucp/ucp

~azzar1/unity/add-show-desktop-key : (revision 1067)

<?php
/**
*
* @package ucp
* @version $Id: ucp_zebra.php,v 1.44 2007/10/05 14:36:34 acydburn Exp $
* @copyright (c) 2005 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
	exit;
}

/**
* ucp_zebra
* @package ucp
*/
class ucp_zebra
{
	var $u_action;

	function main($id, $mode)
	{
		global $config, $db, $user, $auth, $template, $phpbb_root_path, $phpEx;

		$submit	= (isset($_POST['submit']) || isset($_GET['add']) || isset($_GET['remove'])) ? true : false;
		$s_hidden_fields = '';

		$l_mode = strtoupper($mode);

		if ($submit)
		{
			$data = $error = array();
			$updated = false;

			$var_ary = array(
				'usernames'	=> array(0),
				'add'		=> '',
			);

			foreach ($var_ary as $var => $default)
			{
				$data[$var] = request_var($var, $default, true);
			}

			if (!empty($data['add']) || sizeof($data['usernames']))
			{
				if (confirm_box(true))
				{
					if ($data['add'])
					{
						$data['add'] = array_map('trim', array_map('utf8_clean_string', explode("\n", $data['add'])));

						// Do these name/s exist on a list already? If so, ignore ... we could be
						// 'nice' and automatically handle names added to one list present on
						// the other (by removing the existing one) ... but I have a feeling this
						// may lead to complaints
						$sql = 'SELECT z.*, u.username, u.username_clean
							FROM ' . ZEBRA_TABLE . ' z, ' . USERS_TABLE . ' u
							WHERE z.user_id = ' . $user->data['user_id'] . '
								AND u.user_id = z.zebra_id';
						$result = $db->sql_query($sql);

						$friends = $foes = array();
						while ($row = $db->sql_fetchrow($result))
						{
							if ($row['friend'])
							{
								$friends[] = utf8_clean_string($row['username']);
							}
							else
							{
								$foes[] = utf8_clean_string($row['username']);
							}
						}
						$db->sql_freeresult($result);

						// remove friends from the username array
						$n = sizeof($data['add']);
						$data['add'] = array_diff($data['add'], $friends);

						if (sizeof($data['add']) < $n && $mode == 'foes')
						{
							$error[] = $user->lang['NOT_ADDED_FOES_FRIENDS'];
						}

						// remove foes from the username array
						$n = sizeof($data['add']);
						$data['add'] = array_diff($data['add'], $foes);

						if (sizeof($data['add']) < $n && $mode == 'friends')
						{
							$error[] = $user->lang['NOT_ADDED_FRIENDS_FOES'];
						}

						// remove the user himself from the username array
						$n = sizeof($data['add']);
						$data['add'] = array_diff($data['add'], array(utf8_clean_string($user->data['username'])));

						if (sizeof($data['add']) < $n)
						{
							$error[] = $user->lang['NOT_ADDED_' . $l_mode . '_SELF'];
						}

						unset($friends, $foes, $n);

						if (sizeof($data['add']))
						{
							$sql = 'SELECT user_id, user_type
								FROM ' . USERS_TABLE . '
								WHERE ' . $db->sql_in_set('username_clean', $data['add']) . '
									AND user_type <> ' . USER_INACTIVE;
							$result = $db->sql_query($sql);

							$user_id_ary = array();
							while ($row = $db->sql_fetchrow($result))
							{
								if ($row['user_id'] != ANONYMOUS && $row['user_type'] != USER_IGNORE)
								{
									$user_id_ary[] = $row['user_id'];
								}
								else
								{
									$error[] = $user->lang['NOT_ADDED_' . $l_mode . '_ANONYMOUS'];
								}
							}
							$db->sql_freeresult($result);

							if (sizeof($user_id_ary))
							{
								// Remove users from foe list if they are admins or moderators
								if ($mode == 'foes')
								{
									$perms = array();
									foreach ($auth->acl_get_list($user_id_ary, array('a_', 'm_')) as $forum_id => $forum_ary)
									{
										foreach ($forum_ary as $auth_option => $user_ary)
										{
											$perms = array_merge($perms, $user_ary);
										}
									}

									$perms = array_unique($perms);

									if (sizeof($perms))
									{
										$error[] = $user->lang['NOT_ADDED_FOES_MOD_ADMIN'];
									}

									// This may not be right ... it may yield true when perms equate to deny
									$user_id_ary = array_diff($user_id_ary, $perms);
									unset($perms);
								}

								if (sizeof($user_id_ary))
								{
									$sql_mode = ($mode == 'friends') ? 'friend' : 'foe';

									$sql_ary = array();
									foreach ($user_id_ary as $zebra_id)
									{
										$sql_ary[] = array(
											'user_id'		=> (int) $user->data['user_id'],
											'zebra_id'		=> (int) $zebra_id,
											$sql_mode		=> 1
										);
									}

									$db->sql_multi_insert(ZEBRA_TABLE, $sql_ary);

									$updated = true;
								}
								unset($user_id_ary);
							}
							else if (!sizeof($error))
							{
								$error[] = $user->lang['USER_NOT_FOUND_OR_INACTIVE'];
							}
						}
					}
					else if (sizeof($data['usernames']))
					{
						// Force integer values
						$data['usernames'] = array_map('intval', $data['usernames']);

						$sql = 'DELETE FROM ' . ZEBRA_TABLE . '
							WHERE user_id = ' . $user->data['user_id'] . '
								AND ' . $db->sql_in_set('zebra_id', $data['usernames']);
						$db->sql_query($sql);

						$updated = true;
					}

					if ($updated)
					{
						meta_refresh(3, $this->u_action);
						$message = $user->lang[$l_mode . '_UPDATED'] . '<br />' . implode('<br />', $error) . ((sizeof($error)) ? '<br />' : '') . '<br />' . sprintf($user->lang['RETURN_UCP'], '<a href="' . $this->u_action . '">', '</a>');
						trigger_error($message);
					}
					else
					{
						$template->assign_var('ERROR', implode('<br />', $error));
					}
				}
				else
				{
					confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(
						'mode'		=> $mode,
						'submit'	=> true,
						'usernames'	=> $data['usernames'],
						'add'		=> $data['add']))
					);
				}
			}
		}

		$sql_and = ($mode == 'friends') ? 'z.friend = 1' : 'z.foe = 1';
		$sql = 'SELECT z.*, u.username, u.username_clean
			FROM ' . ZEBRA_TABLE . ' z, ' . USERS_TABLE . ' u
			WHERE z.user_id = ' . $user->data['user_id'] . "
				AND $sql_and
				AND u.user_id = z.zebra_id
			ORDER BY u.username_clean ASC";
		$result = $db->sql_query($sql);

		$s_username_options = '';
		while ($row = $db->sql_fetchrow($result))
		{
			$s_username_options .= '<option value="' . $row['zebra_id'] . '">' . $row['username'] . '</option>';
		}
		$db->sql_freeresult($result);

		$template->assign_vars(array(
			'L_TITLE'			=> $user->lang['UCP_ZEBRA_' . $l_mode],

			'U_FIND_USERNAME'	=> append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&amp;form=ucp&amp;field=add'),

			'S_USERNAME_OPTIONS'	=> $s_username_options,
			'S_HIDDEN_FIELDS'		=> $s_hidden_fields,
			'S_UCP_ACTION'			=> $this->u_action)
		);

		$this->tpl_name = 'ucp_zebra_' . $mode;
		$this->page_title = 'UCP_ZEBRA_' . $l_mode;
	}
}

?>

443 by dcoles Added Forum application along with unmodifed version of phpBB3 "Olympus" 3.0.0	1	<?php
	2	/**
	3	*
	4	* @package ucp
	5	* @version $Id: ucp_zebra.php,v 1.44 2007/10/05 14:36:34 acydburn Exp $
	6	* @copyright (c) 2005 phpBB Group
	7	* @license http://opensource.org/licenses/gpl-license.php GNU Public License
	8	*
	9	*/
	10
	11	/**
	12	* @ignore
	13	*/
	14	if (!defined('IN_PHPBB'))
	15	{
	16	exit;
	17	}
	18
	19	/**
	20	* ucp_zebra
	21	* @package ucp
	22	*/
	23	class ucp_zebra
	24	{
	25	var $u_action;
	26
	27	function main($id, $mode)
	28	{
	29	global $config, $db, $user, $auth, $template, $phpbb_root_path, $phpEx;
	30
	31	$submit = (isset($_POST['submit']) \|\| isset($_GET['add']) \|\| isset($_GET['remove'])) ? true : false;
	32	$s_hidden_fields = '';
	33
	34	$l_mode = strtoupper($mode);
	35
	36	if ($submit)
	37	{
	38	$data = $error = array();
	39	$updated = false;
	40
	41	$var_ary = array(
	42	'usernames' => array(0),
	43	'add' => '',
	44	);
	45
	46	foreach ($var_ary as $var => $default)
	47	{
	48	$data[$var] = request_var($var, $default, true);
	49	}
	50
	51	if (!empty($data['add']) \|\| sizeof($data['usernames']))
	52	{
	53	if (confirm_box(true))
	54	{
	55	if ($data['add'])
	56	{
	57	$data['add'] = array_map('trim', array_map('utf8_clean_string', explode("\n", $data['add'])));
	58
	59	// Do these name/s exist on a list already? If so, ignore ... we could be
	60	// 'nice' and automatically handle names added to one list present on
	61	// the other (by removing the existing one) ... but I have a feeling this
	62	// may lead to complaints
	63	$sql = 'SELECT z.*, u.username, u.username_clean
	64	FROM ' . ZEBRA_TABLE . ' z, ' . USERS_TABLE . ' u
65	WHERE z.user_id = ' . $user->data['user_id'] . '
66	AND u.user_id = z.zebra_id';
67	$result = $db->sql_query($sql);
68
69	$friends = $foes = array();
70	while ($row = $db->sql_fetchrow($result))
71	{
72	if ($row['friend'])
73	{
74	$friends[] = utf8_clean_string($row['username']);
75	}
76	else
77	{
78	$foes[] = utf8_clean_string($row['username']);
79	}
80	}
81	$db->sql_freeresult($result);
82
83	// remove friends from the username array
84	$n = sizeof($data['add']);
85	$data['add'] = array_diff($data['add'], $friends);
86
87	if (sizeof($data['add']) < $n && $mode == 'foes')
88	{
89	$error[] = $user->lang['NOT_ADDED_FOES_FRIENDS'];
90	}
91
92	// remove foes from the username array
93	$n = sizeof($data['add']);
94	$data['add'] = array_diff($data['add'], $foes);
95
96	if (sizeof($data['add']) < $n && $mode == 'friends')
97	{
98	$error[] = $user->lang['NOT_ADDED_FRIENDS_FOES'];
99	}
100
101	// remove the user himself from the username array
102	$n = sizeof($data['add']);
103	$data['add'] = array_diff($data['add'], array(utf8_clean_string($user->data['username'])));
104
105	if (sizeof($data['add']) < $n)
106	{
107	$error[] = $user->lang['NOT_ADDED_' . $l_mode . '_SELF'];
108	}
109
110	unset($friends, $foes, $n);
111
112	if (sizeof($data['add']))
113	{
114	$sql = 'SELECT user_id, user_type
115	FROM ' . USERS_TABLE . '
116	WHERE ' . $db->sql_in_set('username_clean', $data['add']) . '
117	AND user_type <> ' . USER_INACTIVE;
118	$result = $db->sql_query($sql);
119
120	$user_id_ary = array();
121	while ($row = $db->sql_fetchrow($result))
122	{
123	if ($row['user_id'] != ANONYMOUS && $row['user_type'] != USER_IGNORE)
124	{
125	$user_id_ary[] = $row['user_id'];
126	}
127	else
128	{
129	$error[] = $user->lang['NOT_ADDED_' . $l_mode . '_ANONYMOUS'];
130	}
131	}
132	$db->sql_freeresult($result);
133
134	if (sizeof($user_id_ary))
135	{
136	// Remove users from foe list if they are admins or moderators
137	if ($mode == 'foes')
138	{
139	$perms = array();
140	foreach ($auth->acl_get_list($user_id_ary, array('a_', 'm_')) as $forum_id => $forum_ary)
141	{
142	foreach ($forum_ary as $auth_option => $user_ary)
143	{
144	$perms = array_merge($perms, $user_ary);
145	}
146	}
147
148	$perms = array_unique($perms);
149
150	if (sizeof($perms))
151	{
152	$error[] = $user->lang['NOT_ADDED_FOES_MOD_ADMIN'];
153	}
154
155	// This may not be right ... it may yield true when perms equate to deny
156	$user_id_ary = array_diff($user_id_ary, $perms);
157	unset($perms);
158	}
159
160	if (sizeof($user_id_ary))
161	{
162	$sql_mode = ($mode == 'friends') ? 'friend' : 'foe';
163
164	$sql_ary = array();
165	foreach ($user_id_ary as $zebra_id)
166	{
167	$sql_ary[] = array(
168	'user_id' => (int) $user->data['user_id'],
169	'zebra_id' => (int) $zebra_id,
170	$sql_mode => 1
171	);
172	}
173
174	$db->sql_multi_insert(ZEBRA_TABLE, $sql_ary);
175
176	$updated = true;
177	}
178	unset($user_id_ary);
179	}
180	else if (!sizeof($error))
181	{
182	$error[] = $user->lang['USER_NOT_FOUND_OR_INACTIVE'];
183	}
184	}
185	}
186	else if (sizeof($data['usernames']))
187	{
188	// Force integer values
189	$data['usernames'] = array_map('intval', $data['usernames']);
190
191	$sql = 'DELETE FROM ' . ZEBRA_TABLE . '
192	WHERE user_id = ' . $user->data['user_id'] . '
193	AND ' . $db->sql_in_set('zebra_id', $data['usernames']);
194	$db->sql_query($sql);
195
196	$updated = true;
197	}
198
199	if ($updated)
200	{
201	meta_refresh(3, $this->u_action);
202	$message = $user->lang[$l_mode . '_UPDATED'] . '<br />' . implode('<br />', $error) . ((sizeof($error)) ? '<br />' : '') . '<br />' . sprintf($user->lang['RETURN_UCP'], '<a href="' . $this->u_action . '">', '</a>');
203	trigger_error($message);
204	}
205	else
206	{
207	$template->assign_var('ERROR', implode('<br />', $error));
208	}
209	}
210	else
211	{
212	confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(
213	'mode' => $mode,
214	'submit' => true,
215	'usernames' => $data['usernames'],
216	'add' => $data['add']))
217	);
218	}
219	}
220	}
221
222	$sql_and = ($mode == 'friends') ? 'z.friend = 1' : 'z.foe = 1';
223	$sql = 'SELECT z.*, u.username, u.username_clean
224	FROM ' . ZEBRA_TABLE . ' z, ' . USERS_TABLE . ' u
225	WHERE z.user_id = ' . $user->data['user_id'] . "
226	AND $sql_and
227	AND u.user_id = z.zebra_id
228	ORDER BY u.username_clean ASC";
229	$result = $db->sql_query($sql);
230
231	$s_username_options = '';
232	while ($row = $db->sql_fetchrow($result))
233	{
234	$s_username_options .= '<option value="' . $row['zebra_id'] . '">' . $row['username'] . '</option>';
235	}
236	$db->sql_freeresult($result);
237
238	$template->assign_vars(array(
239	'L_TITLE' => $user->lang['UCP_ZEBRA_' . $l_mode],
240
241	'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&form=ucp&field=add'),
242
243	'S_USERNAME_OPTIONS' => $s_username_options,
244	'S_HIDDEN_FIELDS' => $s_hidden_fields,
245	'S_UCP_ACTION' => $this->u_action)
246	);
247
248	$this->tpl_name = 'ucp_zebra_' . $mode;
249	$this->page_title = 'UCP_ZEBRA_' . $l_mode;
250	}
251	}
252
253	?>