Mercurial > hgrepos > hgweb.cgi > skipweb

changeset 566:cad051518c1b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Updated
author MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
date Wed, 23 Jul 2014 21:14:18 +0900
parents 54816828dce6
children cdf96ef74054
files minato2014/Bingo.rb minato2014/accountcheck.rb
diffstat 2 files changed, 12 insertions(+), 13 deletions(-) [+]
line wrap: on
line diff
--- a/minato2014/Bingo.rb	Wed Jul 23 19:50:22 2014 +0900
+++ b/minato2014/Bingo.rb	Wed Jul 23 21:14:18 2014 +0900
@@ -59,11 +59,12 @@
         "http://www.w3.org/TR/html4/strict.dtd">
 <html>
 <head>
-<meta http-equiv="refresh" content="3;http://skip.koeki-prj.org/minato2014/account.html">
+<meta http-equiv="refresh" content="2.5;http://roy.e.koeki-u.ac.jp/~c112124/web/minato2014/account.html">
 </head>
 <title>たいとる</title>
 <body>
 '
+#<meta http-equiv="refresh" content="3;http://skip.koeki-prj.org/minato2014/account.html">
 print'
 <p> ログインに失敗しました。 </p>
 <p>
@@ -395,6 +396,8 @@
 
 ####
 
+p sumexp
+
 stamp = stamp_st.inject(:+)                 # 配列内の値を全て足す
 
 charST = rpg(job, sex, stamp, bingo, sumexp)      # ユーザーのキャラクタステータス
@@ -411,7 +414,6 @@
 sum_sql = 'SELECT SUM(exp) FROM main WHERE rank=0;'
 sumexp = db.execute(sum_sql).flatten(2)[0]
 
-
 ####
 
 stamp = stamp_st.inject(:+)                 # 配列内の値を全て足す
@@ -429,7 +431,7 @@
 あなたのLv: %d / 全員のLv: %d<br>
 当選確率: %3.3f \%
 <div>
-", charST[0], id,  name, charST[2],sumexp , charST[1])
+", charST[0], id-1,  name, charST[2],sumexp , charST[1])
 
 # End of bottom
 print'</div>'
--- a/minato2014/accountcheck.rb	Wed Jul 23 19:50:22 2014 +0900
+++ b/minato2014/accountcheck.rb	Wed Jul 23 21:14:18 2014 +0900
@@ -10,11 +10,12 @@
 
 begin
   result = db.execute("select * from main;")
-  max = "select max(id) from main where not id='ID';"
+  max = "select max(id) from main WHERE NOT id=1;"
 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("insert into main values('ID','名前','性別','年代','住所','職業','スタンプ状況','スタンプ画像','レベル','当選順位','本人確認用')");
+  db.execute("create table main(id INTEGER PRIMARY KEY AUTOINCREMENT,name,sex,age,aria,job,stamp_status,stamp_img,exp INTEGER,rank INTEGER,magic)");
+  db.execute("insert into main(name,sex,age,aria,job,stamp_status,stamp_img,exp,rank,magic) values('名前','性別','年代','住所','職業','スタンプ状況','スタンプ画像','レベル','当選順位','本人確認用')");
   result = db.execute("select * from main;")
+  max = "select max(id) from main WHERE NOT id=1;"
 end
 
 name = c["name"]
@@ -25,17 +26,13 @@
 
 code = magic()
 #id = result.length
-begin
-  id = db.execute(max).flatten(2)[0] + 1
-rescue
-  id = 2
-end
+id = db.execute(max).flatten(2)[0].to_i + 1
 #printf("%04d",id)
 
 mg = code[id]
 
-sql = "insert into main values (?,?,?,?,?,?,?,?,?,?,?);"
-db.execute(sql,id,name,sex,age,aria,job,'000010000','n,n,n,n,kamo,n,n,n,n','1','0',mg); #初期値
+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',1,0,mg); #初期値
 
 expires = "Sun, 27 Jul 2016 00:00:00 GMT"

yatex.org