Jump to content
  • 0

[Help] L2j Gracia Final Raid Bosses


Question

12 answers to this question

Recommended Posts

  • 0
Posted

I made this, but i get error :

[Err] 1136 - Column count doesn't match value count at row 1

[Msg] Finished - Unsuccessfully              -    how to fix this?

 

 

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`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`, `absorb_type`, `ss`, `bss`, `ss_rate`, `AI`, `drop_herbs`)
VALUES
(300000000, 29022, 'Baium', 1, 'Baium', 'title', 0, 'Monster.zaken', 65, 174, 80, 'male', 'L2GrandBoss', 40, 100000, 3347, 668, 3, 60, 57, 73, 76, 70, 80, 10253419, 1081544, 6559, 5000, 4378, 4601, 333, 0, 3819, 0, 0, 0, 129, 194, '', 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'fighter', 'false');

 

I can make it manually from sql but its painful. If i am wrong in values like 'Monster.baium' or 'L2GrandBoss' tell me plz. (I say this cuz i dont want f**king quests and teleports to towns when hitting an rb, so the monster.baium does not connects with the quest or wtv)

  • 0
Posted

I made this, but i get error :

[Err] 1136 - Column count doesn't match value count at row 1

[Msg] Finished - Unsuccessfully              -    how to fix this?

 

 

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`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`, `absorb_type`, `ss`, `bss`, `ss_rate`, `AI`, `drop_herbs`)
VALUES
(300000000, 29022, 'Baium', 1, 'Baium', 'title', 0, 'Monster.zaken', 65, 174, 80, 'male', 'L2GrandBoss', 40, 100000, 3347, 668, 3, 60, 57, 73, 76, 70, 80, 10253419, 1081544, 6559, 5000, 4378, 4601, 333, 0, 3819, 0, 0, 0, 129, 194, '', 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'fighter', 'false');

 

I can make it manually from sql but its painful. If i am wrong in values like 'Monster.baium' or 'L2GrandBoss' tell me plz. (I say this cuz i dont want f**king quests and teleports to towns when hitting an rb, so the monster.baium does not connects with the quest or wtv)

 

Its simple, check your TABLE structure, and correct structure from your sql file.

  • 0
Posted

so you can fix it easy :) read this error [Err] 1136 - Column count doesn't match value count at row 1 so you have bad structure on file in our file .sql :)

  • 0
Posted

structure you mean that the id , template_id , ... values are not in order? I checked it and they are. Anyway i did it manually.

  • 0
Posted

i mean count if your database is in the tables in custom_npc then count as entries to your sql file for compatibility of entries to disagree because you lack one now understand me? :)

  • 0
Posted

No ? Anyway this is not the problem, the problem now is that my custom raidbosses do not attack like the real raidbosses, i mean they dont use special attack with magic and etc. like baium when makes a red cloud, or antharas with the spikes. Only normal attacks :(

  • 0
Posted

No ? Anyway this is not the problem, the problem now is that my custom raidbosses do not attack like the real raidbosses, i mean they dont use special attack with magic and etc. like baium when makes a red cloud, or antharas with the spikes. Only normal attacks :(

 

Are you using a compiled pack ? Report it to their forum.

 

If you're using preconfigured , you can't do anything.

  • 0
Posted

no its not preconfigured or compiled how can i fix this?

 

Report it to the forum of your pack.Maybe it's already reported and they have fixed it.

 

So you only need to update it.

Guest
This topic is now closed to further replies.


  • Posts

    • Added FloodProtector utility to prevent packet flooding for actions like item use and dice rolling. Integrated flood protection checks in relevant client packet handlers and registered/removal hooks in player lifecycle. Updated movement logic in L2PcInstance for improved position synchronization and geodata handling. Minor fixes and refactoring in attack logic, private store handling, and admin NPC editing. Refactored AI classes to enhance movement, attack, and skill usage logic for characters and mobs. Improved distance checks, attack range calculations, and skill casting conditions. Removed unused intention command logic from L2CharacterAI. Updated configuration to enable CellPathFinding. Minor code cleanups and bug fixes for more reliable AI behavior. Enhanced GeoPathFinding with detailed debug and error messages for region loading, including success/failure counts and file checks. Refactored L2AttackableAI and L2CharacterAI to improve attack range tolerance, immediate attack behavior, and added safety checks for missing targets. Updated configuration to disable CellPathFinding by default and added a new ShowRedName option for aggressive mobs. Minor config and log updates included. Applied TCP socket optimizations (e.g., TCP_NODELAY, buffer sizes, keepalive) in ClientThread, Connection, and SelectorThread to reduce latency and improve throughput. Enhanced L2AttackableAI with better random walk, aggro, and attack logic, including silent move checks, quest monster handling, and improved faction/raid/minion behavior. Added silent move support to L2PlayableInstance and quest monster flag to L2NpcTemplate/L2NpcInstance. These changes aim to improve server responsiveness, AI realism, and overall stability.
    • I’ve been using this Escape from Tarkov Hack for about a week now with no issues at all. ESP works great without any lag, and the aimbot is smooth and doesn't feel obvious. Had a quick setup with the loader, and support answered my questions right away. The HWID spoofer also did its job without messing with my system. So far, the cheat's staying undetected on my side.
    • Hello everyone, this is ADENA L2REBORN / LU4 / MASTERWORK We also have items, epics, etc. discord - adver745645 Our prices are reasonable, so have a nice shopping and a nice day.
  • 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