private void ProcessArmorLevelStarUpCmd(GameServerClient client, int nID, byte[] cmdParams, int count) { int ret = 0; RoleDataCmdT <RoleArmorData> data = DataHelper.BytesToObject <RoleDataCmdT <RoleArmorData> >(cmdParams, 0, count); if (data != null && data.RoleID > 0) { DBManager dbMgr = DBManager.getInstance(); DBRoleInfo dbRoleInfo = dbMgr.GetDBRoleInfo(ref data.RoleID); if (null != dbRoleInfo) { if (dbRoleInfo.ArmorData.Armor != data.Value.Armor || dbRoleInfo.ArmorData.Exp != data.Value.Exp) { dbRoleInfo.ArmorData.Armor = data.Value.Armor; dbRoleInfo.ArmorData.Exp = data.Value.Exp; using (MyDbConnection3 conn = new MyDbConnection3(false)) { string cmdText = string.Format("update t_roles set armor={1},armorexp={2} where rid={0}", data.RoleID, data.Value.Armor, data.Value.Exp); ret = conn.ExecuteSql(cmdText, new MySQLParameter[0]); } } } } client.sendCmd(nID, string.Format("{0}", ret)); }
private void ProcessArmorLevelStarUpCmd(GameServerClient client, int nID, byte[] cmdParams, int count) { int ret = 0; RoleDataCmdT <JingLingYuanSuJueXingData> data = DataHelper.BytesToObject <RoleDataCmdT <JingLingYuanSuJueXingData> >(cmdParams, 0, count); if (data != null && data.RoleID > 0) { DBManager dbMgr = DBManager.getInstance(); DBRoleInfo dbRoleInfo = dbMgr.GetDBRoleInfo(ref data.RoleID); if (null != dbRoleInfo) { dbRoleInfo.JingLingYuanSuJueXingData = data.Value; using (MyDbConnection3 conn = new MyDbConnection3(false)) { string cmdText = string.Format("insert into t_juexing_jlys(rid,activetype,activeids) values({0},{1},'{2}') on duplicate key update activetype={1},activeids='{2}'", data.RoleID, data.Value.ActiveType, string.Join <int>(",", data.Value.ActiveIDs)); ret = conn.ExecuteSql(cmdText, new MySQLParameter[0]); } } } client.sendCmd <int>(nID, ret); }