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

drgn

drgn

^Wyatt

MikeJ

drgn

Karasu

Karasu

Gorion

hades25

EpicMan

drgn

Nightw0lf

drgn

disorder25

Loses

Join the conversation

Posts

Topics

Browse

Activity

Store