Pet Inventory 5/5 - REAL!

FOLKS I GOT IT WORK PERFECTLY...

Go to _AddNewCOS SP under SRO_SHARD modify and replace with this below.

Code:

---

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddNewCOS]    Script Date: 02/10/2012 11:32:15 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_AddNewCOS]
    @OwnerCharID    int,
    @RefObjID    int,
    @Level        int,
    @HP        int,
    @MP        int,
    @HGP        int,
    @KeeperNPC    int,
    @State        int,
    @InventorySize  int,
    @itemID        int,
    @PickItemConfig tinyint,
    @RentEndTime    smalldatetime
as

begin tran

    declare @COS_ID    int
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--        pet_skill_item (ÃÖ¼±È£)       
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

    declare @MaxInventorySize tinyint
    select @MaxInventorySize = InventorySize
    from _RefObjCommon, _RefObjChar
    where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID
   
    if( @@rowcount = 0 or @MaxInventorySize < @InventorySize )
    begin
        rollback tran
        return -5
    end

    insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
    set @COS_ID = @@identity
    if (@COS_ID = 0 OR @@error <> 0)
    begin
        rollback tran
        return -1
    end

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--        pet_skill_item (ÃÖ¼±È£)       
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
    if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
    begin
        declare @Slot  int
        set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--        pet_skill_item (ÃÖ¼±È£)       
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        begin
            insert into _InvCOS values(@COS_ID, @Slot, 0)
            if (@@error <> 0)
            begin
                -- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
                rollback tran
                return -2
            end   
       
            set @Slot = @Slot + 1
        end
    end
   
/*    --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù!
    UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID
    IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
    BEGIN
        ROLLBACK TRANSACTION
        RETURN -3
    END
*/
    if( @itemID <> 0 )
    begin
        update _Items set Data = @COS_ID where ID64 = @itemID
        if( @@error <> 0 or @@rowcount = 0 )
        begin
            rollback transaction
            return -4
        end
       
        --BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
        declare @Serial64 bigint
        select @Serial64 = Serial64 from _Items where Data = @COS_ID
        exec _AddTimedJobForPet @COS_ID,5,22926,1992999999,1111708465,1,112,0,0,0,0,0,@Serial64
        --BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
       
    end

    commit tran

return @COS_ID

---

ENJOY!!:thumbup:

Wow nice thanks

Nice work

don't works need change anything in media.pk2?

try to unsummon and summon again.. Thats what I say in the first place need to find the sp of that..

Quote:

---

Originally Posted by PX2000

try to unsummon and summon again.. Thats what I say in the first place need to find the sp of that..

---

already did, in 2nd i get crash i login in game and slot are the same

Well...Maybe because I'm using the new released DB...

Quote:

---

Originally Posted by PX2000

Well...Maybe because I'm using the new released DB...

*request to move development area...

---

i'm using BR files
can something be different?
What you changed? and this option work with all pet?

in me it all works but I just need to re-summon the pet... I don't know why its automatically deleted in _TimedJobForPet...

working fine ty

How can i make constum pages for each pet ?
Only change Inv size or what ?

Quote:

---

Originally Posted by BlackNova

How can i make constum pages for each pet ?
Only change Inv size or what ?

---

what you mean?

Because i want Pets with 3 and 5 sites
Example :
Monkey 5 Pages
Rabbit 3 pages

I got an idea call the expanding before summoning

Quote:

---

Originally Posted by BlackNova

Because i want Pets with 3 and 5 sites
Example :
Monkey 5 Pages
Rabbit 3 pages

---

That maybe possible just examine the procedures above...

Quote:

---

Originally Posted by LastThief

Because i want Pets with 3 and 5 sites
I got an idea call the expanding before summoning

---

I tried that but I dont know why its not working with me.. I'm searching any related to _TimedJobForPet, I found only 1 _AddTimedJobForPet procedure and when I look the procedure there is no DELETE or something like that but WHY all datas in _TimedJobForPet automatically delete when I unsummon the pet? pufff ~_~