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: admin_loginuserDb.php 5229 2012-09-19 12:18:58Z fishbone $
14 * @link http://www.magic3.org
16 require_once($gEnvManager->getDbPath() . '/baseDb.php');
18 class admin_loginuserDb extends BaseDb
23 * @param int $userId ユーザID
24 * @param array $row 取得データ
25 * @return true=正常、false=異常
27 function getLoginUserInfo($userId, &$row)
29 $queryStr = 'SELECT * FROM _login_user LEFT JOIN _login_user_info ON lu_id = li_id AND li_deleted = false ';
30 $queryStr .= 'LEFT JOIN _login_log ON lu_id = ll_user_id ';
31 $queryStr .= 'WHERE lu_deleted = false ';// 削除されていない
32 $queryStr .= 'AND lu_id = ?';
33 $ret = $this->selectRecord($queryStr, array($userId), $row);