Hi guys,
I am trying to spanw a NPC (Shiela - Buffer) but I cannot. I read a lot forum messages and some people said "enable custom npc table"... It seems that custom_npc table is not supported on my version (I downloaded the latest one and custom_npc table does not exist)... so, what should I do?
Thanks in advance.
Bazcor
NPC Spawn - Shiela
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
-
- Posts: 95
- Joined: Wed May 04, 2011 9:12 am
Re: NPC Spawn - Shiela
If this table doesn't exist, you Need to install it. There are .SQL files that Show you how you have to Name the columns.I downloaded the latest one and custom_npc table does not exist
- volix
- Posts: 106
- Joined: Tue May 17, 2011 5:20 pm
-
- Posts: 3
- Joined: Sun Apr 05, 2015 3:20 am
Re: NPC Spawn - Shiela
Hi guys,
New Datapack is not using SQL tables to store custom NPCs, even on SQL updates it is removing the tables.
e.g.
[root@games updates]# pwd
/games/l2j/sql/game/updates
[root@games updates]# cat 20140211update.sql
DROP TABLE IF EXISTS `droplist`;
DROP TABLE IF EXISTS `npc`;
DROP TABLE IF EXISTS `npc_elementals`;
DROP TABLE IF EXISTS `npcaidata`;
DROP TABLE IF EXISTS `npcskills`;
DROP TABLE IF EXISTS `custom_droplist`;
DROP TABLE IF EXISTS `custom_npc`;
DROP TABLE IF EXISTS `custom_npc_elementals`;
DROP TABLE IF EXISTS `custom_npcaidata`;
DROP TABLE IF EXISTS `custom_npcskills`;
[root@games updates]#
I checked my DB and those tables does not exist.
So, my question is... what is the new procedure to add custom NPCs?
Thanks in advance,
Bazcor
New Datapack is not using SQL tables to store custom NPCs, even on SQL updates it is removing the tables.
e.g.
[root@games updates]# pwd
/games/l2j/sql/game/updates
[root@games updates]# cat 20140211update.sql
DROP TABLE IF EXISTS `droplist`;
DROP TABLE IF EXISTS `npc`;
DROP TABLE IF EXISTS `npc_elementals`;
DROP TABLE IF EXISTS `npcaidata`;
DROP TABLE IF EXISTS `npcskills`;
DROP TABLE IF EXISTS `custom_droplist`;
DROP TABLE IF EXISTS `custom_npc`;
DROP TABLE IF EXISTS `custom_npc_elementals`;
DROP TABLE IF EXISTS `custom_npcaidata`;
DROP TABLE IF EXISTS `custom_npcskills`;
[root@games updates]#
I checked my DB and those tables does not exist.
So, my question is... what is the new procedure to add custom NPCs?
Thanks in advance,
Bazcor
-
- Posts: 3
- Joined: Sat Jan 26, 2013 9:45 pm
Re: NPC Spawn - Shiela
Same problem here, i cant Create new custom NPC for YANBuffer, cause there are no "custom_npc" table in Navicat.
-
- Posts: 95
- Joined: Wed May 04, 2011 9:12 am
Re: NPC Spawn - Shiela
So I misunderstood.
All NPC's are now withing XML files. --> data/stats/npcs
There is a custom Folder in which you can place her, like this:
All NPC's are now withing XML files. --> data/stats/npcs
There is a custom Folder in which you can place her, like this:
Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<list xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../xsd/npcs.xsd">
<npc id="1000003" displayId="32226" name="Shiela" usingServerSideName="true" title="L2J NPC Buffer" usingServerSideTitle="true"^type="L2NpcBuffer">
<collision>
<radius normal="11" />
<height normal="22.25" />
</collision>
</npc>
</list>