James Khoury JamesKhoury
JamesKhoury
/ geekkoder.html
Created Jul 10, 2019
— forked from charlycoste/geekkoder.html
a Geek code decoder
View geekkoder.html
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> | |
| <html xmlns="http://www.w3.org/1999/xhtml"> | |
| <head> | |
| <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> | |
| <title>Geek Koder</title> | |
| <script> | |
| /** | |
| * @description Geek Code Decoder (originally written Extension for Firefox ) | |
| * @author Bhasker V Kode | |
| * @date hacked up in the early hours of Feb 23,2007 . |
JamesKhoury
/ umbraco db cleanup.sql
Created Sep 20, 2016
— forked from dampee/umbraco db cleanup.sql
Umbraco Database cleanup. After pulling in an umbraco database from production, you don't need all history or log.
View umbraco db cleanup.sql
| -- dump logs | |
| truncate table umbracolog | |
| -- Umbraco Clear Old Document Versions To Decrease Database Size And Improve Performance | |
| -- http://borism.net/2008/12/16/fixing-a-large-cmspropertydata-table-in-umbraco/ | |
| DECLARE @createdDate Datetime = DATEADD(m, -1, getdate()) | |
| DELETE FROM cmsPropertyData WHERE | |
| versionId NOT IN (SELECT versionId FROM cmsDocument WHERE updateDate > @createdDate OR published = 1 OR newest = 1) AND | |
| contentNodeId IN (SELECT DISTINCT nodeID FROM cmsDocument) |