Quote:
Originally Posted by Judgelemental
Hello, since I am playing alone I would not mind having 7 pages. I currently have 5
|
Create this table
Code:
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
And put these IDs inside
Code:
7493
9264
10369
10370
22865
23228
23229
23309
23857
23858
29534
36634
41760
(COS_% ids for default grab pets, you can add additional ones here if you have custom made)
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.