diff options
| author | David M <davidmj@users.sourceforge.net> | 2008-01-07 15:19:38 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2008-01-07 15:19:38 +0000 |
| commit | 2928574ed46334bb8dbbb6612a62db3c3654ba12 (patch) | |
| tree | c010569c70e52dbda45dd835a613977fb30f9dc8 /phpBB/includes/acp/acp_profile.php | |
| parent | 159ce6f8d1bddbe7afc055f70cab3107b9c74a5f (diff) | |
| download | forums-2928574ed46334bb8dbbb6612a62db3c3654ba12.tar forums-2928574ed46334bb8dbbb6612a62db3c3654ba12.tar.gz forums-2928574ed46334bb8dbbb6612a62db3c3654ba12.tar.bz2 forums-2928574ed46334bb8dbbb6612a62db3c3654ba12.tar.xz forums-2928574ed46334bb8dbbb6612a62db3c3654ba12.zip | |
- a few tiny clean ups
- a new MS SQL DBAL, it does not work so hot because of issues with the extension it depends on
git-svn-id: file:///svn/phpbb/trunk@8313 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/acp/acp_profile.php')
| -rw-r--r-- | phpBB/includes/acp/acp_profile.php | 13 |
1 files changed, 5 insertions, 8 deletions
diff --git a/phpBB/includes/acp/acp_profile.php b/phpBB/includes/acp/acp_profile.php index bd7d58717b..253308d153 100644 --- a/phpBB/includes/acp/acp_profile.php +++ b/phpBB/includes/acp/acp_profile.php @@ -120,9 +120,8 @@ class acp_profile $db->sql_query('DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . " WHERE field_id = $field_id"); $db->sql_query('DELETE FROM ' . PROFILE_LANG_TABLE . " WHERE field_id = $field_id"); - switch ($db->sql_layer) + if ($db->dbms_type == 'sqlite') { - case 'sqlite': $sql = "SELECT sql FROM sqlite_master WHERE type = 'table' @@ -166,9 +165,9 @@ class acp_profile $db->sql_query('CREATE TABLE ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $new_table_cols . ');'); $db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . PROFILE_FIELDS_DATA_TABLE . '_temp;'); $db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp'); - break; - - default: + } + else + { $db->sql_query('ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " DROP COLUMN pf_$field_ident"); } @@ -1348,10 +1347,9 @@ class acp_profile { global $db; - switch ($db->sql_layer) + switch ($db->dbms_type) { case 'mysql': - case 'mysqli': // We are defining the biggest common value, because of the possibility to edit the min/max values of each field. $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD `$field_ident` "; @@ -1468,7 +1466,6 @@ class acp_profile break; case 'mssql': - case 'mssql_odbc': // We are defining the biggest common value, because of the possibility to edit the min/max values of each field. $sql = 'ALTER TABLE [' . PROFILE_FIELDS_DATA_TABLE . "] ADD [$field_ident] "; |