|
You last visited: Today at 13:39
Advertisement
vSro Guild user Limit [Query]
Discussion on vSro Guild user Limit [Query] within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
06/15/2014, 10:31
|
#1
|
elite*gold: 0
Join Date: Feb 2014
Posts: 73
Received Thanks: 30
|
vSro Guild user Limit [Query]
A lot of people are looking for and this is something that needs
Just say thank you.
PHP Code:
How to use? Right click SRO_VT_SHARD > New Query > Paste code > Execute.
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' -- << Userr Limit Credits by $Apollo
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
2nd Union Limit
Code:
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 @rvalue int
exec @rvalue = _Guild_FnAddMember @guildID, @CreaterID, 0, @FoundationDate,0xffffffff
if (@@error <> 0 or @rvalue <= 0)
begin
rollback transaction
return @rvalue
end
-- 길드 창고를 생성하자
exec @rvalue = _Guild_CreateChest_NoTX @guildID
if (@@error <> 0 or @rvalue <= 0)
begin
rollback transaction
return @rvalue
end
commit transaction
return @guildID
/* Credits by Apollo : Skype apollo1337_1*/
|
|
|
06/16/2014, 16:40
|
#2
|
elite*gold: 5
Join Date: Mar 2008
Posts: 6,223
Received Thanks: 3,766
|
#approved
|
|
|
06/16/2014, 17:47
|
#3
|
elite*gold: 0
Join Date: Mar 2012
Posts: 28
Received Thanks: 1
|
Good Jop
|
|
|
06/16/2014, 20:05
|
#4
|
elite*gold: 0
Join Date: Jun 2014
Posts: 38
Received Thanks: 53
|
Quote:
Originally Posted by $Apollo
A lot of people are looking for and this is something that needs
Just say thank you.
PHP Code:
How to use? Right click SRO_VT_SHARD > New Query > Paste code > Execute.
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' -- << Userr Limit Credits by $Apollo
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
2nd Union Limit
Code:
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 @rvalue int
exec @rvalue = _Guild_FnAddMember @guildID, @CreaterID, 0, @FoundationDate,0xffffffff
if (@@error <> 0 or @rvalue <= 0)
begin
rollback transaction
return @rvalue
end
-- 길드 창고를 생성하자
exec @rvalue = _Guild_CreateChest_NoTX @guildID
if (@@error <> 0 or @rvalue <= 0)
begin
rollback transaction
return @rvalue
end
commit transaction
return @guildID
/* Credits by Apollo : Skype apollo1337_1*/
|
Quote:
Originally Posted by nnnn200123
Good Jop
|
Thank you
|
|
|
07/16/2014, 03:02
|
#5
|
elite*gold: 0
Join Date: Mar 2010
Posts: 177
Received Thanks: 11
|
Quote:
Originally Posted by $Apollo
A lot of people are looking for and this is something that needs
Just say thank you.
PHP Code:
How to use? Right click SRO_VT_SHARD > New Query > Paste code > Execute.
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' -- << Userr Limit Credits by $Apollo
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
2nd Union Limit
Code:
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 @rvalue int
exec @rvalue = _Guild_FnAddMember @guildID, @CreaterID, 0, @FoundationDate,0xffffffff
if (@@error <> 0 or @rvalue <= 0)
begin
rollback transaction
return @rvalue
end
-- 길드 창고를 생성하자
exec @rvalue = _Guild_CreateChest_NoTX @guildID
if (@@error <> 0 or @rvalue <= 0)
begin
rollback transaction
return @rvalue
end
commit transaction
return @guildID
/* Credits by Apollo : Skype apollo1337_1*/
|
Msg 102, Level 15, State 1, Procedure _Guild_FnAddMember, Line 55
Incorrect syntax near '@guildID'. ???
|
|
|
07/16/2014, 22:30
|
#6
|
elite*gold: 85
Join Date: Aug 2010
Posts: 1,278
Received Thanks: 521
|
not recommend to change guild or union limits .. it will cuz some bugs later ^^
|
|
|
07/17/2014, 12:41
|
#7
|
elite*gold: 0
Join Date: Sep 2010
Posts: 53
Received Thanks: 4
|
Quote:
Originally Posted by Little Messi
Msg 102, Level 15, State 1, Procedure _Guild_FnAddMember, Line 55
Incorrect syntax near '@guildID'. ???
|
How . Me too
|
|
|
07/19/2014, 01:26
|
#8
|
elite*gold: 0
Join Date: Feb 2014
Posts: 73
Received Thanks: 30
|
|
|
|
07/19/2014, 11:38
|
#9
|
elite*gold: 0
Join Date: Aug 2008
Posts: 1,037
Received Thanks: 478
|
Quote:
Originally Posted by its.soul
not recommend to change guild or union limits .. it will cuz some bugs later ^^
|
Which bugs ?
|
|
|
07/20/2014, 23:00
|
#10
|
elite*gold: 85
Join Date: Aug 2010
Posts: 1,278
Received Thanks: 521
|
1st (tested bug ) when guild register fw the minmum user limit bugged some times can register even with 1 member .. sometimes didnt accept register even the guild 25/30
- it depends on the limit changes .. Ppl dont think you can change guild members even to maxmium 20 ..
2nd bug ( tested ) at areana guild register some times didnt telport all registered users
and some times it telports all guild in ( tested on 20 limit )
.. i didnt test the union limit !
but i like trace the orginial coding way .. buggs appear with testing ..SO keep testing
@plantix
From ur Server Website
Quote:
Important announcement:
With our serverinspection at 24th/25th July we change our union-/guildsystem.
There will be a unionlimit (2 guilds per union) and a guildlimit (30 players per guild).
Please note (its very important!!!): Every union with more than 2 guilds and every guild with more than 30 players will be deleted (deadline: 24th July 00:00 Servertime). If we delete a guild, everything related to the guild will be deleted too (guildstorage, fortress).
From now on, you have enough time to talk to your guildmates for who will stay and will leave to avoid the deletion of your guild.
|
Sounds not good !! .. just do it & test let me know what will you will found
|
|
|
07/21/2014, 16:02
|
#11
|
elite*gold: 0
Join Date: Sep 2007
Posts: 250
Received Thanks: 34
|
I am pretty sure that this union limit wont work, u are just simply creating new guilds nothing else nothing more, but u are missing alliancecreate and alliancedelete
|
|
|
11/14/2014, 00:45
|
#12
|
elite*gold: 60
Join Date: Nov 2014
Posts: 66
Received Thanks: 13
|
Good jop
|
|
|
11/15/2014, 19:53
|
#13
|
elite*gold: 60
Join Date: Nov 2014
Posts: 66
Received Thanks: 13
|
Thanks Dude Well Done
|
|
|
12/10/2014, 08:11
|
#14
|
elite*gold: 0
Join Date: Nov 2014
Posts: 28
Received Thanks: 5
|
anyway know how to edit sro_client to make it works any number instead of 50 members in guild?
|
|
|
12/10/2014, 08:42
|
#15
|
elite*gold: 0
Join Date: May 2013
Posts: 1,447
Received Thanks: 1,044
|
Good idea, but as @wolff66 said the union limit wont work by just creating the guilds, you will have to edit alliancecreate procedure to "insert" those guilds once an alliance is created and of course modify the alliancedelete procedure to make it impossible to delete guilds with name like @GuildName + 'Limit' or something like it..
|
|
|
|
|
Similar Threads
|
Simple query for union limit
06/18/2014 - SRO PServer Guides & Releases - 1 Replies
;Hello epvp.
I thought would work for you, because I share it with you
USE
GO
/****** Object: StoredProcedure . Script Date: 14.06.2014 16:53:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
|
[Request]How to make Job reward coin / Guild limit & union limit
02/12/2014 - SRO Private Server - 1 Replies
Hello everybody hope you are all fine
i want to ask how to add gold coins as a reward from jobbing if trader hunter thief sell their goods they receive the gold coin in guild storage or inventory doesn't matter , waiting for any hints or help :D
&
asking about how to set guild members limit if i want guild to be 32 member only
& union limit to be 4 guilds only
i know it seems big requests but HELPPPPPPPPPPPP xD spam ftw
thanks for reading this
my regards be safe :D
|
Vsro Files Query Error
01/27/2014 - SRO Private Server - 8 Replies
Hello Guys,
im looking around and trying to find help now for a long period.
Here is my Problem:
http://img36.imageshack.us/img36/9717/forufo.jpg
srShard
count=1
id=64
global_operation_id=20
|
Vsro 90 Lv. Limit
07/11/2012 - SRO Private Server - 0 Replies
Hello
From party Lv. 120 i want change 90 Lv. or have link vsro 90 lv. party sro_client
http://img600.imageshack.us/img600/5615/adszwy.pn g
|
Release : Vsro Databases in Query
09/16/2011 - SRO Private Server - 13 Replies
deleted
|
All times are GMT +2. The time now is 13:39.
|
|