Kalispera 8elo na me help me tin vote manager den mou doulevi to hopzone to topzone einai ok kati exi to hopzone sas dixno ta codes mou mimpos exo la8os egw L2jFrozen Exo
Extensions.Vote.DDSConverter.java
package Extensions.Vote;
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.IOException;
import java.nio.ByteBuffer;
import java.nio.ByteOrder;
import java.util.logging.Logger;
import javax.imageio.ImageIO;
public class DDSConverter
{
public static final Logger log = Logger.getLogger(DDSConverter.class.getName());
protected static class Color
{
@Override
public boolean equals(Object obj)
{
if (this == obj)
{
return true;
}
if ((obj == null) || (getClass() != obj.getClass()))
{
return false;
}
Color color = (Color) obj;
if (b != color.b)
{
return false;
}
if (g != color.g)
{
return false;
}
return r == color.r;
}
@Override
public int hashCode()
{
int i = r;
i = (29 * i) + g;
i = (29 * i) + b;
return i;
}
protected int r;
protected int g;
protected int b;
public Color()
{
r = g = b = 0;
}
public Color(int i, int j, int k)
{
r = i;
g = j;
b = k;
}
}
public static ByteBuffer convertToDDS(File file) throws IOException
{
if (file == null)
{
String s = "nullValue.FileIsNull";
log.severe(s);
throw new IllegalArgumentException(s);
}
if (!file.exists() || !file.canRead())
{
String s1 = "DDSConverter.NoFileOrNoPermission";
log.severe(s1);
throw new IllegalArgumentException(s1);
}
BufferedImage bufferedimage = ImageIO.read(file);
if (bufferedimage == null)
{
return null;
}
if (bufferedimage.getColorModel().hasAlpha())
{
return convertToDxt3(bufferedimage);
}
return convertToDxt1NoTransparency(bufferedimage);
}
public static ByteBuffer convertToDxt1NoTransparency(BufferedImage bufferedimage)
{
if (bufferedimage == null)
{
return null;
}
int ai[] = new int[16];
int i = 128 + ((bufferedimage.getWidth() * bufferedimage.getHeight()) / 2);
ByteBuffer bytebuffer = ByteBuffer.allocate(i);
bytebuffer.order(ByteOrder.LITTLE_ENDIAN);
buildHeaderDxt1(bytebuffer, bufferedimage.getWidth(), bufferedimage.getHeight());
int j = bufferedimage.getWidth() / 4;
int k = bufferedimage.getHeight() / 4;
for (int l = 0; l < k; l++)
{
for (int i1 = 0; i1 < j; i1++)
{
BufferedImage bufferedimage1 = bufferedimage.getSubimage(i1 * 4, l * 4, 4, 4);
bufferedimage1.getRGB(0, 0, 4, 4, ai, 0, 4);
Color acolor[] = getColors888(ai);
for (int j1 = 0; j1 < ai.length; j1++)
{
ai[j1] = getPixel565(acolor[j1]);
acolor[j1] = getColor565(ai[j1]);
}
int ai1[] = determineExtremeColors(acolor);
if (ai[ai1[0]] < ai[ai1[1]])
{
int k1 = ai1[0];
ai1[0] = ai1[1];
ai1[1] = k1;
}
bytebuffer.putShort((short) ai[ai1[0]]);
bytebuffer.putShort((short) ai[ai1[1]]);
long l1 = computeBitMask(acolor, ai1);
bytebuffer.putInt((int) l1);
}
}
return bytebuffer;
}
public static ByteBuffer convertToDxt3(BufferedImage bufferedimage)
{
if (bufferedimage == null)
{
return null;
}
if (!bufferedimage.getColorModel().hasAlpha())
{
return convertToDxt1NoTransparency(bufferedimage);
}
int ai[] = new int[16];
int i = 128 + (bufferedimage.getWidth() * bufferedimage.getHeight());
ByteBuffer bytebuffer = ByteBuffer.allocate(i);
bytebuffer.order(ByteOrder.LITTLE_ENDIAN);
buildHeaderDxt3(bytebuffer, bufferedimage.getWidth(), bufferedimage.getHeight());
int j = bufferedimage.getWidth() / 4;
int k = bufferedimage.getHeight() / 4;
for (int l = 0; l < k; l++)
{
for (int i1 = 0; i1 < j; i1++)
{
BufferedImage bufferedimage1 = bufferedimage.getSubimage(i1 * 4, l * 4, 4, 4);
bufferedimage1.getRGB(0, 0, 4, 4, ai, 0, 4);
Color acolor[] = getColors888(ai);
for (int j1 = 0; j1 < ai.length; j1 += 2)
{
bytebuffer.put((byte) ((ai[j1] >>> 28) | (ai[j1 + 1] >>> 24)));
}
for (int k1 = 0; k1 < ai.length; k1++)
{
ai[k1] = getPixel565(acolor[k1]);
acolor[k1] = getColor565(ai[k1]);
}
int ai1[] = determineExtremeColors(acolor);
if (ai[ai1[0]] < ai[ai1[1]])
{
int l1 = ai1[0];
ai1[0] = ai1[1];
ai1[1] = l1;
}
bytebuffer.putShort((short) ai[ai1[0]]);
bytebuffer.putShort((short) ai[ai1[1]]);
long l2 = computeBitMask(acolor, ai1);
bytebuffer.putInt((int) l2);
}
}
return bytebuffer;
}
protected static void buildHeaderDxt1(ByteBuffer bytebuffer, int i, int j)
{
bytebuffer.rewind();
bytebuffer.put((byte) 68);
bytebuffer.put((byte) 68);
bytebuffer.put((byte) 83);
bytebuffer.put((byte) 32);
bytebuffer.putInt(124);
int k = 0xa1007;
bytebuffer.putInt(k);
bytebuffer.putInt(j);
bytebuffer.putInt(i);
bytebuffer.putInt((i * j) / 2);
bytebuffer.putInt(0);
bytebuffer.putInt(0);
bytebuffer.position(bytebuffer.position() + 44);
bytebuffer.putInt(32);
bytebuffer.putInt(4);
bytebuffer.put((byte) 68);
bytebuffer.put((byte) 88);
bytebuffer.put((byte) 84);
bytebuffer.put((byte) 49);
bytebuffer.putInt(0);
bytebuffer.putInt(0);
bytebuffer.putInt(0);
bytebuffer.putInt(0);
bytebuffer.putInt(0);
bytebuffer.putInt(4096);
bytebuffer.putInt(0);
bytebuffer.position(bytebuffer.position() + 12);
}
protected static void buildHeaderDxt3(ByteBuffer bytebuffer, int i, int j)
{
bytebuffer.rewind();
bytebuffer.put((byte) 68);
bytebuffer.put((byte) 68);
bytebuffer.put((byte) 83);
bytebuffer.put((byte) 32);
bytebuffer.putInt(124);
int k = 0xa1007;
bytebuffer.putInt(k);
bytebuffer.putInt(j);
bytebuffer.putInt(i);
bytebuffer.putInt(i * j);
bytebuffer.putInt(0);
bytebuffer.putInt(0);
bytebuffer.position(bytebuffer.position() + 44);
bytebuffer.putInt(32);
bytebuffer.putInt(4);
bytebuffer.put((byte) 68);
bytebuffer.put((byte) 88);
bytebuffer.put((byte) 84);
bytebuffer.put((byte) 51);
bytebuffer.putInt(0);
bytebuffer.putInt(0);
bytebuffer.putInt(0);
bytebuffer.putInt(0);
bytebuffer.putInt(0);
bytebuffer.putInt(4096);
bytebuffer.putInt(0);
bytebuffer.position(bytebuffer.position() + 12);
}
protected static int[] determineExtremeColors(Color acolor[])
{
int i = 0x80000000;
int ai[] = new int[2];
for (int j = 0; j < (acolor.length - 1); j++)
{
for (int k = j + 1; k < acolor.length; k++)
{
int l = distance(acolor[j], acolor[k]);
if (l > i)
{
i = l;
ai[0] = j;
ai[1] = k;
}
}
}
return ai;
}
protected static long computeBitMask(Color acolor[], int ai[])
{
Color acolor1[] =
{
null,
null,
new Color(),
new Color()
};
acolor1[0] = acolor[ai[0]];
acolor1[1] = acolor[ai[1]];
if (acolor1[0].equals(acolor1[1]))
{
return 0L;
}
acolor1[2].r = ((2 * acolor1[0].r) + acolor1[1].r + 1) / 3;
acolor1[2].g = ((2 * acolor1[0].g) + acolor1[1].g + 1) / 3;
acolor1[2].b = ((2 * acolor1[0].b) + acolor1[1].b + 1) / 3;
acolor1[3].r = (acolor1[0].r + (2 * acolor1[1].r) + 1) / 3;
acolor1[3].g = (acolor1[0].g + (2 * acolor1[1].g) + 1) / 3;
acolor1[3].b = (acolor1[0].b + (2 * acolor1[1].b) + 1) / 3;
long l = 0L;
for (int i = 0; i < acolor.length; i++)
{
int j = 0x7fffffff;
int k = 0;
for (int i1 = 0; i1 < acolor1.length; i1++)
{
int j1 = distance(acolor[i], acolor1[i1]);
if (j1 < j)
{
j = j1;
k = i1;
}
}
l |= k << (i * 2);
}
return l;
}
protected static int getPixel565(Color color)
{
int i = color.r >> 3;
int j = color.g >> 2;
int k = color.b >> 3;
return (i << 11) | (j << 5) | k;
}
protected static Color getColor565(int i)
{
Color color = new Color();
color.r = (int) (i & 63488L) >> 11;
color.g = (int) (i & 2016L) >> 5;
color.b = (int) (i & 31L);
return color;
}
protected static Color[] getColors888(int ai[])
{
Color acolor[] = new Color[ai.length];
for (int i = 0; i < ai.length; i++)
{
acolor[i] = new Color();
acolor[i].r = (int) (ai[i] & 0xff0000L) >> 16;
acolor[i].g = (int) (ai[i] & 65280L) >> 8;
acolor[i].b = (int) (ai[i] & 255L);
}
return acolor;
}
protected static int distance(Color color, Color color1)
{
return ((color1.r - color.r) * (color1.r - color.r)) + ((color1.g - color.g) * (color1.g - color.g)) + ((color1.b - color.b) * (color1.b - color.b));
}
}
Extensions.Vote.Votemanager.java
/*
* This program is free software: you can redistribute it and/or modify it under
* the terms of the GNU General Public License as published by the Free Software
* Foundation, either version 3 of the License, or (at your option) any later
* version.
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
* details.
* You should have received a copy of the GNU General Public License along with
* this program. If not, see <http://www.gnu.org/licenses/>.
*/
package Extensions.Vote;
import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.URL;
import java.net.URLConnection;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.logging.Level;
import java.util.logging.Logger;
import Extensions.Vote.Tasks.MonthlyResetTask;
import Extensions.Vote.Tasks.TriesResetTask;
import com.l2jfrozen.Config;
import com.l2jfrozen.gameserver.thread.ThreadPoolManager;
import com.l2jfrozen.gameserver.model.L2World;
import com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance;
import com.l2jfrozen.util.database.L2DatabaseFactory;
public class VoteManager
{
protected static final Logger _log = Logger.getLogger(VoteManager.class.getName());
private static boolean hasVotedHop;
private static boolean hasVotedTop;
public VoteManager()
{
}
public static void load()
{
_log.log(Level.INFO, "VoteManager: initialized.");
TriesResetTask.getInstance();
MonthlyResetTask.getInstance();
}
protected static int getHopZoneVotes()
{
int votes = -1;
String Hopzonelink = Config.VOTE_LINK_HOPZONE;
InputStreamReader isr = null;
BufferedReader br = null;
try
{
URLConnection con = new URL(Hopzonelink).openConnection();
con.addRequestProperty("User-L2Hopzone", "Mozilla/4.76");
isr = new InputStreamReader(con.getInputStream());
br = new BufferedReader(isr);
String line;
while ((line = br.readLine()) != null)
{
if (line.contains("rank anonymous tooltip"))
{
votes = Integer.valueOf(line.split(">")[2].replace("</span", ""));
break;
}
}
br.close();
isr.close();
}
catch (Exception e)
{
if (Config.DEVELOPER)
{
e.printStackTrace();
}
}
return votes;
}
protected static int getTopZoneVotes()
{
int votes = -1;
URL url = null;
URLConnection con = null;
InputStream is = null;
InputStreamReader isr = null;
BufferedReader in = null;
try
{
url = new URL(Config.VOTE_LINK_TOPZONE);
con = url.openConnection();
con.addRequestProperty("User-Agent", "L2TopZone");
is = con.getInputStream();
isr = new InputStreamReader(is);
in = new BufferedReader(isr);
String inputLine;
while ((inputLine = in.readLine()) != null)
{
if (inputLine.contains("Votes"))
{
String votesLine = inputLine;
votes = Integer.valueOf(votesLine.split(">")[3].replace("</div", ""));
break;
}
}
}
catch (Exception e)
{
if (Config.DEVELOPER)
{
e.printStackTrace();
}
}
return votes;
}
public static String hopCd(L2PcInstance player)
{
long hopCdMs = 0;
long voteDelay = 43200000L;
PreparedStatement statement = null;
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("SELECT lastVoteHopzone FROM characters WHERE obj_Id=?");
statement.setInt(1, player.getObjectId());
ResultSet rset = statement.executeQuery();
while (rset.next())
{
hopCdMs = rset.getLong("lastVoteHopzone");
}
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
SimpleDateFormat sdf = new SimpleDateFormat("MMM dd,yyyy HH:mm");
Date resultdate = new Date(hopCdMs + voteDelay);
return sdf.format(resultdate);
}
public static String topCd(L2PcInstance player)
{
long topCdMs = 0;
long voteDelay = 43200000L;
PreparedStatement statement = null;
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("SELECT lastVoteTopzone FROM characters WHERE obj_Id=?");
statement.setInt(1, player.getObjectId());
ResultSet rset = statement.executeQuery();
while (rset.next())
{
topCdMs = rset.getLong("lastVoteTopzone");
}
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
SimpleDateFormat sdf = new SimpleDateFormat("MMM dd,yyyy HH:mm");
Date resultdate = new Date(topCdMs + voteDelay);
return sdf.format(resultdate);
}
public static String whosVoting()
{
for (L2PcInstance voter : L2World.getInstance().getAllPlayers())
{
if (voter.isVoting())
{
return voter.getName();
}
}
return "None";
}
public static void hopvote(final L2PcInstance player)
{
long lastVoteHopzone = 0L;
long voteDelay = 43200000L;
final int firstvoteshop;
firstvoteshop = getHopZoneVotes();
class hopvotetask implements Runnable
{
private final L2PcInstance p;
public hopvotetask(L2PcInstance player)
{
p = player;
}
@Override
public void run()
{
if (firstvoteshop < getHopZoneVotes())
{
p.setIsVoting(false);
p.setIsImobilised(false);
VoteManager.setHasVotedHop(player);
p.sendMessage("Thank you for voting for us!");
VoteManager.updateLastVoteHopzone(p);
VoteManager.updateVotes(p);
}
else
{
p.setIsVoting(false);
p.setIsImobilised(false);
p.sendMessage("You did not vote.Please try again.");
VoteManager.setTries(player, VoteManager.getTries(p) - 1);
}
}
}
PreparedStatement statement = null;
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("SELECT lastVoteHopzone FROM characters WHERE obj_Id=?");
statement.setInt(1, player.getObjectId());
ResultSet rset = statement.executeQuery();
while (rset.next())
{
lastVoteHopzone = rset.getLong("lastVoteHopzone");
}
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
if (getTries(player) <= 0)
{
player.sendMessage("Due to your multiple failures in voting you lost your chance to vote today");
}
else if (((lastVoteHopzone + voteDelay) < System.currentTimeMillis()) && (getTries(player) > 0))
{
for (L2PcInstance j : L2World.getInstance().getAllPlayers())
{
if (j.isVoting())
{
player.sendMessage("Someone is already voting.Wait for your turn please!");
return;
}
}
player.setIsVoting(true);
player.setIsImobilised(true);
player.sendMessage("Go fast on the site and vote on the hopzone banner!");
player.sendMessage("You have " + Config.SECS_TO_VOTE + " seconds.Hurry!");
ThreadPoolManager.getInstance().scheduleGeneral(new hopvotetask(player), Config.SECS_TO_VOTE * 1000);
}
else if ((getTries(player) <= 0) && ((lastVoteHopzone + voteDelay) < System.currentTimeMillis()))
{
for (L2PcInstance j : L2World.getInstance().getAllPlayers())
{
if (j.isVoting())
{
player.sendMessage("Someone is already voting.Wait for your turn please!");
return;
}
}
player.setIsVoting(true);
player.setIsImobilised(true);
player.sendMessage("Go fast on the site and vote on the hopzone banner!");
player.sendMessage("You have " + Config.SECS_TO_VOTE + " seconds.Hurry!");
ThreadPoolManager.getInstance().scheduleGeneral(new hopvotetask(player), Config.SECS_TO_VOTE * 1000);
}
else
{
player.sendMessage("12 hours have to pass till you are able to vote again.");
}
}
public static void topvote(final L2PcInstance player)
{
long lastVoteTopzone = 0L;
long voteDelay = 43200000L;
final int firstvotestop;
firstvotestop = getTopZoneVotes();
class topvotetask implements Runnable
{
private final L2PcInstance p;
public topvotetask(L2PcInstance player)
{
p = player;
}
@Override
public void run()
{
if (firstvotestop < getTopZoneVotes())
{
p.setIsVoting(false);
p.setIsImobilised(false);
VoteManager.setHasVotedTop(p);
p.sendMessage("Thank you for voting for us!");
VoteManager.updateLastVoteTopzone(p);
VoteManager.updateVotes(p);
}
else
{
p.setIsVoting(false);
p.setIsImobilised(false);
p.sendMessage("You did not vote.Please try again.");
VoteManager.setTries(p, VoteManager.getTries(p) - 1);
}
}
}
PreparedStatement statement = null;
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("SELECT lastVoteTopzone FROM characters WHERE obj_Id=?");
statement.setInt(1, player.getObjectId());
ResultSet rset = statement.executeQuery();
while (rset.next())
{
lastVoteTopzone = rset.getLong("lastVoteTopzone");
}
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
if (getTries(player) <= 0)
{
player.sendMessage("Due to your multiple failures in voting you lost your chance to vote today");
}
else if ((getTries(player) <= 0) && ((lastVoteTopzone + voteDelay) < System.currentTimeMillis()))
{
for (L2PcInstance j : L2World.getInstance().getAllPlayers())
{
if (j.isVoting())
{
player.sendMessage("Someone is already voting.Wait for your turn please!");
return;
}
}
player.setIsVoting(true);
player.setIsImobilised(true);
player.sendMessage("Go fast on the site and vote on the topzone banner!");
player.sendMessage((new StringBuilder()).append("You have ").append(Config.SECS_TO_VOTE).append(" seconds.Hurry!").toString());
ThreadPoolManager.getInstance().scheduleGeneral(new topvotetask(player), Config.SECS_TO_VOTE * 1000);
}
else if (((lastVoteTopzone + voteDelay) < System.currentTimeMillis()) && (getTries(player) > 0))
{
for (L2PcInstance j : L2World.getInstance().getAllPlayers())
{
if (j.isVoting())
{
player.sendMessage("Someone is already voting.Wait for your turn please!");
return;
}
}
player.setIsVoting(true);
player.setIsImobilised(true);
player.sendMessage("Go fast on the site and vote on the topzone banner!");
player.sendMessage((new StringBuilder()).append("You have ").append(Config.SECS_TO_VOTE).append(" seconds.Hurry!").toString());
ThreadPoolManager.getInstance().scheduleGeneral(new topvotetask(player), Config.SECS_TO_VOTE * 1000);
}
else
{
player.sendMessage("12 hours have to pass till you are able to vote again.");
}
}
public static void hasVotedHop(L2PcInstance player)
{
int hasVotedHop = -1;
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("SELECT hasVotedHop FROM characters WHERE obj_Id=?");
statement.setInt(1, player.getObjectId());
ResultSet rset = statement.executeQuery();
while (rset.next())
{
hasVotedHop = rset.getInt("hasVotedHop");
}
if (hasVotedHop == 1)
{
setHasVotedHop(true);
}
else if (hasVotedHop == 0)
{
setHasVotedHop(false);
}
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
}
public static void hasVotedTop(L2PcInstance player)
{
int hasVotedTop = -1;
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("SELECT hasVotedTop FROM characters WHERE obj_Id=?");
statement.setInt(1, player.getObjectId());
ResultSet rset = statement.executeQuery();
while (rset.next())
{
hasVotedTop = rset.getInt("hasVotedTop");
}
if (hasVotedTop == 1)
{
setHasVotedTop(true);
}
else if (hasVotedTop == 0)
{
setHasVotedTop(false);
}
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
}
public static void updateVotes(L2PcInstance activeChar)
{
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("UPDATE characters SET monthVotes=?, totalVotes=? WHERE obj_Id=?");
statement.setInt(1, getMonthVotes(activeChar) + 1);
statement.setInt(2, getTotalVotes(activeChar) + 1);
statement.setInt(3, activeChar.getObjectId());
statement.execute();
statement.close();
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
}
public static void setHasVotedHop(L2PcInstance activeChar)
{
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("UPDATE characters SET hasVotedHop=? WHERE obj_Id=?");
statement.setInt(1, 1);
statement.setInt(2, activeChar.getObjectId());
statement.execute();
statement.close();
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
}
public static void setHasVotedTop(L2PcInstance activeChar)
{
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("UPDATE characters SET hasVotedTop=? WHERE obj_Id=?");
statement.setInt(1, 1);
statement.setInt(2, activeChar.getObjectId());
statement.execute();
statement.close();
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
}
public static void setHasNotVotedHop(L2PcInstance activeChar)
{
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("UPDATE characters SET hasVotedHop=? WHERE obj_Id=?");
statement.setInt(1, 0);
statement.setInt(2, activeChar.getObjectId());
statement.execute();
statement.close();
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
}
public static void setHasNotVotedTop(L2PcInstance activeChar)
{
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("UPDATE characters SET hasVotedTop=? WHERE obj_Id=?");
statement.setInt(1, 0);
statement.setInt(2, activeChar.getObjectId());
statement.execute();
statement.close();
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
}
public static int getTries(L2PcInstance player)
{
int tries = -1;
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("SELECT tries FROM characters WHERE obj_Id=?");
statement.setInt(1, player.getObjectId());
for (ResultSet rset = statement.executeQuery(); rset.next();)
{
tries = rset.getInt("tries");
}
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
return tries;
}
public static void setTries(L2PcInstance player, int tries)
{
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("UPDATE characters SET tries=? WHERE obj_Id=?");
statement.setInt(1, tries);
statement.setInt(2, player.getObjectId());
statement.execute();
statement.close();
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
}
public static int getMonthVotes(L2PcInstance player)
{
int monthVotes = -1;
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("SELECT monthVotes FROM characters WHERE obj_Id=?");
statement.setInt(1, player.getObjectId());
for (ResultSet rset = statement.executeQuery(); rset.next();)
{
monthVotes = rset.getInt("monthVotes");
}
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
return monthVotes;
}
public static int getTotalVotes(L2PcInstance player)
{
int totalVotes = -1;
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("SELECT totalVotes FROM characters WHERE obj_Id=?");
statement.setInt(1, player.getObjectId());
for (ResultSet rset = statement.executeQuery(); rset.next();)
{
totalVotes = rset.getInt("totalVotes");
}
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
return totalVotes;
}
public static int getBigTotalVotes(L2PcInstance player)
{
int bigTotalVotes = -1;
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("SELECT SUM(totalVotes) FROM characters");
for (ResultSet rset = statement.executeQuery(); rset.next();)
{
bigTotalVotes = rset.getInt("SUM(totalVotes)");
}
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
return bigTotalVotes;
}
public static int getBigMonthVotes(L2PcInstance player)
{
int bigMonthVotes = -1;
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("SELECT SUM(monthVotes) FROM characters");
for (ResultSet rset = statement.executeQuery(); rset.next();)
{
bigMonthVotes = rset.getInt("SUM(monthVotes)");
}
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
return bigMonthVotes;
}
public static void updateLastVoteHopzone(L2PcInstance player)
{
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("UPDATE characters SET lastVoteHopzone=? WHERE obj_Id=?");
statement.setLong(1, System.currentTimeMillis());
statement.setInt(2, player.getObjectId());
statement.execute();
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
}
public static void updateLastVoteTopzone(L2PcInstance player)
{
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("UPDATE characters SET lastVoteTopzone=? WHERE obj_Id=?");
statement.setLong(1, System.currentTimeMillis());
statement.setInt(2, player.getObjectId());
statement.execute();
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
}
// Getters and Setters
public static boolean hasVotedHop()
{
return hasVotedHop;
}
public static void setHasVotedHop(boolean hasVotedHop)
{
VoteManager.hasVotedHop = hasVotedHop;
}
public static boolean hasVotedTop()
{
return hasVotedTop;
}
public static void setHasVotedTop(boolean hasVotedTop)
{
VoteManager.hasVotedTop = hasVotedTop;
}
}
Extensions.vote.VoteConfig.java
/*
* This program is free software: you can redistribute it and/or modify it under
* the terms of the GNU General Public License as published by the Free Software
* Foundation, either version 3 of the License, or (at your option) any later
* version.
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
* details.
* You should have received a copy of the GNU General Public License along with
* this program. If not, see <http://www.gnu.org/licenses/>.
*/
package Extensions.Vote;
public class VoteConfig
{
public VoteConfig()
{
}
}
Extensions.Vote.Tasks.MonthlyResetTask.java
/*
* This program is free software: you can redistribute it and/or modify it under
* the terms of the GNU General Public License as published by the Free Software
* Foundation, either version 3 of the License, or (at your option) any later
* version.
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
* details.
* You should have received a copy of the GNU General Public License along with
* this program. If not, see <http://www.gnu.org/licenses/>.
*/
package Extensions.Vote.Tasks;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Calendar;
import java.util.logging.Level;
import java.util.logging.Logger;
import com.l2jfrozen.Config;
import com.l2jfrozen.gameserver.thread.ThreadPoolManager;
import com.l2jfrozen.util.database.L2DatabaseFactory;
public class MonthlyResetTask
{
protected static final Logger _log = Logger.getLogger(MonthlyResetTask.class.getName());
public MonthlyResetTask()
{
}
public static void getInstance()
{
ThreadPoolManager.getInstance().scheduleGeneral(new Runnable()
{
@Override
public void run()
{
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("UPDATE characters SET monthVotes=?");
statement.setInt(1, 0);
statement.execute();
statement.close();
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
}
}, getValidationTime());
}
private static long getValidationTime()
{
Calendar cld = Calendar.getInstance();
cld.set(5, 1);
long time = cld.getTimeInMillis();
if ((System.currentTimeMillis() - time) <= 0L)
{
long delay = cld.getTimeInMillis() - System.currentTimeMillis();
return delay;
}
return 0L;
}
}
Extensions.Vote.Tasks.TriesResetTask.java
/*
* This program is free software: you can redistribute it and/or modify it under
* the terms of the GNU General Public License as published by the Free Software
* Foundation, either version 3 of the License, or (at your option) any later
* version.
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
* details.
* You should have received a copy of the GNU General Public License along with
* this program. If not, see <http://www.gnu.org/licenses/>.
*/
package Extensions.Vote.Tasks;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Calendar;
import java.util.logging.Level;
import java.util.logging.Logger;
import com.l2jfrozen.Config;
import com.l2jfrozen.gameserver.thread.ThreadPoolManager;
import com.l2jfrozen.util.database.L2DatabaseFactory;
public class TriesResetTask
{
protected static final Logger _log = Logger.getLogger(TriesResetTask.class.getName());
public TriesResetTask()
{
}
public static void getInstance()
{
ThreadPoolManager.getInstance().scheduleGeneral(new Runnable()
{
@Override
public void run()
{
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("UPDATE characters SET tries=?");
statement.setInt(1, 3);
statement.execute();
statement.close();
}
catch (Exception e)
{
_log.warning(" ");
}
finally
{
try
{
if (con != null)
con.close();
}
catch (SQLException e)
{
_log.warning("Failed to close database connection!");
}
}
}
}, getValidationTime());
}
private static long getValidationTime()
{
Calendar cld = Calendar.getInstance();
cld.set(11, 12);
cld.set(12, 1);
long time = cld.getTimeInMillis();
if ((System.currentTimeMillis() - time) <= 0L)
{
long delay = cld.getTimeInMillis() - System.currentTimeMillis();
return delay;
}
return 0L;
}
}
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
I'm just testing the extender) I couldn't find any critical issues.
I found my own error due to which the autoloot function was not active:
just a syntax error, case-sensitive. You can't use a capital letter in the Myext.ini settings.
AutoLootMobDrop = true. (parameter true must necessarily be with a lowercase letter)
DISCORD :
utchiha_market
telegram :
https://t.me/utchiha_market
SELLIX STORE :
https://utchihamkt.mysellix.io/
Join our server for more products :
https://discord.gg/hood-services
https://campsite.bio/utchihaamkt
I had a similar problem once when I was setting up a custom shop system in a game. For me, the fix was buried in the database settings. I had to adjust the stack limit for the item in the MySQL database, which allowed bulk purchases without triggering errors. You might want to check the item_template or a similar table for stackable values.
As for inspiration, I once played around with a different setup for fun using https://themulligans.org. While it’s an online casino, their sleek inventory and transaction systems gave me some cool ideas for designing in-game economies.
Question
CTGavesT
Kalispera 8elo na me help me tin vote manager den mou doulevi to hopzone to topzone einai ok kati exi to hopzone sas dixno ta codes mou mimpos exo la8os egw L2jFrozen Exo
Extensions.Vote.DDSConverter.java
Extensions.Vote.Votemanager.java
Extensions.vote.VoteConfig.java
Extensions.Vote.Tasks.MonthlyResetTask.java
Extensions.Vote.Tasks.TriesResetTask.java
com.l2jfrozen.gameserver.model.actor.instance.L2VoteManagerInstance.java
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.