Need Query make grab pet 3 pages only

[a7med9000]

Hello Please try Help Me
Need query make grab pet 3 pages only or 2 pages or 1
Don't like pets have 5 or 7 pages
Thanks for Helping me

[.Aaron]

Having grab pets with more than 2 pages in your server might result in crashing your gameserver. If you want your grab pets to have 2 pages, copy the proceure in the following pastebin link and execute it in SQL

[InPanic Kev]

Originally Posted by .Aaron

Having grab pets with more than 2 pages in your server might result in crashing your gameserver. If you want your grab pets to have 2 pages, copy the proceure in the following pastebin link and execute it in SQL

You can use more as 2 pages without server crash !

Originally Posted by a7med9000

Hello Please try Help Me
Need query make grab pet 3 pages only or 2 pages or 1
Don't like pets have 5 or 7 pages
Thanks for Helping me

better dont use the Link : its ****.

[hoangphan7]

It will crash your game server!

[.Aaron]

Originally Posted by InPanic Kev

You can use more as 2 pages without server crash !



better dont use the Link : its ****.

Sure, give me the link of whatever server you have with 3 grab pet pages or more, and give me 5 minutes to crash your gameserver.

[InPanic Kev]

Originally Posted by .Aaron

Sure, give me the link of whatever server you have with 3 grab pet pages or more, and give me 5 minutes to crash your gameserver.

try it we have 5 Pages.

[kaka20315]

can any one help me to the way to add page 2 to my pick pet's in my server (have just one page)

[Judgelemental]

Originally Posted by kaka20315

can any one help me to the way to add page 2 to my pick pet's in my server (have just one page)

(Credits: JohnDornel^)

Create this table:

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

It's in SRO_VT_SHARD

And put these IDs inside:

7489
7493
9263
9264
10365
10366
10369
10370
10373
22717
22718
22719
22865
22931
23228
23229
23276
23309
23330
23331
23857
23858
27503
29413
29534
36514
36634
41760

Go to SRO_VT_SHARD > Programmability > Stored Procedures > _AddNewCOS >Right Click and Modify

Add this before "commit tran" :

if ((SELECT COUNT(*) FROM _COS_Exceptions with (NOLOCK) where ID=@RefObjID) <> 0)
BEGIN
declare @64 bigint
DECLARE @ int
set @= DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) --get curent timestamp
set @= @+28*24*440000
select @64 = Serial64 from _Items where Data = @_ID
IF(NOT EXISTS(SELECT * FROM _TimedJobForPet WHERE CharID = @_ID))
BEGIN
exec _AddTimedJobForPet @_ID,5,22926, @,1111708465,1,56,0,0,0,0,0, @64
END
end

56 is the number of slots, so 2 pages.
For 5 pages you put 112.

Restart the GameServer, summon your pet, unsummon it, summon again and you have 2 pages