Cleaning out an improperly uninstalled mod

I recently installed, and subsequently uninstalled, DJ's AME because of various reasons. Unfortunately, even though i ran the cleanup tools with the plugin it left behind a ton of artifacts in old posts.

All of my old Youtube video links (which were previously just the YT URL) now look like so:

[ame="http://www.youtube.com/watch?v=6fOprNSFCX4"]Title of Video[/ame]

And since I don't have an AME code, they just parse as plain text. Is there a quick and simple way to clean these up across my forum? I'd like to remove the bold bits, and just leave the URL behind. Bonus points if the URL is still parsed correctly so that it's click-able.

[ame="ht tp://w ww.youtube.com/watch?v=6fOprNSFCX4"]Title of Video

I've attached a screenshot of how it's looking on my forum at present. Any insight would be awesome. Thanks!

[kh99]

Unfortunately I don't think there's any regular expression replacement in mysql, so you'd have to write a script, or maybe export the post table to a text file, do a replacement on it in an editor or something (maybe by a command line tool in linux), then import it again. But I did figure out a pattern, I think, so in a vbulletin php script it would be something like:

PHP Code:

$posts = $vbulletin->db->query_read("SELECT postid, pagetext FROM ".TABLE_PREFIX."post WHERE pagetext LIKE '%[ame%' ");
while ($post = $vbulletin->db->fetch_array($posts))
{
   if (($new_pagetext = preg_replace('/\[ame="(.*?)"].*?\[\/ame]/i', '[url]$1[/url]', $post['pagetext'])) != NULL &&
         $new_pagetext !== $post['pagetext'])
   {
      $vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."post SET pagetext='".$vbulletin->db->escape_string($new_pagetext)."' WHERE postid={$post['postid']} ");
   }
} 


[kh99]

OK, I decided to test it in a plugin, so I thought I might as well export it and post it here. You would take this xml file and use Plugins & Products > Download/ Upload Plugins, and scroll to the bottom for the upload form. Then you'd point your browser at misc.php?do=fixame and see what happens. I tried to echo dots but it might not work, so you might see nothing for a long time if you have a lot of posts. You only need to do it once (assuming it doesn't timeout or stop because of an error) then uninstall it.

You should probably close your forum and backup your database before running this.

I'll give that a shot, thank you VERY much! It rewrote all of my Amazon URLs too (ugh).

If this works, I'll PM you and paypal you some cash to grab a burrito on me. I make a decent chunk of change from my Amazon affiliated links, and AME broke them all.

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

That worked! Thank you so much dude!