[Help] Contour Script

[St34lth4ng3l]

So, i wanted to create a script that adds all armors into the mixinginfo table for the specific contour cards

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

[MentaL]

[fyrjzy]

i don't know how to use the script,but u can use this method.

first, you can Export the ti_item table to excel, and select all item about Kind = 16 AND ReqUnitKind = 61440
second, make the ti_ItemMixingInfo used excel about 7031740,then save the excel
third,import the excel u made from second part.

[St34lth4ng3l]

No i won't make it in excel, i wanna have a script for that because it's much easier and faster to execute

[hi5]

I dont understand what u really need, may be this?

DECLARE @Noob INT
SET @Noob = (SELECT ItemNum FROM atum2_db_account.dbo.ti_Item WHERE Kind = 16 AND ReqUnitKind = 61440)
INSERT INTO atum2_db_account.dbo.ti_ItemMixingInfo (TargetItemNum, MixingProbability, MixingCost, SourceItemNum1, SourceItemCount1, SourceItemNum2, SourceItemCount2)
VALUES (7031740, 10000 , 0 ,@Noob, 1, 7031740, 1)

???

[inetpub]

no, this will not work hi5.
That needs to use loop to insert all armors to MixingInfo

Read about making loops in T-SQL
should be smth like:

DECLARE @ID int
DECLARE IDs CURSOR LOCAL FOR SELECT ItemNum FROM atum2_db_account.dbo.ti_Item WHERE Kind = '16' AND ReqUnitKind = '61440'

OPEN IDs
FETCH NEXT FROM IDs into @ID
WHILE @@FETCH_STATUS = 0
BEGIN
    INSERT INTO atum2_db_account.dbo.ti_ItemMixingInfo (TargetItemNum, MixingProbability, MixingCost, SourceItemNum1, SourceItemCount1, SourceItemNum2, SourceItemCount2)
VALUES (7031740, 10000 , 0 ,@ID, 1, 7031740, 1) 

    FETCH NEXT FROM IDs into @ID
END

CLOSE IDs
DEALLOCATE IDs

[St34lth4ng3l]

When i'm at home ill test it, thanx in advance for the help^^

[DragonLord]

Holy hell you made some scary statements there.

INSERT INTO atum2_db_account.dbo.ti_ItemMixingInfo (TargetItemNum, MixingProbability, MixingCost, SourceItemNum1, SourceItemCount1, SourceItemNum2, SourceItemCount2)
SELECT 7031740, 10000 , 0 ,ItemNum, 1, 7031740, 1 FROM atum2_db_account.dbo.ti_Item WHERE Kind = 16 AND ReqUnitKind = 61440

No reason to use while loops or cursor loops for something this dead simple.