Please enable / Bitte aktiviere JavaScript!
Veuillez activer / Por favor activa el Javascript![ ? ]
Script To Delete Rb's Spawn - Request Server Development Help [L2J] - MaxCheaters.com

Jump to content

Welcome to MaxCheaters.com
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. If you already have an account, login here - otherwise create an account for free today!

Announcements!

Dont forget to follow the rules and staffer rules

Check Our Daily News and Updates ,Like Us @ Facebook

Advertising information here


Photo

Script To Delete Rb's Spawn

script sql rb spawn

  • Please log in to reply

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users


6 replies to this topic

#1
DontKnow

DontKnow
    • Level 2 Cheater
    • Members
    Posts:
    15
    Reputation:
    0
    Member:
    56685
    Joined:
    30-July 09
  • Gender:
    Not Telling
  • User's Feedbacks

  • N/A 0 0 0

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


  • 0

#2
jornik

jornik
    • Level 2 Cheater
    • VIP Member
    Posts:
    11
    Reputation:
    0
    Member:
    124197
    Joined:
    02-February 13
  • Gender:
    Not Telling
  • User's Feedbacks

  • N/A 0 0 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?



#3
DontKnow

DontKnow
    • Level 2 Cheater
    • Members
    Posts:
    15
    Reputation:
    0
    Member:
    56685
    Joined:
    30-July 09
  • Gender:
    Not Telling
  • User's Feedbacks

  • N/A 0 0 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. 



#4
melron

melron
    • Level 25 Cheater
    • VIP Member
    Posts:
    387
    Reputation:
    9
    Member:
    128204
    Joined:
    07-May 13
  • Current Mood:
    Emotions'
  • Gender:
    Male
  • Country:
    Country Flag
  • Location:
    Valley of Saints
  • User's Feedbacks

  • N/A 0 0 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, 19 May 2017 - 05:12 PM.

Instead of wondering when your next vacation is, you ought to set up a life you don't need to escape from....

 


#5
DontKnow

DontKnow
    • Level 2 Cheater
    • Members
    Posts:
    15
    Reputation:
    0
    Member:
    56685
    Joined:
    30-July 09
  • Gender:
    Not Telling
  • User's Feedbacks

  • N/A 0 0 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.



#6
eressea

eressea
    • Level 17 Cheater
    • VIP Member
    Posts:
    239
    Reputation:
    5
    Member:
    134050
    Joined:
    07-October 13
  • Current Mood:
    Emotions'
  • Gender:
    Female
  • Country:
    Country Flag
  • User's Feedbacks

  • N/A 0 0 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...


Emca
 
--
 
They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety -- Benjamin Franklin

Do unto others as they do unto you -- Anton Szandor LaVey

 

L2 Shrine - Gracia Final 4x l2off retail NO DONATE - https://l2shrine.com/


#7
DontKnow

DontKnow
    • Level 2 Cheater
    • Members
    Posts:
    15
    Reputation:
    0
    Member:
    56685
    Joined:
    30-July 09
  • Gender:
    Not Telling
  • User's Feedbacks

  • N/A 0 0 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. 







Also tagged with one or more of these keywords: script, sql, rb, spawn

MaxCheaters.com IPB Forum Theme by Stereotype