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]
  pre = "%"

#####################################
##########秘密のこたえを設定##############
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 += 5
  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 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


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_, image, alt, name, 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">
<!--
-->
</style>
</head>

<body>
<header></header>
<h1>さかたっち</h1>
<img src=%s alt=%s width="133" height="133">

<p>
%sさん<br>
<br>
さかたポイント:%dp<br>
%s
</p>

%s
<footer></footer>
</body>
</html>

_EOS_
author	ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
date	Tue, 14 Jul 2015 19:24:23 +0900
parents	20860c80eaa0
children	1f0ce6bcfb80