Guild/Union Limit

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Guild_FnAddMember] Script Date: 15.06.2014 11:08:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO








ALTER PROCEDURE [dbo].[_Guild_FnAddMember]
@guildID int,
@[Only registered and activated users can see links. Click Here To Register...]ID int,
@[Only registered and activated users can see links. Click Here To Register...]Class tinyint,
@joinDate smalldatetime,
@[Only registered and activated users can see links. Click Here To Register...]ssion int

as
Declare @[Only registered and activated users can see links. Click Here To Register...] int = '24'
if (exists (select CharID from _GuildMember where CharID = @[Only registered and activated users can see links. Click Here To Register...]ID))
begin
return -1001
end




declare @[Only registered and activated users can see links. Click Here To Register...]Name varchar(64)
declare @curLevel tinyint
select @[Only registered and activated users can see links. Click Here To Register...]Name = CharName16, @curLevel = CurLevel from _Char with (nolock) where CharID = @[Only registered and activated users can see links. Click Here To Register...]ID
if (@@error <> 0 or @@rowcount = 0)
begin
return -1
end
if (exists (select CharID from _GuildMember with (nolock) where GuildID = @guildID and CharID = @[Only registered and activated users can see links. Click Here To Register...]ID))
begin
return -2
end

declare @[Only registered and activated users can see links. Click Here To Register...]bjID int
select @[Only registered and activated users can see links. Click Here To Register...]bjID = RefObjID from _Char with (nolock) where CharID = @[Only registered and activated users can see links. Click Here To Register...]ID

if (@@error <> 0 or @@rowcount = 0)
begin
return -5
end












declare @[Only registered and activated users can see links. Click Here To Register...]Authority tinyint
set @[Only registered and activated users can see links. Click Here To Register...]Authority = 0




if @[Only registered and activated users can see links. Click Here To Register...]Class = 0 -- ±æ¸¶ÀÌ¸é °ø¼º±ÇÇÑÀ» commander·Î ¼¼ÆÃ! ±× ¿Ü´Â ÀϹY member·Î ¼¼ÆÃÇÑ´Ù.
begin
set @[Only registered and activated users can see links. Click Here To Register...]Authority = 1
end
Declare @GC int = (Select COUNT(*) from _GuildMember where GuildID = @guildID )
if @GC <= @[Only registered and activated users can see links. Click Here To Register...] begin
insert _GuildMember values @guildID, @[Only registered and activated users can see links. Click Here To Register...]ID, @[Only registered and activated users can see links. Click Here To Register...]Name, @[Only registered and activated users can see links. Click Here To Register...]Class, @curLevel, 0, @joinDate @[Only registered and activated users can see links. Click Here To Register...]ssion, 0, 0, 0, null, @[Only registered and activated users can see links. Click Here To Register...]bjID, @[Only registered and activated users can see links. Click Here To Register...]Authority)
end
if (@@error <> 0 or @@rowcount = 0)
begin
return -3
end

if @GC <= @[Only registered and activated users can see links. Click Here To Register...] begin
update _Char Set GuildID = @guildID where CharID = @[Only registered and activated users can see links. Click Here To Register...]ID
end
if (@@error <> 0 or @@rowcount = 0)
begin
return -4
end
return 1

USE [SRO_VT_SHARD]

GO
/****** Object: StoredProcedure [dbo].[_Guild_Create] Script Date: 14.06.2014 16:53:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO








--
ALTER PROCEDURE [dbo].[_Guild_Create]
@guildName varchar(64),
@CreaterID int
as
if (exists (select id from _Guild where Name = @guildName))
begin
return -1000
end
if (exists (select CharID from _GuildMember where CharID = @CreaterID))
begin
return -1001
end
begin transaction

declare @guildID int
declare @FoundationDate smalldatetime

set @FoundationDate = GetDate()
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values (@guildName+'_ULimit_1', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values (@guildName+'_ULimit_2', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values (@guildName+'_ULimit_3', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values (@guildName+'_ULimit_4', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values (@guildName+'_ULimit_5', 1, 0, @FoundationDate,0,0)




insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values (@guildName, 5, 0, @FoundationDate,0,0)
set @guildID = @@identity

if (@@error <> 0 or @@rowcount = 0 or @guildID = 0)
begin
rollback transaction
return -5
end




--???? ???? 0xffffffff !!
declare @[Only registered and activated users can see links. Click Here To Register...]lue int
exec @[Only registered and activated users can see links. Click Here To Register...]lue = _Guild_FnAddMember @guildID, @CreaterID, 0, @FoundationDate,0xffffffff
if (@@error <> 0 or @[Only registered and activated users can see links. Click Here To Register...]lue <= 0)
begin
rollback transaction
return @[Only registered and activated users can see links. Click Here To Register...]lue
end

-- ?? ??? ????
exec @[Only registered and activated users can see links. Click Here To Register...]lue = _Guild_CreateChest_NoTX @guildID
if (@@error <> 0 or @[Only registered and activated users can see links. Click Here To Register...]lue <= 0)
begin
rollback transaction
return @[Only registered and activated users can see links. Click Here To Register...]lue
end




commit transaction
return @guildID