changeset 3496:438590a064bc

henkou
author KASHIWAGURA Aya <c115046@?.koeki-u.ac.jp>
date Sat, 29 Jul 2017 21:07:19 +0900
parents 6cb60ae36bcf
children a7961ce245be 5d17e8e47d84
files event/oasis2017/idol/home.rb event/oasis2017/idol/red_1.rb
diffstat 2 files changed, 6 insertions(+), 23 deletions(-) [+]
line wrap: on
line diff
--- a/event/oasis2017/idol/home.rb	Sat Jul 29 19:45:19 2017 +0900
+++ b/event/oasis2017/idol/home.rb	Sat Jul 29 21:07:19 2017 +0900
@@ -46,7 +46,7 @@
 db.execute("CREATE TABLE IF NOT EXISTS " +
            "users(id text primary key, name text, creation text)")
 db.execute("CREATE TABLE IF NOT EXISTS " +
-           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id)" + "UNIQUE(id, keyword))")
+           "point(id, keyword text, FOREIGN KEY(id) REFERENCES users(id),"+"UNIQUE(id,keyword))" )
 
 if form_clr > "" && id > ''# クリアボタンが押されていたら
   db.execute("DELETE FROM point WHERE id=?", id)
@@ -77,13 +77,12 @@
   pt = (r ? r[0] : 0)
 
   print(<<-EOF)
-<htm lang="ja">
+<html lang="ja">
 <head><title>アイキス!★ホーム</title>
 <meta name="viewport" content="width=device-width, initial-scale=1" />
-<link rel="stylesheet" href="src/leaflet.css" />
 <script src="src/leaflet.js"></script>
 EOF
-
+#<link rel="stylesheet" href="src/leaflet.css" />
   printf("<link rel=\"stylesheet\" type=\"text/css\" href=\"%s.css\" >", gin)
   puts "<meta name=\"viewport\" content=\"width=device-width\">
 
@@ -131,11 +130,11 @@
 
 qr = ARGV[0]
 
-
+p id
 point = nil
 if ARGV[0] == "A" #1つ目
   point = "ID1"
-elsif ARGV[0] ="B" #二つ目
+elsif ARGV[0] =="B" #二つ目
   point = "ID2"
 elsif ARGV[0] =="C" #三つ目
   point = "ID3"
@@ -146,7 +145,7 @@
 elsif ARGV[0] =="528856582528717535" #六つ目
   point = "ID6"
 end
-
+p point
 if point
   db.execute("REPLACE INTO point VALUES(?, ?)", id, point)
   #db.execute("REPLACE INTO point VALUES(?)", id)
--- a/event/oasis2017/idol/red_1.rb	Sat Jul 29 19:45:19 2017 +0900
+++ b/event/oasis2017/idol/red_1.rb	Sat Jul 29 21:07:19 2017 +0900
@@ -57,19 +57,6 @@
 name = db.execute("SELECT name FROM users WHERE id=?", id)[0]
 
 
-
-
-
-
-
-
-
-
-
-
-
-
-
 open("red1a.txt","r:utf-8") do |cat|
 
   while line = cat.gets
@@ -126,9 +113,6 @@
  print(<<-"EOF")
 <p><b><a href="home.rb">NEXT LIVE……</a></b><br>
 
-次の話まで残り___ptだよ!
-
-
 
 </p>
 EOF

yatex.org