Guild/Union Limit

[mudik]

#delete

[XxGhostSpiriTxX]

 Spoiler

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,
@ID int,
@Class tinyint,
@joinDate smalldatetime,
@ssion int

as
Declare @ int = '24'
if (exists (select CharID from _GuildMember where CharID = @ID))
begin
return -1001
end




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

declare @bjID int
select @bjID = RefObjID from _Char with (nolock) where CharID = @ID

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












declare @Authority tinyint
set @Authority = 0




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

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

 Spoiler

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 @lue int
exec @lue = _Guild_FnAddMember @guildID, @CreaterID, 0, @FoundationDate,0xffffffff
if (@@error <> 0 or @lue <= 0)
begin
rollback transaction
return @lue
end

-- ?? ??? ????
exec @lue = _Guild_CreateChest_NoTX @guildID
if (@@error <> 0 or @lue <= 0)
begin
rollback transaction
return @lue
end




commit transaction
return @guildID

[mudik]

Query’s will make lags/bugs any other way?

[devdash]

Originally Posted by mudik

Query’s will make lags/bugs any other way?

Well, i don't think so, but maybe other errors pop up

I remember i asked the same question once before, and the replay was "do not use it because ..." i can't remember the reason -_-

maybe someone else can correct me here.

[mudik]

Originally Posted by alydandy

Well, i don't think so, but maybe other errors pop up

I remember i asked the same question once before, and the replay was "do not use it because ..." i can't remember the reason -_-

maybe someone else can correct me here.

nah you are right its make problems xD

[White Ros3]

don't use these queries it's not efficient enough. better use a filter