auycro

//  CaptureScreenButton.cs
//  UnityPlugins
//
//  Created by Gumpanat Keardkeawfa on July 8,16.
//  Copyright © 2016 Auycro. All rights reserved.

//  for windows, use [winapi](https://msdn.microsoft.com/en-us/library/windows/desktop/ms646928(v=vs.85).aspx)

using UnityEngine;
#if UNITY_EDITOR

auycro

building dll with GCC http://stackoverflow.com/questions/16332701/how-to-call-c-dll-in-c-sharp http://www.adp-gmbh.ch/cpp/gcc/create_lib.html

first we have C code

#include <stdio.h>

int
hello()

auycro

import android.accounts.AccountManager;
import android.accounts.Account;

public class GetAccountPlugin {
	//CANNOT GET CORRECT PURCHASED USER'S EMAIL
	public String GetGoogleAccountEmail(Activity activity){
		AccountManager manager = (AccountManager) activity.getSystemService(Context.ACCOUNT_SERVICE);
		Account[] accounts =  manager.getAccounts();
		//Log.d(tag, "GetGoogleAccountEmail-LENGTH " + accounts.length);
		String strGmail = "";

auycro

rect

auycro

//  Created by Auycro on August 22,16.
//  Copyright © 2016 Auycro. All rights reserved.

public class SampleConnectAndRunQuery
{
  static string insert_sql = "INSERT INTO {0} VALUE ({1},\"{2}\")";

  static bool InsertData(string table, int id, string update_detail){
    bool result = true;
    try {

auycro

//  Created by Gumpanat Keardkeawfa on 11/14/16.
//  Copyright © 2016 Auycro. All rights reserved.

using System;
using System.IO;
using System.Text;

namespace FileConvertCommaAsciiToChar
{
	class MainClass

auycro

//FROM http://stackoverflow.com/questions/10796464/transfer-ownership-of-a-file-to-another-user-in-google-apps-script

/**
* Change Owner of a file or folder 
* Run this as admin and authorise first in the script editor.
*/ 
function changeOwner(newOwnerEmail, fileOrFolderId){
  var file = DocsList.getFileById(fileOrFolderId);
  var oldOwnerEmail = file.getOwner().getEmail();
  if (oldOwnerEmail === newOwnerEmail) {

auycro

MYSQL's note

How to get a valuation about the size of mysql table dump

http://serverfault.com/questions/411902/how-to-get-a-valuation-about-the-size-of-mysql-table-dump

By database:

SELECT table_schema 'database',

auycro

Command

tr

translation http://www.thegeekstuff.com/2012/12/linux-tr-command/

$tr '[:upper:]' '[:lower:]' input.txt > output.txt

cut

auycro

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`)