Query Kolay NPC ve Canavar Ekleme Rehberi [SQL Kodlarıyla]

Aethre' Alıntı:

Knight Online Guide to Adding Monsters and NPCs

Server owners can easily add new monsters or NPCs to the game. Below are example queries and explanations to help you perform these operations correctly.

Monster Addition Process

First, you need to find the ID of the monster you want to add. You can do this using the following query:

<b>[Hidden content]</b>

Example:
We want to add a Worm to the Luferson region. To do this, we write the following query in the Query Analyzer:

<b>[Hidden content]</b>

The records from this query show that Worm's ID is 700. Now let's add this monster to Luferson.
The coordinates to be used are: 751, 351
Respawn time: 30 minutes (30 × 60 = 1800 seconds)

Kod:

INSERT INTO [K_NPCPOS] VALUES
('1','700','1','0','0','0','0','751','351','751','351','751','351','751','351','1','1800','0','0','NULL');

This query adds a single instance of Worm with ID 700 to the Luferson region.

NPC Adding Process

Similarly, to add a new NPC to the game, we need to know their ID.
For example, we'll add a new Sundries to Moradon . To do this:

<b>[Hidden content]</b>

This query lists all sundries NPCs in the game.
The most important point to pay attention to is the byGroup value:

1 = Karus

2 = Human
Since Moradon is a shared space, this difference is irrelevant.

For example, let's add the Sundries NPC with ID 505 to Moradon (Zone 21) at these coordinates: 351, 256

Kod:

INSERT INTO [K_NPCPOS] VALUES
('21','505','103','0','0','0','0','351','256','351','256','351','256','351','256','1','30','0','0','NULL');

NPC or Monster Removal

To remove an added monster or NPC, you can use the following query:

Kod:

DELETE FROM K_NPCPOS WHERE NpcID = IDnumber AND ZoneID = Zonenumber

Example:
To delete the Worm (ID 700, Zone 1) that we added to Luferson:

Kod:

DELETE FROM K_NPCPOS WHERE NpcID = 700 AND ZoneID = 1

If there are multiple identical monsters in the same area and you only want to eliminate the one in a specific location, you can include its coordinates.

Kod:

DELETE FROM K_NPCPOS WHERE NpcID = 700 AND ZoneID = 1 AND LeftX = 751

If you don't know the exact coordinates, you can first list them using this query:

Kod:

SELECT * FROM K_NPCPOS WHERE NpcID = 700 AND ZoneID = 1

This way, you can find the closest coordinate value to the monster you want to delete and perform the operation.

Genişletmek için tıklayın...