Jump to content
  • 0

Script To Delete Rb's Spawn


DontKnow

Question

7 answers to this question

Recommended Posts

  • 0

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. 

Link to comment
Share on other sites

  • 0
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
Link to comment
Share on other sites

  • 0
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.

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

  • 0

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. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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