Mercurial > hgrepos > hgweb.cgi > skipweb
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