--- a/oasis2015/accountcheck.rb	Mon Jul 13 15:30:02 2015 +0900
+++ b/oasis2015/accountcheck.rb	Mon Jul 13 16:14:08 2015 +0900
@@ -10,9 +10,6 @@
 
 
 sql = "insert into test values(?, ?, ?, ?, ?, ?, ?, ?, ?)"
-#sql = "insert into test values (?, 0, 0, 0, 0, 0, 0, 0, 0)"
-#squp = "update test set name = ?, 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)"
@@ -23,13 +20,18 @@
 cle2 = "CREATE TABLE IF NOT EXISTS toi(id, q1, q2, q3, q4, q5, q6, q7, q8, q9, q10)"
 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)"
 
 ins4 = 'insert into time values(?, 61, "n")'
+ins5 = 'insert into num values("aa",0)'
+num = "select id from num where cd = ?"
+numup = "update num set id = ? where cd = ?"
 
 db.execute(cle1)
 db.execute(cle2)
 db.execute(cle3)
 db.execute(cle4)
+db.execute(cle5)
 if name == "createman789789789"
 db.execute(ins4, "a")
 db.execute(ins4, "b")
@@ -41,6 +43,7 @@
 db.execute(ins4, "h")
 db.execute(ins4, "i")
 db.execute(ins4, "j")
+db.execute(ins5)
 end
 
 name = c["name"]
@@ -52,19 +55,21 @@
 
 id = c.cookies["id"][0]
 if id == nil
-  srand
-  id = rand(1000)
+#  srand
+#  id = rand(1000)
+  number = db.execute(num, "aa")
+  id = number[0][0].to_i + 1
   exp = 0
   pt = 0
   lv = 1
+  cd = "aa"
   db.execute(sql, id, name, cal, age, sex, aria, exp, pt, lv)
-#  db.execute(sql, id)
-#  db.execute(squp, namae, cal, age, sex, aria, exp, pt, lv, id)
 
   db.execute(toi, id)
   db.execute(item, id)
+  db.execute(numup, id, cd)
 end
-  srand(id.to_i)
+  srand(id.to_i)  
   id2 = rand(1000000)