/**
* 确认注册【设定密码】
* @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;
