Mercurial > hgrepos > hgweb.cgi > skipweb
changeset 763:64b7d066bcd6
acc squp
| author | ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp> |
|---|---|
| date | Wed, 08 Jul 2015 19:05:40 +0900 |
| parents | 3409791b31fb |
| children | bf7d8db7b369 |
| files | oasis2015/accountcheck.rb |
| diffstat | 1 files changed, 2 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/oasis2015/accountcheck.rb Wed Jul 08 19:03:02 2015 +0900 +++ b/oasis2015/accountcheck.rb Wed Jul 08 19:05:40 2015 +0900 @@ -9,8 +9,7 @@ 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 cal = ? where id = ?" -#, 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)" @@ -56,7 +55,7 @@ lv = 1 # db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv) db.execute(sql, id) - db.execute(squp, cal, id) + db.execute(squp, name, cal, age, sex, aria, exp, pt, lv, id) db.execute(toi, id) db.execute(item, id)
