Mercurial > hgrepos > hgweb.cgi > skipweb
changeset 934:3754420d61d0
add css
| author | OOTANI Hiroyuki <c115036@g.koeki-u.ac.jp> |
|---|---|
| date | Thu, 12 Nov 2015 14:00:46 +0900 |
| parents | 705efb33d418 (current diff) af7924c66c67 (diff) |
| children | d54779c7b166 |
| files | syuzai/syuzai.html |
| diffstat | 39 files changed, 400 insertions(+), 42 deletions(-) [+] |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/oasis2015/#gets.rb# Thu Nov 12 14:00:46 2015 +0900 @@ -0,0 +1,168 @@ +#!/usr/bin/env ruby22 +# -*- coding:utf-8 -*- + +require 'sqlite3' +require 'cgi' + +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 = ?" +cook = db.execute(data, person) +upd = "update test set pt = ? where id = ?" +goods = "update goods set g1 = ?, g2 = ?, g3 = ?, g4 = ?, g5 = ?, g6 = ? where id = ?" + + +name = cook[0][1] +pt = cook[0][7] +lv = cook[0][8] + +ticket = "select * from goods where id = ?" +have = db.execute(ticket, person) +g1 = have[0][1] +g2 = have[0][2] +g3 = have[0][3] +g4 = have[0][4] +g5 = have[0][5] +g6 = have[0][6] + +gets = c["sho"] +c1 = 10 #商品それぞれに対して消費するポイント +c2 = 6 +c3 = 8 +c4 = 2 +c5 = 5 +c6 = 100 +n1 = "オランダせんべい" #商品それぞれの名前 +n2 = "温ビール" +n3 = "ハンドクリーム" +n4 = "" + +h1 = "チケットを発行したよ!<br>海洋センター3階でスタッフの人と商品をこうかんしてね!" +if lv < 3 + h1 = "チケット発行できません!" + kekka = "レベル が たりないよ!" +elsif gets == "s1" && pt >= c1 + g1 += 1 + pt -= c1 + kekka = "#{n1}交換券をゲット!" +elsif gets == "s2" && pt >= c2 + g2 += 1 + pt -= c2 + kekka = "#{n2}交換券をゲット!" +elsif gets == "s3" && pt >= c3 + g3 += 1 + pt -= c3 + kekka = "#{n3}交換券をゲット!" +elsif gets == "s4" && pt >= c4 + g4 += 1 + pt -= c4 + kekka = "あめ交換券をゲット!" +elsif gets == "s5" && pt >= c5 + g5 += 1 + pt -= c5 + kekka = "10円金券をゲット!" +elsif gets == "s6" && pt >= c6 + g6 += 1 + pt -= c6 + kekka = "まぐろ交換券をゲット!" +else + h1 = "チケット発行できません!!" + kekka = "ポイントとかたりません!" +end + +trade = c["trade"] +if trade == n1 && g1 > 0 + g1 -= 1 + kekka = "#{n1} と交換します!<br>スタッフの人は、スタッフがボタンを押した場合のみ、交換してください!" + h1 = "#{n1}と交換します!<br>こぼさないで たべてね!" +elsif trade == n2 && g2 > 0 + g2 -= 1 + kekka = "#{n2} と交換します!<br>スタッフの人は、スタッフがボタンを押した場合のみ、年齢を確認してから交換してください!" + h1 = "#{n2} と交換します!<br>ひやしてから おうち で のんでね!" +elsif trade == n3 && g3 > 0 +g3 -= 1 +kekka = "#{n3} と交換します!<br>スタッフの人は、スタッフがボタンを押した場合のみ、交換してください!" + h1 = "#{n3}と交換します!" +elsif trade == n4 && g4 > 0 +g4 -= 1 +kekka = "あめ と交換します!<br>スタッフの人は、スタッフがボタンを押した場合のみ、交換してください!" +h1 = "あめと交換します!" +elsif trade == "10えん金券" && g5 > 0 +g5 -= 1 +kekka = " 10えん と交換します!<br>スタッフの人は、スタッフがボタンを押した場合のみ、交換してください!" +h1 = "10えんと交換します!" +elsif trade == "まぐろ" && g6 > 0 +g6 -= 1 +kekka = "まぐろ と交換します!<br>スタッフの人は、スタッフがボタンを押した場合のみ、交換してください!" +h1 = "まぐろと交換します!" +end + + + + + +db.execute(goods, g1, g2, g3, g4, g5, g6, person) +db.execute(upd, pt, person) + + +pre = "%" +printf(<<_EOS_, h1, name, pt, kekka, g1, g2, g4) + +<!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/tsuya.png"/> +<title>こうかん!</title> +<style type="text/css"> +<!-- +--> +</style> + +</head> + +<body> +<header></header> +<h1>さかたっち</h1> +<h2>%s</h2> +<p> +%sさん<br> +さかたポイント:%dp<br> +%s +</p> +<table> +<title>もっているチケット</title> +<tr><td> +オランダせんべい</td><td>:%d</td></tr><tr><td> +温ビール</td><td>:%d</td></tr><tr><td> +secret[3~/td><td>:%d</td></tr><tr><td> +</td><td></td></tr><tr><td> +</td><td></td></tr> +</table> +<br><br> +<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" placeholder="ここは スタッフ の 人 が つかうよ!"> +<input type="submit" value="スタッフ ぼたん"><br>スタッフじゃない人はおさないでね! +</form> + +<footer></footer> +</body> +</html> + + +_EOS_
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/oasis2015/admin/#check.rb# Thu Nov 12 14:00:46 2015 +0900 @@ -0,0 +1,151 @@ +#!/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") + +getAC1 = ARGV[0] +pass = "hogehogeboy" + +hsh = c["SQ1"] +hsh += c["SQ2"] + +pts = "<table><tr><th>id</th><td>name</td><td>cal</td><td>age</td><td>sex</td><td>aria</td><td>exp</td><td>pt</td><td>lv</td></tr>" + + +if c["SQ2"] == "toi" +pts = "<table><tr><th>id</th><td>q1</td><td>q2</td><td>q3</td><td>q4</td><td>q5</td><td>q6</td><td>q7</td><td>q8</td><td>q9</td><td>secret</td></tr>" +elsif c["SQ2"] == "time" +pts = "<table><tr><th>cd</th><td>now</td><td>id</td></tr>" +elsif c["SQ2"] == "goods" +pts = "<table><tr><th>id</th><td>おちゃ</td><td>しょうひん2</td><td>しょうひん3</td><td>しょうひん4</td><td>しょうひん5</td><td>しょうひん6</td></tr>" +elsif c["SQ2"] == "pass" +pts = "<table><tr><th>id</th><td>pass</td><td>name</td></tr>" + +end + + +###################################### +################SQ3################### +if c["SQ3"] == "" +else +upd = c["SQ3"] +db.execute(upd) +end + +################SQ3################### +###################################### + + + + +################################ +################################ +if hsh == "" +# pts = "hoge" + hsh = "select * from test" +else +end + +hsh2 = db.execute(hsh) +i = 0 +while i < hsh2.length + data = hsh2[i] + if c["SQ2"] == "toi" + pts += "<tr><th>#{data[0]}</th><td>#{data[1]}</td><td>#{data[2]}</td><td>#{data[3]}</td><td>#{data[4]}</td><td>#{data[5]}</td><td>#{data[6]}</td><td>#{data[7]}</td><td>#{data[8]}</td><td>#{data[9]}</td><td>#{data[10]}</td></tr>" + elsif c["SQ2"] == "time" + pts += "<tr><th>#{data[0]}</th><td>#{data[1]}</td><td>#{data[2]}</td></tr>" + elsif c["SQ2"] == "goods" + pts += "<tr><th>#{data[0]}</th><td>#{data[1]}</td><td>#{data[2]}</td><td>#{data[3]}</td><td>#{data[4]}</td><td>#{data[5]}</td><td>#{data[6]}</td></tr>" + else + pts += "<tr><th>#{data[0]}</th><td>#{data[1]}</td><td>#{data[2]}</td><td>#{data[3]}</td><td>#{data[4]}</td><td>#{data[5]}</td><td>#{data[6]}</td><td>#{data[7]}</td><td>#{data[8]}</td><td>#{data[9]}</td></tr>" + end + i += 1 +end +#end +pts += "</table>" + + +print"Content-type: text/html; charset=UTF-8\n\n" + + +###################################### +################if ~html############## + +#if getAC1 == pass + +printf(<<_EOS_, pts, hsh2.lenght) +<!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/tamago.png"/> + +<title>control</title> +<style type="text/css"> +<!-- +--> +</style> +</head> + +<body> +<header><p>test,toi,goods,time,num,pass<p></header> + + + +<h1>control</h1> +<form method="POST" action="check.rb?#{pass}"> +<input type="text" name="SQ1" value="select * from "> +<input type="text" name="SQ2" placeholder='test JOIN pass ON test.id==pass.id;' value="test"> +<input type="submit"> +</form> + +<form method="POST" action="check.rb?#{pass}"> +<input type="text" name="SQ3" size="42" placeholder='insert into test values(501, "foo", "inu", 40, "G", "sakata", 0,0,1)' value="update test set pt = 0 where id = 0"> +<input type="submit"> +</form> +<p>%s<br></p> + + +<address>skip@xxxx.co.jp</address> +<footer></footer> +</body> +</html> + +_EOS_ +############################################# +############################################# +#else +if getAC1 == "hoge" ###いらない行。accをつける前は"else"のみだった。 +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/tamago.png"/> +<title>さかたっち(go top!)</title> +<style type="text/css"> +</style></head> +<body><header></header> +<h1>さかたっち</h1> +<a href="../index.html">トップへ!</a> +<address>skip@xxxx.co.jp</address> +<footer></footer></body> +</html> +_EOS_ +end
--- a/syuzai/higawari/higawari.html Thu Nov 12 13:59:57 2015 +0900 +++ b/syuzai/higawari/higawari.html Thu Nov 12 14:00:46 2015 +0900 @@ -12,7 +12,9 @@ <p>ۤۤ꿩ۤۤѥåƥ</p> <h1></h1> -<p><a href="">....</a></p> +<p> +<a href="http://skip.koeki-prj.org/syuzai/higawari/higawari2.html">ؤŹ</a> +</p> <p><a href="">...</a></p> <p><a href="">..</a></p> <p><a href="">.</a></p>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/syuzai/higawari/higawari2.html Thu Nov 12 14:00:46 2015 +0900 @@ -0,0 +1,32 @@ +<html> +<head> +<meta http-equiv="Content-Type" content="text/html; charset=EUC-JP"> +<title>ؤ</title> +<link rel="stylesheet" type="text/css" href=".css"> +</head> + +<body> +<h1>ؤ</h1> +<h1>Ź</h1> +<p>Υϡ꿩</p> +<p><img src=""></p> +<p>ƾҲʸ</p> +<p>Υϡ꿩</p> +<p><img src=""></p> +<p>ƾҲʸ</p> +<p>Υϡ꿩</p> +<p><img src=""></p> +<p>ƾҲʸ</p> +<p>Υϡ꿩</p> +<p><img src=""></p> +<p>ƾҲʸ</p> +<p>Υϡ꿩</p> +<p><img src=""></p> +<p>ƾҲʸ</p> + +<p> +<a href="http://skip.koeki-prj.org/syuzai/higawari/higawari.html">ؤ</a> +</p> + +</body> +</html>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/syuzai/higawari/higawari2.html~ Thu Nov 12 14:00:46 2015 +0900 @@ -0,0 +1,31 @@ +<html> +<head> +<title>★日替わりランチ★</title> +<link rel="stylesheet" type="text/css" href=".css"> +</head> + +<body> +<h1>日替わりランチ</h1> +<h1>○○店</h1> +<p>月曜日のランチは○○定食</p> +<p><img src=""></p> +<p>内容紹介文</p> +<p>火曜日のランチは○○定食</p> +<p><img src=""></p> +<p>内容紹介文</p> +<p>水曜日のランチは○○定食</p> +<p><img src=""></p> +<p>内容紹介文</p> +<p>木曜日のランチは○○定食</p> +<p><img src=""></p> +<p>内容紹介文</p> +<p>金曜日のランチは○○定食</p> +<p>img src=""></p> +<p>内容紹介文</p> + +<p> +<a href="http://skip.koeki-prj.org/syuzai/higawari/higawari.html">日替わりランチへ +</p> + +</body> +</html>
--- a/syuzai/syuzai.html Thu Nov 12 13:59:57 2015 +0900 +++ b/syuzai/syuzai.html Thu Nov 12 14:00:46 2015 +0900 @@ -52,7 +52,7 @@ src="rupo/rupo1-150.jpg"></a></th><th><a href="./ijyuu.html"><img src="iturn/i20091123-1450-00.jpg" width="150" height="100"></a></th> <th><a href="zoo/index.html"><img src="zoo/domon_a.jpg" width="150" height="100"></a></th><th><a href="higawari/higawari.html"><img src="higawari/higawari.jpg"></a></th> -<th><a href="tokusan/tokusan.html"><img src="tokusan/"></a></th><th><a href="dezima/dezima.html"><img src="dezima/dezima4-150.JPG"></a></th></tr></tr> +<th><a href="tokusan/tokusan.html"><img src="tokusan/tokusan_top.jpg" width="150" height="100"></a></th><th><a href="dezima/dezima.html"><img src="dezima/dezima4-150.JPG"></a></th></tr></tr> </table>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/syuzai/tokusan/tokusan.css Thu Nov 12 14:00:46 2015 +0900 @@ -0,0 +1,14 @@ + +body{background: #ccffff;} + +h1{background: #ffcccc; + color: #ff0000; + text-align: center;} + +p{color: black;} + +h2{color: #ff6633; + text-align: center;} + +h3{color: #ff6633;} +
--- a/syuzai/tokusan/tokusan.html Thu Nov 12 13:59:57 2015 +0900 +++ b/syuzai/tokusan/tokusan.html Thu Nov 12 14:00:46 2015 +0900 @@ -17,46 +17,6 @@ -<h1><img src="IMG_20151003_164802.jpg"></h1> -<h1><img src="IMG_20151003_164835.jpg"></h1> -<h1><img src="IMG_20151003_164841.jpg"></h1> -<h1><img src="IMG_20151003_164909.jpg"></h1> -<h1><img src="IMG_20151003_164921.jpg"></h1> -<h1><img src="IMG_20151003_164943.jpg"></h1> -<h1><img src="IMG_20151003_164956.jpg"></h1> -<h1><img src="IMG_20151003_165014.jpg"></h1> -<h1><img src="IMG_20151003_165039.jpg"></h1> -<h1><img src="IMG_20151003_165052.jpg"></h1> -<h1><img src="IMG_20151003_165058.jpg"></h1> -<h1><img src="IMG_20151003_165104.jpg"></h1> -<h1><img src="IMG_20151003_165109.jpg"></h1> -<h1><img src="IMG_20151003_165113.jpg"></h1> -<h1><img src="IMG_20151003_165123.jpg"></h1> -<h1><img src="IMG_20151003_165129.jpg"></h1> -<h1><img src="IMG_20151003_165135.jpg"></h1> -<h1><img src="IMG_20151003_165147.jpg"></h1> -<h1><img src="IMG_20151003_165151.jpg"></h1> -<h1><img src="IMG_20151003_165209.jpg"></h1> -<h1><img src="IMG_20151003_165223.jpg"></h1> -<h1><img src="IMG_20151003_165240.jpg"></h1> -<h1><img src="IMG_20151003_165251.jpg"></h1> -<h1><img src="IMG_20151003_165255.jpg"></h1> -<h1><img src="IMG_20151003_165344.jpg"></h1> -<h1><img src="IMG_20151003_165350.jpg"></h1> -<h1><img src="IMG_20151003_165354.jpg"></h1> -<h1><img src="IMG_20151003_165359.jpg"></h1> -<h1><img src="IMG_20151003_165410.jpg"></h1> -<h1><img src="IMG_20151003_165416.jpg"></h1> -<h1><img src="IMG_20151003_165424.jpg"></h1> -<h1><img src="IMG_20151003_165430.jpg"></h1> -<h1><img src="IMG_20151003_165444.jpg"></h1> -<h1><img src="IMG_20151003_165448.jpg"></h1> -<h1><img src="IMG_20151003_165506.jpg"></h1> -<h1><img src="IMG_20151003_165511.jpg"></h1> -<h1><img src=""></h1> -<h1><img src=""></h1> -<h1><img src=""></h1> -<h1><img src=""></h1> <h1>⤷ʪä!ߤʹԤäƤߤƤ!</h1> </body>
