|
|
| (85 versions intermédiaires par 4 utilisateurs non affichées) |
| Ligne 1 : |
Ligne 1 : |
| == Objectif == | | == Objectif == |
| * Basculer le forum vers phpbb 3.2 | | * Basculer le forum vers phpbb 3.2 |
| | * Ancien forum (à peu près) : https://github.com/Conardo/wefrag |
|
| |
|
| == Procédure == | | == Architecture applicative == |
| === Analyse ===
| | * phpbb 3.2 |
| * Récupérer [http://nofrag.com/temporary/dumpforum.sql le dump du forum].
| | * Plug-in de tribune : https://www.phpbb.com/customise/db/extension/ajax_shoutbox/ |
| * 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)) => '''????'''
| |
| * 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)) => ''''
| |
| * user_new_privmsg
| |
| * user_unread_privmsg
| |
| * user_last_privmsg
| |
| * user_message_rules
| |
| * user_full_folder
| |
| * user_emailtime
| |
| * user_topic_show_days
| |
| * user_topic_sortby_type
| |
| * user_topic_sortby_dir
| |
| * user_post_show_days
| |
| * user_post_sortby_type
| |
| * user_post_sortby_dir
| |
| * user_notify
| |
| * user_notify_pm
| |
| * user_notify_type
| |
| * user_allow_pm
| |
| * user_allow_viewonline
| |
| * user_allow_viewemail
| |
| * user_allow_massemail
| |
| * user_options
| |
| * user_avatar
| |
| * user_avatar_type
| |
| * user_avatar_width
| |
| * user_avatar_height
| |
| * user_sig
| |
| * user_sig_bbcode_uid
| |
| * user_sig_bbcode_bitfield
| |
| * user_jabber
| |
| * user_actkey
| |
| * user_newpasswd
| |
| * user_form_salt
| |
| * user_new
| |
| * user_reminded
| |
| * user_reminded_time
| |
| | |
| === phpbb_forums ===
| |