Mercurial > hgrepos > hgweb.cgi > skipweb

annotate minato2014/accountcheck.rb @ 612:02a89288330c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
updated
author MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
date Sat, 26 Jul 2014 10:44:30 +0900
parents 030f81b61fa5
children 3c386da692cc
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
529
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
1 #!/usr/bin/env ruby
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
2 # -*- coding: utf-8 -*-
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
3
545
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
4 require 'sqlite3'
529
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
5 require 'cgi'
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
6 require './magic.rb'
529
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
7
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
8 c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8")
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
9 db = SQLite3::Database.new("sql/stamp.sq3")
529
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
10
545
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
11 begin
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
12 result = db.execute("select * from main;")
569
149fe4bb5398 Updated files(finished product) and make back up dir.
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 566
diff changeset
13 max = "select max(id) from main;"
545
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
14 rescue
566
cad051518c1b Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 562
diff changeset
15 db.execute("create table main(id INTEGER PRIMARY KEY AUTOINCREMENT,name,sex,age,aria,job,stamp_status,stamp_img,exp INTEGER,rank INTEGER,magic)");
cad051518c1b Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 562
diff changeset
16 db.execute("insert into main(name,sex,age,aria,job,stamp_status,stamp_img,exp,rank,magic) values('','у','綛岩撮','篏','傑キ','鴻帥潟倶','鴻帥潟糸','','綵檎篏','篋榊∈茯')");
559
c512239aa312 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 558
diff changeset
17 result = db.execute("select * from main;")
569
149fe4bb5398 Updated files(finished product) and make back up dir.
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 566
diff changeset
18 max = "select max(id) from main;"
545
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
19 end
529
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
20
600
b4a6d35c245d updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 599
diff changeset
21 id = c.cookies["id"][0]
593
6df136790f98 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 588
diff changeset
22 c_magic = c.cookies["magic"][0]
529
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
23 name = c["name"]
545
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
24 job = c["job"]
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
25 age = c["age"]
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
26 sex = c["sex"]
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
27 aria = c["aria"]
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
28
612
02a89288330c updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 611
diff changeset
29 begin
610
21f3ff965c03 updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 608
diff changeset
30 sel = 'select * from main where id=? magic=?'
612
02a89288330c updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 611
diff changeset
31 h = db.execute(sel, id.to_i, c_magic.to_i)
02a89288330c updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 611
diff changeset
32 rescue
02a89288330c updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 611
diff changeset
33 h == []
02a89288330c updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 611
diff changeset
34 end
606
8d9231f5cc97 updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 605
diff changeset
35
607
c4ca02958a58 updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 606
diff changeset
36 if id != nil && h != []
598
abc392e919b1 updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 593
diff changeset
37 update = 'update main set name=?, job=?, age=?, sex=?, aria=? where id=? and magic=?'
abc392e919b1 updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 593
diff changeset
38 mg = c_magic
600
b4a6d35c245d updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 599
diff changeset
39 db.execute(update, name, job, age, sex, aria, id.to_i, mg.to_i)
598
abc392e919b1 updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 593
diff changeset
40 else
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
41 code = magic()
566
cad051518c1b Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 562
diff changeset
42 id = db.execute(max).flatten(2)[0].to_i + 1
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
43 mg = code[id]
566
cad051518c1b Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 562
diff changeset
44 sql = "insert into main(name,sex,age,aria,job,stamp_status,stamp_img,exp,rank,magic) values (?,?,?,?,?,?,?,?,?,?);"
585
6bb57e79ac91 accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 571
diff changeset
45 db.execute(sql,name,sex,age,aria,job,'000010000','n,n,n,n,kamo,n,n,n,n',0,0,mg); #
593
6df136790f98 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 588
diff changeset
46 end
598
abc392e919b1 updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 593
diff changeset
47
571
9f99fdab102a Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 569
diff changeset
48 expires = "Sun, 27 Jul 2014 00:00:00 GMT"
545
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
49
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
50 printf("Content-type: text/html; charset=UTF-8
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
51 Set-Cookie:id=%s ;expires=%s
569
149fe4bb5398 Updated files(finished product) and make back up dir.
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 566
diff changeset
52 Set-Cookie:magic=%s;expires=%s\n\n",id,expires,mg.to_s,expires)
545
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
53
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
54 print'<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
529
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
55 <html>
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
56 <head>
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
57 <title>Registering Account</title>
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
58 <link rel="stylesheet" type="text/css" href="design.css">
545
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
59 </head>'
585
6bb57e79ac91 accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 571
diff changeset
60 printf'
6bb57e79ac91 accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 571
diff changeset
61 <p>脂蚊絎篋障</p>
6bb57e79ac91 accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 571
diff changeset
62 <p>ID%04dс初吾ID茵障</p>
6bb57e79ac91 accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 571
diff changeset
63 <p>筝荐潟鴻帥潟若紮筝!</p>
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
64 <p><a href="Bingo.rb"> >> Let\'s go to Stamp Rally << </a></p>
529
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
65 <p></p>
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
66
545
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
67 </body></html>
588
ba2206504e12 accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 585
diff changeset
68 ',id.to_i-1

yatex.org