changeset 868:8ce30665be64

rm
author ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
date Fri, 23 Oct 2015 13:21:03 +0900
parents ff7adfbeb4b4
children 644d022c37d1
files opencampus2015/#.htaccess# opencampus2015/#gohan.rb# opencampus2015/accountcheck.rb opencampus2015/prof.rb
diffstat 4 files changed, 6 insertions(+), 217 deletions(-) [+]
line wrap: on
line diff
--- a/opencampus2015/#.htaccess#	Thu Oct 22 21:51:29 2015 +0900
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-AddHandler cgi-script   .rb
-Options  +ExecCGI
-AddType "text/html; charset=utf-8" .html
--- a/opencampus2015/#gohan.rb#	Thu Oct 22 21:51:29 2015 +0900
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,208 +0,0 @@
-#!/usr/bin/env ruby22
-# -*- coding: utf-8 -*-
-require 'cgi'
-require 'sqlite3'
-require 'kconv'
-c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8")
-db = SQLite3::Database.new("sql/main.sq3")
-
-id = c.cookies["id"][0]
-person = id.to_i
-
-data = "select * from test where id = ?"
-   #idが?(後で代入)のデータをtest票から探す。という命令をdataにしくむ。全てがほしい場合は「*」。「*」を「name」に変えると該当データのnameだけとりだす。
-
-cook = db.execute(data, person)
-   #dataに仕組んでいた命令を、personを代入しつつ実行。
-
-upd = "update test set exp = ?, pt = ? where id = ?"
-   #「idが?3のとき、expを?1にする。ptを?2にする。」という命令文。
-lvupd = "update test set lv = ? where id = ?"
-
-que = "select q10 from toi where id = ?"
-queupd = "update toi set q10 = 1 where id = ?"
-q10 = db.execute(que, person)
-
-  name = cook[0][1]
-  cal = cook[0][2]
-  exp = cook[0][6]
-  pt = cook[0][7]
-  lv = cook[0][8]
-  per = "%"
-
-
-gohan = c["gohan"]
-
-if gohan == "g1" && pt >= 2
-  exp += 2
-  pt -= 2
-  db.execute(upd, exp, pt, person)  
-  kekka = "#{cal}が成長した!"
-elsif gohan == "g2" && pt >= 5
-  exp += 6
-  pt -= 5
-  db.execute(upd, exp, pt, person)
-  kekka = "#{cal}がすごく成長した!"
-elsif gohan == m3
-  if q10[0][0] == 0
-    exp += 10
-    db.execute(upd, exp, pt, person)  
-    kekka = ""
-    db.execute(queupd, person)
-  else
-    kekka ="しつもん に こたえられるのは いっかい だけだよ!"
-  end
-else
-  kekka = "ポイント が たりない!"
-end
-
-if gohan == m3
-elsif gohan == "g1"
-elsif gohan == "g2"
-else
-kekka = "こたえ が ちがうよ!"
-end
-
-
-if exp >= lv*10 && lv < 5
-  lv += 1
-  db.execute(lvupd, lv, person)
-  kekka += "<br>レベルが上がった!<br>レベルが#{lv}になった!"
-end
-
-
-if cal == "inu"
-  image = "./img/inu#{lv}.png"
-  alt = "inu#{lv}"
-elsif cal == "sisip"
-  image = "./img/sisip#{lv}.png"
-  alt = "sisip#{lv}"
-elsif cal == "kamon"
-  image = "./img/kamon#{lv}.png"
-  alt = "kamon#{lv}"
-elsif cal == "boy"
-  image = "./img/boy#{lv}.png"
-  alt = "boy#{lv}"
-elsif cal == "girl"
-  image = "./img/girl#{lv}.png"
-  alt = "girl#{lv}"
-elsif cal == "snake"
-  image = "./img/snake#{lv}.png"
-  alt = "snake#{lv}"
-else
-  image = "./img/snail.png"
-end
-
-if lv == 1
-  color = "black"
-elsif lv == 2
-  color = "navy"
-elsif lv == 3
-  color = "green"
-elsif lv == 4
-  color = "red"
-elsif lv == 5
-  color = "yellow"
-else
-  color = "pink"
-  image = "./img/snail.png"
-  alt = "snails_bug"
-end
-
-gage = 0
-exp2 = exp
-if lv < 5
-  while exp2 >= 10
-    exp2 -= 10
-  end
-  gage = 100-exp2*10
-end
-
-
-
-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();" />'
-  back = mo + modoru
-elsif lv >= 5
-  back += "<br>(レベルマックスだよ!)"
-end
-back += '</span></div></a></div>'
-
-cook = db.execute(data, person)
-exp = cook[0][6]
-pt = cook[0][7]
-lv = cook[0][8]
-  
-
-printf(<<_EOS_, per, gage, per, per, per, color, image, alt, name, person, cal, lv, pt, kekka, back)
-
-<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
-	"http://www.w3.org/TR/html4/strict.dtd">
-<html>
-<head>
-
-<meta name="viewport"
-content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no">
-<meta name="format-detection" content="telephone=no">
-<link media="only screen and (max-device-width:480px)"
-href="smart.css" type="text/css" rel="stylesheet" />
-<link media="screen and (min-device-width:481px)" href="profeel.css"
-type="text/css" rel="stylesheet" />
-
-<link rel="shortcut icon" href="./img/exp.png"/>
-<title>ごはぁん!</title>
-<style type="text/css">
-<!--
-p.gage{
-background:#adf;
-margin-left:0%s;
-margin-right:%d%s;
-text-align:left;
-border-radius: 10ex;
-}
-div.gage{
-background:#ddf;
-margin-left:20%s;
-margin-right:20%s;
-border-radius: 10ex;
-}
-
-div.cal div{float:left; border:solid %s;}
-
--->
-</style>
-</head>
-
-<body>
-<header></header>
-<h1>ほげほげ!</h1>
-
-<div class="cal">
-<div>
-<img src=%s alt=%s width="172" height="172">
-</div>
-<table class="state"><tr><td>name</td><td>:%s</td></tr>
-<tr><td>id</td><td>:%04d</td></tr>
-<tr><td>cara</td><td>:%s</td></tr>
-<tr><td>lv.</td><td>%d</td></tr>
-</table>
-</div>
-
-<div class="gage">
-<p class="gage">exp</p>
-</div>
-
-<p>
-
-こうえきポイント:%dp<br>
-%s
-</p>
-
-%s
-<footer></footer>
-</body>
-</html>
-
-_EOS_
--- a/opencampus2015/accountcheck.rb	Thu Oct 22 21:51:29 2015 +0900
+++ b/opencampus2015/accountcheck.rb	Fri Oct 23 13:21:03 2015 +0900
@@ -53,7 +53,7 @@
 db.execute(ins4, "i")
 db.execute(ins4, "j")
 db.execute(ins5)
-system `sqlite3 -separator , /sql/main.sq3 ".import list.csv"`
+system `sqlite3 -separator , /sql/main.sq3 ".import list.csv zukan"` #(cle8)
 end
 
 name = c["name"]
@@ -127,10 +127,10 @@
 
 </head>
 <body>
-<h1>ほげほげ</h1>
-<h2>登録が完了しました!</h2>
-<p>ようこそ_ %s _さん!</p>
-<p>あなたのIDは%04dです!</p>
+<h1>Miyazac Quest</h1>
+<h2>登録完了!</h2>
+<p>よくきた_ %s _よ!</p>
+<p>おまえのIDは%04dだ!</p>
 <div class="f1"><a href="prof.rb"><div class="lets"><span>始めよう!</span></div></a></div>
 <form method="POST" type="text">
 </form>
--- a/opencampus2015/prof.rb	Thu Oct 22 21:51:29 2015 +0900
+++ b/opencampus2015/prof.rb	Fri Oct 23 13:21:03 2015 +0900
@@ -322,7 +322,7 @@
 
 %s
 
-<p>こうえきポイント:%dp</p>
+<p>coin:%dp</p>
 <table><tr><td>
 <form method="POST" action="gohan.rb">
 <label><input type="checkbox" name="hdn">宿屋<div><br>

yatex.org