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
<?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')) { |
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
{ | |
"rule": { | |
"key": "turf_war", | |
"name": "ナワバリバトル", | |
"multiline_name": "ナワバリ\nバトル" | |
}, | |
"type": "regular", | |
"stage": { | |
"id": "109", | |
"name": "あしたはデンデン", |
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
-- 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, |
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
<?php | |
/* | |
* マルチバイト対応 str_replace() | |
* | |
* Release 3 update 1 | |
* | |
* Copyright (C) 2006,2007,2011,2012 by HiNa <hina@bouhime.com>. All rights reserved. | |
* | |
* LICENSE | |
* |
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
<?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'); |
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
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 |
We can't make this file beautiful and searchable because it's too large.
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
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 |
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
#!/usr/bin/env python | |
# -*- coding: utf-8 -*- | |
import requests | |
import ssl | |
def http_get(url): | |
try: | |
requests.get(site["url"], verify=True) | |
return "OK" |
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
-- 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" |
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
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" | |
NewerOlder