diff --git a/event/2013halfmarathon/bingo.css b/event/2013halfmarathon/bingo.css
new file mode 100644
index 0000000..8daf2e3
--- /dev/null
+++ b/event/2013halfmarathon/bingo.css
@@ -0,0 +1,69 @@
+body{
+
+}
+div.main{
+ width: 800px;
+ height: 1000px;
+ background-image: url("bingo2.png");
+ background-repeat: no-repeat;
+ margin-left: auto;
+ margin-right: auto;
+ border: thin solid red;
+ }
+div.head{
+ background:;
+ width: 100%;
+ height: 150px;
+}
+
+/* -------------------------
+div.center-l{
+ background:#67bdff;
+ width: 100px;
+ height: 100%;
+ border: thin solid;
+ float:left;
+}
+============================ */
+
+div.center-c{
+ background: white;
+ width: 710px;
+ height: 690px;
+ padding-top: 2%;
+ margin-top: 20px;
+ margin-left: auto;
+ margin-right: auto;
+}
+
+/* ------------------------
+div.center-c li{
+ width: 150px;
+ height: 150px;
+ float: left;
+ margin: auto;
+ border: thin solid;
+ list-style-type: none;
+}
+=========================== */
+
+/* -------------------------
+div.center-r{
+ background:#67bdff;
+ width: 100px;
+ height: 100%;
+ border: thin solid;
+ float: right;
+}
+============================ */
+
+td div{
+ position: relative;
+}
+
+
+div.foot{
+ background:;
+ width: 100%;
+ height: 150px;
+}
diff --git a/event/2013halfmarathon/bingo.html b/event/2013halfmarathon/bingo.html
new file mode 100644
index 0000000..ee00a87
--- /dev/null
+++ b/event/2013halfmarathon/bingo.html
@@ -0,0 +1,73 @@
+
+
+
+Minato Oasis Festival
+
+
+
+
+
+
+
+
+
+
+
+
+ | |
+ |
+ |
+
+
+ |
+
+ |
+
+
+ 
+
+ 1
+
+
+ |
+
+
+ |
+
+
+ |
+
+ |
+
+
+ |
+
+
+ |
+
+
+
+
+

+
+
+
diff --git a/event/2013halfmarathon/bingo2.png b/event/2013halfmarathon/bingo2.png
new file mode 100644
index 0000000..9b962df
--- /dev/null
+++ b/event/2013halfmarathon/bingo2.png
Binary files differ
diff --git a/event/2013halfmarathon/city.html b/event/2013halfmarathon/city.html
new file mode 100644
index 0000000..50bb8b6
--- /dev/null
+++ b/event/2013halfmarathon/city.html
@@ -0,0 +1,26 @@
+
+
+
+���ĥ��ƥ��ϡ��եޥ饽��
+
+
+
+
+
+
+
+
��ջ���
+
�������˥��ޥۡ����֥�åȤ���Υ��ץ�Υ�������ɤ�ɬ�פ��褪��
+
��������פ���Τ���Į��5����Τ�Ź����
+
��������פ�3�Ľ���顢�������Ƥ͡�
+
+
+
+
+
+
+������ץ��λ�����ˡ�Ϥ�����dz�ǧ�Ǥ���
+��
+
+
+
\ No newline at end of file
diff --git a/event/2013halfmarathon/downrad1.png b/event/2013halfmarathon/downrad1.png
new file mode 100644
index 0000000..2cda8e8
--- /dev/null
+++ b/event/2013halfmarathon/downrad1.png
Binary files differ
diff --git a/event/2013halfmarathon/kamonkun01.png b/event/2013halfmarathon/kamonkun01.png
new file mode 100644
index 0000000..cb404b3
--- /dev/null
+++ b/event/2013halfmarathon/kamonkun01.png
Binary files differ
diff --git a/event/2013halfmarathon/kamonkun01_migi.png b/event/2013halfmarathon/kamonkun01_migi.png
new file mode 100644
index 0000000..fe700c3
--- /dev/null
+++ b/event/2013halfmarathon/kamonkun01_migi.png
Binary files differ
diff --git a/event/2013halfmarathon/kamonkun03.png b/event/2013halfmarathon/kamonkun03.png
new file mode 100644
index 0000000..099cbb2
--- /dev/null
+++ b/event/2013halfmarathon/kamonkun03.png
Binary files differ
diff --git a/event/2013halfmarathon/kamonkun05.png b/event/2013halfmarathon/kamonkun05.png
new file mode 100644
index 0000000..8d75826
--- /dev/null
+++ b/event/2013halfmarathon/kamonkun05.png
Binary files differ
diff --git a/event/2013halfmarathon/marathon2013.html b/event/2013halfmarathon/marathon2013.html
new file mode 100644
index 0000000..c920ecd
--- /dev/null
+++ b/event/2013halfmarathon/marathon2013.html
@@ -0,0 +1,73 @@
+
+
+���ĥ��ƥ��ϡ��եޥ饽��
+
+
+
+
+
+
+
+
+
+
+
+

+
+
+
+
���ĥ��ƥ��ϡ��եޥ饽��
+
+
+

+
+
SWAN��
+Project
+
+
���ˤʤ뤪Ź�ο�Ф���å�����
+
+

+
+
+
+
������ץ��Ǥ����ʥ����ݥ�ޥۤǥ��å�!
+
+
������ץ����äλ�������
+
+- ���ޥۤΡ�Google play�פ⤷���ϡ�App Store�פ����֥ե�åġפ�̵����
+�ץ�����ޤ���
+- ��FLET'S WiFi���ץ�פ�̵����������ɤޤ���
+
+- ���ץ��ư���ơ��桼������Ͽ�ޤ���
+
+
���ĥ��ƥ����ϡ��եޥ饽��and�ɤ��פ�����
+
������ץ�Ź�ޤ˹Ԥäơ����ޥۤǥ�����פ��Ƥ����ޤ���
+
+
+
������פ�3�Ľ���ơ����ʸ�Ǥ����ʥ����ݥ�åȤ��ޤ��礦!
+
+
+
diff --git a/event/2013halfmarathon/marathon2013.html.orig b/event/2013halfmarathon/marathon2013.html.orig
new file mode 100644
index 0000000..c920ecd
--- /dev/null
+++ b/event/2013halfmarathon/marathon2013.html.orig
@@ -0,0 +1,73 @@
+
+
+���ĥ��ƥ��ϡ��եޥ饽��
+
+
+
+
+
+
+
+
+
+
+
+

+
+
+
+
���ĥ��ƥ��ϡ��եޥ饽��
+
+
+

+
+
SWAN��
+Project
+
+
���ˤʤ뤪Ź�ο�Ф���å�����
+
+

+
+
+
+
������ץ��Ǥ����ʥ����ݥ�ޥۤǥ��å�!
+
+
������ץ����äλ�������
+
+- ���ޥۤΡ�Google play�פ⤷���ϡ�App Store�פ����֥ե�åġפ�̵����
+�ץ�����ޤ���
+- ��FLET'S WiFi���ץ�פ�̵����������ɤޤ���
+
+- ���ץ��ư���ơ��桼������Ͽ�ޤ���
+
+
���ĥ��ƥ����ϡ��եޥ饽��and�ɤ��פ�����
+
������ץ�Ź�ޤ˹Ԥäơ����ޥۤǥ�����פ��Ƥ����ޤ���
+
+
+
������פ�3�Ľ���ơ����ʸ�Ǥ����ʥ����ݥ�åȤ��ޤ��礦!
+
+
+
diff --git a/event/2013halfmarathon/minato.css b/event/2013halfmarathon/minato.css
new file mode 100644
index 0000000..f6da83a
--- /dev/null
+++ b/event/2013halfmarathon/minato.css
@@ -0,0 +1,17 @@
+body{
+ background: #2d48e2;
+}
+
+div{
+ background: rgba(255,255,255,1.0);
+ height: 500px;
+ width: 1100px;
+ margin-left: auto;
+ margin-right: auto;
+}
+
+h1{
+ text-align: center;
+}
+
+
diff --git a/event/2013halfmarathon/minato_festival.html b/event/2013halfmarathon/minato_festival.html
new file mode 100644
index 0000000..c63046e
--- /dev/null
+++ b/event/2013halfmarathon/minato_festival.html
@@ -0,0 +1,30 @@
+
+
+
+Stamp rally in Minato festival
+
+
+
+
+
+Minato Festival
+
+
+
�����������פ�Ȥ�...
+
+
+
+
+
+
������ץ��Ȥ�...
+
+
+
+
+
+
diff --git a/event/2013halfmarathon/omise3.png b/event/2013halfmarathon/omise3.png
new file mode 100644
index 0000000..9e9af95
--- /dev/null
+++ b/event/2013halfmarathon/omise3.png
Binary files differ
diff --git a/event/2013halfmarathon/omise4.png b/event/2013halfmarathon/omise4.png
new file mode 100644
index 0000000..d2bf127
--- /dev/null
+++ b/event/2013halfmarathon/omise4.png
Binary files differ
diff --git a/event/2013halfmarathon/skip_map.png b/event/2013halfmarathon/skip_map.png
new file mode 100644
index 0000000..82bb417
--- /dev/null
+++ b/event/2013halfmarathon/skip_map.png
Binary files differ
diff --git a/event/2013halfmarathon/skipman.png b/event/2013halfmarathon/skipman.png
new file mode 100644
index 0000000..f839e9a
--- /dev/null
+++ b/event/2013halfmarathon/skipman.png
Binary files differ
diff --git a/event/2013halfmarathon/skipman.xcf b/event/2013halfmarathon/skipman.xcf
new file mode 100644
index 0000000..0dffb9d
--- /dev/null
+++ b/event/2013halfmarathon/skipman.xcf
Binary files differ
diff --git a/event/2013halfmarathon/stamp-pig.png b/event/2013halfmarathon/stamp-pig.png
new file mode 100644
index 0000000..ca47543
--- /dev/null
+++ b/event/2013halfmarathon/stamp-pig.png
Binary files differ
diff --git a/event/2013halfmarathon/stamp.png b/event/2013halfmarathon/stamp.png
new file mode 100644
index 0000000..d2d6bb3
--- /dev/null
+++ b/event/2013halfmarathon/stamp.png
Binary files differ
diff --git a/event/bingo.css b/event/bingo.css
deleted file mode 100644
index 8daf2e3..0000000
--- a/event/bingo.css
+++ /dev/null
@@ -1,69 +0,0 @@
-body{
-
-}
-div.main{
- width: 800px;
- height: 1000px;
- background-image: url("bingo2.png");
- background-repeat: no-repeat;
- margin-left: auto;
- margin-right: auto;
- border: thin solid red;
- }
-div.head{
- background:;
- width: 100%;
- height: 150px;
-}
-
-/* -------------------------
-div.center-l{
- background:#67bdff;
- width: 100px;
- height: 100%;
- border: thin solid;
- float:left;
-}
-============================ */
-
-div.center-c{
- background: white;
- width: 710px;
- height: 690px;
- padding-top: 2%;
- margin-top: 20px;
- margin-left: auto;
- margin-right: auto;
-}
-
-/* ------------------------
-div.center-c li{
- width: 150px;
- height: 150px;
- float: left;
- margin: auto;
- border: thin solid;
- list-style-type: none;
-}
-=========================== */
-
-/* -------------------------
-div.center-r{
- background:#67bdff;
- width: 100px;
- height: 100%;
- border: thin solid;
- float: right;
-}
-============================ */
-
-td div{
- position: relative;
-}
-
-
-div.foot{
- background:;
- width: 100%;
- height: 150px;
-}
diff --git a/event/bingo.html b/event/bingo.html
deleted file mode 100644
index ee00a87..0000000
--- a/event/bingo.html
+++ /dev/null
@@ -1,73 +0,0 @@
-
-
-
-Minato Oasis Festival
-
-
-
-
-
-
-
-
-
-
-
-
- | |
- |
- |
-
-
- |
-
- |
-
-
- 
-
- 1
-
-
- |
-
-
- |
-
-
- |
-
- |
-
-
- |
-
-
- |
-
-
-
-
-

-
-
-
diff --git a/event/bingo2.png b/event/bingo2.png
deleted file mode 100644
index 9b962df..0000000
--- a/event/bingo2.png
+++ /dev/null
Binary files differ
diff --git a/event/city.html b/event/city.html
deleted file mode 100644
index 50bb8b6..0000000
--- a/event/city.html
+++ /dev/null
@@ -1,26 +0,0 @@
-
-
-
-���ĥ��ƥ��ϡ��եޥ饽��
-
-
-
-
-
-
-
-
��ջ���
-
�������˥��ޥۡ����֥�åȤ���Υ��ץ�Υ�������ɤ�ɬ�פ��褪��
-
��������פ���Τ���Į��5����Τ�Ź����
-
��������פ�3�Ľ���顢�������Ƥ͡�
-
-
-
-
-
-
-������ץ��λ�����ˡ�Ϥ�����dz�ǧ�Ǥ���
-��
-
-
-
\ No newline at end of file
diff --git a/event/downrad1.png b/event/downrad1.png
deleted file mode 100644
index 2cda8e8..0000000
--- a/event/downrad1.png
+++ /dev/null
Binary files differ
diff --git a/event/kamonkun01.png b/event/kamonkun01.png
deleted file mode 100644
index cb404b3..0000000
--- a/event/kamonkun01.png
+++ /dev/null
Binary files differ
diff --git a/event/kamonkun01_migi.png b/event/kamonkun01_migi.png
deleted file mode 100644
index fe700c3..0000000
--- a/event/kamonkun01_migi.png
+++ /dev/null
Binary files differ
diff --git a/event/kamonkun03.png b/event/kamonkun03.png
deleted file mode 100644
index 099cbb2..0000000
--- a/event/kamonkun03.png
+++ /dev/null
Binary files differ
diff --git a/event/kamonkun05.png b/event/kamonkun05.png
deleted file mode 100644
index 8d75826..0000000
--- a/event/kamonkun05.png
+++ /dev/null
Binary files differ
diff --git a/event/marathon2013.html b/event/marathon2013.html
deleted file mode 100644
index c920ecd..0000000
--- a/event/marathon2013.html
+++ /dev/null
@@ -1,73 +0,0 @@
-
-
-���ĥ��ƥ��ϡ��եޥ饽��
-
-
-
-
-
-
-
-
-
-
-
-

-
-
-
-
���ĥ��ƥ��ϡ��եޥ饽��
-
-
-

-
-
SWAN��
-Project
-
-
���ˤʤ뤪Ź�ο�Ф���å�����
-
-

-
-
-
-
������ץ��Ǥ����ʥ����ݥ�ޥۤǥ��å�!
-
-
������ץ����äλ�������
-
-- ���ޥۤΡ�Google play�פ⤷���ϡ�App Store�פ����֥ե�åġפ�̵����
-�ץ�����ޤ���
-- ��FLET'S WiFi���ץ�פ�̵����������ɤޤ���
-
-- ���ץ��ư���ơ��桼������Ͽ�ޤ���
-
-
���ĥ��ƥ����ϡ��եޥ饽��and�ɤ��פ�����
-
������ץ�Ź�ޤ˹Ԥäơ����ޥۤǥ�����פ��Ƥ����ޤ���
-
-
-
������פ�3�Ľ���ơ����ʸ�Ǥ����ʥ����ݥ�åȤ��ޤ��礦!
-
-
-
diff --git a/event/marathon2013.html.orig b/event/marathon2013.html.orig
deleted file mode 100644
index c920ecd..0000000
--- a/event/marathon2013.html.orig
+++ /dev/null
@@ -1,73 +0,0 @@
-
-
-���ĥ��ƥ��ϡ��եޥ饽��
-
-
-
-
-
-
-
-
-
-
-
-

-
-
-
-
���ĥ��ƥ��ϡ��եޥ饽��
-
-
-

-
-
SWAN��
-Project
-
-
���ˤʤ뤪Ź�ο�Ф���å�����
-
-

-
-
-
-
������ץ��Ǥ����ʥ����ݥ�ޥۤǥ��å�!
-
-
������ץ����äλ�������
-
-- ���ޥۤΡ�Google play�פ⤷���ϡ�App Store�פ����֥ե�åġפ�̵����
-�ץ�����ޤ���
-- ��FLET'S WiFi���ץ�פ�̵����������ɤޤ���
-
-- ���ץ��ư���ơ��桼������Ͽ�ޤ���
-
-
���ĥ��ƥ����ϡ��եޥ饽��and�ɤ��פ�����
-
������ץ�Ź�ޤ˹Ԥäơ����ޥۤǥ�����פ��Ƥ����ޤ���
-
-
-
������פ�3�Ľ���ơ����ʸ�Ǥ����ʥ����ݥ�åȤ��ޤ��礦!
-
-
-
diff --git a/event/minato.css b/event/minato.css
deleted file mode 100644
index f6da83a..0000000
--- a/event/minato.css
+++ /dev/null
@@ -1,17 +0,0 @@
-body{
- background: #2d48e2;
-}
-
-div{
- background: rgba(255,255,255,1.0);
- height: 500px;
- width: 1100px;
- margin-left: auto;
- margin-right: auto;
-}
-
-h1{
- text-align: center;
-}
-
-
diff --git a/event/minato_festival.html b/event/minato_festival.html
deleted file mode 100644
index c63046e..0000000
--- a/event/minato_festival.html
+++ /dev/null
@@ -1,30 +0,0 @@
-
-
-
-Stamp rally in Minato festival
-
-
-
-
-
-Minato Festival
-
-
-
�����������פ�Ȥ�...
-
-
-
-
-
-
������ץ��Ȥ�...
-
-
-
-
-
-
diff --git "a/event/oasis2015/\043gets.rb\043" "b/event/oasis2015/\043gets.rb\043"
new file mode 100755
index 0000000..d079925
--- /dev/null
+++ "b/event/oasis2015/\043gets.rb\043"
@@ -0,0 +1,168 @@
+#!/usr/bin/env ruby22
+# -*- coding:utf-8 -*-
+
+require 'sqlite3'
+require 'cgi'
+
+c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8")
+db = SQLite3::Database.new("sql/main.sq3")
+
+id = c.cookies["id"][0]
+person = id.to_i
+
+data = "select * from test where id = ?"
+cook = db.execute(data, person)
+upd = "update test set pt = ? where id = ?"
+goods = "update goods set g1 = ?, g2 = ?, g3 = ?, g4 = ?, g5 = ?, g6 = ? where id = ?"
+
+
+name = cook[0][1]
+pt = cook[0][7]
+lv = cook[0][8]
+
+ticket = "select * from goods where id = ?"
+have = db.execute(ticket, person)
+g1 = have[0][1]
+g2 = have[0][2]
+g3 = have[0][3]
+g4 = have[0][4]
+g5 = have[0][5]
+g6 = have[0][6]
+
+gets = c["sho"]
+c1 = 10 #商品それぞれに対して消費するポイント
+c2 = 6
+c3 = 8
+c4 = 2
+c5 = 5
+c6 = 100
+n1 = "オランダせんべい" #商品それぞれの名前
+n2 = "温ビール"
+n3 = "ハンドクリーム"
+n4 = ""
+
+h1 = "チケットを発行したよ!
海洋センター3階でスタッフの人と商品をこうかんしてね!"
+if lv < 3
+ h1 = "チケット発行できません!"
+ kekka = "レベル が たりないよ!"
+elsif gets == "s1" && pt >= c1
+ g1 += 1
+ pt -= c1
+ kekka = "#{n1}交換券をゲット!"
+elsif gets == "s2" && pt >= c2
+ g2 += 1
+ pt -= c2
+ kekka = "#{n2}交換券をゲット!"
+elsif gets == "s3" && pt >= c3
+ g3 += 1
+ pt -= c3
+ kekka = "#{n3}交換券をゲット!"
+elsif gets == "s4" && pt >= c4
+ g4 += 1
+ pt -= c4
+ kekka = "あめ交換券をゲット!"
+elsif gets == "s5" && pt >= c5
+ g5 += 1
+ pt -= c5
+ kekka = "10円金券をゲット!"
+elsif gets == "s6" && pt >= c6
+ g6 += 1
+ pt -= c6
+ kekka = "まぐろ交換券をゲット!"
+else
+ h1 = "チケット発行できません!!"
+ kekka = "ポイントとかたりません!"
+end
+
+trade = c["trade"]
+if trade == n1 && g1 > 0
+ g1 -= 1
+ kekka = "#{n1} と交換します!
スタッフの人は、スタッフがボタンを押した場合のみ、交換してください!"
+ h1 = "#{n1}と交換します!
こぼさないで たべてね!"
+elsif trade == n2 && g2 > 0
+ g2 -= 1
+ kekka = "#{n2} と交換します!
スタッフの人は、スタッフがボタンを押した場合のみ、年齢を確認してから交換してください!"
+ h1 = "#{n2} と交換します!
ひやしてから おうち で のんでね!"
+elsif trade == n3 && g3 > 0
+g3 -= 1
+kekka = "#{n3} と交換します!
スタッフの人は、スタッフがボタンを押した場合のみ、交換してください!"
+ h1 = "#{n3}と交換します!"
+elsif trade == n4 && g4 > 0
+g4 -= 1
+kekka = "あめ と交換します!
スタッフの人は、スタッフがボタンを押した場合のみ、交換してください!"
+h1 = "あめと交換します!"
+elsif trade == "10えん金券" && g5 > 0
+g5 -= 1
+kekka = " 10えん と交換します!
スタッフの人は、スタッフがボタンを押した場合のみ、交換してください!"
+h1 = "10えんと交換します!"
+elsif trade == "まぐろ" && g6 > 0
+g6 -= 1
+kekka = "まぐろ と交換します!
スタッフの人は、スタッフがボタンを押した場合のみ、交換してください!"
+h1 = "まぐろと交換します!"
+end
+
+
+
+
+
+db.execute(goods, g1, g2, g3, g4, g5, g6, person)
+db.execute(upd, pt, person)
+
+
+pre = "%"
+printf(<<_EOS_, h1, name, pt, kekka, g1, g2, g4)
+
+
+
+
+
+
+
+
+
+
+
+こうかん!
+
+
+
+
+
+
+さかたっち
+%s
+
+%sさん
+さかたポイント:%dp
+%s
+
+
+もっているチケット
+|
+オランダせんべい | :%d |
|
+温ビール | :%d |
|
+secret[3~/td> | :%d |
|
+ | |
|
+ | |
+
+
+
+
+
+
+
+
+
+
+
+_EOS_
diff --git a/event/oasis2015/.htaccess b/event/oasis2015/.htaccess
new file mode 100644
index 0000000..3a8c330
--- /dev/null
+++ b/event/oasis2015/.htaccess
@@ -0,0 +1,4 @@
+AddHandler cgi-script .rb
+AddType "text/html; charset=UTF-8" .rb
+AddType "text/html; charset=UTF-8" .html
+Options +ExecCGI
diff --git a/event/oasis2015/accountcheck.rb b/event/oasis2015/accountcheck.rb
new file mode 100755
index 0000000..32b2d65
--- /dev/null
+++ b/event/oasis2015/accountcheck.rb
@@ -0,0 +1,126 @@
+#!/usr/bin/env ruby22
+# -*- coding: utf-8 -*-
+
+require 'sqlite3'
+require 'kconv'
+require 'cgi'
+
+c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8")
+db = SQLite3::Database.new("sql/main.sq3")
+
+
+sql = "insert into test values(?, ?, ?, ?, ?, ?, ?, ?, ?)"
+
+toi = "insert into toi values (?, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)"
+item = "insert into goods values (?, 0, 0, 0, 0, 0, 0)"
+
+name = c["name"]
+
+cle1 = "CREATE TABLE IF NOT EXISTS test(id, name, cal, age, sex, aria, exp, pt, lv)"
+cle2 = "CREATE TABLE IF NOT EXISTS toi(id, q1, q2, q3, q4, q5, q6, q7, q8, q9, q10)"
+cle3 = "CREATE TABLE IF NOT EXISTS goods(id, g1, g2, g3, g4, g5, g6)"
+cle4 = "CREATE TABLE IF NOT EXISTS time(cd, now, id)"
+cle5 = "CREATE TABLE IF NOT EXISTS num(cd, id)"
+cle6 = "CREATE TABLE IF NOT EXISTS pass(id, pass, name)"
+
+ins4 = 'insert into time values(?, 61, "n")'
+ins5 = 'insert into num values("aa",0)'
+ins6 = 'insert into pass values(?, ?, ?)'
+num = "select id from num where cd = ?"
+numup = "update num set id = ? where cd = ?"
+
+db.execute(cle1)
+db.execute(cle2)
+db.execute(cle3)
+db.execute(cle4)
+db.execute(cle5)
+db.execute(cle6)
+if name == "createman789789789"
+db.execute(ins4, "a")
+db.execute(ins4, "b")
+db.execute(ins4, "c")
+db.execute(ins4, "d")
+db.execute(ins4, "e")
+db.execute(ins4, "f")
+db.execute(ins4, "g")
+db.execute(ins4, "h")
+db.execute(ins4, "i")
+db.execute(ins4, "j")
+db.execute(ins5)
+end
+
+name = c["name"]
+namae = "#{name}"
+cal = c["cal"]
+age = c["age"]
+sex = c["sex"]
+aria = c["aria"]
+
+id = c.cookies["id"][0]
+pass = c.cookies["pass"][0]
+
+if id == nil
+# srand
+# id = rand(1000)
+ number = db.execute(num, "aa")
+ id = number[0][0].to_i + 1
+ exp = 0
+ pt = 0
+ lv = 1
+ cd = "aa"
+ if pass == nil
+ pass = id
+ end
+ db.execute(ins6, id, pass, name)
+ db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv)
+ db.execute(toi, id)
+ db.execute(item, id)
+ db.execute(numup, id, cd)
+end
+# srand(id.to_i)
+# id2 = rand(1000000)
+id2 = pass
+
+
+
+expires = "SAT, 2 Apr 2016 00:00:00 GMT"
+
+printf("Content-type: text/html; charset=UTF-8
+Set-Cookie:id=%s ;expires=%s
+Set-Cookie:pass=%s ;expires=%s\n\n", id, expires, id2, expires)
+
+
+printf(<<_EOS_, name, id.to_i)
+
+
+
+
+
+
+
+
+
+
+
+
+
+Registering Account
+
+
+
+さかたっち
+登録が完了しました!
+ようこそ_ %s _さん!
+あなたのIDは%04dです!
+
+
+
+_EOS_
+
+
+if name == "createman987987987"
+ `rm sql/main.sq3`
+# `touch sql/main.sq3`
+# `chmod a+w sql/main.sq3`
+end
diff --git "a/event/oasis2015/admin/\043check.rb\043" "b/event/oasis2015/admin/\043check.rb\043"
new file mode 100755
index 0000000..039e103
--- /dev/null
+++ "b/event/oasis2015/admin/\043check.rb\043"
@@ -0,0 +1,151 @@
+#!/usr/bin/env ruby22
+# -*- coding: utf-8 -*-
+require 'cgi'
+require 'sqlite3'
+require 'kconv'
+c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8")
+db = SQLite3::Database.new("../sql/main.sq3")
+
+getAC1 = ARGV[0]
+pass = "hogehogeboy"
+
+hsh = c["SQ1"]
+hsh += c["SQ2"]
+
+pts = "| id | name | cal | age | sex | aria | exp | pt | lv |
"
+
+
+if c["SQ2"] == "toi"
+pts = "| id | q1 | q2 | q3 | q4 | q5 | q6 | q7 | q8 | q9 | secret |
"
+elsif c["SQ2"] == "time"
+pts = "| cd | now | id |
"
+elsif c["SQ2"] == "goods"
+pts = "| id | おちゃ | しょうひん2 | しょうひん3 | しょうひん4 | しょうひん5 | しょうひん6 |
"
+elsif c["SQ2"] == "pass"
+pts = "| id | pass | name |
"
+
+end
+
+
+######################################
+################SQ3###################
+if c["SQ3"] == ""
+else
+upd = c["SQ3"]
+db.execute(upd)
+end
+
+################SQ3###################
+######################################
+
+
+
+
+################################
+################################
+if hsh == ""
+# pts = "hoge"
+ hsh = "select * from test"
+else
+end
+
+hsh2 = db.execute(hsh)
+i = 0
+while i < hsh2.length
+ data = hsh2[i]
+ if c["SQ2"] == "toi"
+ pts += "| #{data[0]} | #{data[1]} | #{data[2]} | #{data[3]} | #{data[4]} | #{data[5]} | #{data[6]} | #{data[7]} | #{data[8]} | #{data[9]} | #{data[10]} |
"
+ elsif c["SQ2"] == "time"
+ pts += "| #{data[0]} | #{data[1]} | #{data[2]} |
"
+ elsif c["SQ2"] == "goods"
+ pts += "| #{data[0]} | #{data[1]} | #{data[2]} | #{data[3]} | #{data[4]} | #{data[5]} | #{data[6]} |
"
+ else
+ pts += "| #{data[0]} | #{data[1]} | #{data[2]} | #{data[3]} | #{data[4]} | #{data[5]} | #{data[6]} | #{data[7]} | #{data[8]} | #{data[9]} |
"
+ end
+ i += 1
+end
+#end
+pts += "
"
+
+
+print"Content-type: text/html; charset=UTF-8\n\n"
+
+
+######################################
+################if ~html##############
+
+#if getAC1 == pass
+
+printf(<<_EOS_, pts, hsh2.lenght)
+
+
+
+
+
+
+
+
+
+
+
+control
+
+
+
+
+test,toi,goods,time,num,pass
+
+
+
+control
+
+
+
+%s
+
+
+skip@xxxx.co.jp
+
+
+
+
+_EOS_
+#############################################
+#############################################
+#else
+if getAC1 == "hoge" ###いらない行。accをつける前は"else"のみだった。
+printf(<<_EOS_)
+
+
+
+
+
+
+
+さかたっち(go top!)
+
+
+さかたっち
+トップへ!
+skip@xxxx.co.jp
+
+
+_EOS_
+end
diff --git a/event/oasis2015/admin/.htaccess b/event/oasis2015/admin/.htaccess
new file mode 100644
index 0000000..302ad69
--- /dev/null
+++ b/event/oasis2015/admin/.htaccess
@@ -0,0 +1,10 @@
+AddHandler cgi-script .rb
+AddType "text/html; charset=utf-8" .rb
+AddType "text/html; charset=utf-8" .html
+Options +ExecCGI
+AuthUserFile /home/www/skip/oasis2015/admin/.htpasswd
+#AuthUserFile /home/irhome/c113/c113007/public_html/web/oasis2015/admin/.htpasswd#royでページを動かしたいとき用
+AuthGroupFile /dev/null
+AuthName "splatoon! piyopiyogirl"
+AuthType Basic
+require valid-user
diff --git a/event/oasis2015/admin/.htpasswd b/event/oasis2015/admin/.htpasswd
new file mode 100644
index 0000000..8baee9c
--- /dev/null
+++ b/event/oasis2015/admin/.htpasswd
@@ -0,0 +1 @@
+c113007:QRf28ARYqd/FY
diff --git a/event/oasis2015/admin/check.rb b/event/oasis2015/admin/check.rb
new file mode 100755
index 0000000..8285625
--- /dev/null
+++ b/event/oasis2015/admin/check.rb
@@ -0,0 +1,151 @@
+#!/usr/bin/env ruby22
+# -*- coding: utf-8 -*-
+require 'cgi'
+require 'sqlite3'
+require 'kconv'
+c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8")
+db = SQLite3::Database.new("../sql/main.sq3")
+
+getAC1 = ARGV[0]
+pass = "hogehogeboy"
+
+hsh = c["SQ1"]
+hsh += c["SQ2"]
+
+pts = "| id | name | cal | age | sex | aria | exp | pt | lv |
"
+
+
+if c["SQ2"] == "toi"
+pts = "| id | q1 | q2 | q3 | q4 | q5 | q6 | q7 | q8 | q9 | secret |
"
+elsif c["SQ2"] == "time"
+pts = "| cd | now | id |
"
+elsif c["SQ2"] == "goods"
+pts = "| id | おちゃ | しょうひん2 | しょうひん3 | しょうひん4 | しょうひん5 | しょうひん6 |
"
+elsif c["SQ2"] == "pass"
+pts = "| id | pass | name |
"
+
+end
+
+
+######################################
+################SQ3###################
+if c["SQ3"] == ""
+else
+upd = c["SQ3"]
+db.execute(upd)
+end
+
+################SQ3###################
+######################################
+
+
+
+
+################################
+################################
+if hsh == ""
+# pts = "hoge"
+ hsh = "select * from test"
+else
+end
+
+hsh2 = db.execute(hsh)
+i = 0
+while i < hsh2.length
+ data = hsh2[i]
+ if c["SQ2"] == "toi"
+ pts += "| #{data[0]} | #{data[1]} | #{data[2]} | #{data[3]} | #{data[4]} | #{data[5]} | #{data[6]} | #{data[7]} | #{data[8]} | #{data[9]} | #{data[10]} |
"
+ elsif c["SQ2"] == "time"
+ pts += "| #{data[0]} | #{data[1]} | #{data[2]} |
"
+ elsif c["SQ2"] == "goods"
+ pts += "| #{data[0]} | #{data[1]} | #{data[2]} | #{data[3]} | #{data[4]} | #{data[5]} | #{data[6]} |
"
+ else
+ pts += "| #{data[0]} | #{data[1]} | #{data[2]} | #{data[3]} | #{data[4]} | #{data[5]} | #{data[6]} | #{data[7]} | #{data[8]} | #{data[9]} |
"
+ end
+ i += 1
+end
+#end
+pts += "
"
+
+
+print"Content-type: text/html; charset=UTF-8\n\n"
+
+sum=hsh2.length
+######################################
+################if ~html##############
+
+#if getAC1 == pass
+
+printf(<<_EOS_, sum , pts)
+
+
+
+
+
+
+
+
+
+
+
+control
+
+
+
+
+test,toi,goods,time,num,pass,%s
+
+
+
+control
+
+
+
+%s
+
+
+skip@xxxx.co.jp
+
+
+
+
+_EOS_
+#############################################
+#############################################
+#else
+if getAC1 == "hoge" ###いらない行。accをつける前は"else"のみだった。
+printf(<<_EOS_)
+
+
+
+
+
+
+
+さかたっち(go top!)
+
+
+さかたっち
+トップへ!
+skip@xxxx.co.jp
+
+
+_EOS_
+end
diff --git a/event/oasis2015/admin2/.htaccess b/event/oasis2015/admin2/.htaccess
new file mode 100644
index 0000000..66b2e8e
--- /dev/null
+++ b/event/oasis2015/admin2/.htaccess
@@ -0,0 +1,9 @@
+AddHandler cgi-script .rb
+AddType "text/html; charset=utf-8" .rb
+AddType "text/html; charset=utf-8" .html
+Options +ExecCGI
+AuthUserFile /home/www/skip/2014OC/admin/.htpasswd
+AuthGroupFile /dev/null
+AuthName "ǧ�ڥ�����"
+AuthType Basic
+require valid-user
diff --git a/event/oasis2015/admin2/.htpasswd b/event/oasis2015/admin2/.htpasswd
new file mode 100644
index 0000000..522e590
--- /dev/null
+++ b/event/oasis2015/admin2/.htpasswd
@@ -0,0 +1,2 @@
+Murakami:7Y005Wtya7Ogw
+test:tebUY14UFwMKg
diff --git a/event/oasis2015/admin2/drawLots.html b/event/oasis2015/admin2/drawLots.html
new file mode 100644
index 0000000..e45a1a3
--- /dev/null
+++ b/event/oasis2015/admin2/drawLots.html
@@ -0,0 +1,24 @@
+
+
+
+Database delete
+
+
+
+
+
+抽選用ページ
+実行するとデータベースが書き変えられます。
+実行する際は注意してください。
+
+データ閲覧ページに戻る
+
+
diff --git a/event/oasis2015/admin2/drawLots.rb b/event/oasis2015/admin2/drawLots.rb
new file mode 100755
index 0000000..8ed7125
--- /dev/null
+++ b/event/oasis2015/admin2/drawLots.rb
@@ -0,0 +1,87 @@
+#!/usr/bin/env ruby
+# -*- coding: utf-8 -*-
+
+require 'sqlite3'
+require 'cgi'
+require 'date'
+
+c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8")
+db = SQLite3::Database.new("../sql/stamp.sq3")
+
+add = ENV["REMOTE_ADDR"]
+
+if /^(172\.19\.5\.|172\.17\.54\.|172\.21\.90\.)|118.21.142.107|202.214.125.107|192.168.43.255/ =~ add
+check = c['check']
+
+printf("Content-type: text/html; charset=UTF-8\n\n")
+
+sum = 'SELECT SUM(rank) FROM main WHERE NOT id=1;'
+rank_sum = db.execute(sum).flatten(2)[0].to_i
+
+t = Time.now
+expires = Time.local(2014, 8, 17, 8, 50)
+expires2 = Time.local(2014, 10, 25, 0, 00)
+if t > expires && t < expires2 && rank_sum == 0
+else
+ check = ""
+ puts check
+end
+
+if check == "OK"
+ begin
+ result = db.execute("select id,exp,rank from main;")
+ rescue
+ exit
+ end
+ all = Array.new
+ for id,lv,rank in result
+ if id == 1 || lv == 0 || rank.to_i != 0
+ next
+ end
+ lv.to_i.times do
+ all << id
+ end
+ end
+
+ tousen = Array.new(0)
+ atari1 = rand(all.length)
+ tousen << all[atari1]
+ all.delete_if {|x| x == tousen[0]}
+
+ sql = "update main set rank = 1 where id = ?;"
+ db.execute(sql,tousen[0])
+
+ sql = "update main set rank = 2 where id = ?;"
+ while tousen.length < 4
+ srand
+ atari2 = rand(all.length)
+ hoge = all[atari2]
+ tousen << all[atari2]
+ all.delete_if {|x| x == hoge}
+ db.execute(sql,hoge)
+ end
+
+ i=0
+
+ printf("1等はIDが%04dの方!おめでとー!
\n",tousen[i].to_i-1)
+ printf("2等はIDが%04dと%04dと%04dの方!おめでとー!
\n",tousen[i+=1].to_i-1,tousen[i+=1].to_i-1,tousen[i+=1].to_i-1)
+else
+ print"抽選はまだ行いませんよ
\n"
+end
+print'抽選ページに戻る
+データ閲覧ページに戻る
+'
+else
+ printf("Content-type: text/html; charset=UTF-8\n\n")
+
+ printf'
+
+
+Delete table
+
+
+
+管理者用ページのため閲覧できません。
'
+end
+print'