[AmIMad]

Arkadaşlar Bütün Accountlara İtem Yollama

USE SRO_VT_SHARD 
GO 
/******* Query By Yui SQL ********/ 

DECLARE    @CharName VARCHAR(64), 
    @ItemCodeName VARCHAR(64) = 'ITEM_CH_SWORD_01_A'    --İtemin Refcommon'daki Codename 128Kodu

DECLARE item_cur CURSOR FOR 
SELECT DISTINCT CharName16 FROM _Char ORDER BY CharName16 

    OPEN item_cur 
        FETCH NEXT FROM item_cur INTO @CharName 
            WHILE @@FETCH_STATUS = 0 
                BEGIN 
                    EXEC _ADD_ITEM_EXTERN @CharName, @ItemCodeName, 1, 0  --params: CharName, ItemCodeName, Data(quantity or durability), OptLevel 
                    FETCH NEXT FROM item_cur INTO @CharName 
                END 
         
        PRINT @CharName 
    CLOSE item_cur 

DEALLOCATE item_cur