[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

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Posts

Topics