[Share][Updated] Vote Point System

[Rizel]

Hello. This is my first share on this forum:) This share is a 'simple' core mod to inspirate your players to vote to the server. I added a field to the characters table in the servers SQL. With Navicat (design table/ add field) the properties are:

Name: 'vote'  Type: 'int' Lenght: 10  Decimals: 0 Allow null:[ ] Default: 0 Unsigned: [x]

After that apply the patch that i attached. This contains the diff file and 2 java files wich you have to copy to handler/voicedcommandhandlers/. After that compile the server core and you're done.

You have to make a PHP script for your servers homepage for increase the character's vote field if he voted. In the game use the .vote voice command to see how many vote points you have and .change to change theese points to Glittering Medal. You can change the reward item-s id in VoteChange.java so you can give anything you want for the vote points. I use the Glittering Medal with a simple multisell NPC.

 

Diff file:

Index: D:/Eclipse/Core Version 1.2.6/src/main/java/com/l2jfree/gameserver/model/actor/instance/L2PcInstance.java
===================================================================
--- D:/Eclipse/Core Version 1.2.6/src/main/java/com/l2jfree/gameserver/model/actor/instance/L2PcInstance.java	(revision 4875)
+++ D:/Eclipse/Core Version 1.2.6/src/main/java/com/l2jfree/gameserver/model/actor/instance/L2PcInstance.java	(working copy)
@@ -267,8 +267,8 @@
	private static final String	DELETE_SKILL_SAVE				= "DELETE FROM character_skills_save WHERE charId=? AND class_index=?";

	// Character Character SQL String Definitions:
-	private static final String	UPDATE_CHARACTER				= "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,face=?,hairStyle=?,hairColor=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,in_jail=?,jail_timer=?,newbie=?,nobless=?,pledge_rank=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,banchat_timer=?,char_name=?,death_penalty_level=?,trust_level=? WHERE charId=?";
-	private static final String	RESTORE_CHARACTER				= "SELECT account_name, charId, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, face, hairStyle, hairColor, sex, heading, x, y, z, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, banchat_timer, newbie, nobless, pledge_rank, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally, clan_join_expiry_time,clan_create_expiry_time,charViP,death_penalty_level,trust_level FROM characters WHERE charId=?";
+	private static final String	UPDATE_CHARACTER				= "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,face=?,hairStyle=?,hairColor=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,in_jail=?,jail_timer=?,newbie=?,nobless=?,pledge_rank=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,banchat_timer=?,char_name=?,death_penalty_level=?,trust_level=?,vote=? WHERE charId=?";
+	private static final String	RESTORE_CHARACTER				= "SELECT account_name, charId, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, face, hairStyle, hairColor, sex, heading, x, y, z, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, banchat_timer, newbie, nobless, pledge_rank, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally, clan_join_expiry_time,clan_create_expiry_time,charViP,death_penalty_level,trust_level,vote FROM characters WHERE charId=?";
     
	// Character Subclass SQL String Definitions:
	private static final String	RESTORE_CHAR_SUBCLASSES			= "SELECT class_id,exp,sp,level,class_index FROM character_subclasses WHERE charId=? ORDER BY class_index ASC";
@@ -289,7 +289,9 @@
	private static final String	RESTORE_CHAR_RECOMS				= "SELECT charId,target_id FROM character_recommends WHERE charId=?";
	private static final String	ADD_CHAR_RECOM					= "INSERT INTO character_recommends (charId,target_id) VALUES (?,?)";
	private static final String	DELETE_CHAR_RECOMS				= "DELETE FROM character_recommends WHERE charId=?";
-
+	private static final String	RESTORE_CHAR_VOTE				= "SELECT vote FROM characters WHERE charId=?";
+	private static final String	UPDATE_CHAR_VOTE			= "UPDATE characters SET vote=? WHERE charId=?";
+	
	// Character Transformation SQL String Definitions:
	private static final String	SELECT_CHAR_TRANSFORM			= "SELECT transform_id FROM characters WHERE charId=?";
	private static final String	UPDATE_CHAR_TRANSFORM			= "UPDATE characters SET transform_id=? WHERE charId=?";
@@ -408,6 +410,10 @@

	/** The number of player killed during a PvP (the player killed was PvP Flagged) */
	private int								_pvpKills;
+	
+	/** The number of the player's votes */
+	
+	private int								_voteCount;

	/** The PK counter of the L2PcInstance (= Number of non PvP Flagged player killed) */
	private int								_pkKills;
@@ -2101,6 +2107,19 @@
		return _pvpKills;
	}

+	
+	public int getVoteCount()
+	{
+		restoreVote();
+		return _voteCount;
+	}
+	
+	public void setVoteCount(int vote)
+	{
+		_voteCount = vote;
+		updateVote();
+	}
+	
	/**
	 * Set the the PvP Kills of the L2PcInstance (Number of player killed during a PvP).<BR><BR>
	 */
@@ -6794,7 +6813,8 @@
				player.setAllianceWithVarkaKetra(rset.getInt("varka_ketra_ally"));
				player.setDeathPenaltyBuffLevel(rset.getInt("death_penalty_level"));
				player.setTrustLevel(rset.getInt("trust_level"));
-
+				player.setVoteCount(rset.getInt("vote"));
+				
				// Add the L2PcInstance object in _allObjects
				// L2World.getInstance().storeObject(player);

@@ -7030,6 +7050,57 @@
		finally { try { if (con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } }
	}

+	
+	private void restoreVote()
+		{
+			Connection con = null;
+	
+			try
+			{
+				con = L2DatabaseFactory.getInstance().getConnection(con);
+				PreparedStatement statement = con.prepareStatement(RESTORE_CHAR_VOTE);
+				statement.setInt(1, getObjectId());
+				ResultSet rset = statement.executeQuery();
+				while (rset.next())
+				{
+					_voteCount=(rset.getInt("vote"));
+				}
+	
+				rset.close();
+				statement.close();
+			}
+			catch (Exception e)
+			{
+				_log.error("could not restore vote: ", e);
+			}
+			finally { try { if (con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } }
+		}
+	
+	
+	private void updateVote()
+	{
+
+
+
+			Connection con = null;
+			try
+			{
+				con = L2DatabaseFactory.getInstance().getConnection(con);
+				PreparedStatement statement = con.prepareStatement(UPDATE_CHAR_VOTE);
+				statement.setInt(1, _voteCount);
+				statement.setInt(2, getObjectId());
+
+				statement.execute();
+				statement.close();
+			}
+			catch (Exception e)
+			{
+				_log.fatal("Vote insert info: " + e);
+			}
+	        finally { try { if (con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } }
+		}
+	
+	
	/**
	 * Store recipe book data for this L2PcInstance, if not on an active sub-class.
	 */
@@ -7203,7 +7274,8 @@
			statement.setString(49, getName());
			statement.setLong(50, getDeathPenaltyBuffLevel());
			statement.setLong(51, getTrustLevel());
-			statement.setInt(52, getObjectId());
+			statement.setInt(52, getVoteCount());
+			statement.setInt(53, getObjectId());
			statement.execute();
			statement.close();
		}
Index: D:/Eclipse/Core Version 1.2.6/src/main/java/com/l2jfree/gameserver/handler/VoicedCommandHandler.java
===================================================================
--- D:/Eclipse/Core Version 1.2.6/src/main/java/com/l2jfree/gameserver/handler/VoicedCommandHandler.java	(revision 4875)
+++ D:/Eclipse/Core Version 1.2.6/src/main/java/com/l2jfree/gameserver/handler/VoicedCommandHandler.java	(working copy)
@@ -48,6 +48,8 @@
		registerVoicedCommandHandler(new CastleDoors());
		registerVoicedCommandHandler(new Hellbound());
		registerVoicedCommandHandler(new VersionInfo());
+		registerVoicedCommandHandler(new VoteCount());
+		registerVoicedCommandHandler(new VoteChange());
		if (Config.ALLOW_WEDDING)
		{
			registerVoicedCommandHandler(new Wedding());

 

handler/voicedcommandhandlers/VoteChange.java

package com.l2jfree.gameserver.handler.voicedcommandhandlers;

import com.l2jfree.gameserver.handler.IVoicedCommandHandler;
import com.l2jfree.gameserver.model.actor.instance.L2PcInstance;

/** 
* @author Rizel
* 
*/
public class VoteChange  implements IVoicedCommandHandler
{
private static final String[]	VOICED_COMMANDS	=
												{ "change" };

public boolean useVoicedCommand(String command, L2PcInstance activeChar, String target)
{
	if (command.startsWith("change"))
	{
		if (activeChar.getVoteCount() == 0)
		{
			activeChar.sendMessage("You don't have any vote points.");
			return true;			
		}
		else
		{
		activeChar.addItem("Loot", 6393, activeChar.getVoteCount(), activeChar, true);
		activeChar.sendMessage("You changed " + activeChar.getVoteCount() + " vote points to Medal!");
		activeChar.setVoteCount(0);
		return true;
		}
	}
	return false;
}
public String[] getVoicedCommandList()
{
	return VOICED_COMMANDS;
}
}

 

 

handler/voicedcommandhandlers/VoteCount.java

 

package com.l2jfree.gameserver.handler.voicedcommandhandlers;

import com.l2jfree.gameserver.handler.IVoicedCommandHandler;
import com.l2jfree.gameserver.model.actor.instance.L2PcInstance;

/** 
* @author Rizel
* 
*/
public class VoteCount  implements IVoicedCommandHandler
{
private static final String[]	VOICED_COMMANDS	=
												{ "vote" };

public boolean useVoicedCommand(String command, L2PcInstance activeChar, String target)
{
	if (command.startsWith("vote"))
	{
		activeChar.sendMessage("Your vote points: " + activeChar.getVoteCount());
		return true;
	}
	return false;
}
public String[] getVoicedCommandList()
{
	return VOICED_COMMANDS;
}
}

The share tested on L2JFree.

 

::: Update :::

 

There was a few player who asked me to make a PHP for this system.

Here are the .php files:

 

http://www.4shared.com/file/89856652/81ab6709/votesystemphp.html

 

You need to add a new column to characters table named votetime type int

 

I can't test it so i'm not sure that it will work :S if you find any bugs pls reply

 

[Intrepid]

very good share my friend:)especially because you wrote it to our server before you share it:P

[Versus]

Really nice beggining.Continue this way ;)

[EvilMan]

Its realy good thing so iam very thankfull for you.. Nice job keep going! :)

[Frank]

It is a cool share.! Keep sharing, awards are coming dude.!

[ketchupyx]

can you tell us what we have to put in the php script?

 

and your thing is away from any type of exploit??? (dynamic ip ect)

 

BTW THANKS AND NICE SHARE!!

[Th3On3]

This has to be the best and I mean the BEST! thing I have ever seen posted on MXC

Going on my server for sure

[Dimis4]

Well finally a good share ,

I am not going to use it because votes for me means : what your players thing about your server and if they 'love' you in order to vote. Furthermore this is a bit complicated because if you want to make a .php that increase players votes this will cause a mess and will provide easy points . What i mean :

If you want this script to works player should log in Or write his char name to site before making vote.

Thats a bit annoying to login in order to make a vote. Furthermore we must add a kind of protection what i mean?

A sql tample that will log the char name and ip and check if the char name or ip voted the last 12 hours. If yes then it wont provide more points. This will keep your server secure from points abuse.

I will write one for you as soon as possible to complete this share.

Gn.

 

PS: you can do the same job much more easier just with the php script a modify on characters.sql that you perfectly done and one point trader . He will tell you how many points you have and what you can change them fore without making any change to your java files.

[Intrepid]

Because Rizel make that for our server i know how it works...

you enter to the web page and you see links to extrem top100 hopzone and so on below that you have to write down your characters name you vote your character get 1 point in sql you go ingame .vote you see how many point you have .change you change it to another item and you use it at shop's

dinamic ip exploit protection in PHP.

[Vago]

The secure checks will be made in the php file.

If char votes at more than 12 hours form last vote, add point, if not, dont add anything. Also you cannot be sure they vote because the point is added when they click the link...you got no idea if they type the security vote on the voting site and press the vote button too.

Anyway there could be one more check. If the vote is 12 hours laster then the last and 5 seconds after the link is clicked the vote count increases too (import it from the voting site page), then, add...100% secure.

Because I dont know php at all I request some web coder to do it please...Would complete this share and be totally pro. ^^

[Dippindots]

nice share !!

[Rizel]

i don't really know how to write the php to be absolutely sure that the players really voted:S the php i used only asks the players name check when he last voted and brings up the topsite but i can't be sure that the player will enter the code and vote. if someone can write a php which solve this problem please post here:)

[FiX]

GJ!!!

Great Share..

[z0ul0u]

omg its owning yeah man go on

[M4GNUM]

man.. this a really nice idea!

i'd like to give you +1, but i can't.. xD

keep your good work and thanks for sharing