diff --git a/minato2014/accountcheck.rb b/minato2014/accountcheck.rb index a4859b1..e5922e1 100755 --- a/minato2014/accountcheck.rb +++ b/minato2014/accountcheck.rb @@ -18,7 +18,7 @@ max = "select max(id) from main;" end -c_id = c.cookies["id"][0] +id = c.cookies["id"][0] c_magic = c.cookies["magic"][0] name = c["name"] job = c["job"] @@ -26,19 +26,19 @@ sex = c["sex"] aria = c["aria"] -code = magic() -#id = result.length -id = db.execute(max).flatten(2)[0].to_i + 1 -#printf("%04d",id) - -mg = code[id] - -if c_id != nil && c_magic != nil +if id != nil && c_magic != nil update = 'update main set name=?, job=?, age=?, sex=?, aria=? where id=? and magic=?' +mg = c_magic +db.execute(update, name, job, age, sex, aria, id, mg) else +code = magic() +id = db.execute(max).flatten(2)[0].to_i + 1 +mg = code[id] sql = "insert into main(name,sex,age,aria,job,stamp_status,stamp_img,exp,rank,magic) values (?,?,?,?,?,?,?,?,?,?);" db.execute(sql,name,sex,age,aria,job,'000010000','n,n,n,n,kamo,n,n,n,n',0,0,mg); #初期値 +mg = code[id] end + expires = "Sun, 27 Jul 2014 00:00:00 GMT" printf("Content-type: text/html; charset=UTF-8