Mercurial > hgrepos > hgweb.cgi > skipweb
changeset 759:016bb33e7624
acc nameup
author | ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp> |
---|---|
date | Wed, 08 Jul 2015 18:58:54 +0900 |
parents | 999f46bf091e |
children | 9a5b38747cbf |
files | oasis2015/accountcheck.rb |
diffstat | 1 files changed, 4 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/oasis2015/accountcheck.rb Wed Jul 08 18:54:00 2015 +0900 +++ b/oasis2015/accountcheck.rb Wed Jul 08 18:58:54 2015 +0900 @@ -9,6 +9,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 = ? where id = ?" +#, 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)" @@ -54,6 +56,8 @@ lv = 1 # db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv) db.execute(sql, id) + db.execute(squp, name, id) + db.execute(toi, id) db.execute(item, id) end