internal static UserInfo GetUserInfo(string userName,string password) { string cmdText = string.Format("select top 1 username,password,tpp,ppp,pmsound,invisible,templateid,sigstatus,uid from [{2}users] where username='******' and password='******'", Utils.HtmlEncode(userName),Utils.MD5(password), Config.Instance.DNTTablePrefix); UserInfo info = null; using(DataTable table = _DB.vDataTable(cmdText)) { if (table != null && table.Rows.Count > 0) { DataRow row = table.Rows[0]; info = new UserInfo(); info.Tpp = row["tpp"].ToString(); info.Ppp = row["ppp"].ToString(); info.Pmsound = row["pmsound"].ToString(); info.Invisible = row["invisible"].ToString(); info.Sigstatus = row["sigstatus"].ToString(); info.Uid = row["uid"].ToString(); info.TemplateId = Convert.ToInt32(row["templateid"].ToString()); info.Password = row["password"].ToString(); } } return info; }
public static void WriteUserCookie(UserInfo userInfo) { if (userInfo != null) { HttpCookie cookie = new HttpCookie("dnt"); cookie.Values["userid"] = userInfo.Uid.ToString(); cookie.Values["password"] = Utils.UrlEncode(SetCookiePassword(userInfo.Password, Config.Instance.PasswordKey)); cookie.Values["tpp"] = userInfo.Tpp.ToString(); cookie.Values["ppp"] = userInfo.Ppp.ToString(); cookie.Values["pmsound"] = userInfo.Pmsound.ToString(); cookie.Values["invisible"] = userInfo.Invisible; cookie.Values["referer"] = "index.aspx"; cookie.Values["sigstatus"] = userInfo.Sigstatus.ToString(); cookie.Values["expires"] = "0"; string str2 = Config.Instance.CookieDomain; if (((str2 != string.Empty) && (HttpContext.Current.Request.Url.Host.IndexOf(str2) > -1)) && IsValidDomain(HttpContext.Current.Request.Url.Host)) { cookie.Domain = str2; } HttpContext.Current.Response.AppendCookie(cookie); if (userInfo.TemplateId > 0) { Utils.WriteCookie(Utils.GetTemplateCookieName(), userInfo.TemplateId.ToString(), 0xf423f); } } }
internal static UserInfo GetUserInfo(int userID) { string cmdText = string.Format("select username,password from [{1}users] where uid='{0}'", userID, Config.Instance.DNTTablePrefix); UserInfo info = null; using (DataTable table = _DB.vDataTable(cmdText)) { if (table != null && table.Rows.Count > 0) { DataRow row = table.Rows[0]; info = new UserInfo(); info.Password = row["password"].ToString(); } } return info; }