upgrade members

[PietroP]

Good Evening. I Have this file, can i add my old members in my new forum ? How I can ?

-- Struttura della tabella `ibf_members`
--
CREATE TABLE `ibf_members` (
`id` mediumint(8) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`mgroup` smallint(3) NOT NULL default '0',
`email` varchar(150) NOT NULL default '',
`joined` int(10) NOT NULL default '0',
`ip_address` varchar(16) NOT NULL default '',
`posts` mediumint(7) default '0',
`title` varchar(64) default NULL,
`allow_admin_mails` tinyint(1) default NULL,
`time_offset` varchar(10) default NULL,
`hide_email` varchar(8) default NULL,
`email_pm` tinyint(1) default '1',
`email_full` tinyint(1) default NULL,
`skin` smallint(5) default NULL,
`warn_level` int(10) default NULL,
`warn_lastwarn` int(10) NOT NULL default '0',
`language` varchar(32) default NULL,
`last_post` int(10) default NULL,
`restrict_post` varchar(100) NOT NULL default '0',
`view_sigs` tinyint(1) default '1',
`view_img` tinyint(1) default '1',
`view_avs` tinyint(1) default '1',
`view_pop` tinyint(1) default '1',
`bday_day` int(2) default NULL,
`bday_month` int(2) default NULL,
`bday_year` int(4) default NULL,
`new_msg` tinyint(2) default '0',
`msg_total` smallint(5) default '0',
`show_popup` tinyint(1) default '0',
`misc` varchar(128) default NULL,
`last_visit` int(10) default '0',
`last_activity` int(10) default '0',
`dst_in_use` tinyint(1) default '0',
`view_prefs` varchar(64) default '-1&-1',
`coppa_user` tinyint(1) default '0',
`mod_posts` varchar(100) NOT NULL default '0',
`auto_track` varchar(50) default '0',
`temp_ban` varchar(100) default '0',
`sub_end` int(10) NOT NULL default '0',
`login_anonymous` char(3) NOT NULL default '0&0',
`ignored_users` text,
`mgroup_others` varchar(255) NOT NULL default '',
`org_perm_id` varchar(255) NOT NULL default '',
`member_login_key` varchar(32) NOT NULL default '',
`member_login_key_expire` int(10) NOT NULL default '0',
`subs_pkg_chosen` smallint(3) NOT NULL default '0',
`has_blog` tinyint(1) NOT NULL default '0',
`has_gallery` tinyint(1) NOT NULL default '0',
`members_markers` text,
`members_editor_choice` char(3) NOT NULL default 'std',
`members_auto_dst` tinyint(1) NOT NULL default '1',
`members_display_name` varchar(255) NOT NULL default '',
`members_created_remote` tinyint(1) NOT NULL default '0',
`members_cache` mediumtext,
`members_disable_pm` int(1) NOT NULL default '0',
`members_l_display_name` varchar(255) NOT NULL default '0',
`members_l_username` varchar(255) NOT NULL default '0',
`failed_logins` text,
`failed_login_count` smallint(3) NOT NULL default '0',
`members_profile_views` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `members_l_display_name` (`members_l_display_name`),
KEY `members_l_username` (`members_l_username`),
KEY `mgroup` (`mgroup`),
KEY `bday_day` (`bday_day`),
KEY `bday_month` (`bday_month`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dump dei dati per la tabella `ibf_members`
--

INSERT INTO `ibf_members` (`id`, `name`, `mgroup`, `legacy_password`, `email`, `joined`, `ip_address`, `posts`, `title`, `allow_admin_mails`, `time_offset`, `hide_email`, `email_pm`, `email_full`, `skin`, `warn_level`, `warn_lastwarn`, `language`, `last_post`, `restrict_post`, `view_sigs`, `view_img`, `view_avs`, `view_pop`, `bday_day`, `bday_month`, `bday_year`, `new_msg`, `msg_total`, `show_popup`, `misc`, `last_visit`, `last_activity`, `dst_in_use`, `view_prefs`, `coppa_user`, `mod_posts`, `auto_track`, `temp_ban`, `sub_end`, `login_anonymous`, `ignored_users`, `mgroup_others`, `org_perm_id`, `member_login_key`, `subs_pkg_chosen`, `has_blog`, `members_markers`, `members_editor_choice`, `members_auto_dst`, `members_display_name`, `members_created_remote`, `members_cache`, `members_disable_pm`, `use_dshoutbox`, `dshoutbox_mod`, `dshout_limit`, `dshouts_today`, `dshouts_alltime`, `dshout_saveload`, `dshout_bwbypass`, `dshout_editown`, `dshout_deleteown`, `last_shout_time`, `sb_showavatars`, `sb_showshouttime`, `sb_defaultcolor`, `sb_refresh`, `sb_showsmiliest`, `sb_showtdshouters`, `sb_showtpshouters`, `sb_shoutboxtype`, `sb_topic_id`) VALUES (1, 'CoolSh@rK', 4, '', 'xxx@nnnn.it', 1136238893, '80.117.127.37', 5, 'Administrator', NULL, NULL, NULL, NULL, NULL, 4, NULL, 0, '2', 1137437099, '0', 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, 0, NULL, 1137366828, 1179833361, 0, '-1&-1', 0, '0', '0', '0', 0, '0&1', '', '', '', 'aedd65df1dcc8a1b110738e65d771344', 0, 0, '', 'std', 1, 'CoolSh@rK', 0, NULL, 0, 1, 0, 0, '10|8th January 2006', 0, 1, 0, 1, 0, 1136758002, 'D', 'D', 'D', 'D', 'D', 'D', 'D', 'D', 0),
(2, 'Max', 4, '', 'xxx@xxx.it', 1136238955, '80.117.127.37', 55, NULL, NULL, '1', NULL, 1, NULL, 4, NULL, 0, '2', 1172930952, '0', 1, 1, 1, 1, 14, 8, 1973, 0, 1, 0, NULL, 1171378873, 1181998336, 0, '-1&-1', 0, '0', '0', '0', 0, '0&1', '', '', '', 'a8dc1cc6fff6537d2597eba710197b96', 0, 0, '', 'std', 0, 'Max', 0, NULL, 0, 1, 0, 0, '1|25th February 2007', 0, 1, 0, 1, 0, 1172406477, 'D', 'D', 'D', 'D', 'D', 'D', 'D', 'D', 0),

[bfarber]

This forum is for feedback regarding our services and products. Please submit a ticket for support, or use IPS Beyond for peer-to-peer support.