Trying to fix QUOTES from Invision import

[pattycake]

well, yes, I do... i copied them straight from the invision table into the posts table of vbulletin.

In the Invision table, it was ibf_posts, column name post
In the vbulletin table, it is vb_kt_post, column name pagetext

I know... bad move to do a direct copy but I did it so now I have a mess to clean up.

--------------- Added [DATE]1389560223[/DATE] at [TIME]1389560223[/TIME] ---------------

I went inside the Invision code, in a program called post_parser.php

In that code, I found the following:

$txt = preg_replace( "#<!--QuoteBegin-->(.+?)<!--QuoteEBegin-->#"                , '[QUOTE]'         , $txt );
$txt = preg_replace( "#<!--QuoteBegin-{1,2}([^>]+?)\+([^>]+?)-->(.+?)<!--QuoteEBegin-->#"  , "[QUOTE=\\1,\\2]" , $txt );
$txt = preg_replace( "#<!--QuoteBegin-{1,2}([^>]+?)\+-->(.+?)<!--QuoteEBegin-->#"       , "[QUOTE=\\1]" , $txt );

there's another line for QuoteEEnd but it won't paste into the code above

I think this is the key to a correct conversion.

--------------- Added [DATE]1389562663[/DATE] at [TIME]1389562663[/TIME] ---------------

I got it... I used that exact code that was in the post_parser.php and, it converted it clean as a whistle... removed all the TABLE stuff, TD stuff, etc, and made it work as vbulletin expects.

Case Closed,
Ticket-be-gone
We-be-happy

-pat-

--------------- Added [DATE]1389593985[/DATE] at [TIME]1389593985[/TIME] ---------------

Well crud... I [thought] I had it... the quotes are definitely fixed, but now I have another friggin preg_replace statement

here is what needs to be converted:

<img src='http://img2.timg.co.il/forums/1_172631546.JPG' border='0' alt='user posted image' />

here is my preg-replace:

$txt = preg_replace( "#<img src=[\"'](\S+?)['\"].+?".">#"           , "\[IMG\]\\1\[/IMG\]"

and here is what it renders:

[IMG]'http://img2.timg.co.il/forums/1_172631546.JPG[/IMG]

Notice that apostrophe right after the first ] just before the http?
If I get rid of that booger, it'll be clean.

Teach me, guide me Grasshopper...

.