Jump to content

[SHARE]Vote point system reward


Recommended Posts

Hello...recently i was searching on some forums and i found a very interesting tool for lineage2 servers.

This is a Vote point system that whould impulse the players to vote for a reward...

Java scrips are made by "bubulina" .

 

the script below has only the java files that we need to implement into the server side ..

also if anyone whould share the script needed to implement into the websites whould be great.

 

All the credits for that script goes to "bubulina" ...Have a nice day!

 

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;
@@ -2****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;
}
}

 

btw bubulina = skanners

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share



  • Posts

    • I started on a random c3 server - it was a low rate one; but not for too long anyway. My internet cafe and I quickly moved to c4. I remember l2pvpx, l2dex, l2max, l2brazuca, l2forever; too many to remember. L2Gold was probably the first custom server I tried, back when having a weapon with SA and Noblesse was the big thing. After that, I think L2AePvP (rechristened L2Pride) became a big thing in our internet cafe. Even though most of us had a computer and internet at home - 100mbps fiber (in the building) in early 2000, in our city.   I regret not playing WoW. Only a few nerds played this game when I was a little kid.   I was playing a lot of DotA and other custom maps on Warcraft 3 - mostly on Garena. CS 1.6 was a game I dominated the most in terms of performance; late elementary school/early high school.   I rarely play L2 and CS:GO these days. Mostly DotA 2 - my biggest performance was probably in 2016 or so. Now I'm a noob. Mostly playing occasionally with other noobish friends.   So all my life I've been a Counter Strike, DotA, Lineage 2 player. I tried other games, but not for too long, I got bored very quickly. I guess competitive gaming is for me. But as you get older, you don't have the same reflexes or time for it. The change will be made sooner or later.
    • I heard a lot about Ashes, if you manage to make a MxC guild I would eventually join when it's up (I'm support, generally healer, btw).   Hopefully, we don't wait for nothing. Those days, games are launched while they're not even ready. 😄
    • Time for another summary of our updates over the past 24-48 hours!   We've implemented many new Telegram services, at some amazing prices! Some of the best being: 1559 - Telegram Members [10K] [Instant - 5K/D] - $0.43 1560 - Telegram Members [50K] [1H - 50K/D - AR14] - $0.66 1561 - Telegram Members [0% Drop] [5K] [1H - 5K/D] - $0.93 1564 - Telegram NFT Members [5K] [1H - 5K/D] [Non Drop] ⛔ - $1.57   We've also reduced the price of a few of our Telegram services: 1261 - Telegram Members [50K] [1H - 10K/D - AR3] - Price decreased from $0.52 to $0.44    1265 - Telegram Members [50K] [1H - 10K/D - AR7] - Price decreased from $0.60 to $0.51        Instant Instagram Views have also been further reduced to offer the best prices across the market! 1550 - Instagram Views [Works on Normal/IGTV/Reels] [10M] [Instant - 10M/D] - Price decreased from $0.025 to $0.015    1122 - Instagram Views [Works on Normal/IGTV/Reels] [50M] [Instant - 1M/D] - Price decreased from $0.05 to $0.016        We've also introduced two instant Twitter services, which we expect to be extremely popular: 1555 - Twitter Likes [5K] [Instant - 5K/D] - $0.55 1556 - Twitter Retweets [5K] [Instant - 5K/D] - $0.55     And finally, we've made a start on our AUTOMATIC (subscription based services), these can be found under the category Instagram Automatic Services [Subscription Based]. A few of the listed services are: 1567 - Instagram AUTO Likes [5K] [Instant - 5K/D] - $0.02 1573 - Instagram AUTO POWER Likes [10K] [Instant - 5K/D] - $1.04 1570 - Instagram AUTO Views [Works on Normal/IGTV/Reels] [10M] [Instant - 10M/D] - $0.015 1575 - Instagram AUTO Impressions + Reach + Profile Visits [1M] [Instant - 1M/D] - $0.11 1572 - Instagram AUTO Comments [Random] [10K] [Instant - 5K/D] - $0.73 1571 - Instagram AUTO Saves [5K] [Instant - 1K/D] - $0.01     We appreciate your continued support and thank you for using SMMFlare!
    • @xRelic se euxaristw poli filaraki.. ara afou les oti exei arketa themata as dw allo pack kalitera gia na asxolithw.. se euxaristw kai pali
    • Το φροζεν εχει αρκετα θεματα και ενα απο αυτα ειναι λιγο με τα ραιδβοσσ στο σπαουν λιστ...μπορεις να κανεις copy paste το βοοσ και απο l2raidboss να το κανεις νπσ με δικο σου ιδ και να βαλεις συγκεκριμενο τιμε που θες να κανει σπαουν πχ //spawn valakas 1 3600 (wra) απλα θα ξανα βγιε απο την ωρα που θα βγει ... οποτε μπορεις τριτη πχ στις 8 να κανεις //spawn valakas 1 604800 ετσι θα βγει την επομενη τριτη στην ωρα που θα γινει δεαδ... αν θες παλι να εξτρα πραγματα ωστε να γινεται announcements κτλπ θες code απο την αρχη.
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock