public bool UpdateUser(DDO_User ddo)
{
cmd = "update user set `user_name`=\"" + ddo.m_username + "\",`password`=\"" + ddo.m_pwd + "\",`question`=\"" + ddo.m_pwdProtectProblem + "\",`answer`=\"" + ddo.m_pwdProtectAnswer + "\" where `userid`=" + ddo.m_playerId + ";";
try { pool.ExecuteSql(database, cmd); } catch { return(false); }
return(true);
}
public int InsertUser(DDO_User ddo)
{
try {
DataSet ds = new DataSet();
cmd = "insert into `user` values(null,\"" + ddo.m_username + "\",\"" + ddo.m_pwd + "\",\"" + ddo.m_pwdProtectProblem + "\",\"" + ddo.m_pwdProtectAnswer + "\");select last_insert_id();";
//Console.WriteLine(cmd);
pool.ExecuteSql(database, cmd, ds);
return(int.Parse(ds.Tables[0].Rows[0]["last_insert_id()"].ToString()));
} catch {
return(-1);
}
}
//USER
public bool GetUserByUsername(string username, out DDO_User resUser)
{
DataSet ds = new DataSet();
cmd = "select * from `user` where user_name=\"" + username + "\";";
pool.ExecuteSql(database, cmd, ds);
if (ds.Tables[0].Rows.Count == 0)
{
resUser = default(DDO_User);
return(false);
}
resUser = new DDO_User(int.Parse(ds.Tables[0].Rows[0]["userid"].ToString()), username, ds.Tables[0].Rows[0]["password"].ToString(), ds.Tables[0].Rows[0]["question"].ToString(), ds.Tables[0].Rows[0]["answer"].ToString());
return(true);
}