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);
}
