821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
1 #!/usr/bin/env ruby22
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
2 # -*- coding: utf-8 -*-
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
3 require 'cgi'
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
4 require 'sqlite3'
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
5 require 'kconv'
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
6 c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
7 db = SQLite3::Database.new("./sql/main.sq3")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
8
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
9 id = c.cookies["id"][0]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
10 person = id.to_i
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
11
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
12 data = "select * from test where id = ?"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
13 data2 = "select * from test where id = ?"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
14 #idが?(後で代入)のデータをtest票から探す。という命令をdataにしくむ。全てがほしい場合は「*」。「*」を「name」に変えると該当データのnameだけとりだす。
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
15 cook = db.execute(data, person) #dataに仕組んでいた命令を、personを代入しつつ実行。
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
16 cook2 = db.execute(data2, person)
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
17 jikan1 = "select * from time where cd = ?"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
18 timeupd = "update time set now = ?, id = ? where cd = ?"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
19
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
20 que = "select * from toi where id = ?"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
21 queupd = "update toi set q1 = ?, q2 = ?, q3 = ?, q4 = ?, q5 = ? where id = ?"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
22 toi = db.execute(que, person)
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
23
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
24 bomd = "update test set pt = ? where id = ?"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
25 ins4 = 'insert into time values(?, 61, "n")'
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
26 printf("Content-type: text/html; charset=UTF-8\n\n")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
27
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
28 begin
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
29 name = cook[0][1]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
30 cal = cook[0][2]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
31 age = cook[0][3]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
32 sex = cook[0][4]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
33 aria = cook[0][5]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
34 exp = cook[0][6]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
35 pt = cook[0][7]
|
883
|
36 #lv = cook[0][8]
|
821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
37 rescue
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
38 printf(<<_EOS_)
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
39 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
40 "http://www.w3.org/TR/html4/strict.dtd">
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
41 <html><head>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
42 <meta name="viewport"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
43 content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no">
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
44 <meta name="format-detection" content="telephone=no">
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
45 <link media="only screen and (max-device-width:480px)"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
46 href="smart.css" type="text/css" rel="stylesheet" />
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
47 <link media="screen and (min-device-width:481px)" href="profeel.css"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
48 type="text/css" rel="stylesheet" />
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
49 <link rel="shortcut icon" href="./img/cabage.png"/>
|
864
|
50 <title>Miyazac Quest</title>
|
821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
51 <style type="text/css">
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
52 <!--
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
53 -->
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
54 </style>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
55 </head>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
56
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
57 <body>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
58 <header></header>
|
882
|
59 <h1>記録が無くなったようだ...</h1><h2>記憶も消してやりなおしたまえ......</h2>
|
|
60 <div class="f1"><a href="index.html"><div class="lets"><span>新規記憶の作成</span></div></a></div>
|
|
61 <div class="f1"><a href="cookie.rb"><div class="lets"><span>作成前に記憶を消す</span></div></a></div>
|
821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
62 <address>skip@xxxx.co.jp</address>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
63 <footer></footer>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
64 </body>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
65 </html>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
66
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
67 _EOS_
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
68 exit(0) ##プログラム終了! これがないと以降のプログラムが動いてしまう。
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
69 end
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
70
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
71
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
72
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
73 q1 = toi[0][1]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
74 q2 = toi[0][2]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
75 q3 = toi[0][3]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
76 q4 = toi[0][4]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
77 q5 = toi[0][5]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
78
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
79 per ="%"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
80
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
81 ##################--ptを獲得するための乱数生成--#############
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
82 ##################----#############################
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
83
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
84 def qrc()
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
85 srand(4567845678)
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
86 x = rand(10000000)
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
87 srand(x)
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
88 qrnumber = Hash.new("n")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
89 qrarr = ["a", "b", "c", "d", "e"]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
90 qrarr.length.times do |i|
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
91 qrnumber[rand(100000000)] = qrarr[i]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
92 end
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
93 return qrnumber
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
94 end
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
95
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
96 ##################ptを獲得した際の反応。####################
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
97 #########前の人が書き込んだ時間と比べて60秒以内なら追加ポイント####
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
98 kpt = 0
|
864
|
99
|
821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
100
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
101 begin
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
102 jikan2 = db.execute(jikan1, "j")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
103 now1 = jikan2[0][1]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
104 rescue
|
882
|
105 ("a".."j").each{|x| db.execute(ins4,x)}
|
821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
106 end
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
107
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
108
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
109 qrAC = qrc ###生成したハッシュには、"乱数"=>"記号"が入っている
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
110 getAC = ARGV[0].to_i ###URL?以降の文字(特定の乱数)を取得してgetACに代入
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
111 qr = qrAC[getAC] ###特定の"乱数"が一致すると、"乱数"=>"記号"がqrに正しく入力される。
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
112 if qr =="a" && q1 == 0
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
113 q1 += 1
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
114 jikan2 = db.execute(jikan1, "a")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
115 now1 = jikan2[0][1]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
116 nowper = jikan2[0][2]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
117 now2 = Time.now.to_i
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
118 db.execute(timeupd, now2, person, "a")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
119 if person == nowper
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
120 elsif now1 == nil
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
121 elsif now2-now1 < 40
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
122 pt += 5
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
123 kpt += 5
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
124 end
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
125 pt += 7
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
126 kpt += 7
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
127 elsif qr == "b" && q2 == 0
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
128 q2 += 1
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
129 jikan2 = db.execute(jikan1, "b")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
130 now1 = jikan2[0][1]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
131 nowper = jikan2[0][2]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
132 now2 = Time.now.to_i
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
133 db.execute(timeupd, now2, person, "b")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
134 if person == nowper
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
135 elsif now1 == nil
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
136 elsif now2-now1 < 20
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
137 pt += 2
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
138 kpt += 2
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
139 end
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
140 pt += 12
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
141 kpt += 12
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
142 elsif qr == "c" && q3 == 0
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
143 q3 += 1
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
144 jikan2 = db.execute(jikan1, "c")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
145 now1 = jikan2[0][1]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
146 nowper = jikan2[0][2]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
147 now2 = Time.now.to_i
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
148 db.execute(timeupd, now2, person, "c")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
149 if person == nowper
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
150 elsif now1 == nil
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
151 elsif now2-now1 < 25
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
152 pt += 10
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
153 kpt += 10
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
154 end
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
155 pt += 3
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
156 kpt += 3
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
157 elsif qr == "d" && q4 == 0
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
158 q4 += 1
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
159 jikan2 = db.execute(jikan1, "d")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
160 now1 = jikan2[0][1]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
161 nowper = jikan2[0][2]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
162 now2 = Time.now.to_i
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
163 db.execute(timeupd, now2, person, "d")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
164 if person == nowper
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
165 elsif now1 == nil
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
166 elsif now2-now1 < 60
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
167 pt += 2
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
168 kpt += 2
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
169 end
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
170 pt += 15
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
171 kpt += 15
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
172 elsif qr == "e" && q5 == 0
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
173 q5 += 1
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
174 jikan2 = db.execute(jikan1, "e")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
175 now1 = jikan2[0][1]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
176 nowper = jikan2[0][2]
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
177 now2 = Time.now.to_i
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
178 db.execute(timeupd, now2, person, "e")
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
179 if person == nowper
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
180 elsif now1 == nil
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
181 elsif now2-now1 < 50
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
182 pt += 4
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
183 kpt += 4
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
184 end
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
185 pt += 10
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
186 kpt += 10
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
187 end
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
188
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
189
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
190 db.execute(bomd, pt, person)
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
191 db.execute(queupd, q1, q2, q3, q4, q5, person)
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
192
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
193 kkget = ""
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
194
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
195 ########################~ここまでpt処理~###################
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
196 #######################################################
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
197
|
882
|
198 ##################################レベル処理する####
|
883
|
199 lv = 1
|
|
200 gage = 0
|
|
201 e1 = db.execute("select e1 from box where id = ?",person)[0][0]#じぶんのidのboxにある一体目の経験値
|
|
202 no1 = db.execute("select no1 from box where id = ?",person)[0][0]
|
|
203 no2 = db.execute("select no2 from box where id = ?",person)[0][0].to_i#2体目id
|
|
204 no3 = db.execute("select no3 from box where id = ?",person)[0][0].to_i#3体目id
|
|
205 lv2 = db.execute("select lv2 from zukan where no = ?",no1)[0][0].to_i
|
|
206 lv3 = db.execute("select lv3 from zukan where no = ?",no1)[0][0].to_i
|
|
207 lv4 = db.execute("select lv4 from zukan where no = ?",no1)[0][0].to_i
|
|
208 lv5 = db.execute("select lv5 from zukan where no = ?",no1)[0][0].to_i
|
882
|
209 if e1 < lv2
|
|
210 lv = 1
|
883
|
211 gage = 100-(e1/lv2.to_f*100)
|
882
|
212 elsif e1 >= lv5
|
|
213 lv = 5
|
883
|
214 gage = 0
|
882
|
215 elsif e1 >= lv4
|
|
216 lv = 4
|
883
|
217 gage = 100-(e1-lv4)/(lv5-lv4.to_f)*100
|
882
|
218 elsif e1 >= lv3
|
|
219 lv = 3
|
883
|
220 gage = 100-(e1-lv3)/(lv4-lv3.to_f)*100
|
882
|
221 elsif e1 >= lv2
|
|
222 lv = 2
|
883
|
223 gage = 100-(e1-lv2)/(lv3-lv2.to_f)*100
|
|
224 end#########################################
|
882
|
225
|
|
226
|
864
|
227 image = "./img/#{cal}#{lv}.png"
|
|
228 alt = "#{cal}.png"
|
821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
229
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
230
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
231
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
232 if lv == 1
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
233 color = "black"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
234 elsif lv == 2
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
235 color = "navy"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
236 elsif lv == 3
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
237 color = "green"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
238 elsif lv == 4
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
239 color = "red"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
240 elsif lv == 5
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
241 color = "yellow"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
242 else
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
243 color = "pink"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
244 image = "./img/snail.png"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
245 alt = "snails_bug"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
246 end
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
247 #expが10あがる毎にlvが1あがる。
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
248 #expの1の位*10で、次のレベルアップに必要な経験値の割合が出る。
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
249 #(exp=12の場合、2*10=『20%』、次のレベルアップまであと80%が必要、と分かる。)
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
250 #(exp=35の場合、5*10=『50%』、次のレベルアップまであと50%が必要、と分かる。)
|
882
|
251 #exppoint = "select e1 from box where id = ?" #じぶんのidのboxにある一体目の経験値
|
|
252 #expp = db.execute(exppoint,id)
|
|
253 #exp = expp[0][0].to_i
|
883
|
254 #gage = 0
|
882
|
255 #gage2 = db.execute("select no1 from box where id = ?",id)
|
|
256 #exp2 = exp
|
870
|
257 #esa = "<br><br><br>"
|
|
258
|
883
|
259 wcname ="select name from zukan where no = ?"
|
|
260 cal1 = db.execute(wcname,no1)[0][0]
|
|
261 begin
|
|
262 cal2 = db.execute(wcname,no2.to_s)[0][0]
|
|
263 rescue
|
|
264 cal2 = db.execute(wcname,no2.to_s)[0]
|
|
265 end
|
|
266 begin
|
|
267 cal3 = db.execute(wcname,no3.to_s)[0][0]
|
|
268 rescue
|
|
269 cal3 = db.execute(wcname,no3.to_s)[0]
|
|
270 end
|
|
271 chengeform = '<select name="chenge"><option value = 0>' + "#{cal1}"
|
|
272 if no2 > 0 && no3 >0
|
|
273 chengeform +="<option value = 2>#{cal2}<option value = 3>#{cal3}"
|
|
274 elsif no2 > 0 && no3 > 0
|
|
275 chengeform +="<option value = 2>#{cal2}"
|
|
276 end
|
821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
277
|
825
|
278 kakunin = ""
|
821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
279 #########################
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
280 #########################
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
281 ###################################--HTML--##################
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
282 ###################################--------##################
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
283
|
898
|
284 printf(<<_EOS_, per, gage, per, per, per, color, kakunin, kkget, image, alt, name, person, cal, lv, chengeform,pt,chengeform)
|
821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
285
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
286
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
287 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
288 "http://www.w3.org/TR/html4/strict.dtd">
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
289 <html>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
290 <head>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
291
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
292 <meta name="viewport"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
293 content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no">
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
294 <meta name="format-detection" content="telephone=no">
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
295 <link media="only screen and (max-device-width:480px)"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
296 href="smart.css" type="text/css" rel="stylesheet" />
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
297 <link media="screen and (min-device-width:481px)" href="profeel.css"
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
298 type="text/css" rel="stylesheet" />
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
299
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
300
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
301
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
302
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
303 <link rel="shortcut icon" href="./img/cabage.png"/>
|
898
|
304 <title>Miyazac Quest!</title>
|
821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
305 <style type="text/css">
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
306 <!--
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
307 p.gage{
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
308 background:#adf;
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
309 margin-left:0%s;
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
310 margin-right:%d%s;
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
311 text-align:left;
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
312 border-radius: 10ex;
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
313 }
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
314 div.gage{
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
315 background:#ddf;
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
316 margin-left:20%s;
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
317 margin-right:20%s;
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
318 border-radius: 10ex;
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
319 }
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
320 div.cal div{float:left; border:solid %s;}
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
321
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
322 -->
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
323 </style>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
324 </head>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
325
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
326 <body>
|
824
|
327 <header><p>%s</p></header>
|
870
|
328 <h1>Miyazac Quest</h1>
|
821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
329 <h2>%s</h2>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
330
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
331 <div class="cal">
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
332 <div>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
333 <img src=%s alt=%s width="172" height="172">
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
334 </div>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
335 <table class="state"><tr><td>name</td><td>:%s</td></tr>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
336 <tr><td>id</td><td>:%04d</td></tr>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
337 <tr><td>cara</td><td>:%s</td></tr>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
338 <tr><td>lv.</td><td>%d</td></tr>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
339 </table>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
340 </div>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
341
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
342 <div class="gage">
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
343 <p class="gage">exp</p>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
344 </div>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
345
|
870
|
346 <form method="POST" action="quest.rb">
|
883
|
347 %s
|
870
|
348 <input type="submit" value="~魔王の迷宮へ~">
|
|
349 </form>
|
|
350 <p>coin:%d$</p>
|
898
|
351 <table class="anime"><tr><td>
|
|
352
|
890
|
353 <form method="POST" action="prof.rb">
|
865
|
354 <label><input type="checkbox" name="hdn">宿屋<div><br>
|
890
|
355 <label><input type="radio" name="yado" value="g1">馬小屋:10$<img src="./img/food.png" width="16" height="16"></label><br>
|
898
|
356 <label><input type="radio" name="yado" value="g2">客室:50$<img src="./img/niku.png" width="16" height="16"></label><br><br>
|
870
|
357 <input type="reset" value="やめる">
|
883
|
358 <input type="submit" value="泊まる"></div></label>
|
898
|
359 </form>
|
|
360 </td><td>
|
|
361 <form method="POST" action="battle.rb">
|
|
362 <label><input type="checkbox" name="hdn">闘技場<div><br><br><br>
|
|
363 <label>%s</label>
|
|
364 <label><input type="submit" value="バトル"></label><br>
|
|
365 <label><input type="reset" value="いかない"></label></div></label>
|
|
366 <!--</div></label>-->
|
|
367 </form>
|
885
|
368 </td><td>
|
890
|
369
|
|
370 <form method="POST" action="cookie.rb">
|
883
|
371 <label><input type="checkbox" name="hdn">人生リセット<div><br><br><br>
|
|
372 <input type="reset" value="やめる">
|
|
373 <input type="submit" value="記憶を消す"></div></label>
|
898
|
374 </form>
|
821
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
375 </td></tr></table>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
376 <footer></footer>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
377 </body>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
378 </html>
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
379
|
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff
changeset
|
380 _EOS_
|