1 files changed, 1 insertions, 65 deletions
diff --git a/phpBB/includes/ucp/ucp_profile.php b/phpBB/includes/ucp/ucp_profile.php
index 6a557bc264..52f17a8048 100644
--- a/phpBB/includes/ucp/ucp_profile.php
+++ b/phpBB/includes/ucp/ucp_profile.php
@@ -440,72 +440,8 @@ class ucp_profile
 								'user_sig_bbcode_bitfield'	=> $message_parser->bbcode_bitfield
 							);
 
-							$query = '';
-
-							switch (SQL_LAYER)
-							{
-								case 'mssql':
-								case 'mssql_odbc':
-									$values = array();
-									foreach ($sql_ary as $key => $var)
-									{
-										if (is_null($var))
-										{
-											$values[] = "$key = NULL";
-										}
-										else if (is_string($var))
-										{
-											if ($key !== 'user_sig_bbcode_bitfield')
-											{
-												$values[] = "$key = '" . $db->sql_escape($var) . "'";
-											}
-											else
-											{
-												$values[] = "$key = CAST('" . $var . "' AS varbinary)";
-											}
-										}
-										else
-										{
-											$values[] = (is_bool($var)) ? "$key = " . intval($var) : "$key = $var";
-										}
-									}
-									$query = implode(', ', $values);
-								break;
-
-								case 'sqlite':
-									$values = array();
-									foreach ($sql_ary as $key => $var)
-									{
-										if (is_null($var))
-										{
-											$values[] = "$key = NULL";
-										}
-										else if (is_string($var))
-										{
-											if ($key !== 'user_sig_bbcode_bitfield')
-											{
-												$values[] = "$key = '" . $db->sql_escape($var) . "'";
-											}
-											else
-											{
-												$values[] = "$key = '" . sqlite_udf_encode_binary($var) . "'";
-											}
-										}
-										else
-										{
-											$values[] = (is_bool($var)) ? "$key = " . intval($var) : "$key = $var";
-										}
-									}
-									$query = implode(', ', $values);
-								break;
-
-								default:
-									$query = $db->sql_build_array('UPDATE', $sql_ary);
-								break;
-							}
-
 							$sql = 'UPDATE ' . USERS_TABLE . ' 
-								SET ' . $query . ' 
+								SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' 
 								WHERE user_id = ' . $user->data['user_id'];
 							$db->sql_query($sql);