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

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?

 

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.

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

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

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.

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

Work in Freya?

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

 

 

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

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)

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 tell me Mysql version, project (l2j H5 , Freya , IL other?).

 

I updated some sql procedures and tables.

Check and report,

 

v2.9.8 added.

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)

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