Yui
17-09-2013, 05:25 AM
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
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
alot of owner's of serve's ask about Query to give all player item
Today i will Release it for all free
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