Mercurial > hgrepos > hgweb.cgi > skipweb
annotate minato2014/accountcheck.rb @ 1157:227e24731dcc
merged
author | GOTO Sakuya<c113061@e.koeki-u.ac.jp> |
---|---|
date | Tue, 01 Dec 2015 22:38:11 +0900 |
parents | 9b51ab10dbac |
children |
rev | line source |
---|---|
673 | 1 <<<<<<< local |
2 #!/usr/bin/env ruby | |
3 # -*- coding: utf-8 -*- | |
4 | |
5 #require 'sqlite3' | |
6 require 'cgi' | |
7 | |
8 c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8") | |
9 #db = SQLite3::Database.new("sql/stump.sq3") | |
10 | |
11 print("Content-type: text/html; charset=UTF-8 \n\n") | |
12 | |
13 name = c["name"] | |
14 job = c["job"] | |
15 sex = c["sex"] | |
16 | |
17 print' | |
18 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" | |
19 "http://www.w3.org/TR/html4/strict.dtd"> | |
20 | |
21 <html> | |
22 <head> | |
23 <title>Registering Account</title> | |
24 <link rel="stylesheet" type="text/css" href="design.css"> | |
25 </head> | |
26 ' | |
27 printf' | |
28 <p>登録が完了しました。下記リンクからスタンプラリーカードを入手して下さい!</p> | |
29 <p><a href="hoge.rb?%s+%s+%s"> >> Let\'s go to Stamp Rally << </a></p> | |
30 ',name,job,sex | |
31 print' | |
32 <p></p> | |
33 <p><a href="account.html"> >> アカウント登録画面に戻る << </a></p> | |
34 ' | |
35 print'</body></html>' | |
36 ======= | |
529 | 37 #!/usr/bin/env ruby |
38 # -*- coding: utf-8 -*- | |
39 | |
545 | 40 require 'sqlite3' |
529 | 41 require 'cgi' |
550 | 42 require './magic.rb' |
529 | 43 |
44 c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8") | |
550 | 45 db = SQLite3::Database.new("sql/stamp.sq3") |
529 | 46 |
545 | 47 begin |
48 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
|
49 max = "select max(id) from main;" |
545 | 50 rescue |
566 | 51 db.execute("create table main(id INTEGER PRIMARY KEY AUTOINCREMENT,name,sex,age,aria,job,stamp_status,stamp_img,exp INTEGER,rank INTEGER,magic)"); |
52 db.execute("insert into main(name,sex,age,aria,job,stamp_status,stamp_img,exp,rank,magic) values('名前','性別','年代','住所','職業','スタンプ状況','スタンプ画像','レベル','当選順位','本人確認用')"); | |
559 | 53 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
|
54 max = "select max(id) from main;" |
545 | 55 end |
529 | 56 |
600 | 57 id = c.cookies["id"][0] |
593 | 58 c_magic = c.cookies["magic"][0] |
529 | 59 name = c["name"] |
545 | 60 job = c["job"] |
61 age = c["age"] | |
62 sex = c["sex"] | |
63 aria = c["aria"] | |
64 | |
612 | 65 begin |
614 | 66 sel = 'select * from main where id=? AND magic=?' |
612 | 67 h = db.execute(sel, id.to_i, c_magic.to_i) |
68 rescue | |
69 h == [] | |
70 end | |
606 | 71 |
607 | 72 if id != nil && h != [] |
598 | 73 update = 'update main set name=?, job=?, age=?, sex=?, aria=? where id=? and magic=?' |
74 mg = c_magic | |
600 | 75 db.execute(update, name, job, age, sex, aria, id.to_i, mg.to_i) |
598 | 76 else |
550 | 77 code = magic() |
566 | 78 id = db.execute(max).flatten(2)[0].to_i + 1 |
550 | 79 mg = code[id] |
566 | 80 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
|
81 db.execute(sql,name,sex,age,aria,job,'000010000','n,n,n,n,kamo,n,n,n,n',0,0,mg); #初期値 |
593 | 82 end |
598 | 83 |
571 | 84 expires = "Sun, 27 Jul 2014 00:00:00 GMT" |
545 | 85 |
550 | 86 printf("Content-type: text/html; charset=UTF-8 |
87 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
|
88 Set-Cookie:magic=%s;expires=%s\n\n",id,expires,mg.to_s,expires) |
545 | 89 |
550 | 90 print'<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> |
529 | 91 <html> |
92 <head> | |
93 <title>Registering Account</title> | |
94 <link rel="stylesheet" type="text/css" href="design.css"> | |
545 | 95 </head>' |
585
6bb57e79ac91
accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
571
diff
changeset
|
96 printf' |
6bb57e79ac91
accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
571
diff
changeset
|
97 <p>登録が完了しました。</p> |
6bb57e79ac91
accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
571
diff
changeset
|
98 <p>あなたのIDは%04dです。抽選はこのIDを元に行われます</p> |
6bb57e79ac91
accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
571
diff
changeset
|
99 <p>下記リンクからスタンプラリーを開始して下さい!</p> |
550 | 100 <p><a href="Bingo.rb"> >> Let\'s go to Stamp Rally << </a></p> |
529 | 101 <p></p> |
550 | 102 |
545 | 103 </body></html> |
588
ba2206504e12
accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
585
diff
changeset
|
104 ',id.to_i-1 |
673 | 105 >>>>>>> other |