| id | q1 | q2 | q3 | q4 | q5 | q6 | q7 | q8 | q9 | secret |
|---|
| cd | now | id |
|---|
| id | おちゃ | しょうひん2 | しょうひん3 | しょうひん4 | しょうひん5 | しょうひん6 |
|---|
| 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]} |
test,toi,goods,time,num,pass
control
- - - -%s
さかたっち
-トップへ! -skip@xxxx.co.jp - - -_EOS_ -end diff --git "a/opencampus2015/\043battle.rb\043" "b/opencampus2015/\043battle.rb\043" deleted file mode 100755 index 16d193d..0000000 --- "a/opencampus2015/\043battle.rb\043" +++ /dev/null @@ -1,181 +0,0 @@ -#!/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") - -per = "%" -id = c.cookies["id"][0] -person = id.to_i - -data = "select * from test where id = ?" -cook = db.execute(data, person) -printf("Content-type: text/html; charset=UTF-8\n\n") - -begin -id,name,cal,age,sex,aria,exp,pt,lv = cook[0] -rescue -printf(<<_EOS_) - - - - - - - -記録が無くなったようだ...
記憶も消してやりなおしたまえ......
- - -skip@xxxx.co.jp - - - - -_EOS_ -exit(0) ##プログラム終了! これがないと以降のプログラムが動いてしまう。 -end - -#################キャラクタ######### -chenge = c["chenge"].to_i -box = db.execute("select * from box where id = ?",id) -hoge,no1,e1,t1,tm1,no2,e2,t2,tm2,no3,e3,t3,tm3=box[0] -newname = "select name from zukan where no = ?" -if chenge == 2 - db.execute("update box set no1=?,e1=?,t1=?,tm1=?,no2=?,e2=?,t2=?,tm2=? where id = ?",no2,e2,t2,tm2,no1,e1,t1,tm1,id) -calname = db.execute(newname,no2)[0][0] - -db.execute("update test set cal = ? where id = ?",calname,id) -elsif chenge == 3 - db.execute("update box set no1=?,e1=?,t1=?,tm1=?,no3=?,e3=?,t3=?,tm3=? where id = ?",no3,e3,t3,tm3,no1,e1,t1,tm1,id) -calname = db.execute(newname,no3)[0][0] -db.execute("update test set cal = ? where id = ?",calname,id) -end - -##################################レベル処理する#### -gage = 0 -e1 = db.execute("select e1 from box where id = ?",person)[0][0]#じぶんのidのboxにある一体目の経験値 -no1 = db.execute("select no1 from box where id = ?",person)[0][0] -no2 = db.execute("select no2 from box where id = ?",person)[0][0].to_i#2体目id -no3 = db.execute("select no3 from box where id = ?",person)[0][0].to_i#3体目id -lv2 = db.execute("select lv2 from zukan where no = ?",no1)[0][0].to_i -lv3 = db.execute("select lv3 from zukan where no = ?",no1)[0][0].to_i -lv4 = db.execute("select lv4 from zukan where no = ?",no1)[0][0].to_i -lv5 = db.execute("select lv5 from zukan where no = ?",no1)[0][0].to_i -if e1 < lv2 -lv = 1 -gage = 100-(e1/lv2.to_f*100) -elsif e1 >= lv5 -lv = 5 -gage = 0 -elsif e1 >= lv4 -lv = 4 -gage = 100-(e1-lv4)/(lv5-lv4.to_f)*100 -elsif e1 >= lv3 -lv = 3 -gage = 100-(e1-lv3)/(lv4-lv3.to_f)*100 -elsif e1 >= lv2 -lv = 2 -gage = 100-(e1-lv2)/(lv3-lv2.to_f)*100 -end######################################### - - -image = "./img/#{cal}#{lv}.png" -alt = "#{cal}.png" - - - -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 - -printf(<<_EOS_, per, gage, per, per, per, color, cal, image, alt, name, person, cal, lv) - - - - - - - - - - - - - -Miyazac Quest
- -
-
-
-
-
-
-
-| name | :%s |
| id | :%04d |
| cara | :%s |
| lv. | %d |
-
-
-
-
-
-
-_EOS_
exp
-