public static string TalentInfoModify(DBManager dbMgr, int roleID, int totalCount, long exp, long expAdd, int isUp, int zoneID) { int result = 1; using (MyDbConnection3 conn = new MyDbConnection3(false)) { string cmdText = string.Format("REPLACE INTO t_talent(roleID, tatalCount, exp, zoneID) VALUES({0}, {1}, {2}, {3})", new object[] { roleID, totalCount, exp, zoneID }); int count = conn.ExecuteNonQuery(cmdText, 0); if (count > 0) { result = 0; TalentManager.TalentLogAdd(dbMgr, zoneID, roleID, 1, expAdd); if (isUp > 0) { TalentManager.TalentLogAdd(dbMgr, zoneID, roleID, 2, 1L); } TalentManager.DbUpdateTalent(dbMgr, roleID, totalCount, exp); } } return(result.ToString()); }
public static string TalentEffectClear(DBManager dbMgr, int roleID, int zoneID) { int result = 1; using (MyDbConnection3 conn = new MyDbConnection3(false)) { string cmdText = string.Format("DELETE FROM t_talent_effect where roleID={0}", roleID); int count = conn.ExecuteNonQuery(cmdText, 0); if (count > 0) { TalentManager.TalentLogAdd(dbMgr, zoneID, roleID, 3, 1L); result = 0; TalentManager.DbTalentClear(dbMgr, roleID); } } return(result.ToString()); }