Table Missing IDs?

07/17/2025 05:00 furyovisk#1

Hello, I was trying to change InventorySize value for the pets to have a 2nd page but ended up noticing a weird thing in my database.

In the table _RefObjCommon ID values go up to 41797
But in the table _RefObjChar it stops at ID 18890

Shouldn't it be 41797 too?

I was trying to change the Cat COS InventorySize value in _RefObjChar but since its ID is 23309 I noticed that.

Why my _RefObjChar table is missing all those IDs?

07/19/2025 21:46 Worshiper#2

Are you talking about Grap pet inventory?

07/20/2025 23:00 Devsome#3

#moved

07/21/2025 22:56 Kabloz�#4

Code:

SELECT * FROM dbo._RefObjChar WHERE id IN ( SELECT Link FROM dbo._RefObjCommon WHERE CodeName128 LIKE 'COS CODENAME HERE')

This query can help you.

The best way to make the COS InventorySize is to set it to 140.

If you want to fix missing IDs, follow these steps:

1. Go to the RefObjChar table.
2. Right-click on the ID column.
3. Choose Set Primary Key.
4. Save and close the table.
5. Reopen the table and that's it.

10/16/2025 03:46 McQueen.95#5

_RefObjChar is connect with column name " Link " into Refobjcommn Table not ID