Jump to content
  • 0

l2jfrozen, guards


Question

Posted (edited)

can i delete castle guards from anywhere? i mean not 1 by 1.

and 1 more question, how can i change  enchant skill Sp cost ?

Edited by dramaa93

5 answers to this question

Recommended Posts

  • 0
Posted (edited)
1 hour ago, dramaa93 said:

can i delete castle guards from anywhere? i mean not 1 by 1.

and 1 more question, how can i change  enchant skill Sp cost ?

I guess their type is L2SiegeGuardInstance you can make an SQL query and delete all ID from the spawnlist table of that type. 

 

On the other hand, why delete them from the database. Simply add a check in SpawnTable.java if template instance typeOf("L2SiegeGuard"), to continue and not perform any spawn of that instance. Faster way cause i doubt if your spawnlist contains the type of the spawn. This must in "custom_npc" or "npc.xml" if your NPCs are in xml format.

Edited by Kara
  • 0
Posted
On 2/22/2021 at 4:36 PM, dramaa93 said:

can i delete castle guards from anywhere? i mean not 1 by 1.

and 1 more question, how can i change  enchant skill Sp cost ?

i think this will work as well SQL~>

Spoiler

DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid = npc.idTemplate AND npc.level < 80 AND npc.type = 'L2SiegeGuard'; 

 

Guest
This topic is now closed to further replies.


  • Posts

    • To all first time buyers we give a bonus + 10% of the order. 
    • 🔥 Looking for a powerful, clean, and player-friendly Auction House system for your Lineage 2 server? This fully-featured module is ready to plug into your project and provide your players with a modern, centralized marketplace!   💼 What is it? A complete Auction House system designed for fixed-price item sales between players. Forget about private stores and spammed zones—this system offers a smooth, secure, and offline-friendly way to buy and sell items across your server.   Photo Library: https://imgur.com/a/zLlUQbW   ✅ Main Features: 🔹 Fixed-Price Listings Only: Players list items at a set price. No bidding, no delays—just fast, clean trades. 🔹 Multi-Currency Support: Works with Adena, event coins, custom currencies—fully configurable. 🔹 Dynamic Interface: Players can filter items by name, type, and price. Easy-to-use HTML layout with smooth pagination. 🔹 Sell While Offline: Post items and receive payments even if you're not online—true passive trading. 🔹 Safety First: Full validation: no equipped/augmented/restricted items unless allowed. Prevents scams, mispricing, and listing errors. 🔹 Expiration Timer (Optional): Set listing time limits. Expired items go to warehouse/mail automatically. 🔹 Spam & Duplication Protection: Prevents multiple listings of identical items and unnecessary database load. 🔹 Performance Optimized: Clean, indexed SQL structure. No lag or bloating even with thousands of listings.   ⚙️ Plug & Play Clean Java code (compatible with aCis & derivatives). Easy setup with full instructions and sample configurations. Includes SQL, HTML files, and all Java classes – fully working out of the box.   💰 Pricing & Contact 📦 50 euro - One-time purchase with full support for setup & basic customization. 💬 Contact me here via PM or on Discord: @Luminous 🔐 Serious buyers only – source is clean, secure, and tested on live servers.     Give your server the next-level economy it deserves. No more chaotic trade zones. No more confusion. Just clean, efficient, server-wide trading.
    • We are certainly not an ambulance, but we will definitely cure you of blacklists and empty pockets. Live freely with SX! Each of you will receive a trial version of SX to familiarize yourself with the product, all you have to do is post in this thread
    • 166 pisses on their heads any day of the week though
    • Thnx for share, i can't pm u for password  
  • Topics

×
×
  • Create New...