[Question] how to change max inventory pet size in _RefObjChar ?
Discussion on [Question] how to change max inventory pet size in _RefObjChar ? within the SRO Private Server forum part of the Silkroad Online category.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_COS_Exceptions](
[ID] [int] NOT NULL,
CONSTRAINT [PK__COS_Exceptions] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
(COS_% ids for default grab pets, you can add additional ones here if you have custom made)
Go to SRO_VT_SHARD > Programmability > Stored Procedures > _AddNewCOS > Right Click and Modify.
At the end, before "commit tran" add this
if ((SELECT COUNT(*) FROM _COS_Exceptions with (NOLOCK) where ID=@RefObjID) <> 0)
BEGIN
declare @64 bigint
DECLARE @ int
set @= DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) --get curent timestamp
set @ @+28*24*440000
select @64 = Serial64 from _Items where Data = @_ID
IF(NOT EXISTS(SELECT * FROM _TimedJobForPet WHERE CharID = @_ID))
BEGIN
exec _AddTimedJobForPet @_ID,5,22926 @,1111708465,1,28,0,0,0,0,0 @64
END
end
enD
To modify the amount of slots there is a "28" on the "exec _AddTimedJobForPet..." line, you can edit it there. Just multiplay pages * slotsPerPage and use that number. That should be all.
Thank you for the quick response!
I could manage to unlock 7 pages, however as soon as I place an item on the 6th or 7th page I get a disconnect followed by:
I could manage to unlock 7 pages, however as soon as I place an item on the 6th or 7th page I get a disconnect followed by:
I really don't have the ability to test it right now myself, but the procedure seems to fail when placing the item. I'd assume the _InvCOS table is missing the lines for these slots. The _AddNewCOS procedure, takes the InventorySize from _RefObjChar, so try to increase that for each grab pet to 7 pages value and spawn a new pet, to build new data for _InvCOS and try again.
I really don't have the ability to test it right now myself, but the procedure seems to fail when placing the item. I'd assume the _InvCOS table is missing the lines for these slots. The _AddNewCOS procedure, takes the InventorySize from _RefObjChar, so try to increase that for each grab pet to 7 pages value and spawn a new pet, to build new data for _InvCOS and try again.
It makes sense, however:
The default InventorySize of grab pets in _RefObjChar is 140 (5 pages).
Increasing that to 196 (7 pages) crashes the GS upon loading the module.
If I manually add lines in _InvCOS then it works:
It seems like the lines are created automatically up to '139'
The default InventorySize of grab pets in _RefObjChar is 140 (5 pages).
Increasing that to 196 (7 pages) crashes the GS upon loading the module.
If I manually add lines in _InvCOS then it works:
It seems like the lines are created automatically up to '139'
Likely there is a check somewhere in the gameserver for it, but if what you did works.. you can just edit the _AddNewCOS procedure, inside the loop replace "< char.InventorySize" with the max amount of slots and it should do the job.
Likely there is a check somewhere in the gameserver for it, but if what you did works.. you can just edit the _AddNewCOS procedure, inside the loop replace "< char.InventorySize" with the max amount of slots and it should do the job.
Doing that allowed me to store the items in the 6th/7th tab, however upon re-logging the GS crashes.
Unfortunately that does not work...I think I'll just give up
[Selling] BM [EU] 1240+ HM16 Max Soul Max Pet Max VT Aransu Weapon Max Gear Fire 01/05/2018 - Blade & Soul Trading - 1 Replies Hi i am Selling my BM on the EU Server
He is HM 16 1240 AP + Full Fire Build + Fire Gear Max
Aransu Weapon with 5 Octagonal Gems and 3 Hepta Fire Gems to Upgrade in Octagonal when the Update comes.
The Account has over 400 Customs and 9 Legy Pet Skins many Mats and
Is Pemium Rank 10 with 200 Days Premium
The Character has 10 Charakter Slots free and 1 lvl 50er voucher code.
The Character is a Very Beautiful Yun so i Think you dont Need a new character Optimization.
The Character is...
[SIZE="6"][/SIZE]Wichtig an alle die gepowerlvlt werden möchten !![/SIZE] 08/21/2011 - WarRock - 2 Replies habe einige Powerlvl service auf e-pvp getestet und auch einiges an geld gezahlt. Doch passt auf sie ziehen euch bloß das geld ab und verschwinden dan :(. Ich dachte wenigstens auf e-pvp wird macn nicht abgezogen aber kann man ja nix machen.
mfg damdam9