How to Delete all pet's From Game with out that Error

[mag]

Welcome RZ Brother's
i want to Delete all pet's from Game
when i Clean TimeDjopForpet/CharCos/InvCos
then open my Server and Press Start on Char i Get Confirm

[MentaL]

[mag]

Any idea

[RenePunik]

Screen or more detail to help you!

[NadaZayed]

Just Disable them ..

[InPanic Kev]

You need to delete all :

From _Items
With this Query you can see all Pick Pets from the Server

SELECT ID64 , RefItemID , CodeName128 , Data FROM _Items as i
left join _RefObjCommon as roc on roc.ID = i.RefItemID
where TypeID1 = 3 and TypeID2 = 2 and TypeID3 = 1 and TypeID4 = 2

With this Query you can check all Pet Inventory

-- Pet Inventar 
select COSID , Slot , ItemID , CodeName128 , OptLevel from _InvCOS as inv
left join _Items as I on I.ID64 = INV.ItemID
left join _RefObjCommon as roc on roc.ID = I.RefItemID
order by COSID,Slot DESC

also you need to set the ItemID from all Pets to 0 [ _Inventory / GuildStorage / and and and ] and delete all the Pet Timed Jobs

its rly easy if you know MSSQL ;)

#edit ::::

with this query you can see all Pets from Players (inventory)

SELECT CharID , Slot , ItemID , CodeName128 FROM _Inventory as inv
left join _Items as i on i.ID64 = inv.ItemID
left join _RefObjCommon as roc on roc.ID = i.RefItemID
where TypeID1 = 3 and TypeID2 = 2 and TypeID3 = 1 and TypeID4 = 2

if u wanna delete all Pets from the Player Inventory [use this query]

-- Set all Pick Pets from the Player Inventory to 0 ( del )
Update _Inventory 
set ItemID = 0
from _Inventory as inv
left join _Items as i on i.ID64 = inv.ItemID
left join _RefObjCommon as roc on roc.ID = i.RefItemID
where TypeID1 = 3 and TypeID2 = 2 and TypeID3 = 1 and TypeID4 = 2

you need the same for GuildStorage and AccountStorage ....