[share] HopZone Java Vote Reward

[ButterCup]

  Quote

Create a List, add the ip in the reward method and before check if ip is not in List.

 

:)

 

Let me help you 

 

Check multiple box protection  do you see a list with IPs ? you can use  a part of that script, idea is !  if you allow  2 or  XXXX box online where the reward will go ? on what char ?

 

[UnAfraid]

  On 9/10/2010 at 2:11 AM, ButterCup said:

 

 

:)

 

Let me help you  

 

Check multiple box protection  do you see a list with IPs ? you can use  a part of that script, idea is !  if you allow  2 or  XXXX box online where the reward will go ? on what char ?

 

 

are u read the script??

have u see what it do .. ?

 

PreparedStatement statement = con.prepareStatement("" +

+ "SELECT" +

+ " c.charId," +

+ " c.char_name" +

+ "FROM" +

+ " characters AS c" +

+ "LEFT JOIN" +

+ " accounts AS a" +

+ "ON" +

+ " c.account_name = a.login" +

+ "WHERE" +

+ " c.online > 0" +

+ "GROUP BY" +

+ " a.lastIP" +

+ "ORDER BY" +

+ " c.level" +

+ "DESC");

 

the mysql query getting only chars with unique ip read BetterCup read :)

 

[KIL3R]

make one for topzone too thx

[EvE]

This can be implemented to L2j [freya] ?

[HackMeUpReturns]

  On 10/9/2010 at 12:04 PM, EvE said:

This can be implemented to L2j [freya] ?

It works.

[disorder25]

why hide the share if you can download it on the L2j forum. Lol

[+cs.tribal]

Really cool share mate!

This will make the server keep voting for their rewards!

...nice... it's the best way to get many votes!

thanks!

[Fringe]

Already shared, i can't see it, but i know it already been shared 100000Time... Every 10 votes ppl get reward...

And code starts:

  Quote

package net.sf.l2j.gameserver.model.entity.event;

 

import java.io.BufferedReader;

import java.io.IOException;

import java.io.InputStreamReader;

import java.net.URL;

import java.util.Collection;

import java.util.List;

 

import javolution.util.FastList;

 

 

import net.sf.l2j.gameserver.model.entity.Announcements;

import net.sf.l2j.gameserver.thread.ThreadPoolManager;

 

import net.sf.l2j.gameserver.model.L2World;

import net.sf.l2j.gameserver.model.actor.instance.L2ItemInstance;

import net.sf.l2j.gameserver.model.actor.instance.L2PcInstance;

 

public class AutoVoteRewardHandler

{

private int initialCheck = 60 * 1000; // 60 seconds = 1 minutes

private int delayForCheck = 300 * 1000; // 300 seconds = 10 minutes

//HopZone

 

Code an be founded on junk  section or on l2jserver forum

[EvE]

Registered on login as Server 1 : Bartz
Server Votes: 4038
Master access level set for character KenZoR! Just a warning to be careful ;)
FourSepulchersManager: Entry time: Sun Oct 10 14:55:26 EEST 2010
SevenSigns: Data updated successfully.
Server Votes: 4061
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'AS cLEFT JOIN accounts AS aON c.account_name =
a.loginWHERE   c.online > 0GROUP BY' at line 1
       at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

       at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

       at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
       at java.lang.reflect.Constructor.newInstance(Unknown Source)
       at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
       at com.mysql.jdbc.Util.getInstance(Util.java:384)
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2113)
       at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2275)
       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
       at com.l2jserver.gameserver.instancemanager.AutoVoteRewardHandler$AutoRe
ward.run(AutoVoteRewardHandler.java:68)
       at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
       at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)

       at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
       at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$101(Unknown Source)
       at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
runPeriodic(Unknown Source)
       at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
       at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
       at java.lang.Thread.run(Unknown Source)

 

L2j Server - last rev. - freya!

 

From what I understand I think I have to mention the v. of MySQL : 5.1

[NoLimit]

Same like EvE..

[LordOfDarkness]

  On 9/4/2010 at 11:45 PM, extr3me said:

 

 

I know it is kinda late .. but I've added the java code correctly....

I've edited everything right..

 

take a look I hope is right:

 

+ private final String HOPZONE = "l2.hopzone.net/lineage2/moreinfo/l2goldenarmy/85584.html";

+ // 60 * 1000(1000milliseconds = 1 second) = 60seconds

+ private final int initialCheck = 60 * 1000;

+ // 1800 * 1000(1000milliseconds = 1 second) = 1800seconds = 30minutes

+ private final int delayForCheck = 60 * 1000;

+ private final int[] itemId = { 7569 };

+ private final int[] itemCount = { 5 };

+ private final int[] maxStack = { 1, 1, 1 };

+ private final int votesRequiredForReward = 5;

 

But yet.. I restart my server as well and nothing..

 

what can I do to fix it?:) thanks

[NoLimit]

  Quote

  private final int[] maxStack = { 1, 1, 1 }

maxStack is about how many times you want to share this item!since you put only 1 item (itemId=7569) for share you just need to put how many times you want to share it at maxStack.so delete {1, 1, 1} cuz this is equal for 3 items and add only one value! it would be like private final int[] maxStack = { 9999 } in this way you share your item 9999 times.Try this one and if you have problem message me to give you the whole code...or you can find it at l2j server forum..

[akaravas]

this works on l2j?? or just is a shit code?

[Hardstyle]

  On 12/5/2010 at 4:38 AM, akaravas said:

this works on l2j?? or just is a shit code?

Yap!

 

 

But on l2jforum its says that it works only when you have same DB for gameserver and login...can someone tell me why and how i can fix it?

[fatal2ty]

working?