Need Query for add item to all player

Need It Fast please, thanks

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

Quote:

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

Quote:

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 ;)