фикс на пати.
от пользователя batfriz
USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_insert_party] Script Date: 01/26/2013 21:53:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- start of smp_insert_party
ALTER PROCEDURE [dbo].[smp_insert_party]
@IN_NAME NVARCHAR(31),
@IN_PARTY_SID INT,
@IN_LEADER_SID INT,
@IN_PARTY_TYPE INT
AS
SET NOCOUNT ON
INSERT INTO dbo.Party( sid, name, leader_id, share_mode, party_type, lead_party_id ) VALUES( @IN_PARTY_SID, @IN_NAME, @IN_LEADER_SID, 0, @IN_PARTY_TYPE, 0 );
2
USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_set_party] Script Date: 01/26/2013 21:54:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- start of smp_set_party_leader
-- start of smp_set_party
ALTER PROCEDURE [dbo].[smp_set_party]
@IN_NAME NVARCHAR(31),
@IN_SID INT
AS
SET NOCOUNT ON
DECLARE @SID INT
SET @SID = 0
SELECT @SID = sid FROM Character WITH (NOLOCK) WHERE name = @IN_NAME
update Character set party_id = @IN_SID where sid = @SID
