blob: c8ac8360ad151d95446e0621294ca52269f94e01 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
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', ''),
),
),
);
}
}
|
