Mercurial > hgrepos > hgweb.cgi > skipweb

annotate minato2014/bacup/Bingo1.rb @ 1735:93632e78829c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
audio Êѹ¹11
author OOTANI Hiroyuki <c115036@g.koeki-u.ac.jp>
date Fri, 28 Jul 2017 21:10:57 +0900
parents 345b851fea56
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
582
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
1 #!/usr/bin/env ruby
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
2 # -*- coding: utf-8 -*-
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
3
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
4 require 'sqlite3'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
5 require 'cgi'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
6 require 'date'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
7 require './sub.rb'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
8 require 'net/http'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
9
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
10 c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8")
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
11 db = SQLite3::Database.new("sql/stamp.sq3")
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
12
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
13 id = c.cookies["id"][0].to_i
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
14 magic = c.cookies["magic"][0].to_i
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
15 err = 0 # ä¸æ­£ãªå‹•ãã§ã‚ã‚Œã°è² ã®å€¤ã«ãªã‚‹
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
16 sidesize = 3
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
17 message = "ã¯ã‚Šãã£ã¦è¡Œãã¾ã—ょã†!<br>" # ビンゴ用テキスト
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
18
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
19 print("Content-type: text/html; charset=UTF-8 \n\n")
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
20
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
21 ### DROP TABLE ###
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
22
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
23 getcom = ARGV[0].to_s
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
24 drop = 'DROP TABLE main ;'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
25 if getcom == 'ududlrllba'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
26 db.execute(drop)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
27 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
28
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
29 ######
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
30
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
31 ### DELETE TABLE ###
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
32
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
33 del = 'DELETE FROM main WHERE id=?'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
34 if getcom == 'ududlrlrba'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
35 db.execute(del, id)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
36 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
37
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
38 ######
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
39
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
40 ##### CHECKING UID #####
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
41
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
42 sql = "SELECT stamp_status, stamp_img, name, job, sex, exp FROM main WHERE id=? AND magic=?"
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
43 begin
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
44 user_data = db.execute(sql, id, magic)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
45 rescue
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
46 user_data = []
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
47 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
48
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
49 if user_data == [] # ログインエラー(-1)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
50 err -= 1
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
51 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
52
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
53 ### LOGIN ERROR HTML ###
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
54
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
55 if err == -1
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
56 print'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
57 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
58 "http://www.w3.org/TR/html4/strict.dtd">
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
59 <html>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
60 <head>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
61 <meta http-equiv="refresh" content="2.5;http://skip.koeki-prj.org/minato2014/account.html">
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
62 </head>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
63 <title>ãŸã„ã¨ã‚‹</title>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
64 <body>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
65 '
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
66 print'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
67 <p> ログインã«å¤±æ•—ã—ã¾ã—ãŸã€‚ </p>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
68 <p>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
69 アカウント登録ページã¸æŽ¥ç¶šä¸­â€¦<br>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
70 * 3秒経ã£ã¦ã‚‚移動ã—ãªã„å ´åˆã¯<a href="account.html">ã“ã¡ã‚‰</a>ã‹ã‚‰ç§»å‹•ã—ã¦ä¸‹ã•ã„。
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
71 </p>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
72 </body>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
73 </html>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
74 '
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
75 exit
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
76 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
77
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
78 ######
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
79
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
80 ##########
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
81
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
82 ##### RE-ARRAYING STAMP_STATUS AND STAMP_IMG #####
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
83
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
84 # stamp status
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
85 stamp_st = user_data[0][0]
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
86 stamp_st = stamp_st.split(//) # 一文字ãšã¤åˆ†ã‘ã¦é…列ã«ã™ã‚‹
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
87 stamp_st = stamp_st.map {|s| s.to_i} # é…列内ã®æ–‡å­—列を数列ã«ãªãŠã™
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
88
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
89 # stamp img
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
90 stamp_img = user_data[0][1]
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
91 stamp_img = stamp_img.split(",") # 文字列を","ã§åŒºåˆ‡ã£ã¦é…列ã«ã™ã‚‹
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
92
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
93 ##########
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
94
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
95 ##### STAMPPING #####
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
96
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
97 ### Making randam number ###
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
98
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
99 def taiou(sidesize)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
100 srand(256788901)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
101 stamp = Hash.new("n")
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
102 stamp_name = ["kamo", "kite", "mame", "mo2usa", "inuwasi", "hanabu", "be", "UMIMARU", "pero"]
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
103 (sidesize**2).times do |n|
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
104 stamp[rand(10000000)] = stamp_name[n]
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
105 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
106 stamp
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
107 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
108
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
109 ######
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
110
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
111 ##### Checking bingo method #####
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
112
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
113 def bingocheck(start, sidesize, stepon, stamp, decision, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
114 nbox = []
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
115 setbox = Hash.new
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
116 if sidesize == stepon
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
117 x = sidesize
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
118 else
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
119 x = 1
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
120 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
121 x.times do |m|
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
122 start.step(sidesize*sidesize - 1, stepon) do |n|
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
123 nbox << n + m
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
124 if nbox.length == sidesize
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
125 dbox = Array.new(0) # next bingo or reach numbers(bingoed -> nothing)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
126 for i in nbox
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
127 if stamp[i] == 0
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
128 dbox << i
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
129 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
130 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
131 # sidesizeã«decisionã®å€¤ã‚’加ãˆã‚‹ã“ã¨ã§ã€ãƒ“ンゴã€æ¬¡ãƒ“ンゴã€ãƒªãƒ¼ãƒã‚’ãã‚Œãžã‚Œdecisionã«0,1,2を加ãˆã‚‹ã“ã¨ã§è¡¨ç¾ã€‚
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
132 if dbox.length == decision
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
133 setbox[dbox] = nbox
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
134 bingo << setbox
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
135 setbox = Hash.new
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
136 nbox = []
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
137 else
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
138 nbox = []
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
139 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
140 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
141 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
142 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
143 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
144 # bingo[{[ビンゴã¾ãŸã¯ãƒªãƒ¼ãƒã«å¿…è¦ãªç•ªå·] => [ビンゴã¾ãŸã¯ãƒªãƒ¼ãƒã®ãƒ©ã‚¤ãƒ³ã‚’å½¢æˆã™ã‚‹ç•ªå·]}]
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
145 ##########
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
146
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
147 bingo = # ç¾åœ¨ã®ãƒ“ンゴ数
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
148
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
149 ### Checking Access Cord(AC) ###
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
150
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
151 getAC = ARGV[0].to_i # URL?以é™ã®å¼•æ•°ã‚’å–å¾—
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
152 rightAC = taiou(sidesize) # taiouã§ç”Ÿæˆã—ãŸACã®ãƒãƒƒã‚·ãƒ¥
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
153 #p rightAC
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
154 rightAC = rightAC[getAC] # ACãŒæ­£ã—ã‘ã‚Œã°ã‚¹ã‚¿ãƒ³ãƒ—åãŒå…¥ã‚Šã€ç•°ãªã‚‹å ´åˆã¯n
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
155
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
156 ##### ACCESS LOG #####
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
157 t = Time.now
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
158 time = (t.hour * 3600) + (t.min * 60) + t.sec
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
159
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
160 ## Checking sql_master table. If sqlite_master don't have tablename, it create.
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
161
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
162 sql_master = "SELECT name FROM sqlite_master WHERE name='logs';"
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
163 check_master = db.execute(sql_master)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
164 sql_logs = 'CREATE TABLE logs(
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
165 id INTEGER PRIMARY KEY AUTOINCREMENT,
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
166 uid INTEGER,
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
167 ac TEXT,
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
168 time INTEGER);
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
169 '
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
170 if check_master == []
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
171 db.execute(sql_logs)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
172 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
173
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
174 ##########
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
175
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
176 begin
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
177 get_log = 'SELECT ac, time FROM logs WHERE uid=(SELECT MAX(id) FROM logs WHERE uid=?);' # ユーザーã®æœ€æ–°ã®ãƒ­ã‚°æƒ…報をå–å¾—
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
178 log_check = db.execute(get_log, id)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
179 rescue
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
180 print'GETTING LOG ERROR!'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
181 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
182 begin
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
183 log = 'INSERT INTO logs(uid, ac, time) VALUES(?, ?, ?)'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
184 db.execute(log, id, rightAC, time)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
185 rescue
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
186 print'INSERT LOG ERROR!'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
187 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
188 # /* memo: å†åº¦åŒã˜ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã‚’作る際ã¯ã‚¹ã‚¿ãƒ³ãƒ—用ã®ãƒ†ãƒ¼ãƒ–ルãŒã»ã—ã„。 */ #
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
189
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
190 ##########
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
191
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
192 ### ビンゴã—ãŸãƒ©ã‚¤ãƒ³ã‚’判定(decision = 0) ###
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
193 bingo = []
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
194 # 横
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
195 bingocheck(0, sidesize, 1, stamp_st, 0, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
196 # 縦
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
197 bingocheck(0, sidesize, sidesize, stamp_st, 0, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
198 # 左斜ã‚
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
199 bingocheck(0, sidesize, sidesize+1, stamp_st, 0, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
200 # å³æ–œã‚
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
201 bingocheck(sidesize-1, sidesize, sidesize-1, stamp_st, 0, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
202 #######
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
203
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
204 bingo = bingo.length # ビンゴã®æ•°
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
205 last_bingo = bingo
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
206
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
207 if rightAC != "n" # rightACãŒæ­£ã—ã‘ã‚Œã°
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
208
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
209 ### Update Stamp_status And Stamp_img ###
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
210
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
211 # Replacing Image #
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
212
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
213 index_st = []
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
214 stamp_st.length.times { |c|
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
215 if stamp_st[c] == 0
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
216 index_st << c
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
217 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
218 }
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
219
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
220 ### リーãƒï¼ˆdecision = 1）# [{[ビンゴã®ç•ªå·] => [リーãƒã‚’構æˆã™ã‚‹æ•°]}]
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
221 reach = []
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
222 # 横
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
223 bingocheck(0, sidesize, 1, stamp_st, 1, reach)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
224 # 縦
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
225 bingocheck(0, sidesize, sidesize, stamp_st, 1, reach)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
226 # 左斜ã‚
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
227 bingocheck(0, sidesize, sidesize+1, stamp_st, 1, reach)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
228 # å³æ–œã‚
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
229 bingocheck(sidesize-1, sidesize, sidesize-1, stamp_st, 1, reach)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
230 #######
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
231
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
232 begin
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
233 reach = reach[0].flatten(2)[0] # ビンゴã®ç•ªå·ã®ã¿æŠ½å‡º
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
234 rescue
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
235 reach = []
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
236 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
237
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
238 ### ビンゴã—ãŸãƒ©ã‚¤ãƒ³ã‚’判定(decision = 0) ###
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
239 bingo = []
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
240 # 横
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
241 bingocheck(0, sidesize, 1, stamp_st, 0, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
242 # 縦
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
243 bingocheck(0, sidesize, sidesize, stamp_st, 0, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
244 # 左斜ã‚
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
245 bingocheck(0, sidesize, sidesize+1, stamp_st, 0, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
246 # å³æ–œã‚
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
247 bingocheck(sidesize-1, sidesize, sidesize-1, stamp_st, 0, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
248 #######
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
249
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
250 bingo = bingo.length # ビンゴã®æ•°
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
251
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
252 # Updating stamp_st #
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
253 if stamp_img.include?(rightAC) == true # æ—¢ã«åŒåã®ã‚¹ã‚¿ãƒ³ãƒ—ãŒå…¥ã£ã¦ã„ãŸã‚‰
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
254 if stamp_st[stamp_img.index(rightAC)] < 9
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
255 stamp_st[stamp_img.index(rightAC)] += 1 # 対応ã™ã‚‹ã‚¹ã‚¿ãƒ³ãƒ—ã®ä½ç½®ã«1足ã™
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
256 message = "スタンプカウントãŒã€Œ1ã€å¢—ãˆã¾ã—ãŸ!(スタンプカウントã¯ã€Œ9ã€ãŒä¸Šé™ã§ã™)"
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
257 else
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
258 message="スタンプカウントMAX!!(※ã“れ以上ã“ã®ã‚¹ã‚¿ãƒ³ãƒ—ã®ã‚«ã‚¦ãƒ³ãƒˆã¯å¢—ãˆã¾ã›ã‚“)"
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
259 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
260 else
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
261 if reach != [] && bingo == 0 # ã¯ã˜ã‚ã®ãƒ“ンゴã¯å¿…ãš3回ã§å®Œæˆ
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
262 stamp_st[reach] += 1# ビンゴã«ãªã‚‹æ•°å­—を代入
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
263 stamp_img[reach] = rightAC
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
264 message = "æ–°ã—ã„スタンプをGETã—ã¾ã—ãŸ!" # Top message
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
265 else
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
266 randam_number = index_st[rand(index_st.length)] # スタンプã®å…¥ã£ã¦ã„ãªã„個所ã®ãªã‹ã‹ã‚‰ãƒ©ãƒ³ãƒ€ãƒ ã«ã²ã¨ã¤é¸ã¶
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
267 stamp_st[randam_number] += 1 # é¸ã°ã‚ŒãŸå€‹æ‰€ã«1足ã™
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
268 stamp_img[randam_number] = rightAC # stamp_stã¨åŒã˜å€‹æ‰€ã«stamp_imgã«ã‚¹ã‚¿ãƒ³ãƒ—ã®åå‰ã‚’代入
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
269 message = "æ–°ã—ã„スタンプをGETã—ã¾ã—ãŸ!" # Top message
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
270 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
271 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
272 ##
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
273
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
274 ### ビンゴã—ãŸãƒ©ã‚¤ãƒ³ã‚’判定(decision = 0) ###
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
275 bingo = []
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
276 # 横
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
277 bingocheck(0, sidesize, 1, stamp_st, 0, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
278 # 縦
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
279 bingocheck(0, sidesize, sidesize, stamp_st, 0, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
280 # 左斜ã‚
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
281 bingocheck(0, sidesize, sidesize+1, stamp_st, 0, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
282 # å³æ–œã‚
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
283 bingocheck(sidesize-1, sidesize, sidesize-1, stamp_st, 0, bingo)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
284 #######
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
285
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
286 bingo = bingo.length # ビンゴã®æ•°
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
287
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
288
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
289 ##
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
290
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
291 # Convert to string #
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
292
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
293 stamp_st_string = stamp_st.join
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
294 stamp_img_string = stamp_img.join(",")
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
295
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
296 ##
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
297
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
298 sql_update = "UPDATE main SET stamp_status=?, stamp_img=? WHERE id=?;"
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
299 db.execute(sql_update, stamp_st_string, stamp_img_string, id)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
300 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
301
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
302 ######
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
303
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
304 ##########
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
305
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
306 ##### HTML #####
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
307 print'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
308 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
309 "http://www.w3.org/TR/html4/strict.dtd">
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
310 <html>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
311 <head>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
312 <title>ãŸã„ã¨ã‚‹</title>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
313 <link rel="stylesheet" type="text/css" href="Bingo.css">
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
314 </head>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
315 <body>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
316 '
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
317 ### TOP ###
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
318
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
319 sql_rank = 'select rank from main where id=?;'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
320 rank = db.execute(sql_rank, id).flatten(2)[0].to_i
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
321
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
322 print'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
323 <div class="outflam">
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
324 '
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
325 if rank > 0
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
326 print'<div class="top" style="background: red;">'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
327 else
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
328 print'<div class="top">'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
329 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
330 # - ãƒ“ãƒ³ã‚´ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹å‡¦ç† - #
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
331
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
332 if rank > 0
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
333 printf("<h1>ãŠã‚ã§ã¨ã†ã”ã–ã„ã¾ã™!!<br>☆ %dç­‰ ☆ãŒå½“é¸ã—ã¾ã—ãŸ!!</h1>", rank)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
334 # print'<p>抽é¸ã¯çµ‚了ã—ã¾ã—ãŸãŒã€å¼•ç¶šãゆる☆スタをãŠæ¥½ã—ã¿ä¸‹ã•ã„!!</p>'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
335 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
336
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
337 # End of top
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
338 print'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
339 </div>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
340 '
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
341 # Top message #
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
342
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
343 bc = bingo.to_i - last_bingo.to_i
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
344
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
345 if bc > 0
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
346 message += '<br>ãŠã‚ã§ã¨ã†!' + bc.to_s
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
347 message += 'ビンゴæƒã„ã¾ã—ãŸ!!<br>'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
348 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
349
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
350 if rank > 0
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
351 printf("<p style=\"background:red; color:white;\">%sãŠã‚ã§ã¨ã†ã”ã–ã„ã¾ã™!☆ %dç­‰ ☆ãŒå½“é¸ã—ã¾ã—ãŸ!!</p>", message, rank)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
352 else
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
353 printf("<p style=\"background:#136cf9;\">%s</p>", message)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
354 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
355
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
356 ##
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
357
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
358 ######
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
359
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
360 ### CENTER ###
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
361 print'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
362 <div class="center">
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
363 <table border=1>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
364 '
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
365 for i in 0..2
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
366 print'<tr>'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
367 3.times do |n|
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
368 if stamp_st[3*i+n].to_i > 0
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
369 printf("<td width=170 height=170><img src=\"png/%s.png\" alt=\"stamped\" width=\"160\" height=\"160\"><span style=\"color: green; font-weight: 900;\">%d</span></td>\n", stamp_img[3*i+n], stamp_st[3*i+n])
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
370 else
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
371 print"<td width=170 height=170></td>\n"
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
372 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
373 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
374 print'<tr>'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
375 end
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
376 # End of center
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
377 print'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
378 </table>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
379 </div>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
380 '
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
381 ######
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
382
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
383 ### BOTTOM ###
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
384 print'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
385 <div class="bottom">
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
386 '
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
387 # - RPGã®è¡¨ç¤º - #
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
388
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
389 name = user_data[0][2]
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
390 job = user_data[0][3]
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
391 sex = user_data[0][4]
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
392 exp = user_data[0][5]
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
393
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
394 ## GETTING EXP SUM ##
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
395
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
396 sum_sql = 'SELECT SUM(exp) FROM main WHERE rank=0;'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
397 sumexp = db.execute(sum_sql).flatten(2)[0]
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
398
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
399 ####
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
400
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
401 stamp = stamp_st.inject(:+) # é…列内ã®å€¤ã‚’å…¨ã¦è¶³ã™
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
402
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
403 charST = rpg(job, sex, stamp, bingo, sumexp) # ユーザーã®ã‚­ãƒ£ãƒ©ã‚¯ã‚¿ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
404
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
405 ## UPDATE EXP ##
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
406
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
407 update_exp = 'UPDATE main SET exp=? WHERE id=?;'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
408 db.execute(update_exp, charST[2], id)
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
409
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
410 ####
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
411
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
412 ## GETTING EXP SUM ##
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
413
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
414 sum_sql = 'SELECT SUM(exp) FROM main WHERE rank=0;'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
415 sumexp = db.execute(sum_sql).flatten(2)[0]
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
416
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
417 ####
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
418
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
419 stamp = stamp_st.inject(:+) # é…列内ã®å€¤ã‚’å…¨ã¦è¶³ã™
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
420
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
421 charST = rpg(job, sex, stamp, bingo, sumexp) # ユーザーã®ã‚­ãƒ£ãƒ©ã‚¯ã‚¿ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
422
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
423 printf("
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
424 <!-- キャラクターイメージã®è¨­å®š -->
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
425 <div class=\"charIMG\">
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
426 <img src=\"png/%s.png\">
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
427 </div>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
428 <div class=\"charSTATUS\">
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
429 ID:%04d<br>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
430 NAME:%s<br>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
431 ã‚ãªãŸã®Lv: %d / 全員ã®Lv: %d<br>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
432 当é¸ç¢ºçŽ‡: %3.3f \%
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
433 <div>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
434 ", charST[0], id-1, name, charST[2],sumexp , charST[1])
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
435
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
436 # End of bottom
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
437 print'</div>'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
438 # End of outflam
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
439 print'</div>'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
440 ######
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
441
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
442 print'
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
443 </body>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
444 </html>
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
445 '
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
446 ##########

yatex.org