Help penalty guild

05/10/2015 21:53 xaladim#1

I need you help please.

05/10/2015 22:55 Xutan*#2

explain, what do u want?
if u want to remove guild penalty go to SRO_VT_SHARD > _AddTimedJob procedure >>
add this query

PHP Code:


			
if @JobID = 1
begin
return -1
end

after this

PHP Code:


			
            declare @NewJobID int
            set @NewJobID = 0

so it will be like that

PHP Code:


			
            declare @NewJobID int
            set @NewJobID = 0
if @JobID = 1
begin
return -1
end

don't use the query if fgw takes a part in your server's gameplay. REMEMBER THIS

05/11/2015 01:04 xaladim#3

my server have FGW :/ how to remove this ?

05/11/2015 04:14 Xutan*#4

well, there is a way better to remove guild penalty without breaking fgw but i'm not gonna share it.
however, here is another good way.
make a new return scroll and add this query in _AddLogItem

PHP Code:


			
if @Operation = 41 and @ItemRefID = id of the new return scroll in _RefObjCommon
begin
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID = @CharID and JobID = 1 and Category = 2
end

then add this scroll for 1gold. so people will get it for free

05/11/2015 17:09 Dallin�#5

put this lines at your addtimedjob procedure ;)
IF @Category=2 and @JobID in (1,2)
begin
delete from _TimedJob WHERE ID=@NewJobID
end