557
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
1 #!/usr/bin/env ruby
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
2 # -*- coding: utf-8 -*-
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
3
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
4 require 'sqlite3'
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
5 require 'cgi'
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
6
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
7 db = SQLite3::Database.new("/sql/stamp.sq3")
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
8
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
9 c = CGI.new(:accept_charaset => "UTF-8")
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
10 check = c['check']
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
11 if check = "OK"
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
12 begin
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
13 db.execute("drop table main;")
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
14 db.extcute("drop table logs;")
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
15 text = "<p>若帥ゃ障</p>"
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
16 rescue
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
17 text = "<p>若帥障</p>"
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
18 end
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
19 else
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
20 text = "若帥ゃ障"
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
21 end
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
22
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
23 printf("Content-type: text/html; charset=UTF-8\n\n")
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
24
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
25 printf'<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
26 <html>
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
27 <head>
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
28 <title>Delete table</title>
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
29 <link rel="stylesheet" type="text/css" href="design.css">
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
30 </head>
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
31 </body>
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
32 %s
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
33 <p><a href="etsuran.rb">若翠画Η若吾</a></p>
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
34 <p></p>
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
35 </body></html>
|
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff
changeset
|
36 ',text
|