changeset 898:99ebd8665b87

hoge
author ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
date Thu, 29 Oct 2015 18:22:56 +0900
parents 915fd695766f
children 25f7b4ff3bc6
files opencampus2015/#battle.rb# opencampus2015/battle.rb opencampus2015/prof.rb opencampus2015/profeel.css opencampus2015/quest.rb
diffstat 5 files changed, 199 insertions(+), 205 deletions(-) [+]
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/opencampus2015/#battle.rb#	Thu Oct 29 18:22:56 2015 +0900
@@ -0,0 +1,181 @@
+#!/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")
+
+per = "%"
+id = c.cookies["id"][0]
+person = id.to_i
+
+data = "select * from test where id = ?"
+cook = db.execute(data, person)
+printf("Content-type: text/html; charset=UTF-8\n\n")
+
+begin
+id,name,cal,age,sex,aria,exp,pt,lv = cook[0]
+rescue
+printf(<<_EOS_)
+<!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/cabage.png"/>
+<title>Miyazac Quest</title>
+<style type="text/css">
+<!--
+-->
+</style>
+</head>
+
+<body>
+<header></header>
+<h1>記録が無くなったようだ...</h1><h2>記憶も消してやりなおしたまえ......</h2>
+<div class="f1"><a href="index.html"><div class="lets"><span>新規記憶の作成</span></div></a></div>
+<div class="f1"><a href="cookie.rb"><div class="lets"><span>作成前に記憶を消す</span></div></a></div>
+<address>skip&#x40;xxxx.co.jp</address>
+<footer></footer>
+</body>
+</html>
+
+_EOS_
+exit(0)            ##プログラム終了! これがないと以降のプログラムが動いてしまう。
+end
+
+#################キャラクタ#########
+chenge = c["chenge"].to_i
+box = db.execute("select * from box where id = ?",id)
+hoge,no1,e1,t1,tm1,no2,e2,t2,tm2,no3,e3,t3,tm3=box[0]
+newname = "select name from zukan where no = ?"
+if chenge == 2
+  db.execute("update box set no1=?,e1=?,t1=?,tm1=?,no2=?,e2=?,t2=?,tm2=? where id = ?",no2,e2,t2,tm2,no1,e1,t1,tm1,id)
+calname = db.execute(newname,no2)[0][0]
+
+db.execute("update test set cal = ? where id = ?",calname,id)
+elsif chenge == 3
+  db.execute("update box set no1=?,e1=?,t1=?,tm1=?,no3=?,e3=?,t3=?,tm3=? where id = ?",no3,e3,t3,tm3,no1,e1,t1,tm1,id)
+calname = db.execute(newname,no3)[0][0]
+db.execute("update test set cal = ? where id = ?",calname,id)
+end
+
+##################################レベル処理する####
+gage = 0
+e1 = db.execute("select e1 from box where id = ?",person)[0][0]#じぶんのidのboxにある一体目の経験値
+no1 = db.execute("select no1 from box where id = ?",person)[0][0]
+no2 = db.execute("select no2 from box where id = ?",person)[0][0].to_i#2体目id
+no3 = db.execute("select no3 from box where id = ?",person)[0][0].to_i#3体目id
+lv2 = db.execute("select lv2 from zukan where no = ?",no1)[0][0].to_i
+lv3 = db.execute("select lv3 from zukan where no = ?",no1)[0][0].to_i
+lv4 = db.execute("select lv4 from zukan where no = ?",no1)[0][0].to_i
+lv5 = db.execute("select lv5 from zukan where no = ?",no1)[0][0].to_i
+if e1 < lv2
+lv = 1
+gage = 100-(e1/lv2.to_f*100)
+elsif e1 >= lv5
+lv = 5
+gage = 0
+elsif e1 >= lv4
+lv = 4
+gage = 100-(e1-lv4)/(lv5-lv4.to_f)*100
+elsif e1 >= lv3
+lv = 3
+gage = 100-(e1-lv3)/(lv4-lv3.to_f)*100
+elsif e1 >= lv2
+lv = 2
+gage = 100-(e1-lv2)/(lv3-lv2.to_f)*100
+end#########################################
+
+
+image = "./img/#{cal}#{lv}.png"
+alt = "#{cal}.png"
+
+
+
+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
+
+printf(<<_EOS_, per, gage, per, per, per, color, cal, image, alt, name, person, cal, lv)
+
+
+<!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/cabage.png"/>
+<title>BATTLE!</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>%s</header>
+<h1>Miyazac Quest</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>
+
+<footer></footer>
+</body>
+</html>
+
+_EOS_
--- a/opencampus2015/battle.rb	Wed Oct 28 13:16:58 2015 +0900
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,177 +0,0 @@
-#!/usr/bin/env ruby22
-# -*- coding: utf-8 -*-
-require 'cgi'
-require 'sqlite3'
-require 'kconv'
-id = c.cookies["id"][0]
-person = id.to_i
-
-data = "select * from test where id = ?"
-cook = db.execute(data, person)
-printf("Content-type: text/html; charset=UTF-8\n\n")
-
-begin
-name = cook[0][1]
-cal = cook[0][2]
-age = cook[0][3]
-sex = cook[0][4]
-aria = cook[0][5]
-exp = cook[0][6]
-pt = cook[0][7]
-lv = cook[0][8]
-rescue
-printf(<<_EOS_)
-<!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/cabage.png"/>
-<title>Miyazac Quest</title>
-<style type="text/css">
-<!--
--->
-</style>
-</head>
-
-<body>
-<header></header>
-<h1>記録が無くなったようだ...</h1><h2>記憶も消してやりなおしたまえ......</h2>
-<div class="f1"><a href="index.html"><div class="lets"><span>新規記憶の作成</span></div></a></div>
-<div class="f1"><a href="cookie.rb"><div class="lets"><span>作成前に記憶を消す</span></div></a></div>
-<address>skip&#x40;xxxx.co.jp</address>
-<footer></footer>
-</body>
-</html>
-
-_EOS_
-exit(0)            ##プログラム終了! これがないと以降のプログラムが動いてしまう。
-end
-
-
-kkget = ""
-
-########################~ここまでpt処理~###################
-#######################################################
-
-##################################レベル処理する####
-gage = 0
-e1 = db.execute("select e1 from box where id = ?",person)[0][0]#じぶんのidのboxにある一体目の経験値
-no1 = db.execute("select no1 from box where id = ?",person)[0][0]
-no2 = db.execute("select no2 from box where id = ?",person)[0][0].to_i#2体目id
-no3 = db.execute("select no3 from box where id = ?",person)[0][0].to_i#3体目id
-lv2 = db.execute("select lv2 from zukan where no = ?",no1)[0][0].to_i
-lv3 = db.execute("select lv3 from zukan where no = ?",no1)[0][0].to_i
-lv4 = db.execute("select lv4 from zukan where no = ?",no1)[0][0].to_i
-lv5 = db.execute("select lv5 from zukan where no = ?",no1)[0][0].to_i
-if e1 < lv2
-lv = 1
-gage = 100-(e1/lv2.to_f*100)
-elsif e1 >= lv5
-lv = 5
-gage = 0
-elsif e1 >= lv4
-lv = 4
-gage = 100-(e1-lv4)/(lv5-lv4.to_f)*100
-elsif e1 >= lv3
-lv = 3
-gage = 100-(e1-lv3)/(lv4-lv3.to_f)*100
-elsif e1 >= lv2
-lv = 2
-gage = 100-(e1-lv2)/(lv3-lv2.to_f)*100
-end#########################################
-
-
-image = "./img/#{cal}#{lv}.png"
-alt = "#{cal}.png"
-
-
-
-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
-
-printf(<<_EOS_, per, gage, per, per, per, color, kakunin, kkget, image, alt, name, person, cal, lv)
-
-
-<!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/cabage.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><p>%s</p></header>
-<h1>Miyazac Quest</h1>
-<h2>%s</h2>
-
-<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>
-
-<footer></footer>
-</body>
-</html>
-
-_EOS_
--- a/opencampus2015/prof.rb	Wed Oct 28 13:16:58 2015 +0900
+++ b/opencampus2015/prof.rb	Thu Oct 29 18:22:56 2015 +0900
@@ -281,7 +281,7 @@
 ###################################--HTML--##################
 ###################################--------##################
 
-printf(<<_EOS_, per, gage, per, per, per, color, kakunin, kkget, image, alt, name, person, cal, lv, chengeform ,pt)
+printf(<<_EOS_, per, gage, per, per, per, color, kakunin, kkget, image, alt, name, person, cal, lv, chengeform,pt,chengeform)
 
 
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
@@ -301,7 +301,7 @@
 
 
 <link rel="shortcut icon" href="./img/cabage.png"/>
-<title>ほげほげ!</title>
+<title>Miyazac Quest!</title>
 <style type="text/css">
 <!--
 p.gage{
@@ -348,29 +348,30 @@
 <input type="submit" value="~魔王の迷宮へ~">
 </form>
 <p>coin:%d$</p>
-<table><tr><td>
-<!--
+<table class="anime"><tr><td>
+
 <form method="POST" action="prof.rb">
 <label><input type="checkbox" name="hdn">宿屋<div><br>
 <label><input type="radio" name="yado" value="g1">馬小屋:10$<img src="./img/food.png" width="16" height="16"></label><br>
-<label><input type="radio" name="yado" value="g2">客室:50$<img src="./img/niku.png" width="16" height="16"></label><br>
+<label><input type="radio" name="yado" value="g2">客室:50$<img src="./img/niku.png" width="16" height="16"></label><br><br>
 <input type="reset" value="やめる">
 <input type="submit" value="泊まる"></div></label>
-</div></label></form>
+</form>
+</td><td>
+<form method="POST" action="battle.rb">
+<label><input type="checkbox" name="hdn">闘技場<div><br><br><br>
+<label>%s</label>
+<label><input type="submit" value="バトル"></label><br>
+<label><input type="reset" value="いかない"></label></div></label>
+<!--</div></label>-->
+</form>
 </td><td>
 
 <form method="POST" action="cookie.rb">
-<label><input type="checkbox" name="hdn">闘技場<div><br><br><br>
-<input type="reset" value="いかない">
-<input type="submit" value="バトル"></div></label>
-</div></label></form>
-</td></tr><td>
--->
-<form method="POST" action="cookie.rb">
 <label><input type="checkbox" name="hdn">人生リセット<div><br><br><br>
 <input type="reset" value="やめる">
 <input type="submit" value="記憶を消す"></div></label>
-</div></label></form>
+</form>
 </td></tr></table>
 <footer></footer>
 </body>
--- a/opencampus2015/profeel.css	Wed Oct 28 13:16:58 2015 +0900
+++ b/opencampus2015/profeel.css	Thu Oct 29 18:22:56 2015 +0900
@@ -51,7 +51,7 @@
 table{margin-left:auto; margin-right: auto;}
 table.state{text-align:left;}
 table.state tr+tr+tr+tr{font-size:xx-large;}
-
+#table.anime td{border:solid red;}
 
 div.f1{padding:0% 0%;
 margin:1em 17em;}
@@ -73,3 +73,4 @@
 background: #eef;
 border: solid 2px navy;}
 
+ 
--- a/opencampus2015/quest.rb	Wed Oct 28 13:16:58 2015 +0900
+++ b/opencampus2015/quest.rb	Thu Oct 29 18:22:56 2015 +0900
@@ -10,18 +10,7 @@
 id = c.cookies["id"][0].to_i
 chenge = c["chenge"].to_i
 box = db.execute("select * from box where id = ?",id)
-no1 = box[0][1]
-e1 = box[0][2]
-t1 = box[0][3]
-tm1 = box[0][4]
-no2 = box[0][5]
-e2 = box[0][6]
-t2 = box[0][7]
-tm2 = box[0][8]
-no3 = box[0][9]
-e3 = box[0][10]
-t3 = box[0][11]
-tm3 = box[0][12]
+hoge,no1,e1,t1,tm1,no2,e2,t2,tm2,no3,e3,t3,tm3=box[0]
 newname = "select name from zukan where no = ?"
 if chenge == 2
   db.execute("update box set no1=?,e1=?,t1=?,tm1=?,no2=?,e2=?,t2=?,tm2=? where id = ?",no2,e2,t2,tm2,no1,e1,t1,tm1,id)
@@ -79,7 +68,6 @@
 exit(0)            ##プログラム終了! これがないと以降のプログラムが動いてしまう。
 end
 ##################################
-#card = "select " 設定してる予定のi1,i2,i3を選びたい。どこから? メインテーブル? それようのテーブル?
 exppoint = "select e1 from box where id = ?"  #じぶんのidのboxにある一体目の経験値
 expup = "update box set e1 = ? where id = ?"
 exp2 = db.execute(exppoint,id)

yatex.org