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

    • ElmoreLab Harbor - Eternal C1 x1: ✅ https://harbor.elmorelab.com ElmoreLab Harbor - Eternal C1 x1 - is an exclusive server of the Eternal C1 chronicles from the top project ElmoreLab Harbor.   A unique server of its kind, on which everyone will have maximum pleasure, such as oldschool players who dream of nostalgia and to feel the warmest and classic C1 chronicles, as well as experienced players who are tired of thousands unbalanced servers of late chronicles. Due to the professional corrections of the balance system and the HONEST gameplay system - on this server, EVERY player will feel like in their own, warm and cozy Harbor C1. Let's return to the origins of L2 - back to 2004 in C1! ❤️   ⭐ Server characteristics:   STRICTLY 1 window, NO BOXES Bans for RMT and bots/cheats No donations with benefits Unique and high-quality PTS-build from Master Toma Professional corrections and full class-balance Reworked economy and closed all abuses Improved animations and all aspects of the game Exclusive HD-client with high-quality textures Experienced administration and management Fixed all bugs, geodata, exploits and holes Maximum sociality due to the 1-box system Discovering, exploring and researching Big online International server Nostalgia and oldschool-feelings   Rates: x1 Server start: 14.02.2025   The server is at the final stages of development and preparation for release. Information on the server will be updated, soon the patchnotes and changes/edits will be posted. Don't miss the legendary and epic experience on the best server in the last 20 years! ❤️ Join our C1-forum with a lot of information about server and active discussions.   ⭐ Website: https://harbor.elmorelab.com   ✅ Forum: https://forum-harbor.elmorelab.com   💥 Telegram: https://t.me/l2harbor https://t.me/l2harbor_chat   ⚡ Discord: https://discord.gg/harborelmorelab
    • yeah ok, if you say what is fuctional 100% i can't say something different 😛  but if someone find hard to compile it or get vs and all that things i have here one more simple way here to put overlay in your own server or to change your window name with few money.
    • I've been using this for 2 years now with no issues from Discord. I don't use ogg.dll either. This one works with any l2.exe too; I don’t see any difference between them.
    • hmm.. ok i just see that, is different code first of all. My sources is totally different based in other way, with else libraries.  I have access to modify everything even to make the clock to stop show how many time users play in server. 1) so maybe keep some personal info more hide. 2) i dont use ogg.dll 3) i create it and give it ready + support to install it. Plus what is mine can working with what ever .exe you want not just l2 with same simple method. And i am sure if you try this source to compile it, after 3 hours discord will like shadowban your API too thats my source
  • Topics

×
×
  • Create New...