@@ -396,8 +394,6 @@ #### -p sumexp - stamp = stamp_st.inject(:+) # 配列内の値を全て足す charST = rpg(job, sex, stamp, bingo, sumexp) # ユーザーのキャラクタステータス diff -r f00ce72f48e5 -r 149fe4bb5398 minato2014/accountcheck.rb --- a/minato2014/accountcheck.rb Wed Jul 23 21:25:09 2014 +0900 +++ b/minato2014/accountcheck.rb Thu Jul 24 11:52:08 2014 +0900 @@ -10,12 +10,12 @@ begin result = db.execute("select * from main;") - max = "select max(id) from main WHERE NOT id=1;" + max = "select max(id) from main;" rescue db.execute("create table main(id INTEGER PRIMARY KEY AUTOINCREMENT,name,sex,age,aria,job,stamp_status,stamp_img,exp INTEGER,rank INTEGER,magic)"); db.execute("insert into main(name,sex,age,aria,job,stamp_status,stamp_img,exp,rank,magic) values('名前','性別','年代','住所','職業','スタンプ状況','スタンプ画像','レベル','当選順位','本人確認用')"); result = db.execute("select * from main;") - max = "select max(id) from main WHERE NOT id=1;" + max = "select max(id) from main;" end name = c["name"] @@ -38,7 +38,7 @@ printf("Content-type: text/html; charset=UTF-8 Set-Cookie:id=%s ;expires=%s -Set-Cookie:magic=%s;expires=%s\n\n",id.to_s,expires,mg.to_s,expires) +Set-Cookie:magic=%s;expires=%s\n\n",id,expires,mg.to_s,expires) print' diff -r f00ce72f48e5 -r 149fe4bb5398 minato2014/bacup/Bingo.css --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/minato2014/bacup/Bingo.css Thu Jul 24 11:52:08 2014 +0900 @@ -0,0 +1,77 @@ +html,body { + width: 100%; + height: 100%; +} +div.outflam{ + width: 800px; + height: 1240px; + margin-left: auto; + margin-right: auto; + padding: 0 auto; + } + +div.top{ + background: #136cf9; + background-image: url("png/top.png"); + background-repeat: no-repeat; + border: thin solid #136cf9; + width: 100%; + height: 180px; + margin-top:0 auto; + margin-bottom:0 auto; + margin-left: auto; + margin-right: auto; + +} + +p { + margin:0; + padding-left: 5%; + font-weight: 900; + height: 5%; + width: 95%; + background: #136cf9; + border: thin solid #136cf9; +} + +div.center{ + border: thin solid #1d38ff; + background: #1d38ff; + width: 100%; + height: 45%; + margin-left: auto; + margin-right: auto; +} + +table { + background: white; + margin-left: auto; + margin-right: auto; + margin-top: 1%; + margin-bottom: auto; +} + +div.bottom{ + background: #45e2fe; + background-image: url("png/bottom.png"); + background-repeat: no-repeat; + background-position: center bottom; + border:thin solid #45e2fe; + width: 100%; + height: 150px; + margin-left: auto; + margin-right: auto; +} + +div.bottom img { + float: left; + margin-left: 15%; +} + +div.charSTATUS { + clear: right; + margin-top: 7%; + background: rgba(255,255,255,0.75); + width: 70%; +} + diff -r f00ce72f48e5 -r 149fe4bb5398 minato2014/bacup/Bingo.rb --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/minato2014/bacup/Bingo.rb Thu Jul 24 11:52:08 2014 +0900 @@ -0,0 +1,442 @@ +#!/usr/bin/env ruby +# -*- coding: utf-8 -*- + +require 'sqlite3' +require 'cgi' +require 'date' +require './sub.rb' +require 'net/http' + +c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8") +db = SQLite3::Database.new("sql/stamp.sq3") + +id = c.cookies["id"][0].to_i +magic = c.cookies["magic"][0].to_i +err = 0 # 不正な動きであれば負の値になる +sidesize = 3 +message = "はりきって行きましょう!
" # ビンゴ用テキスト + +print("Content-type: text/html; charset=UTF-8 \n\n") + +### DROP TABLE ### + +getcom = ARGV[0].to_s +drop = 'DROP TABLE main ;' +if getcom == 'ududlrllba' + db.execute(drop) +end + +###### + +### DELETE TABLE ### + +del = 'DELETE FROM main WHERE id=?' +if getcom == 'ududlrlrba' + db.execute(del, id) +end + +###### + +##### CHECKING UID ##### + +sql = "SELECT stamp_status, stamp_img, name, job, sex, exp FROM main WHERE id=? AND magic=?" +begin + user_data = db.execute(sql, id, magic) +rescue + user_data = [] +end + +if user_data == [] # ログインエラー(-1) + err -= 1 +end + +### LOGIN ERROR HTML ### + +if err == -1 + print' + + + + + +たいとる + +' +print' +

+アカウント登録ページへ接続中…
+* 3秒経っても移動しない場合はこちらから移動して下さい。 +

+' +if rank > 0 + print'

' +else + print'

' +end +# - ビンゴステータス処理 - # + +if rank > 0 + printf("

おめでとうございます!!
☆ %d等 ☆が当選しました!!

", rank) + # print'

抽選は終了しましたが、引続きゆる☆スタをお楽しみ下さい!!

' +end + +# End of top +print' +

+' +# Top message # + +bc = bingo.to_i - last_bingo.to_i + +if bc > 0 + message += '
おめでとう!' + bc.to_s + message += 'ビンゴ揃いました!!
' +end + +printf("

",message) + +## + +###### + +### CENTER ### +print' +

+ +' +for i in 0..2 + print'' + 3.times do |n| + if stamp_st[3*i+n].to_i > 0 + printf("\n", stamp_img[3*i+n], stamp_st[3*i+n]) + else + print"\n" + end + end + print'' +end +# End of center +print' +

$\"stamped\"$ %d

+' +###### + +### BOTTOM ### +print' +

+' +# - RPGの表示 - # + +name = user_data[0][2] +job = user_data[0][3] +sex = user_data[0][4] +exp = user_data[0][5] + +## GETTING EXP SUM ## + +sum_sql = 'SELECT SUM(exp) FROM main WHERE rank=0;' +sumexp = db.execute(sum_sql).flatten(2)[0] + +#### + +stamp = stamp_st.inject(:+) # 配列内の値を全て足す + +charST = rpg(job, sex, stamp, bingo, sumexp) # ユーザーのキャラクタステータス + +## UPDATE EXP ## + +update_exp = 'UPDATE main SET exp=? WHERE id=?;' +db.execute(update_exp, charST[2], id) + +#### + +## GETTING EXP SUM ## + +sum_sql = 'SELECT SUM(exp) FROM main WHERE rank=0;' +sumexp = db.execute(sum_sql).flatten(2)[0] + +#### + +stamp = stamp_st.inject(:+) # 配列内の値を全て足す + +charST = rpg(job, sex, stamp, bingo, sumexp) # ユーザーのキャラクタステータス + +printf(" + +

+ID:%04d
+NAME:%s
+あなたのLv: %d / 全員のLv: %d
+当選確率: %3.3f \% +

+", charST[0], id-1, name, charST[2],sumexp , charST[1]) + +# End of bottom +print'

' +# End of outflam +print'

' +###### + +print' + + +' +########## diff -r f00ce72f48e5 -r 149fe4bb5398 minato2014/bacup/accountcheck.rb --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/minato2014/bacup/accountcheck.rb Thu Jul 24 11:52:08 2014 +0900 @@ -0,0 +1,55 @@ +#!/usr/bin/env ruby +# -*- coding: utf-8 -*- + +require 'sqlite3' +require 'cgi' +require './magic.rb' + +c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8") +db = SQLite3::Database.new("sql/stamp.sq3") + +begin + result = db.execute("select * from main;") + max = "select max(id) from main;" +rescue + db.execute("create table main(id INTEGER PRIMARY KEY AUTOINCREMENT,name,sex,age,aria,job,stamp_status,stamp_img,exp INTEGER,rank INTEGER,magic)"); + db.execute("insert into main(name,sex,age,aria,job,stamp_status,stamp_img,exp,rank,magic) values('名前','性別','年代','住所','職業','スタンプ状況','スタンプ画像','レベル','当選順位','本人確認用')"); + result = db.execute("select * from main;") + max = "select max(id) from main;" +end + +name = c["name"] +job = c["job"] +age = c["age"] +sex = c["sex"] +aria = c["aria"] + +code = magic() +#id = result.length +id = db.execute(max).flatten(2)[0].to_i + 1 +#printf("%04d",id) + +mg = code[id] + +sql = "insert into main(name,sex,age,aria,job,stamp_status,stamp_img,exp,rank,magic) values (?,?,?,?,?,?,?,?,?,?);" +db.execute(sql,name,sex,age,aria,job,'000010000','n,n,n,n,kamo,n,n,n,n',1,0,mg); #初期値 + +expires = "Sun, 27 Jul 2016 00:00:00 GMT" + +printf("Content-type: text/html; charset=UTF-8 +Set-Cookie:id=%s ;expires=%s +Set-Cookie:magic=%s;expires=%s\n\n",id,expires,mg.to_s,expires) + +print' + + +Registering Account + +' +print' +

登録が完了しました。下記リンクからスタンプラリーを開始して下さい!

>> Let\'s go to Stamp Rally <<

+ + +'

おめでとうございます!!☆ %d等 ☆が当選しました!!

おめでとうございます!!
☆ %d等 ☆が当選しました!!