Code Hi5 Vote Reward Configurable [ Topzone - Hopzone ]

drgn · September 21, 2013

i installed all code in latest H5 core version=5816

builddate=25/02/2013 06:00

and i got only one error in AutoVoteRewardHandler also in Shutdown and Gameserver but is the same

package com.l2jserver.gameserver.instancemanager;
    
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.net.URL;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;

import com.l2jserver.gameserver.model.item.instance.L2ItemInstance;
import com.l2jserver.Config;
import com.l2jserver.L2DatabaseFactory;
import com.l2jserver.gameserver.ThreadPoolManager;
import com.l2jserver.gameserver.model.L2World;
import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
import com.l2jserver.gameserver.network.clientpackets.Say2;
import com.l2jserver.gameserver.network.serverpackets.CreatureSay;
import com.l2jserver.gameserver.util.Broadcast;
    
public class AutoVoteRewardHandler
{
  private static Logger _log = Logger.getLogger(AutoVoteRewardHandler.class.getName());
  
  private static final int initialCheck  = 1 * 1000;
  private static final int delayForCheck = Config.DELAY_FOR_NEXT_REWARD * 1000;

  private static int lastVoteCount = 0;
      
  private AutoVoteRewardHandler()
  {
      _log.info("Vote Reward System: Vote reward system initiated.");
      if (Config.VOTE_REWARD_ENABLE)
          load();
      ThreadPoolManager.getInstance().scheduleGeneralAtFixedRate(new AutoReward(), initialCheck, delayForCheck);
  }
      
  private class AutoReward implements Runnable
	{
		@Override
		public void run()
		{
			int votes = getVotes(Config.VOTE_HTML_PATCH);
			System.out.println("Server Votes: " + votes);
			if (votes != 0 && getLastVoteCount() != 0 && votes >= getLastVoteCount() + Config.VOTES_FOR_REWARD)
			{
				Connection con = null;
				try
				{
					con = L2DatabaseFactory.getInstance().getConnection();
					PreparedStatement statement = con.prepareStatement("SELECT c.charId, c.char_name FROM characters AS c LEFT JOIN accounts AS a ON c.account_name = a.login WHERE c.online > 0 GROUP BY a.lastIP ORDER BY c.level DESC");
					ResultSet rset = statement.executeQuery();
					L2PcInstance player = null;
				        L2ItemInstance item = null;
					L2ItemInstance item2 = null;
					while (rset.next())
					{
						player = L2World.getInstance().getPlayer(rset.getInt("charId"));
						if (player != null && !player.getClient().isDetached())
						{
								item = player.getInventory().getItemByItemId(Config.VOTE_REWARD1_ID);
								if (item == null || item.getCount() < Config.MAX_REWARD_COUNT_FOR_STACK_ITEM1)
									player.addItem("reward", Config.VOTE_REWARD1_ID, Config.VOTE_REWARD1_COUNT, player, true);
								item2 = player.getInventory().getItemByItemId(Config.VOTE_REWARD1_ID);
						
								if (item2 == null || item2.getCount() < Config.MAX_REWARD_COUNT_FOR_STACK_ITEM1)
									player.addItem("reward", Config.VOTE_REWARD2_ID, Config.VOTE_REWARD2_COUNT, player, true);
						}
					}
					setLastVoteCount(getLastVoteCount() + Config.VOTES_FOR_REWARD);
					statement.close();
					_log.info("Vote Reward System: Reward for votes now!");
		            Broadcast.toAllOnlinePlayers(new CreatureSay(1, Say2.CRITICAL_ANNOUNCE, "", "Vote Manager: Reward for players! Thanks for Vote."));
			}
				catch (SQLException e)
				{
					e.printStackTrace();
				}
				finally
				{
					L2DatabaseFactory.close(con);
				}
				
				setLastVoteCount(getLastVoteCount() + Config.VOTES_FOR_REWARD);
			}
			Broadcast.toAllOnlinePlayers(new CreatureSay(1, Say2.CRITICAL_ANNOUNCE, "", "Vote Manager: Server votes: " + votes + " | Next Reward on " + (getLastVoteCount() + Config.VOTES_FOR_REWARD) + " Votes."));
			if (getLastVoteCount() == 0)
				setLastVoteCount(votes);
		}
	}
      
  private int getVotes(String urlString)
  {
      URL url = null;
      InputStreamReader isr = null;
      BufferedReader in = null;
      try
      {
          url = new URL(urlString);
          isr = new InputStreamReader(url.openStream());
          in = new BufferedReader(isr);
          String inputLine;
          while ((inputLine = in.readLine()) != null)
          {
        	  if (Config.VOTE_REWARD_TOPZONE_ENABLE)
        	  {
        		  // for TopZone
        		  if (inputLine.contains("<tr><td><div align=\"center\"><b><font style=\"font-size:14px;color:#018BC1;\""))
        		  {
        			  return Integer.valueOf(inputLine.split(">")[5].replace("</font", ""));
        		  }
        	  }
        	  if (Config.VOTE_REWARD_HOPZONE_ENABLE)
       	  {
        		  // for HopZone
        		  if (inputLine.contains("rank anonymous tooltip"))
        		  {
        			  @SuppressWarnings("unused")
        			  int Sub = 12;
        			  switch (inputLine.length())
        			  {
        				  case 116:
        					  Sub = 13; 
        					  break;
        				  case 117:
        					  Sub = 14; 
        					  break;
        				  case 118:
        					  Sub = 15;
        					  break;
        				  case 119:
        					  Sub = 16; 
        					  break;
        			  }
        			  return Integer.valueOf(inputLine.split(">")[2].replace("</span", ""));
        		  }
              }
          }
      }
      catch (IOException e)
      {
          _log.warning("Vote Reward System: "+e);
      }
      finally
      {
          try
          {
              in.close();
          }
          catch (IOException e)
          {}
          try
          {
              isr.close();
          }
          catch (IOException e)
          {}
      }
      return 0;
  }
      
  private void setLastVoteCount(int voteCount)
  {
      lastVoteCount = voteCount;
  }
      
  private int getLastVoteCount()
  {
      return lastVoteCount;
  }
  
  private void load()
  {
      int votes = 0;
      Connection con = null;
      try
      {
          con = L2DatabaseFactory.getInstance().getConnection();
          PreparedStatement statement = con.prepareStatement("SELECT vote FROM votes LIMIT 1");
          ResultSet rset = statement.executeQuery();

          while (rset.next())
          {
              votes = rset.getInt("vote");
          }
          rset.close();
          statement.close();
      }
      catch (Exception e)
      {
          _log.log(Level.WARNING, "data error on vote: ", e);
      }
      finally
      {
          L2DatabaseFactory.close(con);
      }
      
      setLastVoteCount(votes);
  }
  
  public void save()
  {
      Connection con = null;
      try
      {
          con = L2DatabaseFactory.getInstance().getConnection();
          PreparedStatement statement = con.prepareStatement("UPDATE votes SET vote = ? WHERE id=1");
          statement.setInt(1, getLastVoteCount());
          statement.execute();
          statement.close();
      }
      catch (Exception e)
      {
          _log.log(Level.WARNING, "data error on vote: ", e);
      }
      finally
      {
          L2DatabaseFactory.close(con);
      }
  }
  
  public static AutoVoteRewardHandler getInstance()
  {
     return SingletonHolder._instance;
  }
      
  @SuppressWarnings("synthetic-access")
  private static class SingletonHolder
  {
      protected static final AutoVoteRewardHandler _instance = new AutoVoteRewardHandler();
  }
}

that give me error and

import com.l2jserver.gameserver.model.item.instance.L2ItemInstance;

L2ItemInstance item = null;

L2ItemInstance item2 = null;

it says : "Multiple markers at this line

- Occurrence of 'L2ItemInstance'

- L2ItemInstance cannot be resolved

to a type"

how to fix that ?

I had the same error but fixed when save all files ;) and see that import :

import com.l2jserver.gameserver.model.item.instance.L2ItemInstance;

i change it to :

import com.l2jserver.gameserver.model.items.instance.L2ItemInstance;

for my revision.

Other problem was smthing with API i delete this from AutoVoteRewardHandler.java :

finally
{
L2DatabaseFactory.close(con);
}

Edit : The problem with API no fixed problem when server running because connection no close.

Edited September 22, 2013 by drgn

drgn · September 22, 2013

I have problem with AutoVoteSystem !

With topzone i get server votes : 0

and with hopzone i get this error :

My properties file :



# ---------------------------------------------------------------------------

# Vote Reward System

# ---------------------------------------------------------------------------

# Set it "True" if you want to Enable Vote Reward System.

EnableVoteReward = True

 

# If you enable Vote Reward System you must fill your Html Patch.

# e.g. VoteHtmlPatch = http://l2.hopzone.net / http://l2topzone.net

# Html Patch for Your Vote Site

# Works with TopZone & HopZone

 

ServerNameForVotes = ServerName 

VoteHtmlPatch = http://l2.hopzone.net/.... <- Here what? my main hopzone site url?

VoteReward1Count = 5

VoteReward2Count = 2

VoteReward1Id = 9627

VoteReward2Id = 3470

VotesForReward = 10

 

# Max a-beep-t of reward items that you want to stop reward 

# the player that have more than "MaxRewardCountForStack".

MaxRewardCountForStackItem1 = 500

MaxRewardCountForStackItem2 = 500

 

# DelayForNextReward in seconds

DelayForNextReward = 300

 

# Enable TopZone Vote Reward

# Default = False

EnableTopzoneReward = False

 

# Enable HopZone Vote Reward

# Default = False

EnableHopzoneReward = True

My AutoVoteRewardHanlder.java :



package com.l2jserver.gameserver.instancemanager;

 

import java.io.BufferedReader;

import java.io.IOException;

import java.io.InputStreamReader;

import java.net.URL;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.logging.Level;

import java.util.logging.Logger;

 

import com.l2jserver.Config;

import com.l2jserver.L2DatabaseFactory;

import com.l2jserver.gameserver.ThreadPoolManager;

import com.l2jserver.gameserver.model.L2World;

import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;

import com.l2jserver.gameserver.model.items.instance.L2ItemInstance;

import com.l2jserver.gameserver.network.clientpackets.Say2;

import com.l2jserver.gameserver.network.serverpackets.CreatureSay;

import com.l2jserver.gameserver.util.Broadcast;

 

public class AutoVoteRewardHandler

{

    private static Logger _log = Logger.getLogger(AutoVoteRewardHandler.class.getName());

    

    private static final int initialCheck = 1 * 1000;

    private static final int delayForCheck = Config.DELAY_FOR_NEXT_REWARD * 1000;

    

    private static int lastVoteCount = 0;

    

    private AutoVoteRewardHandler()

    {

        _log.info("Vote Reward System: Vote reward system initiated.");

        if (Config.VOTE_REWARD_ENABLE)

        {

            load();

        }

        ThreadPoolManager.getInstance().scheduleGeneralAtFixedRate(new AutoReward(), initialCheck, delayForCheck);

    }

    

    private class AutoReward implements Runnable

    {

        @Override

        public void run()

        {

            int votes = getVotes(Config.VOTE_HTML_PATCH);

            System.out.println("Server Votes: " + votes);

            if ((votes != 0) && (getLastVoteCount() != 0) && (votes >= (getLastVoteCount() + Config.VOTES_FOR_REWARD)))

            {

                Connection con = null;

                try

                {

                    con = L2DatabaseFactory.getInstance().getConnection();

                    PreparedStatement statement = con.prepareStatement("SELECT c.charId, c.char_name FROM characters AS c LEFT JOIN accounts AS a ON c.account_name = a.login WHERE c.online > 0 GROUP BY a.lastIP ORDER BY c.level DESC");

                    ResultSet rset = statement.executeQuery();

                    L2PcInstance player = null;

                    L2ItemInstance item = null;

                    L2ItemInstance item2 = null;

                    while (rset.next())

                    {

                        player = L2World.getInstance().getPlayer(rset.getInt("charId"));

                        if ((player != null) && !player.getClient().isDetached())

                        {

                            item = player.getInventory().getItemByItemId(Config.VOTE_REWARD1_ID);

                            if ((item == null) || (item.getCount() < Config.MAX_REWARD_COUNT_FOR_STACK_ITEM1))

                            {

                                player.addItem("reward", Config.VOTE_REWARD1_ID, Config.VOTE_REWARD1_COUNT, player, true);

                            }

                            item2 = player.getInventory().getItemByItemId(Config.VOTE_REWARD1_ID);

                            

                            if ((item2 == null) || (item2.getCount() < Config.MAX_REWARD_COUNT_FOR_STACK_ITEM1))

                            {

                                player.addItem("reward", Config.VOTE_REWARD2_ID, Config.VOTE_REWARD2_COUNT, player, true);

                            }

                        }

                    }

                    setLastVoteCount(getLastVoteCount() + Config.VOTES_FOR_REWARD);

                    statement.close();

                    _log.info("Vote Reward System: Reward for votes now!");

                    Broadcast.toAllOnlinePlayers(new CreatureSay(1, Say2.CRITICAL_ANNOUNCE, "", "Vote Manager: Reward for players! Thanks for Vote."));

                }

                catch (SQLException e)

                {

                    e.printStackTrace();

                }

                finally

                {

                    L2DatabaseFactory.close(con);

                }

                

                setLastVoteCount(getLastVoteCount() + Config.VOTES_FOR_REWARD);

            }

            Broadcast.toAllOnlinePlayers(new CreatureSay(1, Say2.CRITICAL_ANNOUNCE, "", "Vote Manager: Server votes: " + votes + " | Next Reward on " + (getLastVoteCount() + Config.VOTES_FOR_REWARD) + " Votes."));

            if (getLastVoteCount() == 0)

            {

                setLastVoteCount(votes);

            }

        }

    }

    

    private int getVotes(String urlString)

    {

        URL url = null;

        InputStreamReader isr = null;

        BufferedReader in = null;

        try

        {

            url = new URL(urlString);

            isr = new InputStreamReader(url.openStream());

            in = new BufferedReader(isr);

            String inputLine;

            while ((inputLine = in.readLine()) != null)

            {

                if (Config.VOTE_REWARD_TOPZONE_ENABLE)

                {

                    // for TopZone

                    if (inputLine.contains("<tr><td><div align=\"center\"><b><font style=\"font-size:14px;color:#018BC1;\""))

                    {

                        return Integer.valueOf(inputLine.split(">")[3].replace("</div", ""));

                        

                    }

                }

                if (Config.VOTE_REWARD_HOPZONE_ENABLE)

                {

                    // for HopZone

                    if (inputLine.contains("rank anonymous tooltip"))

                    {

                        @SuppressWarnings("unused")

                        int Sub = 12;

                        switch (inputLine.length())

                        {

                            case 116:

                                Sub = 13;

                                break;

                            case 117:

                                Sub = 14;

                                break;

                            case 118:

                                Sub = 15;

                                break;

                            case 119:

                                Sub = 16;

                                break;

                        }

                        return Integer.valueOf(inputLine.split(">")[2].replace("</span", ""));

                    }

                }

            }

        }

        catch (IOException e)

        {

            _log.warning("Vote Reward System: " + e);

        }

        finally

        {

            try

            {

                in.close();

            }

            catch (IOException e)

            {

            }

            try

            {

                isr.close();

            }

            catch (IOException e)

            {

            }

        }

        return 0;

    }

    

    private void setLastVoteCount(int voteCount)

    {

        lastVoteCount = voteCount;

    }

    

    private int getLastVoteCount()

    {

        return lastVoteCount;

    }

    

    private void load()

    {

        int votes = 0;

        Connection con = null;

        try

        {

            con = L2DatabaseFactory.getInstance().getConnection();

            PreparedStatement statement = con.prepareStatement("SELECT vote FROM votes LIMIT 1");

            ResultSet rset = statement.executeQuery();

            

            while (rset.next())

            {

                votes = rset.getInt("vote");

            }

            rset.close();

            statement.close();

        }

        catch (Exception e)

        {

            _log.log(Level.WARNING, "data error on vote: ", e);

        }

        finally

        {

            L2DatabaseFactory.close(con);

        }

        

        setLastVoteCount(votes);

    }

    

    public void save()

    {

        Connection con = null;

        try

        {

            con = L2DatabaseFactory.getInstance().getConnection();

            PreparedStatement statement = con.prepareStatement("UPDATE votes SET vote = ? WHERE id=1");

            statement.setInt(1, getLastVoteCount());

            statement.execute();

            statement.close();

        }

        catch (Exception e)

        {

            _log.log(Level.WARNING, "data error on vote: ", e);

        }

        finally

        {

            L2DatabaseFactory.close(con);

        }

    }

    

    public static AutoVoteRewardHandler getInstance()

    {

        return SingletonHolder._instance;

    }

    

    @SuppressWarnings("synthetic-access")

    private static class SingletonHolder

    {

        protected static final AutoVoteRewardHandler _instance = new AutoVoteRewardHandler();

    }

}

I dont know where the problem is !

Edit:

I edit this line :



if (inputLine.contains("<tr><td><div align=\"center\"><b><font style=\"font-size:14px;color:#018BC1;\""))

to:



if (inputLine.contains("Votes:"))

And work !

Any ideas for hopzone?

Edited September 22, 2013 by drgn

^Wyatt · September 22, 2013

You should create a topic in Dev Help Section.

That error is common to appear when hopzone is Down, can't be that?

MikeJ · September 22, 2013

You should create a topic in Dev Help Section.

That error is common to appear when hopzone is Down, can't be that?

If it was down, it wouldn't return a 403 error.

For anyone looking for the solution: http://www.maxcheaters.com/topic/169551-vote-reward-system-problem/?do=findComment&comment=2268862

drgn · October 2, 2013

Link Broken? i have problem with dat table i think, votes saved only for TopZone i think because when i enable Hopzone votes at atble stay 20 and real its 3 :/ and the message is that reward when server reach 21 Votes :/

Edited October 2, 2013 by drgn

Karasu · November 9, 2013

Update sql link...

Karasu · November 11, 2013

link for votes.sql not work ,can anyone update it?

Gorion · December 21, 2013

For all that had a problem with this Vote Reward below is the proper code of AutoVoteRewardHandler.java that is working for both Topzone and Hopzone (rest of the files like in the 1st post:

AutoVoteRewardHandler.java

package com.l2jserver.gameserver.instancemanager;

import java.io.BufferedReader;
import java.io.IOException;
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.util.logging.Level;
import java.util.logging.Logger;

import com.l2jserver.Config;
import com.l2jserver.L2DatabaseFactory;
import com.l2jserver.gameserver.ThreadPoolManager;
import com.l2jserver.gameserver.model.L2World;
import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
import com.l2jserver.gameserver.model.items.instance.L2ItemInstance;
import com.l2jserver.gameserver.network.clientpackets.Say2;
import com.l2jserver.gameserver.network.serverpackets.CreatureSay;
import com.l2jserver.gameserver.util.Broadcast;

public class AutoVoteRewardHandler
{
	private static Logger _log = Logger.getLogger(AutoVoteRewardHandler.class.getName());
	
	private static final int initialCheck = 1 * 1000;
	private static final int delayForCheck = Config.DELAY_FOR_NEXT_REWARD * 1000;
	
	private static int lastVoteCount = 0;
	
	private AutoVoteRewardHandler()
	{
		_log.info("Vote Reward System: Vote reward system initiated.");
		if (Config.VOTE_REWARD_ENABLE)
		{
			load();
		}
		ThreadPoolManager.getInstance().scheduleGeneralAtFixedRate(new AutoReward(), initialCheck, delayForCheck);
	}
	
	private class AutoReward implements Runnable
	{
		@Override
		public void run()
		{
			int votes = getVotes(Config.VOTE_HTML_PATCH);
			System.out.println("Server Votes: " + votes);
			if ((votes != 0) && (getLastVoteCount() != 0) && (votes >= (getLastVoteCount() + Config.VOTES_FOR_REWARD)))
			{
				Connection con = null;
				try
				{
					con = L2DatabaseFactory.getInstance().getConnection();
					PreparedStatement statement = con.prepareStatement("SELECT c.charId, c.char_name FROM characters AS c LEFT JOIN accounts AS a ON c.account_name = a.login WHERE c.online > 0 GROUP BY a.lastIP ORDER BY c.level DESC");
					ResultSet rset = statement.executeQuery();
					L2PcInstance player = null;
					L2ItemInstance item = null;
					L2ItemInstance item2 = null;
					while (rset.next())
					{
						player = L2World.getInstance().getPlayer(rset.getInt("charId"));
						if ((player != null) && !player.getClient().isDetached())
						{
							item = player.getInventory().getItemByItemId(Config.VOTE_REWARD1_ID);
							if ((item == null) || (item.getCount() < Config.MAX_REWARD_COUNT_FOR_STACK_ITEM1))
							{
								player.addItem("reward", Config.VOTE_REWARD1_ID, Config.VOTE_REWARD1_COUNT, player, true);
							}
							item2 = player.getInventory().getItemByItemId(Config.VOTE_REWARD1_ID);
							
							if ((item2 == null) || (item2.getCount() < Config.MAX_REWARD_COUNT_FOR_STACK_ITEM1))
							{
								player.addItem("reward", Config.VOTE_REWARD2_ID, Config.VOTE_REWARD2_COUNT, player, true);
							}
						}
					}
					setLastVoteCount(getLastVoteCount() + Config.VOTES_FOR_REWARD);
					statement.close();
					_log.info("Vote Reward System: Reward for votes now!");
					Broadcast.toAllOnlinePlayers(new CreatureSay(1, Say2.CRITICAL_ANNOUNCE, "", "Vote Manager: Reward for players! Thanks for Vote."));
				}
				catch (SQLException e)
				{
					e.printStackTrace();
				}
				finally
				{
					L2DatabaseFactory.close(con);
				}
				
				setLastVoteCount(getLastVoteCount() + Config.VOTES_FOR_REWARD);
			}
			Broadcast.toAllOnlinePlayers(new CreatureSay(1, Say2.CRITICAL_ANNOUNCE, "", "Vote Manager: Server votes: " + votes + " | Next Reward on " + (getLastVoteCount() + Config.VOTES_FOR_REWARD) + " Votes."));
			if (getLastVoteCount() == 0)
			{
				setLastVoteCount(votes);
			}
		}
	}
	
	private int getVotes(String urlString)
	{
		URL url = null;
		InputStreamReader isr = null;
		BufferedReader in = null;
		try
		{
			url = new URL(urlString);
			URLConnection connection = url.openConnection();
			connection.setRequestProperty("User-Agent", "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20100101 Firefox/10.0.2");
			connection.connect();
			InputStream response = connection.getInputStream();
			isr = new InputStreamReader(response);
			in = new BufferedReader(isr);
			String inputLine;
			while ((inputLine = in.readLine()) != null)
			{
				if (Config.VOTE_REWARD_TOPZONE_ENABLE)
				{
					// for TopZone
					// if (inputLine.contains("<tr><td><div align=\"center\"><b><font style=\"font-size:14px;color:#018BC1;\""))
					if (inputLine.contains("Votes:"))
					{
						return Integer.valueOf(inputLine.split(">")[3].replace("</div", ""));
					}
				}
				if (Config.VOTE_REWARD_HOPZONE_ENABLE)
				{
					// for HopZone
					if (inputLine.contains("rank anonymous tooltip"))
					{
						@SuppressWarnings("unused")
						int Sub = 12;
						switch (inputLine.length())
						{
							case 116:
								Sub = 13;
								break;
							case 117:
								Sub = 14;
								break;
							case 118:
								Sub = 15;
								break;
							case 119:
								Sub = 16;
								break;
						}
						return Integer.valueOf(inputLine.split(">")[2].replace("</span", ""));
					}
				}
			}
		}
		catch (IOException e)
		{
			_log.warning("Vote Reward System: " + e);
		}
		finally
		{
			try
			{
				in.close();
			}
			catch (IOException e)
			{
			}
			try
			{
				isr.close();
			}
			catch (IOException e)
			{
			}
		}
		return 0;
	}
	
	private void setLastVoteCount(int voteCount)
	{
		lastVoteCount = voteCount;
	}
	
	private int getLastVoteCount()
	{
		return lastVoteCount;
	}
	
	private void load()
	{
		int votes = 0;
		Connection con = null;
		try
		{
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("SELECT vote FROM votes LIMIT 1");
			ResultSet rset = statement.executeQuery();
			
			while (rset.next())
			{
				votes = rset.getInt("vote");
			}
			rset.close();
			statement.close();
		}
		catch (Exception e)
		{
			_log.log(Level.WARNING, "data error on vote: ", e);
		}
		finally
		{
			L2DatabaseFactory.close(con);
		}
		
		setLastVoteCount(votes);
	}
	
	public void save()
	{
		Connection con = null;
		try
		{
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("UPDATE votes SET vote = ? WHERE id=1");
			statement.setInt(1, getLastVoteCount());
			statement.execute();
			statement.close();
		}
		catch (Exception e)
		{
			_log.log(Level.WARNING, "data error on vote: ", e);
		}
		finally
		{
			L2DatabaseFactory.close(con);
		}
	}
	
	public static AutoVoteRewardHandler getInstance()
	{
		return SingletonHolder._instance;
	}
	
	@SuppressWarnings("synthetic-access")
	private static class SingletonHolder
	{
		protected static final AutoVoteRewardHandler _instance = new AutoVoteRewardHandler();
	}
}

Because the .sql file is dead I assume votes.sql shoul looks like that but not sure:

-- ----------------------------
-- Table structure for `votes`
-- ----------------------------
DROP TABLE IF EXISTS `votes`;
CREATE TABLE `votes` (
  `id` int(6) NOT NULL,
  `vote` int(6) NOT NULL,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;


-- ----------------------------
-- Records of votes
-- ----------------------------
INSERT INTO votes VALUES ('1', '0');

Edited December 21, 2013 by Gorion

hades25 · January 18, 2014

Somone can reshare sql for this please!

Thanks!

EpicMan · January 19, 2014

Somone can reshare sql for this please!

Thanks!

-- ----------------------------
-- Table structure for `votes`
-- ----------------------------
DROP TABLE IF EXISTS `votes`;
CREATE TABLE `votes` (
  `id` int(6) NOT NULL,
  `vote` int(6) NOT NULL,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;


-- ----------------------------
-- Records of votes
-- ----------------------------
INSERT INTO votes VALUES ('1', '0');

drgn · February 28, 2014

Γεια σας !

Έχω ένα θεματάκι.. όταν φτάνει ο αριθμός τον votes δεν δίνει reward και πετάει error !

Έχει κανείς καμία ιδέα;

Έχω ψάξει τα πάντα :/ με έχει μπερδέψει αρκετά !

Ευχαριστώ !

Nightw0lf · March 1, 2014

kapou psaxnei o kwdikas na vrei stin vasi dedomenwn to "accounts" table alla den to vriskei..

drgn · March 1, 2014

Εδώ είναι το πρόβλημα :

PreparedStatement statement = con.prepareStatement("SELECT c.charId, c.char_name FROM characters AS c LEFT JOIN accounts AS a ON c.account_name = a.login WHERE c.online > 0 GROUP BY a.lastIP ORDER BY c.level DESC");

change to :

PreparedStatement statement = con.prepareStatement("SELECT c.charId, c.char_name FROM characters AS c LEFT JOIN l2jls.accounts AS a ON c.account_name = a.login WHERE c.online > 0 GROUP BY a.lastIP ORDER BY c.level DESC");

ήθελε το l2jls στο accounts. Το είχα ξανά κάνει αλλά δεν είχε πιάσει ! Τώρα δίνει κανονικά reward !

Edited March 1, 2014 by drgn

disorder25 · March 14, 2014

This is not working, can anyone help me with the right code for Topzone vote reward?

while ((inputLine = in.readLine()) != null)
			{
				// for top-zone
				if (inputLine.contains("Votes:"))
				{
					return Integer.valueOf(inputLine.split(">")[3].replace("</div", ""));
				}

Loses · September 13, 2014

http://www25.zippyshare.com/v/29015671/file.html vote.sql

Code Hi5 Vote Reward Configurable [ Topzone - Hopzone ]

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Posts

Topics