diff options
| author | David King <imkingdavid@gmail.com> | 2013-06-23 19:47:13 -0400 |
|---|---|---|
| committer | David King <imkingdavid@gmail.com> | 2013-06-23 19:47:13 -0400 |
| commit | fc99c862521c8a01c076bcd062513a33f9a36fa4 (patch) | |
| tree | 6cb219685247c23d9f49ed7ba8d299b6459dc544 /phpBB/includes/db | |
| parent | 8d86f88ac6f7dc5370c043ed3b89659b0c68dd69 (diff) | |
| download | forums-fc99c862521c8a01c076bcd062513a33f9a36fa4.tar forums-fc99c862521c8a01c076bcd062513a33f9a36fa4.tar.gz forums-fc99c862521c8a01c076bcd062513a33f9a36fa4.tar.bz2 forums-fc99c862521c8a01c076bcd062513a33f9a36fa4.tar.xz forums-fc99c862521c8a01c076bcd062513a33f9a36fa4.zip | |
[ticket/11253] Put AND clause in correct SQL query
PHPBB3-11253
Diffstat (limited to 'phpBB/includes/db')
| -rw-r--r-- | phpBB/includes/db/migration/data/310/signature_module_auth.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/includes/db/migration/data/310/signature_module_auth.php b/phpBB/includes/db/migration/data/310/signature_module_auth.php index 1e6c6cc1dc..e4fbb27bcb 100644 --- a/phpBB/includes/db/migration/data/310/signature_module_auth.php +++ b/phpBB/includes/db/migration/data/310/signature_module_auth.php @@ -15,8 +15,7 @@ class phpbb_db_migration_data_310_signature_module_auth extends phpbb_db_migrati FROM ' . MODULES_TABLE . " WHERE module_class = 'ucp' AND module_basename = 'ucp_profile' - AND module_mode = 'signature' - AND module_auth = ''"; + AND module_mode = 'signature'"; $result = $this->db->sql_query($sql); $module_auth = $this->db_sql_fetchfield('module_auth'); $this->db->sql_freeresult($result); @@ -45,7 +44,8 @@ class phpbb_db_migration_data_310_signature_module_auth extends phpbb_db_migrati SET module_auth = 'acl_u_sig' WHERE module_class = 'ucp' AND module_basename = 'ucp_profile' - AND module_mode = 'signature'"; + AND module_mode = 'signature' + AND module_auth = ''"; $this->db->sql_query($sql); } } |