smf - phpbb

[[Unknown]]

Code Select Expand

Decided to post a few shots of our garden before it gets to big or to dry.

Here's the crop area.

<!--EZCODE IMAGE START--><img src="http://howardsdesigns.com/images/skosh/Garden%20(4)%20(Small).jpg"/><!--EZCODE IMAGE END-->

<p>                  >^..^< If at first you don't succeed, destroy all evidence that you ever tried. </p><i>Edited by: <A HREF=http://p196.ezboard.com/bintothenight.showUserPublicProfile?gid=skosh@intothenight>Skosh</A> at: 5/27/05 11:32 pm
</i>

Hmm.. okay, try this query:

UPDATE smf_messages
SET body = REPLACE(REPLACE(REPLACE(body, '<img src=&quot;', '<img src="'), '&quot;/>', '" alt="" />'), '<br>', '<br />');

What is phpMyAdmin?  What else is wrong, after that?

I'm using SMF 1.0.5.

That's all I wanted to know .

-[Unknown]

[JohnnyVW]

Hmm.. okay, try this query:

UPDATE smf_messages
SET body = REPLACE(REPLACE(REPLACE(body, '<img src=&quot;', '<img src="'), '&quot;/>', '" alt="" />'), '<br>', '<br />');

What is phpMyAdmin?  What else is wrong, after that?

I'm using SMF 1.0.5.

That's all I wanted to know .

-[Unknown]

Very Cool!!!  OK, I ran the query and most came out OK.  There are a few spots that didn't come out right...

Linked text and linked images (I think mostly at the bottom of each post) aren't working right.  Also, Pictures in some other areas aren't coming out.  I know that on some that there are broken links, but in others the pictures show up on the phpbb side...

Here are two examples of the same topic:

SMF [nofollow]
phpbb [nofollow]

Here is the code from the smf board when I go to modify the first post:

Code Select Expand

I thought that I should start a new thread and not crash the other one.  <!--EZCODE EMOTICON START :\ --><img src=http://www.ezboard.com/images/emoticons/ohwell.gif ALT=":\"><!--EZCODE EMOTICON END-->  <!--EZCODE EMOTICON START :lol --><img src=http://www.ezboard.com/images/emoticons/laugh.gif ALT=":lol"><!--EZCODE EMOTICON END-->

Johnny and I had to get up really early, so we took some pictures of the sunrise this morning, and they were so <!--EZCODE ITALIC START--><em>unbelievably</em><!--EZCODE ITALIC END--> glorious, we wanted to share them with all of you.  Trouble is, we had to limit <!--EZCODE ITALIC START--><em><!--EZCODE BOLD START--><strong>all</strong><!--EZCODE BOLD END--></em><!--EZCODE ITALIC END--> of them to <!--EZCODE ITALIC START--><em>just</em><!--EZCODE ITALIC END--> three ~ so you'll have to use your imagination for the rest.  <!--EZCODE EMOTICON START ;) --><img src=http://www.ezboard.com/images/emoticons/wink.gif ALT=";)"><!--EZCODE EMOTICON END-->

Sunrise in Costa Mesa, January 3, 2003...

<!--EZCODE IMAGE START--><img src="http://home.earthlink.net/~raven708/Images5/Sunrise_5A.jpg" style="border:0;" alt="" /><!--EZCODE IMAGE END-->

<p></p><i></i>


I think it'd come out great if I could get rid of those stupid EZBoard comments! 

Thanks [Unknown]!

[[Unknown]]

Try this:

UPDATE smf_messages
SET body = REPLACE(REPLACE(REPLACE(body, '&quot; style=&quot;border:0;"', '" style="border: 0;"'), '<a href=&quot;', '<a href="'), '&quot;>', '">');

Quoting/modifying those posts may be more complicated :/.

-[Unknown]

[JohnnyVW]

WOOOHOOO!!!!

Thank you very much, [Unknown]!!!

I'm not concerned about quoting or modifying those posts.  They are archives of our old board and just want them to be able to be read.  When we really go live, I'm making all of those threads and posts "read-only."

I checked out a few other places on the board and this worked. 

Once again, thanks!!!