Yemla Mythirians merchant fix (merchantitems)

Share files with other Dawn of Light users

Moderator: Support Team

Post a reply

Yemla Mythirians merchant fix (merchantitems)

Postby deathwish » Wed Feb 08, 2012 6:43 pm

Fixed Yemla Mythirians merchantitems.
Updated the scripts and also added a sql update for anyone thats already got the bugged pages in their database.

Download file contains the following:
Yemla Mythirians Scripts (.cs) - Fixed bugged pages
Update for merchantitems (.sql) - if you already have the items in your database.

if you just want the sql update for the merchantitems, heres the code:
Code: Select all
-- Update for Yemla Mythirian items
-- Fixed the merchantitems - By Deathwish 08/02/2012

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('54de8974-1953-4330-a605-52da45568abe', 'Mythirians', 'lesser_mythirian_of_health', 0, 0, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('361bf7c2-db44-4359-a02f-22bead4a4262', 'Mythirians', 'lesser_mythirian_of_power', 0, 1, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('9b58b150-a915-4aec-941f-d531ef10c4ba', 'Mythirians', 'lesser_mythirian_of_scathing', 0, 2, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('1f7c15ba-82e2-4f0c-a15e-53c5c83b4506', 'Mythirians', 'lesser_mythirian_of_focal', 0, 3, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('6b0c6d08-07ff-4c27-aad4-873b9543f75c', 'Mythirians', 'lesser_mythirian_of_deflection', 0, 4, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('8fc65c65-06bc-4f6a-92d5-317da5de7d50', 'Mythirians', 'lesser_mythirian_of_evasion', 0, 5, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('0c0112c2-206e-4d04-8547-793b74c6adea', 'Mythirians', 'lesser_mythirian_of_barricading', 0, 6, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('6fcdce4a-be74-43b0-a233-5ac2d5bf2f8e', 'Mythirians', 'lesser_mythirian_of_guerdon', 0, 7, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('bacfcfb5-4bb1-49f1-869c-37ca1ab63dd9', 'Mythirians', 'lesser_mythirian_of_siphoning', 0, 8, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('f09c6170-08ad-49e0-ad34-66e48889e504', 'Mythirians', 'lesser_adroit_mythirian', 0, 10, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('7bf1d911-0772-4855-ba3a-aa51e4b29dc9', 'Mythirians', 'lesser_insightful_mythirain', 0, 11, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('575f5d6f-66b1-458b-9ec1-990edf6ddd90', 'Mythirians', 'lesser_mighty_mythirian', 0, 12, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('9082eb4b-5f3a-4802-bbad-2653d3acacd5', 'Mythirians', 'lesser_speedy_mythirian', 0, 13, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('80ce6a23-7370-408e-beb1-e04480eb662f', 'Mythirians', 'lesser_tempered_mythirian', 0, 14, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('4bf40194-7d9e-4d39-88b1-fcf3ee626ea8', 'Mythirians', 'lesser_protection_mythirian', 0, 16, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('96d97beb-e200-4fe2-b4ba-fcac17701fec', 'Mythirians', 'reinforcing_bodybender_mythirian', 0, 17, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('d1cc5fb2-a079-4139-b462-7e797c908300', 'Mythirians', 'reinforcing_edgebender_mythirian', 0, 18, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('c868d4e1-5c24-4d8e-8c7a-4befe99b12b5', 'Mythirians', 'reinforcing_heatbender_mythirian', 0, 19, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('85cdd997-5c32-449c-a520-bec25725e57c', 'Mythirians', 'reinforcing_icebender_mythirian', 0, 20, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('574554e0-20b1-4b0e-9f0f-29afd3803254', 'Mythirians', 'reinforcing_matterbender_mythirian', 0, 21, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('48732949-e414-46ee-acbf-58fe4195d376', 'Mythirians', 'reinforcing_spiritbender_mythirian', 0, 22, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('28d41c4b-975c-49d3-b9c8-1e5fbb808ba3', 'Mythirians', 'lesser_warding_mythirian_of_essence', 0, 23, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('70678375-2ed5-43f1-a376-57eb4a6c852d', 'Mythirians', 'Average_mythirian_of_health', 1, 0, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('3fd02a75-beb6-4f8b-8538-d9cbb9b7154c', 'Mythirians', 'Average_mythirian_of_power', 1, 1, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('ee07dd1a-f82b-4062-8e77-001c398aa574', 'Mythirians', 'Average_mythirian_of_scathing', 1, 2, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('449448f5-fe59-4e26-9099-f998a121618c', 'Mythirians', 'lesser_mythirian_of_focal', 1, 3, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('275fd625-c341-40f9-803e-77704b6b1e0d', 'Mythirians', 'Average_mythirian_of_deflection', 1, 4, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('5f5f1734-125e-46a6-b8ba-959ba49889d3', 'Mythirians', 'Average_mythirian_of_evasion', 1, 5, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('2399344a-1ae8-4472-a56d-26ce5bcf48a4', 'Mythirians', 'Average_mythirian_of_barricading', 1, 6, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('ca553334-d34e-4b92-b269-4137acfb5250', 'Mythirians', 'Average_mythirian_of_guerdon', 1, 7, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('f3dee755-7205-4c15-ad83-3b8241992353', 'Mythirians', 'Average_mythirian_of_siphoning', 1, 8, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('e40645b8-f368-450a-b0de-be6172495e01', 'Mythirians', 'Average_adroit_mythirian', 1, 10, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('8af3af8e-9053-4bb1-96b5-7ef90a5a09d1', 'Mythirians', 'Average_insightful_mythirain', 1, 11, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('0f907ca6-d254-4c3e-8e7c-a4249c664133', 'Mythirians', 'Average_mighty_mythirian', 1, 12, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('99f55c55-329f-41f8-a5d5-90b22187862d', 'Mythirians', 'Average_speedy_mythirian', 1, 13, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('0e4fe012-ac8b-44be-ae57-edd2849ac94f', 'Mythirians', 'Average_tempered_mythirian', 1, 14, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('dd89d551-42c8-4f4f-8063-e5eed56e98c4', 'Mythirians', 'Average_protection_mythirian', 1, 16, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('c7b114d6-89f1-4a9c-89ed-d1c2017cacb4', 'Mythirians', 'protector\'s_bodybender_mythirian', 1, 17, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('5003d928-f35b-4845-9ce9-890ad9aaa7b9', 'Mythirians', 'protector\'s_edgebender_mythirian', 1, 18, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('df436fb2-fa5f-46bd-b97b-522eff9083de', 'Mythirians', 'protector\'s_heatbender_mythirian', 1, 19, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('6f54bb27-8175-4445-addd-b5228f523e4c', 'Mythirians', 'protector\'s_icebender_mythirian', 1, 20, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('df817aba-5c8e-4ce6-8b85-d31e1065a1ab', 'Mythirians', 'protector\'s_matterbender_mythirian', 1, 21, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('de9d6356-1bc5-49d5-b0a1-ce3b27fc975e', 'Mythirians', 'protector\'s_spiritbender_mythirian', 1, 22, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('6f7b3c64-8ec4-4d59-99e7-c2606161d722', 'Mythirians', 'Average_warding_mythirian_of_essence', 1, 23, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('3a8e376a-8dfb-4e4d-bb47-193933b87f3e', 'Mythirians', 'greater_mythirian_of_health', 3, 0, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('b352c805-ff46-40f3-b23c-1e889b0ce229', 'Mythirians', 'greater_mythirian_of_power', 3, 1, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('bdc9b116-0acd-449c-8461-91efaf65b269', 'Mythirians', 'mythirian_of_endurance', 3, 2, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('89d5de40-fac2-4d74-966f-6fde62992222', 'Mythirians', 'greater_mythirian_of_scathing', 3, 3, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('7c464ca2-8521-44e3-82bc-3efe4d11e77e', 'Mythirians', 'greater_mythirian_of_focal', 3, 4, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('5deddb62-e634-470d-8248-8b322cbdbf44', 'Mythirians', 'greater_mythirian_of_deflection', 3, 5, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('90eea0d7-52f9-4dc5-808d-eeb09df07e61', 'Mythirians', 'greater_mythirian_of_evasion', 3, 6, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('555012b3-0fa6-4a68-83b7-3c55fe68420b', 'Mythirians', 'greater_mythirian_of_barricading', 3, 7, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('a79957ec-db4c-46c1-8a09-6e968112a40f', 'Mythirians', 'greater_mythirian_of_guerdon', 3, 8, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('48d238f6-3ebf-4edc-b52d-3717a253a770', 'Mythirians', 'greater_mythirian_of_siphoning', 3, 9, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('6729581f-1462-44aa-8da6-03d85892a1f8', 'Mythirians', 'greater_adroit_mythirian', 3, 11, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('bd061312-0d9d-4e72-a458-86772b5f2be9', 'Mythirians', 'greater_insightful_mythirain', 3, 12, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('4a096d02-2ecf-4d1b-857e-c954a6c4d4ac', 'Mythirians', 'greater_mighty_mythirian', 3, 13, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('1829f95b-9ce4-4082-9af4-913a55b4668c', 'Mythirians', 'greater_speedy_mythirian', 3, 14, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('fc46cf5d-a01f-43f3-80b5-813098b3c948', 'Mythirians', 'greater_tempered_mythirian', 3, 15, NULL);

REPLACE INTO merchantitem
(`MerchantItem_ID`, `ItemListID`, `ItemTemplateID`, `PageNumber`, `SlotPosition`, `PackageID`)
VALUES
('caa38b73-db46-41ca-9f2f-6ca606a58ebe', 'Mythirians', 'greater_warding_mythirian_of_essence', 3, 16, NULL);
Attachments
Mythirians.rar
(6.93 KiB) Downloaded 332 times
- Terry - terryammon
User avatar
deathwish
Database Team
 
Posts: 483
Joined: Sun Jul 05, 2009 10:15 pm
Location: England / Essex
Top
Post a reply

Return to “%s” User Files

Who is online

Users browsing this forum: No registered users and 1 guest

Website by Etaew - © 2012 Dawn of Light - Powered by phpBB © 2011 phpBB Group

Artwork and screen shots Copyright © 2001-2004 Mythic Entertainment, Inc. All rights reserved. Used with permission of Mythic Entertainment. Mythic Entertainment, the Mythic Entertainment logo, "Dark Age of Camelot," "Shrouded Isles," "Foundations," "New Frontiers," "Trials of Atlantis," "Catacombs," "Darkness Rising," the Dark Age of Camelot and subsequent logos, and the stylized Celtic knot are trademarks of Mythic Entertainment, Inc.