[Share] Rin4a Buffer NPC v1.1 [Freya]

GreekFlavour · December 15, 2010

i cant add this buffer :(

i dont now about init_py i need just the html file and the sql and i find a lots of problems with sql all the time appears error.:: :(

Matim · December 15, 2010

i cant add this buffer :(

i dont now about init_py i need just the html file and the sql and i find a lots of problems with sql all the time appears error.:: :(

If you expect help, we need error log and description of your problem(s)

Artemian · December 15, 2010

This is Error log with Buffer errors :F

15.12.2010 9:06:26 com.l2jserver.gameserver.model.quest.Quest showError
WARNING: D:\l2j\gameserver\data\scripts\custom\555_NPCBUFFER\__init__.py
Traceback (innermost last):
  (no code object) at line 0
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

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

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

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)

at com.mysql.jdbc.Util.getInstance(Util.java:384)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)


com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.buffer_scheme_list' doesn't exist

at org.python.core.Py.JavaError(Unknown Source)
at org.python.core.PyObject._jthrow(Unknown Source)
at org.python.core.PyObject._jcall(Unknown Source)
at org.python.proxies.main$Quest$426.onFirstTalk(Unknown Source)
at com.l2jserver.gameserver.model.quest.Quest.notifyFirstTalk(Quest.java:506)
at handlers.actionhandlers.L2NpcAction.action(L2NpcAction.java:139)
at com.l2jserver.gameserver.model.L2Object.onAction(L2Object.java:275)
at com.l2jserver.gameserver.model.L2Object.onAction(L2Object.java:268)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.doInteract(L2PcInstance.java:4625)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance$AIAccessor.doInteract(L2PcInstance.java:361)
at com.l2jserver.gameserver.ai.L2PlayerAI.thinkInteract(L2PlayerAI.java:324)
at com.l2jserver.gameserver.ai.L2PlayerAI.onEvtThink(L2PlayerAI.java:349)
at com.l2jserver.gameserver.ai.L2CharacterAI.onEvtArrived(L2CharacterAI.java:704)
at com.l2jserver.gameserver.ai.AbstractAI.notifyEvent(AbstractAI.java:452)
at com.l2jserver.gameserver.ai.AbstractAI.notifyEvent(AbstractAI.java:339)
at com.l2jserver.gameserver.GameTimeController$MovingObjectArrived.run(GameTimeController.java:210)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

`NeverMore · December 15, 2010

This is Error log with Buffer errors :F

15.12.2010 9:06:26 com.l2jserver.gameserver.model.quest.Quest showError
WARNING: D:\l2j\gameserver\data\scripts\custom\555_NPCBUFFER\__init__.py
Traceback (innermost last):
  (no code object) at line 0
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

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

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

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)

at com.mysql.jdbc.Util.getInstance(Util.java:384)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)


com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.buffer_scheme_list' doesn't exist

at org.python.core.Py.JavaError(Unknown Source)
at org.python.core.PyObject._jthrow(Unknown Source)
at org.python.core.PyObject._jcall(Unknown Source)
at org.python.proxies.main$Quest$426.onFirstTalk(Unknown Source)
at com.l2jserver.gameserver.model.quest.Quest.notifyFirstTalk(Quest.java:506)
at handlers.actionhandlers.L2NpcAction.action(L2NpcAction.java:139)
at com.l2jserver.gameserver.model.L2Object.onAction(L2Object.java:275)
at com.l2jserver.gameserver.model.L2Object.onAction(L2Object.java:268)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.doInteract(L2PcInstance.java:4625)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance$AIAccessor.doInteract(L2PcInstance.java:361)
at com.l2jserver.gameserver.ai.L2PlayerAI.thinkInteract(L2PlayerAI.java:324)
at com.l2jserver.gameserver.ai.L2PlayerAI.onEvtThink(L2PlayerAI.java:349)
at com.l2jserver.gameserver.ai.L2CharacterAI.onEvtArrived(L2CharacterAI.java:704)
at com.l2jserver.gameserver.ai.AbstractAI.notifyEvent(AbstractAI.java:452)
at com.l2jserver.gameserver.ai.AbstractAI.notifyEvent(AbstractAI.java:339)
at com.l2jserver.gameserver.GameTimeController$MovingObjectArrived.run(GameTimeController.java:210)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Strange.... ??? I Hadn'd errors on adding this perfect BUffer... What is your chronicle? and project?

Ps:One of the Best Buffers from me... It contains everything... Amazing Thanks For share

Rin4a · December 15, 2010

Can't you read?

Table 'l2jdb.buffer_scheme_list' doesn't exist

Hershey · December 17, 2010

Thank's im looking for this:)

Artemian · December 18, 2010

But this table exist!

And even to the table, normally via a SQL file, it wrote the data:

http://freya.mmosite.cz/files/custom_npc.txt

I've got L2j (l2jserver.com Nightlies) FREYA

DP: 7672

SP: 4429

Noizee · December 20, 2010

Ive Modified this buffer for L2jserver Rev.7672 But It also Works with latest revision from L2jserver

http://www.4shared.com/document/o3XZqGy9/SQL_2.html

Here is the link for SQL

Opeth · December 21, 2010

I got error :D

[Err] 1264 - Out of range value for column 'patk' at row 1
[Err] REPLACE INTO `npc` VALUES(555, 18544, 'Buffer', 1, 'Edited by Z!T!oN', 1, 'LineageNpcEV.trap_ironcastle', '8', '24', 85, 'male', 'L2Npc', 40, '680', '1820', '0.00', '0.00', 40, 43, 30, 21, 20, 20, 0, 14, 101400, 6, 307525, 230, 1, 1, 0, 0, 0, 27, 120, 0, 0, 0, 0, 0, 1);

........

INSERT INTO `buffer_buff_list` VALUES ('1', '0', 'buff', '1036', '2', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('28', '0', 'special', '1323', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('31', '1', 'song', '264', '1', '2', '1');

INSERT INTO `buff

[Msg] Finished - Unsuccessfully

--------------------------------------------------

Noizee · December 22, 2010

Remove Patk And its value

Lelouch · December 22, 2010

Looks nice :)

georgesharck · December 25, 2010

great

conheonit · December 29, 2010

On corruption issues have been fixed Unclosed connection in this version?

Dec 30, 2010 6:15:02 AM com.l2jserver.L2DatabaseFactory$ConnectionCloser run

WARNING: Unclosed connection! Trace: sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)

java.lang.RuntimeException

at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:227)

at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.python.core.PyReflectedFunction.__call__(Unknown Source)

at org.python.core.PyMethod.__call__(Unknown Source)

at org.python.core.PyObject.__call__(Unknown Source)

at org.python.core.PyInstance.invoke(Unknown Source)

at org.python.pycode.serializable._pyx1293660807218.buildHtml$19(__init__.py:344)

at org.python.pycode.serializable._pyx1293660807218.call_function(__init__.py)

at org.python.core.PyTableCode.call(Unknown Source)

at org.python.core.PyTableCode.call(Unknown Source)

at org.python.core.PyFunction.__call__(Unknown Source)

at org.python.pycode.serializable._pyx1293660807218.onAdvEvent$14(__init__.py:831)

at org.python.pycode.serializable._pyx1293660807218.call_function(__init__.py)

at org.python.core.PyTableCode.call(Unknown Source)

at org.python.core.PyTableCode.call(Unknown Source)

at org.python.core.PyTableCode.call(Unknown Source)

at org.python.core.PyFunction.__call__(Unknown Source)

at org.python.core.PyMethod.__call__(Unknown Source)

at org.python.core.PyObject.__call__(Unknown Source)

at org.python.core.PyObject._jcallexc(Unknown Source)

at org.python.core.PyObject._jcall(Unknown Source)

at org.python.proxies.main$Quest$427.onAdvEvent(Unknown Source)

at com.l2jserver.gameserver.model.quest.Quest.notifyEvent(Quest.java:448)

at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.processQuestEvent(L2PcInstance.java:1806)

at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:212)

at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)

at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1001)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

[/Quote]

Soulmaster · December 30, 2010

Nice share :) but i have a problem , everything is perfect but in the Buff section i have only 1 buff which is Magic Barrier the rest are not to be found :( how can i add them? even tho they are in navicat?

conheonit · December 30, 2010

To this point, everything seems perfect. Hope not to see error Unclose Connection...

[Share] Rin4a Buffer NPC v1.1 [Freya]

Recommended Posts

GreekFlavour

Matim

Artemian

`NeverMore

Rin4a

Hershey

Artemian

Noizee

Opeth

Noizee

Lelouch

georgesharck

conheonit

Soulmaster

conheonit

Posts

Topics

Browse

Activity

Store