need code to send reward

[MARIUS_CL]

hello guys
i need code to send reward in storage to all server

?

no answer ?

[MrCatGardens]

Originally Posted by MARIUS_CL

hello guys
i need code to send reward in storage to all server

?

no answer ?

just search for the stored procedure additemextern (as far as i can remember). the rest should be self explanatory.
basic knowledge about stored procedures: google

[IM HictoR]

use sro_vt_Shard
go
exec _additemextern @d,itemid

[MARIUS_CL]

Originally Posted by IM HictoR

use sro_vt_Shard
go
exec _additemextern @d,itemid

i think this to send rw for one char
i want code to send to all game

[ZαKuRα]

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