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 »

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: 4199
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 »

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 »

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: 4199
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 »

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 »

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 »

up
User avatar
UnAfraid
L2j Veteran
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

Post 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.
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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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