vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   sql help needed (https://vborg.vbsupport.ru/showthread.php?t=178277)

Meatshield 05-06-2008 06:04 AM

sql help needed
 
I currently have loads of posts wrapped it code tags
ie:
HTML Code:

[code]post[/code]
I have just installed a hide mod and want to have all the older posts wrapped in code tags hidden aswell
so there like this:
HTML Code:

[hide][ code]post[/ code][/hide]
Is there a way to insert the hide code via an sql quiry rather than having to edit everypost 1 by 1?

Farcaster 05-06-2008 04:29 PM

If you are going to want the code tag to always be encapsulated by the hide tag, perhaps you might modify the code tag? But, yes, you could use the mySQL replace function to update the posts.

Here's the code you would probably use (untested, so use at your own risk and backup your data):

[sql]UPDATE post
SET pagetext = REPLACE(REPLACE(REPLACE(REPLACE(pagetext,'
Code:

','[HIDE]

       
Code:

       
'),'

','

[/HIDE]'),'
Code:

','[hide]

       
Code:

       
'),'

','

[/hide]')
WHERE pagetext LIKE '%
Code:

%' AND pagetext LIKE '%
%';[/sql]

Note that the mySQL replace function is case sensitive, so this will replace anything that is either tagged in all uppercase or all lower case. It will not find tags with mixed case...

Because vBulletin stores a cache of parsed posts, you'll most likely need to clear this cache before you see the posts updated. You can do that by executing this SQL:

[SQL]TRUNCATE TABLE postparsed;[/SQL]

Following that you can rebuild the post cache if you wish or let it rebuild on its own. If you want to rebuild it, in the AdminCP goto Maintenance -> Update Counters -> Rebuild Post Cache


EDIT: That's annoying... Note that vBulletin automatically lowered the capitilzation in that SQL query to "prevent shouting." So, when you execute it, be sure to make the first 4 instances of the word "code" uppercase.

Meatshield 05-06-2008 09:14 PM

It worked great many thanks :D

Farcaster 05-06-2008 09:54 PM

No trouble at all.


All times are GMT. The time now is 10:08 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00980 seconds
  • Memory Usage 1,717KB
  • 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
  • (5)bbcode_code_printable
  • (2)bbcode_html_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