Query for add item to all player By Yui

[Yui]

Hello Silkroad4arab


alot of owner's of serve's ask about Query to give all player item
Today i will Release it for all free

كود PHP:

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

DECLARE    @CharName VARCHAR(64),
    @ItemCodeName VARCHAR(64) = 'ITEM_CH_SWORD_01_A'    --Item's codename

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 


Notice

Use this Query when server offline