[SOLVED]Pet ep4 procedures

[Davidc96]

Hello

I need help with Pet procedures.

I was investigating how the Pet works and I edit the procedures to fix it.

But when I bought a PET, pet inserts into the Store and when I equiped, it doesn't appear and if I take off, it appears a 0xc000005 Exception.


This is my InsertStorePetItem

USE [atum2_db_1]
GO
/****** Object: StoredProcedure [dbo].[atum_InsertStorePetItem] Script Date: 05/05/2014 21:22:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-------------------------------------------------------------
-----관텮 프로?AR?
-- // 2010-06-15 by shcho&hslee Ce?A?sLU - lCRELURE R?Az? A煞? 될 때, Ce 정s링?A煞?되는 Al리를 L置r
--
-- //주R? - dbo.atum_Insert_td_pet로 R?l?기 때a츂? 항상 RE 프로?AR?R쭄? dbo.atum_Insert_td_pet? 생Ls되l???큊.
--
-------------------------------------------------------------
ALTER PROCEDURE [dbo].[atum_InsertStorePetItem] --R??16컇
@accNum INT,
@possess INT,
@ItemStorage TINYINT,
@wear TINYINT,
@CurrentCount INT,

@ItemWindowIndex INT,
@ItemNum INT,
@NumOfEnchants SMALLINT,
@PrefixCodeNum INT,
@SufficCodeNum INT,
@CurrentEndurance FLOAT,
@ColorCode INT,
@UsingTimeStamp INT,
@i_PetIndex INT
AS
DECLARE @PIndex INT, @UniqueNumber BIGINT, @PetEXP FLOAT, @PetExpRatio TINYINT, @Plevel INT, @PELevel INT, @PName VARCHAR(40), @PEName INT, @UWI INT ,@SlotCountSkill TINYINT,@SlotCountSocket TINYINT, @KitLevelHP TINYINT, @KitLevelShield TINYINT, @KitLevelSP TINYINT, @Skillslot4 INT, @Skillslot5 INT, @Skillslot6 INT,
@store_Error INT, @pet_error INT

BEGIN TRAN

INSERT INTO dbo.td_Store(AccountUniqueNumber,Possess,ItemStorage,Wear,CurrentCount,ItemWindowIndex,ItemNum,NumOfEnchants,PrefixCodeNum,SuffixCodeNum,CurrentEndurance,ColorCode,UsingTimeStamp,CreatedTime,ShapeItemNum,MainSvrItemUID,CoolingTime)
VALUES (@accNum, @possess, @ItemStorage, @wear, @CurrentCount, @ItemWindowIndex,
@ItemNum, @NumOfEnchants, @PrefixCodeNum, @SufficCodeNum, @CurrentEndurance, @ColorCode, @UsingTimeStamp, GetDate(), 0, 0, 0);

SET @store_Error = @@ERROR

IF (@store_error <> 0)
BEGIN
ROLLBACK TRAN;
END


EXEC dbo.atum_Insert_td_pet @@IDENTITY ,@i_PetIndex,'',1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
EXEC dbo.atum_Update_PetInfo @@IDENTITY,0, 1,'HV',0,1,0,0,0,0,0,0,0,0,0,0,0,0

SET @pet_error = @@ERROR

IF (@pet_error <> 0)
BEGIN
ROLLBACK TRAN;
END

This is my Insert_td_Pet

ALTER PROC [dbo].[atum_Insert_td_pet] --R??20컇

@i_itemUID BIGINT, --lCRELUUID
@i_PetIndex INT, --Ce R琯?s(1001,1002......)
@i_PetEXP FLOAT,
@i_PetLevel INT, --Ce톋s?
@i_PetName VARCHAR(40), --Ce RE름
@i_ExpRatio TINYINT, --?sL?ElE

@i_EnableSocketCount TINYINT, --CeRE름 sZ캽 ??그. 0RE면 sZ캽?능, 1REsZ sZ캽 sN? 킺C???0
@i_HPKitItemNum INT,
@i_HPKitTriggerValue FLOAT,
@i_ShieldKitItemNum INT,
@i_ShieldKitTriggerValue FLOAT,
@i_SPKitItemNum INT,
@i_SPKitTriggerValue FLOAT,

@i_AutoSkilItem1 INT,
@i_AutoSkilItem2 INT,
@i_AutoSkilItem3 INT,
@i_AutoSkilItem4 INT,
--Ce LN횯 ??롯
@i_AutoSkilItem5 INT,

@i_AutoSkilItem6 INT,
@i_SocketItem1 INT,
@i_SocketItem2 INT,
@i_SocketItem3 INT,
@i_SocketItem4 INT,
@i_SocketItem5 INT,
@i_SocketItem6 INT

AS

BEGIN

INSERT INTO dbo.td_pet(ItemUID,PetIndex, Name, Level, Experience, ExpRatio, EnableSocketCount, HPKitItemNum, HPKitTriggerValue, ShieldKitItemNum,
ShieldKitTriggerValue, SPKitItemNum, SPKitTriggerValue, AutoSkilItemNum1, AutoSkilItemNum2, AutoSkilItemNum3,AutoSkilItemNum4, AutoSkilItemNum5,
AutoSkilItemNum6, SocketItem1, SocketItem2, SocketItem3, SocketItem4, SocketItem5, SocketItem6)
VALUES(@i_itemUID,@i_PetIndex,@i_PetName, @i_PetLevel, @i_PetEXP, @i_ExpRatio, @i_EnableSocketCount, @i_HPKitItemNum, @i_HPKitTriggerValue, @i_ShieldKitItemNum,
@i_ShieldKitTriggerValue, @i_SPKitItemNum, @i_SPKitTriggerValue, @i_AutoSkilItem1, @i_AutoSkilItem2, @i_AutoSkilItem3, @i_AutoSkilItem4,@i_AutoSkilItem5,
@i_AutoSkilItem6, @i_SocketItem1, @i_SocketItem2,@i_SocketItem3, @i_SocketItem4,@i_SocketItem5, @i_SocketItem6)
END

Field server doesnt giive me any error, only that socket client closed Reason[0x000005]

Anyone can help me?

Thank you

[MentaL]

[mKeey]

Take a look at your ACEOnline.atm

[gaby001]

the procedure its ok like mkeey say take a lock at aceonline atm or se if u have the obj in your server and client and loock in res-eff if the obj for pet it there and one more thing go in db at "ti_items" and se at link item and if it the right number there and at source item

[Davidc96]

I test it but the same, I use AceOnline EP4 Client with killburne AceOnline.atm.

This is my td_pet table values:

30188    1000    0    1    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0 

The order is: ItemUID, PetIndex, Name, Level, Experience, ExpRatio, EnableSocketCount, HPKitItemNum, HPKitTriggerValue, ShieldKitItemNum, ShieldKitTriggerValue, SPKitItemNum, SPKitTriggerValue, AutoSkilItemNum[6] and SocketItem[6].

in td_Item: LinkItem = 1000 and SouceIndex = 7030000

in ti_Pet: PetIndex = 1000

And load_td_petinfo

ALTER PROC [dbo].[atum_Load_td_petInfo] --R??1컇
@i_ItemUID BIGINT --item_UID로 C?정s만?로탒?큊.

AS

BEGIN
SELECT ItemUID, PetIndex, Name, Level, Experience, ExpRatio, EnableSocketCount, HPKitItemNum, HPKitTriggerValue,
ShieldKitItemNum, ShieldKitTriggerValue, SPKitItemNum, SPKitTriggerValue, AutoSkilItemNum1, AutoSkilItemNum2, AutoSkilItemNum3,
AutoSkilItemNum4, AutoSkilItemNum5, AutoSkilItemNum6
FROM td_pet WITH (NOLOCK) WHERE ItemUID = @i_ItemUID
END

[WarriorSW]

change itemnum and source index of pet to 7230000 (in ti_Item) - ep 4+ haven't SourceIndex (City&Field of Pet) in DB tables. It just matching it by ItemNum

[Davidc96]

Solved, but it doesn't appeared any Welcome pet Messaged anyway, thanks WarriorSW and all to help me ^^