#!/usr/bin/ruby1.8 #coding: utf-8 require "cgi" require 'rubygems' require 'dbi' CGI_NAME = "rrpc.cgi" # ----------------------------------------------- # --- login # ----------------------------------------------- DBNAME = 'DBI:Mysql:koruri:magpie.koruri-word.net' DBLOGIN = 'rerofumi' DBPASS = 'mzEeZdEUhZcF' VERB = false # ----------------------------------------------- # --- html # ----------------------------------------------- class GenHtml def initialize(db, id) @id = id @db = db end def header parts = "" parts << "" parts << "\n" parts << "\n" parts << "\n" # parts << "\n" if FileTest.exist?("html_header.html") then open("html_header.html") do |fp| fp.each do |line| parts << line end end end parts << "\n" parts << "\n" parts end def footer parts = "" parts << "\n" parts end def preview "" end def param wavefile = @id.to_s + ".wav" tweet = '' sql = 'SELECT talk FROM ruripeco_talk WHERE time=?' sth = @db.execute(sql, @id.to_i) sth.fetch do |row| tweet << row[0] break end sth.finish # parts = "" parts << "
\n" parts << "
\n" parts << " \"faceicon\"\n" parts << "
\n" parts << "
\n" parts << " るりぺこ。/bot\n" parts << "
\n" parts << "
\n" parts << "\n" parts << "
\n" parts << "
\n" parts << tweet parts << "
\n" parts << "
\n" parts << "

\n" parts << sprintf("wavfile: %s\n", wavefile, wavefile) parts << "

\n" parts end def generate page = "Content-type: text/html\n\n" page << header page << param page << preview page << footer page end end # ----------------------------------------------- # --- cgi work # ----------------------------------------------- cgi = CGI.new params = cgi.params display_id = params["q"][0].to_i # --- open DB db = DBI.connect(DBNAME, DBLOGIN, DBPASS) db.do('SET NAMES utf8') # --- page generate htmlmaker = GenHtml::new(db, display_id) print htmlmaker.generate()