--- a/minato2014/accountcheck.rb	Fri Jul 25 19:34:11 2014 +0900
+++ b/minato2014/accountcheck.rb	Fri Jul 25 19:36:41 2014 +0900
@@ -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"]
 
+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 = 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
-update = 'update main set name=?, job=?, age=?, sex=?, aria=? where id=? and magic=?'
-else
 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