Citation
REPLACE INTO `fsb2_users` (`u_id`, `u_auth`, `u_nickname`, `u_email`, `u_avatar`, `u_signature`, `u_birthday`, `u_language`, `u_tpl`, `u_joined`, `u_last_visit`, `u_last_read`, `u_last_read_flag`, `u_total_post`, `u_total_topic`, `u_total_abuse`, `u_total_mp`, `u_avatar_method`, `u_can_use_avatar`, `u_can_use_sig`, `u_sexe`, `u_activate_redirection`, `u_activate_email`, `u_activate_auto_notification`, `u_activate_mp_notification`, `u_activate_hidden`, `u_activate_fscode`, `u_activate_avatar`, `u_activate_sig`, `u_activate_img`, `u_activate_ajax`, `u_activate_userlist`, `u_mp_auto_answer_activ`, `u_mp_auto_answer_message`, `u_rank_id`, `u_activate_wysiwyg`, `u_new_mp`, `u_newsletter`, `u_single_group_id`, `u_default_group_id`, `u_color`, `u_comment`, `u_register_ip`, `u_activated`, `u_confirm_hash`, `u_total_warning`, `u_warn_post`, `u_warn_read`, `u_utc`, `u_utc_dst`, `u_approve`, `u_flood_post`) VALUES (1, 0, 'Visitor', '', '', '', '00/00/0000', 'fr', 'WhiteSummer', 0, 0, 1190531469, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 1, 1, 6, 1, 1, 0, '', 2, 0, 0, 0, 0, 2, '', '', '', 1, '', 0, 0, 0, 0, 0, 0, 0);
=================
Structure apres reinstall :
#
# Structure de la table MySQL `2fsb2_users`
#
CREATE TABLE `2fsb2_users` (
`u_id` int(11) NOT NULL auto_increment,
`u_auth` tinyint(4) NOT NULL default '0',
`u_nickname` varchar(40) NOT NULL default '',
`u_email` varchar(255) NOT NULL default '',
`u_avatar` varchar(255) NOT NULL default '',
`u_signature` text NOT NULL,
`u_birthday` char(10) NOT NULL default '0000/00/00',
`u_language` varchar(255) NOT NULL default '',
`u_tpl` varchar(255) NOT NULL default '',
`u_joined` int(11) NOT NULL default '0',
`u_last_visit` int(11) NOT NULL default '0',
`u_last_read` int(11) NOT NULL default '0',
`u_last_read_flag` tinyint(4) NOT NULL default '0',
`u_total_post` int(11) NOT NULL default '0',
`u_total_topic` int(11) NOT NULL default '0',
`u_total_abuse` int(11) NOT NULL default '-1',
`u_total_unapproved` int(11) NOT NULL default '-1',
`u_total_mp` int(11) NOT NULL default '0',
`u_avatar_method` tinyint(4) NOT NULL default '0',
`u_can_use_avatar` tinyint(4) NOT NULL default '1',
`u_can_use_sig` tinyint(4) NOT NULL default '1',
`u_sexe` tinyint(4) NOT NULL default '0',
`u_activate_redirection` tinyint(4) NOT NULL default '8',
`u_activate_email` tinyint(4) NOT NULL default '4',
`u_activate_auto_notification` tinyint(4) NOT NULL default '2',
`u_activate_mp_notification` tinyint(4) NOT NULL default '1',
`u_activate_hidden` tinyint(4) NOT NULL,
`u_activate_fscode` tinyint(4) NOT NULL default '6',
`u_activate_avatar` tinyint(4) NOT NULL default '1',
`u_activate_sig` tinyint(4) NOT NULL default '1',
`u_activate_img` tinyint(4) NOT NULL default '6',
`u_activate_ajax` tinyint(4) NOT NULL default '1',
`u_activate_userlist` tinyint(4) NOT NULL default '1',
`u_mp_auto_answer_activ` tinyint(4) NOT NULL default '0',
`u_mp_auto_answer_message` varchar(255) NOT NULL default '',
`u_rank_id` mediumint(9) NOT NULL default '0',
`u_activate_wysiwyg` tinyint(4) NOT NULL default '1',
`u_new_mp` tinyint(4) NOT NULL default '0',
`u_newsletter` tinyint(4) NOT NULL default '0',
`u_single_group_id` int(11) NOT NULL default '0',
`u_default_group_id` int(11) NOT NULL default '2',
`u_color` varchar(255) NOT NULL default '',
`u_comment` text NOT NULL,
`u_register_ip` varchar(15) NOT NULL,
`u_activated` tinyint(4) NOT NULL,
`u_confirm_hash` char(32) NOT NULL,
`u_total_warning` tinyint(4) NOT NULL,
`u_warn_post` int(11) NOT NULL default '0',
`u_warn_read` int(11) NOT NULL default '0',
`u_utc` tinyint(4) NOT NULL default '0',
`u_utc_dst` tinyint(4) NOT NULL,
`u_approve` tinyint(4) NOT NULL default '0',
`u_flood_post` int(11) NOT NULL default '0',
PRIMARY KEY (`u_id`),
KEY `u_nickname` (`u_nickname`),
KEY `u_birthday` (`u_birthday`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
#
# Contenu de la table MySQL `2fsb2_users`
#
INSERT INTO 2fsb2_users (u_id, u_auth, u_nickname, u_email, u_avatar, u_signature, u_birthday, u_language, u_tpl, u_joined, u_last_visit, u_last_read, u_last_read_flag, u_total_post, u_total_topic, u_total_abuse, u_total_unapproved, u_total_mp, u_avatar_method, u_can_use_avatar, u_can_use_sig, u_sexe, u_activate_redirection, u_activate_email, u_activate_auto_notification, u_activate_mp_notification, u_activate_hidden, u_activate_fscode, u_activate_avatar, u_activate_sig, u_activate_img, u_activate_ajax, u_activate_userlist, u_mp_auto_answer_activ, u_mp_auto_answer_message, u_rank_id, u_activate_wysiwyg, u_new_mp, u_newsletter, u_single_group_id, u_default_group_id, u_color, u_comment, u_register_ip, u_activated, u_confirm_hash, u_total_warning, u_warn_post, u_warn_read, u_utc, u_utc_dst, u_approve, u_flood_post) VALUES (1, 0, 'Visitor', '', '', '', '00/00/0000', 'fr', 'WhiteSummer', 0, 0, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 1, 1, 6, 1, 1, 0, '', 2, 0, 0, 0, 0, 2, '', '', '', 1, '', 0, 0, 0, 0, 0, 0, 0);
voilà, j'espere que celà vous suffira
sinon, no souci , laissez tomber (pas chantage mais baissage de bras) , rien de vital dans mes demandes.
au pire peut etre je rendrai le forum en "libre postage"
pour tout dire , mon idée premiere etait d'integrer les users de mes sites xoopsé dans FSB . sans competences suffisament poussées pout le faire, j'y ai renoncé .