DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level>67 AND npc.type='L2Monster';
I used this sql script and I got this error... I wanna delete all monsters >67 lvl
script working normal but I got this error what is wrong?
INFO - Van Halter
WARN VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175. WARN VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175. WARN VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175. WARN VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175. WARN VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175.
and this
INFO NPCTable: No npc correlating with id: 18345 INFO NPCTable: No npc correlating with id: 18346 INFO NPCTable: No npc correlating with id: 20627 INFO NPCTable: No npc correlating with id: 20627 INFO NPCTable: No npc correlating with id: 20627
Responsibilities
• Working with the Lineage 2 server datapack
• Editing and maintaining:
• NPCs, mobs, raids, minions
• Skills, items, multisell, buylists
• Quests (XML + HTML)
• Spawn lists, territories, siege data
• Balancing:
• EXP / SP / Drop / Spoil
• Economy, shops, crafting
• PvE progression without PvP bias
• Testing changes:
• clean characters + GM testing
• server restarts
• log analysis
Required Skills
• Excellent knowledge of the Lineage 2 datapack structure
• Confident work with XML / CSV / TXT
• Understanding of Interlude mechanics:
• aggro, AI, land-rate
• champion / raid mechanics
• Understanding of interdependencies:
• item ↔ skill ↔ NPC ↔ quest
• Careful handling of IDs (without breaking compatibility)
Would Be a Big Plus
• Experience with L2J forks
• Understanding of the Java side of the server (datapack ↔ code integration level)
• Experience with custom systems:
• dynamic rates
• stage-based progression
• seasonal / PvE events
• Ability to balance using tables and formulas rather than “by feel”
We Are Not Looking for Someone Who
• Copies datapacks from other servers
• Changes IDs without understanding the consequences
• Creates multisells with infinite profit
• Does not test changes after a restart
• Balances “by intuition”
Question
Pamela32
DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level>67 AND npc.type='L2Monster';
I used this sql script and I got this error... I wanna delete all monsters >67 lvl
script working normal but I got this error what is wrong?
INFO - Van Halter
WARN VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175.
WARN VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175.
WARN VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175.
WARN VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175.
WARN VanHalterManager.loadRoyalGuard: Data missing in NPC table for ID: 22175.
and this
INFO NPCTable: No npc correlating with id: 18345
INFO NPCTable: No npc correlating with id: 18346
INFO NPCTable: No npc correlating with id: 20627
INFO NPCTable: No npc correlating with id: 20627
INFO NPCTable: No npc correlating with id: 20627
1 answer to this question
Recommended Posts