Max Plus and Guild Query

Hello there epvp, i'm having trouble using the max plus and max guild query and i'm not sure what seems to be the problem. Would love some help. Both are from MaDenGo.
Here it is.

Max players in guild -

Max plus -

bro that's a produces not queries

Quote:

Originally Posted by _Prophet_ Max plus -  Spoiler [Only registered and activated users can see links. Click Here To Register...]

wtf, add this query @ _addlogitem

Fixed it for you

Guild limit:
Plus limit:
open SRO_VT_LOG database go to programmability > stored procedures. Find _AddLogItem procedure, open it and add this line at the end:
like this:

Quote:

Originally Posted by Memoirs Fixed it for you Guild limit:  Spoiler Code: 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 = '24' -- Credits by MaDenGo, fixed by Memoirs 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 Plus limit: open SRO_VT_LOG database go to programmability > stored procedures. Find _AddLogItem procedure, open it and add this line at the end: Code: IF (@Operation = 90 AND @strDesc like '%Opt: +13%') BEGIN UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 12 WHERE Serial64 = @ItemSerial END like this:  Spoiler [Only registered and activated users can see links. Click Here To Register...]

Great man, thanks i really appreciate it!

yeah