- Joined
- Jul 18, 2009
- Messages
- 655
- Reaction score
- 76
Hello is it possible to send item to specific channel only not to all channel
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!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;
thank you its workingCode: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