7 * LICENSE: This source file is licensed under the terms of the GNU General Public License.
9 * @package Magic3 Framework
10 * @author 平田直毅(Naoki Hirata) <naoki@aplo.co.jp>
11 * @copyright Copyright 2006-2010 Magic3 Project.
12 * @license http://www.gnu.org/copyleft/gpl.html GPL License
13 * @version SVN: $Id: blogLibDb.php 3621 2010-09-24 03:07:53Z fishbone $
14 * @link http://www.magic3.org
16 require_once($gEnvManager->getDbPath() . '/baseDb.php');
18 class blogLibDb extends BaseDb
23 * @param int $id エントリーID
24 * @param string $langId 言語
25 * @param array $row レコード
26 * @return bool 取得 = true, 取得なし= false
28 function getEntryItem($id, $langId, &$row)
30 $queryStr = 'SELECT * FROM blog_entry LEFT JOIN blog_id ON be_blog_id = bl_id AND bl_deleted = false ';
31 $queryStr .= 'WHERE be_deleted = false '; // 削除されていない
32 $queryStr .= 'AND be_id = ? ';
33 $queryStr .= 'AND be_language_id = ? ';
34 $ret = $this->selectRecord($queryStr, array($id, $langId), $row);
40 * @param string $id 識別ID
41 * @param array $row レコード
42 * @return bool 取得 = true, 取得なし= false
44 function getBlogInfoById($id, &$row)
46 $queryStr = 'SELECT * FROM blog_id ';
47 $queryStr .= 'WHERE bl_deleted = false ';
48 $queryStr .= 'AND bl_id = ? ';
49 $ret = $this->selectRecord($queryStr, array($id), $row);