%s
",message) +if rank > 0 + printf("%sおめでとうございます!☆ %d等 ☆が当選しました!!
", message, rank) +else + printf("%s
", message) +end ## diff --git a/minato2014/accountcheck.rb b/minato2014/accountcheck.rb index c0ae437..09d8a1a 100755 --- a/minato2014/accountcheck.rb +++ b/minato2014/accountcheck.rb @@ -34,7 +34,7 @@ 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" +expires = "Sun, 27 Jul 2014 00:00:00 GMT" printf("Content-type: text/html; charset=UTF-8 Set-Cookie:id=%s ;expires=%s diff --git a/minato2014/admin/.htaccess b/minato2014/admin/.htaccess index b2ecd58..f78c1c8 100644 --- a/minato2014/admin/.htaccess +++ b/minato2014/admin/.htaccess @@ -2,7 +2,7 @@ AddType "text/html; charset=utf-8" .rb AddType "text/html; charset=utf-8" .html Options +ExecCGI -AuthUserFile /home/www/skip/minato2014/admin/.htpasswd +AuthUserFile /home/irhome/c112/c112124/public_html/web/minato2014/admin/.htpasswd AuthGroupFile /dev/null AuthName "ǧ�ڥ�����" AuthType Basic diff --git a/minato2014/admin/.htpasswd b/minato2014/admin/.htpasswd index 8c96c9d..87e6762 100644 --- a/minato2014/admin/.htpasswd +++ b/minato2014/admin/.htpasswd @@ -1,2 +1,3 @@ fujix:fu5QjLTqbHEaQ shokok:9tQUls7fXzqMA +Murakami:7Y005Wtya7Ogw diff --git a/minato2014/admin/backup/.htaccess b/minato2014/admin/backup/.htaccess new file mode 100644 index 0000000..f78c1c8 --- /dev/null +++ b/minato2014/admin/backup/.htaccess @@ -0,0 +1,9 @@ +AddHandler cgi-script .rb +AddType "text/html; charset=utf-8" .rb +AddType "text/html; charset=utf-8" .html +Options +ExecCGI +AuthUserFile /home/irhome/c112/c112124/public_html/web/minato2014/admin/.htpasswd +AuthGroupFile /dev/null +AuthName "ǧ�ڥ�����" +AuthType Basic +require valid-user diff --git a/minato2014/admin/backup/.htpasswd b/minato2014/admin/backup/.htpasswd new file mode 100644 index 0000000..87e6762 --- /dev/null +++ b/minato2014/admin/backup/.htpasswd @@ -0,0 +1,3 @@ +fujix:fu5QjLTqbHEaQ +shokok:9tQUls7fXzqMA +Murakami:7Y005Wtya7Ogw diff --git a/minato2014/admin/backup/chusen.html b/minato2014/admin/backup/chusen.html new file mode 100644 index 0000000..5ee5e17 --- /dev/null +++ b/minato2014/admin/backup/chusen.html @@ -0,0 +1,26 @@ + + + +実行するとデータベースが書き変えられます。
+実行する際は注意してください。
+ + +c111126@g.koeki-u.ac.jp + + + diff --git a/minato2014/admin/backup/chusen.rb b/minato2014/admin/backup/chusen.rb new file mode 100755 index 0000000..7b23958 --- /dev/null +++ b/minato2014/admin/backup/chusen.rb @@ -0,0 +1,52 @@ +#!/usr/bin/env ruby +# -*- coding: utf-8 -*- + +require 'sqlite3' +require 'cgi' + +c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8") +db = SQLite3::Database.new("../sql/stamp.sq3") + +check = c['check'] +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 == "ID" || 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("Content-type: text/html; charset=UTF-8\n\n") + + printf("1等はIDが%04dの方!おめでとー!
\n",tousen[i].to_i) + printf("2等はIDが%04dと%04dと%04dの方!おめでとー!
\n",tousen[i+=1].to_i,tousen[i+=1].to_i,tousen[i+=1].to_i) +else + print"抽選はまだ行いませんよ
" +end diff --git a/minato2014/admin/backup/delete.html b/minato2014/admin/backup/delete.html new file mode 100644 index 0000000..bc9e85c --- /dev/null +++ b/minato2014/admin/backup/delete.html @@ -0,0 +1,26 @@ + + + +実行するとデータベースが削除されます。
+実行する際は注意してください。
+ + +c111126@g.koeki-u.ac.jp + + + diff --git a/minato2014/admin/backup/delete.rb b/minato2014/admin/backup/delete.rb new file mode 100755 index 0000000..a219b66 --- /dev/null +++ b/minato2014/admin/backup/delete.rb @@ -0,0 +1,36 @@ +#!/usr/bin/env ruby +# -*- coding: utf-8 -*- + +require 'sqlite3' +require 'cgi' + +db = SQLite3::Database.new("../sql/stamp.sq3") + +c = CGI.new(:accept_charaset => "UTF-8") +check = c['check'] +if check == "OK" + begin + db.execute("drop table main;") + db.extcute("drop table logs;") + text = "データを削除しました。
" + rescue + text = "データがありません。
" + end +else + text = "データは削除されません" +end + +printf("Content-type: text/html; charset=UTF-8\n\n") + +printf' + + +