NPC. I don't know how to do it... :-6
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
-
- Posts: 12
- Joined: Fri Dec 06, 2013 12:46 pm
NPC. I don't know how to do it... :-6
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.
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.
- UnAfraid
- L2j Veteran
- Posts: 4199
- Joined: Mon Jul 23, 2007 4:25 pm
- Location: Bulgaria
- Contact:
Re: NPC. I don't know how to do it... :-6
The l2j configurator isnt the place u must looking at.
check data/stats/npcs/custom/
check data/stats/npcs/custom/
-
- Posts: 12
- Joined: Fri Dec 06, 2013 12:46 pm
Re: NPC. I don't know how to do it... :-6
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
I checked data/stats/npcs
I don't know where the Global GK Juliette and Buffer Shiela are.
Any help is welcome.... :-6
- UnAfraid
- L2j Veteran
- Posts: 4199
- Joined: Mon Jul 23, 2007 4:25 pm
- Location: Bulgaria
- Contact:
-
- Posts: 12
- Joined: Fri Dec 06, 2013 12:46 pm
Re: NPC. I don't know how to do it... :-6
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?
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?
- UnAfraid
- L2j Veteran
- Posts: 4199
- Joined: Mon Jul 23, 2007 4:25 pm
- Location: Bulgaria
- Contact:
Re: NPC. I don't know how to do it... :-6
Use navicat and check custom_npc table there you must put your custom npcs.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?
Don't forget to enable CustomNpcTable in General.properties.
And btw bumping is not allowed here.
-
- Posts: 12
- Joined: Fri Dec 06, 2013 12:46 pm
Re: NPC. I don't know how to do it... :-6
L2J server Version 6270
L2J datapack version 10024
navicat
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.)
L2J datapack version 10024
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...?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.
navicat
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.)
SorryUnAfraid wrote: And btw bumping is not allowed here.
-
- Posts: 238
- Joined: Tue Jan 15, 2008 8:20 am
- Location: Germany
Re: NPC. I don't know how to do it... :-6
You've to spawn the npc ingame with command //spawn <NPC-Id>.Moplen wrote:but I don't know how to put that npc in the game. Do I have to download something...?
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 (:
-
- Posts: 12
- Joined: Fri Dec 06, 2013 12:46 pm
Re: NPC. I don't know how to do it... :-6
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.
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.
-
- Posts: 238
- Joined: Tue Jan 15, 2008 8:20 am
- Location: Germany
Re: NPC. I don't know how to do it... :-6
Is there something written in the systemchat? Somethink like "Your target cannot be found."?
-
- Posts: 12
- Joined: Fri Dec 06, 2013 12:46 pm
Re: NPC. I don't know how to do it... :-6
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''.
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''.
-
- Posts: 238
- Joined: Tue Jan 15, 2008 8:20 am
- Location: Germany
Re: NPC. I don't know how to do it... :-6
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.
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.
-
- Posts: 12
- Joined: Fri Dec 06, 2013 12:46 pm
Re: NPC. I don't know how to do it... :-6
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".
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.
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".
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.
-
- Posts: 1
- Joined: Sun Apr 06, 2014 3:09 am
Re: NPC. I don't know how to do it... :-6
Just put //spawn shiela
I got same error but with npc name no problem
I got same error but with npc name no problem