Forum Bénabar

Code : Tout sélectionner

update `phpbb3_forums` set forum_name = replace(forum_name, 'é', 'é' ) where forum_name like '%é%';
update `phpbb3_forums` set forum_desc = replace(forum_desc, 'é', 'é' ) where forum_desc like '%é%';
update `phpbb3_forums` set forum_parents = replace(forum_parents, 'é', 'é' ) where forum_parents like '%é%';
update `phpbb3_forums` set forum_last_post_subject = replace(forum_last_post_subject, 'é', 'é' ) where forum_last_post_subject like '%é%';
update `phpbb3_forums` set forum_last_poster_name = replace(forum_last_poster_name, 'é', 'é' ) where forum_last_poster_name like '%é%';

update `phpbb3_acl_roles` set role_description = replace(role_description, 'é', 'é' ) where role_description like '%é%';

update `phpbb3_groups` set group_name = replace(group_name, 'é', 'é' ) where group_name like '%é%';
update `phpbb3_groups` set group_desc = replace(group_desc, 'é', 'é' ) where group_desc like '%é%';

update `phpbb3_moderator_cache` set group_name = replace(group_name, 'é', 'é' ) where group_name like '%é%';

update `phpbb3_poll_options` set poll_option_text = replace(poll_option_text, 'é', 'é' ) where poll_option_text like '%é%';

update `phpbb3_posts` set post_subject = replace(post_subject, 'é', 'é' ) where post_subject like '%é%';
update `phpbb3_posts` set post_text = replace(post_text, 'é', 'é' ) where post_text like '%é%';

update `phpbb3_privmsgs` set message_subject = replace(message_subject, 'é', 'é' ) where message_subject like '%é%';
update `phpbb3_privmsgs` set message_text = replace(message_text, 'é', 'é' ) where message_text like '%é%';
update `phpbb3_privmsgs` set to_address = replace(to_address, 'é', 'é' ) where to_address like '%é%';

update `phpbb3_ranks` set rank_title = replace(rank_title, 'é', 'é' ) where rank_title like '%é%';

update `phpbb3_reports_reasons` set reason_description = replace(reason_description, 'é', 'é' ) where reason_description like '%é%';

update `phpbb3_smilies` set emotion = replace(emotion, 'é', 'é' ) where emotion like '%é%';

update `phpbb3_topics` set topic_title = replace(topic_title, 'é', 'é' ) where topic_title like '%é%';
update `phpbb3_topics` set topic_first_poster_name = replace(topic_first_poster_name, 'é', 'é' ) where topic_first_poster_name like '%é%';
update `phpbb3_topics` set topic_last_poster_name = replace(topic_last_poster_name, 'é', 'é' ) where topic_last_poster_name like '%é%';
update `phpbb3_topics` set topic_last_post_subject = replace(topic_last_post_subject, 'é', 'é' ) where topic_last_post_subject like '%é%';
update `phpbb3_topics` set poll_title = replace(poll_title, 'é', 'é' ) where poll_title like '%é%';

update `phpbb3_users` set user_permissions = replace(user_permissions, 'é', 'é' ) where user_permissions like '%é%';
update `phpbb3_users` set username = replace(username, 'é', 'é' ) where username like '%é%';
update `phpbb3_users` set username_clean = replace(username_clean, 'é', 'é' ) where username_clean like '%é%';
update `phpbb3_users` set user_sig = replace(user_sig, 'é', 'é' ) where user_sig like '%é%';
update `phpbb3_users` set user_from = replace(user_from, 'é', 'é' ) where user_from like '%é%';
update `phpbb3_users` set user_occ = replace(user_occ, 'é', 'é' ) where user_occ like '%é%';
update `phpbb3_users` set user_interests = replace(user_interests, 'é', 'é' ) where user_interests like '%é%';

update `phpbb3_forums` set forum_name = replace(forum_name, 'ã©', 'é' ) where forum_name like '%ã©%';
update `phpbb3_forums` set forum_desc = replace(forum_desc, 'ã©', 'é' ) where forum_desc like '%ã©%';
update `phpbb3_forums` set forum_parents = replace(forum_parents, 'ã©', 'é' ) where forum_parents like '%ã©%';

update `phpbb3_acl_roles` set role_description = replace(role_description, 'ã©', 'é' ) where role_description like '%ã©%';

update `phpbb3_groups` set group_name = replace(group_name, 'ã©', 'é' ) where group_name like '%ã©%';
update `phpbb3_groups` set group_desc = replace(group_desc, 'ã©', 'é' ) where group_desc like '%ã©%';

update `phpbb3_moderator_cache` set group_name = replace(group_name, 'ã©', 'é' ) where group_name like '%ã©%';

update `phpbb3_poll_options` set poll_option_text = replace(poll_option_text, 'ã©', 'é' ) where poll_option_text like '%ã©%';

update `phpbb3_posts` set post_subject = replace(post_subject, 'ã©', 'é' ) where post_subject like '%ã©%';
update `phpbb3_posts` set post_text = replace(post_text, 'ã©', 'é' ) where post_text like '%ã©%';

update `phpbb3_privmsgs` set message_subject = replace(message_subject, 'ã©', 'é' ) where message_subject like '%ã©%';
update `phpbb3_privmsgs` set message_text = replace(message_text, 'ã©', 'é' ) where message_text like '%ã©%';
update `phpbb3_privmsgs` set to_address = replace(to_address, 'ã©', 'é' ) where to_address like '%ã©%';

update `phpbb3_ranks` set rank_title = replace(rank_title, 'ã©', 'é' ) where rank_title like '%ã©%';

update `phpbb3_reports_reasons` set reason_description = replace(reason_description, 'ã©', 'é' ) where reason_description like '%ã©%';

update `phpbb3_smilies` set emotion = replace(emotion, 'ã©', 'é' ) where emotion like '%ã©%';

update `phpbb3_topics` set topic_title = replace(topic_title, 'ã©', 'é' ) where topic_title like '%ã©%';
update `phpbb3_topics` set topic_first_poster_name = replace(topic_first_poster_name, 'ã©', 'é' ) where topic_first_poster_name like '%ã©%';
update `phpbb3_topics` set topic_last_poster_name = replace(topic_last_poster_name, 'ã©', 'é' ) where topic_last_poster_name like '%ã©%';
update `phpbb3_topics` set topic_last_post_subject = replace(topic_last_post_subject, 'ã©', 'é' ) where topic_last_post_subject like '%ã©%';
update `phpbb3_topics` set poll_title = replace(poll_title, 'ã©', 'é' ) where poll_title like '%ã©%';

update `phpbb3_users` set user_permissions = replace(user_permissions, 'ã©', 'é' ) where user_permissions like '%ã©%';
update `phpbb3_users` set username = replace(username, 'ã©', 'é' ) where username like '%ã©%';
update `phpbb3_users` set username_clean = replace(username_clean, 'ã©', 'é' ) where username_clean like '%ã©%';
update `phpbb3_users` set user_sig = replace(user_sig, 'ã©', 'é' ) where user_sig like '%ã©%';
update `phpbb3_users` set user_from = replace(user_from, 'ã©', 'é' ) where user_from like '%ã©%';
update `phpbb3_users` set user_occ = replace(user_occ, 'ã©', 'é' ) where user_occ like '%ã©%';
update `phpbb3_users` set user_interests = replace(user_interests, 'ã©', 'é' ) where user_interests like '%ã©%';

Code : Tout sélectionner

é - é
è - è
ê - ê
ë - ë
â - â
ä - ä
î - î
ï - ï
ò - ò
ô - ô
ù - ù
û - û
ç - ç
' - ’
! - …
« - «Â
» -  »
« - «
» - »
œ - Å“
à - Ã