Help with cleaner.php (REGEX)

[The Dawg]

I need to replace an outdated mods text in posts.

Old code example:

[ame="http://www.youtube.com/watch?v=wYJ20INbM7Q"]YouTube - ‪Bill O'Reilly Interviews Rapper Lupe Fiasco - 06/20/11‬‏[/ame]

How I want the new code to look:

[video=youtube;wYJ20INbM7Q]http://www.youtube.com/watch?v=wYJ20INbM7Q[/video]

Regex I was given by a coder:

$text = preg_replace('|\[ame="http://www.youtube.com/watch\?v=([a-z0-9]+)"\](.+)|i', '[video=youtube;$1]http://www.youtube.com/watch?v=$1[/video]', $text);

I do not know where to put this in cleaner.php

I put it here:

PHP Code:

// BACK UP YOUR DATABASE
$replacer = array(
$text = preg_replace('|\[ame="http://www.youtube.com/watch\?v=([a-z0-9]+)"\](.+)|i',
'[video=youtube;$1]http://www.youtube.com/watch?v=$1[/video]', $text) 
);

// BACK UP YOUR DATABASE 


and it does nothing.

Please tell me how to execute this code.

Thanks

[BirdOPrey5]

What is cleaner.php? Where did you get it from?

[The Dawg]

Originally Posted by BirdOPrey5

What is cleaner.php? Where did you get it from?

Cleaner.php is the impex/tools/ folder for Vbulletin.

[BirdOPrey5]

Originally Posted by The Dawg

I need to replace an outdated mods text in posts.

Old code example:

[ame="http://www.youtube.com/watch?v=wYJ20INbM7Q"]YouTube - ‪Bill O'Reilly Interviews Rapper Lupe Fiasco - 06/20/11‬‏[/ame]

How I want the new code to look:

[video=youtube;wYJ20INbM7Q]http://www.youtube.com/watch?v=wYJ20INbM7Q[/video]

Regex I was given by a coder:

$text = preg_replace('|\[ame="http://www.youtube.com/watch\?v=([a-z0-9]+)"\](.+)|i', '[video=youtube;$1]http://www.youtube.com/watch?v=$1[/video]', $text);

I do not know where to put this in cleaner.php

I put it here:

PHP Code:

// BACK UP YOUR DATABASE
$replacer = array(
$text = preg_replace('|\[ame="http://www.youtube.com/watch\?v=([a-z0-9]+)"\](.+)|i',
'[video=youtube;$1]http://www.youtube.com/watch?v=$1[/video]', $text) 
);

// BACK UP YOUR DATABASE 


and it does nothing.

Please tell me how to execute this code.

Thanks

You find this in cleaner.php

PHP Code:

        #$text = preg_replace('##siU', '', $text); 


Change it to this:

PHP Code:

        $text = preg_replace('#[ame="http://www.youtube.com/watch\?v=([a-z0-9]+)"\](.+)|#siU', '[video=youtube;$1]http://www.youtube.com/watch?v=$1[/video]', $text); 


Try that. Make sure you have a backup though, I couldn't test this.

[The Dawg]

Got some progress. :up:

(I am running this on a test database to get the syntax right)

Cleaner ran but I got the error:

Warning: preg_replace(): Compilation failed: unmatched parentheses at offset 48

I looked at the test thread and it deleted the string I want to replace but it did not replace it ( due to the error )

So if I can get the code correct it should work.

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

Success!

Here is the regex pattern that worked:

$text = preg_replace('|\[ame="http://www.youtube.com/watch\?v=([a-z0-9]+)"\](.+)|i', '[video=youtube;$1]http://www.youtube.com/watch?v=$1[/video]', $text);

[BirdOPrey5]

I took another look at the code, I think there were a couple typos-

try this line:

    $text = preg_replace('#\[ame="http://www.youtube.com/watch\?v=([a-z0-9]+)"\](.+)#siU', '[video=youtube;$1]http://www.youtube.com/watch?v=$1[/video]', $text);