diff options
| author | Marc Alexander <admin@m-a-styles.de> | 2013-06-17 23:04:22 +0200 |
|---|---|---|
| committer | Marc Alexander <admin@m-a-styles.de> | 2013-09-14 13:53:14 +0200 |
| commit | dae4327cfcd0908dc751f47cbbc462df454d153c (patch) | |
| tree | 438a6768d998e89cba6907ac9aeb313656d57507 /phpBB/includes | |
| parent | 4b81b93d102b1657ab59cbc98cfa5c1d66d94304 (diff) | |
| download | forums-dae4327cfcd0908dc751f47cbbc462df454d153c.tar forums-dae4327cfcd0908dc751f47cbbc462df454d153c.tar.gz forums-dae4327cfcd0908dc751f47cbbc462df454d153c.tar.bz2 forums-dae4327cfcd0908dc751f47cbbc462df454d153c.tar.xz forums-dae4327cfcd0908dc751f47cbbc462df454d153c.zip | |
[feature/passwords] Add schema changes for new hash types
PHPBB3-11610
Diffstat (limited to 'phpBB/includes')
| -rw-r--r-- | phpBB/includes/db/migration/data/310/crypto.php | 63 |
1 files changed, 63 insertions, 0 deletions
diff --git a/phpBB/includes/db/migration/data/310/crypto.php b/phpBB/includes/db/migration/data/310/crypto.php new file mode 100644 index 0000000000..c8ac8360ad --- /dev/null +++ b/phpBB/includes/db/migration/data/310/crypto.php @@ -0,0 +1,63 @@ +<?php +/** +* +* @package migration +* @copyright (c) 2013 phpBB Group +* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2 +* +*/ + +class phpbb_db_migration_data_310_crypto extends phpbb_db_migration +{ + public function effectively_installed() + { + $ret = false; + $this->db->sql_return_on_error(true); + // Set user_password to 64 character long string + $sql = 'UPDATE ' . USERS_TABLE . " + SET user_password = '" . md5('foobar') . md5('foobar') . "' + WHERE user_id = '" . ANONYMOUS . "'"; + $this->db->sql_query($sql); + $this->db->sql_return_on_error(false); + + if ($this->db->sql_affectedrows()) + { + $ret = true; + } + + // Reset user password + $sql = 'UPDATE ' . USERS_TABLE . " + SET user_password = '' + WHERE user_id = '" . ANONYMOUS . "'"; + $this->db->sql_query($sql); + + return $ret; + } + + static public function depends_on() + { + return array('phpbb_db_migration_data_30x_3_0_11'); + } + + public function update_schema() + { + return array( + 'change_columns' => array( + $this->table_prefix . 'users' => array( + 'user_password' => array('VCHAR:255', ''), + ), + ), + ); + } + + public function revert_schema() + { + return array( + 'change_columns' => array( + $this->table_prefix . 'users' => array( + 'user_password' => array('VCHAR:40', ''), + ), + ), + ); + } +} |