blob: 5acd8325d2d7474ba78e2db2f817526d405e71a9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
def module_bdg(msg_body, sender_nick, config)
require 'dbi'
require 'htmlentities'
require 'iconv'
@mysql_config = { "host" => "localhost",
"db" => "bdg",
"user" => "bdg_ro",
"passwd" => "vinblanc_ro"
}
def bdg(bdg_number)
begin
db = DBI.connect("DBI:Mysql:" + @mysql_config["db"] + ":" + @mysql_config["host"], @mysql_config["user"], @mysql_config["passwd"])
st = db.execute('select id,titre,blague,auteur,date_post from blague where id=' + bdg_number)
row = st.fetch
answer = "\##{row[0]} - #{row[1]} \n #{row[2]} \n par #{row[3]} le #{row[4]} "
answer = HTMLEntities.new.decode(answer)
answer = Iconv.new('utf-8', 'iso-8859-1').iconv(answer)
return answer
rescue
answer = "BDG introuvable"
return answer
end
end
if msg_body =~ /^!bdg(\s|)\d+$/
answer = bdg(msg_body.gsub(/!bdg(\s|)/, ''))
return answer
elsif msg_body =~ /^!bdg+/
answer = "Veuillez entrer un numéro de BDG."
return answer
end
end
|