Mercurial > hgrepos > hgweb.cgi > skipweb

changeset 1658:6fe6a425a499

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
kayaku,rbÊѹ¹1
author OOTANI Hiroyuki <c115036@g.koeki-u.ac.jp>
date Thu, 27 Jul 2017 00:00:35 +0900
parents ffaf3376dc92
children 4239bc112dc3
files event/oasis2017/ikusei/kayaku4.rb event/oasis2017/ikusei/rogin.rb
diffstat 2 files changed, 84 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/event/oasis2017/ikusei/kayaku4.rb	Wed Jul 26 23:46:35 2017 +0900
+++ b/event/oasis2017/ikusei/kayaku4.rb	Thu Jul 27 00:00:35 2017 +0900
@@ -5,6 +5,89 @@
 
 require 'cgi'
 require 'csv'
+require 'sqlite3'
+file = "db/point.sq3"
+#cookie関係
+cookie_id=c.cookies["id"][0]
+
+form_seikai=c["seikai"]  #ã‚‚ã—正解ã—ãŸã‚‰?ã¨ã‹ã˜ã‚ƒãªã„?
+form_name=c["playname"]  #åå‰å…¥åŠ›
+
+someValue="IKA"
+
+
+if cookie_id == nil
+  newid = Time.now.to_i.to_s + "/" + rand(99999).to_s
+  id = newid
+else
+  id = cookie_id
+end
+
+# idã‚’ã™ãcookieã§ç›¸æ‰‹ãƒ–ラウザã«é€ã‚‹
+# 変数ã®æœŸé™ã‚’24時間ã«è¨­å®šã—ã€expire変数ã«å…¥ã‚Œã‚‹
+expire = (Time.now+24*3600).gmtime.strftime("%a, %d %b %Y %H:%M:%S GMT")
+printf("Content-type: text/html; charset=UTF-8\n")
+printf("Set-Cookie: id=%s; expires=%s\n\n", id, expire)
+
+db = SQLite3::Database.new(file)
+db.execute("PRAGMA foreign_keys=on")
+db.execute("CREATE TABLE IF NOT EXISTS " +
+           "users(id text primary key, name text, creation text)")
+db.execute("CREATE TABLE IF NOT EXISTS " +
+           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id))")
+
+
+if form_seikai > "" && id > ''# ã‚‚ã—正解ã—ãŸã‚‰
+  db.execute("DELETE FROM point WHERE id=?", id)
+end
+
+# cookie関連ã¯ã“ã“ã¾ã§ã ã¨æ€ã£ã¦ã„ã‚‹
+
+################################################################## ユーザ登録
+playname = form_name
+if form_name > ""		# フォームã§nameãŒé€ã‚‰ã‚ŒãŸãªã‚‰ãれ優先
+  now = Time.now.strftime("%F %T")
+  db.execute("REPLACE INTO users VALUES(?, ?, ?)", id, form_name, now);
+else				# フォームã§nameãªã‘ã‚Œã°dbã‹ã‚‰
+  dbname = db.execute("SELECT name from users WHERE id=?", id)[0][0]
+  if dbname != nil
+    playname = dbname		# データベースã‹ã‚‰ã®ã®åå‰ã‚’プレイåã¨ã™ã‚‹
+  end
+end
+if playname == ""
+  print(<<-EOF)
+	<form action="#{File.basename($0)}" method="POST">
+	<p>プレイåを入れã¦ãã ã•ã„:
+	<input type="text" name="playname">
+	<input type="submit" value="é€ä¿¡">
+	<input type="reset" value="リセット">
+	</form>
+	EOF
+  exit
+end
+printf("<h1>%sã•ã‚“ã®ãƒãƒ£ãƒ¬ãƒ³ã‚¸</h1>\n", playname)
+################################################################## åˆå›žå‡¦ç†
+
+
+
+number = c["rd"]
+img = c["img"]
+def outinput(value, name)
+  printf("<label><input type=\"radio\" name=\"rd\" value=\"%s\">%s</label>", value, name)
+end
+
+def imgsrc(img)
+  printf("<img src=\"%s\">", img)
+end
+
+if number == ""  #åˆå›žèµ·å‹•æ™‚ã®ã¿
+  number = "1"    #numberã«"1"を代入
+end
+
+
+
+
+
 
 c = CGI.new(:accept_charset => "UTF-8")
 print "Content-type: text/html; charset=UTF-8\n\n"
--- a/event/oasis2017/ikusei/rogin.rb	Wed Jul 26 23:46:35 2017 +0900
+++ b/event/oasis2017/ikusei/rogin.rb	Thu Jul 27 00:00:35 2017 +0900
@@ -95,7 +95,7 @@
 printf(<<-EOF,
 	<!DOCTYPE html>
 	<html lang="ja">
-	<head><title>○○ゲーム</title></head>
+	<head><title>庄内雑学ゲーム</title></head>
 	<body>
 	<h1>%s</h1>
 	<p>%s</p>

yatex.org