need code to send reward

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

?

no answer ?

Quote:

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

use sro_vt_Shard
go
exec _additemextern @[Only registered and activated users can see links. Click Here To Register...]d,itemid

Quote:

Originally Posted by IM HictoR use sro_vt_Shard go exec _additemextern @[Only registered and activated users can see links. Click Here To Register...]d,itemid

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

:)

Quote:

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