vb.org Archive - Cleaning out an improperly uninstalled mod

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Cleaning out an improperly uninstalled mod (https://vborg.vbsupport.ru/showthread.php?t=317851)

Guest210212002

03-19-2015 12:26 PM

Cleaning out an improperly uninstalled mod

1 Attachment(s)

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:

Code:

[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.

Code:

[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	03-19-2015 08:03 PM

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	03-19-2015 08:11 PM

1 Attachment(s)

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.

Guest210212002

03-20-2015 10:14 PM

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. :D 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!

All times are GMT. The time now is 03:18 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01035 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: