{

$hash = phpbb_hash($password_new_format);

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_password = \'' . $this->db->sql_escape($hash) . '\',

user_pass_convert = 0

static protected $format_cache = array();

/**

* the user context and modify the timezone to the users selected timezone if one is not set.

*

* @param string $time String in a format accepted by strtotime().

* Correctly adjust LIKE expression for special characters

* Some DBMS are handling them in a different way

*

* @return string LIKE expression including the keyword!

*/

function sql_like_expression($expression)

* @param string $field name of the sql column that shall be compared

* @param array $array array of values that are allowed (IN) or not allowed (NOT IN)

* @param bool $negate true for NOT IN (), false for IN () (default)

*/

function sql_in_set($field, $array, $negate = false, $allow_empty_set = false)

{

$group_id = $this->db->sql_nextid();

}

$sql = 'SELECT role_id

FROM ' . ACL_ROLES_TABLE . "

WHERE role_name = 'ROLE_USER_NEW_MEMBER'

$u_role = $this->db->sql_nextid();

// Now add the correct data to the roles...

$sql = 'INSERT INTO ' . ACL_ROLES_DATA_TABLE . " (role_id, auth_option_id, auth_setting) SELECT $u_role, auth_option_id, 0 FROM " . ACL_OPTIONS_TABLE . " WHERE auth_option LIKE 'u_%' AND auth_option IN ('u_sendpm', 'u_masspm', 'u_masspm_group')";

$this->sql_query($sql);

$this->sql_query($sql);

}

$sql = 'SELECT role_id

FROM ' . ACL_ROLES_TABLE . "

WHERE role_name = 'ROLE_FORUM_NEW_MEMBER'

$this->sql_query($sql);

}

$sql = 'SELECT 1

FROM ' . USERS_TABLE . '

WHERE user_new = 0';

public function move_customise_modules()

{

// First get language module id

$sql = 'SELECT module_id FROM ' . MODULES_TABLE . "

WHERE module_basename = 'acp_language'";

}

/**

* "Daylight Saving Time" option

*

* @param $timezone float Users timezone in 3.0

}

/**

*

* @package db

*/

}

/**

* @param \phpbb\user $user

* @return string

*/

* current config value

*

* @param string $compare If equal to the current config value, will be

* @param string $config_name The name of the config setting you would

* like to update

* @param mixed $config_value The value of the config setting

/**

* Module Add

*

*

* @param string $class The module class(acp|mcp|ucp)

* @param int|string $parent The parent module_id|module_langname (0 for no parent)

}

/**

*

* @param string $role_name The new \role name

* @param sting $role_type The type (u_, m_, a_)

}

/**

*

* @package db

*/

}

/**

*/

function sql_column_add($table_name, $column_name, $column_data, $inline = false)

{

unset($notify_users[ANONYMOUS]);

// Make sure not to send new \notifications to users who've already been notified about this item

$sql = 'SELECT n.user_id

FROM ' . $this->notifications_table . ' n, ' . $this->notification_types_table . ' nt

WHERE n.notification_type_id = ' . (int) $notification_type_id . '

}

$this->db->sql_freeresult($result);

$notifications = $this->find_users_for_notification($post);

// Find the notifications we must delete