src/main/java/com/l2jserver/gameserver/instancemanager/ItemsOnGroundManager.java - develop - tofu/l2interlude

src/main/java/com/l2jserver/gameserver/instancemanager/ItemsOnGroundManager.java
214 строк7 KB
Zoey76
01 янв 2025, 07:57
01 янв 2025, 07:5716130a5
/*
 * Copyright © 2004-2025 L2J Server
 * 
 * This file is part of L2J Server.
 * 
 * L2J Server 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.
 * 
 * L2J Server 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 com.l2jserver.gameserver.instancemanager;

import static com.l2jserver.gameserver.config.Configuration.general;

import java.util.List;
import java.util.concurrent.CopyOnWriteArrayList;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import com.l2jserver.commons.database.ConnectionFactory;
import com.l2jserver.gameserver.ItemsAutoDestroy;
import com.l2jserver.gameserver.ThreadPoolManager;
import com.l2jserver.gameserver.model.L2World;
import com.l2jserver.gameserver.model.items.instance.L2ItemInstance;

/**
 * This class manage all items on ground.
 * @author Enforcer
 */
public final class ItemsOnGroundManager implements Runnable {
	
	private static final Logger LOG = LoggerFactory.getLogger(ItemsOnGroundManager.class);
	
	private final List<L2ItemInstance> _items = new CopyOnWriteArrayList<>();
	
	private ItemsOnGroundManager() {
		if (general().getSaveDroppedItemInterval() > 0) {
			ThreadPoolManager.getInstance().scheduleGeneralAtFixedRate(this, general().getSaveDroppedItemInterval(), general().getSaveDroppedItemInterval());
		}
		load();
	}
	
	private void load() {
		// If SaveDroppedItem is false, may want to delete all items previously stored to avoid add old items on reactivate
		if (!general().saveDroppedItem() && general().clearDroppedItemTable()) {
			emptyTable();
		}
		
		if (!general().saveDroppedItem()) {
			return;
		}
		
		// if DestroyPlayerDroppedItem was previously false, items currently protected will be added to ItemsAutoDestroy
		if (general().destroyPlayerDroppedItem()) {
			String str;
			if (!general().destroyEquipableItem()) {
				// Recycle misc. items only
				str = "UPDATE itemsonground SET drop_time = ? WHERE drop_time = -1 AND equipable = 0";
			} else {
				// Recycle all items including equipable
				str = "UPDATE itemsonground SET drop_time = ? WHERE drop_time = -1";
			}
			
			try (var con = ConnectionFactory.getInstance().getConnection();
				var ps = con.prepareStatement(str)) {
				ps.setLong(1, System.currentTimeMillis());
				ps.execute();
			} catch (Exception e) {
				LOG.error("Error while updating table ItemsOnGround: {}", e.getMessage(), e);
			}
		}
		
		// Add items to world
		try (var con = ConnectionFactory.getInstance().getConnection();
			var ps = con.prepareStatement("SELECT object_id,item_id,count,enchant_level,x,y,z,drop_time,equipable FROM itemsonground")) {
			int count = 0;
			try (var rs = ps.executeQuery()) {
				L2ItemInstance item;
				while (rs.next()) {
					item = new L2ItemInstance(rs.getInt(1), rs.getInt(2));
					L2World.getInstance().storeObject(item);
					// this check and..
					if (item.isStackable() && (rs.getInt(3) > 1)) {
						item.setCount(rs.getInt(3));
					}
					// this, are really necessary?
					if (rs.getInt(4) > 0) {
						item.setEnchantLevel(rs.getInt(4));
					}
					item.setXYZ(rs.getInt(5), rs.getInt(6), rs.getInt(7));
					item.setWorldRegion(L2World.getInstance().getRegion(item.getLocation()));
					item.getWorldRegion().addVisibleObject(item);
					final long dropTime = rs.getLong(8);
					item.setDropTime(dropTime);
					item.setProtected(dropTime == -1);
					item.setIsVisible(true);
					L2World.getInstance().addVisibleObject(item, item.getWorldRegion());
					_items.add(item);
					count++;
					// add to ItemsAutoDestroy only items not protected
					if (!general().getProtectedItems().contains(item.getId())) {
						if (dropTime > -1) {
							if (((general().getAutoDestroyDroppedItemAfter() > 0) && !item.getItem().hasExImmediateEffect()) || ((general().getAutoDestroyHerbTime() > 0) && item.getItem().hasExImmediateEffect())) {
								ItemsAutoDestroy.getInstance().addItem(item);
							}
						}
					}
				}
			}
			LOG.info("Loaded {} items.", count);
		} catch (Exception e) {
			LOG.error("Error while loading ItemsOnGround: {}", e.getMessage(), e);
		}
		
		if (general().emptyDroppedItemTableAfterLoad()) {
			emptyTable();
		}
	}
	
	public void save(L2ItemInstance item) {
		if (!general().saveDroppedItem()) {
			return;
		}
		_items.add(item);
	}
	
	public void removeObject(L2ItemInstance item) {
		if (general().saveDroppedItem()) {
			_items.remove(item);
		}
	}
	
	public void saveInDb() {
		run();
	}
	
	public void cleanUp() {
		_items.clear();
	}
	
	private void emptyTable() {
		try (var con = ConnectionFactory.getInstance().getConnection();
			var s = con.createStatement()) {
			s.executeUpdate("DELETE FROM itemsonground");
		} catch (Exception e1) {
			LOG.error("Error while cleaning table ItemsOnGround: {}", e1.getMessage(), e1);
		}
	}
	
	@Override
	public synchronized void run() {
		if (!general().saveDroppedItem()) {
			return;
		}
		
		emptyTable();
		
		if (_items.isEmpty()) {
			return;
		}
		
		try (var con = ConnectionFactory.getInstance().getConnection();
			var ps = con.prepareStatement("INSERT INTO itemsonground(object_id,item_id,count,enchant_level,x,y,z,drop_time,equipable) VALUES(?,?,?,?,?,?,?,?,?)")) {
			for (L2ItemInstance item : _items) {
				if (item == null) {
					continue;
				}
				
				if (CursedWeaponsManager.getInstance().isCursed(item.getId())) {
					continue; // Cursed Items not saved to ground, prevent double save
				}
				
				try {
					ps.setInt(1, item.getObjectId());
					ps.setInt(2, item.getId());
					ps.setLong(3, item.getCount());
					ps.setInt(4, item.getEnchantLevel());
					ps.setInt(5, item.getX());
					ps.setInt(6, item.getY());
					ps.setInt(7, item.getZ());
					ps.setLong(8, (item.isProtected() ? -1 : item.getDropTime())); // item is protected or AutoDestroyed
					ps.setLong(9, (item.isEquipable() ? 1 : 0)); // set equip-able
					ps.execute();
					ps.clearParameters();
				} catch (Exception e) {
					LOG.error("Error while inserting into table ItemsOnGround: {}", e.getMessage(), e);
				}
			}
		} catch (Exception e) {
			LOG.error("SQL error while storing items on ground: {}", e.getMessage(), e);
		}
	}
	
	/**
	 * Gets the single instance of {@code ItemsOnGroundManager}.
	 * @return single instance of {@code ItemsOnGroundManager}
	 */
	public static ItemsOnGroundManager getInstance() {
		return SingletonHolder._instance;
	}
	
	private static class SingletonHolder {
		protected static final ItemsOnGroundManager _instance = new ItemsOnGroundManager();
	}
}