Mercurial > hgrepos > hgweb.cgi > skipweb

changeset 562:54816828dce6

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 19:50:22 +0900
parents a4130df7d730
children b057c38118fc cad051518c1b
files minato2014/Bingo.rb minato2014/accountcheck.rb
diffstat 2 files changed, 2 insertions(+), 9 deletions(-) [+]
line wrap: on
line diff
--- a/minato2014/Bingo.rb	Wed Jul 23 19:30:49 2014 +0900
+++ b/minato2014/Bingo.rb	Wed Jul 23 19:50:22 2014 +0900
@@ -395,13 +395,6 @@
 
 ####
 
-### GETTING EXP ###
-
-exp_sql = 'SELECT exp FROM main WHERE id=?'
-last_exp = db.execute(exp_sql).flatten(2)[0]
-
-######
-
 stamp = stamp_st.inject(:+)                 # 配列内の値を全て足す
 
 charST = rpg(job, sex, stamp, bingo, sumexp)      # ユーザーのキャラクタステータス
@@ -415,7 +408,7 @@
 
 ## GETTING EXP SUM ##
 
-sum_sql = 'SELECT SUM(exp) FROM main ;'
+sum_sql = 'SELECT SUM(exp) FROM main WHERE rank=0;'
 sumexp = db.execute(sum_sql).flatten(2)[0]
 
 
--- a/minato2014/accountcheck.rb	Wed Jul 23 19:30:49 2014 +0900
+++ b/minato2014/accountcheck.rb	Wed Jul 23 19:50:22 2014 +0900
@@ -28,7 +28,7 @@
 begin
   id = db.execute(max).flatten(2)[0] + 1
 rescue
-  id = 1
+  id = 2
 end
 #printf("%04d",id)

yatex.org