# HG changeset patch # User ARAKI Tsuyohito # Date 1436425817 -32400 # Node ID 429ce9e53a8c360b71947d04b4447a6ba846beef # Parent 3708afa70fcbf13b3d7b8d7b785c7e0a97c2485f aria area diff -r 3708afa70fcb -r 429ce9e53a8c oasis2015/accountcheck.rb --- a/oasis2015/accountcheck.rb Wed Jul 08 20:16:24 2015 +0900 +++ b/oasis2015/accountcheck.rb Thu Jul 09 16:10:17 2015 +0900 @@ -7,9 +7,12 @@ c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8") db = SQLite3::Database.new("sql/main.sq3") + + #sql = "insert into test values(?, ?, ?, ?, ?, ?, ?, ?, ?)" sql = "insert into test values (?, 0, 0, 0, 0, 0, 0, 0, 0)" -squp = "update test set name = ?, cal = ?, age = ?, sex =? , aria =? , exp =? , pt = ?, lv =? where id = ?" +squp = "update test set name = ?, cal = ?, age = ?, sex = ? , aria = ? , exp = ? , pt = ?, lv = ? where id = ?" + toi = "insert into toi values (?, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)" item = "insert into goods values (?, 0, 0, 0, 0, 0, 0)" @@ -92,6 +95,6 @@ if name == "createman987987987" `rm sql/main.sq3` - `touch sql/main.sq3` - `chmod a+w sql/main.sq3` +# `touch sql/main.sq3` +# `chmod a+w sql/main.sq3` end diff -r 3708afa70fcb -r 429ce9e53a8c oasis2015/prof.rb --- a/oasis2015/prof.rb Wed Jul 08 20:16:24 2015 +0900 +++ b/oasis2015/prof.rb Thu Jul 09 16:10:17 2015 +0900 @@ -58,8 +58,6 @@ ##################ptを獲得した際の反応。#################### #########前の人が書き込んだ時間と比べて60秒以内なら追加ポイント#### kpt = 0 -tema = pt -pt = tema.to_i bom = c["bom"] ####
より if bom == "skip" jikan2 = db.execute(jikan1, "j")