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>
 

yatex.org