Skip to content

Instantly share code, notes, and snippets.

View kashiwasan's full-sized avatar

Shota Kashiwagi kashiwasan

11 followers · 22 following
View GitHub Profile
@kashiwasan
kashiwasan / gist:1269652
Created October 7, 2011 07:01
OpenPNE3 Azure SQL (CREATE&ALTER)
IF NOT EXISTS(SELECT * FROM sys.schemas WHERE [name] = N'dbo')
EXEC (N'CREATE SCHEMA dbo')
GO
IF EXISTS (SELECT * FROM sys.objects so JOIN sys.schemas sc ON so.schema_id = sc.schema_id WHERE so.name = N'activity_data' AND sc.name=N'dbo' AND type in (N'U'))
BEGIN
DECLARE @drop_statement nvarchar(500)
DECLARE drop_cursor CURSOR FOR
SELECT 'alter table '+quotename(schema_name(ob.schema_id))+
@kashiwasan
kashiwasan / gist:1269655
Created October 7, 2011 07:03
OpenPNE3 Azure SQL (INSERT)
INSERT INTO sns_term (name,application) VALUES ('friend','pc_frontend'),('friend','mobile_frontend'),('my_friend','pc_frontend'),('my_friend','mobile_frontend'),('community','pc_frontend'),('community','mobile_frontend'),('nickname','pc_frontend'),('nickname','mobile_frontend'),('activity','pc_frontend'),('activity','mobile_frontend'),('post_activity','pc_frontend'),('post_activity','mobile_frontend');
INSERT INTO sns_term_translation (value,lang) VALUES ('friend','en'),('フレンド','ja_JP'),('friend','en'),('ﾌﾚﾝﾄﾞ','ja_JP'),('my friend','en'),('マイフレンド','ja_JP'),('my friend','en'),('ﾏｲﾌﾚﾝﾄﾞ','ja_JP'),('community','en'),('コミュニティ','ja_JP'),('community','en'),('ｺﾐｭﾆﾃｨ','ja_JP'),('nickname','en'),('ニックネーム','ja_JP'),('nickname','en'),('ﾆｯｸﾈｰﾑ','ja_JP'),('activity','en'),('アクティビティ','ja_JP'),('activity','en'),('ｱｸﾃｨﾋﾞﾃｨ','ja_JP'),('Post Activity','en'),('アクティビティ投稿','ja_JP'),('Post Activity','en'),('投稿','ja_JP');
INSERT INTO sns_config (name,value) VALUES ('OpenPNE_revision','46'),('opAshiatoPlugin_revision','3'),('opAuth
@kashiwasan
kashiwasan / openpneFastInstallTask.class.php
Created November 25, 2011 08:40 — forked from 77web/openpneFastInstallTask.class.php
(kashiwagi fixed) 1行コマンドでインストールができるopenpne:fast-installタスクの提案。
<?php
/**
* This file is part of the OpenPNE package.
* (c) OpenPNE Project (http://www.openpne.jp/)
*
* For the full copyright and license information, please view the LICENSE
* file and the NOTICE file that were distributed with this source code.
*/
@kashiwasan
kashiwasan / .htaccess
Created December 13, 2011 07:32 — forked from tejima/.htaccess
p.kslive.jp
RewriteEngine On
RewriteRule ([0-9]+)/([0-9A-Za-z]+\.(jpg|png)) ./index.php?src=http://dl.dropbox.com/u/20190621/p/$2&q=100&aoe=0&w=$1 [L]
RewriteRule ([0-9]+\.(jpg|png)) ./index.php?src=http://dl.dropbox.com/u/20190621/p/$1&q=100 [L]
@kashiwasan
kashiwasan / mail_generator.php
Created January 12, 2012 12:16
mailaddress generator for coreserver
<?php
/***************************
(c) mail address generator for coreserver
@author : kashiwasan <pc.kashiwasan@gmail.com>
****************************/
// ベースドメインを指定
$domain = "example.com";
@kashiwasan
kashiwasan / message_list.json
Created February 6, 2012 03:44
message_list.json
{"status":"success","data":[{"id":1,"member":{"id":1,"profile_image":"http:\/\/example.com\/images\/no_image.gif","profile_url":"http:\/\/example.com\/member\/1","friend":"false","blocking":"false"},"title":"(title)","created_at":"Thu, 05 Jan 2012 14:03:40 +0900"},{"id":2,"member":{"id":2,"profile_image":"http:\/\/example.com\/images\/no_image.gif","profile_url":"http:\/\/example.com\/member\/2","friend":"false","blocking":"false"},"title":"(title2)","created_at":"Thu, 06 Jan 2012 14:03:40 +0900"}]}
@kashiwasan
kashiwasan / opJsonApiTest.php
Created March 31, 2012 10:10
JsonApi 単体テストスクリプト
<?php
$app = 'api';
include_once dirname(__FILE__) . '/../../bootstrap/unit.php';
include_once dirname(__FILE__) . '/../../bootstrap/database.php';
$configuration = ProjectConfiguration::getApplicationConfiguration('api', 'prod', isset($debug) ? $debug : true);
sfContext::createInstance($configuration);
$numOfTest = 42;
@kashiwasan
kashiwasan / mosquito.php
Created December 8, 2012 15:39
モスキート音認証
<?php
// モスキート音認証
// バージョン 1.1
// 作者: 園田 裕大
// 　　 柏木 祥太
// サイト: http://www.0319.jp/
// ライセンス: PHP License
// This product includes PHP, freely available from http://www.php.net/
/////////////// 定義 ////////////////
@kashiwasan
kashiwasan / firefox_20_install.sh
Last active February 1, 2016 02:09 — forked from alingogo/firefox_20_install.sh
#!/bin/bash
# yum install firefox
wget "http://download.mozilla.org/?product=firefox-43.0-SSL&os=linux&lang=ja"
tar jxvf firefox-43.0.tar.bz2
cp -frp firefox /usr/local/firefox43
mv /usr/bin/firefox{,.bak}
ln -s /usr/local/firefox43/firefox /usr/bin/.
@kashiwasan
kashiwasan / member_model.class.php
Last active March 21, 2016 04:59
Original Model Classes
<?php
class Member extends Model {
protected $tableName = 'members';
}