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

[sroYunk]

no one have any Resolution set this item to example 1 page more = 28 days
or 5 pages more 28 days

or like any of these ??

[lepitismak]

lost pages when relog

[Witchy Moo]

Utilizing the original pet extension item with a modified SP, pretty good idea but it's never the proper way to put pet extension item to use.

In other threads before this you can have 5/7 pages without any items right after spawning the pet and teleport the char.

Just a little info:

1. If you have modified SP (_AddTimedJobForPet), NO NEED to use extension item, just spawn the pet and teleport, and you'll have inventory expansion.
2. But if you're gonna fix and use the item, NO NEED to modify the SP. it's the other way around ;)

And a bit info about those two: (you have to pick either one)

*) For you guys who wanna stick to the SP modifications:

1992999999 = 7684 days
put it into as variable (for example: @timeToKeep) so you can change it anytime you want, here's how you count it:

change this:

    insert into _TimedJobForPet values @CharID, @category, @jobID, 1992999999, @data1, @data2, 112, @data4, @data5, @data6, @data7, @data8, @serial64, 0)
    set @NewJobID = @@identity

to this:

    DECLARE @rentEndTime DATETIME
    DECLARE @newtime INT
    SELECT @rentEndTime = RentEndTime FROM _CharCOS WHERE ID = @CharID
    SET @newtime = DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE())
    -- 3 days
    SET @timeToKeep = @newtime + 3 * 24 * 3600
    -- 24 days
    SET @timeToKeep = @newtime + 24 * 24 * 3600

    INSERT INTO _TimedJobForPet VALUES  @CharID, @category, @jobID, @timeToKeep, @data1, @data2, @data3, @data4, @data5, @data6, @data7, @data8, @serial64, 0)
    SET @NewJobID = @@identity

*) And a little tips for you guys who wanna use the pet extension item, 28 days will never work for the buff, it works only for the inventory extension, it's because the item cannot have maximum value of INT (-1875767296) of 28 days in Media side, not in database side, so forcing it as it is will make the client bugged and instead you'll lose the skill buff after some period of time. So you should decrease into 24 days, and it will work fine.

This is the result of using the item, in proper way:



good luck ;)

[BadFist]

or more simple with out editing noffing you can just add this... on skill -1875767296 and work only with a teleport.

[Witchy Moo]

or more simple with out editing noffing you can just add this... on skill -1875767296 and work only with a teleport.

Wrong, having -1875767296 value (28 days) will make the client have minus value as result and the skill will gone after some seconds. Only the inventory expansion will stay for 28 days. The workaround is to set it for 24 days.

[lepitismak]

make this

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


DECLARE @rentEndTime DATETIME
DECLARE @newtime INT
SELECT @rentEndTime = RentEndTime FROM _CharCOS WHERE ID = @CharID
SET @newtime = DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE())
-- 3 days
SET @timeToKeep = @newtime + 3 * 24 * 3600
-- 24 days
SET @timeToKeep = @newtime + 24 * 24 * 3600


INSERT INTO _TimedJobForPet VALUES @CharID, @category, @jobID, @timeToKeep, @data1, @data2, @data3, @data4, @data5, @data6, @data7, @data8, @serial64, 0)
SET @NewJobID = @@identity


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


return @NewJobID


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

and get this

Msg 102, Level 15, State 1, Procedure _AddTimedJobForPet, Line 38Incorrect syntax near '@CharID'.

[BadFist]

Wrong, having -1875767296 value (28 days) will make the client have minus value as result and the skill will gone after some seconds. Only the inventory expansion will stay for 28 days. The workaround is to set it for 24 days.

is work or not ? qqqq http://prntscr.com/2f2tqx

[Witchy Moo]

is work or not ? qqqq http://prntscr.com/2f2tqx

No, it's not, your pet missing "Skill" line, the working one would be like this:



;)

[lepitismak]

and if i need work with item?

[Witchy Moo]

and if i need work with item?

find old items in _RefObjCommon, something called "CHULYAN" or "AGOL", and learn the item parameters, these items were made for pet extension. You'll find a way ;)