Pet inventory 5/7 7000days with Item

[Mixizi]

Hello , so I didn't see anyone release that so lets do it ^^.

That make working inventory pet expansion .

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddTimedJobForPet]    Script Date: 02/24/2013 12:26:27 ******/

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--	Edited by Mixizi Ethereal Online	
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

ALTER PROCEDURE [dbo].[_AddTimedJobForPet]
	@CharID			int,
	@Category		tinyint,
	@JobID			int,
	@TimeToKeep		int,
	@Data1			int,
	@Data2			int,
	@Data3			int,
	@Data4			int,
	@Data5			int,
	@Data6			int,
	@Data7			int,
	@Data8			int,
	@Serial64		bigint
as
	if (not exists (select ID from _CharCOS with (nolock) where ID = @CharID))
		return -1

	declare @NewJobID int
	set @NewJobID = 0

	insert into _TimedJobForPet values(@CharID, @Category, @JobID, 1992999999, @Data1, @Data2, 112, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, 0)
	set @NewJobID = @@identity

	if (@@error <> 0 or @@rowcount = 0)
		return -2

	return @NewJobID

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

In game just make the item :

ITEM_MALL_PET_WATCH_CHULHYEN_4W 1

That give 5/7 Inventory page and 7306 Days expension and you only need to teleport your character after the item used.

You are free to change the code for change the amout of page & time.

[MentaL]

[Crue]

Nice..

[Jason1990]

one question,

when i change

insert into _TimedJobForPet values(@CharID, @Category, @JobID, 1992999999, @Data1, @Data2, 112, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, 0)
	set @NewJobID = @@identity

Can i set in that way the 7306Days? because if my pet work 28Days, i only want to add the time for expansion for 28days too.

Thanks for release! and thanks for answer (maybe) :D

[Mixizi]

one question,

when i change

insert into _TimedJobForPet values(@CharID, @Category, @JobID, 1992999999, @Data1, @Data2, 112, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, 0)
	set @NewJobID = @@identity

Can i set in that way the 7306Days? because if my pet work 28Days, i only want to add the time for expansion for 28days too.

Thanks for release! and thanks for answer (maybe) :D

I've tried with 30days didn't work but I think I've find the solution , I'll say you more soon ;)

[Jason1990]

I've tried with 30days didn't work but I think I've find the solution , I'll say you more soon ;)

Would be very interesting! Because i search for an ability to use these item long time ago.
Maybe u directly now how to add the same clock with only 1 extra page?^^

[Showtek]

Yeah, i need it with 28 days too :)

[atef007]

Yeah, i need it with 28 days too :)

It's My Frist Answer In RageZone
and i was here from 8 Years ^_^
here ur Answer change To 5004000

[Jason1990]

It's My Frist Answer In RageZone
and i was here from 8 Years ^_^
here ur Answer change To 5004000

Doesn't work, only give out 4pages and after teleport it's back to one :D but nice try hehe

[alandonilo]

30 Days = 43200

[Mixizi]

30 Days = 43200

You tested it ?

[alandonilo]

yes !!

[Showtek]

When i use this scroll before teleport i have 5 inventories, after teleport 4. wtf.

[Mixizi]

The 5 Days don't work !

[sroYunk]

i have try alot of differnet values Nothing working only this one with 7000++ anyone
have found out maybee how they have to change the value to fix up to maybee 28 days or so on =?

[BlackNova]

Tried that and dont work.
After 60 seks and teleport the pages are gone