Help penalty guild

xaladim · 05/10/2015, 21:53

I need you help please.

Xutan* · 05/10/2015, 22:55

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

xaladim · 05/11/2015, 01:04

my server have FGW :/ how to remove this ?

Xutan* · 05/11/2015, 04:14

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

Dallin¥ · 05/11/2015, 17:09

put this lines at your addtimedjob procedure

IF @Category=2 and @JobID in (1,2)
begin
delete from _TimedJob WHERE ID=@NewJobID
end