NPC Spawn - Shiela

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
Bazcor
Posts: 3
Joined: Sun Apr 05, 2015 3:20 am

NPC Spawn - Shiela

Post by Bazcor »

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
Amrod
Posts: 95
Joined: Wed May 04, 2011 9:12 am

Re: NPC Spawn - Shiela

Post by Amrod »

I downloaded the latest one and custom_npc table does not exist
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.
User avatar
volix
Posts: 106
Joined: Tue May 17, 2011 5:20 pm

Re: NPC Spawn - Shiela

Post by volix »

This NPC Shiela?
Look at General.properties
Bazcor
Posts: 3
Joined: Sun Apr 05, 2015 3:20 am

Re: NPC Spawn - Shiela

Post by Bazcor »

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
feris
Posts: 3
Joined: Sat Jan 26, 2013 9:45 pm

Re: NPC Spawn - Shiela

Post by feris »

Same problem here, i cant Create new custom NPC for YANBuffer, cause there are no "custom_npc" table in Navicat.
Amrod
Posts: 95
Joined: Wed May 04, 2011 9:12 am

Re: NPC Spawn - Shiela

Post by Amrod »

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:

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>
Post Reply