Jump to content
  • 0

Weird ID in inventory table.


MegaByte

Question


  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   1
  • Joined:  11/12/14
  • Last Seen:  

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.

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.00
  • Content Count:  171
  • Reputation:   15
  • Joined:  01/26/12
  • Last Seen:  

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 by sikiro
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   1
  • Joined:  11/12/14
  • Last Seen:  

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.

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...