Mercurial > hgrepos > hgweb.cgi > skipweb

annotate opencampus2015/accountcheck.rb @ 2557:3e60e112134a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
hogehoge
author ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
date Sat, 25 Jul 2015 10:52:57 +0900
parents cd6017bd9a66
children 5a7fdc570aa9
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
2554
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
1 #!/usr/bin/env ruby22
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
2 # -*- coding: utf-8 -*-
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
3
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
4 require 'sqlite3'
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
5 require 'kconv'
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
6 require 'cgi'
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
7
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
8 c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8")
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
9 db = SQLite3::Database.new("sql/main.sq3")
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
10
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
11
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
12 sql = "insert into test values(?, ?, ?, ?, ?, ?, ?, ?, ?)"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
13
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
14 toi = "insert into toi values (?, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
15 item = "insert into goods values (?, 0, 0, 0, 0, 0, 0)"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
16
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
17 name = c["name"]
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
18
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
19 cle1 = "CREATE TABLE IF NOT EXISTS test(id, name, cal, age, sex, aria, exp, pt, lv)"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
20 cle2 = "CREATE TABLE IF NOT EXISTS toi(id, q1, q2, q3, q4, q5, q6, q7, q8, q9, q10)"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
21 cle3 = "CREATE TABLE IF NOT EXISTS goods(id, g1, g2, g3, g4, g5, g6)"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
22 cle4 = "CREATE TABLE IF NOT EXISTS time(cd, now, id)"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
23 cle5 = "CREATE TABLE IF NOT EXISTS num(cd, id)"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
24 cle6 = "CREATE TABLE IF NOT EXISTS pass(id, pass, name)"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
25
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
26 ins4 = 'insert into time values(?, 61, "n")'
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
27 ins5 = 'insert into num values("aa",0)'
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
28 ins6 = 'insert into pass values(?, ?, ?)'
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
29 num = "select id from num where cd = ?"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
30 numup = "update num set id = ? where cd = ?"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
31
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
32 db.execute(cle1)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
33 db.execute(cle2)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
34 db.execute(cle3)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
35 db.execute(cle4)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
36 db.execute(cle5)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
37 db.execute(cle6)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
38 if name == "createman789789789"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
39 db.execute(ins4, "a")
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
40 db.execute(ins4, "b")
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
41 db.execute(ins4, "c")
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
42 db.execute(ins4, "d")
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
43 db.execute(ins4, "e")
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
44 db.execute(ins4, "f")
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
45 db.execute(ins4, "g")
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
46 db.execute(ins4, "h")
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
47 db.execute(ins4, "i")
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
48 db.execute(ins4, "j")
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
49 db.execute(ins5)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
50 end
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
51
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
52 name = c["name"]
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
53 namae = "#{name}"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
54 cal = c["cal"]
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
55 age = c["age"]
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
56 sex = c["sex"]
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
57 aria = c["aria"]
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
58
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
59 id = c.cookies["id"][0]
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
60 pass = c.cookies["pass"][0]
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
61
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
62 if id == nil
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
63 number = db.execute(num, "aa")
2556
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
64 begin
2554
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
65 id = number[0][0].to_i + 1
2556
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
66 rescue
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
67 db.execute(ins4, "a")
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
68 db.execute(ins4, "b")
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
69 db.execute(ins4, "c")
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
70 db.execute(ins4, "d")
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
71 db.execute(ins4, "e")
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
72 db.execute(ins4, "f")
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
73 db.execute(ins4, "g")
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
74 db.execute(ins4, "h")
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
75 db.execute(ins4, "i")
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
76 db.execute(ins4, "j")
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
77 db.execute(ins5)
cd6017bd9a66 htpasswd
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2554
diff changeset
78 id = number[0][0].to_i + 1
2557
3e60e112134a hogehoge
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2556
diff changeset
79 end
3e60e112134a hogehoge
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents: 2556
diff changeset
80 exp = 0
2554
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
81 pt = 0
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
82 lv = 1
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
83 cd = "aa"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
84 if pass == nil
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
85 pass = id
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
86 end
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
87 db.execute(ins6, id, pass, name)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
88 db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
89 db.execute(toi, id)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
90 db.execute(item, id)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
91 db.execute(numup, id, cd)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
92 end
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
93 # srand(id.to_i)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
94 # id2 = rand(1000000)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
95 id2 = pass
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
96
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
97
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
98
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
99 expires = "SAT, 24 Oct 2015 00:00:00 GMT"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
100
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
101 printf("Content-type: text/html; charset=UTF-8
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
102 Set-Cookie:id=%s ;expires=%s
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
103 Set-Cookie:pass=%s ;expires=%s\n\n", id, expires, id2, expires)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
104
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
105 printf(<<_EOS_, name, id.to_i)
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
106 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
107 <html>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
108 <head>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
109
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
110 <meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no">
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
111 <meta name="format-detection" content="telephone=no">
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
112 <link media="only screen and (max-device-width:480px)" href="smart.css" type="text/css" rel="stylesheet" />
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
113 <link media="screen and (min-device-width:481px)" href="profeel.css" type="text/css" rel="stylesheet" />
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
114
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
115
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
116
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
117
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
118 <link rel="shortcut icon" href="./img/cabage.png"/>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
119 <title>Registering Account</title>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
120
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
121 </head>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
122 <body>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
123 <h1>ほげほげ</h1>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
124 <h2>登録が完了しました!</h2>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
125 <p>ようこそ_ %s _さん!</p>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
126 <p>あなたのIDは%04dです!</p>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
127 <div class="f1"><a href="prof.rb"><div class="lets"><span>始めよう!</span></div></a></div>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
128 <form method="POST" type="text">
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
129 </form>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
130 </body></html>
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
131 _EOS_
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
132
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
133
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
134 if name == "createman987987987"
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
135 `rm sql/main.sq3`
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
136 # `touch sql/main.sq3`
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
137 # `chmod a+w sql/main.sq3`
ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
parents:
diff changeset
138 end

yatex.org