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-2009 Magic3 Project.
12 * @license http://www.gnu.org/copyleft/gpl.html GPL License
13 * @version SVN: $Id: reg_userDb.php 2023 2009-06-30 11:57:01Z fishbone $
14 * @link http://www.magic3.org
16 require_once($gEnvManager->getDbPath() . '/baseDb.php');
18 class reg_userDb extends BaseDb
23 * @param string $name 名前
24 * @param string $account アカウント
25 * @param string $password パスワード
26 * @param string $widgetId ウィジェットID
27 * @param int $newId 新規に作成したログインユーザID
28 * @return true=成功、false=失敗
30 function addUser($name, $account, $password, $widgetId, &$newId)
32 $now = date("Y/m/d H:i:s"); // 現在日時
33 $userId = $this->gEnv->getCurrentUserId(); // 現在のユーザ
36 $this->startTransaction();
40 $queryStr = 'select max(lu_id) as ms from _login_user ';
41 $ret = $this->selectRecord($queryStr, array(), $row);
42 if ($ret) $newId = $row['ms'] + 1;
45 $userType = UserInfo::USER_TYPE_NOT_AUTHENTICATED; // 未承認ユーザ
48 $queryStr = 'INSERT INTO _login_user (';
49 $queryStr .= 'lu_id, ';
50 $queryStr .= 'lu_history_index, ';
51 $queryStr .= 'lu_name, ';
52 $queryStr .= 'lu_account, ';
53 $queryStr .= 'lu_password, ';
54 $queryStr .= 'lu_user_type, ';
55 $queryStr .= 'lu_assign, ';
56 $queryStr .= 'lu_enable_login, ';
57 $queryStr .= 'lu_widget_id, ';
58 $queryStr .= 'lu_create_user_id, ';
59 $queryStr .= 'lu_create_dt ';
60 $queryStr .= ') VALUES (';
65 $queryStr .= 'md5(?), ';
72 $ret = $this->execStatement($queryStr, array($newId, 0, $name, $account, $password, $userType, '', 1, $widgetId, $userId, $now));
75 $ret = $this->endTransaction();