Mercurial > hgrepos > hgweb.cgi > skipweb
annotate minato2014/accountcheck.rb @ 3622:9ff3188fd649
.txt file moved to .md
| author | HIROSE Yuuji <yuuji@koeki-u.ac.jp> |
|---|---|
| date | Sat, 19 May 2018 13:29:26 +0859 |
| parents | 18d605acb962 |
| children |
| rev | line source |
|---|---|
| 2406 | 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 ======= | |
| 2262 | 37 #!/usr/bin/env ruby |
| 38 # -*- coding: utf-8 -*- | |
| 39 | |
| 2279 | 40 require 'sqlite3' |
| 2262 | 41 require 'cgi' |
| 2283 | 42 require './magic.rb' |
| 2262 | 43 |
| 44 c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8") | |
| 2283 | 45 db = SQLite3::Database.new("sql/stamp.sq3") |
| 2262 | 46 |
| 2279 | 47 begin |
| 48 result = db.execute("select * from main;") | |
|
2302
350a801e8e74
Updated files(finished product) and make back up dir.
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
2296
diff
changeset
|
49 max = "select max(id) from main;" |
| 2279 | 50 rescue |
| 2296 | 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('名前','性別','年代','住所','職業','スタンプ状況','スタンプ画像','レベル','当選順位','本人確認用')"); | |
| 2292 | 53 result = db.execute("select * from main;") |
|
2302
350a801e8e74
Updated files(finished product) and make back up dir.
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
2296
diff
changeset
|
54 max = "select max(id) from main;" |
| 2279 | 55 end |
| 2262 | 56 |
| 2333 | 57 id = c.cookies["id"][0] |
| 2326 | 58 c_magic = c.cookies["magic"][0] |
| 2262 | 59 name = c["name"] |
| 2279 | 60 job = c["job"] |
| 61 age = c["age"] | |
| 62 sex = c["sex"] | |
| 63 aria = c["aria"] | |
| 64 | |
| 2345 | 65 begin |
| 2347 | 66 sel = 'select * from main where id=? AND magic=?' |
| 2345 | 67 h = db.execute(sel, id.to_i, c_magic.to_i) |
| 68 rescue | |
| 69 h == [] | |
| 70 end | |
| 2339 | 71 |
| 2340 | 72 if id != nil && h != [] |
| 2331 | 73 update = 'update main set name=?, job=?, age=?, sex=?, aria=? where id=? and magic=?' |
| 74 mg = c_magic | |
| 2333 | 75 db.execute(update, name, job, age, sex, aria, id.to_i, mg.to_i) |
| 2331 | 76 else |
| 2283 | 77 code = magic() |
| 2296 | 78 id = db.execute(max).flatten(2)[0].to_i + 1 |
| 2283 | 79 mg = code[id] |
| 2296 | 80 sql = "insert into main(name,sex,age,aria,job,stamp_status,stamp_img,exp,rank,magic) values (?,?,?,?,?,?,?,?,?,?);" |
|
2319
2245128efdf5
accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
2304
diff
changeset
|
81 db.execute(sql,name,sex,age,aria,job,'000010000','n,n,n,n,kamo,n,n,n,n',0,0,mg); #初期値 |
| 2326 | 82 end |
| 2331 | 83 |
| 2304 | 84 expires = "Sun, 27 Jul 2014 00:00:00 GMT" |
| 2279 | 85 |
| 2283 | 86 printf("Content-type: text/html; charset=UTF-8 |
| 87 Set-Cookie:id=%s ;expires=%s | |
|
2302
350a801e8e74
Updated files(finished product) and make back up dir.
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
2296
diff
changeset
|
88 Set-Cookie:magic=%s;expires=%s\n\n",id,expires,mg.to_s,expires) |
| 2279 | 89 |
| 2283 | 90 print'<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> |
| 2262 | 91 <html> |
| 92 <head> | |
| 93 <title>Registering Account</title> | |
| 94 <link rel="stylesheet" type="text/css" href="design.css"> | |
| 2279 | 95 </head>' |
|
2319
2245128efdf5
accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
2304
diff
changeset
|
96 printf' |
|
2245128efdf5
accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
2304
diff
changeset
|
97 <p>登録が完了しました。</p> |
|
2245128efdf5
accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
2304
diff
changeset
|
98 <p>あなたのIDは%04dです。抽選はこのIDを元に行われます</p> |
|
2245128efdf5
accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
2304
diff
changeset
|
99 <p>下記リンクからスタンプラリーを開始して下さい!</p> |
| 2283 | 100 <p><a href="Bingo.rb"> >> Let\'s go to Stamp Rally << </a></p> |
| 2262 | 101 <p></p> |
| 2283 | 102 |
| 2279 | 103 </body></html> |
|
2322
53f7849558d7
accountcheck.rb changed
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
2319
diff
changeset
|
104 ',id.to_i-1 |
| 2406 | 105 >>>>>>> other |
