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-2012 Magic3 Project.
12 * @license http://www.gnu.org/copyleft/gpl.html GPL License
13 * @version SVN: $Id: photoslide2Db.php 4699 2012-02-19 14:14:58Z fishbone $
14 * @link http://www.magic3.org
16 require_once($gEnvManager->getDbPath() . '/baseDb.php');
18 class photoslide2Db extends BaseDb
23 * @param int $itemCount 取得項目数
24 * @param string $lang 言語
25 * @param string $sortKey ソートキー(index=表示順,date=日付,rate=評価,ref=参照数)
26 * @param int $sortDirection 取得順(0=降順,1=昇順)
27 * @param function $callback コールバック関数
30 function getPhotoItems($itemCount, $lang, $sortKey, $sortDirection, $callback)
32 $queryStr = 'SELECT DISTINCT ht_public_id,ht_name,ht_rate_average,ht_view_count,ht_regist_dt FROM photo ';
33 $queryStr .= 'WHERE ht_deleted = false '; // 未削除
34 $queryStr .= 'AND ht_visible = true '; // 公開中
40 $orderKey = 'ht_sort_order ';
41 if (empty($sortDirection)) $orderKey .= 'DESC ';
42 $orderKey .= ',ht_regist_dt ';
45 $orderKey = 'ht_regist_dt ';
48 $orderKey = 'ht_rate_average ';
51 $orderKey = 'ht_view_count ';
55 if (empty($sortDirection)) $ord = 'DESC ';
56 $queryStr .= 'ORDER BY ' . $orderKey . $ord . 'LIMIT ' . $itemCount; // 画像アップロード日時順
57 $this->selectLoop($queryStr, array(), $callback);
62 * @param string $key キーとなる項目値
63 * @return string $value 値
65 function getConfig($key)
68 $queryStr = 'SELECT hg_value FROM photo_config ';
69 $queryStr .= 'WHERE hg_id = ?';
70 $ret = $this->selectRecord($queryStr, array($key), $row);
71 if ($ret) $retValue = $row['hg_value'];