[release]140 pet inventory expand

Printable View

Show 100 post(s) from this thread on one page

27-12-11
chichi

[release]140 pet inventory expand

find pet that u want to expand from _refobjcommon.
change column of inventery to 140
then change chardataXXX of media.pk2 to 140
then modify store_procedure _addnewCOS
right click ,execute
u can find your pet has 140 inventory.

sorry for my poor English .
hope can help some one.

_addnewCOS is below .

PHP Code:

USE [SRO_VT_SHARD_INIT] GO /****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 12/29/2011 12:41:21 ******/ 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 -- à?o￥???? ?y?o ???D! rollback tran return -2 end set @Slot = @Slot + 1 end end /* --′? àì?ó àì ??·3??′? μ￥àì?í?| 3?á? ?ê′?′ù! 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 exec _ADDTIMEDJOBFORPET @COS_ID,5,22926,1590084174,1111708465,1,112,0,0,0,0,0,72339069016407748 end commit tran return @COS_ID
27-12-11
egsro

Re: [release]140 pet inventory expand

would be greet if you told us which column should we modify in _refobjcommon
28-12-11
chichi

Re: [release]140 pet inventory expand

end of _refobjcommon is column 'link'
then look for 'InventorySize' from _refchar
notice:_refchar id = link ,

help helpful to u .
28-12-11
saxz

Re: [release]140 pet inventory expand

this will make all the grap pets have 140 slots?

not working....
28-12-11
chichi

Re: [release]140 pet inventory expand

every pet has the data inventorysize
u should change one by one,u may also use sql querry.
i have tested this,and successful.

right click the store_proceed,and exeute .
28-12-11
saxz

Re: [release]140 pet inventory expand

i told you not working lol
i already tested this
28-12-11
chichi

Re: [release]140 pet inventory expand

is there store_procedure _ADDTIMEDJOBFORPET ?
if not,add it .
28-12-11
kid1110

Re: [release]140 pet inventory expand

Quote:

Originally Posted by chichi

find pet that u want to expand from _refobjcommon.
change column of inventery to 140
then change chardataXXX of media.pk2 to 140
then modify store_procedure _addnewCOS
right click ,execute
u can find your pet has 140 inventory.

sorry for my poor English .
hope can help some one.

_addnewCOS is below.

Good job. Done.

Thanks.
28-12-11
egsro

Re: [release]140 pet inventory expand

ITEM_COS_P_CAT_SCROLL
Link = 10498 ?!

how to change it to 140 slots xD
28-12-11
kid1110

Re: [release]140 pet inventory expand

Quote:

Originally Posted by egsro

ITEM_COS_P_CAT_SCROLL
Link = 10498 ?!

how to change it to 140 slots xD

Step 1: Find ID Pet in _RefObjCommon (Don't need link).
- Ex: 9264
- Modify 'InventorySize' in _RefObjChar of ID 9264.

Step 2: Edit file characterdata_10000.txt
- Ex:

Code:

1 9264 COS_P_SEOWON 서원 xxx SN_COS_P_SEOWON xxx 0 1 1 2 3 4 5000 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 3 0 0 0 0 0 50 120 45 0 4 0 cos\p_seowon.bsr xxx cos\cos_p_seowon.ddj xxx xxx 1 0 109 0 140 0 0 0 0 0 1 0 0 0 7 10 1 1 27 0 27 2 0 1679057940 3 3000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

- Complete look like:

Code:

1 9264 COS_P_SEOWON 서원 xxx SN_COS_P_SEOWON xxx 0 1 1 2 3 4 5000 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 3 0 0 0 0 0 50 120 45 0 4 0 cos\p_seowon.bsr xxx cos\cos_p_seowon.ddj xxx xxx 1 0 109 0 140 0 0 0 0 0 1 0 0 0 7 10 1 1 27 0 27 2 0 1679057940 3 3000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Step 3: Modify SRO_VT_SHARD \ Programmability \ Stored Procedures \dbo._AdNewCOS
- Add:

Code:

exec _ADDTIMEDJOBFORPET @COS_ID,5,22926,1590084174,1111708465,1,112,0,0,0,0,0,72339069016407748

- Beforce:

Code:

end commit tran return @COS_ID

- Execute.

Step 4: Import characterdata_10000.txt to media.pk2.

Done.
28-12-11
susii

Re: [release]140 pet inventory expand

Quote:

Originally Posted by kid1110

Step 1: Find ID Pet in _RefObjCommon (Don't need link).
- Ex: 9264
- Modify 'InventorySize' in _RefChar of ID 9264.

Step 2: Edit file characterdata_10000.txt
- Ex:

Code:

1 9264 COS_P_SEOWON 서원 xxx SN_COS_P_SEOWON xxx 0 1 1 2 3 4 5000 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 3 0 0 0 0 0 50 120 45 0 4 0 cos\p_seowon.bsr xxx cos\cos_p_seowon.ddj xxx xxx 1 0 109 0 140 0 0 0 0 0 1 0 0 0 7 10 1 1 27 0 27 2 0 1679057940 3 3000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

- Complete look like:

Code:

1 9264 COS_P_SEOWON 서원 xxx SN_COS_P_SEOWON xxx 0 1 1 2 3 4 5000 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 3 0 0 0 0 0 50 120 45 0 4 0 cos\p_seowon.bsr xxx cos\cos_p_seowon.ddj xxx xxx 1 0 109 0 140 0 0 0 0 0 1 0 0 0 7 10 1 1 27 0 27 2 0 1679057940 3 3000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Step 3: Import characterdata_10000.txt to media.pk2.

Done.

_RefChar doesn't exist. Did you mean _RefObjChar ?
28-12-11
kid1110

Re: [release]140 pet inventory expand

Sorry, wrong write.

_RefObjChar is true.

http://i44.servimg.com/u/f44/12/84/69/39/sro20124.jpg
28-12-11
susii

Re: [release]140 pet inventory expand

Thanks.. It's working correctly..
29-12-11
egsro

Re: [release]140 pet inventory expand

Quote:

Originally Posted by kid1110

Sorry, wrong write.

_RefObjChar is true.

http://i44.servimg.com/u/f44/12/84/69/39/sro20124.jpg

how to spawn 2x grap pets xD or 2x attack pet !

thx alot for your simple guild :)
29-12-11
adelnaim

Re: [release]140 pet inventory expand

Quote:

Originally Posted by egsro

how to spawn 2x grap pets xD or 2x attack pet !

thx alot for your simple guild :)

hi can u upload Ur media.pk2 if u can Ty :thumbup:

Quote:

Originally Posted by kid1110

Sorry, wrong write.

_RefObjChar is true.

http://i44.servimg.com/u/f44/12/84/69/39/sro20124.jpg

hi can u upload Ur media.pk2 if u can Ty....

Show 100 post(s) from this thread on one page