From 2df4c55788261bf9efd40bc31047885683f948f6 Mon Sep 17 00:00:00 2001 From: piernov Date: Fri, 19 Oct 2012 19:16:23 +0200 Subject: Initialisation du dépôt. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- index.cgi | 92 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 92 insertions(+) create mode 100755 index.cgi (limited to 'index.cgi') diff --git a/index.cgi b/index.cgi new file mode 100755 index 0000000..5cd81ac --- /dev/null +++ b/index.cgi @@ -0,0 +1,92 @@ +#!/usr/bin/ruby + +require 'rubygems' +require 'dbi' +require 'cgi' + +require 'conf' +db=$db + +page="Blagues" +subpage="Aléatoire" + +cgi = CGI.new +puts cgi.header + +puts < + + + + + BDG — Blagues de Geek + + + + + + + + + +HTML_BDG + +require 'menu' +puts menu_bdg(page,subpage) + +puts < + +

Quelques blagues au hasard

+HTML_BDG + +total = 0 +db.execute("SELECT COUNT(*) FROM blague").each { |row| total = row[0] } + +if total < 5 + count = total +else + count = 5 +end + +displayed = Hash.new() + +i = 0 +until i == count +db.execute("SELECT id,titre,auteur,blague,DATE_FORMAT(date_post, '%e/%c/%Y'),voteplus,votetotal FROM blague WHERE ID=#{rand(total)+1}").each { |row| + if displayed["#{row[0]}"] == true + next + else + displayed["#{row[0]}"] = true + end + + unless row[1] == "" + if i.modulo(2) == 1 + parity = " impair" + else + parity = "" + end + i += 1 + puts < +

\##{row[0]} - #{CGI::escapeHTML(row[1])} ( #{row[5]} / #{row[6]} )

#{CGI::escapeHTML(row[3]).gsub(/\r\n|\r|\n/,"
")}

posté par #{CGI::escapeHTML(row[2])} le #{row[4]}

+ + +HTML_BDG + + end + } +end + +require 'infos' +puts infos_bdg() + +puts < + + + +HTML_BDG -- cgit v1.2.3-54-g00ecf