zwei833
Emperor
- Joined
- Feb 26, 2011
- Messages
- 1,229
Let's take this as an example:
Code:INSERT INTO Units (Type, Class, Combat, CombatClass) VALUES ('UNIT_C15_MUSKETDUDE', 'UNITCLASS_MUSKETMEN', 24, 'UNITCOMBAT_GUN'); CREATE TRIGGER Zwei_MusketManChange ON INSERT INTO Units WHERE Class = 'UNITCLASS_MUSKETMEN' --I've never got triggers to work, so I don't know the exact working UPDATE Units SET CombatClass = 'UNITCOMBAT_RANGED', RangedCombat = Combat - 2, Combat = Combat - 2 WHERE Type = *.NEW --Or whatever the temporary variable is END;
If that doesn't make sense, ask someone who knows triggers to write it out properly.
Google Translate says that those mean "Wild 'Tachi'" and "Scroll". Anywhere near what you intended?
[Edit]
Tachi is indeed a sword, but it just appears to be a precursor to the Katana. It's a start though, so thanks!
I will take a look of the code tomorrow, thanks!
not 'Tachi', but Nodachi(野太刀) and Nagamaki(長卷).