Skip to content

Instantly share code, notes, and snippets.

@t3easy

t3easy/mh_code_highlighter-to-fs_code_snippet.sql

Created January 8, 2016 15:02
Show Gist options
  • Save t3easy/db739dda316d3e1f9967 to your computer and use it in GitHub Desktop.
Save t3easy/db739dda316d3e1f9967 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mh_code_highlighter-to-fs_code_snippet.sql
UPDATE `tt_content` SET `bodytext` = `tx_mhcodehighlighter_geshi_code` WHERE `list_type` = 'mh_code_highlighter_pi1';
UPDATE `tt_content` SET `CType` = 'fs_code_snippet' WHERE `list_type` = 'mh_code_highlighter_pi1';
UPDATE `tt_content` SET `list_type` = '' WHERE `CType` = 'fs_code_snippet';
UPDATE `tt_content` SET `programming_language` = 'typoscript' WHERE `CType` = 'fs_code_snippet' AND `tx_mhcodehighlighter_geshi_lang` = 'typoscript.php';
UPDATE `tt_content` SET `programming_language` = 'bash' WHERE `CType` = 'fs_code_snippet' AND `tx_mhcodehighlighter_geshi_lang` = 'bash.php';
UPDATE `tt_content` SET `programming_language` = 'javascript' WHERE `CType` = 'fs_code_snippet' AND `tx_mhcodehighlighter_geshi_lang` = 'javascript.php';
UPDATE `tt_content` SET `programming_language` = 'php' WHERE `CType` = 'fs_code_snippet' AND `tx_mhcodehighlighter_geshi_lang` = 'php.php';
UPDATE `tt_content` SET `programming_language` = 'html' WHERE `CType` = 'fs_code_snippet' AND `tx_mhcodehighlighter_geshi_lang` = 'html4strict.php';
UPDATE `tt_content` SET `programming_language` = 'xml' WHERE `CType` = 'fs_code_snippet' AND `tx_mhcodehighlighter_geshi_lang` = 'xml.php';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment