# HG changeset patch # User ARAKI Tsuyohito # Date 1445577676 -32400 # Node ID 667f8ae73792306c6db9aeb669c83021ed6901a2 # Parent 644d022c37d1ec0485f885abb43d6421a71e79c6 cle8 diff -r 644d022c37d1 -r 667f8ae73792 opencampus2015/accountcheck.rb --- a/opencampus2015/accountcheck.rb Fri Oct 23 13:29:32 2015 +0900 +++ b/opencampus2015/accountcheck.rb Fri Oct 23 14:21:16 2015 +0900 @@ -4,10 +4,11 @@ require 'sqlite3' require 'kconv' require 'cgi' +require 'csv' c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8") db = SQLite3::Database.new("sql/main.sq3") - +csv = "list.csv" sql = "insert into test values(?, ?, ?, ?, ?, ?, ?, ?, ?)" @@ -42,18 +43,12 @@ db.execute(cle7) db.execute(cle8) if name == "createman789789789" -db.execute(ins4, "a") -db.execute(ins4, "b") -db.execute(ins4, "c") -db.execute(ins4, "d") -db.execute(ins4, "e") -db.execute(ins4, "f") -db.execute(ins4, "g") -db.execute(ins4, "h") -db.execute(ins4, "i") -db.execute(ins4, "j") + ("a".."j").each{|x|db.execute(ins4,x)} db.execute(ins5) -system `sqlite3 -separator , /sql/main.sq3 ".import list.csv zukan"` #(cle8) +#system `sqlite3 -separator , /sql/main.sq3 ".import list.csv zukan"` #(cle8) +CSV.foreach(csv) do |row| +db.execute("INSERT INTO zukan VALUES(?,?,?,?,?,?,?)",*row) +end end name = c["name"] diff -r 644d022c37d1 -r 667f8ae73792 opencampus2015/prof.rb --- a/opencampus2015/prof.rb Fri Oct 23 13:29:32 2015 +0900 +++ b/opencampus2015/prof.rb Fri Oct 23 14:21:16 2015 +0900 @@ -234,23 +234,14 @@ #(exp=35の場合、5*10=『50%』、次のレベルアップまであと50%が必要、と分かる。) gage = 0 exp2 = exp -esa = "


" -if lv < 5 - while exp2 >= 10 - exp2 -= 10 - end - gage = 100-exp2*10 - esa =' -
-:0pt' -end +#esa = "


" + ######################## ###lv==5のとき画像を変える### -comm = "" kakunin = "" ######################### @@ -258,7 +249,7 @@ ###################################--HTML--################## ###################################--------################## -printf(<<_EOS_, per, gage, per, per, per, color, kakunin, kkget, image, alt, name, person, cal, lv, comm, pt, m1, mimg1, m2, mimg2, esa) +printf(<<_EOS_, per, gage, per, per, per, color, kakunin, kkget, image, alt, name, person, cal, lv, pt, m1, mimg1,m2,mimg2)

%s

-

Miyazac quest

+

Miyazac Quest

%s

@@ -320,23 +311,20 @@

exp

-%s - -

coin:%dp

+
+ +
+

coin:%d$


+
-
-
-
diff -r 644d022c37d1 -r 667f8ae73792 opencampus2015/profeel.css --- a/opencampus2015/profeel.css Fri Oct 23 13:29:32 2015 +0900 +++ b/opencampus2015/profeel.css Fri Oct 23 14:21:16 2015 +0900 @@ -1,5 +1,5 @@ body{text-align:center; -background:#bff; +background:#355; border:dashed 5px navy; } header{ @@ -30,8 +30,8 @@ header p {color:red;} h1{ -color:#e90; -border:solid 5px #fa0; +color:#0d4; +border:solid 5px #a00; border-style:double; background:url("./img/lvb.png"); background-color:red; diff -r 644d022c37d1 -r 667f8ae73792 opencampus2015/quest.rb --- a/opencampus2015/quest.rb Fri Oct 23 13:29:32 2015 +0900 +++ b/opencampus2015/quest.rb Fri Oct 23 14:21:16 2015 +0900 @@ -15,7 +15,7 @@ exppoint = "select e1 from box where id = ?" #じぶんのidのboxにある一体目の経験値 expup = "update box set e1 = ? where id = ?" exp2 = db.execute(exppoint,id) -exp = exp2[0][0].to_i +exp = exp2[0].to_i if cmps == "↑" exp += 2 end @@ -23,7 +23,7 @@ db.execute(expup,exp,id) -printf(<<_EOS_,cmps) +printf(<<_EOS_,cmps,exp2)

だぁんじょん%s

- +

%s

exp