We moved our repositories to BitBucket!

If you can't login or you can't register to the forums do not rise an issue, instead please write to support (at) l2jserver.com

Check our wiki!

Report server issues here

Forum has been updated to phpBB 3.2, let's see if this fixes some minor bugs we had.

Thank you for visiting http://www.l2jserver.com/

NPC. I don't know how to do it... :-6

Find the proper support area, Saga-Version.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Moplen
Posts: 12
Joined: Fri Dec 06, 2013 12:46 pm

NPC. I don't know how to do it... :-6

Post by Moplen » Thu Feb 20, 2014 4:51 pm

L2J server Version 6270
L2J datapack version 10024

What should I do if I want to add new npcs like Global GK Juliette,
Roy the Cat, NPC BUffer Shiela and so on in game?

Thanks for your great help.

Image

User avatar
UnAfraid
L2j Veteran
L2j Veteran
Posts: 4196
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

Re: NPC. I don't know how to do it... :-6

Post by UnAfraid » Thu Feb 20, 2014 7:31 pm

The l2j configurator isnt the place u must looking at.
check data/stats/npcs/custom/
Image

Moplen
Posts: 12
Joined: Fri Dec 06, 2013 12:46 pm

Re: NPC. I don't know how to do it... :-6

Post by Moplen » Thu Feb 20, 2014 9:30 pm

Thank you very much! !!

I checked data/stats/npcs

I don't know where the Global GK Juliette and Buffer Shiela are.

Any help is welcome.... :-6

Image

User avatar
UnAfraid
L2j Veteran
L2j Veteran
Posts: 4196
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

Re: NPC. I don't know how to do it... :-6

Post by UnAfraid » Thu Feb 20, 2014 9:41 pm

Look at custom folder
Image

Moplen
Posts: 12
Joined: Fri Dec 06, 2013 12:46 pm

Re: NPC. I don't know how to do it... :-6

Post by Moplen » Fri Feb 21, 2014 1:31 pm

I have checked data/stats/npcs, but I have no custom folder. :-6
I am playing on Freya, and I haven't found it.

Where can I find a SQL file to add the npc global GK in the database?

Moplen
Posts: 12
Joined: Fri Dec 06, 2013 12:46 pm

Re: NPC. I don't know how to do it... :-6

Post by Moplen » Sat Feb 22, 2014 1:03 pm

up

User avatar
UnAfraid
L2j Veteran
L2j Veteran
Posts: 4196
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

Re: NPC. I don't know how to do it... :-6

Post by UnAfraid » Sat Feb 22, 2014 1:07 pm

Moplen wrote:I have checked data/stats/npcs, but I have no custom folder. :-6
I am playing on Freya, and I haven't found it.

Where can I find a SQL file to add the npc global GK in the database?
Use navicat and check custom_npc table there you must put your custom npcs.
Don't forget to enable CustomNpcTable in General.properties.

And btw bumping is not allowed here.
Image

Moplen
Posts: 12
Joined: Fri Dec 06, 2013 12:46 pm

Re: NPC. I don't know how to do it... :-6

Post by Moplen » Sun Feb 23, 2014 10:30 pm

L2J server Version 6270
L2J datapack version 10024
UnAfraid wrote: Use navicat and check custom_npc table there you must put your custom npcs.
Don't forget to enable CustomNpcTable in General.properties.
Thanks for your great help. Ok, I enabled CustomNpcTable by writing True. I can see the npc Shiela on custom_npc table, but I don't know how to put that npc in the game. Do I have to download something...?

navicat
Image


PS -Also, I tried to install Yanbuffer, but I perhaps failed :-6
(In game I saw no change, and I don't know where looking for it.)
UnAfraid wrote: And btw bumping is not allowed here.
Sorry :oops:

Cresceus
Posts: 238
Joined: Tue Jan 15, 2008 8:20 am
Location: Germany

Re: NPC. I don't know how to do it... :-6

Post by Cresceus » Mon Feb 24, 2014 10:16 am

Moplen wrote:but I don't know how to put that npc in the game. Do I have to download something...?
You've to spawn the npc ingame with command //spawn <NPC-Id>.

If you got no target, the npc will spawn at the current location of your character. Otherwise the npc will spawn at the location of your target. So make sure you have the correct target (:

Moplen
Posts: 12
Joined: Fri Dec 06, 2013 12:46 pm

Re: NPC. I don't know how to do it... :-6

Post by Moplen » Mon Feb 24, 2014 7:42 pm

Hi Cresceus
Thanks for your reply !

I tested the //show_spawns - Opens spawn menu.
It worked well.
Then I wrote the ID number 1000003 and Npc name Shiela.
It didn't work. I tried more and more times. Nothing.
It doesn't show that Npc.

So I tried to spawn a different Npc (eg. Raula, Id 322226) and it worked.

What's wrong? Why I cannot spawn Shiela?

The Custom NPC shows these values: name Shiela, ID 1000003, serversidename 1, title L2J NPC buffer and so on.

Cresceus
Posts: 238
Joined: Tue Jan 15, 2008 8:20 am
Location: Germany

Re: NPC. I don't know how to do it... :-6

Post by Cresceus » Mon Feb 24, 2014 9:35 pm

Is there something written in the systemchat? Somethink like "Your target cannot be found."?

Moplen
Posts: 12
Joined: Fri Dec 06, 2013 12:46 pm

Re: NPC. I don't know how to do it... :-6

Post by Moplen » Tue Feb 25, 2014 12:03 am

Yes, exactly, you are right. In fact I don't understand what's wrong.
On Custom_Npc (Navicat), Shiela's ID is 1000003.
But when I click on Spawn, on chat you can read
''Your target cannot be found''.

Image

Image

Cresceus
Posts: 238
Joined: Tue Jan 15, 2008 8:20 am
Location: Germany

Re: NPC. I don't know how to do it... :-6

Post by Cresceus » Tue Feb 25, 2014 1:43 am

Are you sure you've enabled CustomNpcTable (CustomNpcTable = True) in General.properties?

What is written in stdout.log when you try to spawn Shiela or another custom npc?

It seems that the custom npc is not loaded. Try to spawn another custom npc. Catherine, Snow or Andromeda for testing purpose.

Moplen
Posts: 12
Joined: Fri Dec 06, 2013 12:46 pm

Re: NPC. I don't know how to do it... :-6

Post by Moplen » Tue Feb 25, 2014 4:54 pm

Thanks for your answer.

I have tested Shiela and then Catrina, Andromeda, Snow.
The result is the same: ''Your target cannot be found''. 0____o

So I controlled the game/ config/ General.properties,
and on CustomNpcTable you can read "True".

Image

About stdout.log, there are some errors (see below):

[ Geodata ]
Geodata Engine: Disabled.
---------------------------------------------------------------------=[ NPCs ]
SkillLearnData: Loaded 256 Skill Learn data.
NpcTable: Error creating NPC table.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jgs.custom_n
pc' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2157)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2324)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:116)
at com.l2jserver.gameserver.datatables.NpcTable.loadNpcs(NpcTable.java:7
12)
at com.l2jserver.gameserver.datatables.NpcTable.loadNpcs(NpcTable.java:6
82)
at com.l2jserver.gameserver.datatables.NpcTable.restoreNpcData(NpcTable.
java:220)
at com.l2jserver.gameserver.datatables.NpcTable.<init>(NpcTable.java:99)

at com.l2jserver.gameserver.datatables.NpcTable$SingletonHolder.<clinit>
(NpcTable.java:1193)
at com.l2jserver.gameserver.datatables.NpcTable.getInstance(NpcTable.jav
a:1188)
at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:274)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:483)

NpcTable: Loaded 10461 (Custom: 0) NPC template(s).
NpcTable: Loaded 112918 (Custom: 0) NPC skills.
NpcTable: Loaded 43832 (Custom: 0) drops.
NpcTable: Loaded 520 Minions.
NpcTable: Error reading NPC AI Data: Table 'l2jgs.custom_npcaidata' doesn't exis
t
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jgs.custom_n
pcaidata' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2157)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2324)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:116)
at com.l2jserver.gameserver.datatables.NpcTable.loadNpcAi(NpcTable.java:
1036)
at com.l2jserver.gameserver.datatables.NpcTable.loadNpcsAI(NpcTable.java
:1008)
at com.l2jserver.gameserver.datatables.NpcTable.restoreNpcData(NpcTable.
java:225)
at com.l2jserver.gameserver.datatables.NpcTable.<init>(NpcTable.java:99)

at com.l2jserver.gameserver.datatables.NpcTable$SingletonHolder.<clinit>
(NpcTable.java:1193)
at com.l2jserver.gameserver.datatables.NpcTable.getInstance(NpcTable.jav
a:1188)
at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:274)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:483)

NpcTable: Loaded 10461 (Custom: 0) AI Data.
NpcTable: Error reading NPC Elementals Data: Table 'l2jgs.custom_npc_elementals'
doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jgs.custom_n
pc_elementals' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2157)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2324)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:116)
at com.l2jserver.gameserver.datatables.NpcTable.loadNpcsElement(NpcTable
.java:1128)
at com.l2jserver.gameserver.datatables.NpcTable.loadNpcsElement(NpcTable
.java:1100)
at com.l2jserver.gameserver.datatables.NpcTable.restoreNpcData(NpcTable.
java:226)
at com.l2jserver.gameserver.datatables.NpcTable.<init>(NpcTable.java:99)

at com.l2jserver.gameserver.datatables.NpcTable$SingletonHolder.<clinit>
(NpcTable.java:1193)
at com.l2jserver.gameserver.datatables.NpcTable.getInstance(NpcTable.jav
a:1188)
at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:274)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:483)

NpcTable: Loaded 10461 (Custom: 0) Elementals Data.

mcskiller
Posts: 1
Joined: Sun Apr 06, 2014 3:09 am

Re: NPC. I don't know how to do it... :-6

Post by mcskiller » Sun Apr 06, 2014 10:40 pm

Just put //spawn shiela
I got same error but with npc name no problem

Locked