From 175c89da9351e40d76cb53f14af09e03b11ace2e Mon Sep 17 00:00:00 2001
From: hylom <hylom@users.sourceforge.jp>
Date: Wed, 5 Apr 2017 00:25:31 +0900
Subject: [PATCH] Model::Discussions: select() now returns discussion kind

---
 src/newslash_web/lib/Newslash/Model/Discussions.pm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/src/newslash_web/lib/Newslash/Model/Discussions.pm b/src/newslash_web/lib/Newslash/Model/Discussions.pm
index 8685cf3c..514bd855 100644
--- a/src/newslash_web/lib/Newslash/Model/Discussions.pm
+++ b/src/newslash_web/lib/Newslash/Model/Discussions.pm
@@ -65,8 +65,9 @@ sub select {
 
   my $dbh = $self->connect_db;
   my $sql = <<"EOSQL";
-SELECT discussions.*
+SELECT discussions.*, discussion_kinds.name AS kind
   FROM discussions
+  LEFT JOIN discussion_kinds ON discussions.dkid = discussion_kinds.dkid
   WHERE discussions.$query_type = ?
 EOSQL
 
-- 
2.11.0