Jump to content

[guide] Database Limit 65535 fix


Recommended Posts

[glow=purple,20,700]Having problem adding that mob to your Database? do you get the error that the npc id has to be 65535 and under? well here is how you fix this.[/glow]

 

[glow=red,2,300]This doesn't have to be edit in core just your tables..[/glow]

 

[glow=maroon,2,300]Step 1:[/glow] [glow=teal,2,300]Open your Navicat.[/glow]

 

[glow=maroon,2,300]Step 2:[/glow] [glow=teal,2,300]Go to the table you have 65535 limit on.[/glow]

 

[glow=maroon,2,300]Step 3:[/glow] [glow=teal,2,300]Right click on the table and go to Design.[/glow]

 

[glow=maroon,2,300]Step 4:[/glow] [glow=teal,2,300]A box will pop up, there you will see rows and colums. Look for the Idtemplate row, once you see this, look under the Type colum.[/glow]

 

[glow=maroon,2,300]Step5:[/glow] [glow=teal,2,300]Change what ever it is to mediumint.[/glow]

 

[glow=maroon,2,300]Step 6:[/glow] [glow=teal,2,300]Save and exit the table.[/glow]

 

[glow=maroon,2,300]Step 7:[/glow] [glow=teal,2,300]Restart your Gameserver.[/glow]

 

[glow=red,2,300]This has been tested on Custom_Npc table only, But I'm sure it will work on any other Table, just has not been tested on any other. also remeber that this will work with other types, exp: npc id.

anyhow good luck and enjoy![/glow]

Link to comment
Share on other sites

this fix is shared on mxc allready ...i say'd it 2 time i think...you should mention this is a fix for the bug when you get the error "blablabla out of range  at colum id" or something similar 2 that on your gs... i had this on my spawnlist table ...

and thx:)

Link to comment
Share on other sites

It is 65535 for a reason, because it is the highest number that can act as an unsigned 16-bit binary number.

 

God knows what errors will approach in the future if you change this value, it is the same reason why Microsoft Excel has 65535 cells (2006 and below (Last time i used excel :P) )

Link to comment
Share on other sites

It is 65535 for a reason, because it is the highest number that can act as an unsigned 16-bit binary number.

 

God knows what errors will approach in the future if you change this value, it is the same reason why Microsoft Excel has 65535 cells (2006 and below (Last time i used excel :P) )

 

 

if you have any exp with navicat, and l2 server, than you would know you have have higher numbers for npc and mobs.

Link to comment
Share on other sites

The database was obviously designed to use 16-bit integers for npc IDs, so that must mean that the core was more than likely designed around this too right?

 

You can change whatever you want in the database but if you didn't change the core too then it won't work in any other table.

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
Reply to this topic...

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

 Share



×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disbaled AdBlock