Weird ID in inventory table.

[MegaByte]

Hey, weird char_id such as 150001 showing up in inventory and picklog.

SELECT * FROM inventory WHERE char_id NOT IN (SELECT char_id FROM `char`)

Just wondering what those are is it some special kind of identifier?

 

Thanks.

[sikiro]

login id and char id are diferent from each other. so for example an account id starts at 200000 while a character id starts at 150000.  so the server identifies both differently   anytime one of your player makes an account it will use a accound id starting with 20XXXX while every chracter made is 15xxxx  it makes it easy to manage character logs and such.

Edited April 3, 2017 by sikiro

[MegaByte]

Aye. but the only char_id's I have are 1 to 20.
The account_id's are from 200000 though.

I did do a truncate on the char table, could be why but I would have expected that to reset the auto increment column char_id.

In hind site maybe it is possible that I neglected to turn off the server during the truncate on those tables and it delay saved stuff from old characters I was testing with that I thought were logged off :S
Still odd that the records are "orphaned" but I guess that is by design since MyISAM does not support foreign keys~

Thanks for the explanation though sikiro.
I guess it should be safe to delete the erroneous records.