Visualizzare HTML dopo conversione snitz>phpbb2>phpbb3

[GIANLUCA1989]

Grazie mille mi interesserebbe una cosa del genere..
visto che il tuo caso è simile ti sei trovato anche te in quest'altra condizione
http://www.phpbbitalia.net/forum/forum- ... t6879.html
se si potresti rispondermi dall'altra parte.... questo è un altro grande dilemma che si verificato dopo la conversione
gian

[tronikx]

perdonami... mi ero scordato di te!
mi rendo conto che è lunghetto, ma...

Codice: Seleziona tutto

   - - - CORREZIONE QUOTE - - -

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "*", "rrrrrrrrrrrrrrrr11111111111111111")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, """", "*")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<blockquote id=*quote*><font size=*1* face=*Verdana, Arial, Helvetica* id=*quote*>Citazione:<hr height=*1* noshade id=*quote*><i>Messaggio inserito da ", " [quote="")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</i>
<br />", "":3beawgqx:3beawgqx] ")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</i>", "":3beawgqx:3beawgqx] ")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<blockquote id=*quote*><font size=*1* face=*Verdana, Arial, Helvetica* id=*quote*>Citazione:<hr height=*1* noshade id=*quote*>", "[quote:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<hr height=*1* noshade id=*quote*></blockquote id=*quote*></font id=*quote*>", " [/quote:3beawgqx:3beawgqx] ")) ;

   - - - inizio correzione smile - - -

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[:)]", "<!-- s[:)] --><img src=*{SMILIES_PATH}/smile.gif* alt=*[:)]* title=*risata* /><!-- s[:)] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[;)]", "<!-- s[;)] --><img src=*{SMILIES_PATH}/wink.gif* alt=*[;)]* title=*wink* /><!-- s[;)] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[:D]", "<!-- s[:D] --><img src=*{SMILIES_PATH}/biggrin2.gif* alt=*[:D]* title=*risata* /><!-- s[:D] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[8D]", "<!-- s[8D] --><img src=*{SMILIES_PATH}/cool.gif* alt=*[8D]* title=*figo* /><!-- s[8D] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[:p]", "<!-- s[:p] --><img src=*{SMILIES_PATH}/drool.gif* alt=*[:p]* title=*sbava* /><!-- s[:p] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[:I]", "<!-- s[:I] --><img src=*{SMILIES_PATH}/blushing.gif* alt=*[:I]* title=*arrossito* /><!-- s[:I] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[}:)]", "<!-- s[}:)] --><img src=*{SMILIES_PATH}/dev.gif* alt=*[}:)]* title=*risata* /><!-- s[}:)] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[:o)]", "<!-- s[:o)] --><img src=*{SMILIES_PATH}/bleh.gif* alt=*[:o)]* title=*pernacchia* /><!-- s[:o)] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[:(]", "<!-- s[:(] --><img src=*{SMILIES_PATH}/sad.gif* alt=*[:(]* title=*triste* /><!-- s[:(] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[8]", "<!-- s[8] --><img src=*{SMILIES_PATH}/icon_smile_8ball.gif* alt=*[8]* title=*palla* /><!-- s[8] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[B)]", "<!-- s[B)] --><img src=*{SMILIES_PATH}/sweatdrop.gif* alt=*[B)]* title=*suda* /><!-- s[B)] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[8)]", "<!-- s[:I] --><img src=*{SMILIES_PATH}/blushing.gif* alt=*[:I]* title=*arrossito* /><!-- s[:I] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[:0]", "<!-- s[:0] --><img src=*{SMILIES_PATH}/eek.gif* alt=*[:0]* title=*incredulo* /><!-- s[:0] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[:(!]", "<!-- s[:(!] --><img src=*{SMILIES_PATH}/mad.gif* alt=*[:(!]* title=*arrabbiato* /><!-- s[:(!] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[|)]", "<!-- s[|)] --><img src=*{SMILIES_PATH}/sleep1.gif* alt=*[|)]* title=*sonno* /><!-- s[|)] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[?]", "<!-- s[?] --><img src=*{SMILIES_PATH}/confused1.gif* alt=*[?]* title=*???* /><!-- s[?] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[V]", "<!-- s[V] --><img src=*{SMILIES_PATH}/omino_mento.gif* alt=*[V]* title=*mmm* /><!-- s[V] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[^]", "<!-- s[^] --><img src=*{SMILIES_PATH}/happy.gif* alt=*[^]* title=*compiaciuto* /><!-- s[^] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[:X]", "<!-- s[:X] --><img src=*{SMILIES_PATH}/wub.gif* alt=*[:X]* title=*wub* /><!-- s[:X] -->")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[xx(]", "<!-- s[xx(] --><img src=*{SMILIES_PATH}/icon_smile_dead.gif* alt=*[xx(]* title=*ops* /><!-- s[xx(] -->")) ;

   - - - fine correzione smile - - -

   - - - inizio correzione bold - - -

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<b>", "[b:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</b>", "[/b:3beawgqx:3beawgqx]")) ;

   - - - fine correzione bold - - -

   - - - eliminazione [i] - - -

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[i]", "")) ;

   - - - eliminazione [i] - - -

   - - - eliminazione [u] - - -

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[u]", "")) ;

   - - - eliminazione [u] - - -

   - - - eliminazione <br /> - - -

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<br />", "")) ;

   - - - eliminazione <br /> - - -

   - - - inizio adattamento img - - -

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[img]", "[img:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[img:3beawgqx:3beawgqx]/Redipuglia/", "
[img:3beawgqx:3beawgqx]http&#58;//www&#46;discusfriends&#46;org/Redipuglia/")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[/img]", "[/img:3beawgqx:3beawgqx]
")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[img:3beawgqx:3beawgqx]/redipuglia/", "
[img:3beawgqx:3beawgqx]http&#58;//www&#46;discusfriends&#46;org/redipuglia/")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[img:3beawgqx:3beawgqx]redipuglia/", "
[img:3beawgqx:3beawgqx]http&#58;//www&#46;discusfriends&#46;org/redipuglia/")) ;

   - - - fine adattamento img - - -

   - - - inizio adattamento url - - -

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[url]", "[url:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[url=*", "[url=")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "*]", ":3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[/url]", "[/url:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[url=/Redipuglia/", "[url=http&#58;//www&#46;discusfriends&#46;org/Redipuglia/")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "immagini/icon_paperclip.gif", "http&#58;//www&#46;discusfriends&#46;org/forum/immagini/icon_paperclip.gif")) ;

   - - - fine adattamento url - - -

   - - - inizio adattamento dimensioni carattere - - -

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font size=*1*>", "[size=50:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*size1*>", "[/size:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font size=*2*>", "[size=80:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*size2*>", "[/size:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font size=*3*>", "[size=100:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*size3*>", "[/size:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font size=*4*>", "[size=130:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*size4*>", "[/size:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font size=*5*>", "[size=165:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*size5*>", "[/size:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font size=*6*>", "[size=200:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*size6*>", "[/size:3beawgqx:3beawgqx]")) ;

   - - - fine adattamento dimensioni carattere - - -

   - - - inizio adattamento colori - - -

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*black*>", "[color=#000000:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*black*>", "[/color:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*red*>", "[color=#FF0000:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*red*>", "[/color:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*yellow*>", "[color=#FFFF00:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*yellow*>", "[/color:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*green*>", "[color=#008000:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*green*>", "[/color:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*orange*>", "[color=#FFBF00:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*orange*>", "[/color:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*purple*>", "[color=#8040BF:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*purple*>", "[/color:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*blue*>", "[color=#0000FF:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*blue*>", "[/color:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*beige*>", "[color=#FFFFFF:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*beige*>", "[/color:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*brown*>", "[color=#800000:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*brown*>", "[/color:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*teal*>", "[color=#008080:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*teal*>", "[/color:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*navy*>", "[color=#0040BF:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*navy*>", "[/color:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*maroon*>", "[color=#400000:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*maroon*>", "[/color:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "<font color=*limegreen*>", "[color=#80FF80:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts SET post_text=(REPLACE(post_text, "</font id=*limegreen*>", "[/color:3beawgqx:3beawgqx]")) ;

   - - - fine adattamento colori - - -

   - - - inizio adattamento smile censura - - -

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "[:204]", "<!-- s[:204] --><img src=*{SMILIES_PATH}/censored2.gif* alt=*[:204]* title=*censura* /><!-- s[:204] -->")) ;

   - - - fine adattamento smile censura - - -

   - - - inizio adattamento caratteri - - -

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Comic Sans MS*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Comic Sans MS*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Andale Mono*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Andale Mono*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Arial*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Arial*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Arial Black*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Arial Black*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Book Antiqua*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Book Antiqua*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Century Gothic*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Century Gothic*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Georgia*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Georgia*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Impact*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Impact*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Script MT Bold*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Script MT Bold*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Stencil*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Stencil*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Tahoma*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Tahoma*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Times New Roman*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Times New Roman*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Trebuchet MS*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Trebuchet MS*>", "[/i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "<font face=*Verdana*>", "[i:3beawgqx:3beawgqx]")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "</font id=*Verdana*>", "[/i:3beawgqx:3beawgqx]")) ;

   - - - fine adattamento caratteri - - -


UPDATE phpbb_posts set post_text=(REPLACE(post_text, "*", """")) ;

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "rrrrrrrrrrrrrrrr11111111111111111", "*")) ;

UPDATE `phpbb_posts` SET `bbcode_bitfield` = '/8A='

UPDATE phpbb_posts set post_text=(REPLACE(post_text, "3beawgqx:3beawgqx", `bbcode_uid`)) ;

   - - - FINE CORREZIONE QUOTE - - -

   - - - inizio correzione autori topic - - -

 copiare in phpbb tabelle snitz forum_topics e forum_members con mysqldumper

Update PHPBB_TOPICS, FORUM_TOPICS set PHPBB_TOPICS.TOPIC_POSTER = FORUM_TOPICS.T_AUTHOR where FORUM_TOPICS.T_SUBJECT=PHPBB_TOPICS.TOPIC_TITLE;

update PHPBB_TOPICS, FORUM_MEMBERS set PHPBB_TOPICS.TOPIC_FIRST_POSTER_NAME = FORUM_MEMBERS.M_NAME where PHPBB_TOPICS.TOPIC_POSTER = FORUM_MEMBERS.MEMBER_ID

UPDATE `PHPBB_TOPICS` SET `topic_first_poster_colour` = ''

UPDATE `PHPBB_TOPICS` SET `topic_first_poster_colour` = '00AA00'
where (PHPBB_TOPICS.topic_first_poster_name = "Massimiliano Lucarelli")
OR (PHPBB_TOPICS.topic_first_poster_name = "Federico")
OR (PHPBB_TOPICS.topic_first_poster_name = "Gex")
OR (PHPBB_TOPICS.topic_first_poster_name = "mdl")
OR (PHPBB_TOPICS.topic_first_poster_name = "redipuglia")
OR (PHPBB_TOPICS.topic_first_poster_name = "Rinaldo")
OR (PHPBB_TOPICS.topic_first_poster_name = "stefanokirk")
OR (PHPBB_TOPICS.topic_first_poster_name = "Tronikx")

UPDATE `PHPBB_TOPICS` SET `topic_first_poster_colour` = 'AA0000'
where (PHPBB_TOPICS.topic_first_poster_name = "admin")
OR (PHPBB_TOPICS.topic_first_poster_name = "xeronimox")
OR (PHPBB_TOPICS.topic_first_poster_name = "tottifan")

 cancellare da phpbb tabelle forum_topics e forum_members

   - - - fine correzione autori topic - - -

   - - - inizio correzione avatar - - -

UPDATE `phpbb_users` SET `user_avatar` = '';

   - - - fine correzione avatar - - -

   - - - inizio correzione firme post - - -

UPDATE `phpbb_posts` SET `enable_sig` = '1';

   - - - fine correzione firme post - - -