# HG changeset patch # User ARAKI Tsuyohito # Date 1437737988 -32400 # Node ID 76439f2bb691c25a626a6a6dd1373d83709d6236 # Parent 19a10d778bc168e35993dafcc54e3876e4cce7bb open diff -r 19a10d778bc1 -r 76439f2bb691 oasis2015/img/qr/q1.pdf Binary file oasis2015/img/qr/q1.pdf has changed diff -r 19a10d778bc1 -r 76439f2bb691 oasis2015/img/qr/q1o.png Binary file oasis2015/img/qr/q1o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 oasis2015/img/qr/q2o.png Binary file oasis2015/img/qr/q2o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 oasis2015/img/qr/q3o.png Binary file oasis2015/img/qr/q3o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 oasis2015/img/qr/q4o.png Binary file oasis2015/img/qr/q4o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 oasis2015/img/qr/q5o.png Binary file oasis2015/img/qr/q5o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 oasis2015/img/qr/qro.pdf Binary file oasis2015/img/qr/qro.pdf has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/#.htaccess# --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/#.htaccess# Fri Jul 24 20:39:48 2015 +0900 @@ -0,0 +1,3 @@ +AddHandler cgi-script .rb +Options +ExecCGI +AddType "text/html; charset=utf-8" .html diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/.htaccess --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/.htaccess Fri Jul 24 20:39:48 2015 +0900 @@ -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 -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/accountcheck.rb --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/accountcheck.rb Fri Jul 24 20:39:48 2015 +0900 @@ -0,0 +1,123 @@ +#!/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 + 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, 24 Oct 2015 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 -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/admin/.htaccess --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/admin/.htaccess Fri Jul 24 20:39:48 2015 +0900 @@ -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/opencampus2015/admin/.htpasswd #for_skip +AuthUserFile /home/irhome/c113/c113007/public_html/web/opencampus2015/admin/.htpasswd +AuthGroupFile /dev/null +AuthName "splatoon! piyopiyogirl" +AuthType Basic +require valid-user diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/admin/.htpasswd --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/admin/.htpasswd Fri Jul 24 20:39:48 2015 +0900 @@ -0,0 +1,1 @@ +c113007:QRf28ARYqd/FY diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/admin/check.rb --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/admin/check.rb Fri Jul 24 20:39:48 2015 +0900 @@ -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 = "" + + +if c["SQ2"] == "toi" +pts = "

id	name	cal	age	sex	aria	exp	pt	lv

" +elsif c["SQ2"] == "time" +pts = "

id	q1	q2	q3	q4	q5	q6	q7	q8	q9	secret

" +elsif c["SQ2"] == "goods" +pts = "

cd	now	id

" +elsif c["SQ2"] == "pass" +pts = "

id	おちゃ	しょうひん2	しょうひん3	しょうひん4	しょうひん5	しょうひん6

" + +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 += "" + elsif c["SQ2"] == "time" + pts += "" + elsif c["SQ2"] == "goods" + pts += "" + else + pts += "" + end + i += 1 +end +#end +pts += "

id	pass	name
#{data[0]}	#{data[1]}	#{data[2]}	#{data[3]}	#{data[4]}	#{data[5]}	#{data[6]}	#{data[7]}	#{data[8]}	#{data[9]}	#{data[10]}
#{data[0]}	#{data[1]}	#{data[2]}
#{data[0]}	#{data[1]}	#{data[2]}	#{data[3]}	#{data[4]}	#{data[5]}	#{data[6]}
#{data[0]}	#{data[1]}	#{data[2]}	#{data[3]}	#{data[4]}	#{data[5]}	#{data[6]}	#{data[7]}	#{data[8]}	#{data[9]}

" + + +print"Content-type: text/html; charset=UTF-8\n\n" + + +###################################### +################if ~html############## + +#if getAC1 == pass + +printf(<<_EOS_, pts) + + + + + + + + + + + +control + + + + +

test,toi,goods,time,num,pass

+ + + +

control

+ + + +

+ + +

skip@xxxx.co.jp

+ + + + +_EOS_ +############################################# +############################################# +#else +if getAC1 == "hoge" ###いらない行。accをつける前は"else"のみだった。 +printf(<<_EOS_) + + + + + + + +さかたっち(go top!) + +

さかたっち

+トップへ! +

skip@xxxx.co.jp

+ + +_EOS_ +end diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/cookie.rb --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/cookie.rb Fri Jul 24 20:39:48 2015 +0900 @@ -0,0 +1,35 @@ +#!/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") + +id = c.cookies["id"][0] +id = nil +expires = Time.now + 1 +if id == nil +end + + +printf("Content-type: text/html; charset=UTF-8 +Set-Cookie:id=%s ;expires=%s\n\n", id, expires) + +printf(<<_EOS_) + + + + + + +Registering Account + + +

さかたっち

cookieを削除しました!

+とうろくがめんへ! + +_EOS_ diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/gets.rb --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/gets.rb Fri Jul 24 20:39:48 2015 +0900 @@ -0,0 +1,170 @@ +#!/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"] +n1 = "おかし" #商品それぞれの名前 +c1 = 3 #商品それぞれに対して消費するポイント +n2 = "ジュース" +c2 = 10 +n3 = "入学権" +c3 = 30000000 +n4 = "" +c4 = 2 +c5 = "" +c5 = 5 +c6 = "" +c6 = 100 + + +h1 = "チケットを発行したよ!
さかたっちスタッフの人と商品をこうかんしてね!" +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, g3, g4) + + + + + + + + + + + +こうかん! + + + + + +

さかたっち

%s

+%sさん
+さかたポイント:%dp
+%s +

+ +もっているチケット + + + + + +

おかし	:%d
ジュース	:%d
入学権	:%d
secret

+

+

もどる!

+

+ + + + + + + +_EOS_ diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/gohan.rb --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/gohan.rb Fri Jul 24 20:39:48 2015 +0900 @@ -0,0 +1,225 @@ +#!/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") + +id = c.cookies["id"][0] +person = id.to_i + +data = "select * from test where id = ?" + #idが?(後で代入)のデータをtest票から探す。という命令をdataにしくむ。全てがほしい場合は「*」。「*」を「name」に変えると該当データのnameだけとりだす。 + +cook = db.execute(data, person) + #dataに仕組んでいた命令を、personを代入しつつ実行。 + +upd = "update test set exp = ?, pt = ? where id = ?" + #「idが?3のとき、expを?1にする。ptを?2にする。」という命令文。 +lvupd = "update test set lv = ? where id = ?" + +que = "select q10 from toi where id = ?" +queupd = "update toi set q10 = 1 where id = ?" +q10 = db.execute(que, person) + + name = cook[0][1] + cal = cook[0][2] + exp = cook[0][6] + pt = cook[0][7] + lv = cook[0][8] + per = "%" +##################################### +##########秘密のこたえを設定############## +if cal == "inu" +m3 = "あゆ" +elsif cal == "sisip" +m3 = "ゆめ" +elsif cal == "kamon" +m3 = "ねぎ" +elsif cal == "boy" +m3 = "ふね" +elsif cal == "girl" +m3 = "かんざし" +else +m3 = "skipskip" +end +##################################### +##################################### + + +gohan = c["gohan"] +#himitu = "" +if gohan == "g1" && pt >= 2 + exp += 2 + pt -= 2 + db.execute(upd, exp, pt, person) + kekka = "#{cal}が成長した!" +elsif gohan == "g2" && pt >= 5 + exp += 6 + pt -= 5 + db.execute(upd, exp, pt, person) + kekka = "#{cal}がすごく成長した!" +elsif gohan == m3 + if q10[0][0] == 0 + exp += 10 + db.execute(upd, exp, pt, person) + kekka = "" + db.execute(queupd, person) + else + kekka ="しつもんにこたえられるのはいっかいだけだよ!" + end +else + kekka = "ポイントがたりない!" +end + +if gohan == m3 +elsif gohan == "g1" +elsif gohan == "g2" +else +kekka = "こたえがちがうよ!" +end + + +if exp >= lv*10 && lv < 5 + lv += 1 + db.execute(lvupd, lv, person) + kekka += "
レベルが上がった!
レベルが#{lv}になった!" +end + + +if cal == "inu" + image = "./img/inu#{lv}.png" + alt = "inu#{lv}" +elsif cal == "sisip" + image = "./img/sisip#{lv}.png" + alt = "sisip#{lv}" +elsif cal == "kamon" + image = "./img/kamon#{lv}.png" + alt = "kamon#{lv}" +elsif cal == "boy" + image = "./img/boy#{lv}.png" + alt = "boy#{lv}" +elsif cal == "girl" + image = "./img/girl#{lv}.png" + alt = "girl#{lv}" +elsif cal == "snake" + image = "./img/snake#{lv}.png" + alt = "snake#{lv}" +else + image = "./img/snail.png" +end + +if lv == 1 + color = "black" +elsif lv == 2 + color = "navy" +elsif lv == 3 + color = "green" +elsif lv == 4 + color = "red" +elsif lv == 5 + color = "yellow" +else + color = "pink" + image = "./img/snail.png" + alt = "snails_bug" +end + +gage = 0 +exp2 = exp +if lv < 5 + while exp2 >= 10 + exp2 -= 10 + end + gage = 100-exp2*10 +end + + + +modoru = '

ホーム' +back = modoru +if lv < 5 && gohan == "g1" || lv < 5 && gohan == "g2" + mo = '' + back = mo + modoru +elsif lv >= 5 + back += "
(レベルマックスだよ!)" +end +back += '

' + +cook = db.execute(data, person) +exp = cook[0][6] +pt = cook[0][7] +lv = cook[0][8] + + +printf(<<_EOS_, per, gage, per, per, per, color, image, alt, name, person, cal, lv, pt, kekka, back) + + + + + + + + + + + +ごはぁん! + + + + +

ほげほげ!

+ +

+ + + + +

name	:%s
id	:%04d
cara	:%s
lv.	%d

+ +

exp

+ +

+ +こうえきポイント:%dp
+%s +

+ +%s + + + + +_EOS_ diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/boy1.png Binary file opencampus2015/img/boy1.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/boy1o.png Binary file opencampus2015/img/boy1o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/boy2.png Binary file opencampus2015/img/boy2.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/boy2o.png Binary file opencampus2015/img/boy2o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/boy3.png Binary file opencampus2015/img/boy3.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/boy3o.png Binary file opencampus2015/img/boy3o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/boy4.png Binary file opencampus2015/img/boy4.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/boy4o.png Binary file opencampus2015/img/boy4o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/boy5.png Binary file opencampus2015/img/boy5.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/boy5o.png Binary file opencampus2015/img/boy5o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/cabage.png Binary file opencampus2015/img/cabage.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/exp.png Binary file opencampus2015/img/exp.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/expfront.png Binary file opencampus2015/img/expfront.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/fish.png Binary file opencampus2015/img/fish.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/food.png Binary file opencampus2015/img/food.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/foot.png Binary file opencampus2015/img/foot.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/foot2.png Binary file opencampus2015/img/foot2.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/gial1.png Binary file opencampus2015/img/gial1.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/gial1s.png Binary file opencampus2015/img/gial1s.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/girl1.png Binary file opencampus2015/img/girl1.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/girl1o.png Binary file opencampus2015/img/girl1o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/girl2.png Binary file opencampus2015/img/girl2.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/girl2o.png Binary file opencampus2015/img/girl2o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/girl3.png Binary file opencampus2015/img/girl3.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/girl3o.png Binary file opencampus2015/img/girl3o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/girl4.png Binary file opencampus2015/img/girl4.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/girl4o.png Binary file opencampus2015/img/girl4o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/girl5.png Binary file opencampus2015/img/girl5.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/girl5o.png Binary file opencampus2015/img/girl5o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/head.png Binary file opencampus2015/img/head.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/head2.png Binary file opencampus2015/img/head2.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/inu1.png Binary file opencampus2015/img/inu1.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/inu1o.png Binary file opencampus2015/img/inu1o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/inu2.png Binary file opencampus2015/img/inu2.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/inu2o.png Binary file opencampus2015/img/inu2o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/inu3.png Binary file opencampus2015/img/inu3.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/inu3o.png Binary file opencampus2015/img/inu3o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/inu4.png Binary file opencampus2015/img/inu4.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/inu4o.png Binary file opencampus2015/img/inu4o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/inu5.png Binary file opencampus2015/img/inu5.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/inu5o.png Binary file opencampus2015/img/inu5o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/kai.png Binary file opencampus2015/img/kai.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/kamon1.png Binary file opencampus2015/img/kamon1.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/kamon1o.png Binary file opencampus2015/img/kamon1o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/kamon2.png Binary file opencampus2015/img/kamon2.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/kamon2o.png Binary file opencampus2015/img/kamon2o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/kamon3.png Binary file opencampus2015/img/kamon3.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/kamon3o.png Binary file opencampus2015/img/kamon3o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/kamon4.png Binary file opencampus2015/img/kamon4.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/kamon4o.png Binary file opencampus2015/img/kamon4o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/kamon5.png Binary file opencampus2015/img/kamon5.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/kamon5o.png Binary file opencampus2015/img/kamon5o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/kyabetsu.png Binary file opencampus2015/img/kyabetsu.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/lvb.png Binary file opencampus2015/img/lvb.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/niku.png Binary file opencampus2015/img/niku.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/ninnjinn.png Binary file opencampus2015/img/ninnjinn.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/pan.png Binary file opencampus2015/img/pan.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/room.png Binary file opencampus2015/img/room.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/ship.png Binary file opencampus2015/img/ship.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/sisip1.png Binary file opencampus2015/img/sisip1.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/sisip1o.png Binary file opencampus2015/img/sisip1o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/sisip2.png Binary file opencampus2015/img/sisip2.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/sisip2o.png Binary file opencampus2015/img/sisip2o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/sisip3.png Binary file opencampus2015/img/sisip3.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/sisip3o.png Binary file opencampus2015/img/sisip3o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/sisip4.png Binary file opencampus2015/img/sisip4.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/sisip4o.png Binary file opencampus2015/img/sisip4o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/sisip5.png Binary file opencampus2015/img/sisip5.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/sisip5o.png Binary file opencampus2015/img/sisip5o.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/snail.png Binary file opencampus2015/img/snail.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/snake1.png Binary file opencampus2015/img/snake1.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/snake2.png Binary file opencampus2015/img/snake2.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/snake3.png Binary file opencampus2015/img/snake3.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/snake4.png Binary file opencampus2015/img/snake4.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/snake5.png Binary file opencampus2015/img/snake5.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/tamago.png Binary file opencampus2015/img/tamago.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/img/tsuya.png Binary file opencampus2015/img/tsuya.png has changed diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/index.html --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/index.html Fri Jul 24 20:39:48 2015 +0900 @@ -0,0 +1,57 @@ + + + + + + + + + + + +opencampus2015-7 + + + + +

ほげほげ!

~公益大に入学しよう~

キャラクターを登録しよう!

+ + + + diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/prof.rb --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/prof.rb Fri Jul 24 20:39:48 2015 +0900 @@ -0,0 +1,479 @@ +#!/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") + +id = c.cookies["id"][0] +person = id.to_i + +data = "select * from test where id = ?" +data2 = "select * from test where id = ?" +#idが?(後で代入)のデータをtest票から探す。という命令をdataにしくむ。全てがほしい場合は「*」。「*」を「name」に変えると該当データのnameだけとりだす。 +cook = db.execute(data, person) #dataに仕組んでいた命令を、personを代入しつつ実行。 +cook2 = db.execute(data2, person) +jikan1 = "select * from time where cd = ?" +timeupd = "update time set now = ?, id = ? where cd = ?" + +que = "select * from toi where id = ?" +queupd = "update toi set q1 = ?, q2 = ?, q3 = ?, q4 = ?, q5 = ? where id = ?" +toi = db.execute(que, person) + +bomd = "update test set pt = ? where id = ?" +ins4 = 'insert into time values(?, 61, "n")' +printf("Content-type: text/html; charset=UTF-8\n\n") + +begin +name = cook[0][1] +cal = cook[0][2] +age = cook[0][3] +sex = cook[0][4] +aria = cook[0][5] +exp = cook[0][6] +pt = cook[0][7] +lv = cook[0][8] +rescue +printf(<<_EOS_) + + + + + + + +ほげほげ + + + + +

データがみつかりません!

クッキーを消してやりなおしてください!

とうろく画面へ!

くっきーをけす!

skip@xxxx.co.jp

+ + + + +_EOS_ +exit(0) ##プログラム終了! これがないと以降のプログラムが動いてしまう。 +end + + + +q1 = toi[0][1] +q2 = toi[0][2] +q3 = toi[0][3] +q4 = toi[0][4] +q5 = toi[0][5] + +per ="%" + +##################--ptを獲得するための乱数生成--############# +##################----############################# + +def qrc() + srand(4567845678) + x = rand(10000000) + srand(x) + qrnumber = Hash.new("n") + qrarr = ["a", "b", "c", "d", "e"] + qrarr.length.times do |i| + qrnumber[rand(100000000)] = qrarr[i] + end + return qrnumber +end + +##################ptを獲得した際の反応。#################### +#########前の人が書き込んだ時間と比べて60秒以内なら追加ポイント#### +kpt = 0 +bom = c["bom"] ####

より + +begin + jikan2 = db.execute(jikan1, "j") + now1 = jikan2[0][1] +rescue + 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") +end + +if bom == "please skip here" + jikan2 = db.execute(jikan1, "j") + now1 = jikan2[0][1] + nowper = jikan2[0][2] + now2 = Time.now.to_i + db.execute(timeupd, now2, person, "j") + if person == nowper + elsif now1 == nil + elsif now2-now1 < 2 ####2秒以内なら~ + pt += 50 + kpt += 50 + end + pt += 1 + kpt += 1 + # db.execute(bomd, pt, person) +end + +qrAC = qrc ###生成したハッシュには、"乱数"=>"記号"が入っている +getAC = ARGV[0].to_i ###URL?以降の文字(特定の乱数)を取得してgetACに代入 +qr = qrAC[getAC] ###特定の"乱数"が一致すると、"乱数"=>"記号"がqrに正しく入力される。 +if qr =="a" && q1 == 0 + q1 += 1 + jikan2 = db.execute(jikan1, "a") + now1 = jikan2[0][1] + nowper = jikan2[0][2] + now2 = Time.now.to_i + db.execute(timeupd, now2, person, "a") + if person == nowper + elsif now1 == nil + elsif now2-now1 < 40 + pt += 5 + kpt += 5 + end + pt += 7 + kpt += 7 +elsif qr == "b" && q2 == 0 + q2 += 1 + jikan2 = db.execute(jikan1, "b") + now1 = jikan2[0][1] + nowper = jikan2[0][2] + now2 = Time.now.to_i + db.execute(timeupd, now2, person, "b") + if person == nowper + elsif now1 == nil + elsif now2-now1 < 20 + pt += 2 + kpt += 2 + end + pt += 12 + kpt += 12 +elsif qr == "c" && q3 == 0 + q3 += 1 + jikan2 = db.execute(jikan1, "c") + now1 = jikan2[0][1] + nowper = jikan2[0][2] + now2 = Time.now.to_i + db.execute(timeupd, now2, person, "c") + if person == nowper + elsif now1 == nil + elsif now2-now1 < 25 + pt += 10 + kpt += 10 + end + pt += 3 + kpt += 3 +elsif qr == "d" && q4 == 0 + q4 += 1 + jikan2 = db.execute(jikan1, "d") + now1 = jikan2[0][1] + nowper = jikan2[0][2] + now2 = Time.now.to_i + db.execute(timeupd, now2, person, "d") + if person == nowper + elsif now1 == nil + elsif now2-now1 < 60 + pt += 2 + kpt += 2 + end + pt += 15 + kpt += 15 +elsif qr == "e" && q5 == 0 + q5 += 1 + jikan2 = db.execute(jikan1, "e") + now1 = jikan2[0][1] + nowper = jikan2[0][2] + now2 = Time.now.to_i + db.execute(timeupd, now2, person, "e") + if person == nowper + elsif now1 == nil + elsif now2-now1 < 50 + pt += 4 + kpt += 4 + end + pt += 10 + kpt += 10 +end + + +db.execute(bomd, pt, person) +db.execute(queupd, q1, q2, q3, q4, q5, person) + +kkget = "" +if kpt > 0 + kkget = "#{kpt}ポイントゲット!!" +end + + + +########################~ここまでpt処理~################### +####################################################### + +if cal == "inu" + image = "./img/inu#{lv}.png" + alt = "inu#{lv}" + m1 = "ドッグフード" + mimg1 = "./img/food.png" + m2 = "にく" + mimg2 = "./img/niku.png" +elsif cal == "sisip" + image = "./img/sisip#{lv}.png" + alt = "sisip#{lv}" + m1 = "ぱん" + mimg1 = "./img/pan.png" + m2 = "きゃべつ" + mimg2 = "./img/kyabetsu.png" +elsif cal == "kamon" + image = "./img/kamon#{lv}.png" + alt = "kamon#{lv}" + m1 = "かい" + mimg1 = "./img/kai.png" + m2 = "とびうお" + mimg2 = "./img/fish.png" +elsif cal == "boy" + image = "./img/boy#{lv}.png" + alt = "boy#{lv}" + m1 = "いか" + mimg1 = "./img/ship.png" + m2 = "つやひめ" + mimg2 = "./img/tsuya.png" +elsif cal == "girl" + image = "./img/girl#{lv}.png" + alt = "girl#{lv}" + m1 = "さくらんぼ" + mimg1 = "./img/room.png" + m2 = "つやひめ" + mimg2 = "./img/tsuya.png" +elsif cal == "snake" + image = "./img/snake#{lv}.png" + alt = "snake#{lv}" + m1 = "かえる" + mimg1 = "./img/exp.png" + m2 = "ねずみ" + mimg2 = "./img/exp.png" +else + image = "./img/snail.png" + m1 = "たまごのから" + mimg1 = "./img/tamago.png" + m2 = "きゃべつ" + mimg2 = "./img/cabage.png" +end + + + +if lv == 1 + color = "black" +elsif lv == 2 + color = "navy" +elsif lv == 3 + color = "green" +elsif lv == 4 + color = "red" +elsif lv == 5 + color = "yellow" +else + color = "pink" + image = "./img/snail.png" + alt = "snails_bug" +end +#expが10あがる毎にlvが1あがる。 +#expの1の位*10で、次のレベルアップに必要な経験値の割合が出る。 +#(exp=12の場合、2*10=『20%』、次のレベルアップまであと80%が必要、と分かる。) +#(exp=35の場合、5*10=『50%』、次のレベルアップまであと50%が必要、と分かる。) +gage = 0 +exp2 = exp +esa = "

" +if lv < 5 + while exp2 >= 10 + exp2 -= 10 + end + gage = 100-exp2*10 + esa =' +
+:0pt' +end + + + + +######################## +###lv==5のとき画像を変える### +comm = "" +if ARGV[0] == "commandbomd" +comm += ' + + +

' +elsif lv == 5 +comm += '' +end + +if bom == "inu1" +image = "./img/inu1.png" +elsif bom == "inu2" +image = "./img/inu2.png" +elsif bom == "inu3" +image = "./img/inu3.png" +elsif bom == "inu4" +image = "./img/inu4.png" +elsif bom == "inu5" +image = "./img/inu5.png" + +elsif bom == "sisip1" +image = "./img/sisip1.png" +elsif bom == "sisip2" +image = "./img/sisip2.png" +elsif bom == "sisip3" +image = "./img/sisip3.png" +elsif bom == "sisip4" +image = "./img/sisip4.png" +elsif bom == "sisip5" +image = "./img/sisip5.png" + +elsif bom == "kamon1" +image = "./img/kamon1.png" +elsif bom == "kamon2" +image = "./img/kamon2.png" +elsif bom == "kamon3" +image = "./img/kamon3.png" +elsif bom == "kamon4" +image = "./img/kamon4.png" +elsif bom == "kamon5" +image = "./img/kamon5.png" + +elsif bom == "boy1" +image = "./img/boy1.png" +elsif bom == "boy2" +image = "./img/boy2.png" +elsif bom == "boy3" +image = "./img/boy3.png" +elsif bom == "boy4" +image = "./img/boy4.png" +elsif bom == "boy5" +image = "./img/boy5.png" + +elsif bom == "girl1" +image = "./img/girl1.png" +elsif bom == "girl2" +image = "./img/girl2.png" +elsif bom == "girl3" +image = "./img/girl3.png" +elsif bom == "girl4" +image = "./img/girl4.png" +elsif bom == "girl5" +image = "./img/girl5.png" +end +######################### +######################### +###################################--HTML--################## +###################################--------################## + +printf(<<_EOS_, per, gage, per, per, per, color, qrAC, kkget, image, alt, name, person, cal, lv, comm, pt, m1, mimg1, m2, mimg2, esa) + + + + + + + + + + + + + + + +ほげほげ + + + + +

ほげほげ

%s

+ +

+ + + + +

name	:%s
id	:%04d
cara	:%s
lv.	%d

+ +

exp

+ +%s + +

こうえきポイント:%dp

+ +

+ + + +

skip@xxxx.co.jp

+ + + + +_EOS_ diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/profeel.css --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/profeel.css Fri Jul 24 20:39:48 2015 +0900 @@ -0,0 +1,70 @@ +body{text-align:center; +background:#bff; +border:dashed 5px navy; +} +header{ +#padding:100px; + position: relative; + top: 0px; + left: 0px; + width: 80%; + height: 200px; +background-image:url(./img/head.png); +text-align:center; +margin-left:auto;margin-right:auto; +} +footer{ +#padding:100px; + position: relative; + top: 0px; + left: 0px; + width: 80%; + height: 200px; +background-image:url(./img/foot.png); +text-align:center; +margin-left:auto;margin-right:auto; +} + + + +header p {color:red;} + +h1{ +color:#e90; +border:solid 5px #fa0; +border-style:double; +background:url("./img/lvb.png"); +background-color:red; +} + + + + +input[type="checkbox"][name="hdn"] + span {display: none;} +input[type="checkbox"][name="hdn"]:checked + span {display: inline;} + +input[type="checkbox"][name="hdn"] + div{opacity: 0;} +input[type="checkbox"][name="hdn"]:checked + div { + opacity: 1.0; transition: 3s ease-in-out; + transition: 1s linear;} + +table{margin-left:auto; margin-right: auto;} +table.state{text-align:left;} +table.state tr+tr+tr+tr{font-size:xx-large;} + + +div.f1{padding:0% 0%; +margin:1em 17em;} +div.lets{ +border:solid 2px #fa0; +background:#faf; +padding:1% 0%; +#margin:1em 17em; +} +div.lets span{color:navy; text-decoration: underline #faf;} + +div.cal {margin-left:auto; margin-right:auto; +width: 320px; height: 180px; +background: #eef; +border: solid 2px navy;} + diff -r 19a10d778bc1 -r 76439f2bb691 opencampus2015/smart.css --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/opencampus2015/smart.css Fri Jul 24 20:39:48 2015 +0900 @@ -0,0 +1,76 @@ +body{text-align:center; +background:#bff; +border:dashed 5px navy; +margin-left:auto;margin-right:auto; +width:340px; +} +header{ +#padding:100px; + position: relative; + top: 0px; + left: 0px; + width: 100%; + height: 140px; +background-image:url(./img/head2.png); +background-repeat:no-repeat; +text-align:center; +margin-left:auto;margin-right:auto; +} +footer{ +#padding:100px; + position: relative; + top: 0px; + left: 0px; + width: 100%; + height: 140px; +background-image:url(./img/foot2.png); +background-repeat:no-repeat; +text-align:center; +margin-left:auto;margin-right:auto; +} + + + +header p {color:red;} + +h1{ +color:#e90; +border:solid 5px #fa0; +border-style:double; +background:url("./img/lvb.png"); +background-color:red; +} + +input[type="checkbox"][name="hdn"] + span {display: none;} +input[type="checkbox"][name="hdn"]:checked + span {display: inline;} + +input[type="checkbox"][name="hdn"] + div{opacity: 0;} +input[type="checkbox"][name="hdn"]:checked + div { + opacity: 1.0; transition: 3s ease-in-out; + transition: 1s linear;} + +table{margin-left:auto; margin-right: auto;} +table.state{text-align:left;} +table.state tr+tr+tr+tr{font-size:xx-large;} + + +div.f1{padding:0% 0%;} +div.lets{ +border:solid 2px #fa0; +background:#faf; +padding:1% 0%; +#margin:1em 17em; +} +div.lets span{color:navy; text-decoration: underline #faf;} + + + + +div.cal {margin-left:auto; margin-right:auto; +width: 320px; height: 180px; +background: #eef +border: solid 2px navy;} + + + +#form{margin-left:auto; margin-right:auto;}

名前
性別
年代
出身地
キャラ