ë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

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]

e afto einai adikia alo elinika alo greeklish . px egw apo to pc m exw svisi tin eliniki glwssa. pws tha milisw ellinika? mono greeklish. fixarete to karma sto pedi eleos

omg ban that noob he is scammer he dont have that code. look what he told me yesterday on msn: and now he sell the code :D

axaxa what a stupid boy. ban that noob please

give chat logs with image or gtfo coolis is very trusted guy

idiot are dump head or what? chat logs are not allowed this is the second time that you post. leave the forum no one will buy something . w8 a minute to find when you told me on msn. i dont know how to code vote reward.

ye the code is done? why you told me on msn? you dont have it? want msn log? and 2) why you dont open test server you dont know how to compile? o.O

po re file dn iparxis akrivos afto epsaxna. ilikrina thnx

lol he is vorfin? muhahha

what was your problem with hostyourdream because i am willing to buy dedicated server there!

x0a0xa because i insult him on pm he dekarma me 3 times with his account then he try to dekarma me with remeos account 0a0xa0 what a freaking bastard

xa00xa

he is asking for a second chance o.O

they stoll his account `Romeo` and he get banned. he is asking for second chance. he made 3 topics about it T_T

k o pateras sou einai pakistanos ala dn eipa tpt

http://www.maxcheaters.com/forum/index.php?topic=80516.0 just change few things and it will work for il too.,!

xaxa this sux + ilegal.!

xaxa you dekarma him and then your report him ? i think mods should ban you

gine poio sigekrimenos dn ktlv tpt :@

im gonna test it!

good job im gonna test it. old but good.!