aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/phpbb
diff options
context:
space:
mode:
authorMarc Alexander <admin@m-a-styles.de>2013-08-11 15:04:25 -0500
committerMarc Alexander <admin@m-a-styles.de>2013-09-14 13:55:34 +0200
commitdf8e5f4c3c333be677489d2317f6991598a6cebf (patch)
tree0d96dfecf46eda423912f070679600e3e4f7ae91 /phpBB/phpbb
parent9b24fda5cd1f6e85c536dc2bc3e5f1bbdef5b7c2 (diff)
downloadforums-df8e5f4c3c333be677489d2317f6991598a6cebf.tar
forums-df8e5f4c3c333be677489d2317f6991598a6cebf.tar.gz
forums-df8e5f4c3c333be677489d2317f6991598a6cebf.tar.bz2
forums-df8e5f4c3c333be677489d2317f6991598a6cebf.tar.xz
forums-df8e5f4c3c333be677489d2317f6991598a6cebf.zip
[feature/passwords] Move migrations file to phpbb folder
PHPBB3-11610
Diffstat (limited to 'phpBB/phpbb')
-rw-r--r--phpBB/phpbb/db/migration/data/310/crypto.php63
1 files changed, 63 insertions, 0 deletions
diff --git a/phpBB/phpbb/db/migration/data/310/crypto.php b/phpBB/phpbb/db/migration/data/310/crypto.php
new file mode 100644
index 0000000000..c8ac8360ad
--- /dev/null
+++ b/phpBB/phpbb/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', ''),
+ ),
+ ),
+ );
+ }
+}