Hello Everyone

I have a problem when i install this gmshop: http://www.maxcheaters.com/forum/index.php?topic=183063.0

when i spawn the npc ingame i get critical error and i cant login(cause i get critical errors all the time) until delete the custom npc from my database.i instal sql.sql to navicat 8 and i put gameserver folder into my server folder the only problem i got was with spawnlist.sql when i tried to install it i get this error:[Err] 1264 - Out of range value for column 'id' at row 1. When i tried to put one manually i get an error too: 96949 is not a valid value for field id.The allowed range is 0 to 65535.Anyway i skiped this step.What i did wrong and what i am gona do to fix it? Plz help me!!!!! I use L2JServer - Rev 7669

get an error too: 96949 is not a valid value for field id.The allowed range is 0 to 65535

 

Read it once again, and think a bit.

 

96949 > 65535

 

Conclusion?

ok that's not my problem anyway. the spownlist.sql that included in npc file is in that way and just i wonder why is it while is wrong

I gave you sollution already.

I gave you sollution already.

 

 

i have already change the value to inrange number this action didn't change anything

right click in navicat on  spawnlist table and click design table change the id type to big int and the length to ....10 ore whatever (not to big...)

A new id will fix your problem also you can do it manually.

i try everything you say nothing yet i get critical error when i spawn npc in game.I want to add that when instal the sql.sql file in navicat i get this error too:[Err] 1054 - Unknown column 'armor' in 'field list' i fix that changing the file and then i got this error [Err] 1136 - Column count doesn't match value count at row 1 i fix that deleting 2 values can be this my problem?

 

original sql.sql:INSERT INTO custom_npc

  (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `enchant`, `walkspd`, `runspd`, `isUndead`, `dropHerbGroup`, `basestats`)

VALUES

  (10002, 10, 'NPC GM Shop', 1, 'NPC GM Shop', 1, 'LineageMonster.wererat_01te', 14.00, 25.00, 35, 'male', 'L2Merchant', 40, 773, 366, 7.11, 1.84, 40, 43, 30, 21, 20, 20, 2470, 145, 159, 170, 111, 113, 230, 500, 333, 0, 0, 0, 0, 80, 120, 0, 1, 1);

changed sql.sql: INSERT INTO custom_npc VALUES(10002, 10, 'NPC GM Shop', 1, 'NPC GM Shop', 1, 'LineageMonster.wererat_01te', 14.00, 25.00, 35, 'male', 'L2Merchant', 40, 773, 366, 7.11, 1.84, 40, 43, 30, 21, 20, 20, 2470, 145, 159, 170, 111, 113, 230, 500, 333, 0, 0, 0, 0, 80, 1, 1);

 

Look Man...! Just try to put the SQL alone...! Put id 50000 and it will be OK i Think...

Look Man...! Just try to put the SQL alone...! Put id 50000 and it will be OK i Think...

What you mean? To change npc id to navicat?