Jump to content
MaxCheaters Official Group at Discord
⭐ [#1] CHATGPT PLUS STORE ⭐ >> STARTING 4.99$ MONTH! << ⭐ FULL WARRANTY ⭐ DALLE-3 & GPT4 ✅

CTGavesT

Members
 View Profile  See their activity

  • Posts

    424

  • Credits

    0 

  • Joined

  • Last visited

  • Days Won

    1

  • Feedback

    0%

 Content Type 

Posts posted by CTGavesT

    Help

    in Request Server Development Help [Greek]

    Posted · Edited by FastCow

    Κάτσε ρε φίλε... Τα βλέπεις στο shop κανονικότατα, αλλά όχι πάνω σου? Τι δε βλέπεις ακριβώς όταν το αγοράζεις?

    Πρώτη φορά το ακούω αυτό..

    paw sto shop to agorazo kanonika pano mou den to blepo kanw skill kai ola afta me ton wep apla to blepo aorato 

     

     

    na to itemname-e.dat

    30019 God's Blade Legendary The God's Blade Sword. It has disappeared since the Age of Splendor times, never to be seen again... untill now. HP +20%. Heals received +15%. Patk +15%. Critical +40. Attack speed +50. Mdef +10%, PvP damage +10%. On Crit Power Break. -1     0 0 0

    kai to weapongrp.dat

    0 30019 1 1 7 10 0 LineageWeapon.gods_blade_m00_wp   artifacts.gods_blade_f   icon.weapon_forgotten_blade_i01     -1 1330 47 1 0 7 1 1 LineageWeapon.gods_blade_m00_wp  1 artifacts.gods_blade_f   4 ItemSound.spear_4 ItemSound.sword_big_3 ItemSound.sword_mid_8 ItemSound.public_sword_shing_10 ItemSound.itemdrop_sword ItemSound.itemequip_sword  10 518 267 1 5 8 0 0 0 0 379 0 1 1 1000 0 -1 0 LineageEffect.e_u540_aka_c  2.200000 0.000000 0.000000 0.700000 0.700000        1.700000 0.700000 0.800000 11.000000 0.000000 0.000000       -1 -1 -1 -1 icon.weapon_forgotten_blade_i01

    Help

    in Request Server Development Help [Greek]

    Posted

    dokimases na kaneis kainourio paixti? :P

     

    Nai ekana alla tpt to idio h alli to blepoune me ta idia files pou exo egw

    Αποκλείεται ρε συ.. Ξέρεις τι? Αυτά τα Weapon που θες να βάλεις, ποια είναι τα αρχεία τους? weapongrp και Itemname?

    Κάντα edit με το file edit, και πέρνα μέσα σε άλλο system τις γραμμές αυτές που έχει τα ID και δοκίμασε..

     

    Ούτε καν μαύρα δε τα βλέπεις? Κάτι έστω στο shop που τα πουλάς να εμφανίζει ένα κουτάκι που σε πετάει error?

    Αλλιώς μήπως το πρόβλημα είναι στην Navicat.. Κάνε CreateItem ένα από τα ID των Weapon, αν πει προστέθεικε αλλά δε τo βλέπεις, είναι Client, αν πει δεν υπάρχει, τσέκαρε Navicat και data/stats/weapons

    oxi ta blepo kanonika sto shop to agorazo den mou pou petaei error tpt apla mono egw den to blepo

    Help

    in Request Server Development Help [Greek]

    Posted

    Στους άλλους φαίνεται, ενώ σε εσένα που τα έφτιαξες/πέρασες όχι, ενώ μπαίνεις με το ίδιο Patch?

    Βγες τελείως από το Lineage, και ξανά κάνε επικόλληση όλο το patch μέσα στα files/Lineage II. Αν σου ζητάει να γίνουν αντικατάσταση τα αρχεία, θα πατάς "ναι".

    To ekana ta alla paidia exoun to idio patch me emena kai tous fenete eno se emena oxi exo kani antikatastasi ola ta arxia

    Help

    in Request Server Development Help [Greek]

    Posted · Edited by FastCow

    nai ta perasa kitakte kai olas Emena mou den mou to exi sti 8esi java/net/sf/l2j/gameserver/model/base/Experience.java mou ta exi etsi head-src/com/l2jfrozen/gameserver/datatables/xml/experienceData.java Mimpos fteei auto?

     

    L2jfrozen\gameserver\data\stats\experience.xml

    <?xml version="1.0" encoding="UTF-8"?>
<table maxLevel="85" maxPetLevel="80" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/experience.xsd">
<experience level="1" tolevel="0" />
<experience level="2" tolevel="68" />
<experience level="3" tolevel="363" />
<experience level="4" tolevel="1168" />
<experience level="5" tolevel="2884" />
<experience level="6" tolevel="6038" />
<experience level="7" tolevel="11287" />
<experience level="8" tolevel="19423" />
<experience level="9" tolevel="31378" />
<experience level="10" tolevel="48229" />
<experience level="11" tolevel="71201" />
<experience level="12" tolevel="101676" />
<experience level="13" tolevel="141192" />
<experience level="14" tolevel="191452" />
<experience level="15" tolevel="254327" />
<experience level="16" tolevel="331864" />
<experience level="17" tolevel="426284" />
<experience level="18" tolevel="539995" />
<experience level="19" tolevel="675590" />
<experience level="20" tolevel="835854" />
<experience level="21" tolevel="1023775" />
<experience level="22" tolevel="1242536" />
<experience level="23" tolevel="1495531" />
<experience level="24" tolevel="1786365" />
<experience level="25" tolevel="2118860" />
<experience level="26" tolevel="2497059" />
<experience level="27" tolevel="2925229" />
<experience level="28" tolevel="3407873" />
<experience level="29" tolevel="3949727" />
<experience level="30" tolevel="4555766" />
<experience level="31" tolevel="5231213" />
<experience level="32" tolevel="5981539" />
<experience level="33" tolevel="6812472" />
<experience level="34" tolevel="7729999" />
<experience level="35" tolevel="8740372" />
<experience level="36" tolevel="9850111" />
<experience level="37" tolevel="11066012" />
<experience level="38" tolevel="12395149" />
<experience level="39" tolevel="13844879" />
<experience level="40" tolevel="15422851" />
<experience level="41" tolevel="17137002" />
<experience level="42" tolevel="18995573" />
<experience level="43" tolevel="21007103" />
<experience level="44" tolevel="23180442" />
<experience level="45" tolevel="25524751" />
<experience level="46" tolevel="28049509" />
<experience level="47" tolevel="30764519" />
<experience level="48" tolevel="33679907" />
<experience level="49" tolevel="36806133" />
<experience level="50" tolevel="40153995" />
<experience level="51" tolevel="45524865" />
<experience level="52" tolevel="51262204" />
<experience level="53" tolevel="57383682" />
<experience level="54" tolevel="63907585" />
<experience level="55" tolevel="70852742" />
<experience level="56" tolevel="80700339" />
<experience level="57" tolevel="91162131" />
<experience level="58" tolevel="102265326" />
<experience level="59" tolevel="114038008" />
<experience level="60" tolevel="126509030" />
<experience level="61" tolevel="146307211" />
<experience level="62" tolevel="167243291" />
<experience level="63" tolevel="189363788" />
<experience level="64" tolevel="212716741" />
<experience level="65" tolevel="237351413" />
<experience level="66" tolevel="271973532" />
<experience level="67" tolevel="308441375" />
<experience level="68" tolevel="346825235" />
<experience level="69" tolevel="387197529" />
<experience level="70" tolevel="429632402" />
<experience level="71" tolevel="474205751" />
<experience level="72" tolevel="532692055" />
<experience level="73" tolevel="606319094" />
<experience level="74" tolevel="696376867" />
<experience level="75" tolevel="804219972" />
<experience level="76" tolevel="931275828" />
<experience level="77" tolevel="1151275834" />
<experience level="78" tolevel="1511275834" />
<experience level="79" tolevel="2099275834" />
<experience level="80" tolevel="4200000000" />
<experience level="81" tolevel="6299994999" />
<experience level="82" tolevel="10499905559" />
<experience level="83" tolevel="16800005559" />
<experience level="84" tolevel="27299995559" />
<experience level="85" tolevel="44100005559" />
</table>

    L2jfrozen\gameserver\data\xsd\experience.xsd

    <?xml version="1.0" encoding="UTF-8"?>
<schema xmlns="http://www.w3.org/2001/XMLSchema">
<element name="table">
  <complexType>
   <sequence minOccurs="1" maxOccurs="1">
    <element name="experience" minOccurs="1" maxOccurs="80">
     <complexType>
      <attribute name="level" use="required">
       <simpleType>
        <restriction base="positiveInteger">
         <minInclusive value="1" />
         <maxInclusive value="85" />
        </restriction>
       </simpleType>
      </attribute>
      <attribute name="tolevel" type="nonNegativeInteger" use="required" />
     </complexType>
    </element>
   </sequence>
   <attribute name="maxLevel" use="required">
    <simpleType>
     <restriction base="positiveInteger">
      <minInclusive value="1" />
      <maxInclusive value="85" />
     </restriction>
    </simpleType>
   </attribute>
   <attribute name="maxPetLevel" use="required">
    <simpleType>
     <restriction base="positiveInteger">
      <minInclusive value="1" />
      <maxInclusive value="85" />
     </restriction>
    </simpleType>
   </attribute>
  </complexType>
</element>
</schema>

    Help

    in Request Server Development Help [Greek]

    Posted

    δείξε μας το error που σου βγάζει.

    Auto mou bgazi !

    java.lang.NullPointerException

            at com.l2jfrozen.gameserver.datatables.xml.ExperienceData.getExpForLevel(ExperienceData.java:199)

            at com.l2jfrozen.gameserver.model.actor.stat.PcStat.getExpForLevel(PcStat.java:291)

            at com.l2jfrozen.gameserver.model.actor.stat.PlayableStat.addExp(PlayableStat.java:38)

            at com.l2jfrozen.gameserver.model.actor.stat.PcStat.addExp(PcStat.java:64)

            at com.l2jfrozen.gameserver.model.actor.stat.PlayableStat.addExpAndSp(PlayableStat.java:105)

            at com.l2jfrozen.gameserver.model.actor.stat.PcStat.addExpAndSp(PcStat.java:135)

            at com.l2jfrozen.gameserver.handler.admincommandhandlers.AdminLevel.useAdminCommand(AdminLevel.java:88)

            at com.l2jfrozen.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:118)

            at com.l2jfrozen.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:77)

            at com.l2jfrozen.gameserver.network.L2GameClient.run(L2GameClient.java:1213)

            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

            at java.lang.Thread.run(Unknown Source)

    Error Anagki

    in Request Server Development Help [Greek]

    Posted

    na to kanw etsi einai sosto?

    try
  {
   if(!Config.HOPZONE_SERVER_LINK.endsWith(".html"))
   Config.HOPZONE_SERVER_LINK+=".html";
   URLConnection con = new URL(Config.HOPZONE_SERVER_LINK).openConnection();
   con.addRequestProperty("User-L2Hopzone", "Mozilla/4.76");
   InputStreamReader isr = new InputStreamReader(con.getInputStream());
   BufferedReader br = new BufferedReader(isr);
   while ((line = br.readLine()) != null)
    if (line.contains("rank anonymous tooltip"))
    {
     votes = Integer.valueOf(line.split(">")[2].replace("</span", ""));
     Gui.hopzone.setText("HopZone Votes: "+votes);
     return votes;

    Error Anagki

    in Request Server Development Help [Greek]

    Posted · Edited by FastCow

    Έχει δίκιο ο Dante44.

    Πρώτα κοιτάμε με τι έχουμε να κάνουμε, τι πρέπει να φτιάξουμε, τι δουλεύει και τι όχι, και μετά κάνουμε κινήσεις για live έναν Server.

     

    Τέλος πάντων... Κοίτα αν έχει false για το check του topzone.

    Αλλιώς, στείλε τον κώδικα από τα Java.

     

    Τι έρρορ παίρνεις στο gs μόλις τρώνε dc οι παίχτες? Δώσε περισσότερες πληροφορίες...

    mono auto trone Client Character: Name - Acount:  ID - ip 1.11.11.111 disconnected abnormaly

     

    o code sto java.extensions.vote.votemanager

    /*
* This program is free software: you can redistribute it and/or modify it under
* the terms of the GNU General Public License as published by the Free Software
* Foundation, either version 3 of the License, or (at your option) any later
* version.
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
* details.
* You should have received a copy of the GNU General Public License along with
* this program. If not, see <http://www.gnu.org/licenses/>.
*/
package Extensions.Vote;
import java.io.BufferedReader;
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.text.SimpleDateFormat;
import java.util.Date;
import java.util.logging.Level;
import java.util.logging.Logger;
import Extensions.Vote.Tasks.MonthlyResetTask;
import Extensions.Vote.Tasks.TriesResetTask;
import com.l2jhellas.Config;
import com.l2jhellas.gameserver.ThreadPoolManager;
import com.l2jhellas.gameserver.model.L2World;
import com.l2jhellas.gameserver.model.actor.instance.L2PcInstance;
import com.l2jhellas.util.database.L2DatabaseFactory;
public class VoteManager
{
protected static final Logger _log = Logger.getLogger(VoteManager.class.getName());
private static boolean hasVotedHop;
private static boolean hasVotedTop;
public VoteManager()
{
}
public static void load()
{
  _log.log(Level.INFO, "VoteManager: initialized.");
  TriesResetTask.getInstance();
  MonthlyResetTask.getInstance();
}
protected static int getHopZoneVotes()
{
  int votes = -1;
  String Hopzonelink = Config.VOTE_LINK_HOPZONE;
  InputStreamReader isr = null;
  BufferedReader br = null;
 
  try
  {
   URLConnection con = new URL(Hopzonelink).openConnection();
   con.addRequestProperty("User-Agent", "Mozilla/4.76");
   isr = new InputStreamReader(con.getInputStream());
   br = new BufferedReader(isr);
  
   String line;
   while ((line = br.readLine()) != null)
   {
    if (line.contains("rank anonymous tooltip"))
    {
     votes = Integer.valueOf(line.split(">")[2].replace("</span", ""));
     break;
    }
   }
  
   br.close();
   isr.close();
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: Crazy error call boorinio " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
  return votes;
}
protected static int getTopZoneVotes()
{
  int votes = -1;
  URL url = null;
  URLConnection con = null;
  InputStream is = null;
  InputStreamReader isr = null;
  BufferedReader in = null;
  try
  {
   url = new URL(Config.VOTE_LINK_TOPZONE);
   con = url.openConnection();
   con.addRequestProperty("User-Agent", "L2TopZone");
   is = con.getInputStream();
   isr = new InputStreamReader(is);
   in = new BufferedReader(isr);
   String inputLine;
   while ((inputLine = in.readLine()) != null)
   {
    if (inputLine.contains("Votes"))
    {
     String votesLine = inputLine;
    
     votes = Integer.valueOf(votesLine.split(">")[3].replace("</div", ""));
     break;
    }
   }
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: cant get topzone votes " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
  return votes;
}
public static String hopCd(L2PcInstance player)
{
  long hopCdMs = 0;
  long voteDelay = 43200000L;
  PreparedStatement statement = null;
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   statement = con.prepareStatement("SELECT lastVoteHopzone FROM characters WHERE obj_Id=?");
   statement.setInt(1, player.getObjectId());
   ResultSet rset = statement.executeQuery();
   while (rset.next())
   {
    hopCdMs = rset.getLong("lastVoteHopzone");
   }
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not select lastvotehopzone from characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
  SimpleDateFormat sdf = new SimpleDateFormat("MMM dd,yyyy HH:mm");
  Date resultdate = new Date(hopCdMs + voteDelay);
  return sdf.format(resultdate);
}
public static String topCd(L2PcInstance player)
{
  long topCdMs = 0;
  long voteDelay = 43200000L;
  PreparedStatement statement = null;
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   statement = con.prepareStatement("SELECT lastVoteTopzone FROM characters WHERE obj_Id=?");
   statement.setInt(1, player.getObjectId());
   ResultSet rset = statement.executeQuery();
   while (rset.next())
   {
    topCdMs = rset.getLong("lastVoteTopzone");
   }
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not select lastvotehopzone from characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
  SimpleDateFormat sdf = new SimpleDateFormat("MMM dd,yyyy HH:mm");
  Date resultdate = new Date(topCdMs + voteDelay);
  return sdf.format(resultdate);
}
public static String whosVoting()
{
  for (L2PcInstance voter : L2World.getAllPlayers())
  {
   if (voter.isVoting())
   {
    return voter.getName();
   }
  }
  return "None";
}
public static void hopvote(final L2PcInstance player)
{
  long lastVoteHopzone = 0L;
  long voteDelay = 43200000L;
  final int firstvoteshop;
  firstvoteshop = getHopZoneVotes();
  class hopvotetask implements Runnable
  {
   private final L2PcInstance p;
   public hopvotetask(L2PcInstance player)
   {
    p = player;
   }
   @Override
   public void run()
   {
    if (firstvoteshop < getHopZoneVotes())
    {
     p.setIsVoting(false);
     VoteManager.setHasVotedHop(player);
     p.sendMessage("Thank you for voting for us!");
     VoteManager.updateLastVoteHopzone(p);
     VoteManager.updateVotes(p);
    }
    else
    {
     p.setIsVoting(false);
     p.sendMessage("You did not vote.Please try again.");
     VoteManager.setTries(player, VoteManager.getTries(p) - 1);
    }
   }
  }
  PreparedStatement statement = null;
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   statement = con.prepareStatement("SELECT lastVoteHopzone FROM characters WHERE obj_Id=?");
   statement.setInt(1, player.getObjectId());
   ResultSet rset = statement.executeQuery();
   while (rset.next())
   {
    lastVoteHopzone = rset.getLong("lastVoteHopzone");
   }
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not select lastvotehopzone from characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
  if (getTries(player) <= 0)
  {
   player.sendMessage("Due to your multiple failures in voting you lost your chance to vote today");
  }
  else if (((lastVoteHopzone + voteDelay) < System.currentTimeMillis()) && (getTries(player) > 0))
  {
   for (L2PcInstance j : L2World.getAllPlayers())
   {
    if (j.isVoting())
    {
     player.sendMessage("Someone is already voting.Wait for your turn please!");
     return;
    }
   }
   player.setIsVoting(true);
   player.sendMessage("Go fast on the site and vote on the hopzone banner!");
   player.sendMessage("You have " + Config.SECS_TO_VOTE + " seconds.Hurry!");
   ThreadPoolManager.getInstance().scheduleGeneral(new hopvotetask(player), Config.SECS_TO_VOTE * 1000);
  }
  else if ((getTries(player) <= 0) && ((lastVoteHopzone + voteDelay) < System.currentTimeMillis()))
  {
   for (L2PcInstance j : L2World.getAllPlayers())
   {
    if (j.isVoting())
    {
     player.sendMessage("Someone is already voting.Wait for your turn please!");
     return;
    }
   }
   player.setIsVoting(true);
   player.sendMessage("Go fast on the site and vote on the hopzone banner!");
   player.sendMessage("You have " + Config.SECS_TO_VOTE + " seconds.Hurry!");
   ThreadPoolManager.getInstance().scheduleGeneral(new hopvotetask(player), Config.SECS_TO_VOTE * 1000);
  }
  else
  {
   player.sendMessage("12 hours have to pass till you are able to vote again.");
  }
}
public static void topvote(final L2PcInstance player)
{
  long lastVoteTopzone = 0L;
  long voteDelay = 43200000L;
  final int firstvotestop;
  firstvotestop = getTopZoneVotes();
  class topvotetask implements Runnable
  {
   private final L2PcInstance p;
   public topvotetask(L2PcInstance player)
   {
    p = player;
   }
   @Override
   public void run()
   {
    if (firstvotestop < getTopZoneVotes())
    {
     p.setIsVoting(false);
     VoteManager.setHasVotedTop(p);
     p.sendMessage("Thank you for voting for us!");
     VoteManager.updateLastVoteTopzone(p);
     VoteManager.updateVotes(p);
    }
    else
    {
     p.setIsVoting(false);
     p.sendMessage("You did not vote.Please try again.");
     VoteManager.setTries(p, VoteManager.getTries(p) - 1);
    }
   }
  }
  PreparedStatement statement = null;
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   statement = con.prepareStatement("SELECT lastVoteTopzone FROM characters WHERE obj_Id=?");
   statement.setInt(1, player.getObjectId());
   ResultSet rset = statement.executeQuery();
   while (rset.next())
   {
    lastVoteTopzone = rset.getLong("lastVoteTopzone");
   }
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not select lastvotehopzone from characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
  if (getTries(player) <= 0)
  {
   player.sendMessage("Due to your multiple failures in voting you lost your chance to vote today");
  }
  else if ((getTries(player) <= 0) && ((lastVoteTopzone + voteDelay) < System.currentTimeMillis()))
  {
   for (L2PcInstance j : L2World.getAllPlayers())
   {
    if (j.isVoting())
    {
     player.sendMessage("Someone is already voting.Wait for your turn please!");
     return;
    }
   }
   player.setIsVoting(true);
   player.sendMessage("Go fast on the site and vote on the topzone banner!");
   player.sendMessage((new StringBuilder()).append("You have ").append(Config.SECS_TO_VOTE).append(" seconds.Hurry!").toString());
   ThreadPoolManager.getInstance().scheduleGeneral(new topvotetask(player), Config.SECS_TO_VOTE * 1000);
  }
  else if (((lastVoteTopzone + voteDelay) < System.currentTimeMillis()) && (getTries(player) > 0))
  {
   for (L2PcInstance j : L2World.getAllPlayers())
   {
    if (j.isVoting())
    {
     player.sendMessage("Someone is already voting.Wait for your turn please!");
     return;
    }
   }
   player.setIsVoting(true);
   player.sendMessage("Go fast on the site and vote on the topzone banner!");
   player.sendMessage((new StringBuilder()).append("You have ").append(Config.SECS_TO_VOTE).append(" seconds.Hurry!").toString());
   ThreadPoolManager.getInstance().scheduleGeneral(new topvotetask(player), Config.SECS_TO_VOTE * 1000);
  }
  else
  {
   player.sendMessage("12 hours have to pass till you are able to vote again.");
  }
}
public static void hasVotedHop(L2PcInstance player)
{
  int hasVotedHop = -1;
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("SELECT hasVotedHop FROM characters WHERE obj_Id=?");
   statement.setInt(1, player.getObjectId());
   ResultSet rset = statement.executeQuery();
   while (rset.next())
   {
    hasVotedHop = rset.getInt("hasVotedHop");
   }
   if (hasVotedHop == 1)
   {
    setHasVotedHop(true);
   }
   else if (hasVotedHop == 0)
   {
    setHasVotedHop(false);
   }
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not select hasVotedHop from characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
}
public static void hasVotedTop(L2PcInstance player)
{
  int hasVotedTop = -1;
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("SELECT hasVotedTop FROM characters WHERE obj_Id=?");
   statement.setInt(1, player.getObjectId());
   ResultSet rset = statement.executeQuery();
   while (rset.next())
   {
    hasVotedTop = rset.getInt("hasVotedTop");
   }
   if (hasVotedTop == 1)
   {
    setHasVotedTop(true);
   }
   else if (hasVotedTop == 0)
   {
    setHasVotedTop(false);
   }
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not select hasVotedHop from characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
}
public static void updateVotes(L2PcInstance activeChar)
{
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("UPDATE characters SET monthVotes=?, totalVotes=? WHERE obj_Id=?");
   statement.setInt(1, getMonthVotes(activeChar) + 1);
   statement.setInt(2, getTotalVotes(activeChar) + 1);
   statement.setInt(3, activeChar.getObjectId());
   statement.execute();
   statement.close();
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not update votes on table characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
}
public static void setHasVotedHop(L2PcInstance activeChar)
{
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("UPDATE characters SET hasVotedHop=? WHERE obj_Id=?");
   statement.setInt(1, 1);
   statement.setInt(2, activeChar.getObjectId());
   statement.execute();
   statement.close();
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not update hasVotedHop in characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
}
public static void setHasVotedTop(L2PcInstance activeChar)
{
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("UPDATE characters SET hasVotedTop=? WHERE obj_Id=?");
   statement.setInt(1, 1);
   statement.setInt(2, activeChar.getObjectId());
   statement.execute();
   statement.close();
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not update hasVotedTop in characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
}
public static void setHasNotVotedHop(L2PcInstance activeChar)
{
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("UPDATE characters SET hasVotedHop=? WHERE obj_Id=?");
   statement.setInt(1, 0);
   statement.setInt(2, activeChar.getObjectId());
   statement.execute();
   statement.close();
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not update hasVotedHop in characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
}
public static void setHasNotVotedTop(L2PcInstance activeChar)
{
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("UPDATE characters SET hasVotedTop=? WHERE obj_Id=?");
   statement.setInt(1, 0);
   statement.setInt(2, activeChar.getObjectId());
   statement.execute();
   statement.close();
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not update hasVotedTop in characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
}
public static int getTries(L2PcInstance player)
{
  int tries = -1;
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("SELECT tries FROM characters WHERE obj_Id=?");
   statement.setInt(1, player.getObjectId());
   for (ResultSet rset = statement.executeQuery(); rset.next()
   {
    tries = rset.getInt("tries");
   }
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not get tries from characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
  return tries;
}
public static void setTries(L2PcInstance player, int tries)
{
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("UPDATE characters SET tries=? WHERE obj_Id=?");
   statement.setInt(1, tries);
   statement.setInt(2, player.getObjectId());
   statement.execute();
   statement.close();
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not update tries in characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
}
public static int getMonthVotes(L2PcInstance player)
{
  int monthVotes = -1;
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("SELECT monthVotes FROM characters WHERE obj_Id=?");
   statement.setInt(1, player.getObjectId());
   for (ResultSet rset = statement.executeQuery(); rset.next()
   {
    monthVotes = rset.getInt("monthVotes");
   }
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not select monthVotes from characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
  return monthVotes;
}
public static int getTotalVotes(L2PcInstance player)
{
  int totalVotes = -1;
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("SELECT totalVotes FROM characters WHERE obj_Id=?");
   statement.setInt(1, player.getObjectId());
   for (ResultSet rset = statement.executeQuery(); rset.next()
   {
    totalVotes = rset.getInt("totalVotes");
   }
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not select totalVotes from characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
  return totalVotes;
}
public static int getBigTotalVotes(L2PcInstance player)
{
  int bigTotalVotes = -1;
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("SELECT SUM(totalVotes) FROM characters");
   for (ResultSet rset = statement.executeQuery(); rset.next()
   {
    bigTotalVotes = rset.getInt("SUM(totalVotes)");
   }
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not select totalVotes from characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
  return bigTotalVotes;
}
public static int getBigMonthVotes(L2PcInstance player)
{
  int bigMonthVotes = -1;
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("SELECT SUM(monthVotes) FROM characters");
   for (ResultSet rset = statement.executeQuery(); rset.next()
   {
    bigMonthVotes = rset.getInt("SUM(monthVotes)");
   }
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not select monthVotes from characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
  return bigMonthVotes;
}
public static void updateLastVoteHopzone(L2PcInstance player)
{
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("UPDATE characters SET lastVoteHopzone=? WHERE obj_Id=?");
   statement.setLong(1, System.currentTimeMillis());
   statement.setInt(2, player.getObjectId());
   statement.execute();
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not update lastVoteHopzone in characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
}
public static void updateLastVoteTopzone(L2PcInstance player)
{
  try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  {
   PreparedStatement statement = con.prepareStatement("UPDATE characters SET lastVoteTopzone=? WHERE obj_Id=?");
   statement.setLong(1, System.currentTimeMillis());
   statement.setInt(2, player.getObjectId());
   statement.execute();
  }
  catch (Exception e)
  {
   _log.log(Level.WARNING, "VoteManager: could not update lastVoteTopzone in characters " + e);
   if (Config.DEVELOPER)
   {
    e.printStackTrace();
   }
  }
}
// Getters and Setters
public static boolean hasVotedHop()
{
  return hasVotedHop;
}
public static void setHasVotedHop(boolean hasVotedHop)
{
  VoteManager.hasVotedHop = hasVotedHop;
}
public static boolean hasVotedTop()
{
  return hasVotedTop;
}
public static void setHasVotedTop(boolean hasVotedTop)
{
  VoteManager.hasVotedTop = hasVotedTop;
}
}

    Error Anagki

    in Request Server Development Help [Greek]

    Posted

    stile edw ta configs

    # ================================================================ #

    #                          Vote System                             #

    # ================================================================ #

    HopzoneUrl = http://l2.hopzone.net/lineage2/details/99300/Lineage-2-Infector

    TopzoneUrl =

    # The characters will have a choice between 3 rewards.Set id for them

    VoteRewardId1 = 9142

    VoteRewardId2 = 9142

    VoteRewardId3 = 9142

    # Set the amount of each reward.

    VoteRewardAmount1 = 1

    VoteRewardAmount2 = 2

    VoteRewardAmount3 = 3

    # Set the seconds that the character has

    # until he votes in the site's banners

    SecondsToVote = 20

    # Amount of votes a character must collect

    # in order to get the 4th vote reward

    ExtraRewVoteAm = 20

    # Info of the extra reward item

    VoteRewardId4 = 9142

    VoteRewardAmount4 = 4

     

    exo kai ena allo problima o server mou exi polla bugs einai unblancer kai trwne dc oli

×
×
  • 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