Changeset 1503
Author: kosyachok
(2010/03/12 19:47) Almost 2 years ago
- MAIL. no express mail for now. Will be done a bit later. Use mail-1503.sql to put new table to DB.
Author: kosyachok
(2010/03/12 19:47) Almost 2 years ago
- MAIL. no express mail for now. Will be done a bit later. Use mail-1503.sql to put new table to DB.
{{DB.insertUpdate("UPDATE players SET name=?, exp=?, recoverexp=?, x=?, y=?, z=?, heading=?, world_id=?, player_class=?, last_online=?, cube_size=?, warehouse_size=?, note=?, bind_point=?, title_id=? WHERE id=?", new IUStH(){DB.insertUpdate("UPDATE players SET name=?, exp=?, recoverexp=?, x=?, y=?, z=?, heading=?, world_id=?, player_class=?, last_online=?, cube_size=?, warehouse_size=?, note=?, bind_point=?, title_id=?, mailboxLetters=? WHERE id=?", new IUStH(){{{stmt.setInt(16, player.getObjectId());stmt.setInt(16, player.getMailbox().getLettersCount());stmt.setInt(17, player.getObjectId());{DB.select("SELECT id FROM players WHERE name = ?", new ParamReadStH(){{{playerObjId.add(resultSet.getInt("id"));* {@inheritDoc}* {@inheritDoc}cd.setBindPoint(resultSet.getInt("bind_point"));cd.setBindPoint(resultSet.getInt("bind_point"));cd.setTitleId(resultSet.getInt("title_id"));cd.setTitleId(resultSet.getInt("title_id"));cd.setWarehouseSize(resultSet.getInt("warehouse_size"));cd.setWarehouseSize(resultSet.getInt("warehouse_size"));cd.setOnline(resultSet.getBoolean("online"));cd.setMailboxLetters(resultSet.getInt("mailboxLetters"));float x = resultSet.getFloat("x");float x = resultSet.getFloat("x");float y = resultSet.getFloat("y");float y = resultSet.getFloat("y");byte heading = resultSet.getByte("heading");byte heading = resultSet.getByte("heading");int worldId = resultSet.getInt("world_id");int worldId = resultSet.getInt("world_id");if(z < -1000 && playerInitialData != null){{{{{{{{{{{{LEGION_WAREHOUSE(3);LEGION_WAREHOUSE(3),MAILBOX(127);{{{protected void writeGeneralItemInfo(ByteBuffer buf, Item item, boolean isQuest, boolean privateStore, boolean mail){{writeH(buf, item.getEquipmentSlot()); // not equipable itemsif(!mail)writeH(buf, item.getEquipmentSlot()); // not equipable items{{this.writeWeaponInfo(buf, item, isInventory, false, false, false);protected void writeWeaponInfo(ByteBuffer buf, Item item, boolean isInventory, boolean isWeaponSwitch, boolean privateStore, boolean mail){{writeH(buf, item.isEquipped() ? 255 : item.getEquipmentSlot()); // FF FF equipmentif(!mail)writeH(buf, item.isEquipped() ? 255 : item.getEquipmentSlot()); // FF FF equipmentprotected void writeArmorInfo(ByteBuffer buf, Item item, boolean isInventory, boolean privateStore, boolean mail){{writeH(buf, item.isEquipped() ? 255 : item.getEquipmentSlot()); // FF FF equipmentif(!mail)writeH(buf, item.isEquipped() ? 255 : item.getEquipmentSlot()); // FF FF equipment{{writeArmorInfo(buf,item, true, false, false);{{writeGeneralItemInfo(buf, item, false, false, false);{{writeArmorInfo(buf,item, true, false, false);{{writeGeneralItemInfo(buf, item, false, false, false);{{writeArmorInfo(buf,item, true, false, false);{{writeGeneralItemInfo(buf, item, item.isQuest(), false, false);{{writeWeaponInfo(buf, item, false, false, true, false);{{writeArmorInfo(buf, item, false, true, false);{{writeGeneralItemInfo(buf, item, false, true, false);{{writeWeaponInfo(buf, item, true, isWeaponSwitch, false, false);{{writeArmorInfo(buf,item, true, false, false);{{writeGeneralItemInfo(buf, item, item.isQuest(), false, false);{{writeArmorInfo(buf,item, false, false, false);{{writeGeneralItemInfo(buf, item, item.isQuest(), false, false);writeArmorInfo(buf, item, false, false, false);writeGeneralItemInfo(buf, item, false, false, false);{{writeArmorInfo(buf,item, false, false, false);{{writeGeneralItemInfo(buf, item, item.isQuest(), false, false);addPacketOpcode(SM_MAIL_SERVICE.class, 0xA1, idSet);{{