/*
* 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 lineage2.gameserver.taskmanager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import lineage2.commons.dbutils.DbUtils;
import lineage2.commons.threading.RunnableImpl;
import lineage2.gameserver.ThreadPoolManager;
import lineage2.gameserver.data.xml.holder.ItemHolder;
import lineage2.gameserver.database.DatabaseFactory;
import lineage2.gameserver.model.GameObjectsStorage;
import lineage2.gameserver.model.Player;
import lineage2.gameserver.model.items.ItemInstance;
import lineage2.gameserver.model.items.ItemInstance.ItemLocation;
import lineage2.gameserver.model.items.PcInventory;
import lineage2.gameserver.network.serverpackets.SystemMessage2;
import lineage2.gameserver.utils.ItemFunctions;
import lineage2.gameserver.utils.Log;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
/**
* @author Mobius
* @version $Revision: 1.0 $
*/
public class DelayedItemsManager extends RunnableImpl
{
/**
* Field _log.
*/
private static final Logger _log = LoggerFactory.getLogger(DelayedItemsManager.class);
/**
* Field _instance.
*/
private static DelayedItemsManager _instance;
/**
* Field _lock.
*/
private static final Object _lock = new Object();
/**
* Field last_payment_id.
*/
private int last_payment_id = 0;
/**
* Method getInstance.
* @return DelayedItemsManager
*/
public static DelayedItemsManager getInstance()
{
if (_instance == null)
{
_instance = new DelayedItemsManager();
}
return _instance;
}
/**
* Constructor for DelayedItemsManager.
*/
public DelayedItemsManager()
{
Connection con = null;
try
{
con = DatabaseFactory.getInstance().getConnection();
last_payment_id = get_last_payment_id(con);
}
catch (Exception e)
{
_log.error("", e);
}
finally
{
DbUtils.closeQuietly(con);
}
ThreadPoolManager.getInstance().schedule(this, 10000L);
}
/**
* Method get_last_payment_id.
* @param con Connection
* @return int
*/
private int get_last_payment_id(Connection con)
{
PreparedStatement st = null;
ResultSet rset = null;
int result = last_payment_id;
try
{
st = con.prepareStatement("SELECT MAX(payment_id) AS last FROM items_delayed");
rset = st.executeQuery();
if (rset.next())
{
result = rset.getInt("last");
}
}
catch (Exception e)
{
_log.error("", e);
}
finally
{
DbUtils.closeQuietly(st, rset);
}
return result;
}
/**
* Method runImpl.
*/
@Override
public void runImpl()
{
Player player = null;
Connection con = null;
PreparedStatement st = null;
ResultSet rset = null;
try
{
con = DatabaseFactory.getInstance().getConnection();
int last_payment_id_temp = get_last_payment_id(con);
if (last_payment_id_temp != last_payment_id)
{
synchronized (_lock)
{
st = con.prepareStatement("SELECT DISTINCT owner_id FROM items_delayed WHERE payment_status=0 AND payment_id > ?");
st.setInt(1, last_payment_id);
rset = st.executeQuery();
while (rset.next())
{
if ((player = GameObjectsStorage.getPlayer(rset.getInt("owner_id"))) != null)
{
loadDelayed(player, true);
}
}
last_payment_id = last_payment_id_temp;
}
}
}
catch (Exception e)
{
_log.error("", e);
}
finally
{
DbUtils.closeQuietly(con, st, rset);
}
ThreadPoolManager.getInstance().schedule(this, 10000L);
}
/**
* Method loadDelayed.
* @param player Player
* @param notify boolean
* @return int
*/
public int loadDelayed(Player player, boolean notify)
{
if (player == null)
{
return 0;
}
final int player_id = player.getObjectId();
final PcInventory inv = player.getInventory();
if (inv == null)
{
return 0;
}
int restored_counter = 0;
Connection con = null;
PreparedStatement st = null, st_delete = null;
ResultSet rset = null;
synchronized (_lock)
{
try
{
con = DatabaseFactory.getInstance().getConnection();
st = con.prepareStatement("SELECT * FROM items_delayed WHERE owner_id=? AND payment_status=0");
st.setInt(1, player_id);
rset = st.executeQuery();
ItemInstance item, newItem;
st_delete = con.prepareStatement("UPDATE items_delayed SET payment_status=1 WHERE payment_id=?");
while (rset.next())
{
final int ITEM_ID = rset.getInt("item_id");
final long ITEM_COUNT = rset.getLong("count");
final int ITEM_ENCHANT = rset.getInt("enchant_level");
final int PAYMENT_ID = rset.getInt("payment_id");
final int FLAGS = rset.getInt("flags");
rset.getInt("attribute");
rset.getInt("attribute_level");
boolean stackable = ItemHolder.getInstance().getTemplate(ITEM_ID).isStackable();
boolean success = false;
for (int i = 0; i < (stackable ? 1 : ITEM_COUNT); i++)
{
item = ItemFunctions.createItem(ITEM_ID);
if (item.isStackable())
{
item.setCount(ITEM_COUNT);
}
else
{
item.setEnchantLevel(ITEM_ENCHANT);
}
item.setLocation(ItemLocation.INVENTORY);
item.setCustomFlags(FLAGS);
if (ITEM_COUNT > 0)
{
newItem = inv.addItem(item);
if (newItem == null)
{
_log.warn("Unable to delayed create item " + ITEM_ID + " request " + PAYMENT_ID);
continue;
}
}
success = true;
restored_counter++;
if (notify && (ITEM_COUNT > 0))
{
player.sendPacket(SystemMessage2.obtainItems(ITEM_ID, stackable ? ITEM_COUNT : 1, ITEM_ENCHANT));
}
}
if (!success)
{
continue;
}
Log.add("<add owner_id=" + player_id + " item_id=" + ITEM_ID + " count=" + ITEM_COUNT + " enchant_level=" + ITEM_ENCHANT + " payment_id=" + PAYMENT_ID + "/>", "delayed_add");
st_delete.setInt(1, PAYMENT_ID);
st_delete.execute();
}
}
catch (Exception e)
{
_log.error("Could not load delayed items for player " + player + "!", e);
}
finally
{
DbUtils.closeQuietly(st_delete);
DbUtils.closeQuietly(con, st, rset);
}
}
return restored_counter;
}
}