diff options
| author | Nathan Guse <nathaniel.guse@gmail.com> | 2013-07-06 11:15:04 -0500 |
|---|---|---|
| committer | Nathan Guse <nathaniel.guse@gmail.com> | 2013-07-06 11:15:04 -0500 |
| commit | 2d7a91ebd630d6b9316f05cd8c153cd9dde5c3c9 (patch) | |
| tree | 33a34f004d66c260da679c32b58281e8de2233dd | |
| parent | e03586f2cff2317efc30d8d5c39d6299ecad90bb (diff) | |
| parent | fc99c862521c8a01c076bcd062513a33f9a36fa4 (diff) | |
| download | forums-2d7a91ebd630d6b9316f05cd8c153cd9dde5c3c9.tar forums-2d7a91ebd630d6b9316f05cd8c153cd9dde5c3c9.tar.gz forums-2d7a91ebd630d6b9316f05cd8c153cd9dde5c3c9.tar.bz2 forums-2d7a91ebd630d6b9316f05cd8c153cd9dde5c3c9.tar.xz forums-2d7a91ebd630d6b9316f05cd8c153cd9dde5c3c9.zip | |
Merge remote-tracking branch 'remotes/imkingdavid/ticket/11253' into develop
# By David King
# Via David King
* remotes/imkingdavid/ticket/11253:
[ticket/11253] Put AND clause in correct SQL query
[ticket/11253] Fix a few things brought up in the PR
[ticket/11253] Fix typo in constant
[ticket/11253] Add migration to add auth check to UCP signature module
| -rw-r--r-- | phpBB/includes/db/migration/data/310/signature_module_auth.php | 51 |
1 files changed, 51 insertions, 0 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 new file mode 100644 index 0000000000..e4fbb27bcb --- /dev/null +++ b/phpBB/includes/db/migration/data/310/signature_module_auth.php @@ -0,0 +1,51 @@ +<?php +/** +* +* @package migration +* @copyright (c) 2013 phpBB Group +* @license http://opensource.org/licenses/gpl-2.0.php GNU Public License v2 +* +*/ + +class phpbb_db_migration_data_310_signature_module_auth extends phpbb_db_migration +{ + public function effectively_installed() + { + $sql = 'SELECT module_auth + FROM ' . MODULES_TABLE . " + WHERE module_class = 'ucp' + AND module_basename = 'ucp_profile' + AND module_mode = 'signature'"; + $result = $this->db->sql_query($sql); + $module_auth = $this->db_sql_fetchfield('module_auth'); + $this->db->sql_freeresult($result); + + return $module_auth === 'acl_u_sig' || $module_auth === false; + } + + static public function depends_on() + { + return array('phpbb_db_migration_data_31x_dev'); + } + + public function update_data() + { + return array( + array('custom', array( + array($this, 'update_signature_module_auth'), + ), + ), + ); + } + + public function update_signature_module_auth() + { + $sql = 'UPDATE ' . MODULES_TABLE . " + SET module_auth = 'acl_u_sig' + WHERE module_class = 'ucp' + AND module_basename = 'ucp_profile' + AND module_mode = 'signature' + AND module_auth = ''"; + $this->db->sql_query($sql); + } +} |