Diff | Subversion & Trac

Download diff

 $no_page_header = false;
 require('./pagestart.' . PHP_EXT);
 include_once(IP_ROOT_PATH . 'includes/functions_profile.' . PHP_EXT);
+$db->clear_cache('profile_fields_');
 if(!isset($_GET['mode']) || !isset($_GET['pfid']))
 {
 		'L_ADD_FIELD_TITLE' => $lang['add_field_title'],
 		'L_ADD_FIELD_EXPLAIN' => $lang['add_field_explain'],
-		'S_ADD_FIELD_ACTION' => append_sid("$filename?mode=update&pfid=x")
+		'S_ADD_FIELD_ACTION' => append_sid($filename . '?mode=update&amp;pfid=x')
-		));
+		)
+	);
 }
 elseif($mode == 'update')
 {
 	$name = htmlspecialchars($_POST['field_name']);
 	if(empty($name))
+	{
 		message_die(GENERAL_ERROR,$lang['enter_a_name']);
+	}
 	$description = htmlspecialchars($_POST['field_descrition']);
 	$radio_default_value = htmlspecialchars($_POST['radio_default_value']);
 	$radio_values = explode("\n",str_replace("\r",'',$radio_values));
 	if(empty($radio_default_value))
+	{
 		$radio_default_value = $radio_values[0];
+	}
 	$temp = '';
 	foreach($radio_values as $val)
+	{
 		$temp .= $val . ',';
+	}
 	$radio_values = substr($temp,0,strlen($temp)-1);
 	$checkbox_values = htmlspecialchars($_POST['checkbox_values']);
 		$check_default_values = explode("\n",str_replace("\r",'',$check_default_values));
 		$temp = '';
 		foreach($check_default_values as $val)
+		{
 			$temp .= $val . ',';
+		}
 		$check_default_values = substr($temp,0,strlen($temp)-1);
 	}
 	$temp = '';
 	foreach($checkbox_values as $val)
+	{
 		$temp .= $val . ',';
+	}
 	$checkbox_values = substr($temp,0,strlen($temp)-1);
 	$required = intval($_POST['required']);
 		$sql = "SELECT field_name FROM " . PROFILE_FIELDS_TABLE . "
 			WHERE field_name='$name'";
 		if(!($result = $db->sql_query($sql)))
+		{
 			message_die(GENERAL_ERROR,'Could not query database for field name information','',__LINE__,__FILE__,$sql);
+		}
 		$temp = $db->sql_fetchrowset($result);
 		if(!empty($temp))
+		{
 			message_die(GENERAL_ERROR,$lang['field_exists']);
 	}
+	}
 	if($pfid == 'x')
+	{
 		$die_message = 'Could not insert new profile field';
+	}
 	else
+	{
 		$die_message = 'Could not update profile information';
+	}
 	if($pfid != 'x')
 	{
 		$sql = "SELECT field_name FROM " . PROFILE_FIELDS_TABLE . "
 			WHERE field_id = $pfid";
 		if(!($result = $db->sql_query($sql)))
+		{
 			message_die(GENERAL_ERROR,'Could not find old name','',__LINE__,__FILE__,$sql);
+		}
 		$old_name = $db->sql_fetchrow($result);
 		$old_name = text_to_column($old_name['field_name']);
 	}
 	}
 	if(!$db->sql_query($sql))
+	{
 		message_die(GENERAL_ERROR, $die_message, '', __LINE__, __FILE__, $sql);
+	}
 	if($pfid != 'x')
 	{
 		}
 	}
-	$sql = "ALTER TABLE " . USERS_TABLE . "
+	$sql = "ALTER TABLE " . USERS_TABLE . " ADD $name";
-		ADD $name";
 	switch($type)
 	{
 		case TEXT_FIELD:
 	}
 	if($pfid == 'x' && !$db->sql_query($sql))
+	{
 		message_die(GENERAL_ERROR,'Could not expand users table for new profile field.','',__LINE__,__FILE__,$sql);
+	}
 	$sql = "SELECT user_id FROM " . USERS_TABLE;
 	if(!($result = $db->sql_query($sql)))
+	{
 		message_die(GENERAL_ERROR,'Could not retrieve use and profile information','',__LINE__,__FILE__,$sql);
+	}
 	$user_id_array = array();
-	while($temp = $db->sql_fetchrow($result))$user_id_array[] = $temp['user_id'];
+	while($temp = $db->sql_fetchrow($result))
+	{
+		$user_id_array[] = $temp['user_id'];
+	}
 	if($pfid == 'x')
+	{
 		foreach($user_id_array as $user_id)
 		{
 			$sql = "UPDATE " . USERS_TABLE . "
 			$sql = sprintf($sql,"'$val'");
 			if(!$db->sql_query($sql))
+			{
 				message_die(GENERAL_ERROR,'Could not update users with default values','',__LINE__,__FILE__,$sql);
 		}
+		}
+	}
 	$template->assign_vars(array(
 		'MESSAGE_TITLE' => $pfid == 'x' ? $lang['profile_field_created'] : $lang['profile_field_updated'],
-		'MESSAGE_TEXT' => $lang['field_success'] . '<br /><br />' . $create_second_field_link));
+		'MESSAGE_TEXT' => $lang['field_success'] . '<br /><br />' . $create_second_field_link
+		)
+	);
 }
 elseif($mode == 'edit')
 {
 			'L_ACTION' => $lang['profile_field_action'],
 			'L_EDIT' => $lang['Edit'],
 			'L_DELETE' => $lang['Delete']
-			));
+			)
+		);
 		$profile_rows = get_fields();
 		if(count($profile_rows) == 0)
+		{
 			$template->assign_block_vars('switch_no_fields',array('NO_FIELDS_EXIST' => $lang['no_profile_fields_exist']));
+		}
 		else
 		{
 			$template->assign_block_vars('switch_fields',array());
 				$id = $val['field_id'];
 				$name = $val['field_name'];
-				$edit_url = append_sid("$filename?mode=edit&pfid=$id");
+				$edit_url = append_sid($filename . '?mode=edit&amp;pfid=' . $id);
-				$delete_url = append_sid("$filename?mode=delete&pfid=$id");
+				$delete_url = append_sid($filename . '?mode=delete&amp;pfid=' . $id);
 				$template->assign_block_vars('switch_fields.profile_fields',array(
 					'ROW_CLASS' => $row,
 					'U_PROFILE_FIELD_EDIT' => $edit_url,
 					'U_PROFILE_FIELD_DELETE' => $delete_url
-					));
+					)
+				);
 			}
 		}
 	}
 			'L_ADD_FIELD_TITLE' => $lang['edit_field_title'],
 			'L_ADD_FIELD_EXPLAIN' => $lang['edit_field_explain'],
-			'S_ADD_FIELD_ACTION' => append_sid("$filename?mode=update&pfid=$pfid")
+			'S_ADD_FIELD_ACTION' => append_sid($filename . '?mode=update&amp;pfid=' . $pfid)
-			));
+			)
+		);
 	}
 }
 elseif($mode == 'delete')
 	$field_name = get_fields('WHERE field_id = '.$pfid,false,'field_name');
 	$name = text_to_column($field_name['field_name']);
-	$del_link = '<a href="' . append_sid("$filename?mode=confirmdelete&pfid=$pfid&name=$name") . '">' . $lang['Yes'] . '</a>';
+	$del_link = '<a href="' . append_sid($filename . '?mode=confirmdelete&amp;pfid=' . $pfid . '&amp;name=' . $name) . '">' . $lang['Yes'] . '</a>';
 	$nodel_link = sprintf($lang['index_link'],$lang['No']);
 	$template->set_filenames(array('body' => ADM_TPL . 'admin_message_body.tpl'));
 	$template->assign_vars(array(
 		'MESSAGE_TITLE' => sprintf($lang['double_check_delete'],$field_name['field_name']),
 		'MESSAGE_TEXT' => $del_link . ' &nbsp; ' . $nodel_link
-		));
+		)
+	);
 }
 elseif($mode == 'confirmdelete')
 {
 	$sql = "DELETE FROM " . PROFILE_FIELDS_TABLE . "
 		WHERE field_id = $pfid";
 	if(!$db->sql_query($sql))
+	{
 		message_die(GENERAL_ERROR,'Could not delete profile form database','',__LINE__,__FILE__,$sql);
+	}
 	$name = $_GET['name'];
 	$sql = "ALTER TABLE " . USERS_TABLE . "
 		DROP COLUMN $name";
 	if(!$db->sql_query($sql))
+	{
 		message_die(GENERAL_ERROR,'Could not remove column from '.USERS_TABLE,'',__LINE__,__FILE__,$sql);
+	}
 	$template->set_filenames(array('body' => ADM_TPL . 'admin_message_body.tpl'));
 	$template->assign_vars(array(
 		'MESSAGE_TITLE' => $lang['field_deleted'],
 		'MESSAGE_TEXT' => $lang['click_here_here']
-		));
+		)
+	);
 }
 $template->assign_vars(array(
 	'S_AUTHOR' => AUTHOR,
 	'S_ABOVE_SIGNATURE' => ABOVE_SIGNATURE,
 	'S_BELOW_SIGNATURE' => BELOW_SIGNATURE
-	));
+	)
+);
 $template->pparse('body');
+$db->clear_cache('profile_fields_');
 include('./page_footer_admin.' . PHP_EXT);
 ?>

Icy Phoenix

root/ip/tags/release_1_3_0_53/adm/admin_profile_fields.php