# HG changeset patch # User ARAKI Tsuyohito # Date 1436280392 -32400 # Node ID 6e90aa72efd2e54cbd51e01484ea6d90198e29a9 # Parent 5c017f9686a85c537dca3c9956b3798dc243e808 prof.rb [][] diff -r 5c017f9686a8 -r 6e90aa72efd2 oasis2015/accountcheck.rb --- 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) @@ -57,7 +54,7 @@ -

さかたっち%d

さかたっち

登録が完了しました!

ようこそ_ %s _さん!

あなたのIDは%04dです。抽選はこのIDを元に行われます。

diff -r 5c017f9686a8 -r 6e90aa72efd2 oasis2015/prof.rb --- 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 ="%"