--- a/event/oasis2017/idol/home.rb	Sat Jul 29 14:35:03 2017 +0900
+++ b/event/oasis2017/idol/home.rb	Sat Jul 29 15:12:39 2017 +0900
@@ -1,11 +1,10 @@
-
 # !/usr/bin/env ruby
 # coding: utf-8
 
 # tail -f /usr/local/apache2/logs/error_log
 
 require 'sqlite3'
-file = "../db/users.sq3"
+file = "../db/point.sq3"
 
 require 'cgi'
 c = CGI.new(:accept_charset => 'utf-8')
@@ -57,7 +56,7 @@
 # SELECTの検索結果に値があるかは [0] が nil かどうかで判定できる
 
 name = db.execute("SELECT name FROM users WHERE id=?", id)[0]
-
+qr_pt = db.execute("SELECT point FROM users WHERE id=?", id)[0]
 print(<<-EOF)
 
 
@@ -71,8 +70,8 @@
   end
 
   
-  r = db.execute("SELECT count(*) FROM point WHERE id=?", id)[0]
-  pt = (r ? r[0] : 0)
+ # r = db.execute("SELECT count(*) FROM point WHERE id=?", id)[0]
+ # pt = (r ? r[0] : 0)
 
   print(<<-EOF)
 <htm lang="ja">
@@ -92,7 +91,7 @@
 
 case gin
 when "red"
-  printf(<<-EOF,
+  printf(<<-"EOF"
 <div class="box1">
 <img src="red1.png">
 
@@ -100,11 +99,10 @@
 「一緒にQRコード探しにいこうよ！ %s さん！」</p>
 </div>
 EOF
- name)
 
 when "blue" 
 
-print(<<-EOF,
+print(<<-"EOF"
 <div class="box1">
 <img src="blue1.png">
 
@@ -113,9 +111,10 @@
 </div>
 
 EOF
+
 when "white"
 
-print(<<-EOF,
+print(<<-"EOF"
 <div class="box1">
 <img src="white1.png">
 <p>
@@ -138,11 +137,11 @@
 elsif ARGV[0] =="C" #三つ目
   point = "ID3"
 elsif ARGV[0] =="849054474888775292" #四つ目
-  point = "80"
+  point = "ID4"
 elsif ARGV[0] =="61520500659400819" #五つ目
-  point = "120"
+  point = "ID5"
 elsif ARGV[0] =="528856582528717535" #六つ目
-  point = "150"
+  point = "ID6"
 end
 
 if point
@@ -151,7 +150,7 @@
 r = db.execute("SELECT count(*) FROM point WHERE id=?", id)[0]
 pt = (r ? r[0].to_i : 0)
 
-printf("<br>現在の獲得ファン数：%s<br>",pt)
+printf("<br>現在の獲得ファン数：%s<br>",95*pt)
 
 if pt < 100
   printf("次の話までの目標獲得ファン数：%s<br>",100-pt)