Jump to content

Question

7 answers to this question

Recommended Posts

  • 0
Posted

Can you describe in more detail what are you trying to achieve?

 

I suppose you don't want to spawn RBs level < xx, right?

Yes that is correct . I dont want to spawn rb's lvl<xx . I am using l2jfrozen. 

  • 0
Posted (edited)
SELECT id FROM npc WHERE level < x

use this to store somewhere all raids and make an exception when spawnlist is loading

Edited by melron
  • 0
Posted
SELECT id FROM npc WHERE level < x

use this to store somewhere all raids and make an exception when spawnlist is loading

 

I'm sorry i'm a bit noobish at this started learning 4 days ago. I did play l2 for 15 years and decided to make a server. Having 0 developing skills but 100% exp in how to make the most perfect balance that ever existed. Could you explain to me in more detail? What to do ? I know i'm annoying but i would like to learn the proper way.

  • 0
Posted

SQL? Is it really l2off? In l2off, just remove appropriate lines from npcpos.txt. In l2j it will be some DELETE FROM some_table_with_npc_spawns WHERE some_column_like_npc_id IN (SELECT id FROM table_with_npcs WHERE level<40); but I really don't know table and column names...

  • 0
Posted

SQL? Is it really l2off? In l2off, just remove appropriate lines from npcpos.txt. In l2j it will be some DELETE FROM some_table_with_npc_spawns WHERE some_column_like_npc_id IN (SELECT id FROM table_with_npcs WHERE level<40); but I really don't know table and column names...

I have used this for monsters. DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<40 AND npc.type='L2Monster'; and it worked great. Tried to adapt it for raidboss_spawnlist but can't seem to make it work. And i tried to type in npc.type="L2Raidboss" didnt work. 

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...