Mercurial > hgrepos > hgweb.cgi > skipweb
changeset 2503:f4b965117e3c
ruby22
author | ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp> |
---|---|
date | Thu, 09 Jul 2015 17:02:26 +0900 |
parents | 429ce9e53a8c |
children | 860e03f72365 |
files | oasis2015/accountcheck.rb oasis2015/gets.rb oasis2015/gohan.rb oasis2015/prof.rb |
diffstat | 4 files changed, 73 insertions(+), 54 deletions(-) [+] |
line wrap: on
line diff
--- a/oasis2015/accountcheck.rb Thu Jul 09 16:10:17 2015 +0900 +++ b/oasis2015/accountcheck.rb Thu Jul 09 17:02:26 2015 +0900 @@ -1,4 +1,4 @@ -#!/usr/bin/env ruby +#!/usr/bin/env ruby22 # -*- coding: utf-8 -*- require 'sqlite3' @@ -9,9 +9,9 @@ db = SQLite3::Database.new("sql/main.sq3") -#sql = "insert into test values(?, ?, ?, ?, ?, ?, ?, ?, ?)" -sql = "insert into test values (?, 0, 0, 0, 0, 0, 0, 0, 0)" -squp = "update test set name = ?, cal = ?, age = ?, sex = ? , aria = ? , exp = ? , pt = ?, lv = ? where id = ?" +sql = "insert into test values(?, ?, ?, ?, ?, ?, ?, ?, ?)" +#sql = "insert into test values (?, 0, 0, 0, 0, 0, 0, 0, 0)" +#squp = "update test set name = ?, cal = ?, age = ?, sex = ? , aria = ? , exp = ? , pt = ?, lv = ? where id = ?" toi = "insert into toi values (?, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)" @@ -57,9 +57,9 @@ exp = 0 pt = 0 lv = 1 -# db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv) - db.execute(sql, id) - db.execute(squp, namae, cal, age, sex, aria, exp, pt, lv, id) + db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv) +# db.execute(sql, id) +# db.execute(squp, namae, cal, age, sex, aria, exp, pt, lv, id) db.execute(toi, id) db.execute(item, id)
--- a/oasis2015/gets.rb Thu Jul 09 16:10:17 2015 +0900 +++ b/oasis2015/gets.rb Thu Jul 09 17:02:26 2015 +0900 @@ -136,7 +136,7 @@ まぐろ</td><td>:%d</td></tr> </table> <br><br> -<a href="prof.rb">もどる!</a> +<div class="f1"><a href="prof.rb"><div class="lets"><span>もどる!</span></div></a></div> <br><br> <form method="POST" action="gets.rb"> <input type="text" name="trade" value="ここは スタッフ の 人 が つかうよ!">
--- a/oasis2015/gohan.rb Thu Jul 09 16:10:17 2015 +0900 +++ b/oasis2015/gohan.rb Thu Jul 09 17:02:26 2015 +0900 @@ -1,4 +1,4 @@ -#!/usr/bin/env ruby +#!/usr/bin/env ruby 22 # -*- coding: utf-8 -*- require 'cgi' require 'sqlite3' @@ -101,7 +101,7 @@ -modoru = '<br><a href="prof.rb"><div class="lets"><span>ホーム' +modoru = '<br><div class="f1"><a href="prof.rb"><div class="lets"><span>ホーム' back = modoru if lv < 5 && gohan == "g1" || lv < 5 && gohan == "g2" mo = '<input type="button" value="おかわり!" onclick="location.reload();" />' @@ -109,7 +109,7 @@ elsif lv >= 5 back += "<br>(レベルマックスだよ!)" end -back += '</span></div></a>' +back += '</span></div></a></div>' cook = db.execute(data, person) exp = cook[0][6]
--- a/oasis2015/prof.rb Thu Jul 09 16:10:17 2015 +0900 +++ b/oasis2015/prof.rb Thu Jul 09 17:02:26 2015 +0900 @@ -1,4 +1,4 @@ -#!/usr/bin/env ruby +#!/usr/bin/env ruby22 # -*- coding: utf-8 -*- require 'cgi' require 'sqlite3' @@ -22,6 +22,7 @@ toi = db.execute(que, person) bomd = "update test set pt = ? where id = ?" +ins4 = 'insert into time values(?, 61, "n")' name = cook[0][1] cal = cook[0][2] @@ -59,12 +60,29 @@ #########前の人が書き込んだ時間と比べて60秒以内なら追加ポイント#### kpt = 0 bom = c["bom"] ####<form ~~ name="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 == "skip" -jikan2 = db.execute(jikan1, "j") -now1 = jikan2[0][1] -nowper = jikan2[0][2] -now2 = Time.now.to_i -db.execute(timeupd, now2, person, "j") + 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秒以内なら~ @@ -73,49 +91,49 @@ end pt += 1 kpt += 1 -# db.execute(bomd, pt, person) + # db.execute(bomd, pt, person) end qrAC = qrc ###生成したハッシュには、"乱数"=>"記号"が入っている getAC = ARGV[0].to_i ###URL?以降の文字(特定の乱数)を取得 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") + 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 < 60 pt += 2 kpt += 2 end -pt += 10 -kpt += 10 + pt += 10 + kpt += 10 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") + 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 < 60 pt += 2 kpt += 2 end -pt += 10 -kpt += 10 + pt += 10 + kpt += 10 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") + 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 < 60 @@ -125,12 +143,12 @@ pt += 10 kpt += 10 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") + 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 @@ -140,12 +158,12 @@ pt += 10 kpt += 10 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") + 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 < 60 @@ -156,6 +174,7 @@ kpt += 10 end + db.execute(bomd, pt, person) db.execute(queupd, q1, q2, q3, q4, q5, person) @@ -247,7 +266,7 @@ #以下のprintfについて #pre*4はstyleの部分、<h2>{margin(本来OS_,per,gage,per,per,per,name...) -printf(<<_EOS_, per, gage, per, per, per, color, cook, cook2, kkget, image, alt, name, person, cal, lv, pt, m1, mimg1, m2, mimg2) +printf(<<_EOS_, per, gage, per, per, per, color, cook, kkget, image, alt, name, person, cal, lv, pt, m1, mimg1, m2, mimg2) <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" @@ -276,7 +295,7 @@ </head> <body> -<header><p>%s<br>%s</p></header> +<header><p>%s</p></header> <h1>さかたっち</h1> <h2>%s</h2>