View Single Post
  #1  
Old 25 Jul 2017, 00:18
GHRake GHRake is offline
 
Join Date: Sep 2015
Real name: Anomander Rake
Useful SQL Queries

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
Reply With Quote