vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=325436

Useful SQL Queries
by GHRake
25 Jul 2017 00:18

Here is just a list of useful mysql queries I've saved over the years and I thought others might find them useful as well. Warning: If you aren't experienced with SQL and modifying databases you must be extremely careful what you do and always make a backup first.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

And this one is a doozy. Some old imported posts include this whacky quote tag:
[quote author=Sleinzel link=topic=73.msg304#msg304 date=1337956060]

To replace them with vbulletin quote tags you run this query:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

For the latest updates to my list you can visit my bitbucket snippet page


All times are GMT. The time now is 20:57.

Powered by vBulletin® Version 3.8.14
Copyright © 2021, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.