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. * Returns a new object Item
  158. * @return
  159. */
  160. public Item newItem()
  161. {
  162. return new Item();
  163. }
  164. /**
  165. * Constructor.
  166. */
  167. private ItemTable()
  168. {
  169. _etcItems = new FastMap<Integer, L2EtcItem>();
  170. _armors = new FastMap<Integer, L2Armor>();
  171. _weapons = new FastMap<Integer, L2Weapon>();
  172. load();
  173. }
  174. private void load()
  175. {
  176. int highest = 0;
  177. _armors.clear();
  178. _etcItems.clear();
  179. _weapons.clear();
  180. for (L2Item item : SkillsEngine.getInstance().loadItems())
  181. {
  182. if (highest < item.getItemId())
  183. highest = item.getItemId();
  184. if (item instanceof L2EtcItem)
  185. _etcItems.put(item.getItemId(), (L2EtcItem) item);
  186. else if (item instanceof L2Armor)
  187. _armors.put(item.getItemId(), (L2Armor) item);
  188. else
  189. _weapons.put(item.getItemId(), (L2Weapon) item);
  190. }
  191. buildFastLookupTable(highest);
  192. }
  193. /**
  194. * Builds a variable in which all items are putting in in function of their ID.
  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. else
  227. return _allTemplates[id];
  228. }
  229. /**
  230. * Create the L2ItemInstance corresponding to the Item Identifier and quantitiy add logs the activity.<BR><BR>
  231. *
  232. * <B><U> Actions</U> :</B><BR><BR>
  233. * <li>Create and Init the L2ItemInstance corresponding to the Item Identifier and quantity </li>
  234. * <li>Add the L2ItemInstance object to _allObjects of L2world </li>
  235. * <li>Logs Item creation according to log settings</li><BR><BR>
  236. *
  237. * @param process : String Identifier of process triggering this action
  238. * @param itemId : int Item Identifier of the item to be created
  239. * @param count : int Quantity of items to be created for stackable items
  240. * @param actor : L2PcInstance Player requesting the item creation
  241. * @param reference : Object Object referencing current action like NPC selling item or previous item in transformation
  242. * @return L2ItemInstance corresponding to the new item
  243. */
  244. public L2ItemInstance createItem(String process, int itemId, long count, L2PcInstance actor, Object reference)
  245. {
  246. // Create and Init the L2ItemInstance corresponding to the Item Identifier
  247. L2ItemInstance item = new L2ItemInstance(IdFactory.getInstance().getNextId(), itemId);
  248. if (process.equalsIgnoreCase("loot"))
  249. {
  250. ScheduledFuture<?> itemLootShedule;
  251. if (reference instanceof L2Attackable && ((L2Attackable) reference).isRaid()) // loot privilege for raids
  252. {
  253. L2Attackable raid = (L2Attackable) reference;
  254. // if in CommandChannel and was killing a World/RaidBoss
  255. if (raid.getFirstCommandChannelAttacked() != null && !Config.AUTO_LOOT_RAIDS)
  256. {
  257. item.setOwnerId(raid.getFirstCommandChannelAttacked().getChannelLeader().getObjectId());
  258. itemLootShedule = ThreadPoolManager.getInstance().scheduleGeneral(new ResetOwner(item), Config.LOOT_RAIDS_PRIVILEGE_INTERVAL);
  259. item.setItemLootShedule(itemLootShedule);
  260. }
  261. }
  262. else if (!Config.AUTO_LOOT || (reference instanceof L2EventMonsterInstance && ((L2EventMonsterInstance)reference).eventDropOnGround()))
  263. {
  264. item.setOwnerId(actor.getObjectId());
  265. itemLootShedule = ThreadPoolManager.getInstance().scheduleGeneral(new ResetOwner(item), 15000);
  266. item.setItemLootShedule(itemLootShedule);
  267. }
  268. }
  269. if (Config.DEBUG)
  270. _log.fine("ItemTable: Item created oid:" + item.getObjectId() + " itemid:" + itemId);
  271. // Add the L2ItemInstance object to _allObjects of L2world
  272. L2World.getInstance().storeObject(item);
  273. // Set Item parameters
  274. if (item.isStackable() && count > 1)
  275. item.setCount(count);
  276. if (Config.LOG_ITEMS && !process.equals("Reset"))
  277. {
  278. if (!Config.LOG_ITEMS_SMALL_LOG || (Config.LOG_ITEMS_SMALL_LOG && (item.isEquipable() || item.getItemId() == ADENA_ID)))
  279. {
  280. LogRecord record = new LogRecord(Level.INFO, "CREATE:" + process);
  281. record.setLoggerName("item");
  282. record.setParameters(new Object[] { item, actor, reference });
  283. _logItems.log(record);
  284. }
  285. }
  286. if (actor != null)
  287. {
  288. if (actor.isGM())
  289. {
  290. String referenceName = "no-reference";
  291. if (reference instanceof L2Object)
  292. {
  293. referenceName = (((L2Object)reference).getName() != null?((L2Object)reference).getName():"no-name");
  294. }
  295. else if (reference instanceof String)
  296. referenceName = (String)reference;
  297. String targetName = (actor.getTarget() != null ? actor.getTarget().getName() : "no-target");
  298. if (Config.GMAUDIT)
  299. GMAudit.auditGMAction(actor.getName()+" ["+actor.getObjectId()+"]", process + "(id: " + itemId + " count: " + count + " name: " + item.getItemName()
  300. + " objId: " + item.getObjectId() + ")", targetName, "L2Object referencing this action is: " + referenceName);
  301. }
  302. }
  303. return item;
  304. }
  305. public L2ItemInstance createItem(String process, int itemId, int count, L2PcInstance actor)
  306. {
  307. return createItem(process, itemId, count, actor, null);
  308. }
  309. /**
  310. * Returns a dummy (fr = factice) item.<BR><BR>
  311. * <U><I>Concept :</I></U><BR>
  312. * Dummy item is created by setting the ID of the object in the world at null value
  313. * @param itemId : int designating the item
  314. * @return L2ItemInstance designating the dummy item created
  315. */
  316. public L2ItemInstance createDummyItem(int itemId)
  317. {
  318. L2Item item = getTemplate(itemId);
  319. if (item == null)
  320. return null;
  321. L2ItemInstance temp = new L2ItemInstance(0, item);
  322. return temp;
  323. }
  324. /**
  325. * Destroys the L2ItemInstance.<BR><BR>
  326. *
  327. * <B><U> Actions</U> :</B><BR><BR>
  328. * <li>Sets L2ItemInstance parameters to be unusable </li>
  329. * <li>Removes the L2ItemInstance object to _allObjects of L2world </li>
  330. * <li>Logs Item delettion according to log settings</li><BR><BR>
  331. *
  332. * @param process : String Identifier of process triggering this action
  333. * @param itemId : int Item Identifier of the item to be created
  334. * @param actor : L2PcInstance Player requesting the item destroy
  335. * @param reference : Object Object referencing current action like NPC selling item or previous item in transformation
  336. */
  337. public void destroyItem(String process, L2ItemInstance item, L2PcInstance actor, Object reference)
  338. {
  339. synchronized (item)
  340. {
  341. long old = item.getCount();
  342. item.setCount(0);
  343. item.setOwnerId(0);
  344. item.setLocation(ItemLocation.VOID);
  345. item.setLastChange(L2ItemInstance.REMOVED);
  346. L2World.getInstance().removeObject(item);
  347. IdFactory.getInstance().releaseId(item.getObjectId());
  348. if (Config.LOG_ITEMS)
  349. {
  350. if (!Config.LOG_ITEMS_SMALL_LOG || (Config.LOG_ITEMS_SMALL_LOG && (item.isEquipable() || item.getItemId() == ADENA_ID)))
  351. {
  352. LogRecord record = new LogRecord(Level.INFO, "DELETE:" + process);
  353. record.setLoggerName("item");
  354. record.setParameters(new Object[] { item, "PrevCount("+old+")", actor, reference });
  355. _logItems.log(record);
  356. }
  357. }
  358. if (actor != null)
  359. {
  360. if (actor.isGM())
  361. {
  362. String referenceName = "no-reference";
  363. if (reference instanceof L2Object)
  364. {
  365. referenceName = (((L2Object)reference).getName() != null?((L2Object)reference).getName():"no-name");
  366. }
  367. else if (reference instanceof String)
  368. referenceName = (String)reference;
  369. String targetName = (actor.getTarget() != null ? actor.getTarget().getName() : "no-target");
  370. if (Config.GMAUDIT)
  371. GMAudit.auditGMAction(actor.getName()+" ["+actor.getObjectId()+"]", process + "(id: " + item.getItemId() + " count: " + item.getCount()
  372. + " itemObjId: " + item.getObjectId() + ")", targetName, "L2Object referencing this action is: "
  373. + referenceName);
  374. }
  375. }
  376. // if it's a pet control item, delete the pet as well
  377. if (PetDataTable.isPetItem(item.getItemId()))
  378. {
  379. Connection con = null;
  380. try
  381. {
  382. // Delete the pet in db
  383. con = L2DatabaseFactory.getInstance().getConnection();
  384. PreparedStatement statement = con.prepareStatement("DELETE FROM pets WHERE item_obj_id=?");
  385. statement.setInt(1, item.getObjectId());
  386. statement.execute();
  387. statement.close();
  388. }
  389. catch (Exception e)
  390. {
  391. _log.log(Level.WARNING, "could not delete pet objectid:", e);
  392. }
  393. finally
  394. {
  395. L2DatabaseFactory.close(con);
  396. }
  397. }
  398. }
  399. }
  400. public void reload()
  401. {
  402. load();
  403. EnchantHPBonusData.getInstance().reload();
  404. }
  405. protected static class ResetOwner implements Runnable
  406. {
  407. L2ItemInstance _item;
  408. public ResetOwner(L2ItemInstance item)
  409. {
  410. _item = item;
  411. }
  412. public void run()
  413. {
  414. _item.setOwnerId(0);
  415. _item.setItemLootShedule(null);
  416. }
  417. }
  418. public Set<Integer> getAllArmorsId()
  419. {
  420. return _armors.keySet();
  421. }
  422. public Set<Integer> getAllWeaponsId()
  423. {
  424. return _weapons.keySet();
  425. }
  426. public int getArraySize()
  427. {
  428. return _allTemplates.length;
  429. }
  430. @SuppressWarnings("synthetic-access")
  431. private static class SingletonHolder
  432. {
  433. protected static final ItemTable _instance = new ItemTable();
  434. }
  435. }