V2 Migration Forum

2017-08-31T08:01:16Z

Tenuis : /* Table phpbb_users */

== Objectif ==
* Basculer le forum vers phpbb 3.2

== Procédure ==
=== Analyse ===
* Récupérer [http://nofrag.com/temporary/dumpforum.sql le dump du forum].
* Installer un xampp ou équivalent
* Installer phpbb sur son poste
* Utiliser DBeaver ou tout autre autre outil équivalent pour comparer les tables phpbb avec celles du forum (travail manuel)
=== Transposition ===
* Définir l'ordre de traitement des tables
* Produire une procédure par table

== Liste des tables ==
=== Table phpbb_users ===
* user_id (int(10) unsigned) => wefrag_users.id(int(11))
* user_type(tinyint(2)) => 0
0 pour tous les inscrits admins compris
1 quand pas encore activé
2 pour ignorer l'utilisateur (?) ex. bot
3 pour les "Founders" : sorte de super-admin en god mode
Voir https://wiki.phpbb.com/Table.phpbb_users
* group_id(mediumint(8) unsigned) => phpbb_groups.group_id
* user_permission(mediumtext) => ''vide''
* user_perm_from(mediumint(8) unsigned) => 0
* user_ip(varchar(40)) => ''vide''
* user_regdate(int(11) unsigned) => ''vide''
* username(varchar(255)) => wefrag_users.login(varchar(255))
* username_clean(varchar(255)) => wefrag_users.login(varchar(255))
* user_password(varchar(255)) => wefrag_users.crypted_password(varchar(40))
Phpbb :[https://wiki.phpbb.com/Function.phpbb_check_hash techno proprio]?
Wefrag : [https://github.com/Conardo/wefrag/blob/master/app/models/user.rb sha1 ? voir ligne 220]
* user_passch (int(11) unsigned) => '''wefrag_user_password_resets.?'''
''pas forcément nécessaire''
* user_email(varchar(100)) => wefrag_users.email(varchar(255))
vérifier longueur max en table
* user_email_hash(bigint(20)) =>
d'après [https://www.phpbb.com/community/viewtopic.php?f=71&t=570125 ce lien] : crc32(strtolower($user_email)) . strlen($user_email),
'''à tester'''
* user_birthday(varchar(10)) => wefrag_users.birthdate(date)
* user_lastvisit(int(11) unsigned) => 0
* user_lastmark(int(11) unsigned) => 0
* user_lastpost_time(int(11) unsigned) =>
Récupérer la date du dernier post.
* user_lastpage(varchar(200)) => ''vide''
* user_last_confirm_key(varchar(10)) => ''vide''
* user_last_search(int(11) unsigned) => ''0''
* user_warnings(tinyint(4)) => ''0''
* user_last_warning(int(11) unsigned) => ''0''
* user_login_attempts(tinyint(4)) => ''0''
* user_inactive_reason(tinyint(2)) => ''0''
* user_inactive_time(int(11) unsigned) => ''0''
* user_posts(mediumint(8) unsigned) =>
Alimenter le nombre de posts
* user_lang(varchar(30)) => ''fr''
* user_timezone(varchar(100)) => ''vide''
* user_dateformat(varchar(64)) => ''D j M Y H:i''
* user_style(mediumint(8) unsigned) => ''0''
* user_rank(mediumint(8) unsigned) => ''0''
* user_colour(varchar(6)) => ''vide''
* user_new_privmsg(int(4)) => ''0''
* user_unread_privmsg(int(4)) => ''0''
* user_last_privmsg(int(11) unsigned) => ''0''
* user_message_rules(tinyint(1) unsigned)=> ''0''
* user_full_folder(int(11))=> ''-3''
* user_emailtime(int(11) unsigned)=> ''0''
* user_topic_show_days(smallint(4) unsigned) => ''0''
* user_topic_sortby_type(varchar(1)) => '''t'''
* user_topic_sortby_dir (varchar(1)) => '''d'''
* user_post_show_days (smallint(4) unsigned) => ''0''
* user_post_sortby_type(varchar(1)) => '''t'''
* user_post_sortby_dir (varchar(1)) => '''a'''
* user_notify (tinyint(1) unsigned) => ''0''
* user_notify_pm (tinyint(1) unsigned) => ''1''
* user_notify_type (tinyint(4))=> ''0''
* user_allow_pm(tinyint(1) unsigned) => ''1''
* user_allow_viewonline(tinyint(1) unsigned) => ''1''
* user_allow_viewemail(tinyint(1) unsigned) => ''1''
* user_allow_massemail(tinyint(1) unsigned) => ''1''
* user_options( int(11) UNSIGNED) => ''230271''
* user_avatar (varchar(255)) => ''vide''
* user_avatar_type (varchar(255)) => ''vide''
* user_avatar_width (smallint(4) unsigned) => ''0''
* user_avatar_height (smallint(4) unsigned) => ''0''
* user_sig (mediumtext) => ''vide''
* user_sig_bbcode_uid (varchar(8)) => ''vide''
* user_sig_bbcode_bitfield (varchar(255)) => ''vide''
* user_jabber (varchar(255)) => ''vide''
* user_actkey (varchar(32)) => ''vide''
* user_newpasswd (varchar(255)) => ''vide''
* user_form_salt (varchar(32)) => '''''????'''''
* user_new (tinyint(1)) => ''1''
* user_reminded (tinyint(4)) => ''0''
* user_reminded_time (int(11) UNSIGNED) => ''0''

=== phpbb_forums ===
Cette entité contient les catégories (wefrag_categories)et les forums (wefrag_forums). Il faut donc prévoir un premier passage pour les catégories et un second pour les forums.

* forum_id
* parent_id
* left_id
* right_id
* forum_parents
* forum_name
* forum_desc
* forum_desc_bitfield
* forum_desc_options
* forum_desc_uid
* forum_link
* forum_password
* forum_style
* forum_image
* forum_rules
* forum_rules_link
* forum_rules_bitfield
* forum_rules_options
* forum_rules_uid
* forum_topics_per_page
* forum_type
* forum_status
* forum_last_post_id
* forum_last_poster_id
* forum_last_post_subject
* forum_last_post_time
* forum_last_poster_name
* forum_last_poster_colour
* forum_flags
* display_on_index
* enable_indexing
* enable_icons
* enable_prune
* prune_next
* prune_days
* prune_viewed
* prune_freq
* display_subforum_list
* forum_options
* forum_posts_approved
* forum_posts_unapproved
* forum_posts_softdeleted
* forum_topics_approved
* forum_topics_unapproved
* forum_topics_softdeleted
* enable_shadow_prune
* prune_shadow_days
* prune_shadow_freq
* prune_shadow_next

=== phpbb_topics ===
=== phpbb_posts ===
=== phpbb_groups ===
=== phpbb_user_group ===
=== phpbb_topics_posted ===
=== phpbb_forums_track ===

NoFrag - Contributions [fr]

V2 Migration Forum