Sign in to follow this  
DontKnow

Script To Delete Rb's Spawn

8 posts in this topic

DontKnow    0

I need sql script that would delete rb's bellow certain lvl. Does anyone have that? 

Share this post


Link to post
Share on other sites
jornik    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?

Share this post


Link to post
Share on other sites
DontKnow    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. 

Share this post


Link to post
Share on other sites
melron    21
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

Share this post


Link to post
Share on other sites
DontKnow    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.

Share this post


Link to post
Share on other sites
eressea    10

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

Share this post


Link to post
Share on other sites
DontKnow    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. 

Share this post


Link to post
Share on other sites
Tedd Law    0

man try making it for npc table not raidboss_spawnlist and use L2RaidBoss for npc type!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this