Jump to content

Recommended Posts

Posted

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

Posted

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?

 

Posted

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.

Posted

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

Posted

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.

Posted

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

 

 

Posted

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)

Posted

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

Posted

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)

Guest
This topic is now closed to further replies.



  • Posts

    • 🌐 Works Globally Without VPN: Activate 5TB + Gemini Pro anywhere in the world on your personal Google account in under 60 seconds!     FINAL CALL: Google is Shutting This Down After October 2026! Google will NEVER bring back this window of opportunity again. Once this month ends, this massive backdoor upgrade is gone permanently!  BUY 2, GET 1 FREE IS STILL LIVE! Stock up now for yourself, your family, your business, and your friends! Think about it: Every single person you know uses a Gmail account, and everyone is running out of storage. Don't let your loved ones get trapped paying $20–$30 every single month when you can set them up with 5TB Cloud Storage + Gemini Advanced (12–18 Months) right now for only $15! Why Buy Bulk Activations Today? Instant Gift Value: Perfect lifetime-style gift for clients, family, or team members. 100% Private & Safe: Activates on personal Gmails—zero passwords or logins required. Global Access: Works worldwide with zero VPN hassles. Instant Automated Delivery: Receive your activation links in seconds 24/7! ‍ Time is running out fast—secure your extra free licenses before the October deadline hits! Order Your Bundle Now on the Website
    • The server will officially launch on 2026-10-24, at 10:00 AM (GMT+3).
    • L2OFF Vanganth Gracia Final P110 [Experimental Pre-Alpha] Hello everyone! I would like to share some early gameplay footage of my L2OFF Vanganth Gracia Final P110 project. The project is currently in Experimental Pre-Alpha development. Many systems have already been implemented or adapted to Protocol 110, but there is still a lot of work and testing to be done.   Current Development Progress: Character creation, login and gameplay Character movement, combat and skills NPCs, monsters and basic interactions Inventory, equipment and visual effects Clan and party systems Warehouse and freight systems NPC shops, multisell and trading Mail system Pets and summons Skill Enchant and Ability system Fishing, quests and other gameplay features Various additional features and improvements Please note: Not all features are fully functional yet. Some systems are still incomplete, and bugs or unexpected issues are expected. This is an early experimental project, and a lot more testing, fixes and improvements are required before it can be considered stable.   Gameplay Preview #1       Gameplay Preview #2     More updates and gameplay previews will be shared as development continues.   Project Status: Experimental Pre-Alpha Platform: L2OFF Vanganth Gracia Final Client Protocol: P110 (Grand Crusade) Thanks for watching!
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..