Need Query for add item to all player

[◄Aَِxٌelَْ►]

Need It Fast please, thanks

[mtnman33]

here you go , just change the "ITEM CODE" to what ever item you want to give then then hit execute and all players will get what ever items you want to send them , hope it helps

USE SRO_VT_SHARD
GO
DECLARE @CharName VARCHAR(64),
@ItemCodeName VARCHAR(64) = 'ITEM CODE' --Item's codename
-->Coded by Mountain_Man33
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

[◄Aَِxٌelَْ►]

Originally Posted by mtnman33

here you go , just change the "ITEM CODE" to what ever item you want to give then then hit execute and all players will get what ever items you want to send them , hope it helps

Thanks bro