/** * 确认注册【设定密码】 * @method registerAction * @return [type] [description] * @author NewFuture */ public function registerAction() { $msg = '信息注册失败!'; if ($regInfo = Session::get('reg')) { Session::del('reg'); if (Input::post('password', $password, 'trim') === false) { /*密码未md5*/ $this->error('密码错误', '/'); } elseif (!$password) { /*未设置密码*/ $password = $regInfo['password']; } $regInfo['password'] = Encrypt::encryptPwd($password, $regInfo['number']); if ($id = UserModel::insert($regInfo)) { /*注册成功*/ $regInfo['id'] = $id; $token = Auth::token($regInfo); Cookie::set('token', [$id => $token]); unset($regInfo['password']); Session::set('user', $regInfo); $msg = '信息注册成功!'; } } $this->jump('/', $msg); }
/** * 注册 * @method POST_indexAction * @param string $name [description] * @return [type] [description] * @author NewFuture */ public function POST_indexAction() { if (!($regInfo = Session::get('reg'))) { $this->response(0, '注册信息失效'); } else { /*检查密码*/ if (Input::post('password', $password, 'isMD5')) { $msg = '成功设置了新的密码作为云印密码!'; } else { $msg = '使用刚才的验证密码作为运用登陆密码!'; $password = $regInfo['password']; } /*开始注册*/ $regInfo['password'] = Encrypt::encryptPwd($password, $regInfo['number']); if ($id = UserModel::insert($regInfo)) { /*注册成功*/ $msg .= '(如果下次忘记密码后可以通过 手机,邮箱或者再次认证找回密码)'; $regInfo['id'] = $id; $token = Auth::token($regInfo); Cookie::set('token', $token); unset($regInfo['password']); Session::del('reg'); Session::set('user', $regInfo); $this->response(1, ['user' => $regInfo, 'token' => $token, 'msg' => $msg]); } else { $this->response(0, '注册失败'); } } }
/** * 添加用户 * @param $name * @param $email * @param $pwd */ public function addUser($name, $email, $pwd) { //TODO:datacheck $where = ['OR' => ['name' => $name, 'email' => $email], 'LIMIT' => [1]]; $result = $this->userDao->select(['name', 'email'], $where); foreach ($result as $item) { if ($item['name'] == $name) { throw new \InvalidArgumentException('该用户名已被注册'); } if ($item['email'] == $email) { throw new \InvalidArgumentException('该邮箱已被注册'); } } $result = $this->userDao->insert(['name' => $name, 'email' => $email, 'pwd' => md5($pwd), 'ctime' => time()]); if ($result === false) { throw new \Exception('无法创建用户'); } return true; }
public function createAccountAction() { // Load model can thiet Zend_Loader::loadClass("UserModel"); Zend_Loader::loadClass("RandomStringModel"); //Lay va xu ly tham so $params = $this->_arrParam; if ($this->_request->isPost()) { if (isset($params['email']) && !empty($params['platform']) && !empty($params['user_name']) && !empty($params['password'])) { $user_model = new UserModel(); if (strlen($params['user_name']) >= 1 && strlen($params['user_name']) <= 12) { if (strlen($params['password']) >= 6 && strlen($params['password']) <= 50) { $result = $user_model->checkAccountExist($params['user_name'], $params['email']); if ($result) { // User moi $data = array("user_name" => $params['user_name'], "password" => md5($params['password']), "email" => $params['email'], "user_gome" => 1000, "temp_gome" => 0, "is_vip" => 0, 'daily_gift' => date("Y-m-d", time() - 86400), "status" => ACTIVE_STATUS); try { $id = $user_model->insert($data); if (!empty($params['email'])) { // Gui mail ve email nguoi dung de thong bao dang ki thanh cong neu co email gui len $html = "<div>Bạn đã đăng kí thành công tài khoản tại hệ thống game Zegome<br/>"; $html .= "Tên tài khoản: " . $params['user_name']; $html .= "<br/><p align='center'><i>Liên hệ với chúng tôi: <b>Zero team</b><br/>"; $html .= ADDRESS_ZEGOME . "<br/>"; $html .= "Email: " . EMAIL_ZEGOME . " - Tel: " . PHONE_ZEGOME . ".</i></p></div>"; // Gui mail $mail = new Zend_Mail('UTF-8'); $mail->setBodyHtml($html); $mail->addTo($params['email']); $mail->addCc(EMAIL_ADMIN); $mail->setSubject('Đăng kí tài khoản tại hệ thống game Zegome'); $mail->send(); } $data = array("code" => 1, "content" => "Success"); } catch (exception $e) { $data = array("code" => 0, "content" => "Error in server"); } } else { $data = array("code" => 0, "content" => "Duplicate data"); } } else { $data = array("code" => 0, "content" => "password ít nhất 6 kí tự"); } } else { $data = array("code" => 0, "content" => "user_name nhiều nhất là 12 kí tự"); } } else { $data = array("code" => 0, "content" => "Invalid parameters"); } echo json_encode($data); } exit; }
public function expertregisterAction() { $account = $this->getRequest()->getParam('account'); $password = $this->getRequest()->getParam('password'); $name = $this->getRequest()->getParam('name'); $content = $this->getRequest()->getParam('context'); $work = $this->getRequest()->getParam('work'); $code = $this->getRequest()->getParam('surecode'); if ($code == $_SESSION["validcode"]) { $User = new UserModel(); if ($User->ifRegister($account)) { $set = array('account' => $account, 'password' => $password, 'name' => $name, 'email' => $account, 'type' => 2); //在注册用户的时候顺带着要建一个用户个人信息 if ($User->insert($set) > 0) { $where = "email='{$account}'"; $result = $User->fetchAll($where)->toArray(); $info = array('userid' => $result[0][id], 'sex' => 'M', 'name' => $result[0][name], 'sheng' => '北京市', 'shi' => '北京市', 'xian' => '东城区', 'birth' => '1994-5-29', 'interest' => '跑步'); $userinfo = new userinfoModel(); $expert = array('info' => $content, 'userid' => $result[0][id], 'work' => $work, 'concern' => 0, 'image' => '/WebOne/public/image/initial.png'); $expertinfo = new expertinfoModel(); if ($userinfo->insert($info) > 0 && $expertinfo->insert($expert) > 0) { //注册账号成功 $this->render('ok'); } } else { $this->view->info = '1'; $this->_forward('error'); } } else { $this->view->info = '2'; //账号已经创建 $this->_forward('error'); } } else { $this->view->info = '3'; $this->render('error'); //验证码输入错误 } }
/** * 添加 * */ public function addAction() { // 实例化Model $user = new UserModel(); // 处理post数据 if ($this->getRequest()->isPost()) { // 获取所有post数据 $pdata = $this->getAllPost(); // 处理图片等特殊数据 // 验证 $result = $user->validation->validate($pdata, 'add'); $user->parseAttributes($pdata); // 通过验证 if ($result) { // 入库前数据处理 // Model转换成数组 $data = $user->toArray($pdata); $result = $user->insert($data); if ($result) { // 提示信息并跳转到列表 Tools_help::setSession('Message', '添加成功!'); $this->redirect('/backend/user/index'); } else { // 验证失败 $this->_view->assign('ErrorMessage', '添加失败!'); $this->_view->assign("errors", $user->validation->getErrorSummary()); } } else { // 验证失败 $this->_view->assign('ErrorMessage', '添加失败!'); $this->_view->assign("errors", $user->validation->getErrorSummary()); } } // 格式化表单数据 // 模版分配数据 $this->_view->assign("user", $user); $this->_view->assign("pageTitle", '添加'); }
/** * API:用户注册 * * @access public * @param 无 * @return JsonView 响应json */ public function exeUserRegister() { $requestParam = $this->getAllParameters(); Logger::debug('requestParam:' . print_r($requestParam, true)); $requestJsonParam = $this->getDecodedJsonRequest(); Logger::debug('requestJsonParam:' . print_r($requestJsonParam, true)); // 检测账号是否重复 $ret = AuthModel::checkUserAccount($requestJsonParam['account']); if (!$ret) { $view = new JsonView(); $messageArr['error'] = "该账号已存在"; return $this->getViewByJson($view, $messageArr, 0, "auth/user_register"); } // 检测账号是否重复 $ret = AuthModel::checkUserName($requestJsonParam['user_name']); if (!$ret) { $view = new JsonView(); $messageArr['error'] = "该昵称已存在"; return $this->getViewByJson($view, $messageArr, 0, "auth/user_register"); } // 插入新用户 $ret = AuthModel::insert(array('s_account' => $requestJsonParam['account'], 's_password' => $requestJsonParam['password'], 't_create_time' => date("Y-m-d H:i:s")), $pdo); if (is_null($ret)) { throw new ModelException('insert false pa_user_master'); } //---------------------------- 初始用户表 ---------------------------- $user_id = AuthModel::getUserID($requestJsonParam['account'], $requestJsonParam['password'], $pdo); $messageArr['n_id'] = $user_id; self::$userBasicIni['s_name'] = $requestJsonParam['user_name']; self::$userBasicIni['n_sex'] = $requestJsonParam['sex']; self::$userBasicIni['t_create_time'] = date("Y-m-d H:i:s"); // 初始化关卡信息 $checkPointIni = array(1 => array('score' => 0, 'scr_length' => 0, 'reward' => 0, 'kill_num' => 0, 'star_num' => 0)); //self::$userBasicIni['s_checkpoint_info'] = serialize( $checkPointIni ); // 初始化角色信息 self::$userBasicIni['s_role_info '] = CharacterAction::registCharacter($user_id, Constants::INI_CHARACTER_ID); // 初始化武将信息 self::$userBasicIni['s_general_info'] = GeneralAction::registGeneral($user_id, Constants::INI_GENERAL_ID); // 初始化任务信息 self::$userBasicIni['s_task_info'] = serialize(TaskAndAchieveAction::randTask($user_id)); // 初始化成就信息 self::$userBasicIni['s_achievement_info'] = TaskAndAchieveAction::registAchieveCsv($user_id); // 初始化签到信息 $loginInfo = UserAction::getUserLoginInfo(); self::$userBasicIni['s_login_info'] = serialize($loginInfo); $userInfo = array_merge($messageArr, self::$userBasicIni); $ret = UserModel::insert($userInfo, $pdo); FriendModel::insert(array('n_user_id' => $user_id, 'n_friend_id' => Constants::ROBERT, 't_create_time' => date("Y-m-d H:i:s"))); $battle = UserAction::getUserbattle($user_id); UserModel::update(array('n_battle' => $battle), array('n_id' => $user_id)); MailAction::sendSystemMail($user_id); if (is_null($ret)) { throw new ModelException('insert false pa_user_master'); } // // 成就 // $statisticArr['login_day'] = 1; // TaskAndAchieveAction::achieveStatistic( $user_id, $statisticArr ); $userInfo = array_merge($messageArr, self::$userBasicIni); $session_key = CharacterModel::setSessionKey($user_id, $session_key); $messageArr['total_day'] = $loginInfo['total_day']; $messageArr['session_key'] = $session_key; $view = new JsonView(); return $this->getViewByJson($view, $messageArr, 1, "auth/user_register"); }
public function regAction() { $p = $_REQUEST; $pPhone = empty($p['phone']) ? '' : trim($p['phone']); $pPassword = empty($p['ptxt']) ? '' : trim($p['ptxt']); #客户端发送的必须是md5的 密码 $pCode = empty($p['code']) ? '0' : trim($p['code']); $pDid = empty($p['did']) ? '' : trim($p['did']); $tTime = time(); if (empty($pPassword)) { Tool_Fnc::ajaxMsg('密码不能为空'); } if (empty($pCode)) { Tool_Fnc::ajaxMsg('验证码不能为空'); } if (!Tool_Validate::integer($pCode)) { Tool_Fnc::ajaxMsg('验证码格式错误'); } if (strlen($pPassword) != 32) { Tool_Fnc::ajaxMsg('接口发送的必须是密文密码'); } if (empty($pDid) || !Tool_Validate::az09($pDid)) { Tool_Fnc::ajaxMsg('did error'); } $tUMO = new UserModel(); $tRow = $tUMO->field('count(0) c')->where('phone = \'' . $pPhone . '\'')->fRow(); if (!empty($tRow['c'])) { Tool_Fnc::ajaxMsg('该手机已被他人使用,请重新输入'); } $tUMO = new UserModel(); $tKey = Tool_Fnc::newrand(4); $tMd5str = Tool_Fnc::markmd5($pPassword, $tKey); $tCodeMO = new PhonecodeModel(); $tCodeCRow = $tCodeMO->check($pPhone, 1, $pCode); if ($tCodeCRow['status'] == 0) { Tool_Fnc::ajaxMsg($tCodeCRow['msg']); } $pSex = !isset($p['sex']) ? Tool_Fnc::ajaxMsg('请填写性别') : intval($p['sex']); $pDryWeight = !isset($p['dry_weight']) ? Tool_Fnc::ajaxMsg('请填写干体重') : floatval($p['dry_weight']); $pDateOfBirth = empty($p['date_of_birth']) ? Tool_Fnc::ajaxMsg('请填写出生日期') : trim($p['date_of_birth']); if (!empty($pDateOfBirth) && !Tool_Validate::is_date($pDateOfBirth)) { Tool_Fnc::ajaxMsg('日期格式不正确'); } $tData = array('phone' => $pPhone, 'reg_ip' => Tool_Fnc::realip(), "passwd" => $tMd5str, "reg_time" => $tTime, 'private_key' => $tKey, 'reg_did' => $pDid, 'user_type' => 0, 'sex' => $pSex, 'dry_weight' => $pDryWeight, 'date_of_birth' => $pDateOfBirth, 'reg_did' => $pDid); if (!($tID = $tUMO->insert($tData))) { Tool_Fnc::ajaxMsg('注册失败'); } //did入库 $tUDMO = new UserdidModel(); $tUDRow = $tUDMO->field('count(0) c')->where('uid = ' . $tID . ' and did = \'' . $pDid . '\'')->fRow(); if (empty($tUDRow['c'])) { $tData = array('uid' => $tID, 'did' => $pDid, 'created' => $tTime, 'ip' => Tool_Fnc::realip()); $tUDMO->insert($tData); } $tTokenarr = $this->creattoken($tID); //干重记录表数据更新 $tDWMO = new DryweightlogModel(); $tDryWeightLog = array('uid' => $tID, 'weight' => $pDryWeight, 'date' => date('Y-m-d'), 'month' => date('Y-m'), 'year' => date('Y'), 'created' => $tTime); $tDWMO->insert($tDryWeightLog); //匿名转实名 $tUMO->incognito_real($pDid, $tID); $tTokenarr = array_merge($tTokenarr, array('user_type' => 0)); Tool_Fnc::ajaxMsg('注册成功', 1, $tTokenarr); }
public function register(array $me) { $last_id = UserModel::insert(array('login' => $me['email'], 'fbuid' => $me['id'], 'name' => $me['first_name'], 'surname' => $me['last_name'], 'activate' => 1, 'password' => Tools::random(12), 'newsletter' => 0, 'iso' => 'SVK')); return UserModel::get($last_id); }
require_once '../application/UserModel.php'; require_once '../application/User.php'; $userModel = new UserModel(); $user = new User(); // handle action $action = isset($_GET['action']) ? $_GET['action'] : ''; switch ($action) { case 'create': // TODO: data validation // populate input from user $user->setFirstName($_POST['first_name']); $user->setLastName($_POST['last_name']); $user->setUsername($_POST['username']); $user->setPassword($_POST['password']); // save to database if ($userModel->insert($user)) { header('location:../index.php?action=create&status=success'); } else { // TODO: populate last inputs to session // return back to form header('location:../form.php?action=create&status=failed'); } break; case 'edit': // TODO: data validation // populate input from user $user->setId($_POST['id']); $user->setFirstName($_POST['first_name']); $user->setLastName($_POST['last_name']); $user->setUsername($_POST['username']); $user->setPassword($_POST['password']);
public function addEditOnFormSubmitted(NAppForm $form) { $error = false; dibi::begin(); // add action if ($this->getAction() == 'add') { try { $values = $form->getValues(); $roles = $values['roles']; unset($values['password2'], $values['roles']); // $values['password'] = md5($values['password']); // dibi::query('INSERT INTO ['.TABLE_USERS.'] %v;', $values); $user_id = UserModel::insert($values); if (count($roles)) { foreach ($roles as $role) { dibi::query('INSERT INTO [' . TABLE_USERS_ROLES . '] (user_id, role_id) VALUES (%i, %i);', $user_id, $role); } } $this->flashMessage('The user has been added.', 'ok'); dibi::commit(); if (ACL_CACHING) { unset($this->cache['gui_acl']); // invalidate cache } $this->redirect('Users:'); } catch (Exception $e) { $error = true; $form->addError('The user has not been added.'); throw $e; } } else { // edit action $id = $this->getParam('id'); try { $values = $form->getValues(); $roles = $values['roles']; unset($values['roles']); unset($values['password2']); // dibi::query('UPDATE ['.TABLE_USERS.'] SET %a WHERE id=%i;', $values, $id); UserModel::update($id, $values); dibi::query('DELETE FROM [' . TABLE_USERS_ROLES . '] WHERE user_id=%i;', $id); if (count($roles)) { foreach ($roles as $role) { dibi::query('INSERT INTO [' . TABLE_USERS_ROLES . '] (user_id, role_id) VALUES (%i, %i);', $id, $role); } } $this->flashMessage('The user has been edited.', 'ok'); dibi::commit(); if (ACL_CACHING) { unset($this->cache['gui_acl']); // invalidate cache } $this->redirect('Users:'); } catch (Exception $e) { $error = true; $form->addError('The user has not been edited.'); throw $e; } } if ($error) { dibi::rollback(); } }
$cassandra->useKeyspace('CassandraRowsPaginationExample'); } catch (Exception $e) { // create a new keyspace, accepts extra parameters for replication options // normally you don't do it every time $cassandra->createKeyspace('CassandraRowsPaginationExample'); // use the keyspace again properly $cassandra->useKeyspace('CassandraRowsPaginationExample'); // create a standard column family with given column metadata $cassandra->createStandardColumnFamily('CassandraRowsPaginationExample', 'user', array(array('name' => 'name', 'type' => Cassandra::TYPE_UTF8, 'index-type' => Cassandra::INDEX_KEYS, 'index-name' => 'NameIdx'), array('name' => 'email', 'type' => Cassandra::TYPE_UTF8), array('name' => 'age', 'type' => Cassandra::TYPE_INTEGER, 'index-type' => Cassandra::INDEX_KEYS, 'index-name' => 'AgeIdx'))); $columns = array('name' => 'Columns test', 'age' => 99, 'email' => '*****@*****.**'); // create some example data for ($i = 0; $i < 1000; $i++) { UserModel::insert('user-' . sprintf('%04d', $i), array('name' => 'User #' . $i, 'age' => round($i / 10), 'email' => 'user-' . $i . '@cpcl.com')); $columns[] = 'Column #' . $i; } UserModel::insert('columns-test', $columns); } echo '<pre>'; /* $firstUser = UserModel::load('user-0000'); print_r($firstUser->getData()); */ $reverse = false; $start = null; if (isset($_GET['next'])) { $start = $_GET['next']; } else { if (isset($_GET['previous'])) { $reverse = true; if (isset($_SESSION['start-' . $_GET['previous']])) { $start = $_SESSION['start-' . $_GET['previous']];
public function testRowsCanBeRemoved2() { UserModel::insert('dave', array('email' => '*****@*****.**', 'name' => 'Dave', 'age' => 33)); $dave = UserModel::load('dave'); $this->assertEquals($dave->email, '*****@*****.**'); $this->assertEquals($dave->name, 'Dave'); $this->assertEquals($dave->age, 33); $dave->delete(); $dave2 = UserModel::load('dave'); $this->assertNull($dave2); }
function saveRegistration(NFORM $form) { $values = (array) $form->getValues(); $user = UserModel::getFluent(false)->where(' login = %s', $values['login'])->fetch(); try { if ($user and $user['login'] == $values['login']) { throw new InvalidStateException(_('Uživateľ pod týmto prihlasovacím meno už existuje.')); } // if($user AND $user['email'] == $values['email']) // throw new InvalidStateException( _('Emailová adresa sa už nachádza v databáze. ') ); // unset($values['passwordCheck']); unset($values['terms_and_conditions']); $values['activate'] = 1; //registrovany dostane automaticky 2% zlavu $values['discount'] = 2; UserModel::insert($values); $this->flashMessage("Registrácia je dokončená, účet aktivovaný a ste prihlásený na stránke."); $template = clone $this->template; $template->setFile(APP_DIR . '/FrontModule/templates/Profil/registrationConfirmEmail.phtml'); $template->values = $values; $mail = new MyMail(); $mail->addTo($values['login']); $mail->addBcc(NEnvironment::getVariable('error_email')); $mail->setSubject(_('Informácie o účte')); $mail->setTemplate($template); $mail->send(); $this->user->login($values['login'], $values['password']); if ($this->backlink != '') { $this->restoreRequest($this->backlink); } else { $this->redirect('Homepage:default'); } } catch (InvalidStateException $e) { $form->addError($e->getMessage()); // throw $e; } }
<?php header("Content-Type: text/html; charset=utf-8"); require dirname(__FILE__) . '/includes/init.php'; require dirname(__FILE__) . '/includes/ao/OrderAO.php'; $a = cls_sqlexecute::getInstance('mmall_0000', $user_multiple_dbroute_config); $b = cls_sqlexecute::getInstance('mmall_0001', $user_multiple_dbroute_config); $c = cls_sqlexecute::getInstance('mmall_0002', $user_multiple_dbroute_config); print_r($a->getList()); $c = cls_sqlexecute::getInstance('mmall_0003', $user_multiple_dbroute_config); print_r($a->getList()); die; $userModel = new UserModel(); print_r($userModel->insert()); echo "===="; die; $m = new RefundInfoModel(); print_r($m->insert(10, 1)); die; print_r($userModel->getTableNameBytUserName("abc713807")); //print_r($userModel->getRow('abc291901')); //print_r($userModel->getOne('abc291901')); //print_r($userModel->update('abc291901','new_pwd')); //print_r($userModel->queryAll('abc')); //print_r($userModel->queryAllByIn('abc')); //print_r($userModel->transactionTest('user_name')); //print_r($userModel->delete('abc291901')); //die;