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    18
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    9

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