Welcome!

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!

[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
658
Reaction score
75
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
thank you its working
 
Upvote 0
Back
Top