- Joined
- Apr 12, 2013
- Messages
- 899
- Reaction score
- 484
So, i wanted to create a script that adds all armors into the mixinginfo table for the specific contour cards
thats my query, but it don't work...maybe someone could help me
Code:
WHILE((SELECT ItemNum FROM atum2_db_account.dbo.ti_Item WHERE Kind = 16 AND ReqUnitKind = 61440) <> NULL)BEGIN
INSERT INTO atum2_db_account.dbo.ti_ItemMixingInfo (TargetItemNum, MixingProbability, MixingCost, SourceItemNum1, SourceItemCount1, SourceItemNum2, SourceItemCount2)
VALUES (7031740, 10000 , 0 ,(SELECT ItemNum FROM atum2_db_account.dbo.ti_Item WHERE Kind = 16 AND ReqUnitKind = 61440), 1, 7031740, 1)
END
thats my query, but it don't work...maybe someone could help me