database limit

[darren]

My sql DB has limited me to 65535, so if I make an NPC the is 70010 it will not let me add that npc. how can i fix this problem?

[scrubs]

i guess by changing the NPC ID to something under 65535..

 

Or use custom_npc table

[darren]

i have custom tables but when i spawn mobs and restart they get deleted. i even changed the config file.

[scrubs]

yeah well, when you use custom npc's, then you gotta add their spawn locations in custom_spawnlist or w/e it's named

[josecarlosfl18]

That you need to do need some core editing and DB editing...

 

1- Alter the table that you want too add NPC

 

2- Find the ID colum and change type of data for one more big, the current type must be Int (integer) change it for Long for example...

Thats problems come because and var type integer can store a max positive value of 65535 (¿¿¿ max enchant support ???), that are tech limit and cannot do something about it...

 

3- For the core editing i cant help you, but, in some words you must do the next...

Every function that read or write data in that DB Table must me edited because procedure will try to store (or read) a Integer data fot that colum and will get a Long type...

 

It's hard but... or make you're own custom table with Long ID field and use that instead a defauld one...

 

Good luck...

[darren]

thx for the info...

[Justice]

thx for the info...

 

I think that your problem solved. If you want anything else just pm me to unlock the topic.