Code Rank Pvp System 3.8.9 [Il - H5]

<< Masterio >> · October 26, 2012

in config file

# Show additional button in PvPWindow after death. 
# Button allow see more details about killer. HP/MP/CP Equipment (enchant). 
# It shows killer status only for kill MOMENT.
# Option requires CustomPvpInfoCommandShowOnDeathEnabled and CustomPvpInfoCommandEnabled set on True.
CustomPvpDeathManagerDetailsEnabled = True

Nightw0lf · October 26, 2012

images on the server im curius if this cause lag in every pvp of each player if 50 pvps done in same minute server will send more kbs in client so the upload will be big its better on the client for big servers can you do it configurable?

<< Masterio >> · October 27, 2012

Reasons why i did it:

1. Images from server are resisted for low textures in option's.

2. All images are buffered by client, it's mean they will be send only once to player, next time client load it from memory.

3. If you have 100MBit connection it does no difference.

Anyway I will add the option.

Nightw0lf · October 27, 2012

well some information that i didnt know hehe nice job then!

marwan · October 27, 2012

if(activeChar.isInsideZone(Byte.parseByte(CustomPvpSystemConfig.CUSTOM_PVP_DEATH_MANAGER_RESTRICTED_ZONES_IDS))){

error here

when i change to int it still gives me error

l2gang · October 28, 2012

Community Board problem .

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION l2beta.CPS_B
BS_get_daily_kills does not 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:1053)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2155)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2322)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:446)
        at com.l2jserver.gameserver.custom.pvpsystem.CustomPvpSystemBBSManagerHt
ml.topListHtml(CustomPvpSystemBBSManagerHtml.java:131)
        at com.l2jserver.gameserver.custom.pvpsystem.CustomPvpSystemBBSManagerHt
ml.prepareHtmlResponse(CustomPvpSystemBBSManagerHtml.java:66)
        at com.l2jserver.gameserver.custom.pvpsystem.CustomPvpSystemBBSManager.p
arsecmd(CustomPvpSystemBBSManager.java:70)
        at com.l2jserver.gameserver.communitybbs.CommunityBoard.handleCommands(C
ommunityBoard.java:88)
        at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.
runImpl(RequestBypassToServer.java:248)
        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run
(L2GameClientPacket.java:64)
        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1
088)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

Procedures added, all mysql part.

<< Masterio >> · October 28, 2012

Yes my wrong, i forgot add this procedure :) Updated to v2.9.7.

MaKasTreRo · October 28, 2012

Work in Freya?

<< Masterio >> · October 28, 2012

It was wrote for clear l2j server H5, so i think on freya should work too, but if database structure are different you need edit some fields in sql and procedures manually (Example: table characters, column charId in interlude is char_obj_id, this small differences must be committed manually). I don't know what table structure is in your projects but if you know a little bit sql, you can change it easy.

Same thing with java structure, some classes can be in other packages, than latest H5, so you must change imports (sometimes it's not enough, so you need know java language to fit up this system into your project).

Base classes of CPS are stored in cps package, so corrects not needed. Classes like L2PcInstance, BBSManager, VoiceCommands should be the same, but if you have other customs, remember to add patches manually.

I used Image Converter classes in my system (with html image tag generator class in alone packed), but i don't think so if it will be hard to add.

:D

Nightw0lf · October 28, 2012

exm matthewmaster04 what are the known problems of the rank system? i show some todo inside so is there anything missing or known problem?

l2gang · October 28, 2012

Again, another.

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu
mn 'from_date' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4094)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2155)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2322)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:446)
        at com.l2jserver.gameserver.custom.pvpsystem.CustomPvpSystemBBSManagerHt
ml.topListHtml(CustomPvpSystemBBSManagerHtml.java:131)
        at com.l2jserver.gameserver.custom.pvpsystem.CustomPvpSystemBBSManagerHt
ml.prepareHtmlResponse(CustomPvpSystemBBSManagerHtml.java:66)
        at com.l2jserver.gameserver.custom.pvpsystem.CustomPvpSystemBBSManager.p
arsecmd(CustomPvpSystemBBSManager.java:70)
        at com.l2jserver.gameserver.communitybbs.CommunityBoard.handleCommands(C
ommunityBoard.java:88)
        at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.
runImpl(RequestBypassToServer.java:248)
        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run
(L2GameClientPacket.java:64)
        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1
088)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

marwan · October 28, 2012

if(activeChar.isInsideZone(Byte.parseByte(CustomPvpSystemConfig.CUSTOM_PVP_DEATH_MANAGER_RESTRICTED_ZONES_IDS))){

error here

when i change to int it still gives me error

<< Masterio >> · October 28, 2012

l2gang tell me Mysql version, project (l2j H5 , Freya , IL other?).

I updated some sql procedures and tables.

Check and report,

v2.9.8 added.

l2gang · October 28, 2012

Working with l2j h5 beta fully updated. MySQL Server 5.5 x64

Deleted functions and tables, loaded - procedures_tables_v2.9.8 with "execute SQL files" .

Tested Community Board, no error, but with no data in "custom_pvp_system" table.

Made PvP with 1 character(data is updated in custom_pvp_system table), tested again Community Board, and same error as before :

(mention that in community board list is clear, "no one is killed yet" so no data from mysql reaches there)

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu
mn 'from_date' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4094)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2155)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2322)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:446)
        at com.l2jserver.gameserver.custom.pvpsystem.CustomPvpSystemBBSManagerHt
ml.topListHtml(CustomPvpSystemBBSManagerHtml.java:131)
        at com.l2jserver.gameserver.custom.pvpsystem.CustomPvpSystemBBSManagerHt
ml.prepareHtmlResponse(CustomPvpSystemBBSManagerHtml.java:66)
        at com.l2jserver.gameserver.custom.pvpsystem.CustomPvpSystemBBSManager.p
arsecmd(CustomPvpSystemBBSManager.java:70)
        at com.l2jserver.gameserver.communitybbs.CommunityBoard.handleCommands(C
ommunityBoard.java:88)
        at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.
runImpl(RequestBypassToServer.java:248)
        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run
(L2GameClientPacket.java:64)
        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1
088)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

<< Masterio >> · October 29, 2012

Ok i checked it, i have no errors, maybe i can't restore the situation :)

Code Rank Pvp System 3.8.9 [Il - H5]

Recommended Posts

<< Masterio >>

Nightw0lf

<< Masterio >>

Nightw0lf

marwan

l2gang

<< Masterio >>

MaKasTreRo

<< Masterio >>

Nightw0lf

l2gang

marwan

<< Masterio >>

l2gang

<< Masterio >>

<< Masterio >>

`Sanctus

Dante44®

Posts

Topics

Browse

Activity

Store