[NFP] Question: How to change a XML line via SQL?

[Elhoim]

I want to change a couple of values in some lines similar to this one:

<Row AttackForceType="StandardRaid" MinTargetDifficulty="DIFFICULTY_WARLORD" MaxTargetDifficulty="DIFFICULTY_EMPEROR" SpawnRate="1" MeleeTag="CLASS_MELEE" NumMeleeUnits="4" RangeTag="CLASS_RANGED" NumRangeUnits="2" RaidingForce="true"/>

Full Code:

<BarbarianAttackForces>
        <Row AttackForceType="LowDifficultyStandardRaid" MaxTargetDifficulty="DIFFICULTY_CHIEFTAIN" SpawnRate="1" MeleeTag="CLASS_MELEE" NumMeleeUnits="2" RaidingForce="true"/>
        <Row AttackForceType="StandardRaid" MinTargetDifficulty="DIFFICULTY_WARLORD" MaxTargetDifficulty="DIFFICULTY_EMPEROR" SpawnRate="1" MeleeTag="CLASS_MELEE" NumMeleeUnits="4" RangeTag="CLASS_RANGED" NumRangeUnits="2" RaidingForce="true"/>
        <Row AttackForceType="HighDifficultyStandardRaid" MinTargetDifficulty="DIFFICULTY_IMMORTAL" SpawnRate="1" MeleeTag="CLASS_MELEE" NumMeleeUnits="6" RangeTag="CLASS_RANGED" NumRangeUnits="4" RaidingForce="true"/>
        <Row AttackForceType="LowDifficultyStandardAttack" MaxTargetDifficulty="DIFFICULTY_CHIEFTAIN" SpawnRate="1" MeleeTag="CLASS_MELEE" NumMeleeUnits="4" RangeTag="CLASS_RANGED" NumRangeUnits="2" SiegeTag="CLASS_SIEGE" NumSiegeUnits="2"/>
        <Row AttackForceType="StandardAttack" MinTargetDifficulty="DIFFICULTY_WARLORD" MaxTargetDifficulty="DIFFICULTY_EMPEROR" SpawnRate="1" MeleeTag="CLASS_MELEE" NumMeleeUnits="6" RangeTag="CLASS_RANGED" NumRangeUnits="4" SiegeTag="CLASS_SIEGE" NumSiegeUnits="2" SupportTag="CLASS_BATTERING_RAM" NumSupportUnits="2"/>
        <Row AttackForceType="HighDifficultyStandardAttack" MinTargetDifficulty="DIFFICULTY_IMMORTAL" SpawnRate="1" MeleeTag="CLASS_MELEE" NumMeleeUnits="8" RangeTag="CLASS_RANGED" NumRangeUnits="6" SiegeTag="CLASS_SIEGE" NumSiegeUnits="4" SupportTag="CLASS_BATTERING_RAM" NumSupportUnits="2"/>
        <Row AttackForceType="LowDifficultyCavalryRaid" MaxTargetDifficulty="DIFFICULTY_CHIEFTAIN" SpawnRate="1" MeleeTag="CLASS_LIGHT_CAVALRY" NumMeleeUnits="2" RaidingForce="true"/>
        <Row AttackForceType="CavalryRaid" MinTargetDifficulty="DIFFICULTY_WARLORD" MaxTargetDifficulty="DIFFICULTY_EMPEROR" SpawnRate="1" MeleeTag="CLASS_LIGHT_CAVALRY" NumMeleeUnits="4" RangeTag="CLASS_MOBILE_RANGED" NumRangeUnits="2" RaidingForce="true"/>
        <Row AttackForceType="HighDifficultyCavalryRaid" MinTargetDifficulty="DIFFICULTY_IMMORTAL" SpawnRate="1" MeleeTag="CLASS_LIGHT_CAVALRY" NumMeleeUnits="6" RangeTag="CLASS_MOBILE_RANGED" NumRangeUnits="4" RaidingForce="true"/>
        <Row AttackForceType="LowDifficultyCavalryAttack" MaxTargetDifficulty="DIFFICULTY_CHIEFTAIN" SpawnRate="1" MeleeTag="CLASS_LIGHT_CAVALRY" NumMeleeUnits="4" RangeTag="CLASS_MOBILE_RANGED" NumRangeUnits="2" SiegeTag="CLASS_HEAVY_CAVALRY" NumSiegeUnits="2"/>
        <Row AttackForceType="CavalryAttack" MinTargetDifficulty="DIFFICULTY_WARLORD" MaxTargetDifficulty="DIFFICULTY_EMPEROR" SpawnRate="1" MeleeTag="CLASS_LIGHT_CAVALRY" NumMeleeUnits="6" RangeTag="CLASS_MOBILE_RANGED" NumRangeUnits="4" SiegeTag="CLASS_HEAVY_CAVALRY" NumSiegeUnits="2"/>
        <Row AttackForceType="HighDifficultyCavalryAttack" MinTargetDifficulty="DIFFICULTY_IMMORTAL" SpawnRate="1" MeleeTag="CLASS_LIGHT_CAVALRY" NumMeleeUnits="8" RangeTag="CLASS_MOBILE_RANGED" NumRangeUnits="6" SiegeTag="CLASS_HORSE_ARCHER" NumSiegeUnits="4"/>
        <Row AttackForceType="LowDifficultyNavalRaid" MaxTargetDifficulty="DIFFICULTY_CHIEFTAIN" SpawnRate="1" MeleeTag="CLASS_NAVAL_MELEE" NumMeleeUnits="2" RaidingForce="true"/>
        <Row AttackForceType="NavalRaid" MinTargetDifficulty="DIFFICULTY_WARLORD" MaxTargetDifficulty="DIFFICULTY_EMPEROR" SpawnRate="1" MeleeTag="CLASS_NAVAL_MELEE" NumMeleeUnits="4" RangeTag="CLASS_NAVAL_RANGED" NumRangeUnits="2" RaidingForce="true"/>
        <Row AttackForceType="HighDifficultyNavalRaid" MinTargetDifficulty="DIFFICULTY_IMMORTAL" SpawnRate="1" MeleeTag="CLASS_NAVAL_MELEE" NumMeleeUnits="6" RangeTag="CLASS_NAVAL_RANGED" NumRangeUnits="4" RaidingForce="true"/>
        <Row AttackForceType="LowDifficultyNavalAttack" MaxTargetDifficulty="DIFFICULTY_CHIEFTAIN" SpawnRate="1" MeleeTag="CLASS_NAVAL_MELEE" NumMeleeUnits="4" RangeTag="CLASS_NAVAL_RANGED" NumRangeUnits="2" SiegeTag="CLASS_NAVAL_RANGED" NumSiegeUnits="2"/>
        <Row AttackForceType="NavalAttack" MinTargetDifficulty="DIFFICULTY_WARLORD" MaxTargetDifficulty="DIFFICULTY_EMPEROR" SpawnRate="1" MeleeTag="CLASS_NAVAL_MELEE" NumMeleeUnits="6" RangeTag="CLASS_NAVAL_RANGED" NumRangeUnits="4" SiegeTag="CLASS_NAVAL_RANGED" NumSiegeUnits="2"/>
        <Row AttackForceType="HighDifficultyNavalAttack" MinTargetDifficulty="DIFFICULTY_IMMORTAL" SpawnRate="1" MeleeTag="CLASS_NAVAL_MELEE" NumMeleeUnits="8" RangeTag="CLASS_NAVAL_RANGED" NumRangeUnits="6" SiegeTag="CLASS_NAVAL_RANGED" NumSiegeUnits="4"/>
    </BarbarianAttackForces>

Would it be something like this?

UPDATE BarbarianAttackForces SET NumMeleeUnits = 8 WHERE AttackForceType = 'StandardRaid';

And if I wanted to change more things? Like SpawnRate and NumRangeUnits?

Thanks! =)

 

[Gedemon]

yep

UPDATE BarbarianAttackForces SET NumMeleeUnits = 8, SpawnRate = 2, NumRangeUnits = 45 WHERE AttackForceType = 'StandardRaid';

 

[Elhoim]

Awesome, thanks Gedemon!