Changeset 2440
Author: Sarynth
(2010/07/02 20:35) Over 1 year ago
[trunk] Merged 1.9 branch to trunk. 1.5.1.10-final tag available to remain on version 1.5
Author: Sarynth
(2010/07/02 20:35) Over 1 year ago
[trunk] Merged 1.9 branch to trunk. 1.5.1.10-final tag available to remain on version 1.5
int location = rset.getInt("itemLocation");int location = rset.getInt("itemLocation");int enchant = rset.getInt("enchant");int enchant = rset.getInt("enchant");int itemSkin = rset.getInt("itemSkin");int itemSkin = rset.getInt("itemSkin");brokerItems.add(new Item(itemUniqueId, itemId, itemCount, itemColor, false, false, slot, location, enchant, itemSkin));int fusionedItem = rset.getInt("fusionedItem");brokerItems.add(new Item(itemUniqueId, itemId, itemCount, itemColor, false, false, slot, location, enchant, itemSkin,fusionedItem));{{public static final String SELECT_QUERY = "SELECT `itemUniqueId`, `itemId`, `itemCount`, `itemColor`, `isEquiped`, `isSoulBound`, `slot`, `enchant`, `itemSkin`, `fusionedItem` FROM `inventory` WHERE `itemOwner`=? AND `itemLocation`=? AND `isEquiped`=?";public static final String INSERT_QUERY = "INSERT INTO `inventory` (`itemUniqueId`, `itemId`, `itemCount`, `itemColor`, `itemOwner`, `isEquiped`, isSoulBound, `slot`, `itemLocation`, `enchant`, `itemSkin`) VALUES(?,?,?,?,?,?,?,?,?,?, ?)";public static final String INSERT_QUERY = "INSERT INTO `inventory` (`itemUniqueId`, `itemId`, `itemCount`, `itemColor`, `itemOwner`, `isEquiped`, isSoulBound, `slot`, `itemLocation`, `enchant`, `itemSkin`, `fusionedItem`) VALUES(?,?,?,?,?,?,?,?,?,?, ?,?)";public static final String UPDATE_QUERY = "UPDATE inventory SET itemCount=?, itemColor=?, itemOwner=?, isEquiped=?, isSoulBound=?, slot=?, itemLocation=?, enchant=?, itemSkin=?, fusionedItem=? WHERE itemUniqueId=?";int slot = rset.getInt("slot");int slot = rset.getInt("slot");int enchant = rset.getInt("enchant");int enchant = rset.getInt("enchant");int itemSkin = rset.getInt("itemSkin");int itemSkin = rset.getInt("itemSkin");Item item = new Item(itemUniqueId, itemId, itemCount, itemColor, isEquiped == 1, isSoulBound == 1,slot, storage, enchant, itemSkin);int fusionedItem = rset.getInt("fusionedItem");Item item = new Item(itemUniqueId, itemId, itemCount, itemColor, isEquiped == 1, isSoulBound == 1,slot, storage, enchant, itemSkin,fusionedItem);int slot = rset.getInt("slot");int slot = rset.getInt("slot");int enchant = rset.getInt("enchant");int enchant = rset.getInt("enchant");int itemSkin = rset.getInt("itemSkin");int itemSkin = rset.getInt("itemSkin");Item item = new Item(itemUniqueId, itemId, itemCount, itemColor, true, isSoulBound == 1, slot, storage, enchant, itemSkin);int fusionedItem = rset.getInt("fusionedItem");Item item = new Item(itemUniqueId, itemId, itemCount, itemColor, true, isSoulBound == 1, slot, storage, enchant, itemSkin,fusionedItem);int slot = rset.getInt("slot");int slot = rset.getInt("slot");int enchant = rset.getInt("enchant");int enchant = rset.getInt("enchant");int itemSkin = rset.getInt("itemSkin");int itemSkin = rset.getInt("itemSkin");Item item = new Item(itemUniqueId, itemId, itemCount, itemColor, true, isSoulBound == 1, slot, storage, enchant, itemSkin);int fusionedItem = rset.getInt("fusionedItem");Item item = new Item(itemUniqueId, itemId, itemCount, itemColor, true, isSoulBound == 1, slot, storage, enchant, itemSkin,fusionedItem);stmt.setInt(10, item.getObjectId());stmt.setInt(10, item.getFusionedItem());stmt.setInt(11, item.getObjectId());private static final String SELECT_STORAGE_QUERY = "SELECT `itemUniqueId`, `itemId`, `itemCount`, `itemColor`, `isEquiped`, `slot`, `enchant`, `itemSkin`, `fusionedItem` FROM `inventory` WHERE `itemOwner`=? AND `itemLocation`=? AND `isEquiped`=?";int slot = rset.getInt("slot");int slot = rset.getInt("slot");int enchant = rset.getInt("enchant");int enchant = rset.getInt("enchant");int itemSkin = rset.getInt("itemSkin");int itemSkin = rset.getInt("itemSkin");Item item = new Item(itemUniqueId, itemId, itemCount, itemColor, isEquiped == 1, false, slot, storage, enchant, itemSkin);int fusionedItem = rset.getInt("fusionedItem");Item item = new Item(itemUniqueId, itemId, itemCount, itemColor, isEquiped == 1, false, slot, storage, enchant, itemSkin,fusionedItem);int slot = rset.getInt("slot");int slot = rset.getInt("slot");int enchant = rset.getInt("enchant");int enchant = rset.getInt("enchant");int itemSkin = rset.getInt("itemSkin");int itemSkin = rset.getInt("itemSkin");Item item = new Item(itemUniqueId, itemId, itemCount, itemColor, isEquiped == 1, isSoulBound == 1, slot, StorageType.MAILBOX.getId(), enchant, itemSkin);int fusionedItem = rset.getInt("fusionedItem");Item item = new Item(itemUniqueId, itemId, itemCount, itemColor, isEquiped == 1, isSoulBound == 1, slot, StorageType.MAILBOX.getId(), enchant, itemSkin,fusionedItem);else if(params[0].toLowerCase().equals("inggison")){else if(params[0].toLowerCase().equals("gelkmaros")){else if(params[0].toLowerCase().equals("kaisinel")){else if(params[0].toLowerCase().equals("marchutan")){import com.aionemu.gameserver.network.aion.serverpackets.SM_QUEST_STEP;import com.aionemu.gameserver.network.aion.serverpackets.SM_QUEST_ACCEPTED;PacketSendUtility.sendPacket(target, new SM_QUEST_STEP(questId, qs.getStatus(), qs.getQuestVars().getQuestVars()));PacketSendUtility.sendPacket(target, new SM_QUEST_ACCEPTED(questId, qs.getStatus(), qs.getQuestVars().getQuestVars()));PacketSendUtility.broadcastPacket(admin, new SM_EMOTION(admin, 30, 0, 0), true);PacketSendUtility.broadcastPacket(admin, new SM_EMOTION(admin, 33, 0, 0), true);{{{{{{if(var >= 3 && var <= 10)if(qs.getQuestVarById(1) == 2 && qs.getQuestVarById(2) == 3 && var == 4){{{{{if(var >= 3 && var <= 10)if(qs.getQuestVarById(1) == 3 && qs.getQuestVarById(2) == 2 && var == 4){{{PacketSendUtility.broadcastPacket(player, new SM_EMOTION(player, 37, 0,PacketSendUtility.broadcastPacket(player, new SM_EMOTION(player, 40, 0,ThreadPoolManager.getInstance().schedule(new Runnable(){ThreadPoolManager.getInstance().schedule(new Runnable(){PacketSendUtility.broadcastPacket(player, new SM_EMOTION(player, 38, 0,PacketSendUtility.broadcastPacket(player, new SM_EMOTION(player, 41, 0,if(qs == null || qs.getQuestVars().getQuestVars() != 0)if(qs == null || qs.getStatus() != QuestStatus.START)if(qs == null || qs.getStatus() == QuestStatus.NONE){{{{if(env.getDialogId() == 25)switch(env.getDialogId())return sendQuestDialog(player, env.getVisibleObject().getObjectId(), 1011);{if (ItemService.addItems(player, Collections.singletonList(new QuestItems(182200519, 1))))case 25:return defaultQuestStartDialog(env);return sendQuestDialog(player, env.getVisibleObject().getObjectId(), 1011);case 1007:return sendQuestDialog(player, env.getVisibleObject().getObjectId(), 4);case 1002:if (!ItemService.addItems(player, Collections.singletonList(new QuestItems(182200519, 1))));QuestService.questTimerStart(env, 900);if (QuestService.startQuest(env, QuestStatus.START))return sendQuestDialog(player, env.getVisibleObject().getObjectId(), 1003);elsereturn false;case 1003:return sendQuestDialog(player, env.getVisibleObject().getObjectId(), 1004);}{{{<material rate="500000" nameid="1407909" itemid="152000103" name="High-Grade Gold Ore"/><material rate="500000" nameid="1407909" itemid="152000103" name="Greater Gold Ore"/><material rate="500000" nameid="1407911" itemid="152000105" name="High-Grade Platinum Ore"/><material rate="500000" nameid="1407911" itemid="152000105" name="Greater Platinum Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="High-Grade Mithril Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="Greater Mithril Ore"/><material rate="500000" nameid="1407909" itemid="152000103" name="High-Grade Gold Ore"/><material rate="500000" nameid="1407909" itemid="152000103" name="Greater Gold Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="High-Grade Mithril Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="Greater Mithril Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="High-Grade Mithril Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="Greater Mithril Ore"/><material rate="500000" nameid="1407909" itemid="152000103" name="High-Grade Gold Ore"/><material rate="500000" nameid="1407909" itemid="152000103" name="Greater Gold Ore"/><material rate="500000" nameid="1407911" itemid="152000105" name="High-Grade Platinum Ore"/><material rate="500000" nameid="1407911" itemid="152000105" name="Greater Platinum Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="High-Grade Mithril Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="Greater Mithril Ore"/><material rate="500000" nameid="1407909" itemid="152000103" name="High-Grade Gold Ore"/><material rate="500000" nameid="1407909" itemid="152000103" name="Greater Gold Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="High-Grade Mithril Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="Greater Mithril Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="High-Grade Mithril Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="Greater Mithril Ore"/><gatherable_template id="400201" name="Ore" nameId="701941" sourceType="METAL" harvestCount="3" skillLevel="15" harvestSkill="30001" successAdj="100" failureAdj="100" aerialAdj="100"><gatherable_template id="400158" name="Malevite" nameId="751117" sourceType="NOBLEMETAL" harvestCount="3" skillLevel="460" harvestSkill="30002" successAdj="100" failureAdj="100" aerialAdj="100"><material rate="500000" nameid="1407893" itemid="152000203" name="High-Grade Titanium Ore"/><material rate="500000" nameid="1407893" itemid="152000203" name="Greater Titanium Ore"/><material rate="500000" nameid="1407893" itemid="152000203" name="High-Grade Titanium Ore"/><material rate="500000" nameid="1407893" itemid="152000203" name="Greater Titanium Ore"/><material rate="500000" nameid="1407895" itemid="152000205" name="High-Grade Adamantium Ore"/><material rate="500000" nameid="1407895" itemid="152000205" name="Greater Adamantium Ore"/><material rate="500000" nameid="1407895" itemid="152000205" name="High-Grade Adamantium Ore"/><material rate="500000" nameid="1407895" itemid="152000205" name="Greater Adamantium Ore"/><material rate="500000" nameid="1407897" itemid="152000208" name="High-Grade Orichalcum Ore"/><material rate="500000" nameid="1407897" itemid="152000208" name="Greater Orichalcum Ore"/><material rate="500000" nameid="1407893" itemid="152000203" name="High-Grade Titanium Ore"/><material rate="500000" nameid="1407893" itemid="152000203" name="Greater Titanium Ore"/><material rate="500000" nameid="1407897" itemid="152000208" name="High-Grade Orichalcum Ore"/><material rate="500000" nameid="1407897" itemid="152000208" name="Greater Orichalcum Ore"/><material rate="500000" nameid="1407897" itemid="152000208" name="High-Grade Orichalcum Ore"/><material rate="500000" nameid="1407897" itemid="152000208" name="Greater Orichalcum Ore"/><gatherable_template id="400251" name="Ore" nameId="702091" sourceType="METAL" harvestCount="3" skillLevel="15" harvestSkill="30001" successAdj="100" failureAdj="100" aerialAdj="100"><gatherable_template id="400213" name="Drenite" nameId="748596" sourceType="METAL" harvestCount="3" skillLevel="400" harvestSkill="30002" successAdj="100" failureAdj="100" aerialAdj="100"><material rate="500000" nameid="1407893" itemid="152000203" name="High-Grade Titanium Ore"/><material rate="500000" nameid="1407893" itemid="152000203" name="Greater Titanium Ore"/><material rate="500000" nameid="1407893" itemid="152000203" name="High-Grade Titanium Ore"/><material rate="500000" nameid="1407893" itemid="152000203" name="Greater Titanium Ore"/><material rate="500000" nameid="1407895" itemid="152000205" name="High-Grade Adamantium Ore"/><material rate="500000" nameid="1407895" itemid="152000205" name="Greater Adamantium Ore"/><material rate="500000" nameid="1407895" itemid="152000205" name="High-Grade Adamantium Ore"/><material rate="500000" nameid="1407895" itemid="152000205" name="Greater Adamantium Ore"/><material rate="500000" nameid="1407897" itemid="152000208" name="High-Grade Orichalcum Ore"/><material rate="500000" nameid="1407897" itemid="152000208" name="Greater Orichalcum Ore"/><material rate="500000" nameid="1407893" itemid="152000203" name="High-Grade Titanium Ore"/><material rate="500000" nameid="1407893" itemid="152000203" name="Greater Titanium Ore"/><material rate="500000" nameid="1407897" itemid="152000208" name="High-Grade Orichalcum Ore"/><material rate="500000" nameid="1407897" itemid="152000208" name="Greater Orichalcum Ore"/><gatherable_template id="400308" name="Lapis Lazuli" nameId="701973" sourceType="JEWELRY" harvestCount="1" skillLevel="245" harvestSkill="30002" successAdj="100" failureAdj="100" aerialAdj="100"><material rate="9000000" nameid="1404081" itemid="152000309" name="Lapis Lazuli Ore"/><gatherable_template id="400358" name="Lapis Lazuli" nameId="715700" sourceType="JEWELRY" harvestCount="1" skillLevel="245" harvestSkill="30002" successAdj="100" failureAdj="100" aerialAdj="100"><material rate="9000000" nameid="1404081" itemid="152000309" name="Lapis Lazuli Ore"/><gatherable_template id="400601" name="Aria" nameId="701942" sourceType="HERB" harvestCount="3" skillLevel="1" harvestSkill="30001" successAdj="100" failureAdj="100" aerialAdj="100"><gatherable_template id="400562" name="Hoca" nameId="751125" sourceType="PLANT" harvestCount="3" skillLevel="470" harvestSkill="30002" successAdj="100" failureAdj="100" aerialAdj="100"><gatherable_template id="400651" name="Azpha" nameId="702092" sourceType="HERB" harvestCount="3" skillLevel="1" harvestSkill="30001" successAdj="100" failureAdj="100" aerialAdj="100"><gatherable_template id="400618" name="Zeldt" nameId="748602" sourceType="HERB" harvestCount="3" skillLevel="430" harvestSkill="30002" successAdj="100" failureAdj="100" aerialAdj="100"><gatherable_template id="400852" name="Porel" nameId="702112" sourceType="FISH" harvestCount="3" skillLevel="65" harvestSkill="30002" successAdj="100" failureAdj="100" aerialAdj="100"><gatherable_template id="400852" name="Blueta" nameId="702112" sourceType="FISH" harvestCount="3" skillLevel="65" harvestSkill="30002" successAdj="100" failureAdj="100" aerialAdj="100"><material rate="10000000" nameid="1404175" itemid="152000852" name="Porel"/><material rate="10000000" nameid="1404175" itemid="152000852" name="Blueta"/><gatherable_template id="400853" name="Porel" nameId="702112" sourceType="FISH" harvestCount="3" skillLevel="65" harvestSkill="30002" successAdj="100" failureAdj="100" aerialAdj="100"><gatherable_template id="400853" name="Blueta" nameId="702112" sourceType="FISH" harvestCount="3" skillLevel="65" harvestSkill="30002" successAdj="100" failureAdj="100" aerialAdj="100"><material rate="10000000" nameid="1404175" itemid="152000852" name="Porel"/><material rate="10000000" nameid="1404175" itemid="152000852" name="Blueta"/><material rate="500000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="500000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="500000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="500000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="500000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="500000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="1000000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="1000000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="1500000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="1500000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="2000000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="2000000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="500000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="500000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="500000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="500000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="1000000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="1000000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="1500000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="1500000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="2000000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="2000000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="500000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="500000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="1000000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="1000000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="1500000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="1500000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="500000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="500000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="1000000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="1000000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="1500000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="1500000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="500000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="500000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="500000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="500000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="500000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="500000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="500000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="500000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="1000000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="1000000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="1500000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="1500000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="2000000" nameid="1407899" itemid="152000903" name="High-Grade Aether Crystal"/><material rate="2000000" nameid="1407899" itemid="152000903" name="Greater Aether Crystal"/><material rate="500000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="500000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="500000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="500000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="1000000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="1000000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="1500000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="1500000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="2000000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="2000000" nameid="1407907" itemid="152000908" name="Greater Aether"/><material rate="500000" nameid="1407893" itemid="152000203" name="High-Grade Titanium Ore"/><material rate="500000" nameid="1407893" itemid="152000203" name="Greater Titanium Ore"/><material rate="500000" nameid="1407911" itemid="152000105" name="High-Grade Platinum Ore"/><material rate="500000" nameid="1407911" itemid="152000105" name="Greater Platinum Ore"/><material rate="9352000" nameid="1404111" itemid="152000107" name="Mithril Ore"/><material rate="8377000" nameid="1404111" itemid="152000107" name="Mithril Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="High-Grade Mithril Ore"/><material rate="500000" nameid="1407913" itemid="152000108" name="Greater Mithril Ore"/><material rate="25000" nameid="1488917" itemid="162000065" name="Mind Crystal"/><material rate="1000000" nameid="1488917" itemid="162000065" name="Mind Crystal"/><material rate="9353000" nameid="1404109" itemid="152000207" name="Orichalcum Ore"/><material rate="8378000" nameid="1404109" itemid="152000207" name="Orichalcum Ore"/><material rate="500000" nameid="1407897" itemid="152000208" name="High-Grade Orichalcum Ore"/><material rate="500000" nameid="1407897" itemid="152000208" name="Greater Orichalcum Ore"/><material rate="25000" nameid="1488915" itemid="162000064" name="Life Crystal"/><material rate="1000000" nameid="1488915" itemid="162000064" name="Life Crystal"/><material rate="500000" nameid="1407907" itemid="152000908" name="High-Grade Aether"/><material rate="500000" nameid="1407907" itemid="152000908" name="Greater Aether"/><xs:enumeration value="PC_ALL" /><xs:enumeration value="GOBLIN" /><xs:enumeration value="GENERAL" /><xs:enumeration value="NPC" />