diff --git a/2014OC/accountcheck.rb b/2014OC/accountcheck.rb index c802ae1..ed794c7 100755 --- a/2014OC/accountcheck.rb +++ b/2014OC/accountcheck.rb @@ -45,7 +45,7 @@ db.execute(sql,name,sex,age,aria,job,'000010000','n,n,n,n,kamo1,n,n,n,n',0,0,mg); #初期値 end -expires = "SUN, 3 Aug 2014 24:00:00 GMT" +expires = "SUN, 17 Aug 2014 24:00:00 GMT" printf("Content-type: text/html; charset=UTF-8 Set-Cookie:id=%s ;expires=%s diff --git "a/2014OC/admin/\043drawLots.rb\043" "b/2014OC/admin/\043drawLots.rb\043" new file mode 100755 index 0000000..95c7c84 --- /dev/null +++ "b/2014OC/admin/\043drawLots.rb\043" @@ -0,0 +1,87 @@ +#!/usr/bin/env ruby +# -*- coding: utf-8 -*- + +require 'sqlite3' +require 'cgi' +require 'date' + +c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8") +db = SQLite3::Database.new("../sql/stamp.sq3") + +add = ENV["REMOTE_ADDR"] + +if /^(172\.19\.5\.|172\.17\.54\.|172\.21\.90\.)|118.21.142.107|202.214.125.107/ =~ add +check = c['check'] + +printf("Content-type: text/html; charset=UTF-8\n\n") + +sum = 'SELECT SUM(rank) FROM main WHERE NOT id=1;' +rank_sum = db.execute(sum).flatten(2)[0].to_i + +t = Time.now +expires = Time.local(2014, 8, 3, 8, 50) +expires2 = Time.local(2014, 8, 3, 17, 00) +if t > expires && t < expires2 +else + check = "" + puts check +end + +if check == "OK" + begin + result = db.execute("select id,exp,rank from main;") + rescue + exit + end + all = Array.new + for id,lv,rank in result + if id == 1 || lv == 0 || rank.to_i != 0 + next + end + lv.to_i.times do + all << id + end + end + + tousen = Array.new(0) + atari1 = rand(all.length) + tousen << all[atari1] + all.delete_if {|x| x == tousen[0]} + + sql = "update main set rank = 1 where id = ?;" + db.execute(sql,tousen[0]) + + sql = "update main set rank = 2 where id = ?;" + while tousen.length < 4 + srand + atari2 = rand(all.length) + hoge = all[atari2] + tousen << all[atari2] + all.delete_if {|x| x == hoge} + db.execute(sql,hoge) + end + + i=0 + + printf("

1等はIDが%04dの方!おめでとー!

\n",tousen[i].to_i-1) + printf("

2等はIDが%04dと%04dと%04dの方!おめでとー!

\n",tousen[i+=1].to_i-1,tousen[i+=1].to_i-1,tousen[i+=1].to_i-1) +print'

抽選ページ戻る

\n +

抽選ページ戻る

+' +else + print"

抽選はまだ行いませんよ

\n

抽選ページ戻る

" +end +else + printf("Content-type: text/html; charset=UTF-8\n\n") + + printf' + + +Delete table + + + +

管理者用ページのため閲覧できません。

' +end +print'' diff --git a/2014OC/admin/drawLots.rb b/2014OC/admin/drawLots.rb index 9ccf1c5..ceb570f 100755 --- a/2014OC/admin/drawLots.rb +++ b/2014OC/admin/drawLots.rb @@ -10,7 +10,7 @@ add = ENV["REMOTE_ADDR"] -if /^(172\.19\.5\.|172\.17\.54\.|172\.21\.90\.)|118.21.142.107|202.214.125.107/ =~ add +if /^(172\.19\.5\.|172\.17\.54\.|172\.21\.90\.)|118.21.142.107|202.214.125.107|192.168.43.255/ =~ add check = c['check'] printf("Content-type: text/html; charset=UTF-8\n\n") @@ -19,8 +19,8 @@ rank_sum = db.execute(sum).flatten(2)[0].to_i t = Time.now -expires = Time.local(2014, 8, 3, 8, 50) -expires2 = Time.local(2014, 8, 3, 17, 00) +expires = Time.local(2014, 8, 17, 8, 50) +expires2 = Time.local(2014, 8, 17, 9, 00) if t > expires && t < expires2 else check = "" @@ -65,7 +65,9 @@ printf("

1等はIDが%04dの方!おめでとー!

\n",tousen[i].to_i-1) printf("

2等はIDが%04dと%04dと%04dの方!おめでとー!

\n",tousen[i+=1].to_i-1,tousen[i+=1].to_i-1,tousen[i+=1].to_i-1) -print'

抽選ページ戻る

' +print'

抽選ページ戻る

\n +

抽選ページ戻る

+' else print"

抽選はまだ行いませんよ

\n

抽選ページ戻る

" end diff --git a/minato2014/bacup/Bingo2.rb b/minato2014/bacup/Bingo2.rb new file mode 100755 index 0000000..68811d4 --- /dev/null +++ b/minato2014/bacup/Bingo2.rb @@ -0,0 +1,436 @@ +#!/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") + +getcom = ARGV[0] + +### 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秒経っても移動しない場合はこちらから移動して下さい。 +

+ + +' + exit +end + +###### + +########## + +##### RE-ARRAYING STAMP_STATUS AND STAMP_IMG ##### + +# stamp status +stamp_st = user_data[0][0] +stamp_st = stamp_st.split(//) # 一文字ずつ分けて配列にする +stamp_st = stamp_st.map {|s| s.to_i} # 配列内の文字列を数列になおす + +# stamp img +stamp_img = user_data[0][1] +stamp_img = stamp_img.split(",") # 文字列を","で区切って配列にする + +########## + +##### STAMPPING ##### + +### Making randam number ### + +def taiou(sidesize) + srand(256788901) + stamp = Hash.new("n") + stamp_name = ["kamo", "kite", "mame", "mo2usa", "inuwasi", "hanabu", "be", "UMIMARU", "pero"] + (sidesize**2).times do |n| + stamp[rand(10000000)] = stamp_name[n] + end + stamp +end + +###### + +##### Checking bingo method ##### + +def bingocheck(start, sidesize, stepon, stamp, decision, bingo) + nbox = [] + setbox = Hash.new + if sidesize == stepon + x = sidesize + else + x = 1 + end + x.times do |m| + start.step(sidesize*sidesize - 1, stepon) do |n| + nbox << n + m + if nbox.length == sidesize + dbox = Array.new(0) # next bingo or reach numbers(bingoed -> nothing) + for i in nbox + if stamp[i] == 0 + dbox << i + end + end + # sidesizeにdecisionの値を加えることで、ビンゴ、次ビンゴ、リーチをそれぞれdecisionに0,1,2を加えることで表現。 + if dbox.length == decision + setbox[dbox] = nbox + bingo << setbox + setbox = Hash.new + nbox = [] + else + nbox = [] + end + end + end + end +end +# bingo[{[ビンゴまたはリーチに必要な番号] => [ビンゴまたはリーチのラインを形成する番号]}] +########## + +### Checking Access Cord(AC) ### + +getAC = ARGV[0].to_i # URL?以降の引数を取得 +rightAC = taiou(sidesize) # taiouで生成したACのハッシュ +#p rightAC +rightAC = rightAC[getAC] # ACが正しければスタンプ名が入り、異なる場合はn + +##### ACCESS LOG ##### +t = Time.now +time = (t.hour * 3600) + (t.min * 60) + t.sec + +## Checking sql_master table. If sqlite_master don't have tablename, it create. + +sql_master = "SELECT name FROM sqlite_master WHERE name='logs';" +check_master = db.execute(sql_master) +sql_logs = 'CREATE TABLE logs( +id INTEGER PRIMARY KEY AUTOINCREMENT, +uid INTEGER, +ac TEXT, +time INTEGER); +' +if check_master == [] + db.execute(sql_logs) +end + +########## + +begin + get_log = 'SELECT ac, time FROM logs WHERE uid=(SELECT MAX(id) FROM logs WHERE uid=?);' # ユーザーの最新のログ情報を取得 + log_check = db.execute(get_log, id) +rescue + print'GETTING LOG ERROR!' +end +begin + log = 'INSERT INTO logs(uid, ac, time) VALUES(?, ?, ?)' + db.execute(log, id, rightAC, time) +rescue + print'INSERT LOG ERROR!' +end +# /* memo: 再度同じようなシステムを作る際はスタンプ用のテーブルがほしい。 */ # + +########## + +### ビンゴしたラインを判定(decision = 0) ### +bingo = [] +# 横 +bingocheck(0, sidesize, 1, stamp_st, 0, bingo) +# 縦 +bingocheck(0, sidesize, sidesize, stamp_st, 0, bingo) +# 左斜め +bingocheck(0, sidesize, sidesize+1, stamp_st, 0, bingo) +# 右斜め +bingocheck(sidesize-1, sidesize, sidesize-1, stamp_st, 0, bingo) +####### + +bingo = bingo.length # ビンゴの数 +last_bingo = bingo + +if rightAC != "n" # rightACが正しければ + + ### Update Stamp_status And Stamp_img ### + + # Replacing Image # + + index_st = [] + stamp_st.length.times { |c| + if stamp_st[c] == 0 + index_st << c + end + } + + ### リーチ（decision = 1）# [{[ビンゴの番号] => [リーチを構成する数]}] + reach = [] + # 横 + bingocheck(0, sidesize, 1, stamp_st, 1, reach) + # 縦 + bingocheck(0, sidesize, sidesize, stamp_st, 1, reach) + # 左斜め + bingocheck(0, sidesize, sidesize+1, stamp_st, 1, reach) + # 右斜め + bingocheck(sidesize-1, sidesize, sidesize-1, stamp_st, 1, reach) + ####### + + begin + reach = reach[0].flatten(2)[0] # ビンゴの番号のみ抽出 + rescue + reach = [] + end + + ### ビンゴしたラインを判定(decision = 0) ### + bingo = [] + # 横 + bingocheck(0, sidesize, 1, stamp_st, 0, bingo) + # 縦 + bingocheck(0, sidesize, sidesize, stamp_st, 0, bingo) + # 左斜め + bingocheck(0, sidesize, sidesize+1, stamp_st, 0, bingo) + # 右斜め + bingocheck(sidesize-1, sidesize, sidesize-1, stamp_st, 0, bingo) + ####### + + bingo = bingo.length # ビンゴの数 + + # Updating stamp_st # + if stamp_img.include?(rightAC) == true # 既に同名のスタンプが入っていたら + if stamp_st[stamp_img.index(rightAC)] < 9 + stamp_st[stamp_img.index(rightAC)] += 1 # 対応するスタンプの位置に1足す + message = "スタンプカウントが「1」増えました!(スタンプカウントは「9」が上限です)" + else + message="スタンプカウントMAX!!(※これ以上このスタンプのカウントは増えません)" + end + else + if reach != [] && bingo == 0 # はじめのビンゴは必ず3回で完成 + stamp_st[reach] += 1# ビンゴになる数字を代入 + stamp_img[reach] = rightAC + message = "新しいスタンプをGETしました!" # Top message + else + randam_number = index_st[rand(index_st.length)] # スタンプの入っていない個所のなかからランダムにひとつ選ぶ + stamp_st[randam_number] += 1 # 選ばれた個所に1足す + stamp_img[randam_number] = rightAC # stamp_stと同じ個所にstamp_imgにスタンプの名前を代入 + message = "新しいスタンプをGETしました!" # Top message + end + end + ## + + ### ビンゴしたラインを判定(decision = 0) ### + bingo = [] + # 横 + bingocheck(0, sidesize, 1, stamp_st, 0, bingo) + # 縦 + bingocheck(0, sidesize, sidesize, stamp_st, 0, bingo) + # 左斜め + bingocheck(0, sidesize, sidesize+1, stamp_st, 0, bingo) + # 右斜め + bingocheck(sidesize-1, sidesize, sidesize-1, stamp_st, 0, bingo) + ####### + + bingo = bingo.length # ビンゴの数 + + + ## + + # Convert to string # + + stamp_st_string = stamp_st.join + stamp_img_string = stamp_img.join(",") + + ## + + sql_update = "UPDATE main SET stamp_status=?, stamp_img=? WHERE id=?;" + db.execute(sql_update, stamp_st_string, stamp_img_string, id) +end + +###### + +########## + +##### HTML ##### +print' + + + +たいとる + + + +' +### TOP ### + +sql_rank = 'select rank from main where id=?;' +rank = db.execute(sql_rank, id).flatten(2)[0].to_i + +print' +
+' +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 + +if rank > 0 + printf("

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

", message, rank) +else + printf("

%s

", message) +end + +## + +###### + +### 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' + + +' +##########