function update_data()

{

);

// Add newly_registered group... but check if it already exists (we always supported running the updater on any schema)

$sql = 'SELECT group_id

FROM ' . GROUPS_TABLE . "

WHERE group_name = 'NEWLY_REGISTERED'";

if (!$group_id)

{

$sql = 'INSERT INTO ' . GROUPS_TABLE . " (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('NEWLY_REGISTERED', 3, 0, '', 0, '', '', '', 5)";

}

// Insert new user role... at the end of the chain

FROM ' . ACL_ROLES_TABLE . "

WHERE role_name = 'ROLE_USER_NEW_MEMBER'

AND role_type = 'u_'";

if (!$u_role)

{

$sql = 'SELECT MAX(role_order) as max_order_id

FROM ' . ACL_ROLES_TABLE . "

WHERE role_type = 'u_'";

$next_order_id++;

$sql = 'INSERT INTO ' . ACL_ROLES_TABLE . " (role_name, role_description, role_type, role_order) VALUES ('ROLE_USER_NEW_MEMBER', 'ROLE_DESCRIPTION_USER_NEW_MEMBER', 'u_', $next_order_id)";

if (!$errored)

{

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

// The standard role says that new users are not able to send a PM, Mass PM, are not able to PM groups

$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')";

// Add user role to group

$sql = 'INSERT INTO ' . ACL_GROUPS_TABLE . " (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES ($group_id, 0, 0, $u_role, 0)";

}

}

FROM ' . ACL_ROLES_TABLE . "

WHERE role_name = 'ROLE_FORUM_NEW_MEMBER'

AND role_type = 'f_'";

if (!$f_role)

{

$sql = 'SELECT MAX(role_order) as max_order_id

FROM ' . ACL_ROLES_TABLE . "

WHERE role_type = 'f_'";

$next_order_id++;

$sql = 'INSERT INTO ' . ACL_ROLES_TABLE . " (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_NEW_MEMBER', 'ROLE_DESCRIPTION_FORUM_NEW_MEMBER', 'f_', $next_order_id)";

if (!$errored)

{

$sql = 'INSERT INTO ' . ACL_ROLES_DATA_TABLE . " (role_id, auth_option_id, auth_setting) SELECT $f_role, auth_option_id, 0 FROM " . ACL_OPTIONS_TABLE . " WHERE auth_option LIKE 'f_%' AND auth_option IN ('f_noapprove')";

}

}

$sql = 'SELECT 1

FROM ' . USERS_TABLE . '

WHERE user_new = 0';

if (!$row)

{

$sql = 'UPDATE ' . USERS_TABLE . ' SET user_new = 0';

}

// To mimick the old "feature" we will assign the forum role to every forum, regardless of the setting (this makes sure there are no "this does not work!!!! YUO!!!" posts...

FROM ' . ACL_GROUPS_TABLE . '

WHERE group_id = ' . $group_id . '

AND auth_role_id = ' . $f_role;

// Not assigned at all... :/

if (!$is_options)

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE . '

WHERE forum_type != ' . FORUM_LINK;

{

}

}

// Clear permissions...

$auth_admin = new auth_admin();

$auth_admin->acl_clear_prefetch();

}

}

function update_data()

{

// Update the Custom Profile Fields based on previous settings to the new format

$sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . '

SET field_show_on_vt = 1

WHERE field_hide = 0

AND (field_required = 1 OR field_show_on_reg = 1 OR field_show_profile = 1)';

}

}

function update_data()

{

// Delete all text-templates from the template_data

$sql = 'DELETE FROM ' . STYLES_TEMPLATE_DATA_TABLE . '

}

}

function update_data()

{

$sql = 'SELECT user_id, user_email, user_email_hash

FROM ' . USERS_TABLE . '

WHERE user_type <> ' . USER_IGNORE . "

AND user_email <> ''";

$i = 0;

{

// Snapshot of the phpbb_email_hash() function

// We cannot call it directly because the auto updater updates the DB first. :/

$user_email_hash = sprintf('%u', crc32(strtolower($row['user_email']))) . strlen($row['user_email']);

);

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = ' . (int) $row['user_id'];

}

}

$db->sql_freeresult($result);

}

}

),

)),

array('config.add', array('load_unreads_search', 1)),

);

}