Page 1 of 2

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

Posted: Thu Feb 20, 2014 4:51 pm
by Moplen
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

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

Posted: Thu Feb 20, 2014 7:31 pm
by UnAfraid
The l2j configurator isnt the place u must looking at.
check data/stats/npcs/custom/

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

Posted: Thu Feb 20, 2014 9:30 pm
by Moplen
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

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

Posted: Thu Feb 20, 2014 9:41 pm
by UnAfraid
Look at custom folder

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

Posted: Fri Feb 21, 2014 1:31 pm
by Moplen
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?

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

Posted: Sat Feb 22, 2014 1:03 pm
by Moplen
up

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

Posted: Sat Feb 22, 2014 1:07 pm
by UnAfraid
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.

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

Posted: Sun Feb 23, 2014 10:30 pm
by Moplen
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:

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

Posted: Mon Feb 24, 2014 10:16 am
by Cresceus
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 (:

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

Posted: Mon Feb 24, 2014 7:42 pm
by Moplen
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.

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

Posted: Mon Feb 24, 2014 9:35 pm
by Cresceus
Is there something written in the systemchat? Somethink like "Your target cannot be found."?

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

Posted: Tue Feb 25, 2014 12:03 am
by Moplen
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

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

Posted: Tue Feb 25, 2014 1:43 am
by Cresceus
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.

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

Posted: Tue Feb 25, 2014 4:54 pm
by Moplen
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.

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

Posted: Sun Apr 06, 2014 10:40 pm
by mcskiller
Just put //spawn shiela
I got same error but with npc name no problem