RealspeedVIP Posted January 28, 2016 Posted January 28, 2016 Im looking for Skill Enchanter NPC for L2jFrozen .. i tryed 2-3 npc's but when i install in mysql ( skill learn.sql ) all my custom npc's in custom_npcs table are deleted ... any suggestions?
0 Rootware Posted January 28, 2016 Posted January 28, 2016 Vanga before his death for admin said that: "A code like DROP IF EXISTS in the firts line in SQL queries can delete something what you don't want." :troll:
0 RealspeedVIP Posted January 28, 2016 Author Posted January 28, 2016 Fix the query? Add it by hand? yes i try to add by hand and i get this error : WARN NPCTable: Error defining learning data for NPC 12621: specified classId 131 is higher then max one 118 specified into ClassID Enum --> check your Database to be complient with it.
0 RealspeedVIP Posted January 28, 2016 Author Posted January 28, 2016 this is the sql to npc INSERT INTO npc VALUES ('20703', '25284', 'Diana', '1', 'Enchanter Skill', '1', 'Monster.zaken', '9.00', '34.00', '60', 'female', 'L2Merchant', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '28', '132', '', '0', '0', '0', 'LAST_HIT'); this is the skill learn.sql INSERT INTO `skill_learn` VALUES ('20703', '0'); INSERT INTO `skill_learn` VALUES ('20703', '1'); INSERT INTO `skill_learn` VALUES ('20703', '2'); INSERT INTO `skill_learn` VALUES ('20703', '3'); INSERT INTO `skill_learn` VALUES ('20703', '4'); INSERT INTO `skill_learn` VALUES ('20703', '5'); INSERT INTO `skill_learn` VALUES ('20703', '6'); INSERT INTO `skill_learn` VALUES ('20703', '7'); INSERT INTO `skill_learn` VALUES ('20703', '8'); INSERT INTO `skill_learn` VALUES ('20703', '9'); INSERT INTO `skill_learn` VALUES ('20703', '10'); INSERT INTO `skill_learn` VALUES ('20703', '11'); INSERT INTO `skill_learn` VALUES ('20703', '12'); INSERT INTO `skill_learn` VALUES ('20703', '13'); INSERT INTO `skill_learn` VALUES ('20703', '14'); INSERT INTO `skill_learn` VALUES ('20703', '15'); INSERT INTO `skill_learn` VALUES ('20703', '16'); INSERT INTO `skill_learn` VALUES ('20703', '17'); INSERT INTO `skill_learn` VALUES ('20703', '18'); INSERT INTO `skill_learn` VALUES ('20703', '19'); INSERT INTO `skill_learn` VALUES ('20703', '20'); INSERT INTO `skill_learn` VALUES ('20703', '21'); INSERT INTO `skill_learn` VALUES ('20703', '22'); INSERT INTO `skill_learn` VALUES ('20703', '23'); INSERT INTO `skill_learn` VALUES ('20703', '24'); INSERT INTO `skill_learn` VALUES ('20703', '25'); INSERT INTO `skill_learn` VALUES ('20703', '26'); INSERT INTO `skill_learn` VALUES ('20703', '27'); INSERT INTO `skill_learn` VALUES ('20703', '28'); INSERT INTO `skill_learn` VALUES ('20703', '29'); INSERT INTO `skill_learn` VALUES ('20703', '30'); INSERT INTO `skill_learn` VALUES ('20703', '31'); INSERT INTO `skill_learn` VALUES ('20703', '32'); INSERT INTO `skill_learn` VALUES ('20703', '33'); INSERT INTO `skill_learn` VALUES ('20703', '34'); INSERT INTO `skill_learn` VALUES ('20703', '35'); INSERT INTO `skill_learn` VALUES ('20703', '36'); INSERT INTO `skill_learn` VALUES ('20703', '37'); INSERT INTO `skill_learn` VALUES ('20703', '38'); INSERT INTO `skill_learn` VALUES ('20703', '39'); INSERT INTO `skill_learn` VALUES ('20703', '40'); INSERT INTO `skill_learn` VALUES ('20703', '41'); INSERT INTO `skill_learn` VALUES ('20703', '42'); INSERT INTO `skill_learn` VALUES ('20703', '43'); INSERT INTO `skill_learn` VALUES ('20703', '44'); INSERT INTO `skill_learn` VALUES ('20703', '45'); INSERT INTO `skill_learn` VALUES ('20703', '46'); INSERT INTO `skill_learn` VALUES ('20703', '47'); INSERT INTO `skill_learn` VALUES ('20703', '48'); INSERT INTO `skill_learn` VALUES ('20703', '49'); INSERT INTO `skill_learn` VALUES ('20703', '50'); INSERT INTO `skill_learn` VALUES ('20703', '51'); INSERT INTO `skill_learn` VALUES ('20703', '52'); INSERT INTO `skill_learn` VALUES ('20703', '53'); INSERT INTO `skill_learn` VALUES ('20703', '54'); INSERT INTO `skill_learn` VALUES ('20703', '55'); INSERT INTO `skill_learn` VALUES ('20703', '56'); INSERT INTO `skill_learn` VALUES ('20703', '57'); INSERT INTO `skill_learn` VALUES ('20703', '58'); INSERT INTO `skill_learn` VALUES ('20703', '59'); INSERT INTO `skill_learn` VALUES ('20703', '60'); INSERT INTO `skill_learn` VALUES ('20703', '61'); INSERT INTO `skill_learn` VALUES ('20703', '62'); INSERT INTO `skill_learn` VALUES ('20703', '63'); INSERT INTO `skill_learn` VALUES ('20703', '64'); INSERT INTO `skill_learn` VALUES ('20703', '65'); INSERT INTO `skill_learn` VALUES ('20703', '66'); INSERT INTO `skill_learn` VALUES ('20703', '67'); INSERT INTO `skill_learn` VALUES ('20703', '68'); INSERT INTO `skill_learn` VALUES ('20703', '69'); INSERT INTO `skill_learn` VALUES ('20703', '70'); INSERT INTO `skill_learn` VALUES ('20703', '71'); INSERT INTO `skill_learn` VALUES ('20703', '72'); INSERT INTO `skill_learn` VALUES ('20703', '73'); INSERT INTO `skill_learn` VALUES ('20703', '74'); INSERT INTO `skill_learn` VALUES ('20703', '75'); INSERT INTO `skill_learn` VALUES ('20703', '76'); INSERT INTO `skill_learn` VALUES ('20703', '77'); INSERT INTO `skill_learn` VALUES ('20703', '78'); INSERT INTO `skill_learn` VALUES ('20703', '79'); INSERT INTO `skill_learn` VALUES ('20703', '80'); INSERT INTO `skill_learn` VALUES ('20703', '81'); INSERT INTO `skill_learn` VALUES ('20703', '82'); INSERT INTO `skill_learn` VALUES ('20703', '83'); INSERT INTO `skill_learn` VALUES ('20703', '84'); INSERT INTO `skill_learn` VALUES ('20703', '85'); INSERT INTO `skill_learn` VALUES ('20703', '86'); INSERT INTO `skill_learn` VALUES ('20703', '87'); INSERT INTO `skill_learn` VALUES ('20703', '88'); INSERT INTO `skill_learn` VALUES ('20703', '89'); INSERT INTO `skill_learn` VALUES ('20703', '90'); INSERT INTO `skill_learn` VALUES ('20703', '91'); INSERT INTO `skill_learn` VALUES ('20703', '92'); INSERT INTO `skill_learn` VALUES ('20703', '93'); INSERT INTO `skill_learn` VALUES ('20703', '94'); INSERT INTO `skill_learn` VALUES ('20703', '95'); INSERT INTO `skill_learn` VALUES ('20703', '96'); INSERT INTO `skill_learn` VALUES ('20703', '97'); INSERT INTO `skill_learn` VALUES ('20703', '98'); INSERT INTO `skill_learn` VALUES ('20703', '99'); INSERT INTO `skill_learn` VALUES ('20703', '100'); INSERT INTO `skill_learn` VALUES ('20703', '101'); INSERT INTO `skill_learn` VALUES ('20703', '102'); INSERT INTO `skill_learn` VALUES ('20703', '103'); INSERT INTO `skill_learn` VALUES ('20703', '104'); INSERT INTO `skill_learn` VALUES ('20703', '105'); INSERT INTO `skill_learn` VALUES ('20703', '106'); INSERT INTO `skill_learn` VALUES ('20703', '107'); INSERT INTO `skill_learn` VALUES ('20703', '108'); INSERT INTO `skill_learn` VALUES ('20703', '109'); INSERT INTO `skill_learn` VALUES ('20703', '110'); INSERT INTO `skill_learn` VALUES ('20703', '111'); INSERT INTO `skill_learn` VALUES ('20703', '112'); INSERT INTO `skill_learn` VALUES ('20703', '113'); INSERT INTO `skill_learn` VALUES ('20703', '114'); INSERT INTO `skill_learn` VALUES ('20703', '115'); INSERT INTO `skill_learn` VALUES ('20703', '116'); INSERT INTO `skill_learn` VALUES ('20703', '117'); INSERT INTO `skill_learn` VALUES ('20703', '118'); INSERT INTO `skill_learn` VALUES ('20703', '119'); INSERT INTO `skill_learn` VALUES ('20703', '120'); INSERT INTO `skill_learn` VALUES ('20703', '121'); INSERT INTO `skill_learn` VALUES ('20703', '122'); INSERT INTO `skill_learn` VALUES ('20703', '123'); INSERT INTO `skill_learn` VALUES ('20703', '124'); INSERT INTO `skill_learn` VALUES ('20703', '125'); INSERT INTO `skill_learn` VALUES ('20703', '126'); INSERT INTO `skill_learn` VALUES ('20703', '127'); INSERT INTO `skill_learn` VALUES ('20703', '128'); INSERT INTO `skill_learn` VALUES ('20703', '129'); INSERT INTO `skill_learn` VALUES ('20703', '130'); INSERT INTO `skill_learn` VALUES ('20703', '131'); INSERT INTO `skill_learn` VALUES ('20703', '132'); INSERT INTO `skill_learn` VALUES ('20703', '133'); INSERT INTO `skill_learn` VALUES ('20703', '134'); INSERT INTO `skill_learn` VALUES ('20703', '135'); INSERT INTO `skill_learn` VALUES ('20703', '136');
0 SweeTs Posted January 28, 2016 Posted January 28, 2016 (edited) Read the error and turn on your brain :3 "specified classId 131 is higher then max one 118". Also why you bother? Frozen has a skill enchanter by default, so.. Edited January 28, 2016 by SweeTs
0 LightWarden Posted January 28, 2016 Posted January 28, 2016 And here is a future l2j server admin wanna be who will open his server after he finish it with maxcheaters forum help, good, keep it like this and l2 topsites will be 95% crap servers, this is why l2 players had lost thier interest to play lineage2
0 RealspeedVIP Posted January 28, 2016 Author Posted January 28, 2016 And here is a future l2j server admin wanna be who will open his server after he finish it with maxcheaters forum help, good, keep it like this and l2 topsites will be 95% crap servers, this is why l2 players had lost thier interest to play lineage2 No one was born learned. I dont get why you spam here in this topic, and yea it have some crap servers in the topsites but why you think my server will be crap? SweeTs you can lock the topic.
0 LightWarden Posted January 28, 2016 Posted January 28, 2016 (edited) No one was born learned. I dont get why you spam here in this topic, and yea it have some crap servers in the topsites but why you think my server will be crap? SweeTs you can lock the topic. no offense for greeks, but this photo say everything, can be any nation... Edited January 28, 2016 by LightWarden
0 Devlin Posted January 28, 2016 Posted January 28, 2016 no offense for greeks, but this photo say everything, can be any nation... You say a lot for Greeks. Who you think you are? You are newbie too like all these guys. If you are so smart, stop posting about Greeks and for non-knowledge guys and help them smartass.
0 LightWarden Posted January 28, 2016 Posted January 28, 2016 (edited) You say a lot for Greeks. Who you think you are? You are newbie too like all these guys. If you are so smart, stop posting about Greeks and for non-knowledge guys and help them smartass. Sorry Devlin, but read there the photo have nothing to do with greeks, i was only lazy to remove flags.... thats all, as i said, can be any nation I am not racist or something O0 I also have best virtual friends form GR, so... don't be mad on me ;) Edited January 28, 2016 by LightWarden
0 Devlin Posted January 28, 2016 Posted January 28, 2016 Sorry Devlin, but read there the photo have nothing to do with greeks, i was only lazy to remove flags.... thats all, as i said, can be any nation I am not racist or something O0 I also have best virtual friends form GR, so... don't be mad on me ;) It's not only about Greeks. You pretent the smartass all the time, prove first that you are so smart as you say and then talk please.
0 LightWarden Posted January 28, 2016 Posted January 28, 2016 It's not only about Greeks. You pretent the smartass all the time, prove first that you are so smart as you say and then talk please. Okey Devlin, what you want me to prove you? Just say something, i don't know, whatever
0 Devlin Posted January 28, 2016 Posted January 28, 2016 Okey Devlin, what you want me to prove you? Just say something, i don't know, whatever Solve this guy's problem with no further talk.
0 LightWarden Posted January 28, 2016 Posted January 28, 2016 Solve this guy's problem with no further talk. There is nothing to solve, what you want me to do? add it via teamviwer? l2jfrozen have this npc by default as sweets said
0 RealspeedVIP Posted January 28, 2016 Author Posted January 28, 2016 There is nothing to solve, what you want me to do? add it via teamviwer? l2jfrozen have this npc by default as sweets said and i say i dont have that npc in my pack .. however i will use the default npc's.
Question
RealspeedVIP
Im looking for Skill Enchanter NPC for L2jFrozen .. i tryed 2-3 npc's but when i install in mysql ( skill learn.sql ) all my custom npc's in custom_npcs table are deleted ... any suggestions?
17 answers to this question
Recommended Posts