Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 25 Jul 2017, 01: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
Reply


Tags
mysql, sql queries


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 04:49.

Layout Options | Width: Wide Color: