vSro Guild user Limit [Query]

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,
@MemberID int,
@MemberClass tinyint,
@joinDate smalldatetime,
@permission int

as
Declare @LiMiT int = '32' -- Credits by 'https://www.facebook.com/vsro.service' MaDenGo
if (exists (select CharID from _GuildMember where CharID = @MemberID))
begin
return -1001
end


declare @MemberName varchar(64)
declare @curLevel tinyint
select @MemberName = CharName16, @curLevel = CurLevel from _Char with (nolock) where CharID = @MemberID
if (@@error <> 0 or @@rowcount = 0)
begin
return -1
end
if (exists (select CharID from _GuildMember with (nolock) where GuildID = @guildID and CharID = @MemberID))
begin
return -2
end

declare @ReFObjID int
select @ReFObjID = RefObjID from _Char with (nolock) where CharID = @MemberID

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






declare @siegeAuthority tinyint
set @siegeAuthority = 0


if @MemberClass = 0 -- ±жё¶АМёй °шјє±ЗЗСА» commander·О јјЖГ! ±Ч їЬґВ АП№Э member·О јјЖГЗСґЩ.
begin
set @siegeAuthority = 1
end
Declare @GC int = (Select COUNT(*) from _GuildMember where GuildID = @guildID )
if @GC <= @LiMiT begin
insert _GuildMember values (@GuildID, @MemberID, @MemberName, @MemberClass, @curLevel, 0, @joinDate, @permission, 0, 0, 0, null, @ReFObjID, @siegeAuthority)
end
if (@@error <> 0 or @@rowcount = 0)
begin
return -3
end

if @GC <= @LiMiT begin
update _Char Set GuildID = @guildID where CharID = @MemberID
end
if (@@error <> 0 or @@rowcount = 0)
begin
return -4
end
return 1