kt81
/ gist:36887de8b13ea2dd7047
Created
February 25, 2015 07:56
SQLでhtmlspecialchars的な事をしようとしたことの名残
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE FUNCTION orig_htmlspecialchars(TEXT) RETURNS TEXT AS $$ | |
| SELECT | |
| regexp_replace( | |
| regexp_replace( | |
| regexp_replace( | |
| regexp_replace( | |
| regexp_replace($1, | |
| E'&(?!(?:#\\d+?|\\w+?);)', '&', 'g'), | |
| E'"', '"', 'g'), | |
| E'''', ''', 'g'), |
kt81
/ .gitignore
Created
September 5, 2019 06:58
All-In-One .gitignore for Unity + .NET Core Server development
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ## Ignore Visual Studio temporary files, build results, and | |
| ## files generated by popular Visual Studio add-ons. | |
| # User-specific files | |
| *.suo | |
| *.user | |
| *.userosscache | |
| *.sln.docstates | |
| # User-specific files (MonoDevelop/Xamarin Studio) |
kt81
/ .gitattributes
Last active
July 15, 2020 08:47
Git attributes file for Unity3D & .NET server development
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Global Settings | |
| * text=auto | |
| # Language | |
| *.php text eol=lf | |
| *.cs text eol=lf | |
| *.tt text eol=lf | |
| *.js text eol=lf | |
| *.ts text eol=lf | |
| *.tsx text eol=lf |