static public int UpdatePassWord(string userName, string OldpassWord, string NewPassWord) { if (VerifyLogin(userName, OldpassWord) != 3) { return(0); } MysqlConnector mySql = new MysqlConnector(); mySql.SetServer(AESManager.AESDecrypt(AppVars.dbInfo.ipUrl, AppVars.AppParas.Enc0)); mySql.SetDataBase(AESManager.AESDecrypt(AppVars.dbInfo.dataName, AppVars.AppParas.Enc1)); mySql.SetUserID(AESManager.AESDecrypt(AppVars.dbInfo.userName, AppVars.AppParas.Enc2)); mySql.SetPassword(AESManager.AESDecrypt(AppVars.dbInfo.passWord, AppVars.AppParas.Enc3)); mySql.SetPort(AppVars.dbInfo.portNum.ToString()); mySql.SetCharset("utf-8"); string pwd = NewPassWord, salt = AppVars.AppParas.salt; try { mySql.ExeUpdate(string.Format("update {0} set password = '******' where uid = {2}", "user", MD5Manager.HashString(MD5Manager.HashString(NewPassWord) + salt), AppVars.AppParas.uid)); } catch (Exception ex) { return(0); } AppVars.AppParas.isLogin = false; return(2); }
static public int VerifyLogin(string userName, string passWord) { MysqlConnector mySql = new MysqlConnector(); MySqlDataReader reader; mySql.SetServer(AESManager.AESDecrypt(AppVars.dbInfo.ipUrl, AppVars.AppParas.Enc0)); mySql.SetDataBase(AESManager.AESDecrypt(AppVars.dbInfo.dataName, AppVars.AppParas.Enc1)); mySql.SetUserID(AESManager.AESDecrypt(AppVars.dbInfo.userName, AppVars.AppParas.Enc2)); mySql.SetPassword(AESManager.AESDecrypt(AppVars.dbInfo.passWord, AppVars.AppParas.Enc3)); mySql.SetPort(AppVars.dbInfo.portNum.ToString()); mySql.SetCharset("utf-8"); string pwd = "", salt = AppVars.AppParas.salt; int uid = 0, type = 0; try { reader = mySql.ExeQuery(string.Format("select * from {0} where username = '******'", "user", userName)); while (reader.Read()) { uid = Int32.Parse(reader.GetValue(0).ToString()); pwd = reader.GetValue(1).ToString(); salt = reader.GetValue(2).ToString(); type = Int32.Parse(reader.GetValue(3).ToString()); } } catch (Exception ex) { return(0); } if (pwd == "" || salt == "") { return(1); } if (MD5Manager.HashString(MD5Manager.HashString(passWord) + salt) == pwd) { AppVars.AppParas.isAdmin = type == 0 ? true : false; AppVars.AppParas.isLogin = true; AppVars.AppParas.uid = uid; AppVars.AppParas.UserName = userName; return(2); } return(3); }
static public int RegNewUser(string userName, string passWord, string Email) { int VerifyExist = VerifyLogin(userName, passWord); if (VerifyExist == 0) { return(0); } else if (VerifyExist != 1) { return(1); } MysqlConnector mySql = new MysqlConnector(); mySql.SetServer(AESManager.AESDecrypt(AppVars.dbInfo.ipUrl, AppVars.AppParas.Enc0)); mySql.SetDataBase(AESManager.AESDecrypt(AppVars.dbInfo.dataName, AppVars.AppParas.Enc1)); mySql.SetUserID(AESManager.AESDecrypt(AppVars.dbInfo.userName, AppVars.AppParas.Enc2)); mySql.SetPassword(AESManager.AESDecrypt(AppVars.dbInfo.passWord, AppVars.AppParas.Enc3)); mySql.SetPort(AppVars.dbInfo.portNum.ToString()); mySql.SetCharset("utf-8"); string pwd = passWord, salt = AppVars.AppParas.salt; try { mySql.ExeUpdate(string.Format("insert into {0}({1},{2},{3}) values('{4}','{5}',{6},'{7}')", "user", "username", "password", "type", userName, MD5Manager.HashString(MD5Manager.HashString(passWord) + salt), 1, Email)); } catch (Exception ex) { return(0); } if (VerifyLogin(userName, passWord) == 3) { return(2); } return(0); }