Skip to content

Instantly share code, notes, and snippets.

View fetus-hina's full-sized avatar
💭
I may be slow to respond.

AIZAWA Hina fetus-hina

💭
I may be slow to respond.
View GitHub Profile
@fetus-hina
fetus-hina / mb_explode.function.php
Created February 20, 2012 07:00
mb_explode() function
<?php
/*
* Copyright (C) 2012 by HiNa <hina@bouhime.com>. All rights reserved.
*
* LICENSE
*
* This source file is subject to the 2-clause BSD License(Simplified
* BSD License).
*/
if(!function_exists('mb_explode')) {
{
"rule": {
"key": "turf_war",
"name": "ナワバリバトル",
"multiline_name": "ナワバリ\nバトル"
},
"type": "regular",
"stage": {
"id": "109",
"name": "あしたはデンデン",
@fetus-hina
fetus-hina / query.sql
Created June 11, 2019 18:48
野良 X ブキ集計
-- https://twitter.com/fetus_hina/status/1138514672494080000
SELECT
MAX(c2.key) AS weapon_key,
MAX(c2.name) AS weapon_name_en,
COUNT(*) AS players_count,
SUM(CASE WHEN battle2.is_win = battle_player2.is_my_team THEN 1 ELSE 0 END) AS win_count,
(100.0 * SUM(CASE WHEN battle2.is_win = battle_player2.is_my_team THEN 1 ELSE 0 END)::float / COUNT(*)::float)::decimal(5,2) AS win_pct,
AVG(battle_player2.kill)::decimal(4,2) AS avg_kill,
AVG(battle_player2.death)::decimal(4,2) AS avg_death,
@fetus-hina
fetus-hina / mb_str_replace.function.php
Created November 29, 2011 11:18
mb_str_replace() 説明ページ表示用ソース(リリースソース)
<?php
/*
* マルチバイト対応 str_replace()
*
* Release 3 update 1
*
* Copyright (C) 2006,2007,2011,2012 by HiNa <hina@bouhime.com>. All rights reserved.
*
* LICENSE
*
@fetus-hina
fetus-hina / prog.php
Last active April 17, 2019 08:43
PHPで和暦表示
<?php
// ICU version => 62.1
// ICU Data version => 62.1
// ICU TZData version => 2018e
// ICU Unicode version => 11.0
declare(strict_types=1);
$tz = new DateTimeZone('Asia/Tokyo');
user: nobody
hosts:
"foo.example.com:443":
listen:
host: 0.0.0.0
port: 443
ssl:
certificate-file: /etc/pki/tls/certs/foo.example.com-2015.crt
key-file: /etc/pki/tls/certs/foo.example.com-2015.key
minimum-version: TLSv1
@fetus-hina
fetus-hina / counts.csv
Last active June 5, 2018 12:12
ガチマッチ(野良)ランク S, S+, X、カウント別
We can't make this file beautiful and searchable because it's too large.
rule,stage,cnt_win,cnt_lose,battles,total_secs,battles_overtime
area,battera,62,61,1,304,1
area,battera,64,63,1,310,1
area,battera,65,60,1,300,0
area,battera,66,55,1,300,0
area,battera,66,63,1,300,0
area,battera,66,65,2,610,2
area,battera,66,65,1,315,1
area,battera,67,62,1,300,0
area,battera,68,67,1,306,1
@fetus-hina
fetus-hina / tlstest.py
Last active April 6, 2018 13:46
TLS Test
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import requests
import ssl
def http_get(url):
try:
requests.get(site["url"], verify=True)
return "OK"
@fetus-hina
fetus-hina / clam_blitz.sql
Created December 13, 2017 13:06
ガチアサリ救済
-- stat.ink 管理用 SQL
-- ガチアサリを知らないクライアントで、イカリング2のJSONをそのまま送ってくれるやつの場合に
-- JSONの内容を検査してガチアサリと設定するための SQL
-- rule_id = 5 : ガチアサリの ID をハードコード
-- "battle2"."created_at" >= '2017-12-13T11:00:00+09:00' : ver 2.1.0 リリース日時(ガチアサリは絶対これ以降)
-- "battle2"."id" >= 243190 : 上の日時フィルタの具体的な最小ID(本来どちらかでいい。明示的に&インデックス用)
UPDATE "battle2"
@fetus-hina
fetus-hina / sushi.reg
Created July 14, 2016 11:48
2016年を🍣🍺元年にする設定
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\Calendars\Japanese\Eras]
"1868 01 01"="明治_明_Meiji_M"
"1912 07 30"="大正_大_Taisho_T"
"1926 12 25"="昭和_昭_Showa_S"
"1989 01 08"="平成_平_Heisei_H"
"2016 01 01"="🍣🍺_🍣_Sushi_U"