ItemTable.java 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482
  1. /*
  2. * This program is free software: you can redistribute it and/or modify it under
  3. * the terms of the GNU General Public License as published by the Free Software
  4. * Foundation, either version 3 of the License, or (at your option) any later
  5. * version.
  6. *
  7. * This program is distributed in the hope that it will be useful, but WITHOUT
  8. * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  9. * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
  10. * details.
  11. *
  12. * You should have received a copy of the GNU General Public License along with
  13. * this program. If not, see <http://www.gnu.org/licenses/>.
  14. */
  15. package com.l2jserver.gameserver.datatables;
  16. import static com.l2jserver.gameserver.model.itemcontainer.PcInventory.ADENA_ID;
  17. import java.sql.Connection;
  18. import java.sql.PreparedStatement;
  19. import java.util.Map;
  20. import java.util.Set;
  21. import java.util.concurrent.ScheduledFuture;
  22. import java.util.logging.Level;
  23. import java.util.logging.LogRecord;
  24. import java.util.logging.Logger;
  25. import javolution.util.FastMap;
  26. import com.l2jserver.Config;
  27. import com.l2jserver.L2DatabaseFactory;
  28. import com.l2jserver.gameserver.Item;
  29. import com.l2jserver.gameserver.ThreadPoolManager;
  30. import com.l2jserver.gameserver.idfactory.IdFactory;
  31. import com.l2jserver.gameserver.model.L2ItemInstance;
  32. import com.l2jserver.gameserver.model.L2ItemInstance.ItemLocation;
  33. import com.l2jserver.gameserver.model.L2Object;
  34. import com.l2jserver.gameserver.model.L2World;
  35. import com.l2jserver.gameserver.model.actor.L2Attackable;
  36. import com.l2jserver.gameserver.model.actor.instance.L2EventMonsterInstance;
  37. import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
  38. import com.l2jserver.gameserver.skills.SkillsEngine;
  39. import com.l2jserver.gameserver.templates.item.L2Armor;
  40. import com.l2jserver.gameserver.templates.item.L2ArmorType;
  41. import com.l2jserver.gameserver.templates.item.L2EtcItem;
  42. import com.l2jserver.gameserver.templates.item.L2Item;
  43. import com.l2jserver.gameserver.templates.item.L2Weapon;
  44. import com.l2jserver.gameserver.templates.item.L2WeaponType;
  45. import com.l2jserver.gameserver.util.GMAudit;
  46. /**
  47. * This class ...
  48. *
  49. * @version $Revision: 1.9.2.6.2.9 $ $Date: 2005/04/02 15:57:34 $
  50. */
  51. public class ItemTable
  52. {
  53. private static Logger _log = Logger.getLogger(ItemTable.class.getName());
  54. private static Logger _logItems = Logger.getLogger("item");
  55. public static final Map<String, Integer> _materials = new FastMap<String, Integer>();
  56. public static final Map<String, Integer> _crystalTypes = new FastMap<String, Integer>();
  57. public static final Map<String, Integer> _slots = new FastMap<String, Integer>();
  58. public static final Map<String, L2WeaponType> _weaponTypes = new FastMap<String, L2WeaponType>();
  59. public static final Map<String, L2ArmorType> _armorTypes = new FastMap<String, L2ArmorType>();
  60. private L2Item[] _allTemplates;
  61. private Map<Integer, L2EtcItem> _etcItems;
  62. private Map<Integer, L2Armor> _armors;
  63. private Map<Integer, L2Weapon> _weapons;
  64. static
  65. {
  66. _materials.put("adamantaite", L2Item.MATERIAL_ADAMANTAITE);
  67. _materials.put("blood_steel", L2Item.MATERIAL_BLOOD_STEEL);
  68. _materials.put("bone", L2Item.MATERIAL_BONE);
  69. _materials.put("bronze", L2Item.MATERIAL_BRONZE);
  70. _materials.put("cloth", L2Item.MATERIAL_CLOTH);
  71. _materials.put("chrysolite", L2Item.MATERIAL_CHRYSOLITE);
  72. _materials.put("cobweb", L2Item.MATERIAL_COBWEB);
  73. _materials.put("cotton", L2Item.MATERIAL_FINE_STEEL);
  74. _materials.put("crystal", L2Item.MATERIAL_CRYSTAL);
  75. _materials.put("damascus", L2Item.MATERIAL_DAMASCUS);
  76. _materials.put("dyestuff", L2Item.MATERIAL_DYESTUFF);
  77. _materials.put("fine_steel", L2Item.MATERIAL_FINE_STEEL);
  78. _materials.put("fish", L2Item.MATERIAL_FISH);
  79. _materials.put("gold", L2Item.MATERIAL_GOLD);
  80. _materials.put("horn", L2Item.MATERIAL_HORN);
  81. _materials.put("leather", L2Item.MATERIAL_LEATHER);
  82. _materials.put("liquid", L2Item.MATERIAL_LIQUID);
  83. _materials.put("mithril", L2Item.MATERIAL_MITHRIL);
  84. _materials.put("oriharukon", L2Item.MATERIAL_ORIHARUKON);
  85. _materials.put("paper", L2Item.MATERIAL_PAPER);
  86. _materials.put("rune_xp", L2Item.MATERIAL_RUNE_XP);
  87. _materials.put("rune_sp", L2Item.MATERIAL_RUNE_SP);
  88. _materials.put("rune_remove_penalty", L2Item.MATERIAL_RUNE_PENALTY);
  89. _materials.put("scale_of_dragon", L2Item.MATERIAL_SCALE_OF_DRAGON);
  90. _materials.put("seed", L2Item.MATERIAL_SEED);
  91. _materials.put("silver", L2Item.MATERIAL_SILVER);
  92. _materials.put("steel", L2Item.MATERIAL_STEEL);
  93. _materials.put("wood", L2Item.MATERIAL_WOOD);
  94. _crystalTypes.put("s84", L2Item.CRYSTAL_S84);
  95. _crystalTypes.put("s80", L2Item.CRYSTAL_S80);
  96. _crystalTypes.put("s", L2Item.CRYSTAL_S);
  97. _crystalTypes.put("a", L2Item.CRYSTAL_A);
  98. _crystalTypes.put("b", L2Item.CRYSTAL_B);
  99. _crystalTypes.put("c", L2Item.CRYSTAL_C);
  100. _crystalTypes.put("d", L2Item.CRYSTAL_D);
  101. _crystalTypes.put("none", L2Item.CRYSTAL_NONE);
  102. // weapon types
  103. for (L2WeaponType type : L2WeaponType.values())
  104. {
  105. _weaponTypes.put(type.toString(), type);
  106. }
  107. // armor types
  108. for (L2ArmorType type : L2ArmorType.values())
  109. {
  110. _armorTypes.put(type.toString(), type);
  111. }
  112. _slots.put("shirt", L2Item.SLOT_UNDERWEAR);
  113. _slots.put("lbracelet", L2Item.SLOT_L_BRACELET);
  114. _slots.put("rbracelet", L2Item.SLOT_R_BRACELET);
  115. _slots.put("talisman", L2Item.SLOT_DECO);
  116. _slots.put("chest", L2Item.SLOT_CHEST);
  117. _slots.put("fullarmor", L2Item.SLOT_FULL_ARMOR);
  118. _slots.put("head", L2Item.SLOT_HEAD);
  119. _slots.put("hair", L2Item.SLOT_HAIR);
  120. _slots.put("hairall", L2Item.SLOT_HAIRALL);
  121. _slots.put("underwear", L2Item.SLOT_UNDERWEAR);
  122. _slots.put("back", L2Item.SLOT_BACK);
  123. _slots.put("neck", L2Item.SLOT_NECK);
  124. _slots.put("legs", L2Item.SLOT_LEGS);
  125. _slots.put("feet", L2Item.SLOT_FEET);
  126. _slots.put("gloves", L2Item.SLOT_GLOVES);
  127. _slots.put("chest,legs", L2Item.SLOT_CHEST | L2Item.SLOT_LEGS);
  128. _slots.put("belt", L2Item.SLOT_BELT);
  129. _slots.put("rhand", L2Item.SLOT_R_HAND);
  130. _slots.put("lhand", L2Item.SLOT_L_HAND);
  131. _slots.put("lrhand", L2Item.SLOT_LR_HAND);
  132. _slots.put("rear;lear", L2Item.SLOT_R_EAR | L2Item.SLOT_L_EAR);
  133. _slots.put("rfinger;lfinger", L2Item.SLOT_R_FINGER | L2Item.SLOT_L_FINGER);
  134. _slots.put("wolf", L2Item.SLOT_WOLF);
  135. _slots.put("greatwolf", L2Item.SLOT_GREATWOLF);
  136. _slots.put("hatchling", L2Item.SLOT_HATCHLING);
  137. _slots.put("strider", L2Item.SLOT_STRIDER);
  138. _slots.put("babypet", L2Item.SLOT_BABYPET);
  139. _slots.put("none", L2Item.SLOT_NONE);
  140. //retail compatibility
  141. _slots.put("onepiece", L2Item.SLOT_FULL_ARMOR);
  142. _slots.put("hair2", L2Item.SLOT_HAIR2);
  143. _slots.put("dhair", L2Item.SLOT_HAIRALL);
  144. _slots.put("alldress", L2Item.SLOT_ALLDRESS);
  145. _slots.put("deco1", L2Item.SLOT_DECO);
  146. _slots.put("waist", L2Item.SLOT_BELT);
  147. }
  148. /**
  149. * Returns instance of ItemTable
  150. * @return ItemTable
  151. */
  152. public static ItemTable getInstance()
  153. {
  154. return SingletonHolder._instance;
  155. }
  156. /**
  157. * @return a new object Item
  158. */
  159. public Item newItem()
  160. {
  161. return new Item();
  162. }
  163. /**
  164. * Constructor.
  165. */
  166. private ItemTable()
  167. {
  168. _etcItems = new FastMap<Integer, L2EtcItem>();
  169. _armors = new FastMap<Integer, L2Armor>();
  170. _weapons = new FastMap<Integer, L2Weapon>();
  171. load();
  172. }
  173. private void load()
  174. {
  175. int highest = 0;
  176. _armors.clear();
  177. _etcItems.clear();
  178. _weapons.clear();
  179. for (L2Item item : SkillsEngine.getInstance().loadItems())
  180. {
  181. if (highest < item.getItemId())
  182. highest = item.getItemId();
  183. if (item instanceof L2EtcItem)
  184. _etcItems.put(item.getItemId(), (L2EtcItem) item);
  185. else if (item instanceof L2Armor)
  186. _armors.put(item.getItemId(), (L2Armor) item);
  187. else
  188. _weapons.put(item.getItemId(), (L2Weapon) item);
  189. }
  190. buildFastLookupTable(highest);
  191. }
  192. /**
  193. * Builds a variable in which all items are putting in in function of their ID.
  194. * @param size
  195. */
  196. private void buildFastLookupTable(int size)
  197. {
  198. // Create a FastLookUp Table called _allTemplates of size : value of the highest item ID
  199. _log.info("Highest item id used:" + size);
  200. _allTemplates = new L2Item[size + 1];
  201. // Insert armor item in Fast Look Up Table
  202. for (L2Armor item : _armors.values())
  203. {
  204. _allTemplates[item.getItemId()] = item;
  205. }
  206. // Insert weapon item in Fast Look Up Table
  207. for (L2Weapon item : _weapons.values())
  208. {
  209. _allTemplates[item.getItemId()] = item;
  210. }
  211. // Insert etcItem item in Fast Look Up Table
  212. for (L2EtcItem item : _etcItems.values())
  213. {
  214. _allTemplates[item.getItemId()] = item;
  215. }
  216. }
  217. /**
  218. * Returns the item corresponding to the item ID
  219. * @param id : int designating the item
  220. * @return L2Item
  221. */
  222. public L2Item getTemplate(int id)
  223. {
  224. if (id >= _allTemplates.length)
  225. return null;
  226. return _allTemplates[id];
  227. }
  228. /**
  229. * Create the L2ItemInstance corresponding to the Item Identifier and quantitiy add logs the activity.<BR><BR>
  230. *
  231. * <B><U> Actions</U> :</B><BR><BR>
  232. * <li>Create and Init the L2ItemInstance corresponding to the Item Identifier and quantity </li>
  233. * <li>Add the L2ItemInstance object to _allObjects of L2world </li>
  234. * <li>Logs Item creation according to log settings</li><BR><BR>
  235. *
  236. * @param process : String Identifier of process triggering this action
  237. * @param itemId : int Item Identifier of the item to be created
  238. * @param count : int Quantity of items to be created for stackable items
  239. * @param actor : L2PcInstance Player requesting the item creation
  240. * @param reference : Object Object referencing current action like NPC selling item or previous item in transformation
  241. * @return L2ItemInstance corresponding to the new item
  242. */
  243. public L2ItemInstance createItem(String process, int itemId, long count, L2PcInstance actor, Object reference)
  244. {
  245. // Create and Init the L2ItemInstance corresponding to the Item Identifier
  246. L2ItemInstance item = new L2ItemInstance(IdFactory.getInstance().getNextId(), itemId);
  247. if (process.equalsIgnoreCase("loot"))
  248. {
  249. ScheduledFuture<?> itemLootShedule;
  250. if (reference instanceof L2Attackable && ((L2Attackable) reference).isRaid()) // loot privilege for raids
  251. {
  252. L2Attackable raid = (L2Attackable) reference;
  253. // if in CommandChannel and was killing a World/RaidBoss
  254. if (raid.getFirstCommandChannelAttacked() != null && !Config.AUTO_LOOT_RAIDS)
  255. {
  256. item.setOwnerId(raid.getFirstCommandChannelAttacked().getChannelLeader().getObjectId());
  257. itemLootShedule = ThreadPoolManager.getInstance().scheduleGeneral(new ResetOwner(item), Config.LOOT_RAIDS_PRIVILEGE_INTERVAL);
  258. item.setItemLootShedule(itemLootShedule);
  259. }
  260. }
  261. else if (!Config.AUTO_LOOT || (reference instanceof L2EventMonsterInstance && ((L2EventMonsterInstance)reference).eventDropOnGround()))
  262. {
  263. item.setOwnerId(actor.getObjectId());
  264. itemLootShedule = ThreadPoolManager.getInstance().scheduleGeneral(new ResetOwner(item), 15000);
  265. item.setItemLootShedule(itemLootShedule);
  266. }
  267. }
  268. if (Config.DEBUG)
  269. _log.fine("ItemTable: Item created oid:" + item.getObjectId() + " itemid:" + itemId);
  270. // Add the L2ItemInstance object to _allObjects of L2world
  271. L2World.getInstance().storeObject(item);
  272. // Set Item parameters
  273. if (item.isStackable() && count > 1)
  274. item.setCount(count);
  275. if (Config.LOG_ITEMS && !process.equals("Reset"))
  276. {
  277. if (!Config.LOG_ITEMS_SMALL_LOG || (Config.LOG_ITEMS_SMALL_LOG && (item.isEquipable() || item.getItemId() == ADENA_ID)))
  278. {
  279. LogRecord record = new LogRecord(Level.INFO, "CREATE:" + process);
  280. record.setLoggerName("item");
  281. record.setParameters(new Object[] { item, actor, reference });
  282. _logItems.log(record);
  283. }
  284. }
  285. if (actor != null)
  286. {
  287. if (actor.isGM())
  288. {
  289. String referenceName = "no-reference";
  290. if (reference instanceof L2Object)
  291. {
  292. referenceName = (((L2Object)reference).getName() != null?((L2Object)reference).getName():"no-name");
  293. }
  294. else if (reference instanceof String)
  295. referenceName = (String)reference;
  296. String targetName = (actor.getTarget() != null ? actor.getTarget().getName() : "no-target");
  297. if (Config.GMAUDIT)
  298. GMAudit.auditGMAction(actor.getName()+" ["+actor.getObjectId()+"]", process + "(id: " + itemId + " count: " + count + " name: " + item.getItemName()
  299. + " objId: " + item.getObjectId() + ")", targetName, "L2Object referencing this action is: " + referenceName);
  300. }
  301. }
  302. return item;
  303. }
  304. public L2ItemInstance createItem(String process, int itemId, int count, L2PcInstance actor)
  305. {
  306. return createItem(process, itemId, count, actor, null);
  307. }
  308. /**
  309. * Returns a dummy (fr = factice) item.<BR><BR>
  310. * <U><I>Concept :</I></U><BR>
  311. * Dummy item is created by setting the ID of the object in the world at null value
  312. * @param itemId : int designating the item
  313. * @return L2ItemInstance designating the dummy item created
  314. */
  315. public L2ItemInstance createDummyItem(int itemId)
  316. {
  317. L2Item item = getTemplate(itemId);
  318. if (item == null)
  319. return null;
  320. L2ItemInstance temp = new L2ItemInstance(0, item);
  321. return temp;
  322. }
  323. /**
  324. * Destroys the L2ItemInstance.<BR><BR>
  325. *
  326. * <B><U> Actions</U> :</B><BR><BR>
  327. * <li>Sets L2ItemInstance parameters to be unusable </li>
  328. * <li>Removes the L2ItemInstance object to _allObjects of L2world </li>
  329. * <li>Logs Item deletion according to log settings</li><BR><BR>
  330. * @param process a string identifier of process triggering this action.
  331. * @param item the item instance to be destroyed.
  332. * @param actor the player requesting the item destroy.
  333. * @param reference the object referencing current action like NPC selling item or previous item in transformation.
  334. */
  335. public void destroyItem(String process, L2ItemInstance item, L2PcInstance actor, Object reference)
  336. {
  337. synchronized (item)
  338. {
  339. long old = item.getCount();
  340. item.setCount(0);
  341. item.setOwnerId(0);
  342. item.setLocation(ItemLocation.VOID);
  343. item.setLastChange(L2ItemInstance.REMOVED);
  344. L2World.getInstance().removeObject(item);
  345. IdFactory.getInstance().releaseId(item.getObjectId());
  346. if (Config.LOG_ITEMS)
  347. {
  348. if (!Config.LOG_ITEMS_SMALL_LOG || (Config.LOG_ITEMS_SMALL_LOG && (item.isEquipable() || item.getItemId() == ADENA_ID)))
  349. {
  350. LogRecord record = new LogRecord(Level.INFO, "DELETE:" + process);
  351. record.setLoggerName("item");
  352. record.setParameters(new Object[] { item, "PrevCount("+old+")", actor, reference });
  353. _logItems.log(record);
  354. }
  355. }
  356. if (actor != null)
  357. {
  358. if (actor.isGM())
  359. {
  360. String referenceName = "no-reference";
  361. if (reference instanceof L2Object)
  362. {
  363. referenceName = (((L2Object)reference).getName() != null?((L2Object)reference).getName():"no-name");
  364. }
  365. else if (reference instanceof String)
  366. referenceName = (String)reference;
  367. String targetName = (actor.getTarget() != null ? actor.getTarget().getName() : "no-target");
  368. if (Config.GMAUDIT)
  369. GMAudit.auditGMAction(actor.getName()+" ["+actor.getObjectId()+"]", process + "(id: " + item.getItemId() + " count: " + item.getCount()
  370. + " itemObjId: " + item.getObjectId() + ")", targetName, "L2Object referencing this action is: "
  371. + referenceName);
  372. }
  373. }
  374. // if it's a pet control item, delete the pet as well
  375. if (PetDataTable.isPetItem(item.getItemId()))
  376. {
  377. Connection con = null;
  378. try
  379. {
  380. // Delete the pet in db
  381. con = L2DatabaseFactory.getInstance().getConnection();
  382. PreparedStatement statement = con.prepareStatement("DELETE FROM pets WHERE item_obj_id=?");
  383. statement.setInt(1, item.getObjectId());
  384. statement.execute();
  385. statement.close();
  386. }
  387. catch (Exception e)
  388. {
  389. _log.log(Level.WARNING, "could not delete pet objectid:", e);
  390. }
  391. finally
  392. {
  393. L2DatabaseFactory.close(con);
  394. }
  395. }
  396. }
  397. }
  398. public void reload()
  399. {
  400. load();
  401. EnchantHPBonusData.getInstance().reload();
  402. }
  403. protected static class ResetOwner implements Runnable
  404. {
  405. L2ItemInstance _item;
  406. public ResetOwner(L2ItemInstance item)
  407. {
  408. _item = item;
  409. }
  410. @Override
  411. public void run()
  412. {
  413. _item.setOwnerId(0);
  414. _item.setItemLootShedule(null);
  415. }
  416. }
  417. public Set<Integer> getAllArmorsId()
  418. {
  419. return _armors.keySet();
  420. }
  421. public Set<Integer> getAllWeaponsId()
  422. {
  423. return _weapons.keySet();
  424. }
  425. public int getArraySize()
  426. {
  427. return _allTemplates.length;
  428. }
  429. @SuppressWarnings("synthetic-access")
  430. private static class SingletonHolder
  431. {
  432. protected static final ItemTable _instance = new ItemTable();
  433. }
  434. }