Jump to content
  • 0

char_id sql weird data


iZeal

Question


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  55
  • Reputation:   2
  • Joined:  06/09/14
  • Last Seen:  

Hello I just notice something weird about my db when i checked the char_id column I notice the start of the value was "1" instead of "150000".. attached is a screen shot..

post-26609-0-48753700-1407677857_thumb.png

 

Link to comment
Share on other sites

6 answers to this question

Recommended Posts


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2348
  • Joined:  10/28/11
  • Last Seen:  

maybe you accidently changee the auto_increment value ??

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  55
  • Reputation:   2
  • Joined:  06/09/14
  • Last Seen:  

never touch anything with the structure :/ anyway to fix this? I'm not sure if it will also affect the new one's 

Edited by iZeal
Link to comment
Share on other sites


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2348
  • Joined:  10/28/11
  • Last Seen:  

ALTER TABLE `char` AUTO_INCREMENT = 150000;

probably the Control Panel that you using changed the original value of 150000.

 

ops..it's char..

somewhere in source defined the default starting value..forget which file...kinda lazy to search..xD

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  55
  • Reputation:   2
  • Joined:  06/09/14
  • Last Seen:  

can you help me where to find that?

hmm what about the previous data?

Edited by iZeal
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  36
  • Reputation:   5
  • Joined:  02/01/12
  • Last Seen:  

As I can remember, there's nothing bad to start char_id from "1".

Do you really need to start them from "150000"? You can't just change it for existing data without any kind of self-writed parser, which would change char_id for every character on every gameDB table.

 

2BfB97X.png

Edited by CandyCandy
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  55
  • Reputation:   2
  • Joined:  06/09/14
  • Last Seen:  

hmm really nothing good bad to happen., it's just that i'm not use to it :(

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...