Jump to content
MaxCheaters Official Group on Discord
-> Place your ad text here <-
We're Rebuilding – Join Our Staff Team
  • 0

Skill Enchanter For L2Jfrozen

RealspeedVIP

Asked by RealspeedVIP,

 Share

Question

RealspeedVIP Newbie

RealspeedVIP

Posted
Posted

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

  • 0
RealspeedVIP Newbie

RealspeedVIP

Posted
  • Author
Posted

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 Newbie

RealspeedVIP

Posted
  • Author
Posted

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 Rookie

SweeTs

Posted
Posted (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 by SweeTs
  • 0
LightWarden Newbie

LightWarden

Posted
Posted

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 Newbie

RealspeedVIP

Posted
  • Author
Posted

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 Newbie

LightWarden

Posted
Posted (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.

QkPYHp8.png

 

no offense for greeks, but this photo say everything, can be any nation...

Edited by LightWarden
  • 0
Devlin Newbie

Devlin

Posted
Posted

QkPYHp8.png

 

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 Newbie

LightWarden

Posted
Posted (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 by LightWarden
  • 0
Devlin Newbie

Devlin

Posted
Posted

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 Newbie

LightWarden

Posted
Posted

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 Newbie

Devlin

Posted
Posted

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
RealspeedVIP Newbie

RealspeedVIP

Posted
  • Author
Posted

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.

Guest
This topic is now closed to further replies.
 Share
Go to question listing


  • Posts

    • Poziomeczka
      L2Kings

      By Poziomeczka · Posted

      L2 Kings    Stage 1 – The Awakening Dynasty and Moirai Level Cap: 83 Gear: Dynasty -Moirai & Weapons (Shop for Adena + Drop from mobs/instances ) Masterwork System: Available (Neolithics S required with neolithics u can do armor parts foundation aswell) Class Cloaks: Level 1 - Masterwork sets such us moirai/dynasty stats are boosted also vesper(stage 2) Olf T-Shirt: +6 (fails don’t reset) safe is +2 Dolls: Level 1 Belts: Low & Medium Enchant: Safe +3 / Max +8 / Attribution Easy in Moirai-Dynasty . Main Zones: Varka Outpost: Easy farm, Adena, EXP for new players = > 80- 100kk hour Dragon Valley: Main farm zone — , 100–120kk/hour Weapon Weakness System active (all classes can farm efficiently) Archers get vampiric auto-hits vs mobs Dragon Valley Center: Main Party Zone — boosted drops (Blessed enchants, Neolithics chance) => farm like 150-200kk per hour. Dragon Valley North: Spoil Zone (Asofe + crafting materials for MW) Primeval Isle: Safe autofarm zone (low adena for casual players) ==> 50kk per hour Forge of the Gods & Imperial Tomb: Available from Stage 1 (lower Adena reward in compare with Dragon Valley) Hellbound also avaliable from stage 1 In few words all zones opened but MAIN farm zone with boosted adena and drops is Dragon valley also has more mobs Instances: Zaken (24h Reuse) → Instead of Vespers drop Moirai , 100% chance to drop 1 of 9 dolls lvl 1, Zaken 7-Day Jewelry Raid Bosses (7 RBs): Drop Moirai Parts + Neolithic S grade instead of Vespers parts that has 7 Rb Quest give Icarus Weapons Special Feature 7rb bosses level up soul crystals aswell. Closed Areas : Monaster of SIlence, LOA, ( It wont have mobs) / Mahum Quest/Lizardmen off) Grand Epics: Unlocked on Day 4 of Stage 1 → Antharas, Valakas, Baium, AQ, etc ================================================================================= Stage 2 – Rise of Vespers Level Cap: 85 Gear: Moirai Armors (Adena GM SHOP / Craft/ Drop) Weapons: Icarus Cloaks: Level 2 Olf: +8 Dolls: Level 2 Belts: High & Top Enchant: Safe +3 / Max +8 Masterwork can be with Neolithics S84 aswell but higher so craft will be usefull aswell. 7 Raid Boss Quest Updated: Now works retail give vesper weapons 7rb Bosses Drops : Vespers Instances: Zaken : Drops to retail vespers + the dolls and the extra items that we added on stage 1 New Freya Instance: Added — drops vespers and instead of mid s84 weapons will drop vespers . Extra drops Blessed Bottle of Freya - drops 100% chance 1 of 9 dolls. Farm Areas Dragon Valley remains main farm New Zone : Lair of Antharas (mobs nerfed and added drop Noble stone so solo players can farm too) New Party Zone : LOA Circle   ============================================================================   Stage 3 – The Vorpal ERA Gear: Vorpal Unclock Cloaks: Level 3 Olf: +10 (max cap) Dolls: Level 3 Enchant: Safe +3 / Max +12 Farm Zones : Dragon Valley Center Scorpions becomes a normal solo zone (no longer party zone) Drops:   LOA & Knorik → Mid Weapons avaliable in drop New Party Zone Kariks Instances: Easy Freya Drops Mid Weapons Frintezza Release =================================================================================     Stage 4 – Elegia Era (Final Stage) Elegia Unlock Gear: Elegia Weapons: Elegia TOP s84 ( farmed via H-Freya/ Drops ) Cloaks: Level 5 Dolls: Level 3 (final bonuses) Enchant: Safe +6 / Max +16 Instances: Hard Freya → Drops Elegia Weapons + => The Instance will drop 2-3 parts for sure and also will be able to Join with 7 people . Party Zone will have also drop chances for elegia armor parts and weapons but small   Events (Hourly): Win: 50 Event Medals + 3 GCM + morewards Lose: 25 Medals + 1 GCM + more rewards Tie: 30 Medals + 2 GCM + more rewards   ================================================================================ Epic Fragments Currency Participating in Daily Bosses mass rewarding all players Participating in Instances (zaken freya frintezza etc) all players get reward ================================================================================ Adena - Main server currency (all items in gm shop require adena ) Event Medals (Festival Adena) - Event shop currency Donation coins you can buy with them dressme,cosmetics and premium account Epic Fragments you can buy with them fake epic jewels Olympiad Tokens you can buy many items from olympiad shop (Hero Coin even items that are on next stages) Olympiad Win = 1000 Tokens / Lose = 500 Tokens ================================================================================= Offline Autofarm Allows limited Offline farming requires offline autofarm ticket that you get by voting etc ================================================================================= Grand Epics have Specific Custom NPC that can spawn Epics EU/LATIN TIME ZONE ================================================================================= First Olympiad Day 19 December First Heroes 22 December ( 21 December Last day of 1st Period) After that olympiad will be weekly. ================================================================================= Item price and economy Since adena is main coin of server and NOT donation coins we will always add new items in gm shop with adena in order to burn the adena of server and not be inflation . =================================================================================        
    • MonkZe
      Custom NPC title color

      By MonkZe · Posted

      Hello, I'd like to change a title color for custom npc.  I created custom NPC, cloned existing. I put unique id for it in npcname-e, npcgrp and database. I have "0" to serverSideName in db, so that it would use npcname-e, but instead it has "NoNameNPC"and no title color change.
    • maxicroma
      [WTS] Light mode Complete website template for lineage 2

      By maxicroma · Posted

      Trusted Guy 100% ,  I asked him for some work and he did it right away.
    • VPSLab
      — VPSLAB — Fast & Private RDP/VPS | 100% Instant Setup

      By VPSLab · Posted

      Active & Taking Orders!
    • EliteZ1
      Need .dat editor for c5

      By EliteZ1 · Posted

      up

  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock