Mercurial > hgrepos > hgweb.cgi > skipweb

#!/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 = "%"
#####################################
##########秘密のこたえを設定##############
if cal == "inu"
m3 = "あゆ"
elsif cal == "sisip"
m3 = "ゆめ"
elsif cal == "kamon"
m3 = "ねぎ"
elsif cal == "boy"
m3 = "ふね"
elsif cal == "girl"
m3 = "かんざし"
else
m3 = "skipskip"
end
#####################################
#####################################


gohan = c["gohan"]
#himitu = ""
if gohan == "g1" && pt >= 1
  exp += 1
  pt -= 1
  db.execute(upd, exp, pt, person)
  kekka = "#{cal}が成長した!"
elsif gohan == "g2" && pt >= 3
  exp += 4
  pt -= 3
  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}"
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();" />'
#dmo = ""
  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_
author	SUZUKI Naoyuki <c111086@g.koeki-u.ac.jp>
date	Tue, 15 Dec 2015 19:21:54 +0900
parents	8e4818366063
children