private void OnRegister(UserToken token, SocketModel model) { // 解析消息 ReqRegister req = SerializeUtil.Deserialize <ReqRegister>(model.message); // 从数据库里查询有没有这个账号 string sql = string.Format("select * from account where account = '{0}'", req.account); List <AccountData> accData = MysqlManager.instance.ExecQuery <AccountData>(sql); RespRegister resp = new RespRegister(); if (accData.Count > 0) { resp.msgtips = (uint)MsgTips.AccountRepeat; } else { resp.msgtips = (uint)MsgTips.RegisterSuccess; // 往数据库里插入一个账号 //sql = string.Format("insert into account(account,password) values('{0}','{1}')", req.account, req.password); //MysqlManager.instance.ExecNonQuery(sql); } // 给客户端发送一个应答 NetworkManager.Send(token, (int)MsgID.ACC_REG_SRES, resp); }
private void OnReqRegister(UserToken token, SocketModel model) { ReqRegister req = SerializeUtil.Deserialize <ReqRegister>(model.message); string sql = string.Format("SELECT * FROM account WHERE account = '{0}' ", req.account); List <Account> accounts = MysqlManager.instance.ExecQuery <Account>(sql); if (accounts.Count > 0) { TipsError tip = new TipsError(); tip.code = (int)ECode.ERegisterError; NetworkManager.Send <TipsError>(token, (int)MsgID.TipError, tip); } else { RspRegister rsp = new RspRegister(); rsp.account = req.account; rsp.pwd = req.pwd; rsp.nickname = req.nickname; NetworkManager.Send(token, (int)MsgID.RspRegister, rsp); //插入账号数据 sql = string.Format("INSERT INTO account (account,pwd,nickname,diamond) VALUES ('{0}','{1}','{2}',{3})", req.account, req.pwd, req.nickname, 10000); MysqlManager.instance.ExecNonQuery(sql); //插入装备数据 sql = string.Format("INSERT INTO equip (account,tank,bullet) VALUES ('{0}',{1},{2})", req.account, 1001, 1006); MysqlManager.instance.ExecNonQuery(sql); } }
//Client public async Task <RespRegister> RegisterUser(ReqRegister reqRegister) { string name = reqRegister.UserName; if (name.Length > _config.MaxNameLenght) { name = name.Substring(0, _config.MaxNameLenght); } var user = new User(this, name); await SaveUser(user); _newUsers++; return(new RespRegister() { UserId = user.UserId, UserKey = user.UserKey }); }
private void OnBtnRegisterClick() { if (string.IsNullOrEmpty(_account.text) || string.IsNullOrEmpty(_pwd.text)) { MessageBox.Show("账号或者密码不能为空"); return; } if (_account.text.Contains("'\'") || _account.text.Contains("'")) { MessageBox.Show("账号或者密码包含非法字符"); return; } ReqRegister req = new ReqRegister(); req.account = _account.text; //req.password = _pwd.text; Net.instance.Send((int)MsgID.ACC_REG_CREQ, req); }
void OnRegisterBtnClick() { if (inputAccount.text.Length > 12 || inputAccount.text.Length < 3) { return; } if (inputPwd.text.Length > 12 || inputPwd.text.Length < 3) { return; } if (inputNick.text.Length > 7 || inputNick.text.Length < 3) { return; } ReqRegister req = new ReqRegister(); req.account = inputAccount.text; req.pwd = inputPwd.text; req.nickname = inputNick.text; NetClient.instance.Send <ReqRegister>((int)MsgID.ReqRegister, req); }