[help]installing gm shop Freya

[panionara13]

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

[Matim]

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?

[panionara13]

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

[Matim]

I gave you sollution already.

[panionara13]

I gave you sollution already.

 

 

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

[Hardstyle]

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

[Kяaσh]

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

[panionara13]

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);

 

[`NeverMore]

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

[panionara13]

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?