# HG changeset patch # User SATO Tomohisa # Date 1405672794 -32400 # Node ID 68a5674471db754f9b58ffb0091ca5ed912a62c6 # Parent da66277301929b9a4a8588ab4deda0386f5c04a9# Parent 18170bc7ffa5b3370d30972dcc20884010b9d5ce merge diff -r da6627730192 -r 68a5674471db .png Binary file .png has changed diff -r da6627730192 -r 68a5674471db minato2014/.htaccess --- a/minato2014/.htaccess Fri Jul 18 17:38:58 2014 +0900 +++ b/minato2014/.htaccess Fri Jul 18 17:39:54 2014 +0900 @@ -1,3 +1,4 @@ AddHandler cgi-script .rb AddType "text/html; charset=UTF-8" .rb +AddType "text/html; charset=UTF-8" .html Options +ExecCGI diff -r da6627730192 -r 68a5674471db minato2014/account.html --- a/minato2014/account.html Fri Jul 18 17:38:58 2014 +0900 +++ b/minato2014/account.html Fri Jul 18 17:39:54 2014 +0900 @@ -1,15 +1,14 @@ - -デザイン用サンプル +ゆるスタ登録ページ -

みなとスタンプラリー登録ページ

ゆるスタ登録ページ

入力してね

diff -r da6627730192 -r 68a5674471db minato2014/accountcheck.rb --- a/minato2014/accountcheck.rb Fri Jul 18 17:38:58 2014 +0900 +++ b/minato2014/accountcheck.rb Fri Jul 18 17:39:54 2014 +0900 @@ -1,34 +1,48 @@ #!/usr/bin/env ruby # -*- coding: utf-8 -*- -#require 'sqlite3' +require 'sqlite3' require 'cgi' c = CGI.new(:tag_maker => "html5", :accept_charest => "UTF-8") -#db = SQLite3::Database.new("sql/stump.sq3") +db = SQLite3::Database.new("sql/stump.sq3") -print("Content-type: text/html; charset=UTF-8 \n\n") +begin + result = db.execute("select * from main;") +rescue + db.execute("create table main(id PRIMARY KEY,name,sex,age,aria,job,stamp_status,stamp_img,exp,rank,magic)"); + db.execute("insert into main values('ID','名前','性別','年代','住所','職業','スタンプ状況','スタンプ画像','レベル','当選順位','本人確認用')"); + result = db.execute("select * from main"); +end name = c["name"] -job = c["job"] -sex = c["sex"] +job = c["job"] +age = c["age"] +sex = c["sex"] +aria = c["aria"] + +id = result.length +printf("%04d",id) -print' - - Registering Account - -' +' printf'

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

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

-',name,job,sex -print' +

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

>> アカウント登録画面に戻る <<

+ ' -print'' diff -r da6627730192 -r 68a5674471db minato2014/design.css --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/minato2014/design.css Fri Jul 18 17:39:54 2014 +0900 @@ -0,0 +1,1 @@ +body{background-color: #E0FFFF;} diff -r da6627730192 -r 68a5674471db minato2014/png/madousiB1.png Binary file minato2014/png/madousiB1.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiB2.png Binary file minato2014/png/madousiB2.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiB3.png Binary file minato2014/png/madousiB3.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiB4.png Binary file minato2014/png/madousiB4.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiB5.png Binary file minato2014/png/madousiB5.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiB6.png Binary file minato2014/png/madousiB6.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiB7.png Binary file minato2014/png/madousiB7.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiG1.png Binary file minato2014/png/madousiG1.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiG2.png Binary file minato2014/png/madousiG2.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiG3.png Binary file minato2014/png/madousiG3.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiG4.png Binary file minato2014/png/madousiG4.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiG5.png Binary file minato2014/png/madousiG5.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiG6.png Binary file minato2014/png/madousiG6.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/madousiG7.png Binary file minato2014/png/madousiG7.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiB1.png Binary file minato2014/png/sensiB1.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiB2.png Binary file minato2014/png/sensiB2.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiB3.png Binary file minato2014/png/sensiB3.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiB4.png Binary file minato2014/png/sensiB4.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiB5.png Binary file minato2014/png/sensiB5.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiB6.png Binary file minato2014/png/sensiB6.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiB7.png Binary file minato2014/png/sensiB7.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiG1.png Binary file minato2014/png/sensiG1.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiG2.png Binary file minato2014/png/sensiG2.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiG3.png Binary file minato2014/png/sensiG3.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiG4.png Binary file minato2014/png/sensiG4.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiG5.png Binary file minato2014/png/sensiG5.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiG6.png Binary file minato2014/png/sensiG6.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/sensiG7.png Binary file minato2014/png/sensiG7.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefB1.png Binary file minato2014/png/thiefB1.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefB2.png Binary file minato2014/png/thiefB2.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefB3.png Binary file minato2014/png/thiefB3.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefB4.png Binary file minato2014/png/thiefB4.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefB5.png Binary file minato2014/png/thiefB5.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefB7.png Binary file minato2014/png/thiefB7.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefG1.png Binary file minato2014/png/thiefG1.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefG2.png Binary file minato2014/png/thiefG2.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefG3.png Binary file minato2014/png/thiefG3.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefG4.png Binary file minato2014/png/thiefG4.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefG5.png Binary file minato2014/png/thiefG5.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefG6.png Binary file minato2014/png/thiefG6.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/thiefG7.png Binary file minato2014/png/thiefG7.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiB1.png Binary file minato2014/png/yumiB1.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiB2.png Binary file minato2014/png/yumiB2.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiB3.png Binary file minato2014/png/yumiB3.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiB4.png Binary file minato2014/png/yumiB4.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiB5.png Binary file minato2014/png/yumiB5.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiB6.png Binary file minato2014/png/yumiB6.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiB7.png Binary file minato2014/png/yumiB7.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiG1.png Binary file minato2014/png/yumiG1.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiG2.png Binary file minato2014/png/yumiG2.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiG3.png Binary file minato2014/png/yumiG3.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiG4.png Binary file minato2014/png/yumiG4.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiG5.png Binary file minato2014/png/yumiG5.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiG6.png Binary file minato2014/png/yumiG6.png has changed diff -r da6627730192 -r 68a5674471db minato2014/png/yumiG7.png Binary file minato2014/png/yumiG7.png has changed diff -r da6627730192 -r 68a5674471db minato2014/rain.png Binary file minato2014/rain.png has changed