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!

Problem with Stored Procedure

Newbie Spellweaver
Joined
Aug 3, 2009
Messages
30
Reaction score
0
Im testing Stored Procedure, i maked Bound Talisma , when i drag on armor work fine , but when i relog i dont see more the name "Bound" on armor any one know why?? Thx and sry for my bad
English.



USE [kal_db]
GO
/****** Object: StoredProcedure [dbo].[SetPrefix] Script Date: 12/22/2009 00:32:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SetPrefix]

@prefix int,
@iid int

AS

IF (@prefix = 150)
begin
--do a special thing, like make bound
UPDATE [Item] SET Info = (Info|128) WHERE IID = @iid
end

ELSE
begin
-- do the normal query
UPDATE Item SET [Prefix] = @prefix WHERE [IID] = @iid
end
 
Back
Top