Mercurial > hgrepos > hgweb.cgi > skipweb
changeset 2464:6e90aa72efd2
prof.rb [][]
author | ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp> |
---|---|
date | Tue, 07 Jul 2015 23:46:32 +0900 |
parents | 5c017f9686a8 |
children | 687bb8211b76 |
files | oasis2015/accountcheck.rb oasis2015/prof.rb |
diffstat | 2 files changed, 29 insertions(+), 19 deletions(-) [+] |
line wrap: on
line diff
--- a/oasis2015/accountcheck.rb Tue Jul 07 23:39:22 2015 +0900 +++ b/oasis2015/accountcheck.rb Tue Jul 07 23:46:32 2015 +0900 @@ -19,9 +19,6 @@ db.execute(cle3) db.execute(cle4) -id = c.cookies["id"][0] -person = id.to_i - name = c["name"] cal = c["cal"] age = c["age"] @@ -49,7 +46,7 @@ Set-Cookie:id=%s ;expires=%s Set-Cookie:pass=%s ;expires=%s\n\n", id, expires, id2, expires) -printf(<<_EOS_, person, name, id.to_i) +printf(<<_EOS_, name, id.to_i) <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> @@ -57,7 +54,7 @@ <link rel="stylesheet" type="text/css" href="profeel.css"> </head> <body> -<h1>さかたっち%d</h1> +<h1>さかたっち</h1> <h2>登録が完了しました!</h2> <p>ようこそ_ %s _さん!</p> <p>あなたのIDは%04dです。抽選はこのIDを元に行われます。</p>
--- a/oasis2015/prof.rb Tue Jul 07 23:39:22 2015 +0900 +++ b/oasis2015/prof.rb Tue Jul 07 23:46:32 2015 +0900 @@ -8,6 +8,7 @@ id = c.cookies["id"][0] person = id.to_i + data = "select * from test where id = ?" #idが?(後で代入)のデータをtest票から探す。という命令をdataにしくむ。全てがほしい場合は「*」。「*」を「name」に変えると該当データのnameだけとりだす。 cook = db.execute(data, person) #dataに仕組んでいた命令を、personを代入しつつ実行。 jikan1 = "select * from time where cd = ?" @@ -19,21 +20,33 @@ bomd = "update test set pt = ? where id = ?" -name = cook[0][1] -cal = cook[0][2] -age = cook[0][3] -sex = cook[0][4] -aria = cook[0][5] -exp = cook[0][6] -pt = cook[0][7] -lv = cook[0][8] +#name = cook[0][1] +#cal = cook[0][2] +#age = cook[0][3] +#sex = cook[0][4] +#aria = cook[0][5] +#exp = cook[0][6] +#pt = cook[0][7] +#lv = cook[0][8] - -q1 = toi[0][1] -q2 = toi[0][2] -q3 = toi[0][3] -q4 = toi[0][4] -q5 = toi[0][5] +#q1 = toi[0][1] +#q2 = toi[0][2] +#q3 = toi[0][3] +#q4 = toi[0][4] +#q5 = toi[0][5] +name = "aa" +cal = "bb" +age = "cc" +sex = "dd" +aria = "ee" +exp = "3" +pt = "6" +lv = "9" +q1 = "n" +q2 = "n" +q3 = "n" +q4 = "n" +q5 = "n" per ="%"