Need Query make grab pet 3 pages only

11/12/2018 05:19 a7med9000#1

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 ;)

11/12/2018 16:15 .Aaron#2

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

[Only registered and activated users can see links. Click Here To Register...]

11/29/2018 17:27 InPanic Kev#3

Quote:

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

[Only registered and activated users can see links. Click Here To Register...]

You can use more as 2 pages without server crash ! ;)

Quote:

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 : [Only registered and activated users can see links. Click Here To Register...] its crap.

11/29/2018 18:48 hoangphan7#4

It will crash your game server!

12/02/2018 21:30 .Aaron#5

Quote:

Originally Posted by InPanic Kev

You can use more as 2 pages without server crash ! ;)

better dont use the Link : [Only registered and activated users can see links. Click Here To Register...] its crap.

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. ;)

12/04/2018 09:21 InPanic Kev#6

Quote:

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. ;)

[Only registered and activated users can see links. Click Here To Register...] try it ;) we have 5 Pages.

01/20/2024 20:20 kaka20315#7

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

01/20/2024 20:38 Judgelemental#8

Quote:

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:

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

It's in SRO_VT_SHARD

And put these IDs inside:

Code:

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 @[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,56,0,0,0,0,0, @[Only registered and activated users can see links. Click Here To Register...]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