protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { check ck = new check(); data_conn cn = new data_conn(); string sql = ""; sql = sql + "select * "; sql = sql + "from TB_User "; sql = sql + "where UserName = '******'"; DataSet ds = new DataSet(); ds = cn.mdb_ds(sql, "T_User"); if (ds.Tables["T_User"].Rows.Count > 0) { MessageBox("opfail", "用户名已有人使用"); return; } else if (UserPassword.Value.Length < 6 || UserPassword.Value.Length > 15) { MessageBox("opfail", "密码长度必须在6~15个字符之间"); return; } else if (Company.Value == "" || RealName.Value == "" || Phone.Value == "" || UserEmail.Value == "") { MessageBox("opfail", "必填项不能为空"); return; } else if (!isEmail(UserEmail.Value)) { MessageBox("opfail", "邮箱格式不正确"); return; } else if (UserPassword.Value != UserPassword2.Value) { MessageBox("opfail", "2次密码不一致"); return; } else if (!Checkbox1.Checked) { MessageBox("opfail", "请仔细阅读并同意服务条款"); return; } string recommendUserID; if (this.Request.Cookies["recommendUserID"] == null) { recommendUserID = "0"; } else { if (this.Request.Cookies["recommendUserID"].Value == "") { recommendUserID = "0"; } else { recommendUserID = Request.Cookies["recommendUserID"].Value; } } if (this.Request.Cookies["UID"] == null) { } else { if (Request.Cookies["UID"].Value == "") { } else { data_conn Uidcn = new data_conn(); DataSet Uidds = Uidcn.mdb_ds("select UserID from TB_User where UCenterHomeUid=" + Request.Cookies["UID"].Value, "uid"); if (Uidds.Tables["uid"].Rows.Count == 1) { recommendUserID = Uidds.Tables["uid"].Rows[0][0].ToString(); mysqldata_conn mycn = new mysqldata_conn(); mycn.mdb_exe("update uchome_space set credit=credit+10 where uid=" + Request.Cookies["UID"].Value); } } } sql = ""; sql += "INSERT INTO "; sql += "TB_User "; sql += "("; sql += "UserName, "; sql += "UserPassword, "; sql += "UserEmail, "; sql += "UserPoint, "; sql += "RealName, "; sql += "IfPass, "; sql += "ifvip, "; sql += "ifmanage, "; sql += "CompanyName, "; sql += "Phone, "; sql += "Regtime)"; sql += "VALUES "; sql += "("; sql += "'" + ck.CheckInput(UserName.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(UserPassword.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(UserEmail.Value.ToString()) + "', "; sql += "0, "; sql += "'" + ck.CheckInput(RealName.Value.ToString()) + "', "; sql += "1, "; sql += "1, "; sql += "0, "; sql += "'" + ck.CheckInput(Company.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Phone.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(DateTime.Now.ToString()) + "' "; sql += ")"; cn.mdb_exe(sql); sql = "SELECT * FROM TB_User WHERE UserName = '******'"; ds = cn.mdb_ds(sql, "user"); string sql_account = "insert into TB_ORDER_ACCOUNT (userid) VALUES (" + ds.Tables["user"].Rows[0]["UserID"].ToString() + ")"; cn.mdb_exe(sql_account); //增加账户信息 AllinOrder AllinOrder1 = new AllinOrder(); AllinOrder1.SetOrderTry(ds.Tables["user"].Rows[0]["UserID"].ToString()); if (ds.Tables["user"].Rows.Count != 0) { try { points p = new points(); p.AddNewPoints(ds.Tables["user"].Rows[0]["UserID"].ToString()); } catch (Exception ex) { } string userid = ds.Tables["user"].Rows[0]["UserID"].ToString(); string usernm = ds.Tables["user"].Rows[0]["UserName"].ToString(); string ifvip = ds.Tables["user"].Rows[0]["ifvip"].ToString(); string ifmanage = ds.Tables["user"].Rows[0]["ifmanage"].ToString(); string realname = ds.Tables["user"].Rows[0]["realname"].ToString(); string useremail = ds.Tables["user"].Rows[0]["useremail"].ToString(); Response.Cookies["user_id"].Value = userid; Response.Cookies["user_name"].Value = Server.UrlEncode(usernm); Response.Cookies["ifvip"].Value = ifvip; Response.Cookies["ifmanage"].Value = ifmanage; Response.Cookies["user_id"].Expires = DateTime.Now.AddDays(365); Response.Cookies["user_name"].Expires = DateTime.Now.AddDays(365); Response.Cookies["ifvip"].Expires = DateTime.Now.AddDays(365); Response.Cookies["ifmanage"].Expires = DateTime.Now.AddDays(365); Response.Cookies["realname"].Value = Server.UrlEncode(realname); Response.Cookies["useremail"].Value = Server.UrlEncode(useremail); Response.Cookies["realname"].Expires = DateTime.Now.AddDays(365); Response.Cookies["useremail"].Expires = DateTime.Now.AddDays(365); if (recommendUserID != "0") { cn.mdb_exe("insert into T_FRIEND (UID,FID) values (" + userid + "," + recommendUserID + ")"); cn.mdb_exe("insert into T_FRIEND (UID,FID) values (" + recommendUserID + "," + userid + ")"); Mark mark = new Mark(); mark.MarkOperate(Convert.ToInt32(recommendUserID), 10, "推荐会员", Convert.ToInt32(userid)); } mysqldata_conn mysqlcn = new mysqldata_conn(); DataSet dscount = mysqlcn.mdb_ds("select * from uc_members where username='******'", "ucenter"); if (dscount.Tables["ucenter"].Rows.Count == 0) { Random r = new Random(); string salt = r.Next().ToString().Substring(0, 6); string username = usernm; string password = MD5(MD5(ds.Tables["user"].Rows[0]["UserPassword"].ToString()) + salt); string email = ds.Tables["user"].Rows[0]["UserEmail"].ToString(); string myid = ""; string myidkey = ""; string regip = Page.Request.UserHostAddress; string regdate = UnixTimestamp(); string lastloginip = "0"; string lastlogintime = "0"; string id = this.insert(username, "8fc24ae194289b94e36272a5f9882611", email, myid, myidkey, regip, regdate, lastloginip, lastlogintime, "594882"); if (id != "") { mysqlcn.mdb_exe("insert into uchome_member (uid,username,password) values (" + id + ",'','" + MD5(id + "|" + UnixTimestamp()) + "')"); mysqlcn.mdb_exe("insert into uc_memberfields (uid,blacklist) values (" + id + ",'')"); string myemail; string qq; string msn; if (ds.Tables["user"].Rows[0]["UserEmail"].ToString() != "") { myemail = ds.Tables["user"].Rows[0]["UserEmail"].ToString(); } else { myemail = ""; } qq = ""; msn = ""; mysqlcn.mdb_exe("insert into uchome_spacefield (uid,email,qq,msn,blood,birthprovince,birthcity,resideprovince,residecity,note,spacenote,authstr,theme,css,privacy,friend,feedfriend,sendmail) values (" + id + ",'" + myemail + "','" + qq + "','" + msn + "','','','','','','','','','','','','','','')"); //插入实名 string namestatus = "0"; //实名 mysqlcn.mdb_exe("insert into uchome_space (uid,groupid,username,name,namestatus,domain,dateline,ip) values (" + id + ",5,'" + username + "',''," + namestatus + ",''," + UnixTimestamp() + ",'" + Page.Request.UserHostAddress + "')"); cn.mdb_exe("update TB_User set UCenterHomeUid=" + id + " where UserId=" + userid); //在ucenter中添加推荐好友 if (Request.Cookies["UID"] == null) { } else { if (Request.Cookies["UID"].Value == "") { } else { string gid = "0"; if (this.Request.Cookies["g"] == null) { } else { if (Request.Cookies["g"].Value == "") { } else { gid = Request.Cookies["g"].Value; try { int g = Convert.ToInt32(gid); if (g > 0 && g < 8) { gid = g.ToString(); } else { gid = "0"; } } catch (Exception ex) { gid = "0"; } } } DataSet myUidds = mysqlcn.mdb_ds("select username from uc_members where uid=" + Request.Cookies["UID"].Value, "uid"); mysqlcn.mdb_exe("insert into uchome_friend (uid,fuid,fusername,status,gid,note,dateline) values (" + id + "," + Request.Cookies["UID"].Value + ",'" + myUidds.Tables["uid"].Rows[0][0].ToString() + "',1,0,''," + UnixTimestamp() + ")"); mysqlcn.mdb_exe("insert into uchome_friend (uid,fuid,fusername,status,gid,note,dateline) values (" + Request.Cookies["UID"].Value + "," + id + ",'" + username + "',1," + gid + ",''," + UnixTimestamp() + ")"); mysqlcn.mdb_exe("insert into uc_friends (uid,friendid,direction,comment) values (" + id + "," + Request.Cookies["UID"].Value + ",3,'')"); mysqlcn.mdb_exe("insert into uc_friends (uid,friendid,direction,comment) values (" + Request.Cookies["UID"].Value + "," + id + ",3,'')"); } } } } Response.Cookies["useremail"].Value = UserEmail.Value.ToString(); try { SendEmail(UserName.Value.ToString(), UserPassword.Value.ToString(), UserEmail.Value.ToString(), "GB"); } catch (Exception ex) { Response.Redirect("trysuccess.aspx"); } } }
protected void submitbtn_ServerClick(object sender, EventArgs e) { check check1 = new check(); GetRequest GetRequest1 = new GetRequest(); string u = ""; u = check1.CheckNumber(GetRequest1.GetRequestCookies("user_id", "0")); data_conn cn = new data_conn(); DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); DataSet ds2 = new DataSet(); string sql = ""; string surl = url2.Value.Trim(); string vurl = ""; if (surl.IndexOf("http://") == -1) { surl = "http://" + surl; } sql = "SELECT * FROM TB_REPASTE_VIDEO WHERE '" + check1.CheckRecord(surl) + "' LIKE '%' + vtag + '%'"; ds = cn.mdb_ds(sql, "video"); if (ds.Tables["video"].Rows.Count > 0) { string regexp1 = ds.Tables["video"].Rows[0]["surl"].ToString(); string regexp2 = ds.Tables["video"].Rows[0]["durl"].ToString(); Match TitleMatch = Regex.Match(surl, regexp1, RegexOptions.IgnoreCase | RegexOptions.Multiline); string urlkey = TitleMatch.Groups[1].Value.ToString(); if (urlkey != "") { vurl = Regex.Replace(regexp2, "urlkey", urlkey); } } sql = "INSERT INTO TB_REPASTE_TOPIC (topic,txt,userid,url) VALUES ('" + check1.CheckInput(title.Value) + "','" + vurl + "<br/>" + check1.CheckRecord(HiddenField1.Value) + "'," + u + ",'" + check1.CheckInput(url2.Value) + "'); SELECT @@identity "; ds1 = cn.mdb_ds(sql, "topic"); string redirect_tid = ds1.Tables["topic"].Rows[0][0].ToString();//获得转贴主记录的id号 sql = "INSERT INTO TB_REPASTE_REPASTE (tid,userid) VALUES ('" + ds1.Tables["topic"].Rows[0][0].ToString() + "'," + u + "); SELECT @@identity "; ds2 = cn.mdb_ds(sql, "paste"); string redirect_rid = ds2.Tables["paste"].Rows[0][0].ToString();//获得转贴的id号 sql = "SELECT TOP 4 * FROM V_REPASTE_INDEX WHERE userid2 = " + u + " ORDER BY rid DESC"; ds2 = cn.mdb_ds(sql, "index"); string body_template = ""; for (int i = 0; i < ds2.Tables["index"].Rows.Count; i++) { body_template = body_template + "<a href=\"/club/repaste/detail.aspx?rid=" + ds2.Tables["index"].Rows[i]["rid"].ToString() + "\">" + check1.CheckRecord(ds2.Tables["index"].Rows[i]["topic"].ToString()) + "</a><br/>"; if (i == ds2.Tables["index"].Rows.Count - 1) { body_template += "<div style=\"width:98%;text-align:right;\"><a href=\"/club/repaste/other.aspx?uid=" + u + "\">查看TA的全部转贴>></a></div>"; } } string[] udetail; AllinUser AllinUser1 = new AllinUser(); udetail = AllinUser1.GetUserDetail(u); string uhomeid = udetail[10]; mysqldata_conn mysqlcn = new mysqldata_conn(); sql = "select uc_members.uid,uc_members.username,uchome_space.name from uc_members left join uchome_space on uc_members.uid = uchome_space.uid where uc_members.uid = " + uhomeid; ds2 = mysqlcn.mdb_ds(sql, "uc"); string uhomename = ""; if (ds2.Tables["uc"].Rows[0]["name"].ToString() == "") { uhomename = ds2.Tables["uc"].Rows[0]["username"].ToString(); } else { uhomename = ds2.Tables["uc"].Rows[0]["name"].ToString(); } sql = "DELETE FROM uchome_feed WHERE appid = 1 AND icon = 'repaste' AND uid = " + uhomeid + ";INSERT INTO uchome_feed (appid,icon,uid,username,dateline,friend,hash_data,title_template,body_template) VALUES (1,'repaste'," + uhomeid + ",'" + uhomename + "'," + UnixTimestamp() + ",0,'" + UnixTimestamp() + "','<b>{actor}</b> 转贴给大家','" + body_template + "')"; //Response.Write(sql); mysqlcn.mdb_exe(sql); if (Radio2.Checked == true) { sql = ""; if (answer1.Value != "") { DataSet ds_v = new DataSet(); sql = "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer1.Value) + "',1," + redirect_tid + ");SELECT @@identity "; ds_v = cn.mdb_ds(sql,"vote"); sql = "INSERT INTO TB_REPASTE_VIEW (userid,tid,voteid) VALUES (" + u + "," + redirect_tid + "," + ds_v.Tables["vote"].Rows[0][0].ToString() + ");"; } if (answer2.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer2.Value) + "',0," + redirect_tid + ");"; } if (answer3.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer3.Value) + "',0," + redirect_tid + ");"; } if (answer4.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer4.Value) + "',0," + redirect_tid + ");"; } if (answer5.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer5.Value) + "',0," + redirect_tid + ");"; } if (answer6.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer6.Value) + "',0," + redirect_tid + ");"; } if (answer7.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer7.Value) + "',0," + redirect_tid + ");"; } if (answer8.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer8.Value) + "',0," + redirect_tid + ");"; } cn.mdb_exe(sql); } Response.Redirect("detail.aspx?rid=" + redirect_rid); }
protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { check ck = new check(); order order1 = new order(); string u = ck.CheckNumber(order1.GetRequestQueryString("u", "0")); mysqldata_conn mycn = new mysqldata_conn(); data_conn cn=new data_conn (); DataSet ds = cn.mdb_ds("select * from TB_User where UserID=" + u,"UCenterHomeUid"); string fuid = ds.Tables["UCenterHomeUid"].Rows[0]["UCenterHomeUid"].ToString(); //Response.Write("select * from TB_User where UserID=" + Request.Cookies["user_id"].Value.ToString()); ds = cn.mdb_ds("select * from TB_User where UserID=" + Request.Cookies["user_id"].Value.ToString(), "UCenterHomeUid"); string uid = ds.Tables["UCenterHomeUid"].Rows[0]["UCenterHomeUid"].ToString(); string fuername = ds.Tables["UCenterHomeUid"].Rows[0]["UCenterHomeUid"].ToString(); mycn.mdb_exe("insert into uchome_friend (uid,fuid,fusername,status,dateline) values (" + uid + "," + fuid + ",'',1," + UnixTimestamp() + ")"); mycn.mdb_exe("insert into uc_friends (uid,friendid,direction) values (" + uid + "," + fuid + ",3)"); mycn.mdb_exe("insert into uc_friends (uid,friendid,direction) values (" + fuid + "," + uid + ",3)"); ScriptManager.RegisterStartupScript(ImageButton2, ImageButton2.GetType(), "Alert", "alert('好友添加成功');window.location.href='friend.aspx'", true); }
protected void Button1_Click(object sender, EventArgs e) { check ck = new check(); data_conn cn = new data_conn(); string sql = ""; sql = sql + "select * "; sql = sql + "from TB_User "; sql = sql + "where UserName = '******'"; DataSet ds = new DataSet(); ds = cn.mdb_ds(sql, "T_User"); if (WordsIScn(UserName.Value) && WordsIScn(Text1.Value) && WordsIScn(Text2.Value) && WordsIScn(Text3.Value) && WordsIScn(Text4.Value) && WordsIScn(Text5.Value) && WordsIScn(Text6.Value) && WordsIScn(Text7.Value) && WordsIScn(Text8.Value) && WordsIScn(Text9.Value) && WordsIScn(Text10.Value) && WordsIScn(Text11.Value) && WordsIScn(Text12.Value) && WordsIScn(Text13.Value) && WordsIScn(Text14.Value) && WordsIScn(TEXTAREA1.Value)) { } else { MessageBox("opfail", "不能出现中文字符"); return; } if (ds.Tables["T_User"].Rows.Count > 0) { MessageBox("opfail", "该用户名已被使用"); return; } if (Text1.Value != Text2.Value) { MessageBox("opfail", "两遍输入的密码不相同"); return; } if (!Checkbox1.Checked) { MessageBox("opfail", "Please read the service terms and agree"); return; } if (UserName.Value == "" || Text1.Value == "" || Text2.Value == "" || Text3.Value == "" || Text5.Value == "" || DropDownList1.SelectedValue == "" || Text6.Value == "" || Text8.Value == "" || Text11.Value == "" || Text12.Value == "") { MessageBox("opfail", "*号为必填项"); return; } string recommendUserID; if (this.Request.Cookies["recommendUserID"] == null) { recommendUserID = "0"; } else { if (this.Request.Cookies["recommendUserID"].Value == "") { recommendUserID = "0"; } else { recommendUserID = Request.Cookies["recommendUserID"].Value; } } if (this.Request.Cookies["UID"] == null) { } else { if (Request.Cookies["UID"].Value == "") { } else { data_conn Uidcn = new data_conn(); DataSet Uidds = Uidcn.mdb_ds("select UserID from TB_User where UCenterHomeUid=" + Request.Cookies["UID"].Value, "uid"); if (Uidds.Tables["uid"].Rows.Count == 1) { recommendUserID = Uidds.Tables["uid"].Rows[0][0].ToString(); mysqldata_conn mycn = new mysqldata_conn(); mycn.mdb_exe("update uchome_space set credit=credit+10 where uid=" + Request.Cookies["UID"].Value); } } } sql = ""; sql += "INSERT INTO "; sql += "TB_User "; sql += "("; sql += "UserName, "; sql += "UserPassword, "; sql += "RealName, "; sql += "First_Name, "; sql += "Last_Name, "; sql += "EN_CompanyName, "; sql += "CompanyType, ";//int sql += "Phone, "; sql += "Fax, "; sql += "UserEmail, "; sql += "Usermsn, "; sql += "Website, "; sql += "EN_Country, "; sql += "EN_City, "; sql += "EN_Address, "; sql += "PostNumber, "; sql += "EN_Company_profile, "; sql += "UserPoint, "; sql += "IfPass, "; sql += "ifvip, "; sql += "ifmanage, "; sql += "ifEn, "; sql += "Regtime)"; sql += "VALUES "; sql += "("; sql += "'" + ck.CheckInput(UserName.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text1.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text3.Value.ToString()) + " " + ck.CheckInput(Text4.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text3.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text4.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text5.Value.ToString()) + "', "; sql += "" + ck.CheckInput(DropDownList1.SelectedValue) + ", "; sql += "'" + ck.CheckInput(Text6.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text7.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text8.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text9.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text10.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text11.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text12.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text13.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(Text14.Value.ToString()) + "', "; sql += "'" + ck.CheckInput(TEXTAREA1.Value.ToString()) + "', "; sql += "0, "; sql += "1, "; sql += "1, "; sql += "0, "; sql += "1, "; sql += "'" + ck.CheckInput(DateTime.Now.ToString()) + "' "; sql += ")"; cn.mdb_exe(sql); sql = "SELECT * FROM TB_User WHERE UserName = '******'"; ds = cn.mdb_ds(sql, "user"); string sql_account = "insert into TB_ORDER_ACCOUNT (userid) VALUES (" + ds.Tables["user"].Rows[0]["UserID"].ToString() + ")"; cn.mdb_exe(sql_account); //增加账户信息 if (ds.Tables["user"].Rows.Count != 0) { try { points p = new points(); p.AddNewPoints(ds.Tables["user"].Rows[0]["UserID"].ToString()); } catch (Exception ex) { } string userid = ds.Tables["user"].Rows[0]["UserID"].ToString(); string usernm = ds.Tables["user"].Rows[0]["UserName"].ToString(); string ifvip = ds.Tables["user"].Rows[0]["ifvip"].ToString(); string ifmanage = ds.Tables["user"].Rows[0]["ifmanage"].ToString(); string realname = ds.Tables["user"].Rows[0]["realname"].ToString(); string useremail = ds.Tables["user"].Rows[0]["useremail"].ToString(); Response.Cookies["user_id"].Value = userid; Response.Cookies["user_name"].Value = Server.UrlEncode(usernm); Response.Cookies["ifvip"].Value = ifvip; Response.Cookies["ifmanage"].Value = ifmanage; Response.Cookies["user_id"].Expires = DateTime.Now.AddDays(365); Response.Cookies["user_name"].Expires = DateTime.Now.AddDays(365); Response.Cookies["ifvip"].Expires = DateTime.Now.AddDays(365); Response.Cookies["ifmanage"].Expires = DateTime.Now.AddDays(365); Response.Cookies["realname"].Value = Server.UrlEncode(realname); Response.Cookies["useremail"].Value = Server.UrlEncode(useremail); Response.Cookies["realname"].Expires = DateTime.Now.AddDays(365); Response.Cookies["useremail"].Expires = DateTime.Now.AddDays(365); if (recommendUserID != "0") { cn.mdb_exe("insert into T_FRIEND (UID,FID) values (" + userid + "," + recommendUserID + ")"); cn.mdb_exe("insert into T_FRIEND (UID,FID) values (" + recommendUserID + "," + userid + ")"); Mark mark = new Mark(); mark.MarkOperate(Convert.ToInt32(recommendUserID), 10, "推荐会员", Convert.ToInt32(userid)); } mysqldata_conn mysqlcn = new mysqldata_conn(); DataSet dscount = mysqlcn.mdb_ds("select * from uc_members where username='******'", "ucenter"); if (dscount.Tables["ucenter"].Rows.Count == 0) { Random r = new Random(); string salt = r.Next().ToString().Substring(0, 6); string username = usernm; string password = MD5(MD5(ds.Tables["user"].Rows[0]["UserPassword"].ToString()) + salt); string email = ds.Tables["user"].Rows[0]["UserEmail"].ToString(); string myid = ""; string myidkey = ""; string regip = Page.Request.UserHostAddress; string regdate = UnixTimestamp(); string lastloginip = "0"; string lastlogintime = "0"; string id = this.insert(username, "8fc24ae194289b94e36272a5f9882611", email, myid, myidkey, regip, regdate, lastloginip, lastlogintime, "594882"); if (id != "") { mysqlcn.mdb_exe("insert into uchome_member (uid,username,password) values (" + id + ",'','" + MD5(id + "|" + UnixTimestamp()) + "')"); mysqlcn.mdb_exe("insert into uc_memberfields (uid,blacklist) values (" + id + ",'')"); string myemail; string qq; string msn; if (ds.Tables["user"].Rows[0]["UserEmail"].ToString() != "") { myemail = ds.Tables["user"].Rows[0]["UserEmail"].ToString(); } else { myemail = ""; } qq = ""; msn = ""; mysqlcn.mdb_exe("insert into uchome_spacefield (uid,email,qq,msn,blood,birthprovince,birthcity,resideprovince,residecity,note,spacenote,authstr,theme,css,privacy,friend,feedfriend,sendmail) values (" + id + ",'" + myemail + "','" + qq + "','" + msn + "','','','','','','','','','','','','','','')"); //插入实名 string namestatus = "0"; //实名 mysqlcn.mdb_exe("insert into uchome_space (uid,groupid,username,name,namestatus,domain,dateline,ip) values (" + id + ",5,'" + username + "',''," + namestatus + ",''," + UnixTimestamp() + ",'" + Page.Request.UserHostAddress + "')"); cn.mdb_exe("update TB_User set UCenterHomeUid=" + id + " where UserId=" + userid); //在ucenter中添加推荐好友 if (Request.Cookies["UID"] == null) { } else { if (Request.Cookies["UID"].Value == "") { } else { string gid = "0"; if (this.Request.Cookies["g"] == null) { } else { if (Request.Cookies["g"].Value == "") { } else { gid = Request.Cookies["g"].Value; try { int g = Convert.ToInt32(gid); if (g > 0 && g < 8) { gid = g.ToString(); } else { gid = "0"; } } catch (Exception ex) { gid = "0"; } } } DataSet myUidds = mysqlcn.mdb_ds("select username from uc_members where uid=" + Request.Cookies["UID"].Value, "uid"); mysqlcn.mdb_exe("insert into uchome_friend (uid,fuid,fusername,status,gid,note,dateline) values (" + id + "," + Request.Cookies["UID"].Value + ",'" + myUidds.Tables["uid"].Rows[0][0].ToString() + "',1,0,''," + UnixTimestamp() + ")"); mysqlcn.mdb_exe("insert into uchome_friend (uid,fuid,fusername,status,gid,note,dateline) values (" + Request.Cookies["UID"].Value + "," + id + ",'" + username + "',1," + gid + ",''," + UnixTimestamp() + ")"); mysqlcn.mdb_exe("insert into uc_friends (uid,friendid,direction,comment) values (" + id + "," + Request.Cookies["UID"].Value + ",3,'')"); mysqlcn.mdb_exe("insert into uc_friends (uid,friendid,direction,comment) values (" + Request.Cookies["UID"].Value + "," + id + ",3,'')"); } } } else { Response.Write("safasdfasdf"); } } Response.Cookies["useremail"].Value = Text8.Value.ToString(); Response.Redirect("/en/login_2.aspx"); } }