Estás navegando como visitante. Por favor Registrate y Logueate para poder participar de ventajas como postear en el foro, Solicitar Ayuda, Ver Enlaces, Ver Imagenes. Registrate con nosotros clickeando AQUÍ.    
Registrarse    Identificarse   Blogs
Anuncios Internos
Felicidades para
mariaromer0
mariaromer0


Quieres ser Moderador/a. Si estas interesado/a, lee la info sobre ésto, haciendo Click
Promociona tu web AQUÍ

En ésta web está expresamente prohibido, publicar enlaces de descargas de material protegido por la ley, asi como seriales, cracks, parches, programas o juegos pirateados sin el consentimienteo del autor, en cuyo caso se debará exibir dicha autorización para legitimizar la descarga. Si algun usuario incumple esta norma, sera
eliminado junto a todos sus mensajes.


Portal » Índice general » Zona Webmasters » Tutoriales Webmaster




Nuevo tema Responder al tema  [ 1 mensaje ] 
{ VISITS } Vistas: 1182  { VISITS } Favoritos: 0 { VISITS } Seguidores: 0 
 
Autor Mensaje
 Asunto: Solución Caracteres Extraños al convertir, migrar, trasladar
 Nota Publicado: 12 May 2010 13:53 


Desconectado
Moderador Global
Moderador Global
Avatar de Usuario

Mensajes: 136

Todos mis aportes


Nivel: 10

HP: 0 / 230
0 / 230 0 / 230 0 / 230
MP: 110 / 110
110 / 110 110 / 110 110 / 110
EXP: 136 / 142
136 / 142 136 / 142 136 / 142

Karma: 25

Sexo:
Masculino



He dado: 26 Gracias
Recibidas: 25 Gracias
Blog: Ver blog (0)
Esta es una duda más que común y que tal vez a todos nos ha llegado a suceder alguna vez si es que hemos llegado a migrar una base de datos de un gestor a otro o haber migrado de phpBB2 a phpBB3 o simplemente luego de trasladar nuestro foro a otro servidor.

Esto sucede porque realizamos algún paso equivocadamente en el momento aquel, sobre todo porque no nos fijamos en la codificación los archivos y la base de datos.

Aclaro que este tutorial solo es para arreglar caracteres de los temas, foros, post, nombres de usuarios, firmas, etc... en si solo los datos almacenados en la base de datos.

Si este problema te sucede luego de instalar un MOD, o modificar un archivo de idioma, puedes fijarte en este documento sobre Dudas frecuentes en phpBB3, en el que se explica como solucionarlo.

Y sin más preámbulos vamos a la solución.

Esta consiste en generar unas consultas SQL mediante phpMyAdmin para reemplazar estos caracteres extraños por las letras con los acentos, las ñ y algunos caracteres especiales.

Así que abrimos nuestra base de datos mediante phpMyAdmin (esto en el caso de MySQL), o si usamos otro tipo de base de datos, entonces con su gestor favorito.

Primero que todo y como siempre, creamos una backup de la base de datos por si surge algun inconveniente.

Aca estoy poniendo los ejemplo con el prefijo "phpbb_" que es el mas usado y el que trae por defecto phpBB en su instalación, pero si usan otro deberan cambiarlo o sino, las consultas mostraran error.



Ejecutamos por partes, las siguiente consultas (también se puede ejecutar todas juntas pero lo hare de esta manera, para explicar mejor).

Nombres de los foros y subforos (Para estos tendremos que actualizar los registros de la tabla phpbb_forums):


    UPDATE phpbb_forums SET forum_name = replace(forum_name,'á','á');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'é','é');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'í','í');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'ó','ó');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'ú','ú');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'ñ','ñ');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'¿','¿');




Descripción de los foros y subforos:


    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'á','á');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'é','é');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'í','í');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ó','ó');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ú','ú');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ñ','ñ');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'¿','¿');




Titulos de los Temas (Para estos tendremos que actualizar los registros de la tabla phpbb_topics):

    UPDATE phpbb_topics SET topic_title = replace(topic_title,'á','á');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'é','é');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'í','í');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'ó','ó');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'ú','ú');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'ñ','ñ');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'¿','¿');




Asutos de los post (Para estos tendremos que actualizar los registros de la tabla phpbb_posts):


    UPDATE phpbb_posts SET post_subject = replace(post_subject,'á','á');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'é','é');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'í','í');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'ó','ó');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'ú','ú');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'ñ','ñ');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'¿','¿');



Texto de los post (Si tu foro es muy grande y tiene demaciados mensajes, esta consulta puede tardar mas en realizarse, así que tengamos paciencia):


    UPDATE phpbb_posts SET post_text = replace(post_text,'á','á');
    UPDATE phpbb_posts SET post_text = replace(post_text,'é','é');
    UPDATE phpbb_posts SET post_text = replace(post_text,'í','í');
    UPDATE phpbb_posts SET post_text = replace(post_text,'ó','ó');
    UPDATE phpbb_posts SET post_text = replace(post_text,'ú','ú');
    UPDATE phpbb_posts SET post_text = replace(post_text,'ñ','ñ');
    UPDATE phpbb_posts SET post_text = replace(post_text,'¿','¿');




Firmas de los usuarios (Para estos tendremos que actualizar los registros de la tabla phpbb_users):


    UPDATE phpbb_users SET user_sig = replace(user_sig,'á','á');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'é','é');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'í','í');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'ó','ó');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'ú','ú');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'ñ','ñ');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'¿','¿');




Nicks de los usuarios (Algunos usuarios usan caracteres especiales o acentos en sus Nicks, así que tambien es necesario actulizar estos campos).


    UPDATE phpbb_users SET username = replace(username,'á','á');
    UPDATE phpbb_users SET username = replace(username,'é','é');
    UPDATE phpbb_users SET username = replace(username,'í','í');
    UPDATE phpbb_users SET username = replace(username,'ó','ó');
    UPDATE phpbb_users SET username = replace(username,'ú','ú');
    UPDATE phpbb_users SET username = replace(username,'ñ','ñ');
    UPDATE phpbb_users SET username = replace(username,'¿','¿');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'á','á');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'é','é');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'í','í');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'ó','ó');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'ú','ú');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'ñ','ñ');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'¿','¿');






Estas consultas convertiran los caracteres á , é , í , ó , ú , ñ , ¿ lo que significa que no convierten otros caractedes especiales como el º o vocales con acentos en MAYUSCULAS (É , Ú , Ó), así que deberan crear sus propias consultas para esto, explico:

Para convertIr otros caracteres que no estan acá, de la siguiente manera:

UPDATE TABLA_DE_PHPBB SET CAMPO_TABLA = replace( CAMPO_TABLA, 'CARACTER_EXTRAÑO' , 'CARACTER_CORRECTO' );


TABLA_DE_PHPBB, Tabla en la cual realizaremos la consulta, eje = phpbb_posts,
CAMPO_TABLA, campo en el cual se encuentra almanecenado el caracter extraño, eje = post_text,
CARACTER_EXTRAÑO, caracter que queremos convertir, eje = ´ => caracter extraño que representa la Á,
CARACTER_CORRECTO, caracter correcto por que queremos reemplazar el extraño, eje = Á,


Entonces si queremos crear una consulta con el ejemplo anterior que puse quedaria de la siguiete manera:

UPDATE phpbb_posts SET post_text = replace( post_text , '´' , 'Á' );

Y lo que haria, seria reemplazar todos los caracteres estraños que representan la á mayuscula por "Á".


ampliación extra, (para modificar otros campos):
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ƒÂ','');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'á','á');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'é','é');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ã-','í');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ó','ó');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ú','ú');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ñ','ñ');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'¿','¿');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'´','Á');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'É','É');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ó','Ó');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ú','Ú');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'¡','¡');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ñ','Ñ');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'À','À');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'È','È');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'è','è');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ã’','Ò');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ò','ò');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ã','í');
    UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Â','Í');

    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ƒÂ','');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'á','á');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'é','é');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ã-','í');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ó','ó');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ú','ú');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ñ','ñ');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'¿','¿');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'´','Á');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'É','É');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ó','Ó');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ú','Ú');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'¡','¡');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ñ','Ñ');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'À','À');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'È','È');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'è','è');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ã’','Ò');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ò','ò');
    UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Â','Í');

    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ƒÂ','');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'á','á');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'é','é');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ã-','í');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ó','ó');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ú','ú');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ñ','ñ');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'¿','¿');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'´','Á');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'É','É');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ó','Ó');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ú','Ú');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'¡','¡');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ñ','Ñ');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'À','À');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'È','È');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'è','è');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ã’','Ò');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ò','ò');
    UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ã','í');

    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ƒÂ','');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'á','á');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'é','é');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ã-','í');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ó','ó');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ú','ú');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ñ','ñ');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'¿','¿');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'´','Á');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'É','É');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ó','Ó');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ú','Ú');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'¡','¡');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ñ','Ñ');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'À','À');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'È','È');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'è','è');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ã’','Ò');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ò','ò');
    UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ã','í');

    UPDATE phpbb_forums SET forum_name = replace(forum_name,'ƒÂ','');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'á','á');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'é','é');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ã-','í');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'ó','ó');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'ú','ú');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'ñ','ñ');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'¿','¿');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'´','Á');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'É','É');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ó','Ó');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ú','Ú');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'¡','¡');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ñ','Ñ');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'À','À');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'È','È');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'è','è');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ã’','Ò');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'ò','ò');
    UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ã','í');
       
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ƒÂ','');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'á','á');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'é','é');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ã-','í');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ó','ó');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ú','ú');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ñ','ñ');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'¿','¿');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'´','Á');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'É','É');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ó','Ó');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ú','Ú');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'¡','¡');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ñ','Ñ');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'À','À');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'È','È');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'è','è');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ã’','Ò');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ò','ò');
    UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ã','í');

    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ƒÂ','');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'á','á');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'é','é');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ã-','í');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ó','ó');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ú','ú');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ñ','ñ');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'¿','¿');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'´','Á');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'É','É');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ó','Ó');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ú','Ú');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'¡','¡');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ñ','Ñ');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'À','À');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'È','È');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'è','è');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ã’','Ò');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ò','ò');
    UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ã','í');

    UPDATE phpbb_groups SET group_name = replace(group_name,'ƒÂ','');
    UPDATE phpbb_groups SET group_name = replace(group_name,'á','á');
    UPDATE phpbb_groups SET group_name = replace(group_name,'é','é');
    UPDATE phpbb_groups SET group_name = replace(group_name,'Ã-','í');
    UPDATE phpbb_groups SET group_name = replace(group_name,'ó','ó');
    UPDATE phpbb_groups SET group_name = replace(group_name,'ó','ó');
    UPDATE phpbb_groups SET group_name = replace(group_name,'ú','ú');
    UPDATE phpbb_groups SET group_name = replace(group_name,'ñ','ñ');
    UPDATE phpbb_groups SET group_name = replace(group_name,'¿','¿');
    UPDATE phpbb_groups SET group_name = replace(group_name,'´','Á');
    UPDATE phpbb_groups SET group_name = replace(group_name,'É','É');
    UPDATE phpbb_groups SET group_name = replace(group_name,'Ó','Ó');
    UPDATE phpbb_groups SET group_name = replace(group_name,'Ú','Ú');
    UPDATE phpbb_groups SET group_name = replace(group_name,'¡','¡');
    UPDATE phpbb_groups SET group_name = replace(group_name,'Ñ','Ñ');
    UPDATE phpbb_groups SET group_name = replace(group_name,'À','À');
    UPDATE phpbb_groups SET group_name = replace(group_name,'È','È');
    UPDATE phpbb_groups SET group_name = replace(group_name,'è','è');
    UPDATE phpbb_groups SET group_name = replace(group_name,'Ã’','Ò');
    UPDATE phpbb_groups SET group_name = replace(group_name,'ò','ò');
    UPDATE phpbb_groups SET group_name = replace(group_name,'Ã','í');

    UPDATE phpbb_groups SET group_desc = replace(group_desc,'ƒÂ','');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'á','á');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'é','é');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ã-','í');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'ó','ó');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'ó','ó');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'ú','ú');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'ñ','ñ');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'¿','¿');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'´','Á');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'É','É');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ó','Ó');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ú','Ú');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'¡','¡');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ñ','Ñ');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'À','À');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'È','È');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'è','è');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ã’','Ò');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'ò','ò');
    UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ã','í');

    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ƒÂ','');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'á','á');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'é','é');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ã-','í');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ó','ó');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ú','ú');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ñ','ñ');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'¿','¿');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'´','Á');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'É','É');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ó','Ó');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ú','Ú');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'¡','¡');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ñ','Ñ');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'À','À');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'È','È');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'è','è');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ã’','Ò');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ò','ò');
    UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ã','í');
       
    UPDATE phpbb_log SET log_data = replace(log_data,'ƒÂ','');
    UPDATE phpbb_log SET log_data = replace(log_data,'á','á');
    UPDATE phpbb_log SET log_data = replace(log_data,'é','é');
    UPDATE phpbb_log SET log_data = replace(log_data,'Ã-','í');
    UPDATE phpbb_log SET log_data = replace(log_data,'ó','ó');
    UPDATE phpbb_log SET log_data = replace(log_data,'ú','ú');
    UPDATE phpbb_log SET log_data = replace(log_data,'ñ','ñ');
    UPDATE phpbb_log SET log_data = replace(log_data,'¿','¿');
    UPDATE phpbb_log SET log_data = replace(log_data,'´','Á');
    UPDATE phpbb_log SET log_data = replace(log_data,'É','É');
    UPDATE phpbb_log SET log_data = replace(log_data,'Ó','Ó');
    UPDATE phpbb_log SET log_data = replace(log_data,'Ú','Ú');
    UPDATE phpbb_log SET log_data = replace(log_data,'¡','¡');
    UPDATE phpbb_log SET log_data = replace(log_data,'Ñ','Ñ');
    UPDATE phpbb_log SET log_data = replace(log_data,'À','À');
    UPDATE phpbb_log SET log_data = replace(log_data,'È','È');
    UPDATE phpbb_log SET log_data = replace(log_data,'è','è');
    UPDATE phpbb_log SET log_data = replace(log_data,'Ã’','Ò');
    UPDATE phpbb_log SET log_data = replace(log_data,'ò','ò');
    UPDATE phpbb_log SET log_data = replace(log_data,'Ã','í');

    UPDATE phpbb_moderator_cache SET username = replace(username,'ƒÂ','');
    UPDATE phpbb_moderator_cache SET username = replace(username,'á','á');
    UPDATE phpbb_moderator_cache SET username = replace(username,'é','é');
    UPDATE phpbb_moderator_cache SET username = replace(username,'Ã-','í');
    UPDATE phpbb_moderator_cache SET username = replace(username,'ó','ó');
    UPDATE phpbb_moderator_cache SET username = replace(username,'ú','ú');
    UPDATE phpbb_moderator_cache SET username = replace(username,'ñ','ñ');
    UPDATE phpbb_moderator_cache SET username = replace(username,'¿','¿');
    UPDATE phpbb_moderator_cache SET username = replace(username,'´','Á');
    UPDATE phpbb_moderator_cache SET username = replace(username,'É','É');
    UPDATE phpbb_moderator_cache SET username = replace(username,'Ó','Ó');
    UPDATE phpbb_moderator_cache SET username = replace(username,'Ú','Ú');
    UPDATE phpbb_moderator_cache SET username = replace(username,'¡','¡');
    UPDATE phpbb_moderator_cache SET username = replace(username,'Ñ','Ñ');
    UPDATE phpbb_moderator_cache SET username = replace(username,'À','À');
    UPDATE phpbb_moderator_cache SET username = replace(username,'È','È');
    UPDATE phpbb_moderator_cache SET username = replace(username,'è','è');
    UPDATE phpbb_moderator_cache SET username = replace(username,'Ã’','Ò');
    UPDATE phpbb_moderator_cache SET username = replace(username,'ò','ò');
    UPDATE phpbb_moderator_cache SET username = replace(username,'Ã','í');

    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ƒÂ','');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'á','á');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'á','á');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'é','é');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ã-','í');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ó','ó');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ú','ú');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ñ','ñ');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'¿','¿');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'´','Á');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ó','Ó');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ú','Ú');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'¡','¡');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ñ','Ñ');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'À','À');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'È','È');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'è','è');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ã’','Ò');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ò','ò');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ã','í');
    UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'€','€');

    UPDATE phpbb_posts SET post_subject = replace(post_subject,'ƒÂ','');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'á','á');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'é','é');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ã-','í');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'ó','ó');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'ú','ú');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'ñ','ñ');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'¿','¿');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'´','Á');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'É','É');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ó','Ó');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ú','Ú');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'©','©');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'¡','¡');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ñ','Ñ');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'À','À');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'È','È');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'è','è');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ã’','Ò');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'ò','ò');
    UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ã','í');



    UPDATE phpbb_posts SET post_text = replace(post_text,'ƒÂ','');
    UPDATE phpbb_posts SET post_text = replace(post_text,'á','á');
    UPDATE phpbb_posts SET post_text = replace(post_text,'é','é');
    UPDATE phpbb_posts SET post_text = replace(post_text,'Ã-','í');
    UPDATE phpbb_posts SET post_text = replace(post_text,'ó','ó');
    UPDATE phpbb_posts SET post_text = replace(post_text,'ú','ú');
    UPDATE phpbb_posts SET post_text = replace(post_text,'ñ','ñ');
    UPDATE phpbb_posts SET post_text = replace(post_text,'í±','ñ');
    UPDATE phpbb_posts SET post_text = replace(post_text,'¿','¿');
    UPDATE phpbb_posts SET post_text = replace(post_text,'´','Á');
    UPDATE phpbb_posts SET post_text = replace(post_text,'É','É');
    UPDATE phpbb_posts SET post_text = replace(post_text,'Ó','Ó');
    UPDATE phpbb_posts SET post_text = replace(post_text,'Ú','Ú');
    UPDATE phpbb_posts SET post_text = replace(post_text,'©','©');
    UPDATE phpbb_posts SET post_text = replace(post_text,'¡','¡');
    UPDATE phpbb_posts SET post_text = replace(post_text,'Ñ','Ñ');
    UPDATE phpbb_posts SET post_text = replace(post_text,'À','À');
    UPDATE phpbb_posts SET post_text = replace(post_text,'È','È');
    UPDATE phpbb_posts SET post_text = replace(post_text,'è','è');
    UPDATE phpbb_posts SET post_text = replace(post_text,'Ã’','Ò');
    UPDATE phpbb_posts SET post_text = replace(post_text,'ò','ò');
    UPDATE phpbb_posts SET post_text = replace(post_text,'Ã','í');



    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ƒÂ','');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'á','á');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'é','é');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ã-','í');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ó','ó');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ú','ú');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ñ','ñ');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'¿','¿');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'´','Á');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'É','É');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ó','Ó');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ú','Ú');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'¡','¡');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ñ','Ñ');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'À','À');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'È','È');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'è','è');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ã’','Ò');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ò','ò');
    UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ã','í');
       
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ƒÂ','');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'á','á');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'é','é');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ã-','í');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ó','ó');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ú','ú');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ñ','ñ');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'¿','¿');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'´','Á');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'É','É');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ó','Ó');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ú','Ú');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'¡','¡');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ñ','Ñ');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'À','À');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'È','È');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'è','è');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ã’','Ò');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ò','ò');
    UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ã','í');

    UPDATE phpbb_reports SET report_text = replace(report_text,'ƒÂ','');
    UPDATE phpbb_reports SET report_text = replace(report_text,'á','á');
    UPDATE phpbb_reports SET report_text = replace(report_text,'é','é');
    UPDATE phpbb_reports SET report_text = replace(report_text,'Ã-','í');
    UPDATE phpbb_reports SET report_text = replace(report_text,'ó','ó');
    UPDATE phpbb_reports SET report_text = replace(report_text,'ú','ú');
    UPDATE phpbb_reports SET report_text = replace(report_text,'ñ','ñ');
    UPDATE phpbb_reports SET report_text = replace(report_text,'¿','¿');
    UPDATE phpbb_reports SET report_text = replace(report_text,'´','Á');
    UPDATE phpbb_reports SET report_text = replace(report_text,'É','É');
    UPDATE phpbb_reports SET report_text = replace(report_text,'Ó','Ó');
    UPDATE phpbb_reports SET report_text = replace(report_text,'Ú','Ú');
    UPDATE phpbb_reports SET report_text = replace(report_text,'¡','¡');
    UPDATE phpbb_reports SET report_text = replace(report_text,'Ñ','Ñ');
    UPDATE phpbb_reports SET report_text = replace(report_text,'À','À');
    UPDATE phpbb_reports SET report_text = replace(report_text,'È','È');
    UPDATE phpbb_reports SET report_text = replace(report_text,'è','è');
    UPDATE phpbb_reports SET report_text = replace(report_text,'Ã’','Ò');
    UPDATE phpbb_reports SET report_text = replace(report_text,'ò','ò');
    UPDATE phpbb_reports SET report_text = replace(report_text,'Ã','í');

    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ƒÂ','');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'á','á');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'é','é');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ã-','í');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ó','ó');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ú','ú');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ñ','ñ');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'¿','¿');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'´','Á');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'É','É');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ó','Ó');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ú','Ú');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'¡','¡');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ñ','Ñ');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'À','À');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'È','È');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'è','è');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ã’','Ò');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ò','ò');
    UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ã','í');

    UPDATE phpbb_topics SET topic_title = replace(topic_title,'ƒÂ','');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'á','á');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'é','é');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ã-','í');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'ó','ó');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'ú','ú');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'ñ','ñ');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'¿','¿');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'´','Á');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'É','É');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ó','Ó');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ú','Ú');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'©','©');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'¡','¡');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ñ','Ñ');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'À','À');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'È','È');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'è','è');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ã’','Ò');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'ò','ò');
    UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ã','í');
       
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ƒÂ','');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'á','á');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'é','é');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ã-','í');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ó','ó');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ú','ú');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ñ','ñ');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'¿','¿');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'´','Á');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'É','É');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ó','Ó');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ú','Ú');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'¡','¡');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ñ','Ñ');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'À','À');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'È','È');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'è','è');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ã’','Ò');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ò','ò');
    UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ã','í');
       
    UPDATE phpbb_users SET user_sig = replace(user_sig,'ƒÂ','');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'á','á');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'é','é');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'Ã-','í');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'ó','ó');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'ú','ú');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'ñ','ñ');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'¿','¿');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'´','Á');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'É','É');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'Ó','Ó');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'Ú','Ú');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'¡','¡');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'Ñ','Ñ');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'À','À');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'È','È');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'è','è');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'Ã’','Ò');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'ò','ò');
    UPDATE phpbb_users SET user_sig = replace(user_sig,'Ã','í');

    UPDATE phpbb_users SET username = replace(username,'ƒÂ','');
    UPDATE phpbb_users SET username = replace(username,'á','á');
    UPDATE phpbb_users SET username = replace(username,'é','é');
    UPDATE phpbb_users SET username = replace(username,'Ã-','í');
    UPDATE phpbb_users SET username = replace(username,'ó','ó');
    UPDATE phpbb_users SET username = replace(username,'ú','ú');
    UPDATE phpbb_users SET username = replace(username,'ñ','ñ');
    UPDATE phpbb_users SET username = replace(username,'¿','¿');
    UPDATE phpbb_users SET username = replace(username,'ª','ª');
    UPDATE phpbb_users SET username = replace(username,'´','Á');
    UPDATE phpbb_users SET username = replace(username,'É','É');
    UPDATE phpbb_users SET username = replace(username,'Ó','Ó');
    UPDATE phpbb_users SET username = replace(username,'Ú','Ú');
    UPDATE phpbb_users SET username = replace(username,'¡','¡');
    UPDATE phpbb_users SET username = replace(username,'Ñ','Ñ');
    UPDATE phpbb_users SET username = replace(username,'À','À');
    UPDATE phpbb_users SET username = replace(username,'È','È');
    UPDATE phpbb_users SET username = replace(username,'è','è');
    UPDATE phpbb_users SET username = replace(username,'Ã’','Ò');
    UPDATE phpbb_users SET username = replace(username,'ò','ò');
    UPDATE phpbb_users SET username = replace(username,'Ã','í');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'ƒÂ','');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'á','á');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'é','é');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'Ã-','í');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'ó','ó');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'ú','ú');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'ñ','ñ');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'¿','¿');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'´','Á');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'À','Á');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'‰','É');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'Ó','Ó');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'Ú','Ú');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'¡','¡');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'Ñ','Ñ');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'À','À');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'È','È');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'è','è');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'Ã’','Ò');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'ò','ò');
    UPDATE phpbb_users SET username_clean = replace(username_clean,'Ã','í');

    UPDATE phpbb_styles SET style_copyright = replace(style_copyright,'©','©');


Fuente: phpbb-es.com

firma

Este es el lugar para tu firma

Personaliza tu perfil



Pc-teros Community - www.pc-teros.es
Arriba 
 Perfil  
 
Mostrar mensajes previos:  Ordenar por  
 
Nuevo tema Responder al tema  [ 1 mensaje ] 


¿Te fue util este tema?

Link:
BBcode:
HTML:


Temas Similares


Portal » Índice general » Zona Webmasters » Tutoriales Webmaster


Temas relacionados
 Temas   Autor   Comentarios   Vistas   Último mensaje 
No hay nuevos mensajes sin leer en este tema. Eliminar caracteres “extraños” de una cadena en PHP

blquack

1

921

22 Ene 2012 15:32

EseTecnico Ver último mensaje

No hay nuevos mensajes sin leer en este tema. Convertir caracteres raros, acento, etc, a HTML usando php

blquack

0

946

09 Sep 2012 15:49

blquack Ver último mensaje

No hay nuevos mensajes sin leer en este tema. ¿Cómo? Migrar de Foroactivo a PhpBB3

Megaenna

8

810

15 Dic 2010 20:50

Total13 Ver último mensaje

No hay nuevos mensajes sin leer en este tema. Es posible trasladar temas desde el ACP?

Megabyte

0

305

18 Mar 2011 21:11

Megabyte Ver último mensaje

No hay nuevos mensajes sin leer en este tema. Restaurar, trasladar base de datos de factucont

blquack

0

10091

17 Mar 2010 22:27

blquack Ver último mensaje

No hay nuevos mensajes sin leer en este tema. Adjunto(s) ¿Cómo? Migrar foro phpbb3 - cambio de directório

Megabyte

9

1714

06 Dic 2010 16:14

blquack Ver último mensaje

No hay nuevos mensajes sin leer en este tema. [Solución] ¿Tu Xbox 360 hace mucho ruido?

Megaenna

3

2223

16 May 2011 16:44

uruguayito Ver último mensaje

No hay nuevos mensajes sin leer en este tema. Solución de mensajes de errores de Malwarebytes Anti-Malwar

blquack

3

3130

07 Jul 2011 07:58

EseTecnico Ver último mensaje

No hay nuevos mensajes sin leer en este tema. Permitir mas caracteres en el título

blquack

4

524

21 Ago 2012 04:09

ale_hernand Ver último mensaje

Este tema está cerrado, no puede editar mensajes o enviar nuevas respuestas Bloque Patrocinadores tiene TOPE de caracteres...??????????

AlanWake360

5

241

15 Jul 2010 19:55

blquack Ver último mensaje

 


¿Quién está conectado?

Usuarios navegando por este Foro: No hay usuarios registrados visitando el Foro y 1 invitado

 
 

 
No puede abrir nuevos temas en este Foro
No puede responder a temas en este Foro
No puede editar sus mensajes en este Foro
No puede borrar sus mensajes en este Foro
No puede enviar adjuntos en este Foro

Buscar:
Saltar a:  
cron