фикс на пати.
от пользователя Нужно зарегистироваться что увидеть ссылки..
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