|
You last visited: Today at 02:05
Advertisement
Max Plus and Guild Query
Discussion on Max Plus and Guild Query within the SRO Private Server forum part of the Silkroad Online category.
02/27/2015, 10:37
|
#1
|
elite*gold: 0
Join Date: Jun 2014
Posts: 42
Received Thanks: 9
|
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 -
|
|
|
02/27/2015, 11:14
|
#2
|
elite*gold: 70
Join Date: May 2014
Posts: 206
Received Thanks: 20
|
bro that's a produces not queries
|
|
|
02/27/2015, 12:17
|
#3
|
elite*gold: 41
Join Date: Oct 2012
Posts: 2,216
Received Thanks: 1,195
|
Quote:
Originally Posted by _Prophet_
|
wtf, add this query @ _addlogitem
|
|
|
02/27/2015, 12:17
|
#4
|
elite*gold: 0
Join Date: Dec 2014
Posts: 134
Received Thanks: 68
|
Fixed it for you
Guild limit:
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:
|
|
|
02/27/2015, 14:16
|
#5
|
elite*gold: 0
Join Date: Jun 2014
Posts: 42
Received Thanks: 9
|
Quote:
Originally Posted by Memoirs
Fixed it for you
Guild limit:
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:
|
Great man, thanks i really appreciate it!
|
|
|
02/28/2015, 07:17
|
#6
|
elite*gold: 0
Join Date: Nov 2014
Posts: 29
Received Thanks: 5
|
yeah
|
|
|
Similar Threads
|
vSro Guild user Limit [Query]
07/25/2023 - SRO PServer Guides & Releases - 18 Replies
A lot of people are looking for and this is something that needs
Just say thank you.
How to use?
Right click SRO_VT_SHARD > New Query > Paste code > Execute.
USE
GO
/****** Object: StoredProcedure . Script Date: 15.06.2014 11:08:20 ******/
|
[Suche]Query für "Alteklinge, Reichsklinge" &' Stichdolche NUR QUERY!
08/18/2010 - Metin2 Private Server - 1 Replies
Ich weiß ich werd nervig aber ich suche die Query's
für Alteklinge, Reichsklinge &' Strichdolche
Why?
Naya, weil ich in der DB i-wie nur Drachenmaulglocke hab
... not more -.-
Auf jeden Fall Icon's etc. etc. etc. hab ich ich brauche nur die Query's
|
All times are GMT +2. The time now is 02:05.
|
|