reg.aspx.cs

ASP.NET构建的笑傲江湖社区(C#,全源码提供)

				dr.Close();
				DateTime recordtime = DateTime.Now;
				string userip = this.Request.ServerVariables["REMOTE_ADDR"];
				MyComm.CommandText = @"insert into [注册用户]([用户名], [oicq], [保留], [宠物], [宠物等级], [宠物防御], [宠物攻击], [宠物开始], [宠物内力], [宠物寿命], [宠物体力], [宠物武功], [宠物生命], [存款], [登陆次数], [等级], [点券], [电子邮箱], [防御], [攻击], [会员], [会员到期], [会员费], [积分], [今日杀人], [精确], [魅力], [门派], [密码], [内力], [年龄], [配偶], [身份], [生病], [师父], [体力], [体重], [头像], [生命], [武功], [性别], [银两], [月积分], [战斗等级], [照片], [职业], [智力], [注册IP], [注册时间], [状态], [总共杀人], [最后IP], [最后登陆], [最后领钱], [最后杀人]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("用户名", System.Data.OleDb.OleDbType.VarWChar, 10, "用户名"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("oicq", System.Data.OleDb.OleDbType.VarWChar, 10, "oicq"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("保留", System.Data.OleDb.OleDbType.Boolean, 2, "保留"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("宠物", System.Data.OleDb.OleDbType.VarWChar, 10, "宠物"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("宠物等级", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "宠物等级", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("宠物防御", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "宠物防御", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("宠物攻击", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "宠物攻击", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("宠物开始", System.Data.OleDb.OleDbType.VarWChar, 20, "宠物开始"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("宠物内力", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "宠物内力", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("宠物寿命", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "宠物寿命", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("宠物体力", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "宠物体力", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("宠物武功", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "宠物武功", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("宠物生命", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "宠物生命", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("存款", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "存款", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("登陆次数", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "登陆次数", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("等级", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "等级", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("点券", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "点数", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("电子邮箱", System.Data.OleDb.OleDbType.VarWChar, 50, "电子邮箱"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("防御", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "防御", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("攻击", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "攻击", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("会员", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "会员", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("会员到期", System.Data.OleDb.OleDbType.VarWChar, 20, "会员到期"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("会员费", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "会员费", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("积分", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "积分", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("今日杀人", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "今日杀人", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("精确", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "精确", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("魅力", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "魅力", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("门派", System.Data.OleDb.OleDbType.VarWChar, 10, "门派"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("密码", System.Data.OleDb.OleDbType.VarWChar, 50, "密码"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("内力", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "内力", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("年龄", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "年龄", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("配偶", System.Data.OleDb.OleDbType.VarWChar, 10, "配偶"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("身份", System.Data.OleDb.OleDbType.VarWChar, 10, "身份"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("生病", System.Data.OleDb.OleDbType.VarWChar, 10, "生病"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("师父", System.Data.OleDb.OleDbType.VarWChar, 10, "师父"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("体力", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "体力", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("体重", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "体重", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("头像", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "头像", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("生命", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "生命", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("武功", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "武功", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("性别", System.Data.OleDb.OleDbType.VarWChar, 4, "性别"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("银两", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "银两", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("月积分", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "月积分", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("战斗等级", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "战斗等级", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("照片", System.Data.OleDb.OleDbType.VarWChar, 255, "照片"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("职业", System.Data.OleDb.OleDbType.VarWChar, 10, "职业"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("智力", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "智力", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("注册IP", System.Data.OleDb.OleDbType.VarWChar, 15, "注册IP"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("注册时间", System.Data.OleDb.OleDbType.VarWChar, 20, "注册时间"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("状态", System.Data.OleDb.OleDbType.VarWChar, 10, "状态"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("总共杀人", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "总共杀人", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("最后IP", System.Data.OleDb.OleDbType.VarWChar, 15, "最后IP"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("最后登陆", System.Data.OleDb.OleDbType.VarWChar, 20, "最后登陆"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("最后领钱", System.Data.OleDb.OleDbType.VarWChar, 20, "最后领钱"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("最后杀人", System.Data.OleDb.OleDbType.VarWChar, 20, "最后杀人"));
				MyComm.Parameters["用户名"].Value = username;
				MyComm.Parameters["oicq"].Value = oicq;
				MyComm.Parameters["保留"].Value = true;
				MyComm.Parameters["宠物"].Value = "(无)";
				MyComm.Parameters["宠物等级"].Value = 0;
				MyComm.Parameters["宠物防御"].Value = 0;
				MyComm.Parameters["宠物攻击"].Value = 0;
				MyComm.Parameters["宠物开始"].Value = recordtime;
				MyComm.Parameters["宠物内力"].Value = 0;
				MyComm.Parameters["宠物寿命"].Value = 0;
				MyComm.Parameters["宠物体力"].Value = 0;
				MyComm.Parameters["宠物武功"].Value = 0;
				MyComm.Parameters["宠物生命"].Value = 0;
				MyComm.Parameters["存款"].Value = 0;
				MyComm.Parameters["登陆次数"].Value = 0;
				MyComm.Parameters["等级"].Value = 1;
				MyComm.Parameters["点券"].Value = 0;
				MyComm.Parameters["电子邮箱"].Value = email;
				MyComm.Parameters["防御"].Value = 0;
				MyComm.Parameters["攻击"].Value = 0;
				MyComm.Parameters["会员"].Value = 0;
				MyComm.Parameters["会员到期"].Value = recordtime;
				MyComm.Parameters["会员费"].Value = 0;
				MyComm.Parameters["积分"].Value = 0;
				MyComm.Parameters["今日杀人"].Value = 0;
				MyComm.Parameters["精确"].Value = 0;
				MyComm.Parameters["魅力"].Value = 0;
				MyComm.Parameters["门派"].Value = "(无)";
				MyComm.Parameters["密码"].Value = FormsAuthentication.HashPasswordForStoringInConfigFile(password + userip, "SHA1");
				MyComm.Parameters["内力"].Value = 0;
				MyComm.Parameters["年龄"].Value = 1;
				MyComm.Parameters["配偶"].Value = "(无)";
				MyComm.Parameters["身份"].Value = "(无)";
				MyComm.Parameters["生病"].Value = "(无)";
				MyComm.Parameters["师父"].Value = "(无)";
				MyComm.Parameters["体力"].Value = 0;
				MyComm.Parameters["体重"].Value = 10;
				MyComm.Parameters["头像"].Value = ico;
				MyComm.Parameters["生命"].Value = 0;
				MyComm.Parameters["武功"].Value = 0;
				MyComm.Parameters["性别"].Value = sex;
				MyComm.Parameters["银两"].Value = 1000;
				MyComm.Parameters["月积分"].Value = 0;
				MyComm.Parameters["战斗等级"].Value = 0;
				MyComm.Parameters["照片"].Value = "";
				MyComm.Parameters["职业"].Value = "(无)";
				MyComm.Parameters["智力"].Value = 0;
				MyComm.Parameters["注册IP"].Value = userip;
				MyComm.Parameters["注册时间"].Value = recordtime;
				MyComm.Parameters["状态"].Value = "正常";
				MyComm.Parameters["总共杀人"].Value = 0;
				MyComm.Parameters["最后IP"].Value = "";
				MyComm.Parameters["最后登陆"].Value = recordtime;
				MyComm.Parameters["最后领钱"].Value = recordtime.AddDays(-1);
				MyComm.Parameters["最后杀人"].Value = recordtime.AddDays(-1);
				MyComm.ExecuteNonQuery();
				MyConn.Close();
				MyConn.Dispose();
				this.Response.Write ("<script language=javascript type=text/javascript>\rvar username = \"" + username + "\";\rvar password = \"" + password + "\";\r");
				if (var.public_mailUse == true)
				{
					ESmtpMail EM = new ESmtpMail();
					EM.MailDomain = var.public_mailServer;
					EM.From = var.public_mailFrom;
					EM.FromName = var.public_mailFromName;
					EM.ReplyTo = var.public_mailReplyTo;
					EM.AddRecipient(email);
					EM.Priority = "high";
					EM.Subject = "『" + var.public_name + "』感谢您注册";
					EM.Body = username + "：\r\t您好，您已经成功地在 " + var.public_name + " 注册，\r请牢记你的密码『" + password + "』！\r\r网址：http://5diy.com/a/default.aspx\r\r########################################\r要验证此江湖程序是否正版，请查询\r########################################";
					EM.RecipientName = username;
					if (EM.Send())
					{
						this.Response.Write ("var mailinfo = \"已经发送了一封邮件到您的信箱，请注意查收！\";");
					}
					else
					{
						this.Response.Write ("var mailinfo = \"但邮件没有发送成功，请自己记住密码“" + password + "”！\";");
					}
				}
				else
				{
					this.Response.Write ("var mailinfo = \"\";");
				}
				this.Response.Write ("\r</script>\r");
				this.Response.WriteFile ("html/regok.htm");
				this.Response.End();
			}
		}
	}
}