IPB 3.0 - Invision Power France: Créer un compte de secours sur IPB - IPB 3.0 - Invision Power France

Vous avez un soucis avec votre forum ? Vos accès ne sont plus disponibles, vous ne savez plus quoi faire.
Vous pouvez toujours créer un compte de secours directement dans la base de données.

(ne lancer les pas deux requettes, c'est l'une ou l'autre)

Pour cela, allez dans PhpMyAdmin (onglet SQL)

Lancer cette requette :

INSERT INTO `members` (`member_id`, `name`, `member_group_id`, `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`, `msg_count_new`, `msg_count_total`, `msg_count_reset`, `msg_show_notification`, `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`, `member_login_key_expire`, `subs_pkg_chosen`, `has_blog`, `has_gallery`, `members_editor_choice`, `members_auto_dst`, `members_display_name`, `members_seo_name`, `members_created_remote`, `members_cache`, `members_disable_pm`, `members_l_display_name`, `members_l_username`, `failed_logins`, `failed_login_count`, `members_profile_views`, `members_pass_hash`, `members_pass_salt`, `identity_url`, `member_banned`, `member_uploader`, `members_bitoptions`, `fb_uid`, `fb_emailhash`, `fb_emailallow`, `fb_lastsync`, `members_day_posts`) VALUES
(2, 'demomonforum', 4, 'toto@toto.com', 1248089989, '127.0.0.1', 0, 'Newbie', 1, '0', '1', 1, NULL, 0, 0, 0, '1', NULL, '', 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, NULL, 1248089989, 1248089989, 0, '-1&-1', 0, '', '0', '0', 0, '0&0', NULL, '', '', 'eb340e52788f74e7f2c6e12ffb4a43a5', 1248694789, 0, 0, 0, 'std', 0, 'demomonforum', 'demomonforum', 0, NULL, 0, 'demomonforum', 'demomonforum', NULL, 0, 0, '44d2b3c9dc92ef2ab32bb427cdf4b8bd', 'KjD]_', '', 0, 'default', 0, 0, '', 0, 0, '0,0');

Attention : Ceci est valable pour une version neuve de IPB 3 sans préfixe.
Si vous avez un préfixe du genre ibf_**** il suffit juste de changer le préfixe du début.

Voici le second code avec le préfixe ibf_

INSERT INTO `ibf_members` (`member_id`, `name`, `member_group_id`, `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`, `msg_count_new`, `msg_count_total`, `msg_count_reset`, `msg_show_notification`, `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`, `member_login_key_expire`, `subs_pkg_chosen`, `has_blog`, `has_gallery`, `members_editor_choice`, `members_auto_dst`, `members_display_name`, `members_seo_name`, `members_created_remote`, `members_cache`, `members_disable_pm`, `members_l_display_name`, `members_l_username`, `failed_logins`, `failed_login_count`, `members_profile_views`, `members_pass_hash`, `members_pass_salt`, `identity_url`, `member_banned`, `member_uploader`, `members_bitoptions`, `fb_uid`, `fb_emailhash`, `fb_emailallow`, `fb_lastsync`, `members_day_posts`) VALUES
(2, 'demomonforum', 4, 'toto@toto.com', 1248089989, '127.0.0.1', 0, 'Newbie', 1, '0', '1', 1, NULL, 0, 0, 0, '1', NULL, '', 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, NULL, 1248089989, 1248089989, 0, '-1&-1', 0, '', '0', '0', 0, '0&0', NULL, '', '', 'eb340e52788f74e7f2c6e12ffb4a43a5', 1248694789, 0, 0, 0, 'std', 0, 'demomonforum', 'demomonforum', 0, NULL, 0, 'demomonforum', 'demomonforum', NULL, 0, 0, '44d2b3c9dc92ef2ab32bb427cdf4b8bd', 'KjD]_', '', 0, 'default', 0, 0, '', 0, 0, '0,0');

• Login : demomonforum
  
• Mot de passe : demomonforum
  
• Email : toto@toto.com

Ceci vous permettra de remettre votre forum en place en cas de problème.
Avec ce compte vous serez directement root admin.

Fin.

© Tous droits réservés 2009
IPB - Invision Power France
http://www.invisionpower.fr

En espérant ne jamais m'en servir.... Mais Excellent, MERCI