function convert_users($start_at)
{
// Add salt field to the users table to allow login
if ($start_at == 0) {
$this->fluxbb->db->add_field('users', 'salt', 'VARCHAR(255)', true, '', 'password') or conv_error('Unable to add field', __FILE__, __LINE__, $this->db->error());
}
$result = $this->db->query_build(array('SELECT' => 'uid AS id, username AS username, password AS password, email, avatar, salt AS salt, website AS url, icq AS icq, msn AS msn, aim AS aim, yahoo AS yahoo, postnum AS num_posts, IF(hideemail=1, 1, 0) AS email_setting, timezone, lastvisit AS last_visit, signature, regdate AS registered, usergroup AS group_id', 'FROM' => 'users', 'WHERE' => 'uid > ' . $start_at, 'ORDER BY' => 'uid ASC', 'LIMIT' => PER_PAGE)) or conv_error('Unable to fetch users', __FILE__, __LINE__, $this->db->error());
conv_processing_message('users', $this->db->num_rows($result), $start_at);
if (!$this->db->num_rows($result)) {
return false;
}
while ($cur_user = $this->db->fetch_assoc($result)) {
$start_at = $cur_user['id'];
$cur_user['group_id'] = $this->grp2grp($cur_user['group_id']);
$cur_user['signature'] = $this->convert_message($cur_user['signature']);
$cur_user['id'] = $this->uid2uid($cur_user['id']);
$this->convert_avatar($cur_user);
unset($cur_user['avatar']);
$this->fluxbb->add_row('users', $cur_user);
}
return $this->redirect('users', 'uid', $start_at);
}
function convert_users($start_at)
{
$result = $this->db->query_build(array('SELECT' => 'user_id AS id, username, user_regdate AS registered, user_password AS password, user_email AS email, user_icq AS icq, user_website AS url, user_from AS location, user_viewemail AS email_setting, language, num_posts', 'FROM' => 'users', 'WHERE' => 'user_id > ' . $start_at, 'ORDER BY' => 'user_id ASC', 'LIMIT' => PER_PAGE)) or conv_error('Unable to fetch users', __FILE__, __LINE__, $this->db->error());
conv_processing_message('users', $this->db->num_rows($result), $start_at);
if (!$this->db->num_rows($result)) {
return false;
}
while ($cur_user = $this->db->fetch_assoc($result)) {
$start_at = $cur_user['id'];
$cur_user['group_id'] = $cur_user['id'] == '1' ? PUN_ADMIN : PUN_MEMBER;
$cur_user['username'] = html_entity_decode($cur_user['username']);
$cur_user['id'] = $this->uid2uid($cur_user['id']);
$this->fluxbb->add_row('users', $cur_user);
}
return $this->redirect('users', 'user_id', $start_at);
}
function convert_users($start_at)
{
$result = $this->db->query_build(array('SELECT' => 'user_id AS id, group_id, username, user_password AS password, user_website AS url, user_icq AS icq, user_msnm AS msn, user_aim AS aim, user_yim AS yahoo, user_posts AS num_posts, user_from AS location, user_allow_viewemail AS email_setting, user_timezone AS timezone, user_ip AS registration_ip, user_regdate AS registered, user_lastvisit AS last_visit, user_sig AS signature, user_email AS email, user_avatar', 'FROM' => 'users', 'WHERE' => 'group_id <> 6 AND user_id <> 1 AND user_id > ' . $start_at, 'ORDER BY' => 'user_id ASC', 'LIMIT' => PER_PAGE)) or conv_error('Unable to fetch users', __FILE__, __LINE__, $this->db->error());
conv_processing_message('users', $this->db->num_rows($result), $start_at);
if (!$this->db->num_rows($result)) {
return false;
}
while ($cur_user = $this->db->fetch_assoc($result)) {
$start_at = $cur_user['id'];
$cur_user['username'] = html_entity_decode($cur_user['username']);
$cur_user['group_id'] = $this->grp2grp($cur_user['group_id']);
$cur_user['email_setting'] = !$cur_user['email_setting'];
$cur_user['signature'] = $this->convert_message($cur_user['signature']);
$this->convert_avatar($cur_user);
unset($cur_user['user_avatar']);
$this->fluxbb->add_row('users', $cur_user, array($this->fluxbb, 'error_users'));
}
return $this->redirect('users', 'user_id', $start_at);
}
function convert_users($start_at)
{
// Add salt field to the users table to allow login
if ($start_at == 0) {
$this->fluxbb->db->add_field('users', 'salt', 'VARCHAR(255)', true, '', 'password') or conv_error('Unable to add field', __FILE__, __LINE__, $this->db->error());
}
$result = $this->db->query_build(array('SELECT' => 'id, group_id, username, password, email, title, realname, url, jabber, icq, msn, aim, yahoo, location, signature, disp_topics, disp_posts, email_setting, notify_with_post, auto_notify, show_smilies, show_img, show_img_sig, show_avatars, show_sig, timezone, dst, time_format, date_format, num_posts, last_post, last_search, last_email_sent, registered, registration_ip, last_visit, admin_note, activate_string, activate_key', 'FROM' => 'users', 'WHERE' => 'id <> 1 AND id > ' . $start_at, 'ORDER BY' => 'id ASC', 'LIMIT' => PER_PAGE)) or conv_error('Unable to fetch users', __FILE__, __LINE__, $this->db->error());
conv_processing_message('users', $this->db->num_rows($result), $start_at);
if (!$this->db->num_rows($result)) {
return false;
}
while ($cur_user = $this->db->fetch_assoc($result)) {
$start_at = $cur_user['id'];
$uid = $this->fetchUid($cur_user['username']);
if ($uid > 0) {
$cur_user['id'] = $uid;
} else {
$cur_user['id'] += $this->last_id['users'];
}
if ($cur_user['group_id'] > 4) {
$cur_user['group_id'] += $this->last_id['groups'];
}
$this->fluxbb->add_row('users', $cur_user, array($this, 'error_users'));
}
return $this->redirect('users', 'id', $start_at);
}
function convert_users($start_at)
{
// Add salt field to the users table to allow login
if ($start_at == 0) {
$this->fluxbb->db->add_field('users', 'salt', 'VARCHAR(255)', true, '', 'password') or conv_error('Unable to add field', __FILE__, __LINE__, $this->db->error());
}
$result = $this->db->query_build(array('SELECT' => 'id_member AS id, id_group AS group_id, member_name AS username, passwd AS password, password_salt AS salt, website_url AS url, icq AS icq, msn AS msn, aim AS aim, yim AS yahoo, signature AS signature, time_offset AS timezone, posts AS num_posts, date_registered AS registered, last_login AS last_visit, location AS location, email_address AS email', 'FROM' => 'members', 'WHERE' => 'id_member > ' . $start_at, 'ORDER BY' => 'id_member ASC', 'LIMIT' => PER_PAGE)) or conv_error('Unable to fetch users', __FILE__, __LINE__, $this->db->error());
conv_processing_message('users', $this->db->num_rows($result), $start_at);
if (!$this->db->num_rows($result)) {
return false;
}
while ($cur_user = $this->db->fetch_assoc($result)) {
$start_at = $cur_user['id'];
$cur_user['group_id'] = $this->grp2grp($cur_user['group_id']);
$cur_user['id'] = $this->uid2uid($cur_user['id']);
$result_post = $this->db->query_build(array('SELECT' => 'poster_time', 'FROM' => 'messages', 'WHERE' => 'id_member=' . $cur_user['id'], 'ORDER BY' => 'poster_time DESC', 'LIMIT' => 1)) or conv_error('Unable to fetch last post', __FILE__, __LINE__, $this->db->error());
if ($this->db->num_rows($result_post)) {
$cur_user['last_post'] = $this->db->result($result_post);
}
$this->fluxbb->add_row('users', $cur_user);
}
return $this->redirect('members', 'id_member', $start_at);
}
function convert_users($start_at)
{
$result = $this->db->query_build(array('SELECT' => 'user_id AS id, user_name AS username, user_password AS password, user_email AS email, user_web AS url, user_icq AS icq, user_msn AS msn, user_yahoo AS yahoo, user_sig AS signature, user_offset AS timezone, user_avatar, user_posts AS num_posts, user_joined AS registered, user_lastvisit AS last_visit, user_location AS location, IF(user_hide_email=0, 1, 0) AS email_setting, user_groups AS group_id', 'FROM' => 'users', 'WHERE' => 'user_id > ' . $start_at, 'ORDER BY' => 'user_id ASC', 'LIMIT' => PER_PAGE)) or conv_error('Unable to fetch users', __FILE__, __LINE__, $this->db->error());
conv_processing_message('users', $this->db->num_rows($result), $start_at);
if (!$this->db->num_rows($result)) {
return false;
}
while ($cur_user = $this->db->fetch_assoc($result)) {
$start_at = $cur_user['id'];
$result_last_post = $this->db->query_build(array('SELECT' => 'MAX(post_id)', 'FROM' => 'posts', 'WHERE' => 'post_author = ' . $cur_user['id'])) or conv_error('Unable to fetch user last post', __FILE__, __LINE__, $this->db->error());
$cur_user['last_post'] = $this->db->result($result_last_post);
// $cur_user['group_id'] = $this->grp2grp($cur_user['group_id']);
$groups = explode(',', $cur_user['group_id']);
$cur_user['group_id'] = $cur_user['id'] == 1 ? 1 : (count($groups) ? $groups[0] : 4);
$cur_user['id'] = $this->uid2uid($cur_user['id']);
$cur_user['email_setting'] = !$cur_user['email_setting'];
$cur_user['signature'] = $this->convert_message($cur_user['signature']);
$this->convert_avatar($cur_user);
unset($cur_user['user_avatar']);
$this->fluxbb->add_row('users', $cur_user);
}
return $this->redirect('users', 'user_id', $start_at);
}
function convert_users($start_at)
{
$result = $this->db->query_build(array('SELECT' => 'ID_MEMBER AS id, ID_GROUP AS group_id, memberName AS username, passwd AS password, passwordSalt AS salt, websiteUrl AS url, ICQ AS icq, MSN AS msn, AIM AS aim, YIM AS yahoo, signature AS signature, timeOffset AS timezone, posts AS num_posts, dateRegistered AS registered, lastLogin AS last_visit, location AS location, emailAddress AS email', 'FROM' => 'members', 'WHERE' => 'ID_MEMBER > ' . $start_at, 'ORDER BY' => 'ID_MEMBER ASC', 'LIMIT' => PER_PAGE)) or conv_error('Unable to fetch users', __FILE__, __LINE__, $this->db->error());
conv_processing_message('users', $this->db->num_rows($result), $start_at);
if (!$this->db->num_rows($result)) {
return false;
}
while ($cur_user = $this->db->fetch_assoc($result)) {
$start_at = $cur_user['id'];
$cur_user['group_id'] = $this->grp2grp($cur_user['group_id']);
$cur_user['id'] = $this->uid2uid($cur_user['id']);
$cur_user['signature'] = $this->convert_message($cur_user['signature']);
$this->fluxbb->add_row('users', $cur_user);
}
return $this->redirect('members', 'ID_MEMBER', $start_at);
}
function convert_users($start_at)
{
// Add salt field to the users table to allow login
if ($start_at == 0) {
$this->fluxbb->db->add_field('users', 'salt', 'VARCHAR(255)', true, '', 'password') or conv_error('Unable to add field', __FILE__, __LINE__, $this->db->error());
}
$result = $this->db->query_build(array('SELECT' => 'u.member_id AS id, u.member_group_id AS group_id, u.name AS username, u.members_pass_hash AS password, u.members_pass_salt AS salt, u.title, f.field_3 AS url, f.field_4 AS icq, f.field_2 AS msn, f.field_1 AS aim, f.field_8 AS yahoo, f.field_6 AS location, IF(u.time_offset IS NULL, 0, u.time_offset) AS timezone, u.posts AS num_posts, u.last_post, u.view_img AS show_img, 1 AS show_avatars, u.view_sigs AS show_sig, u.joined AS registered, u.ip_address AS registration_ip, u.last_visit AS last_visit, 1 AS email_setting, u.dst_in_use AS dst, p.signature, p.pp_main_photo', 'JOINS' => array(array('LEFT JOIN' => 'pfields_content AS f', 'ON' => 'f.member_id = u.member_id'), array('LEFT JOIN' => 'profile_portal AS p', 'ON' => 'p.pp_member_id = u.member_id')), 'FROM' => 'members AS u', 'WHERE' => 'u.member_id > ' . $start_at, 'ORDER BY' => 'u.member_id ASC', 'LIMIT' => PER_PAGE)) or conv_error('Unable to fetch users', __FILE__, __LINE__, $this->db->error());
conv_processing_message('users', $this->db->num_rows($result), $start_at);
if (!$this->db->num_rows($result)) {
return false;
}
while ($cur_user = $this->db->fetch_assoc($result)) {
$start_at = $cur_user['id'];
$cur_user['group_id'] = $this->grp2grp($cur_user['group_id']);
$cur_user['id'] = $this->uid2uid($cur_user['id']);
$cur_user['signature'] = $this->convert_message($cur_user['signature']);
$this->convert_avatar($cur_user);
unset($cur_user['pp_main_photo']);
$this->fluxbb->add_row('users', $cur_user, array($this->fluxbb, 'error_users'));
}
return $this->redirect('members', 'member_id', $start_at);
}
function convert_users($start_at)
{
// Add salt field to the users table to allow login
if ($start_at == 0) {
$this->fluxbb->db->add_field('users', 'salt', 'VARCHAR(255)', true, '', 'password') or conv_error('Unable to add field', __FILE__, __LINE__, $this->db->error());
}
$result = $this->db->query_build(array('SELECT' => 'u.userid AS id, u.username, u.password, u.salt, u.timezoneoffset AS timezone, u.posts AS num_posts, u.joindate AS registered, u.lastvisit AS last_visit, u.email, u.usergroupid AS group_id, u.lastpost AS last_post, t.signature, t.rank AS title', 'JOINS' => array(array('LEFT JOIN' => 'usertextfield AS t', 'ON' => 'u.userid = t.userid')), 'FROM' => 'user AS u', 'WHERE' => 'u.userid > ' . $start_at, 'ORDER BY' => 'u.userid ASC', 'LIMIT' => PER_PAGE)) or conv_error('Unable to fetch users', __FILE__, __LINE__, $this->db->error());
conv_processing_message('users', $this->db->num_rows($result), $start_at);
if (!$this->db->num_rows($result)) {
return false;
}
while ($cur_user = $this->db->fetch_assoc($result)) {
$start_at = $cur_user['id'];
$cur_user['id'] = $this->uid2uid($cur_user['id']);
$cur_user['group_id'] = $this->grp2grp($cur_user['group_id']);
$cur_user['signature'] = $this->convert_message($cur_user['signature']);
$this->fluxbb->add_row('users', $cur_user);
}
return $this->redirect('user', 'userid', $start_at);
}
