WTS [WTS] Vote Reward System

[BruT]

As the title i am looking for customers who needs Vote Reward System which is coded just in core side(without php codes)if you want to know his specifications pm me or imail me at pn-brutus@hotmail.com

[Coolis®]

Yea and take it mind that he wants first all money and after the vote reward also he is goiung to try proof you with easy vote checker, just take it mind guys ;)

[BruT]

*

[Coolis®]

Easy vote checkers doesnt exist, the most hard side is the check Side. Learn some java basics then talk with me

yea thats why i got my 9 karma from making 2 huge tut from java, wake up.

[ëfÿġësSkëtö]

omg ban that noob he is scammer he dont have that code.

look what he told me yesterday on msn:

/25/2010      9:15:58 PM      GekaS* QQ e3etaseis      [c=4]BruTuS[/c]      hi

5/25/2010      9:16:05 PM      GekaS* QQ e3etaseis      [c=4]BruTuS[/c]      i find your msn on maxcheaters

5/25/2010      9:16:10 PM      GekaS* QQ e3etaseis      [c=4]BruTuS[/c]      do you have vote reward sytem java side

5/25/2010      9:16:12 PM      GekaS* QQ e3etaseis      [c=4]BruTuS[/c]      because i am interersting to buy it

5/25/2010      9:16:23 PM      GekaS* QQ e3etaseis      [c=4]BruTuS[/c]      ..?

5/25/2010      9:22:29 PM      [c=4]BruTuS[/c]      GekaS* QQ e3etaseis      woot?

5/25/2010      9:22:41 PM      [c=4]BruTuS[/c]      GekaS* QQ e3etaseis      java side?

5/25/2010      9:22:54 PM      GekaS* QQ e3etaseis      [c=4]BruTuS[/c]      thats dont exist. you should add php on website

5/25/2010      9:22:56 PM      [c=4]BruTuS[/c]      GekaS* QQ e3etaseis      without php vote reward dont work?

 

and now he sell the code :D

[BruT]

*

[ëfÿġësSkëtö]

thats nothing ? want some part of it that dont work?
[code]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());

 

i have this so? QQ boy go scamm other forum not here[/code]

[BruT]

*

[szmajso]

I see that im only one who have pure java WORKING vote system :p

It can be even tested on live servers - check my other post to find out where :p

[BruT]

*

[ëfÿġësSkëtö]

szmajso is the best dev arround and yes i will buy the vote reward 100euro from him. because your an idio scammer. gtfo of here.

who gonna trust a guy with 10 post and -1 karma. gf

[BruT]

I am not gonna prove anything especially to Greeks like you

[Vkouk]

off topic

 

locked