|
You last visited: Today at 19:14
Advertisement
[Release] disable Job & Guild Penalty
Discussion on [Release] disable Job & Guild Penalty within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
03/04/2013, 08:54
|
#1
|
elite*gold: 0 
Join Date: May 2006
Posts: 427
Received Thanks: 66
|
[Release] disable Job & Guild Penalty
Hey guys. I want to start to share my experience with you.
Feel free to share a Thanks 
Code:
USE [SRO_VT_SHARD]
GO
/******By Jangan ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
--##If you want to only have one not both, then just modify the line below!
if (@JobID = 1 or @JobID = 2)
BEGIN
return -1
END
ELSE
BEGIN
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
return @NewJobID
|
|
|
|
03/04/2013, 12:02
|
#2
|
Chat Killer In Duty
elite*gold: 5
Join Date: May 2008
Posts: 16,309
Received Thanks: 6,470
|
#approved
|
|
|
|
|
03/04/2013, 12:38
|
#3
|
elite*gold: 0
Join Date: Mar 2010
Posts: 458
Received Thanks: 125
|
nice work keep it up ..... enjoy it before haters comes 
|
|
|
|
|
03/04/2013, 13:18
|
#4
|
elite*gold: 0
Join Date: Jul 2011
Posts: 1,058
Received Thanks: 1,118
|
Quote:
Originally Posted by Nexus7
Hey guys. I want to start to share my experience with you.
Feel free to share a Thanks
Code:
USE [SRO_VT_SHARD]
GO
/******[B][SIZE="5"]By Jangan[/SIZE][/B] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
--##If you want to only have one not both, then just modify the line below!
if (@JobID = 1 or @JobID = 2)
BEGIN
return -1
END
ELSE
BEGIN
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
return @NewJobID
|
Sure bro. Try to complete the FGW dungeon with that procedure, good luck.
|
|
|
|
|
03/04/2013, 18:59
|
#5
|
elite*gold: 10
Join Date: Oct 2008
Posts: 1,938
Received Thanks: 947
|
i have workin one with it fgw works and fw dungeon too
|
|
|
|
|
03/05/2013, 09:51
|
#6
|
elite*gold: 0
Join Date: Feb 2008
Posts: 961
Received Thanks: 648
|
Here is a procedure which works with FGW etc (ONLY JOB,since I'm not interested in Guild resetting).
Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 03/05/2013 10:49:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
if @Category=2 and @JobID=2
begin
delete from _TimedJob where ID=@NewJobID
end
return @NewJobID
Pretty simple eh 
|
|
|
|
|
03/05/2013, 10:07
|
#7
|
elite*gold: 0
Join Date: May 2006
Posts: 427
Received Thanks: 66
|
What is FGW ?
|
|
|
|
|
03/05/2013, 14:50
|
#8
|
elite*gold: 0
Join Date: Feb 2008
Posts: 961
Received Thanks: 648
|
Quote:
Originally Posted by Nexus7
What is FGW ?
|
Forgotten World,basically whenever you enter it the server inserts into _TimedJob a value,and since Jangan's query returns an error and disconnects the character,you can't enter the FGW with that procedure.
|
|
|
|
|
03/05/2013, 15:50
|
#9
|
elite*gold: 71
Join Date: Mar 2011
Posts: 1,594
Received Thanks: 1,099
|
Quote:
Originally Posted by Nexus7
Hey guys. I want to start to share my experience with you.
Feel free to share a Thanks
Code:
USE [SRO_VT_SHARD]
GO
/******By Jangan ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
--##If you want to only have one not both, then just modify the line below!
if (@JobID = 1 or @JobID = 2)
BEGIN
return -1
END
ELSE
BEGIN
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
return @NewJobID
|
Are you sure that you made this query or copy/paste? -> Its by jangan
Code:
/******By Jangan ******/
|
|
|
|
|
03/05/2013, 15:55
|
#10
|
elite*gold: 0
Join Date: May 2006
Posts: 427
Received Thanks: 66
|
hmmm
|
|
|
|
 |
Similar Threads
|
I can't change guild penalty without breaking FGW.
08/09/2022 - SRO Private Server - 1 Replies
Hey guys,
So yeah , title says it all. Everytime we try and make no guild penalty FGW breaks. I'm just wondering if there is any way to make no guild penalty without breaking FGW.Since the whole server is complaining -.- .
Cheers guys
|
[Request] Job / Guild Penalty remove
07/31/2016 - SRO Private Server - 4 Replies
Hi anyone can do it ?
I tried a lot of time but I without success...
Can you share it?
tnx
|
Devias Guild Penalty *prob*
02/18/2013 - SRO Private Server - 0 Replies
Hey Guys,
i tought in Devias Online there is no Guild Penalty, when leaving ur Guild. But as i noted Guild Penalty is still *working. Do u have any Ideas how i could end the Penalty?
Greetz
|
How to Clear Guild Penalty
05/07/2012 - Shaiya - 2 Replies
How do u clear guild penalty, so people don't have to wait 3 days to Join/Make an guild.
|
VSRO- how to remove guild penalty
09/27/2011 - SRO Private Server - 1 Replies
hey guys does anybody know how to get rid of the 3 day wait?
|
All times are GMT +2. The time now is 19:14.
|
|
![[Release] disable Job & Guild Penalty](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/release-disable-job-guild-penalty_ltr.gif){kind=small}
