--- a/minato2014/accountcheck.rb	Wed Jul 23 16:28:10 2014 +0900
+++ b/minato2014/accountcheck.rb	Wed Jul 23 19:23:08 2014 +0900
@@ -10,10 +10,11 @@
 
 begin
   result = db.execute("select * from main;")
+  max = "select max(id) from main where not id='ID';"
 rescue
-  db.execute("create table main(id INTEGER  PRIMARY KEY AUTOINCREMENT,name,sex,age,aria,job,stamp_status,stamp_img,exp,rank,magic)");
+  db.execute("create table main(id INTEGER PRIMARY KEY AUTOINCREMENT,name,sex,age,aria,job,stamp_status,stamp_img,exp,rank,magic)");
   db.execute("insert into main values('ID','名前','性別','年代','住所','職業','スタンプ状況','スタンプ画像','レベル','当選順位','本人確認用')");
-  result = db.execute("select * from main");
+  result = db.execute("select * from main;")
 end
 
 name = c["name"]
@@ -23,7 +24,8 @@
 aria = c["aria"]
 
 code = magic()
-id = result.length
+#id = result.length
+id = db.execute(max).flatten(2)[0] + 1
 #printf("%04d",id)
 
 mg = code[id]