public static void removeById(
     final MapleClient c,
     final MapleInventoryType type,
     final int Id,
     final int quantity,
     final boolean fromDrop,
     final boolean consume) {
   List<IItem> items = c.getPlayer().getInventory(type).listById(Id);
   int remremove = quantity;
   for (IItem item : items) {
     if (remremove <= item.getQuantity()) {
       removeFromSlot(c, type, item.getPosition(), (short) remremove, fromDrop, consume);
       remremove = 0;
       break;
     } else {
       remremove -= item.getQuantity();
       removeFromSlot(c, type, item.getPosition(), item.getQuantity(), fromDrop, consume);
     }
   }
   if (remremove > 0) {
     throw new RuntimeException(
         "[h4x] Not enough items available ("
             + Id
             + ", "
             + (quantity - remremove)
             + "/"
             + quantity
             + ")");
   }
 }
Esempio n. 2
0
 public final void handlePacket(SeekableLittleEndianAccessor slea, MapleClient c) {
   if (!c.getPlayer().isAlive()) {
     c.getSession().write(MaplePacketCreator.enableActions());
     return;
   }
   MapleItemInformationProvider ii = MapleItemInformationProvider.getInstance();
   slea.readInt();
   byte slot = (byte) slea.readShort();
   int itemId = slea.readInt();
   IItem toUse = c.getPlayer().getInventory(MapleInventoryType.USE).getItem(slot);
   if (toUse != null && toUse.getQuantity() > 0 && toUse.getItemId() == itemId) {
     if (itemId == 2022178 || itemId == 2022433 || itemId == 2050004) {
       c.getPlayer().dispelDebuffs();
       remove(c, slot);
       return;
     } else if (itemId == 2050003) {
       c.getPlayer().dispelSeal();
       remove(c, slot);
       return;
     }
     if (isTownScroll(itemId)) {
       if (ii.getItemEffect(toUse.getItemId()).applyTo(c.getPlayer())) {
         remove(c, slot);
       }
       c.getSession().write(MaplePacketCreator.enableActions());
       return;
     }
     remove(c, slot);
     ii.getItemEffect(toUse.getItemId()).applyTo(c.getPlayer());
     c.getPlayer().checkBerserk();
   }
 }
 public static boolean checkSpace(
     final MapleClient c, final int Id, int quantity, final String owner) {
   final MapleItemInformationProvider ii = MapleItemInformationProvider.getInstance();
   final MapleInventoryType type = ii.getInventoryType(Id);
   if (!type.equals(MapleInventoryType.EQUIP)) {
     final short slotMax = ii.getSlotMax(c, Id);
     final List<IItem> existing = c.getPlayer().getInventory(type).listById(Id);
     if (!InventoryConstants.isRechargable(Id)) {
       if (existing.size() > 0) {
         for (IItem eItem : existing) {
           final short oldQ = eItem.getQuantity();
           if (oldQ < slotMax && owner.equals(eItem.getOwner())) {
             final short newQ = (short) Math.min(oldQ + quantity, slotMax);
             quantity -= (newQ - oldQ);
           }
           if (quantity <= 0) {
             break;
           }
         }
       }
     }
     final int numSlotsNeeded;
     if (slotMax > 0) {
       numSlotsNeeded = (int) (Math.ceil(((double) quantity) / slotMax));
     } else if (InventoryConstants.isRechargable(Id)) {
       numSlotsNeeded = 1;
     } else {
       numSlotsNeeded = 1;
       System.out.println("checkSpace error");
     }
     return !c.getPlayer().getInventory(type).isFull(numSlotsNeeded - 1);
   } else {
     return !c.getPlayer().getInventory(type).isFull();
   }
 }
 public static void drop(MapleClient c, MapleInventoryType type, short src, short quantity) {
   if (src < 0) {
     type = MapleInventoryType.EQUIPPED;
   }
   IItem source = c.getPlayer().getInventory(type).getItem(src);
   int Id = source.getId();
   if (c.getPlayer().getItemEffect() == Id && source.getQuantity() == 1) {
     c.getPlayer().setItemEffect(0);
     c.getPlayer().getMap().broadcastMessage(EffectFactory.itemEffect(c.getPlayer().getId(), 0));
   } else if (Id == 5370000 || Id == 5370001) { // not actually possible
     if (c.getPlayer().getItemQuantity(Id, false) == 1) {
       c.getPlayer().setChalkboard(null);
     }
   } else if ((Id >= 5000000 && Id <= 5000100) || Id == 4031284) {
     c.getPlayer().dropMessage("This item may not be dropped.");
     return;
   }
   if (c.getPlayer().getItemQuantity(Id, true) < quantity
       || quantity < 0
       || source == null
       || source.getFlag() == InventoryConstants.LOCK
       || (quantity == 0 && !InventoryConstants.isRechargable(Id))) {
     return;
   }
   Point dropPos = new Point(c.getPlayer().getPosition());
   if (quantity < source.getQuantity() && !InventoryConstants.isRechargable(Id)) {
     IItem target = source.copy();
     target.setQuantity(quantity);
     source.setQuantity((short) (source.getQuantity() - quantity));
     c.announce(InventoryFactory.dropInventoryItemUpdate(type, source));
     dropItem(c, target, dropPos);
   } else {
     c.getPlayer().getInventory(type).removeSlot(src);
     c.announce(
         InventoryFactory.dropInventoryItem((src < 0 ? MapleInventoryType.EQUIP : type), src));
     if (src < 0) {
       c.getPlayer().equipChanged();
     }
     dropItem(c, source, dropPos);
   }
 }
  public static void move(
      final MapleClient c, final MapleInventoryType type, final short src, final short dst) {
    if (src < 0 || dst < 0) {
      return;
    }
    final MapleItemInformationProvider ii = MapleItemInformationProvider.getInstance();
    final IItem source = c.getPlayer().getInventory(type).getItem(src);
    final IItem initialTarget = c.getPlayer().getInventory(type).getItem(dst);
    if (source == null) {
      return;
    }

    short olddstQ = -1;
    if (initialTarget != null) {
      olddstQ = initialTarget.getQuantity();
    }
    final short oldsrcQ = source.getQuantity();
    final short slotMax = ii.getSlotMax(c, source.getId());

    c.getPlayer().getInventory(type).move(src, dst, slotMax);
    if (!type.equals(MapleInventoryType.EQUIP)
        && initialTarget != null
        && initialTarget.getId() == source.getId()
        && !InventoryConstants.isRechargable(source.getId())) {
      if ((olddstQ + oldsrcQ) > slotMax) {
        c.announce(
            InventoryFactory.moveAndMergeWithRestInventoryItem(
                type, src, dst, (short) ((olddstQ + oldsrcQ) - slotMax), slotMax));
      } else {
        c.announce(
            InventoryFactory.moveAndMergeInventoryItem(
                type,
                src,
                dst,
                ((Item) c.getPlayer().getInventory(type).getItem(dst)).getQuantity()));
      }
    } else {
      c.announce(InventoryFactory.moveInventoryItem(type, src, dst));
    }
  }
Esempio n. 6
0
 public final void handlePacket(SeekableLittleEndianAccessor slea, MapleClient c) {
   if (!c.getPlayer().isAlive()) {
     c.announce(MaplePacketCreator.enableActions());
     return;
   }
   slea.readInt();
   byte slot = (byte) slea.readShort();
   int itemId = slea.readInt();
   MapleCharacter player = c.getPlayer();
   IItem toUse = c.getPlayer().getInventory(MapleInventoryType.USE).getItem(slot);
   if (toUse != null && toUse.getQuantity() == 1) {
     if (toUse.getItemId() != itemId) {
       return;
     }
     Map<String, Integer> skilldata =
         MapleItemInformationProvider.getInstance()
             .getSkillStats(toUse.getItemId(), c.getPlayer().getJob().getId());
     boolean canuse = false;
     boolean success = false;
     int skill = 0;
     int maxlevel = 0;
     if (skilldata == null) {
       return;
     }
     if (skilldata.get("skillid") == 0) {
       canuse = false;
     } else if (player.getMasterLevel(SkillFactory.getSkill(skilldata.get("skillid")))
             >= skilldata.get("reqSkillLevel")
         || skilldata.get("reqSkillLevel") == 0) {
       canuse = true;
       if (Randomizer.nextInt(101) < skilldata.get("success") && skilldata.get("success") != 0) {
         success = true;
         ISkill skill2 = SkillFactory.getSkill(skilldata.get("skillid"));
         player.changeSkillLevel(
             skill2,
             player.getSkillLevel(skill2),
             Math.max(skilldata.get("masterLevel"), player.getMasterLevel(skill2)),
             -1);
       } else {
         success = false;
         player.message(
             "The skill book lights up, but the skill winds up as if nothing happened.");
       }
       MapleInventoryManipulator.removeFromSlot(c, MapleInventoryType.USE, slot, (short) 1, false);
     } else {
       canuse = false;
     }
     player
         .getClient()
         .announce(MaplePacketCreator.skillBookSuccess(player, skill, maxlevel, canuse, success));
   }
 }
 public static void removeFromSlot(
     final MapleClient c,
     final MapleInventoryType type,
     final short slot,
     final short quantity,
     final boolean fromDrop,
     final boolean consume) {
   final IItem item = c.getPlayer().getInventory(type).getItem(slot);
   final boolean allowZero = consume && InventoryConstants.isRechargable(item.getId());
   c.getPlayer().getInventory(type).removeItem(slot, quantity, allowZero);
   if (item.getQuantity() == 0 && !allowZero) {
     c.announce(InventoryFactory.clearInventoryItem(type, item.getPosition(), fromDrop));
   } else {
     c.announce(InventoryFactory.updateInventorySlot(type, (Item) item, fromDrop));
   }
 }
 public static boolean addFromDrop(
     final MapleClient c, final IItem item, final boolean show, final boolean showAnyMessage) {
   final MapleItemInformationProvider ii = MapleItemInformationProvider.getInstance();
   if (ii.isPickupRestricted(item.getId())
       && c.getPlayer().getItemQuantity(item.getId(), true) > 0
       && showAnyMessage) {
     c.announce(InventoryFactory.getInventoryFull());
     c.announce(InventoryFactory.showItemUnavailable());
     return false;
   }
   final MapleInventoryType type = ii.getInventoryType(item.getId());
   short quantity = item.getQuantity();
   if (!type.equals(MapleInventoryType.EQUIP)) {
     final short slotMax = ii.getSlotMax(c, item.getId());
     final List<IItem> existing = c.getPlayer().getInventory(type).listById(item.getId());
     if (!InventoryConstants.isRechargable(item.getId())) {
       if (existing.size() > 0) { // first update all existing slots to slotMax
         Iterator<IItem> i = existing.iterator();
         while (quantity > 0) {
           if (i.hasNext()) {
             final Item eItem = (Item) i.next();
             final short oldQ = eItem.getQuantity();
             if (oldQ < slotMax && item.getOwner().equals(eItem.getOwner())) {
               short newQ = (short) Math.min(oldQ + quantity, slotMax);
               quantity -= (newQ - oldQ);
               eItem.setQuantity(newQ);
               short newQi = (short) Math.min(quantity, slotMax);
               quantity -= newQi;
               Item nItem = new Item(item.getId(), (short) 0, newQi);
               nItem.setOwner(item.getOwner());
               if (c.getPlayer().getInventory(type).fakeAddItem(nItem) == -1) {
                 eItem.setQuantity(oldQ);
                 return false;
               }
               quantity += newQi;
               c.announce(InventoryFactory.updateInventorySlot(type, eItem, showAnyMessage));
             }
           } else {
             break;
           }
         }
       }
       while (quantity > 0 || InventoryConstants.isRechargable(item.getId())) {
         final short newQ = (short) Math.min(quantity, slotMax);
         quantity -= newQ;
         final Item nItem = new Item(item.getId(), (short) 0, newQ);
         nItem.setOwner(item.getOwner());
         final short newSlot = c.getPlayer().getInventory(type).addItem(nItem);
         if (newSlot == -1) {
           if (showAnyMessage) {
             c.announce(InventoryFactory.getInventoryFull());
             c.announce(InventoryFactory.getShowInventoryFull());
           }
           item.setQuantity((short) (quantity + newQ));
           return false;
         }
         c.announce(InventoryFactory.addInventorySlot(type, nItem, true));
         if ((InventoryConstants.isRechargable(item.getId())) && quantity == 0) {
           break;
         }
       }
     } else {
       final Item nItem = new Item(item.getId(), (short) 0, quantity);
       final short newSlot = c.getPlayer().getInventory(type).addItem(nItem);
       if (newSlot == -1) {
         if (showAnyMessage) {
           c.announce(InventoryFactory.getInventoryFull());
           c.announce(InventoryFactory.getShowInventoryFull());
         }
         return false;
       }
       c.announce(InventoryFactory.addInventorySlot(type, nItem));
       c.announce(IntraPersonalFactory.enableActions());
     }
   } else if (quantity == 1) {
     final short newSlot = c.getPlayer().getInventory(type).addItem(item);
     if (newSlot == -1) {
       if (showAnyMessage) {
         c.announce(InventoryFactory.getInventoryFull());
         c.announce(InventoryFactory.getShowInventoryFull());
       }
       return false;
     }
     c.announce(InventoryFactory.addInventorySlot(type, item, true));
   } else {
     return false;
   }
   if (show) {
     c.announce(EffectFactory.getShowItemGain(item.getId(), item.getQuantity()));
   }
   return true;
 }
Esempio n. 9
0
 public void buy(MapleClient c, int item, short quantity) {
   MaplePlayerShopItem pItem = items.get(item);
   synchronized (items) {
     IItem newItem = pItem.getItem().copy();
     newItem.setQuantity((short) ((pItem.getItem().getQuantity() * quantity)));
     if ((newItem.getFlag() & ItemConstants.KARMA) == ItemConstants.KARMA) {
       newItem.setFlag((byte) (newItem.getFlag() ^ ItemConstants.KARMA));
     }
     if (newItem.getType() == IItem.ITEM
         && (newItem.getFlag() & ItemConstants.SPIKES) == ItemConstants.SPIKES) {
       newItem.setFlag((byte) (newItem.getFlag() ^ ItemConstants.SPIKES));
     }
     if (quantity < 1
         || pItem.getBundles() < 1
         || !pItem.isExist()
         || pItem.getBundles() < quantity) {
       c.announce(MaplePacketCreator.enableActions());
       return;
     } else if (newItem.getType() == 1 && newItem.getQuantity() > 1) {
       c.announce(MaplePacketCreator.enableActions());
       return;
     } else if (!pItem.isExist()) {
       c.announce(MaplePacketCreator.enableActions());
       return;
     }
     int price = pItem.getPrice() * quantity;
     if (c.getPlayer().getMeso() >= price) {
       if (MapleInventoryManipulator.addFromDrop(c, newItem, true)) {
         c.getPlayer().gainMeso(-price, false);
         sold.add(
             new SoldItem(c.getPlayer().getName(), pItem.getItem().getItemId(), quantity, price));
         pItem.setBundles((short) (pItem.getBundles() - quantity));
         if (pItem.getBundles() < 1) {
           pItem.setDoesExist(false);
         }
         MapleCharacter owner =
             Server.getInstance().getWorld(world).getPlayerStorage().getCharacterByName(ownerName);
         if (owner != null) {
           owner.addMerchantMesos(price);
         } else {
           try {
             PreparedStatement ps =
                 DatabaseConnection.getConnection()
                     .prepareStatement(
                         "UPDATE characters SET MerchantMesos = MerchantMesos + "
                             + price
                             + " WHERE id = ?",
                         Statement.RETURN_GENERATED_KEYS);
             ps.setInt(1, ownerId);
             ps.executeUpdate();
             ps.close();
           } catch (Exception e) {
           }
         }
       } else {
         c.getPlayer()
             .dropMessage(
                 1, "Your inventory is full. Please clean a slot before buying this item.");
       }
     } else {
       c.getPlayer().dropMessage(1, "You do not have enough mesos.");
     }
     try {
       this.saveItems(false);
     } catch (Exception e) {
     }
   }
 }
Esempio n. 10
0
 public final void handlePacket(SeekableLittleEndianAccessor slea, MapleClient c) {
   c.getPlayer().resetAfkTime();
   byte operation = slea.readByte();
   if (operation == Actions.TOSERVER_SEND_ITEM.getCode()) {
     final int fee = 5000;
     byte inventId = slea.readByte();
     short itemPos = slea.readShort();
     short amount = slea.readShort();
     int mesos = slea.readInt();
     String recipient = slea.readMapleAsciiString();
     if (amount < 0 || amount > 2000 || itemPos < 0 || inventId > 5 || inventId < 0) {
       return;
     }
     if (mesos < 0
         || (long) mesos > Integer.MAX_VALUE
         || ((long) mesos + fee + getFee(mesos)) > Integer.MAX_VALUE) {
       return;
     }
     int finalcost = mesos + fee + getFee(mesos);
     boolean send = false;
     if (c.getPlayer().getMeso() >= finalcost) {
       int accid = getAccIdFromCNAME(recipient, true);
       if (accid != -1) {
         if (accid != c.getAccID()) {
           c.getPlayer().gainMeso(-finalcost, false);
           c.getSession()
               .write(
                   MaplePacketCreator.sendDueyMSG(Actions.TOCLIENT_SUCCESSFULLY_SENT.getCode()));
           send = true;
         } else {
           c.getSession()
               .write(MaplePacketCreator.sendDueyMSG(Actions.TOCLIENT_SAMEACC_ERROR.getCode()));
         }
       } else {
         c.getSession()
             .write(
                 MaplePacketCreator.sendDueyMSG(Actions.TOCLIENT_NAME_DOES_NOT_EXIST.getCode()));
       }
     } else {
       c.getSession()
           .write(MaplePacketCreator.sendDueyMSG(Actions.TOCLIENT_NOT_ENOUGH_MESOS.getCode()));
     }
     boolean recipientOn = false;
     MapleClient rClient = null;
     try {
       int channel = c.getChannelServer().getWorldInterface().find(recipient);
       if (channel > -1) {
         recipientOn = true;
         ChannelServer rcserv = ChannelServer.getInstance(channel);
         rClient = rcserv.getPlayerStorage().getCharacterByName(recipient).getClient();
       }
     } catch (RemoteException re) {
       c.getChannelServer().reconnectWorld();
     }
     if (send) {
       if (inventId > 0) {
         MapleInventoryType inv = MapleInventoryType.getByType(inventId);
         IItem item = c.getPlayer().getInventory(inv).getItem((byte) itemPos);
         if (item != null && c.getPlayer().getItemQuantity(item.getItemId(), false) > amount) {
           if (InventoryConstants.isRechargable(item.getItemId())) {
             MapleInventoryManipulator.removeFromSlot(
                 c, inv, (byte) itemPos, item.getQuantity(), true);
           } else {
             MapleInventoryManipulator.removeFromSlot(c, inv, (byte) itemPos, amount, true, false);
           }
           addItemToDB(
               item, amount, mesos, c.getPlayer().getName(), getAccIdFromCNAME(recipient, false));
         } else {
           return;
         }
       } else {
         addMesoToDB(mesos, c.getPlayer().getName(), getAccIdFromCNAME(recipient, false));
       }
       if (recipientOn && rClient != null) {
         rClient
             .getSession()
             .write(MaplePacketCreator.sendDueyMSG(Actions.TOCLIENT_PACKAGE_MSG.getCode()));
       }
       c.getPlayer().gainMeso(-fee, false);
     }
   } else if (operation == Actions.TOSERVER_REMOVE_PACKAGE.getCode()) {
     int packageid = slea.readInt();
     removeItemFromDB(packageid);
     c.getSession().write(MaplePacketCreator.removeItemFromDuey(true, packageid));
   } else if (operation == Actions.TOSERVER_CLAIM_PACKAGE.getCode()) {
     int packageid = slea.readInt();
     List<DueyPackages> packages = new LinkedList<DueyPackages>();
     DueyPackages dp = null;
     Connection con = DatabaseConnection.getConnection();
     try {
       PreparedStatement ps =
           con.prepareStatement(
               "SELECT * FROM dueypackages LEFT JOIN dueyitems USING (PackageId) WHERE PackageId = ?"); // PLEASE WORK D:
       ps.setInt(1, packageid);
       ResultSet rs = ps.executeQuery();
       DueyPackages dueypack = null;
       if (rs.next()) {
         dueypack = getItemByPID(rs);
         dueypack.setSender(rs.getString("SenderName"));
         dueypack.setMesos(rs.getInt("Mesos"));
         dueypack.setSentTime(rs.getString("TimeStamp"));
         packages.add(dueypack);
       }
       rs.close();
       ps.close();
       dp = dueypack;
     } catch (SQLException e) {
     }
     if (dp.getItem() != null) {
       if (!MapleInventoryManipulator.checkSpace(
           c, dp.getItem().getItemId(), dp.getItem().getQuantity(), dp.getItem().getOwner())) {
         c.getPlayer().dropMessage(1, "Your inventory is full");
         c.getSession().write(MaplePacketCreator.enableActions());
         return;
       } else {
         MapleInventoryManipulator.addFromDrop(c, dp.getItem(), false);
       }
     }
     int gainmesos = 0;
     long totalmesos = (long) dp.getMesos() + (long) c.getPlayer().getMeso();
     if (totalmesos >= Integer.MAX_VALUE) {
       gainmesos = 2147383647 - c.getPlayer().getMeso();
     } else if (totalmesos < 0 || dp.getMesos() < 0) {
       // do nothing
     } else {
       c.getPlayer().gainMeso(gainmesos, false);
     }
     removeItemFromDB(packageid);
     c.getSession().write(MaplePacketCreator.removeItemFromDuey(false, packageid));
   }
 }
Esempio n. 11
0
 public final void handlePacket(SeekableLittleEndianAccessor slea, MapleClient c) {
   if (!c.getPlayer().getCashShop().isOpened()) {
     return;
   }
   if (slea.available() > 0) {
     byte op = slea.readByte();
     if (op == 2) { // put item up for sale
       byte itemtype = slea.readByte();
       int itemid = slea.readInt();
       slea.readShort();
       slea.skip(7);
       short stars = 1;
       if (itemtype == 1) {
         slea.skip(32);
       } else {
         stars = slea.readShort();
       }
       slea.readMapleAsciiString(); // another useless thing (owner)
       if (itemtype == 1) {
         slea.skip(32);
       } else {
         slea.readShort();
       }
       byte slot = 1;
       short quantity = 1;
       if (itemtype != 1) {
         if (itemid / 10000 == 207 || itemid / 10000 == 233) {
           slea.skip(8);
         }
         slot = (byte) slea.readInt();
       } else {
         slot = (byte) slea.readInt();
       }
       if (itemtype != 1) {
         if (itemid / 10000 == 207 || itemid / 10000 == 233) {
           quantity = stars;
           slea.skip(4);
         } else {
           quantity = (short) slea.readInt();
         }
       } else {
         quantity = (byte) slea.readInt();
       }
       int price = slea.readInt();
       if (itemtype == 1) {
         quantity = 1;
       }
       if (quantity < 0
           || price < 110
           || c.getPlayer().getItemQuantity(itemid, false) < quantity) {
         return;
       }
       MapleInventoryType type =
           MapleItemInformationProvider.getInstance().getInventoryType(itemid);
       IItem i = c.getPlayer().getInventory(type).getItem(slot).copy();
       if (i != null && c.getPlayer().getMeso() >= 5000) {
         Connection con = DatabaseConnection.getConnection();
         try {
           PreparedStatement ps =
               con.prepareStatement("SELECT COUNT(*) FROM mts_items WHERE seller = ?");
           ps.setInt(1, c.getPlayer().getId());
           ResultSet rs = ps.executeQuery();
           if (rs.next()) {
             if (rs.getInt(1) > 10) { // They have more than 10
               // items up for sale
               // already!
               c.getPlayer().dropMessage(1, "You already have 10 items up for auction!");
               c.announce(getMTS(1, 0, 0));
               c.announce(
                   MaplePacketCreator.transferInventory(getTransfer(c.getPlayer().getId())));
               c.announce(MaplePacketCreator.notYetSoldInv(getNotYetSold(c.getPlayer().getId())));
               rs.close();
               ps.close();
               return;
             }
           }
           rs.close();
           ps.close();
           Calendar calendar = Calendar.getInstance();
           int year = 2008;
           int month = 6;
           int day = 17;
           int oldmax = calendar.getActualMaximum(Calendar.DAY_OF_MONTH);
           int oldday = calendar.get(Calendar.DAY_OF_MONTH) + 7;
           if (oldmax < oldday) {
             if (calendar.get(Calendar.MONTH) + 2 > 12) {
               year = calendar.get(Calendar.YEAR) + 1;
               month = 1;
               calendar.set(year, month, 1);
               day = oldday - oldmax;
             } else {
               month = calendar.get(Calendar.MONTH) + 2;
               year = calendar.get(Calendar.YEAR);
               calendar.set(year, month, 1);
               day = oldday - oldmax;
             }
           } else {
             day = calendar.get(Calendar.DAY_OF_MONTH) + 7;
             month = calendar.get(Calendar.MONTH);
             year = calendar.get(Calendar.YEAR);
           }
           String date = year + "-";
           if (month < 10) {
             date += "0" + month + "-";
           } else {
             date += month + "-";
           }
           if (day < 10) {
             date += "0" + day;
           } else {
             date += day + "";
           }
           if (i.getType() == 2) {
             Item item = (Item) i;
             ps =
                 con.prepareStatement(
                     "INSERT INTO mts_items (tab, type, itemid, quantity, seller, price, owner, sellername, sell_ends) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
             ps.setInt(1, 1);
             ps.setInt(2, (int) type.getType());
             ps.setInt(3, item.getItemId());
             ps.setInt(4, quantity);
             ps.setInt(5, c.getPlayer().getId());
             ps.setInt(6, price);
             ps.setString(7, item.getOwner());
             ps.setString(8, c.getPlayer().getName());
             ps.setString(9, date);
           } else {
             Equip equip = (Equip) i;
             ps =
                 con.prepareStatement(
                     "INSERT INTO mts_items (tab, type, itemid, quantity, seller, price, upgradeslots, level, str, dex, `int`, luk, hp, mp, watk, matk, wdef, mdef, acc, avoid, hands, speed, jump, locked, owner, sellername, sell_ends, vicious, flag) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
             ps.setInt(1, 1);
             ps.setInt(2, (int) type.getType());
             ps.setInt(3, equip.getItemId());
             ps.setInt(4, quantity);
             ps.setInt(5, c.getPlayer().getId());
             ps.setInt(6, price);
             ps.setInt(7, equip.getUpgradeSlots());
             ps.setInt(8, equip.getLevel());
             ps.setInt(9, equip.getStr());
             ps.setInt(10, equip.getDex());
             ps.setInt(11, equip.getInt());
             ps.setInt(12, equip.getLuk());
             ps.setInt(13, equip.getHp());
             ps.setInt(14, equip.getMp());
             ps.setInt(15, equip.getWatk());
             ps.setInt(16, equip.getMatk());
             ps.setInt(17, equip.getWdef());
             ps.setInt(18, equip.getMdef());
             ps.setInt(19, equip.getAcc());
             ps.setInt(20, equip.getAvoid());
             ps.setInt(21, equip.getHands());
             ps.setInt(22, equip.getSpeed());
             ps.setInt(23, equip.getJump());
             ps.setInt(24, 0);
             ps.setString(25, equip.getOwner());
             ps.setString(26, c.getPlayer().getName());
             ps.setString(27, date);
             ps.setInt(28, equip.getVicious());
             ps.setInt(29, equip.getFlag());
           }
           ps.executeUpdate();
           ps.close();
           MapleInventoryManipulator.removeFromSlot(c, type, slot, quantity, false);
         } catch (SQLException e) {
         }
         c.getPlayer().gainMeso(-5000, false);
         c.announce(MaplePacketCreator.MTSConfirmSell());
         c.announce(getMTS(1, 0, 0));
         c.announce(MaplePacketCreator.enableCSUse());
         c.announce(MaplePacketCreator.transferInventory(getTransfer(c.getPlayer().getId())));
         c.announce(MaplePacketCreator.notYetSoldInv(getNotYetSold(c.getPlayer().getId())));
       }
     } else if (op == 3) { // send offer for wanted item
     } else if (op == 4) { // list wanted item
       slea.readInt();
       slea.readInt();
       slea.readInt();
       slea.readShort();
       slea.readMapleAsciiString();
     } else if (op == 5) { // change page
       int tab = slea.readInt();
       int type = slea.readInt();
       int page = slea.readInt();
       c.getPlayer().changePage(page);
       if (tab == 4 && type == 0) {
         c.announce(getCart(c.getPlayer().getId()));
       } else if (tab == c.getPlayer().getCurrentTab()
           && type == c.getPlayer().getCurrentType()
           && c.getPlayer().getSearch() != null) {
         c.announce(
             getMTSSearch(
                 tab, type, c.getPlayer().getCurrentCI(), c.getPlayer().getSearch(), page));
       } else {
         c.getPlayer().setSearch(null);
         c.announce(getMTS(tab, type, page));
       }
       c.getPlayer().changeTab(tab);
       c.getPlayer().changeType(type);
       c.announce(MaplePacketCreator.enableCSUse());
       c.announce(MaplePacketCreator.transferInventory(getTransfer(c.getPlayer().getId())));
       c.announce(MaplePacketCreator.notYetSoldInv(getNotYetSold(c.getPlayer().getId())));
     } else if (op == 6) { // search
       int tab = slea.readInt();
       int type = slea.readInt();
       slea.readInt();
       int ci = slea.readInt();
       String search = slea.readMapleAsciiString();
       c.getPlayer().setSearch(search);
       c.getPlayer().changeTab(tab);
       c.getPlayer().changeType(type);
       c.getPlayer().changeCI(ci);
       c.announce(MaplePacketCreator.enableCSUse());
       c.announce(MaplePacketCreator.enableActions());
       c.announce(getMTSSearch(tab, type, ci, search, c.getPlayer().getCurrentPage()));
       c.announce(MaplePacketCreator.showMTSCash(c.getPlayer()));
       c.announce(MaplePacketCreator.transferInventory(getTransfer(c.getPlayer().getId())));
       c.announce(MaplePacketCreator.notYetSoldInv(getNotYetSold(c.getPlayer().getId())));
     } else if (op == 7) { // cancel sale
       int id = slea.readInt(); // id of the item
       Connection con = DatabaseConnection.getConnection();
       try {
         PreparedStatement ps =
             con.prepareStatement("UPDATE mts_items SET transfer = 1 WHERE id = ? AND seller = ?");
         ps.setInt(1, id);
         ps.setInt(2, c.getPlayer().getId());
         ps.executeUpdate();
         ps.close();
         ps = con.prepareStatement("DELETE FROM mts_cart WHERE itemid = ?");
         ps.setInt(1, id);
         ps.executeUpdate();
         ps.close();
       } catch (SQLException e) {
         e.printStackTrace();
       }
       c.announce(MaplePacketCreator.enableCSUse());
       c.announce(
           getMTS(
               c.getPlayer().getCurrentTab(),
               c.getPlayer().getCurrentType(),
               c.getPlayer().getCurrentPage()));
       c.announce(MaplePacketCreator.notYetSoldInv(getNotYetSold(c.getPlayer().getId())));
       c.announce(MaplePacketCreator.transferInventory(getTransfer(c.getPlayer().getId())));
     } else if (op == 8) { // transfer item from transfer inv.
       int id = slea.readInt(); // id of the item
       Connection con = DatabaseConnection.getConnection();
       PreparedStatement ps;
       ResultSet rs;
       try {
         ps =
             con.prepareStatement(
                 "SELECT * FROM mts_items WHERE seller = ? AND transfer = 1  AND id= ? ORDER BY id DESC");
         ps.setInt(1, c.getPlayer().getId());
         ps.setInt(2, id);
         rs = ps.executeQuery();
         if (rs.next()) {
           IItem i;
           if (rs.getInt("type") != 1) {
             Item ii = new Item(rs.getInt("itemid"), (byte) 0, (short) rs.getInt("quantity"));
             ii.setOwner(rs.getString("owner"));
             ii.setPosition(
                 c.getPlayer()
                     .getInventory(
                         MapleItemInformationProvider.getInstance()
                             .getInventoryType(rs.getInt("itemid")))
                     .getNextFreeSlot());
             i = ii.copy();
           } else {
             Equip equip = new Equip(rs.getInt("itemid"), (byte) rs.getInt("position"), -1);
             equip.setOwner(rs.getString("owner"));
             equip.setQuantity((short) 1);
             equip.setAcc((short) rs.getInt("acc"));
             equip.setAvoid((short) rs.getInt("avoid"));
             equip.setDex((short) rs.getInt("dex"));
             equip.setHands((short) rs.getInt("hands"));
             equip.setHp((short) rs.getInt("hp"));
             equip.setInt((short) rs.getInt("int"));
             equip.setJump((short) rs.getInt("jump"));
             equip.setLuk((short) rs.getInt("luk"));
             equip.setMatk((short) rs.getInt("matk"));
             equip.setMdef((short) rs.getInt("mdef"));
             equip.setMp((short) rs.getInt("mp"));
             equip.setSpeed((short) rs.getInt("speed"));
             equip.setStr((short) rs.getInt("str"));
             equip.setWatk((short) rs.getInt("watk"));
             equip.setWdef((short) rs.getInt("wdef"));
             equip.setUpgradeSlots((byte) rs.getInt("upgradeslots"));
             equip.setLevel((byte) rs.getInt("level"));
             equip.setVicious((byte) rs.getInt("vicious"));
             equip.setFlag((byte) rs.getInt("flag"));
             equip.setPosition(
                 c.getPlayer()
                     .getInventory(
                         MapleItemInformationProvider.getInstance()
                             .getInventoryType(rs.getInt("itemid")))
                     .getNextFreeSlot());
             i = equip.copy();
           }
           PreparedStatement pse =
               con.prepareStatement(
                   "DELETE FROM mts_items WHERE id = ? AND seller = ? AND transfer = 1");
           pse.setInt(1, id);
           pse.setInt(2, c.getPlayer().getId());
           pse.executeUpdate();
           pse.close();
           MapleInventoryManipulator.addFromDrop(c, i, false);
           c.announce(MaplePacketCreator.enableCSUse());
           c.announce(getCart(c.getPlayer().getId()));
           c.announce(
               getMTS(
                   c.getPlayer().getCurrentTab(),
                   c.getPlayer().getCurrentType(),
                   c.getPlayer().getCurrentPage()));
           c.announce(MaplePacketCreator.MTSConfirmTransfer(i.getQuantity(), i.getPosition()));
           c.announce(MaplePacketCreator.transferInventory(getTransfer(c.getPlayer().getId())));
         }
         rs.close();
         ps.close();
       } catch (SQLException e) {
         Output.print("MTS Transfer error: " + e);
       }
     } else if (op == 9) { // add to cart
       int id = slea.readInt(); // id of the item
       Connection con = DatabaseConnection.getConnection();
       try {
         PreparedStatement ps1 =
             con.prepareStatement("SELECT * FROM mts_items WHERE id = ? AND seller <> ?");
         ps1.setInt(1, id); // Previene que agregues al cart tus
         // propios items
         ps1.setInt(2, c.getPlayer().getId());
         ResultSet rs1 = ps1.executeQuery();
         if (rs1.next()) {
           PreparedStatement ps =
               con.prepareStatement("SELECT * FROM mts_cart WHERE cid = ? AND itemid = ?");
           ps.setInt(1, c.getPlayer().getId());
           ps.setInt(2, id);
           ResultSet rs = ps.executeQuery();
           if (!rs.next()) {
             PreparedStatement pse =
                 con.prepareStatement("INSERT INTO mts_cart (cid, itemid) VALUES (?, ?)");
             pse.setInt(1, c.getPlayer().getId());
             pse.setInt(2, id);
             pse.executeUpdate();
             pse.close();
           }
           rs.close();
         }
         rs1.close();
       } catch (SQLException e) {
         e.printStackTrace();
       }
       c.announce(
           getMTS(
               c.getPlayer().getCurrentTab(),
               c.getPlayer().getCurrentType(),
               c.getPlayer().getCurrentPage()));
       c.announce(MaplePacketCreator.enableCSUse());
       c.announce(MaplePacketCreator.enableActions());
       c.announce(MaplePacketCreator.transferInventory(getTransfer(c.getPlayer().getId())));
       c.announce(MaplePacketCreator.notYetSoldInv(getNotYetSold(c.getPlayer().getId())));
     } else if (op == 10) { // delete from cart
       int id = slea.readInt(); // id of the item
       Connection con = DatabaseConnection.getConnection();
       try {
         PreparedStatement ps =
             con.prepareStatement("DELETE FROM mts_cart WHERE itemid = ? AND cid = ?");
         ps.setInt(1, id);
         ps.setInt(2, c.getPlayer().getId());
         ps.executeUpdate();
         ps.close();
       } catch (SQLException e) {
         e.printStackTrace();
       }
       c.announce(getCart(c.getPlayer().getId()));
       c.announce(MaplePacketCreator.enableCSUse());
       c.announce(MaplePacketCreator.transferInventory(getTransfer(c.getPlayer().getId())));
       c.announce(MaplePacketCreator.notYetSoldInv(getNotYetSold(c.getPlayer().getId())));
     } else if (op == 12) { // put item up for auction
     } else if (op == 13) { // cancel wanted cart thing
     } else if (op == 14) { // buy auction item now
     } else if (op == 16) { // buy
       int id = slea.readInt(); // id of the item
       Connection con = DatabaseConnection.getConnection();
       PreparedStatement ps;
       ResultSet rs;
       try {
         ps = con.prepareStatement("SELECT * FROM mts_items WHERE id = ? ORDER BY id DESC");
         ps.setInt(1, id);
         rs = ps.executeQuery();
         if (rs.next()) {
           int price = rs.getInt("price") + 100 + (int) (rs.getInt("price") * 0.1); // taxes
           if (c.getPlayer().getCashShop().getCash(4) >= price) { // FIX
             boolean alwaysnull = true;
             for (Channel cserv : Server.getInstance().getAllChannels()) {
               MapleCharacter victim =
                   cserv.getPlayerStorage().getCharacterById(rs.getInt("seller"));
               if (victim != null) {
                 victim.getCashShop().gainCash(4, rs.getInt("price"));
                 alwaysnull = false;
               }
             }
             if (alwaysnull) {
               PreparedStatement pse =
                   con.prepareStatement("SELECT accountid FROM characters WHERE id = ?");
               pse.setInt(1, rs.getInt("seller"));
               ResultSet rse = pse.executeQuery();
               if (rse.next()) {
                 PreparedStatement psee =
                     con.prepareStatement(
                         "UPDATE accounts SET nxPrepaid = nxPrepaid + ? WHERE id = ?");
                 psee.setInt(1, rs.getInt("price"));
                 psee.setInt(2, rse.getInt("accountid"));
                 psee.executeUpdate();
                 psee.close();
               }
               pse.close();
               rse.close();
             }
             PreparedStatement pse =
                 con.prepareStatement(
                     "UPDATE mts_items SET seller = ?, transfer = 1 WHERE id = ?");
             pse.setInt(1, c.getPlayer().getId());
             pse.setInt(2, id);
             pse.executeUpdate();
             pse.close();
             pse = con.prepareStatement("DELETE FROM mts_cart WHERE itemid = ?");
             pse.setInt(1, id);
             pse.executeUpdate();
             pse.close();
             c.getPlayer().getCashShop().gainCash(4, -price);
             c.announce(MaplePacketCreator.enableCSUse());
             c.announce(
                 getMTS(
                     c.getPlayer().getCurrentTab(),
                     c.getPlayer().getCurrentType(),
                     c.getPlayer().getCurrentPage()));
             c.announce(MaplePacketCreator.MTSConfirmBuy());
             c.announce(MaplePacketCreator.showMTSCash(c.getPlayer()));
             c.announce(MaplePacketCreator.transferInventory(getTransfer(c.getPlayer().getId())));
             c.announce(MaplePacketCreator.notYetSoldInv(getNotYetSold(c.getPlayer().getId())));
             c.announce(MaplePacketCreator.enableActions());
           } else {
             c.announce(MaplePacketCreator.MTSFailBuy());
           }
         }
         rs.close();
         ps.close();
       } catch (SQLException e) {
         c.announce(MaplePacketCreator.MTSFailBuy());
       }
     } else if (op == 17) { // buy from cart
       int id = slea.readInt(); // id of the item
       Connection con = DatabaseConnection.getConnection();
       PreparedStatement ps;
       ResultSet rs;
       try {
         ps = con.prepareStatement("SELECT * FROM mts_items WHERE id = ? ORDER BY id DESC");
         ps.setInt(1, id);
         rs = ps.executeQuery();
         if (rs.next()) {
           int price = rs.getInt("price") + 100 + (int) (rs.getInt("price") * 0.1);
           if (c.getPlayer().getCashShop().getCash(4) >= price) {
             for (Channel cserv : Server.getInstance().getAllChannels()) {
               MapleCharacter victim =
                   cserv.getPlayerStorage().getCharacterById(rs.getInt("seller"));
               if (victim != null) {
                 victim.getCashShop().gainCash(4, rs.getInt("price"));
               } else {
                 PreparedStatement pse =
                     con.prepareStatement("SELECT accountid FROM characters WHERE id = ?");
                 pse.setInt(1, rs.getInt("seller"));
                 ResultSet rse = pse.executeQuery();
                 if (rse.next()) {
                   PreparedStatement psee =
                       con.prepareStatement(
                           "UPDATE accounts SET nxPrepaid = nxPrepaid + ? WHERE id = ?");
                   psee.setInt(1, rs.getInt("price"));
                   psee.setInt(2, rse.getInt("accountid"));
                   psee.executeUpdate();
                   psee.close();
                 }
                 pse.close();
                 rse.close();
               }
             }
             PreparedStatement pse =
                 con.prepareStatement(
                     "UPDATE mts_items SET seller = ?, transfer = 1 WHERE id = ?");
             pse.setInt(1, c.getPlayer().getId());
             pse.setInt(2, id);
             pse.executeUpdate();
             pse.close();
             pse = con.prepareStatement("DELETE FROM mts_cart WHERE itemid = ?");
             pse.setInt(1, id);
             pse.executeUpdate();
             pse.close();
             c.getPlayer().getCashShop().gainCash(4, -price);
             c.announce(getCart(c.getPlayer().getId()));
             c.announce(MaplePacketCreator.enableCSUse());
             c.announce(MaplePacketCreator.MTSConfirmBuy());
             c.announce(MaplePacketCreator.showMTSCash(c.getPlayer()));
             c.announce(MaplePacketCreator.transferInventory(getTransfer(c.getPlayer().getId())));
             c.announce(MaplePacketCreator.notYetSoldInv(getNotYetSold(c.getPlayer().getId())));
           } else {
             c.announce(MaplePacketCreator.MTSFailBuy());
           }
         }
         rs.close();
         ps.close();
       } catch (SQLException e) {
         c.announce(MaplePacketCreator.MTSFailBuy());
       }
     } else {
       System.out.println("Unhandled OP(MTS): " + op + " Packet: " + slea.toString());
     }
   } else {
     c.announce(MaplePacketCreator.showMTSCash(c.getPlayer()));
   }
 }
Esempio n. 12
0
  public final void handlePacket(SeekableLittleEndianAccessor slea, MapleClient c) {
    slea.readInt(); // whatever...
    byte slot = (byte) slea.readShort();
    byte dst = (byte) slea.readShort();
    byte ws = (byte) slea.readShort();
    boolean whiteScroll = false; // white scroll being used?
    boolean legendarySpirit = false; // legendary spirit skill
    if ((ws & 2) == 2) {
      whiteScroll = true;
    }
    MapleItemInformationProvider ii = MapleItemInformationProvider.getInstance();
    IEquip toScroll = (IEquip) c.getPlayer().getInventory(MapleInventoryType.EQUIPPED).getItem(dst);
    ISkill LegendarySpirit = SkillFactory.getSkill(1003);
    if (c.getPlayer().getSkillLevel(LegendarySpirit) > 0 && dst >= 0) {
      legendarySpirit = true;
      toScroll = (IEquip) c.getPlayer().getInventory(MapleInventoryType.EQUIP).getItem(dst);
    }
    byte oldLevel = toScroll.getLevel();
    if (((IEquip) toScroll).getUpgradeSlots() < 1) {
      c.announce(MaplePacketCreator.getInventoryFull());
      return;
    }
    MapleInventory useInventory = c.getPlayer().getInventory(MapleInventoryType.USE);
    IItem scroll = useInventory.getItem(slot);
    IItem wscroll = null;
    List<Integer> scrollReqs = ii.getScrollReqs(scroll.getItemId());
    if (scrollReqs.size() > 0 && !scrollReqs.contains(toScroll.getItemId())) {
      c.announce(MaplePacketCreator.getInventoryFull());
      return;
    }
    if (whiteScroll) {
      wscroll = useInventory.findById(2340000);
      if (wscroll == null || wscroll.getItemId() != 2340000) {
        whiteScroll = false;
      }
    }
    if (scroll.getItemId() != 2049100 && !isCleanSlate(scroll.getItemId())) {
      if (!canScroll(scroll.getItemId(), toScroll.getItemId())) {
        return;
      }
    }
    if (scroll.getQuantity() < 1) {
      return;
    }
    try {
      IEquip scrolled = null;
      ScrollResult scrollSuccess = null;
      int sExpAdd = 0;
      Enchantment enchantment =
          (Enchantment) c.getPlayer().getPowerSkill(PowerSkillType.ENCHANTMENT);
      boolean isMultiScroll = enchantment.getMultiScrollChance() > Randomizer.nextFloat();
      int scrollMulti = 1 + (isMultiScroll ? enchantment.getMultiScrollAmount() : 0);
      if (scrollMulti > 1) sExpAdd += Randomizer.rand(0, 4);
      boolean removeSlot = enchantment.getNoSlotUse() > Randomizer.nextFloat();
      if (scrollMulti > scroll.getQuantity()) {
        scrollMulti = scroll.getQuantity();
      }
      int scrollCount = 0;
      while (scroll.getQuantity() > 0 && scrollMulti > 0) {
        scrollMulti--;
        scrollCount++;
        int scrollRerolls = enchantment.getRerolls();
        sExpAdd += scrollRerolls;

        float statMultiplier = 1 + enchantment.getExtraStats();
        if (statMultiplier > 1) sExpAdd++;

        scrolled =
            (IEquip)
                ii.scrollEquipWithId(
                    toScroll,
                    scroll.getItemId(),
                    whiteScroll,
                    removeSlot,
                    scrollRerolls,
                    statMultiplier,
                    c.getPlayer().isGM());

        if (scrolled != null && enchantment.getDoubleScroll() > Randomizer.nextFloat()) {
          scrolled =
              (IEquip)
                  ii.scrollEquipWithId(
                      scrolled,
                      scroll.getItemId(),
                      whiteScroll,
                      removeSlot,
                      scrollRerolls,
                      statMultiplier,
                      c.getPlayer().isGM());
        }

        scrollSuccess = IEquip.ScrollResult.FAIL; // fail
        if (scrolled == null) {
          scrollSuccess = IEquip.ScrollResult.CURSE;
        } else if (scrolled.getLevel() > oldLevel
            || (isCleanSlate(scroll.getItemId()) && scrolled.getLevel() == oldLevel + 1)) {
          scrollSuccess = IEquip.ScrollResult.SUCCESS;
        }
        useInventory.removeItem(scroll.getPosition(), (short) 1, false);
        if (whiteScroll) {
          useInventory.removeItem(wscroll.getPosition(), (short) 1, false);
          if (wscroll.getQuantity() < 1) {
            c.announce(
                MaplePacketCreator.clearInventoryItem(
                    MapleInventoryType.USE, wscroll.getPosition(), false));
          } else {
            c.announce(
                MaplePacketCreator.updateInventorySlot(MapleInventoryType.USE, (Item) wscroll));
          }
        }
        c.getPlayer()
            .getMap()
            .broadcastMessage(
                MaplePacketCreator.getScrollEffect(
                    c.getPlayer().getId(), scrollSuccess, legendarySpirit));
        if (scrollSuccess == IEquip.ScrollResult.CURSE) {
          break;
        }
      }
      if (scrollSuccess == IEquip.ScrollResult.CURSE) {
        scrollMulti = 0;
        c.announce(MaplePacketCreator.scrolledItem(scroll, toScroll, true));
        if (dst < 0) {
          c.getPlayer()
              .getInventory(MapleInventoryType.EQUIPPED)
              .removeItem(toScroll.getPosition());
        } else {
          c.getPlayer().getInventory(MapleInventoryType.EQUIP).removeItem(toScroll.getPosition());
        }
      } else {
        c.announce(MaplePacketCreator.scrolledItem(scroll, scrolled, false));
      }
      if (dst < 0
          && (scrollSuccess == IEquip.ScrollResult.SUCCESS
              || scrollSuccess == IEquip.ScrollResult.CURSE)) {
        c.getPlayer().equipChanged();
      }
      // sExpAdd /= initMulti;
      if (scrollCount > 1)
        c.getPlayer().message("You have successfully multi-scrolled " + scrollCount + " times!");
      c.getPlayer().addPowerSkillExp(PowerSkillType.ENCHANTMENT, sExpAdd + Randomizer.nextInt(4));
    } catch (Exception ex) {
      ex.printStackTrace();
    }
  }