Нужен Скрипт

[Thodi 79]

Поделитесь может у кого есть Скрипт голосования MMoTop для Хф.

[SoFace 315]

Адаптируйте под ХФ (Если умеете).

package net.sf.l2j.gameserver.custom.deamon;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.URL;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Calendar;
import java.util.StringTokenizer;
import java.util.logging.Logger;

import net.sf.l2j.Config;
import net.sf.l2j.L2DatabaseFactory;
import net.sf.l2j.gameserver.ThreadPoolManager;
import net.sf.l2j.gameserver.model.actor.instance.L2PcInstance;

public class MMOTopDeamon
{
private static final Logger _log = Logger.getLogger(MMOTopDeamon.class.getName());

public static MMOTopDeamon getInstance()
{
return SingletonHolder._instance;
}

protected MMOTopDeamon()
{
if (Config.MMOTopEnable)
{
_log.info("Service: Loading MmoTop Parser...");
ThreadPoolManager.getInstance().scheduleGeneralAtFixedRate(new startParce(), 60000, Config.MMOTopRefreshTime * 60 * 1000);
}
else
{
_log.info("Service: MmoTop Parser - Disabled.");
}
}

protected class startParce implements Runnable
{
@Override
public void run()
{
try
{
getPage(Config.MMOTopUrl);
parse();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}

BufferedReader reader;

protected void parse()
{
String line;

try
{
while ((line = reader.readLine()) != null)
{
StringTokenizer st = new StringTokenizer(line, "\t. :");
while (st.hasMoreTokens())
{
try
{
st.nextToken();
int day = Integer.parseInt(st.nextToken());
int month = Integer.parseInt(st.nextToken());
int year = Integer.parseInt(st.nextToken());
int hour = Integer.parseInt(st.nextToken());
int minute = Integer.parseInt(st.nextToken());
int second = Integer.parseInt(st.nextToken());
st.nextToken();
st.nextToken();
st.nextToken();
st.nextToken();
String name = st.nextToken();
L2PcInstance player = VoteUtils.loadPlayer(name);
if ((player != null) && player.isOnline())
{
Calendar calendar = Calendar.getInstance();
calendar.set(Calendar.YEAR, year);
calendar.set(Calendar.MONTH, month);
calendar.set(Calendar.DAY_OF_MONTH, day);
calendar.set(Calendar.HOUR_OF_DAY, hour);
calendar.set(Calendar.MINUTE, minute);
calendar.set(Calendar.SECOND, second);
calendar.set(Calendar.MILLISECOND, 0);
long time = calendar.getTimeInMillis() / 1000;
checkAndSave(name, time);
}
}
catch (Exception e)
{
}
}
}
}
catch (Exception e)
{
e.printStackTrace();
}
}

private void checkAndSave(String name, long time)
{
_log.info("MMOTopDeamon: Checking mmotop.ru....");
int nVotes = 0;
try (Connection con = L2DatabaseFactory.getInstance().getConnection())
{
PreparedStatement fps = con.prepareStatement("SELECT * FROM `mmotop_votes` WHERE `name`=? AND `time`=? LIMIT 1");
fps.setString(1, name);
fps.setLong(2, time);
ResultSet rs = fps.executeQuery();
if (!rs.next())
{
L2PcInstance player = VoteUtils.loadPlayer(name);
if (player != null)
{
player.addItem("mmotop", Config.MMOTopRewardItemId, Config.MMOTopRewardItemCount, null, true);
if (player.isOnline())
{
player.sendMessage("Вам начислена награда за голосование в рейтинге MMOTop.");
}
player.store();
fps = con.prepareStatement("INSERT INTO `mmotop_votes` (`name`, `time`) VALUES (?, ?)");
fps.setString(1, name);
fps.setLong(2, time);
fps.execute();
nVotes++;
}
}
_log.info("MMOTopDeamon: " + nVotes + " vote(s) parsed");
}
catch (Exception e)
{
e.printStackTrace();
}
}

protected void getPage(String address)
{
try
{
URL url = new URL(address);
new BufferedReader(new InputStreamReader(url.openStream(), "Cp1251"));
}
catch (Exception e)
{
e.printStackTrace();
}
}

private static class SingletonHolder
{
protected static final MMOTopDeamon _instance = new MMOTopDeamon();
}
}

[dislike 302]

 

 

package l2ft.gameserver.instancemanager;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.URL;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Calendar;
import java.util.StringTokenizer;
import java.util.logging.Logger;

import l2ft.commons.dbutils.DbUtils;
import l2ft.gameserver.Config;
import l2ft.gameserver.ThreadPoolManager;
import l2ft.gameserver.database.DatabaseFactory;
import l2ft.gameserver.model.GameObjectsStorage;
import l2ft.gameserver.model.Player;
import l2ft.gameserver.utils.Log;

public class MMOTopManager
{
private static Logger _log = Logger.getLogger(MMOTopManager.class.getName());

private static final String SELECT_PLAYER_OBJID = "SELECT obj_Id FROM characters WHERE char_name=?";
private static final String SELECT_CHARACTER_MMOTOP_DATA = "SELECT * FROM character_mmotop_votes WHERE id=? AND date=? AND multipler=?";
private static final String INSERT_MMOTOP_DATA = "INSERT INTO character_mmotop_votes (date, id, nick, multipler) values (?,?,?,?)";
private static final String DELETE_MMOTOP_DATA = "DELETE FROM character_mmotop_votes WHERE date<?";
private static final String SELECT_MULTIPLER_MMOTOP_DATA = "SELECT multipler FROM character_mmotop_votes WHERE id=? AND has_reward=0";
private static final String UPDATE_MMOTOP_DATA = "UPDATE character_mmotop_votes SET has_reward=1 WHERE id=?";

BufferedReader reader;

private static MMOTopManager _instance;

public static MMOTopManager getInstance()
{
if(_instance == null && Config.MMO_TOP_MANAGER_ENABLED)
_instance = new MMOTopManager();
return _instance;
}

public MMOTopManager()
{
ThreadPoolManager.getInstance().scheduleAtFixedRate(new ConnectAndUpdate(), Config.MMO_TOP_MANAGER_INTERVAL, Config.MMO_TOP_MANAGER_INTERVAL);
ThreadPoolManager.getInstance().scheduleAtFixedRate(new Clean(), Config.MMO_TOP_MANAGER_INTERVAL, Config.MMO_TOP_MANAGER_INTERVAL);
ThreadPoolManager.getInstance().scheduleAtFixedRate(new GiveReward(), Config.MMO_TOP_MANAGER_INTERVAL, Config.MMO_TOP_MANAGER_INTERVAL);
_log.info("MMOTopManager: loaded sucesfully");
}

public void getPage(String address)
{
try
{
URL url = new URL(address);
reader = new BufferedReader(new InputStreamReader(url.openStream(), "UTF8"));
}
catch(Exception e)
{
e.printStackTrace();
}
}

public void parse()
{
try
{
String line;
while((line = reader.readLine()) != null)
{
StringTokenizer st = new StringTokenizer(line, "\t. :");
while(st.hasMoreTokens())
try
{
st.nextToken();
int day = Integer.parseInt(st.nextToken());
int month = Integer.parseInt(st.nextToken()) - 1;
int year = Integer.parseInt(st.nextToken());
int hour = Integer.parseInt(st.nextToken());
int minute = Integer.parseInt(st.nextToken());
int second = Integer.parseInt(st.nextToken());
st.nextToken();
st.nextToken();
st.nextToken();
st.nextToken();
String charName = st.nextToken();
int voteType = Integer.parseInt(st.nextToken());

Calendar calendar = Calendar.getInstance();
calendar.set(1, year);
calendar.set(2, month);
calendar.set(5, day);
calendar.set(11, hour);
calendar.set(12, minute);
calendar.set(13, second);
calendar.set(14, 0);

long voteTime = calendar.getTimeInMillis() / 1000;

if(voteTime + Config.MMO_TOP_SAVE_DAYS * 86400 > System.currentTimeMillis() / 1000)
checkAndSave(voteTime, charName, voteType);
}
catch(Exception e)
{}
}
}
catch(Exception e)
{
_log.warning("MMOTopManager: Cant store MMOTop data.");
e.printStackTrace();
}
}

public void checkAndSave(long voteTime, String charName, int voteType)
{
Connection con = null;
PreparedStatement selectObjectStatement = null, selectMmotopStatement = null, insertStatement = null;
ResultSet rsetObject = null, rsetMmotop = null;
try
{
con = DatabaseFactory.getInstance().getConnection();
selectObjectStatement = con.prepareStatement(SELECT_PLAYER_OBJID);
selectObjectStatement.setString(1, charName);
rsetObject = selectObjectStatement.executeQuery();

int objId = 0;
if(rsetObject.next())
objId = rsetObject.getInt("obj_Id");
if(objId > 0)
{
selectMmotopStatement = con.prepareStatement(SELECT_CHARACTER_MMOTOP_DATA);
selectMmotopStatement.setInt(1, objId);
selectMmotopStatement.setLong(2, voteTime);
selectMmotopStatement.setInt(3, voteType);
rsetMmotop = selectMmotopStatement.executeQuery();
if(!rsetMmotop.next())
{
insertStatement = con.prepareStatement(INSERT_MMOTOP_DATA);
insertStatement.setLong(1, voteTime);
insertStatement.setInt(2, objId);
insertStatement.setString(3, charName);
insertStatement.setInt(4, voteType);
insertStatement.execute();
insertStatement.close();
}
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
DbUtils.closeQuietly(con, selectObjectStatement, rsetObject);
DbUtils.closeQuietly(con, selectMmotopStatement, rsetMmotop);
DbUtils.closeQuietly(con, insertStatement);
}
}

private synchronized void clean()
{
Calendar calendar = Calendar.getInstance();
calendar.add(Calendar.DAY_OF_YEAR, -Config.MMO_TOP_SAVE_DAYS);
Connection con = null;
PreparedStatement statement = null;
try
{
con = DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement(DELETE_MMOTOP_DATA);
statement.setLong(1, calendar.getTimeInMillis() / 1000);
statement.execute();
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
DbUtils.closeQuietly(con, statement);
}
}

private synchronized void giveReward()
{
Connection con = null;
PreparedStatement selectMultStatement = null, updateStatement = null;
ResultSet rsetMult = null;
try
{
con = DatabaseFactory.getInstance().getConnection();
for(Player player : GameObjectsStorage.getAllPlayers())
{
int objId = player.getObjectId();
int mult = 0;
selectMultStatement = con.prepareStatement(SELECT_MULTIPLER_MMOTOP_DATA);
selectMultStatement.setInt(1, objId);
rsetMult = selectMultStatement.executeQuery();

while(rsetMult.next())
mult += rsetMult.getInt("multipler");

if(mult > 0)
{
updateStatement = con.prepareStatement(UPDATE_MMOTOP_DATA);
updateStatement.setInt(1, objId);
updateStatement.executeUpdate();

if(player.getVar("lang@").equalsIgnoreCase("ru"))
player.sendMessage("Спасибо за Ваш голос в рейтинге MMOTop. C наилучшими пожеланиями " + Config.MMO_TOP_SERVER_ADDRESS);
else
player.sendMessage("Thank you for your vote in MMOTop raiting. Best regards " + Config.L2_TOP_SERVER_ADDRESS);
for(int i = 0; i < Config.MMO_TOP_REWARD.length; i += 2)
{
if(Config.MMO_TOP_REWARD[i] == -100) // PC Bang
{
player.addPcBangPoints((Config.MMO_TOP_REWARD[i + 1] * mult), false);
Log.add(player.getName() + " | " + player.getObjectId() + " | MMOTop reward item ID | " + Config.MMO_TOP_REWARD[i] + " | MMOTop reward count | " + (Config.MMO_TOP_REWARD[i + 1] * mult) + " |", "mmotop");
}
else if(Config.MMO_TOP_REWARD[i] == -200) // Clan reputation
{
player.getClan().incReputation((Config.MMO_TOP_REWARD[i + 1] * mult));
Log.add(player.getName() + " | " + player.getObjectId() + " | MMOTop reward item ID | " + Config.MMO_TOP_REWARD[i] + " | MMOTop reward count | " + (Config.MMO_TOP_REWARD[i + 1] * mult) + " |", "mmotop");
}
else if(Config.MMO_TOP_REWARD[i] == -300) // Fame
{
player.setFame(player.getFame() + (Config.MMO_TOP_REWARD[i + 1] * mult));
Log.add(player.getName() + " | " + player.getObjectId() + " | MMOTop reward item ID | " + Config.MMO_TOP_REWARD[i] + " | MMOTop reward count | " + (Config.MMO_TOP_REWARD[i + 1] * mult) + " |", "mmotop");
}
else
{
player.getInventory().addItem(Config.MMO_TOP_REWARD[i], (Config.MMO_TOP_REWARD[i + 1] * mult));
Log.add(player.getName() + " | " + player.getObjectId() + " | MMOTop reward item ID | " + Config.MMO_TOP_REWARD[i] + " | MMOTop reward count | " + (Config.MMO_TOP_REWARD[i + 1] * mult) + " |", "mmotop");
}
}
}
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
DbUtils.closeQuietly(con, selectMultStatement, rsetMult);
DbUtils.closeQuietly(con, updateStatement);
}
}

private class ConnectAndUpdate implements Runnable
{
@Override
public void run()
{
getPage(Config.MMO_TOP_WEB_ADDRESS);
parse();
}
}

private class Clean implements Runnable
{
@Override
public void run()
{
clean();
}
}

private class GiveReward implements Runnable
{
@Override
public void run()
{
giveReward();
}
}
}

 

 

Изменено 19 октября, 2013 пользователем dislike

[Thodi 79]

В том то и дело что не смогу(