Mercurial > hgrepos > hgweb.cgi > skipweb
changeset 2547:167c7b93c6c7
pass2 acc name
author | ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp> |
---|---|
date | Mon, 20 Jul 2015 18:12:31 +0900 |
parents | b0d372776440 |
children | 7cd61c54f41c |
files | oasis2015/accountcheck.rb |
diffstat | 1 files changed, 3 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/oasis2015/accountcheck.rb Mon Jul 20 18:09:17 2015 +0900 +++ b/oasis2015/accountcheck.rb Mon Jul 20 18:12:31 2015 +0900 @@ -21,11 +21,11 @@ cle3 = "CREATE TABLE IF NOT EXISTS goods(id, g1, g2, g3, g4, g5, g6)" cle4 = "CREATE TABLE IF NOT EXISTS time(cd, now, id)" cle5 = "CREATE TABLE IF NOT EXISTS num(cd, id)" -cle6 = "CREATE TABLE IF NOT EXISTS pass(id, pass)" +cle6 = "CREATE TABLE IF NOT EXISTS pass(id, pass, name)" ins4 = 'insert into time values(?, 61, "n")' ins5 = 'insert into num values("aa",0)' -ins6 = 'insert into pass values(?, ?)' +ins6 = 'insert into pass values(?, ?, ?)' num = "select id from num where cd = ?" numup = "update num set id = ? where cd = ?" @@ -71,7 +71,7 @@ if pass == nil pass = id end - db.execute(ins6, id, pass) + db.execute(ins6, id, pass, name) db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv) db.execute(toi, id) db.execute(item, id)