Thank you for the quick response!Quote:
Create this table
And put these IDs insideCode:SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[_COS_Exceptions]( [ID] [int] NOT NULL, CONSTRAINT [PK__COS_Exceptions] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO
(COS_% ids for default grab pets, you can add additional ones here if you have custom made)Code:7493 9264 10369 10370 22865 23228 23229 23309 23857 23858 29534 36634 41760
Go to SRO_VT_SHARD > Programmability > Stored Procedures > _AddNewCOS > Right Click and Modify.
At the end, before "commit tran" add this
if ((SELECT COUNT(*) FROM _COS_Exceptions with (NOLOCK) where ID=@RefObjID) <> 0)
BEGIN
declare @[Only registered and activated users can see links. Click Here To Register...]64 bigint
DECLARE @[Only registered and activated users can see links. Click Here To Register...] int
set @[Only registered and activated users can see links. Click Here To Register...]= DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) --get curent timestamp
set @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]+28*24*440000
select @[Only registered and activated users can see links. Click Here To Register...]64 = Serial64 from _Items where Data = @[Only registered and activated users can see links. Click Here To Register...]_ID
IF(NOT EXISTS(SELECT * FROM _TimedJobForPet WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]_ID))
BEGIN
exec _AddTimedJobForPet @[Only registered and activated users can see links. Click Here To Register...]_ID,5,22926 @[Only registered and activated users can see links. Click Here To Register...],1111708465,1,28,0,0,0,0,0 @[Only registered and activated users can see links. Click Here To Register...]64
END
end
enD
To modify the amount of slots there is a "28" on the "exec _AddTimedJobForPet..." line, you can edit it there. Just multiplay pages * slotsPerPage and use that number. That should be all.
I could manage to unlock 7 pages, however as soon as I place an item on the 6th or 7th page I get a disconnect followed by:
[Only registered and activated users can see links. Click Here To Register...]