[HELP]Sending item to specific channel only

Experienced Elementalist
Joined
Feb 17, 2015
Messages
263
Reaction score
119
Code:
INSERT INTO [CabalCash].[dbo].[MyCashItem] (UserNum, TranNo, ServerIdx, ItemKindIdx, ItemOpt, DurationIdx)
SELECT CharacterIdx/8, 0, 1, @item_id, @item_opt, @item_dur
FROM [Server01].[dbo].[cabal_character_table]
WHERE [Login]=1 AND [ChannelIdx]=4;

change it: @item_id, @item_opt, @item_dur, and ChannelIdx
 
Upvote 0
Joined
Jul 18, 2009
Messages
656
Reaction score
76
thank you its working
 
Upvote 0