package l2p.gameserver.instancemanager;
import java.sql.ResultSet;
import java.util.logging.Logger;
import javolution.util.FastMap;
import l2p.database.DatabaseUtils;
import l2p.database.FiltredPreparedStatement;
import l2p.database.L2DatabaseFactory;
import l2p.database.ThreadConnection;
import l2p.gameserver.model.L2Player;
import l2p.gameserver.model.entity.residence.Residence;
import l2p.gameserver.model.items.L2ItemInstance;
import l2p.gameserver.tables.ItemTable;
import l2p.util.GArray;
import l2p.util.Location;
public class MercTicketManager
{
protected static Logger _log = Logger.getLogger(CastleManager.class.getName());
private static MercTicketManager _instance;
public synchronized static MercTicketManager getInstance()
{
if(_instance == null)
{
_log.info("MercTicketManager: Initializing");
_instance = new MercTicketManager();
_instance.load();
}
return _instance;
}
private GArray<L2ItemInstance> _droppedTickets; // to keep track of items on the ground
private final int[] _maxMercPerType = {10, 15, 10, 10, 20, 20, 20, 20, 20};
private final int[] _maxMercPerCastle = {50, 75, 100, 150, 200, 200, 200, 200, 200};
private final static Integer[][][] _ticketInfo = {{
// Gludio
{3960, 3961, 3962, 3963, 3964, 3965, 3966, 3967, 3968, 3969}, // Mercenary
{6038, 6039, 6040, 6041, 6042, 6043, 6044, 6045, 6046, 6047}, // Greater Mercenary
{6115, 6116, 6117, 6118, 6119, 6120, 6121, 6122, 6123, 6124}, // Dawn Mercenary
{6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184}, // Greater Recruit
{6235, 6236, 6237, 6238, 6239, 6240, 6241, 6242, 6243, 6244}, // Recruit
{6295, 6296}, // Nephilim
{3970, 3971, 3972, /**/35092, 35093, 35094}}, // Teleporter
{
// Dion
{3973, 3974, 3975, 3976, 3977, 3978, 3979, 3980, 3981, 3982}, // Mercenary
{6051, 6052, 6053, 6054, 6055, 6056, 6057, 6058, 6059, 6060}, // Greater Mercenary
{6125, 6126, 6127, 6128, 6129, 6130, 6131, 6132, 6133, 6134}, // Dawn Mercenary
{6185, 6186, 6187, 6188, 6189, 6190, 6191, 6192, 6193, 6194}, // Greater Recruit
{6245, 6246, 6247, 6248, 6249, 6250, 6251, 6252, 6253, 6254}, // Recruit
{6297, 6298}, // Nephilim
{3983, 3984, 3985, /**/35134, 35135, 35136}}, // Teleporter
{
// Giran
{3986, 3987, 3988, 3989, 3990, 3991, 3992, 3993, 3994, 3995}, // Mercenary
{6064, 6065, 6066, 6067, 6068, 6069, 6070, 6071, 6072, 6073}, // Greater Mercenary
{6135, 6136, 6137, 6138, 6139, 6140, 6141, 6142, 6143, 6144}, // Dawn Mercenary
{6195, 6196, 6197, 6198, 6199, 6200, 6201, 6202, 6203, 6204}, // Greater Recruit
{6255, 6256, 6257, 6258, 6259, 6260, 6261, 6262, 6263, 6264}, // Recruit
{6299, 6300}, // Nephilim
{3996, 3997, 3998, /**/35176, 35177, 35178}}, // Teleporter
{
// Oren
{3999, 4000, 4001, 4002, 4003, 4004, 4005, 4006, 4007, 4008}, // Mercenary
{6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086}, // Greater Mercenary
{6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6153, 6154}, // Dawn Mercenary
{6205, 6206, 6207, 6208, 6209, 6210, 6211, 6212, 6213, 6214}, // Greater Recruit
{6265, 6266, 6267, 6268, 6269, 6270, 6271, 6272, 6273, 6274}, // Recruit
{6301, 6302}, // Nephilim
{4009, 4010, 4011, /**/35218, 35219, 35220}}, // Teleporter
{
// Aden
{4012, 4013, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4021}, // Mercenary
{6090, 6091, 6092, 6093, 6094, 6095, 6096, 6097, 6098, 6099}, // Greater Mercenary
{6155, 6156, 6157, 6158, 6159, 6160, 6161, 6162, 6163, 6164}, // Dawn Mercenary
{6215, 6216, 6217, 6218, 6219, 6220, 6221, 6222, 6223, 6224}, // Greater Recruit
{6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284}, // Recruit
{6303, 6304}, // Nephilim
{4022, 4023, 4024, 4025, 4026, /**/35261, 35262, 35263, 35264, 35265}}, // Teleporter
{
// Innadril
{5205, 5206, 5207, 5208, 5209, 5210, 5211, 5212, 5213, 5214}, // Mercenary
{6105, 6106, 6107, 6108, 6109, 6110, 6111, 6112, 6113, 6114}, // Greater Mercenary
{6165, 6166, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174}, // Dawn Mercenary
{6225, 6226, 6227, 6228, 6229, 6230, 6231, 6232, 6233, 6234}, // Greater Recruit
{6285, 6286, 6287, 6288, 6289, 6290, 6291, 6292, 6293, 6294}, // Recruit
{6305, 6306}, // Nephilim
{5215, 5218, 5219, /**/35308, 35309, 35310}}, // Teleporter
{
// Goddard
{6779, 6780, 6781, 6782, 6783, 6784, 6785, 6786, 6787, 6788}, // Mercenary
{6792, 6793, 6794, 6795, 6796, 6797, 6798, 6799, 6800, 6801}, // Greater Mercenary
{6802, 6803, 6804, 6805, 6806, 6807, 6808, 6809, 6810, 6811}, // Dawn Mercenary
{6812, 6813, 6814, 6815, 6816, 6817, 6818, 6819, 6820, 6821}, // Greater Recruit
{6822, 6823, 6824, 6825, 6826, 6827, 6828, 6829, 6830, 6831}, // Recruit
{6832, 6833}, // Nephilim
{6789, 6790, 6791, /**/35352, 35353, 35354}}, // Teleporter
{
// Rune
{7973, 7974, 7975, 7976, 7977, 7978, 7979, 7980, 7981, 7982}, // Mercenary
{7988, 7989, 7990, 7991, 7992, 7993, 7994, 7995, 7996, 7997}, // Greater Mercenary
{7998, 7999, 8000, 8001, 8002, 8003, 8004, 8005, 8006, 8007}, // Dawn Mercenary
{8008, 8009, 8010, 8011, 8012, 8013, 8014, 8015, 8016, 8017}, // Greater Recruit
{8018, 8019, 8020, 8021, 8022, 8023, 8024, 8025, 8026, 8027}, // Recruit
{8028, 8029}, // Nephilim
{7983, 7984, 7985, 7986, 7987, /**/35497, 35498, 35499, 35500, 35501}}, // Teleporter
{
// Schuttgart
{7918, 7919, 7920, 7921, 7922, 7923, 7924, 7925, 7926, 7927}, // Mercenary
{7931, 7932, 7933, 7934, 7935, 7936, 7937, 7938, 7939, 7940}, // Greater Mercenary
{7941, 7942, 7943, 7944, 7945, 7946, 7947, 7948, 7949, 7950}, // Dawn Mercenary
{7951, 7952, 7953, 7954, 7955, 7956, 7957, 7958, 7959, 7960}, // Greater Recruit
{7961, 7962, 7963, 7964, 7965, 7966, 7967, 7968, 7969, 7970}, // Recruit
{7971, 7972}, // Nephilim
{7928, 7929, 7930, /**/35544, 35545, 35546}} // Teleporter
};
private static final int[][] _NpcIds = {{35010, 35011, 35012, 35013, 35014, 35015, 35016, 35017, 35018, 35019}, // Mercenary
{35030, 35031, 35032, 35033, 35034, 35035, 35036, 35037, 35038, 35039}, // Elite Mercenary
{35020, 35021, 35022, 35023, 35024, 35025, 35026, 35027, 35028, 35029}, // Mercenary of Dawn
{35040, 35041, 35042, 35043, 35044, 35045, 35046, 35047, 35048, 35049}, // Greater Recruit
{35050, 35051, 35052, 35053, 35054, 35055, 35056, 35057, 35058, 35059}, // Recruit
{35060, 35060} // Nephilim
};
private static FastMap<Integer, Integer> _itemAndNpc = new FastMap<Integer, Integer>();
private static FastMap<Integer, Integer> _npcAndItem = new FastMap<Integer, Integer>();
static
{
for(Integer[][] itemsInfo : _ticketInfo)
{
for(int type = 0; type < itemsInfo.length; type++)
{
if(type < 6)
{
for(int i = 0; i < itemsInfo[type].length; i++)
{
_itemAndNpc.put(itemsInfo[type][i], _NpcIds[type][i]);
_npcAndItem.put(_NpcIds[type][i], itemsInfo[type][i]);
}
}
else
{
int k = itemsInfo[type].length / 2;
for(int i = 0; i < k; i++)
{
_itemAndNpc.put(itemsInfo[type][i], itemsInfo[type][i + k - 1]);
_npcAndItem.put(itemsInfo[type][i + k - 1], itemsInfo[type][i]);
}
}
}
}
}
private void load()
{
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
ResultSet rset = null;
// load merc tickets into the world
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("SELECT * FROM siege_guards Where isHired = 1");
rset = statement.executeQuery();
int npcId;
int itemId;
Location loc;
while(rset.next())
{
npcId = rset.getInt("npcId");
loc = new Location(rset.getInt("x"), rset.getInt("y"), rset.getInt("z"));
itemId = getItemId(npcId);
if(itemId > 0)
{
L2ItemInstance dropticket = ItemTable.getInstance().createItem(itemId);
dropticket.setLocation(L2ItemInstance.ItemLocation.INVENTORY);
dropticket.dropMe(null, loc);
dropticket.setDropTime(0); // avoids it from beeing removed by the auto item destroyer
getDroppedTickets().add(dropticket);
}
}
_log.info("MercTicketManager: Loaded " + getDroppedTickets().size() + " Mercenary Tickets");
}
catch(Exception e)
{
System.out.println("Exception: loadMercenaryData(): " + e.getMessage());
e.printStackTrace();
}
finally
{
DatabaseUtils.closeDatabaseCSR(con, statement, rset);
}
}
/**
* Checks if the passed item has reached the limit of number of dropped tickets that this SPECIFIC item may have in its castle
*/
public boolean isAtTypeLimit(int itemId)
{
int castleId = getTicketCastleId(itemId);
if(castleId <= 0)
{
return true;
}
int limit = _maxMercPerType[castleId - 1];
if(limit <= 0)
{
return true;
}
for(int type = 0; type < _ticketInfo[castleId - 1].length; type++)
{
for(int item : _ticketInfo[castleId - 1][type])
{
if(item == itemId && type == 6) // Телепортеров можно поставить не более двух
{
limit = 2;
}
}
}
int count = 0;
for(L2ItemInstance ticket : getDroppedTickets())
{
if(ticket != null && ticket.getItemId() == itemId)
{
count++;
}
}
if(count >= limit)
{
return true;
}
return false;
}
/**
* Checks if the passed item belongs to a castle which has reached its limit of number of dropped tickets.
*/
public boolean isAtCasleLimit(int itemId)
{
int castleId = getTicketCastleId(itemId);
if(castleId <= 0)
{
return true;
}
int limit = _maxMercPerCastle[castleId - 1];
if(limit <= 0)
{
return true;
}
int count = 0;
for(L2ItemInstance ticket : getDroppedTickets())
{
if(ticket != null && getTicketCastleId(ticket.getItemId()) == castleId)
{
count++;
}
}
if(count >= limit)
{
return true;
}
return false;
}
public void addTicket(int itemId, L2Player activeChar)
{
Location loc = new Location(activeChar.getX(), activeChar.getY(), activeChar.getZ(), activeChar.getHeading());
Residence castle = CastleManager.getInstance().getCastleByObject(activeChar);
if(castle == null)
{
return;
}
int npcId = getNpcId(itemId);
if(npcId <= 0)
{
return;
}
L2ItemInstance dropticket = ItemTable.getInstance().createItem(itemId);
dropticket.setLocation(L2ItemInstance.ItemLocation.INVENTORY);
dropticket.dropMe(null, loc);
castle.getSiege().getSiegeGuardManager().hireMerc(loc, npcId);
dropticket.setDropTime(0); // avoids it from beeing removed by the auto item destroyer
getDroppedTickets().add(dropticket);
}
/**
* Delete all tickets from a castle;
* remove the items from the world and remove references to them from this class
*/
public void deleteTickets(int castleId)
{
int i = 0;
while(i < getDroppedTickets().size())
{
L2ItemInstance item = getDroppedTickets().get(i);
if(item != null && getTicketCastleId(item.getItemId()) == castleId)
{
item.deleteMe();
getDroppedTickets().remove(i);
}
else
{
i++;
}
}
}
public void removeTicket(L2ItemInstance item)
{
Residence castle = CastleManager.getInstance().getCastleByObject(item);
int itemId = item.getItemId();
int npcId = getNpcId(itemId);
if(npcId > 0 && castle != null)
{
castle.getSiege().getSiegeGuardManager().removeMerc(npcId, item.getLoc());
}
getDroppedTickets().remove(item);
}
public int[] getItemIds()
{
int[] result = new int[_itemAndNpc.size()];
int i = 0;
for(int itemId : _itemAndNpc.keySet())
{
result[i] = itemId;
i++;
}
return result;
}
public final GArray<L2ItemInstance> getDroppedTickets()
{
if(_droppedTickets == null)
{
_droppedTickets = new GArray<L2ItemInstance>();
}
return _droppedTickets;
}
public int getNpcId(int itemId)
{
Integer npcId = _itemAndNpc.get(itemId);
if(npcId == null)
{
return -1;
}
return npcId.intValue();
}
private int getItemId(int npcId)
{
Integer itemId = _npcAndItem.get(npcId);
if(itemId == null)
{
return -1;
}
return itemId.intValue();
}
/**
* returns the castleId for the passed ticket item id
*/
public int getTicketCastleId(int itemId)
{
for(int id = 0; id < _ticketInfo.length; id++)
{
for(Integer[] itemsInfo : _ticketInfo[id])
{
for(int item : itemsInfo)
{
if(item == itemId)
{
return id + 1;
}
}
}
}
return -1;
}
}