Duplicate entry mob_skill_db2

[Lyvondria]

Hello,

 

I added a Custom Monster for a Dungeon. Now i need to add some skills to this mob. He casts Assumptio Lvl 5 on herself but he should cast Assumptio on friendly targets as well.

I already added a skill to mob_skill_db2 with this Mob ID: 2506. Now i want to Cast Assumption Lvl 5 on friendly monsters. So i need to add another table for this Mob. But when i import or add it, it says:

 

#1062 - Duplicate entry '2506' for key 'MOB_ID'

 

 

This is my SQL command:

 

INSERT INTO `mob_skill_db2` (`MOB_ID`, `INFO`, `STATE`, `SKILL_ID`, `SKILL_LV`, `RATE`, `CASTTIME`, `DELAY`, `CANCELABLE`, `TARGET`, `CONDITION`, `CONDITION_VALUE`, `VAL1`, `VAL2`, `VAL3`, `VAL4`, `VAL5`, `EMOTION`, `CHAT`) VALUES
(2506, 'Pirate Ghost@HP_ASSUMPTIO', 'idle', 361, 5, 2000, 750, 3000, 'yes', 'friend', 'friendhpltmaxrate', '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

 

 

So if i check the mob_skill_db there are duplicate entrys too. But why isnt it working on mob_skill_db2?

 

Note:

 

I think i changed the mob_skill_db2 somehow or so because i couldnt edit the skills inside there.But now i can edit the skills in mob_skill_db2. On mob_skill_db i cant edit any skills there ...

 

Anyone has an idea to fix this?

Edited February 28, 2014 by Lyvondria

[Kido]

Hmm just a while a go i got some custom mbos too, and i tryied to manually do the whole mob skill thing, really annoying x_x i wish there could be a program/software to do this more easy.

 

Wjat i did was to take the line of the skill of other mobs and paste it with the id of the custom mob and it worked pretty good, i recommend you for that case, take the mob skill db of the mvp malgaleta sorin of biolab 3

 

give a try, it should work like me o:

[Lyvondria]

I found a solution for that. Just add a new entry AUTO INC. It works fine now.

[Kido]

cool o: glad to know that it works now o:

also, may i ask how o:!