This function can be used for various tasks but I happen to use it to make product keys cleaner or easier to read. Before: ABCDEFGHIJKLMNOPQRSTUVWXY After: ABCDE-FGHIJ-KLMNO-PQRST-UVWXY
Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
MySQL to MSSQL Data Conversion
Ever have to take a MySQL database and put it in Microsoft SQL? This is a MySQL dump script that will assist you in this conversion. Only problem that I’ve had with it is that you need to review the exported SQL and make sure your version of Microsoft SQL…
WordPress Change URL – MySQL – Update String Within Column
Recently I changed a domain alias for a WordPress site and needed to change the domain in all the pages/posts and this little script came in handy. Typical disclaimer stands, do a full backup before running this and verify you have everything setup correctly. If you have a network site…
MSSQL Format U.S. Phone Number
If you have to sanitize your field first it gets ugly but is still possible Reference: http://www.sqlservercurry.com/2010/11/format-phone-numbers-in-sql-server.html
Uninstall Application
First step is to get the application information Either option will display information similar to this To uninstall this application can be done with either query but essentially is like this
Ektron – User Access List
Similar to Ektron SQL – List All Users If you simply need a list of all of your CMS users whether they are admin or otherwise this script will help If you want to show a break down of the groups that each user is in this script will help