TGSLineage2

First it is necessary to know if what you need is to recover one or several values, if you need several then you must add the values of the result in a list but the following form: while(rs.next()){ list.add(rs.getString("name")); } And if you only need to retrieve a single value which is what I assume you want to do, you should limit your result to a by placing at the end of your query Limit 1 And you could put your assignment like this: x = (rs.getString("name") != null) ? rs.getString("name") : "None";

You were invoking the parse Data method to fill the Map from the xml every time you made the query of the icon for its key, the first thing if it could have reduced the performance of your server.

According to the graph you show, in the first case the connection is made from the vps to the main server, that is, the intermediary makes the request for you, waits, the answer and then gives it to you, then at the end the time in which the answer arrives at the client is the sum of both, although for the client the response ping that will be seen in the client will be between the client and the proxy if I am not mistaken, although it does not seem to be the real one, someone understands how the second case works, anyone can explain it ?

Hello @everyone, apparently the problem of undefined claims has been generated by a bad calculation of the remaining times, so to correct this, you must go to: votesystem.Handler.VoteManager and search public long getTimeRemaining (individualVote iv) and replace the old method with this: public long getTimeRemaining (individualVote iv) { long timeRemaining = 0L; timeRemaining = ((iv.getVotingTimeSite () + Config.INTERVAL_TO_NEXT_VOTE) - ((iv.getDiffTime ()> 0)? (System.currentTimeMillis () + iv.getDiffTime ()): (System.currentTimeMillis () - iv.getDiffTime () - iv.getDiffTime ()))); System.out.println ("Remaining time:" + timeRemaining); return timeRemaining; }

In its error it says that parameter 5 has not been specified and that is true because you are only sending 4 Well, according to the code that you have shown, you are calling a store procedure that recive apparently 5 parameters and you are only sending 4 and that is why it is possibly giving you the error in the console

check the number of parameters of this SP sellbuff_saveSellerData What does this method do? OfflineTradeTable.storeOffliners (); Are you sure it works smoothly? check that if it is running with an alert in the console

To save or update you can create a button that calls a save method in the database, and to automatically save after a reboot or shutdown, you must go to the shutdown class and call the save method of the buff, that will be the same used for the buttom, for the error in console, check the number of parameters of your stored procedure that you are calling.

Update for L2Mythras (2017.07.12) https://pastebin.com/yTKnHpDD

Great, thanks.

L2jMobius High-Five https://pastebin.com/aYvSZVC8

Show me your error console so I can help you.

Hello everyone, I wanted to inform you that I have made a few adjustments to the voting system in which the validation of the votes has been corrected and the issue of multiple claims that sometimes occurred in the voting system, also add the adaptation of the system to package l2jfrozen 1132 https://pastebin.com/YczLkpUp I will be making the adaptation to all the chronicles of L2JMobius, L2Mythras, if anyone has any suggestion of a known and open source package that has not yet been adapted let me know.

Exact.

if you are using a current version of mysql you should use mysqli_connect function.

I guess it can fit any l2j simulator

Is a randomly generated code less efficient than an image? Now that I think about it, maybe you're right.

Or just a captcha with randomly generated characters like I do :)

Ho-ho-ho merry christmas. take the trouble to check my user interface, it is very easy to use.

It seems to me that this is a concurrency error and it occurs when you take the same collection to make modifications to it at the same time from different methods, it could be solved by synchronizing the methods that at some point will take the same collection to work or in the particular case of MAPs declaring it as a concurrentHashMap in the latest java versions.

working with aCis last revision but can work for 380 with some little changes, if need help, contact me on my discord. Fixes

Cast to integer what you are sending, If you get an error like numberformatexception it means that what you are sending is not an integer.

Hello MXC community, the reason for this post is to make you aware of my voting site: https://l2.topgameserver.net, relatively new, additionally add in this forum a voting system for several similar sites, I will be giving free assistance to those who have difficulties in integrating the code into their package, I receive suggestions, we are open to listen to them and thus give them a quality service :) :) You can contact me to my discord: https://discord.com/invite/VbnZbWR

Update for l2jfrozen 1.5 Update for L2JMobius Classic Interlude Update for L2JMobius Interlude https://pastebin.com/1HAX4UbN

Update for L2Jserver H5 Last Revision.

I have created a code to reward for voting on several well-known sites. If someone has difficulty adding this code to their package, they can write to me at my discord https://discord.com/invite/VbnZbWR I will adapt this code for l2jfrozen and l2jserver or for some popular open source package. You can see the code in the following link: aCis: https://pastebin.com/1Wq6GZPs L2JServer H5: https://pastebin.com/KVyPAZ0X L2JFrozen 1.5 Interlude https://pastebin.com/GaAyMMT2 L2JMobius Classic Interlude https://pastebin.com/rJcPsbD4 L2JMobius Interlude https://pastebin.com/1HAX4UbN l2jfrozen 1132 https://pastebin.com/YczLkpUp L2jMobius High-Five https://pastebin.com/aYvSZVC8 L2Mythras (2017.07.12) https://pastebin.com/yTKnHpDD 05/17/2020 - For people who have integrated the voting system, I have made some arrangements to the voting system, it is currently working correctly and stable, the changes are already applied to the sources. http://www.mediafire.com/file/g6kag6pg5zu342h/patch_with_some_fiexes.txt/file