Mercurial > hgrepos > hgweb.cgi > skipweb

annotate minato2014/accountcheck.rb @ 588:ba2206504e12

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
accountcheck.rb changed
author FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
date Fri, 25 Jul 2014 18:10:19 +0900
parents 6bb57e79ac91
children 6df136790f98
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
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
21 name = c["name"]
545
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
22 job = c["job"]
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
23 age = c["age"]
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
24 sex = c["sex"]
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
25 aria = c["aria"]
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
26
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
27 code = magic()
559
c512239aa312 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 558
diff changeset
28 #id = result.length
566
cad051518c1b Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 562
diff changeset
29 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
30 #printf("%04d",id)
529
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
31
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
32 mg = code[id]
545
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
33
566
cad051518c1b Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 562
diff changeset
34 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
35 db.execute(sql,name,sex,age,aria,job,'000010000','n,n,n,n,kamo,n,n,n,n',0,0,mg); #
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
36
571
9f99fdab102a Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 569
diff changeset
37 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
38
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
39 printf("Content-type: text/html; charset=UTF-8
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
40 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
41 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
42
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
43 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
44 <html>
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
45 <head>
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
46 <title>Registering Account</title>
f24e989eca53 選んだ性別と職に応じて画像を表示するプログラムとその画像プッシュ
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
47 <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
48 </head>'
585
6bb57e79ac91 accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 571
diff changeset
49 printf'
6bb57e79ac91 accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 571
diff changeset
50 <p>脂蚊絎篋障</p>
6bb57e79ac91 accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 571
diff changeset
51 <p>ID%04dс初吾ID茵障</p>
6bb57e79ac91 accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 571
diff changeset
52 <p>筝荐潟鴻帥潟若紮筝!</p>
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
53 <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
54 <p></p>
550
d6f37e2e9a2f Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents: 545
diff changeset
55
545
785e500c8003 login page add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 529
diff changeset
56 </body></html>
588
ba2206504e12 accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents: 585
diff changeset
57 ',id.to_i-1

yatex.org