Skip to content

Instantly share code, notes, and snippets.

@auycro
auycro / Hello1.html
Last active August 27, 2018 11:30
Test A-frame
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Hello, WebVR! • A-Frame</title>
<meta name="description" content="Hello, WebVR! • A-Frame">
<script src="https://aframe.io/releases/0.8.2/aframe.min.js"></script>
</head>
<body>
@auycro
auycro / ConvertSHIFT_JISToUTF8.cs
Created August 2, 2018 13:22
Convert SHIFT-JIS To UTF8
//---Created by Gumpanat Keardkeawfa on 2018Aug02.---
//---Copyright © 2018 Auycro. All rights reserved.---
using System.IO;
using System.Text;
namespace ConsoleApp1
{
class Program
{
@auycro
auycro / tasks.json
Created October 27, 2017 06:46
VSCODE output japanese 出力 日本語
{
"author": "Gumpanat Keardkeawfa",
"version": "0.1.0",
"command": "cmd",
"isShellCommand": true,
"args": [],
"tasks": [
{
"taskName": "build",
"args": [
@auycro
auycro / JS-LINQ.js
Created October 24, 2017 02:17 — forked from DanDiplo/JS-LINQ.js
JavaScript equivalents of some common C# LINQ methods. To help me remember!
// JS array equivalents to C# LINQ methods - by Dan B.
// Here's a simple array of "person" objects
var people = [
{ name: "John", age: 20 },
{ name: "Mary", age: 35 },
{ name: "Arthur", age: 78 },
{ name: "Mike", age: 27 },
{ name: "Judy", age: 42 },
{ name: "Tim", age: 8 }
@auycro
auycro / mrtg-setting.bash
Created May 29, 2017 07:30
MRTG + SNMP Setting
snmpwalk -v 2c -c public 192.168.xx.xxx 1
cfgmaker [email protected].xx.xxx > /var/www/mrtg/192.168.xx.xxx.cfg
vi /var/www/mrtg/192.168.xx.xxx.cfg
env LANG=C /usr/bin/mrtg /var/www/mrtg/192.168.xx.xxx.cfg
env LANG=C /usr/bin/mrtg /var/www/mrtg/192.168.xx.xxx.cfg
env LANG=C /usr/bin/mrtg /var/www/mrtg/192.168.xx.xxx.cfg
vi /etc/cron.d/mrtg
indexmaker /var/www/mrtg/192.168.xx.xxx.cfg > /var/www/mrtg/192.168.xx.xxx.html
vi /var/www/mrtg/192.168.xx.xxx.html
vi /var/www/mrtg/index.html
@auycro
auycro / .block
Last active May 22, 2017 02:41
Sample Test D3
license: gpl-3.0
@auycro
auycro / some-bootbox-example.html
Last active March 18, 2021 12:16
bootbox example
<html>
<head>
<!-- CSS dependencies -->
<link rel="stylesheet" type="text/css" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<style media="screen" type="text/css">
.modal {
text-align: center;
padding: 0!important;
}
@auycro
auycro / create-table-class.sql
Last active March 1, 2017 04:59
MYSQL: create table class sql
---Created by Gumpanat Keardkeawfa on 2017Mar01.---
---Copyright © 2017 Auycro. All rights reserved.---
---Ref:
--- http://stackoverflow.com/questions/149772/how-to-use-group-by-to-concatenate-strings-in-mysql
--- http://stackoverflow.com/questions/5873170/generate-class-from-database-table
SELECT
REPLACE(table_list.class_template,'{COLUMN_NAME}',tmp3.columns)
FROM
(
@auycro
auycro / TempShell-docker.md
Last active June 19, 2017 08:51
TempShell-docker

sudo docker build -t rozetta-php-app .

sudo docker rmi -f $(sudo docker images -a -q)

sudo docker rmi $(sudo docker images -a | grep none | awk '{print $3}';)

sudo docker rm $(sudo docker ps -a -q)

sudo docker run -d --name my-php -p 80:80 rozetta-php-app

CREATE TABLE `innodb_index_stats` (
`database_name` varchar(64) COLLATE utf8_bin NOT NULL,
`table_name` varchar(64) COLLATE utf8_bin NOT NULL,
`index_name` varchar(64) COLLATE utf8_bin NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`stat_name` varchar(64) COLLATE utf8_bin NOT NULL,
`stat_value` bigint(20) unsigned NOT NULL,
`sample_size` bigint(20) unsigned DEFAULT NULL,
`stat_description` varchar(1024) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)