How To ad the Zul'Aman items (Almost all ZA items)+ Amani war bear and flying machine menu

User Tag List

Results 1 to 3 of 3
  1. #1
    force's Avatar Member
    Reputation
    2
    Join Date
    Sep 2007
    Posts
    21
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How To ad the Zul'Aman items (Almost all ZA items)+ Amani war bear and flying machine

    How To Add The Zul'Aman items into your database!


    1.) Open a blank notepad and paste this into it:
    ##Venice
    /*!40000 ALTER TABLE `items` DISABLE KEYS*/;
    LOCK TABLES `items` WRITE;
    REPLACE INTO `items` (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, `ItemExtendedCost`, `ArenaRankRequirement`, `ReqDisenchantSkill`, `unk2`) VALUES (33478,2,8,-1,'Jin''rohk, The Great Apocalypse','Jin''rohk, The Great Apocalypse','Jin''rohk, The Great Apocalypse','Jin''rohk, The Great Apocalypse',47042,4,0,0,92937,17,-1,-1,164,70,0,0,0,0,0,0,0,0,1,0,7,49,28,45,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'380','5 70',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,3600,0,'0',40933,1,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,1,1,0,0,0, 0,120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,300,0),
    (33810,4,4,-1,'Amani Mask of Death','Amani Mask of Death','Amani Mask of Death','Amani Mask of Death',47019,4,0,0,0,1,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,4,46,7,51,16,33,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,1306,0,0,0,0,0,0,0,0,'0',0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,100,0 ,0,0,0,2,0,4,0,8,0,2882,0,2049,0,300,0),
    (33481,4,4,-1,'Pauldrons of Stone Resolve','Pauldrons of Stone Resolve','Pauldrons of Stone Resolve','Pauldrons of Stone Resolve',47003,4,0,0,65461,3,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,7,43,12,20,15,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0 ',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,1206,0,0,0,0,0,0,0,0,'0',28113,1,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0, 100,0,0,0,0,8,0,8,0,0,0,3017,0,0,0,300,0),
    (33299,4,4,-1,'Spaulders of the Advocate','Spaulders of the Advocate','Spaulders of the Advocate','Spaulders of the Advocate',46807,4,0,0,66444,3,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,7,21,5,28,21,21,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,1206,0,0,0,0,0,0,0,0,'0',18040,1,0,0, 0,0,21634,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0 ,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,300,0),
    (33328,4,3,-1,'Arrow-fall Chestguard','Arrow-fall Chestguard','Arrow-fall Chestguard','Arrow-fall Chestguard',46978,4,0,0,80691,5,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,3,39,7,25,5,38,28,30,6,0,0,0,0,0,0,0,0,0,0,0,'0','0 ',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,900,0,0,0,0,0,0,0,0,'0',15825,1,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,1 40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,300,0),
    (33533,4,3,-1,'Avalanche Leggings','Avalanche Leggings','Avalanche Leggings','Avalanche Leggings',47160,4,0,0,80412,7,-1,-1,128,0,0,0,0,0,0,0,0,0,1,0,7,31,5,40,21,30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0', 0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,787,0,0,0,0,0,0,0,0,'0',28264,1,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,105 ,0,0,0,0,2,0,4,0,8,0,2889,0,0,0,300,0),
    (33421,4,4,-1,'Battleworn Tuskguard','Battleworn Tuskguard','Battleworn Tuskguard','Battleworn Tuskguard',46987,4,0,0,73002,1,-1,-1,133,70,0,0,0,0,0,0,0,0,1,0,7,60,13,23,15,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0 ',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,1355,0,0,0,0,0,0,0,0,'0',35168,1,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0, 100,0,0,0,0,2,0,4,0,8,0,2961,0,0,0,300,0),
    (33211,4,2,-1,'Bladeangel''s Money Belt','Bladeangel''s Money Belt','Bladeangel''s Money Belt','Bladeangel''s Money Belt',46785,4,0,0,33146,6,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,3,25,7,27,19,21,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,227,0,0,0,0,0,0,0,0,'0',16815,1,0,0,0 ,0,39981,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0, 0,40,0,0,0,0,8,0,0,0,0,0,1583,0,0,0,300,0),
    (33453,4,1,-1,'Hood of Hexing','Hood of Hexing','Hood of Hexing','Hood of Hexing',45874,4,0,0,0,1,-1,-1,133,70,0,0,0,0,0,0,0,0,1,1,7,24,5,33,18,31,21,24,0,0,0,0,0,0,0,0,0,0,0,0,'0',' 0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,181,0,0,0,0,0,0,0,0,'0',23732,1,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0, 60,0,0,0,0,2,0,4,0,8,0,2889,0,0,0,300,0),
    (33463,4,1,-1,'Hood of the Third Eye','Hood of the Third Eye','Hood of the Third Eye','Hood of the Third Eye',45708,4,0,0,0,1,-1,-1,133,70,0,0,0,0,0,0,0,0,1,1,7,36,5,40,18,0,21,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,181,0,0,0,0,0,0,0,0,'0',26154,1,0,0,0 ,0,21638,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0, 0,60,0,0,0,0,2,0,4,0,8,0,2865,0,0,0,300,0),
    (33474,2,2,-1,'Ancient Sin''dorei Longbow','Ancient Sin''dorei Longbow','Ancient Sin''dorei Longbow','Ancient Sin''dorei Longbow',42220,4,0,0,101261,15,-1,-1,0,70,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'181','337',0 ,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,3000,0,'407',15808,1,0,0, 0,0,40680,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0 ,0,90,0,0,0,0,0,0,0,0,0,0,0,0,0,0,300,0),
    (33327,4,4,-1,'Mask of Introspection','Mask of Introspection','Mask of Introspection','Mask of Introspection',47070,4,0,0,73002,1,-1,-1,133,70,0,0,0,0,0,0,0,0,1,0,7,33,5,39,21,31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,1306,0,0,0,0,0,0,0,0,'0',36062,1,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,1 00,0,0,0,0,2,0,4,0,8,0,209,0,0,0,300,0),
    (33286,4,3,-1,'Mojo-mender''s Mask','Mojo-mender''s Mask','Mojo-mender''s Mask','Mojo-mender''s Mask',47037,4,0,0,0,1,-1,-1,133,70,0,0,0,0,0,0,0,0,1,1,7,34,5,38,18,0,21,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,731,0,0,0,0,0,0,0,0,'0',36098,1,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,85 ,0,0,0,0,2,0,4,0,8,0,2865,0,0,0,300,0),
    (33356,4,2,-1,'Helm of Natural Regeneration','Helm of Natural Regeneration','Helm of Natural Regeneration','Helm of Natural Regeneration',46983,4,0,0,0,1,-1,-1,133,70,0,0,0,0,0,0,0,0,1,1,7,33,5,39,6,30,21,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,328,0,0,0,0,0,0,0,0,'0',36062,1,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,70 ,0,0,0,0,2,0,4,0,8,0,209,0,0,0,300,0),
    (33479,4,2,-1,'Grimgrin Faceguard','Grimgrin Faceguard','Grimgrin Faceguard','Grimgrin Faceguard',46983,4,0,0,0,1,-1,-1,133,70,0,0,0,0,0,0,0,0,1,1,3,40,7,48,31,24,21,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0 ',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,328,0,0,0,0,0,0,0,0,'0',15827,1,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,7 0,0,0,0,0,2,0,4,0,8,0,1585,0,0,0,300,0),
    (33215,4,4,-1,'Bloodstained Elven Battlevest','Bloodstained Elven Battlevest','Bloodstained Elven Battlevest','Bloodstained Elven Battlevest',47020,4,0,0,0,5,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,4,46,7,69,19,35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,1607,0,0,0,0,0,0,0,0,'0',40679,1,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,0,300,0),
    (33432,4,3,-1,'Coif of the Jungle Stalker','Coif of the Jungle Stalker','Coif of the Jungle Stalker','Coif of the Jungle Stalker',47173,4,0,0,60691,1,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,3,36,7,40,5,35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0', 0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,759,0,0,0,0,0,0,0,0,'0',15821,1,0,0,0, 0,42098,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0 ,85,0,0,0,0,2,0,4,0,8,0,1585,0,0,0,300,0),
    (33972,4,2,-1,'Mask of Primal Power','Mask of Primal Power','Mask of Primal Power','Mask of Primal Power',46983,4,0,0,0,1,-1,-1,133,70,0,0,0,0,0,0,0,0,1,1,7,33,5,39,21,30,21,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0 ',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,328,0,0,0,0,0,0,0,0,'0',28264,1,0,0, 0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,7 0,0,0,0,0,2,0,4,0,8,0,2889,0,0,0,300,0),
    (33464,4,3,-1,'Hex Lord''s Voodoo Pauldrons','Hex Lord''s Voodoo Pauldrons','Hex Lord''s Voodoo Pauldrons','Hex Lord''s Voodoo Pauldrons',46990,4,0,0,0,3,-1,-1,133,70,0,0,0,0,0,0,0,0,1,1,7,17,5,30,30,30,21,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0 ',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,700,0,0,0,0,0,0,0,0,'0',18041,1,0,0, 0,0,21365,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0 ,0,70,0,0,0,0,0,0,0,0,0,0,0,0,0,0,300,0),
    (33283,2,4,-1,'Amani Punisher','Amani Punisher','Amani Punisher','Amani Punisher',46801,4,0,0,100968,21,-1,-1,132,70,0,0,0,0,0,0,0,0,1,0,7,30,5,21,18,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'20','1 13',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,1600,0,'0',44075,1,0 ,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,1,3,0,0,0, 0,105,0,0,0,0,0,0,0,0,0,0,0,0,0,0,300,0),
    (33214,2,7,-1,'Akil''zon''s Talonblade','Akil''zon''s Talonblade','Akil''zon''s Talonblade','Akil''zon''s Talonblade',46789,4,0,0,139081,13,-1,-1,141,70,0,0,0,0,0,0,0,0,1,0,7,25,28,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'100','1 87',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,1500,0,'0',15814,1,0 ,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,1,3,0,0,0, 0,105,0,0,0,0,0,0,0,0,0,0,0,0,0,0,300,0),
    (33467,2,7,-1,'Blade of Twisted Visions','Blade of Twisted Visions','Blade of Twisted Visions','Blade of Twisted Visions',46992,4,0,0,149931,21,-1,-1,132,70,0,0,0,0,0,0,0,1,1,0,5,22,30,29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'22','12 7',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,1800,0,'0',44075,1,0, 0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,1,3,0,0,0,0 ,105,0,0,0,0,0,0,0,0,0,0,0,0,0,0,300,0),
    (33514,4,4,-1,'Pauldrons of Gruesome Fate','Pauldrons of Gruesome Fate','Pauldrons of Gruesome Fate','Pauldrons of Gruesome Fate',47018,4,0,0,0,3,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,4,42,7,33,16,23,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,1206,0,0,0,0,0,0,0,0,'0',40555,1,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,1 00,0,0,0,0,0,0,0,0,0,0,0,0,2059,0,300,0),
    (33303,4,4,-1,'Skullshatter Warboots','Skullshatter Warboots','Skullshatter Warboots','Skullshatter Warboots',46810,4,0,0,79237,8,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,4,30,7,37,19,29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,1105,0,0,0,0,0,0,0,0,'0',0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,75,0, 0,0,0,2,0,8,0,0,0,2857,0,0,0,300,0),
    (33216,4,4,-1,'Chestguard of Hidden Purpose','Chestguard of Hidden Purpose','Chestguard of Hidden Purpose','Chestguard of Hidden Purpose',47028,4,0,0,94475,5,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,7,33,5,31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0 ,'0','0',0,'0','0',0,'0','0',0,'0','0',0,1607,0,0,0,0,0,0,0,0,'0',36062,1,0,0,0, 0,21644,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0 ,165,0,0,0,0,2,0,4,0,8,0,2366,0,0,0,300,0),
    (33326,4,6,-1,'Bulwark of the Amani Empire','Bulwark of the Amani Empire','Bulwark of the Amani Empire','Bulwark of the Amani Empire',46818,4,0,0,85458,14,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,7,42,15,19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0', 0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,5400,0,0,0,0,0,0,0,0,'0',39987,1,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,6,4,0,0,141,0, 120,0,0,0,0,2,0,0,0,0,0,2925,0,0,0,300,0),
    (33473,4,4,-1,'Chestguard of the Warlord','Chestguard of the Warlord','Chestguard of the Warlord','Chestguard of the Warlord',46998,4,0,0,94727,0,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,7,60,12,27,13,42,16,26,0,0,0,0,0,0,0,0,0,0,0,0,'0', '0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,1668,0,0,0,0,0,0,0,0,'0',0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,16 5,0,0,0,0,2,0,4,0,8,0,2868,0,0,0,300,0),
    (33592,4,1,-1,'Cloak of Ancient Rituals','Cloak of Ancient Rituals','Cloak of Ancient Rituals','Cloak of Ancient Rituals',42615,4,0,0,37194,16,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,7,22,5,20,30,25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,108,0,0,0,0,0,0,0,0,'0',18035,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,300,0),
    (33332,4,6,-1,'Enamelled Disc of Mojo','Enamelled Disc of Mojo','Enamelled Disc of Mojo','Enamelled Disc of Mojo',40862,4,0,0,79001,14,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,7,24,5,17,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0 ,'0','0',0,'0','0',0,'0','0',0,'0','0',0,5400,0,0,0,0,0,0,0,0,'0',18036,1,0,0,0, 0,21368,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,6,4,0,0,141 ,0,120,0,0,0,0,4,0,0,0,0,0,2363,0,0,0,300,0),
    (33357,4,1,-1,'Footpads of Madness','Footpads of Madness','Footpads of Madness','Footpads of Madness',41484,4,0,0,37012,8,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,7,25,5,22,30,25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,148,0,0,0,0,0,0,0,0,'0',33484,1,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,50 ,0,NULL,0,NULL,0,0,0,0,0,0,0,NULL,NULL,0,-1,0),
    (33285,4,1,-1,'Fury of the Ursine','Fury of the Ursine','Fury of the Ursine','Fury of the Ursine',42602,4,0,0,25932,9,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,7,12,5,17,6,16,21,17,0,0,0,0,0,0,0,0,0,0,0,0,'0','0 ',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,94,0,0,0,0,0,0,0,0,'0',13881,1,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,35 ,0,NULL,0,NULL,4,0,0,0,0,0,2953,NULL,NULL,0,-1,0),
    (33446,4,4,-1,'Girdle of Stromgarde''s Hope','Girdle of Stromgarde''s Hope','Girdle of Stromgarde''s Hope','Girdle of Stromgarde''s Hope',46989,4,0,0,43619,6,-1,-1,0,70,0,0,0,0,0,0,0,0,1,0,7,23,5,26,21,16,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0 ,'0','0',0,'0','0',0,'0','0',0,'0','0',0,904,0,0,0,0,0,0,0,0,'0',18047,1,0,0,0,0 ,21627,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0, 55,0,NULL,0,NULL,2,0,8,0,0,0,208,NULL,NULL,0,-1,0),
    (33469,4,3,-1,'Hauberk of the Empire''s Champion','Hauberk of the Empire''s Champion','Hauberk of the Empire''s Champion','Hauberk of the Empire''s Champion',46995,4,0,0,80013,5,-1,-1,133,70,0,0,0,0,0,0,0,0,1,0,7,30,5,40,30,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,934,0,0,0,0,0,0,0,0,'0',26225,1,0,0,0 ,0,21637,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0, 0,140,0,NULL,0,NULL,0,0,0,0,0,0,0,NULL,NULL,0,-1,0),
    (33206,4,3,-1,'Pauldrons of Primal Fury','Pauldrons of Primal Fury','Pauldrons of Primal Fury','Pauldrons of Primal Fury',47032,4,0,0,57303,3,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,3,28,7,30,16,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,475,0,0,0,0,0,0,0,0,'0',15815,1,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,85 ,0,NULL,0,NULL,4,0,2,0,0,0,2895,NULL,NULL,0,-1,0),
    (33317,4,1,-1,'Robe of Departed Spirits','Robe of Departed Spirits','Robe of Departed Spirits','Robe of Departed Spirits',42898,4,0,0,50333,20,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,7,34,5,31,30,35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,215,0,0,0,0,0,0,0,0,'0',34040,1,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,10 0,0,NULL,0,NULL,0,0,0,0,0,0,0,NULL,NULL,0,-1,0),
    (33203,4,1,-1,'Robes of Heavenly Purpose','Robes of Heavenly Purpose','Robes of Heavenly Purpose','Robes of Heavenly Purpose',47159,4,0,0,48289,20,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,7,21,5,23,6,45,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0', 0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,215,0,0,0,0,0,0,0,0,'0',31941,1,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,100 ,0,NULL,0,NULL,4,0,8,0,8,0,209,NULL,NULL,0,-1,0),
    (33329,4,2,-1,'Shadowtooth Trollskin Cuirass','Shadowtooth Trollskin Cuirass','Shadowtooth Trollskin Cuirass','Shadowtooth Trollskin Cuirass',46979,4,0,0,64782,5,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,3,45,7,46,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0 ,'0','0',0,'0','0',0,'0','0',0,'0','0',0,404,0,0,0,0,0,0,0,0,'0',15832,1,0,0,0,0 ,42113,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0, 120,0,NULL,0,NULL,0,0,0,0,0,0,0,NULL,NULL,0,-1,0),
    (33322,4,2,-1,'Shimmer-pelt Vest','Shimmer-pelt Vest','Shimmer-pelt Vest','Shimmer-pelt Vest',46813,4,0,0,42800,5,-1,-1,0,70,0,0,0,0,0,0,0,0,1,0,7,34,5,35,6,30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0, '0','0',0,'0','0',0,'0','0',0,'0','0',0,404,0,0,0,0,0,0,0,0,'0',31941,1,0,0,0,0, 21637,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,1 20,0,NULL,0,NULL,0,0,0,0,0,0,0,NULL,NULL,0,-1,0),
    (33300,4,2,-1,'Shoulderpads of Dancing Blades','Shoulderpads of Dancing Blades','Shoulderpads of Dancing Blades','Shoulderpads of Dancing Blades',46809,4,0,0,0,3,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,3,33,7,39,16,16,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0' ,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,303,0,0,0,0,0,0,0,0,'0',15819,1,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0,70 ,0,NULL,0,NULL,0,0,0,0,0,0,0,NULL,NULL,0,-1,0),
    (33471,4,1,-1,'Two-toed Sandals','Two-toed Sandals','Two-toed Sandals','Two-toed Sandals',46996,4,0,0,38338,8,-1,-1,128,70,0,0,0,0,0,0,0,0,1,0,7,33,5,30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0 ,'0','0',0,'0','0',0,'0','0',0,'0','0',0,154,0,0,0,0,0,0,0,0,'0',18041,1,0,0,0,0 ,21365,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0,0,0,0,0,0,0,0, 50,0,NULL,0,NULL,2,0,8,0,0,0,208,NULL,NULL,0,-1,0);
    UNLOCK TABLES;
    /*!40000 ALTER TABLE `items` ENABLE KEYS*/;

    And Right click File>save as> Zul'Aman Items.sql and you can now execute it into your database
    ________________________________________________________________________________ ________________________________________________________________________________ ________________________________ An here is the Amani war bear and The Flying Machine:
    insert into `items` values('33809','15','0','-1','Amani War Bear','Amani War Bear','Amani War Bear','Amani War Bear','37593','4','64','0','0','0','-1','-1','70','70','762','150','0','0','0','0','0','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','43 688','0','0','0','330','3000','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0','0','0','0','0','0','0','0','','0','0','0','0','0','-1','0','0','0','0','0','0','0',NULL,'0',NULL,NULL,'0',NULL,'0',NULL,'0',NULL,NUL L,NULL,'0','-1','0');

    insert into `creature_names` values('24379','Amani War Bear','','0','0','10','0','0','0',NULL,'22464','22462','0','0','1','1',NULL,NULL );

    insert into `creature_proto` values('24379','1','1','35','64','64','53','1.15','0','2000','3','3.87','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1', '1','0','0','2','0','0','2.5','8','14','0');


    insert into `creature_names` (`entry`, `name`, `subname`, `mouseFlags`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) values('24653','Flying Machine','','0','0','0','0','0','0',NULL,'22719','0','0','0','0','0',NULL,NULL);
    insert into `creature_names` (`entry`, `name`, `subname`, `mouseFlags`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) values('24654','Turbo-Charged Flying Machine','','0','0','0','0','0','0',NULL,'22720','0','0','0','0','0',NULL,NULL);
    insert into `items` (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, `ItemExtendedCost`, `ArenaRankRequirement`, `ReqDisenchantSkill`, `unk2`) values('34060','15','0','-1','Flying Machine Control','Flying Machine Control','Flying Machine Control','Flying Machine Control','47773','4','64','2000000','400000','0','-1','-1','70','70','202','350','0','0','0','0','7','1','1','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','44 153','0','0','0','330','3000','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0','0','0','0','0','0','0','1','Requires expert riding skill or higher to use.','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','-1','0');
    insert into `items` (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, `ItemExtendedCost`, `ArenaRankRequirement`, `ReqDisenchantSkill`, `unk2`) values('34061','15','0','-1','Turbo-Charged Flying Machine Control','Turbo-Charged Flying Machine Control','Turbo-Charged Flying Machine Control','Turbo-Charged Flying Machine Control','47774','4','64','2000000','400000','0','-1','-1','70','70','202','375','0','0','0','0','7','1','1','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','44 151','0','0','0','330','3000','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0','0','0','0','0','0','0','1','Requires artisan riding skill or higher to use.','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','-1','0');

    There ya go! Dont forget to +Rep

    Peace out
    -Force

    How To ad the Zul'Aman items (Almost all ZA items)+ Amani war bear and flying machine
  2. #2
    Saridormi's Avatar Contributor
    Reputation
    306
    Join Date
    Mar 2007
    Posts
    556
    Thanks G/R
    19/16
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: How To ad the Zul'Aman items (Almost all ZA items)+ Amani war bear and flying mac

    Nice... I was about to rep you.....

    Until I saw you asked.

    Please don't ask for rep


  3. #3
    gurpreet's Avatar Member
    Reputation
    5
    Join Date
    Sep 2007
    Posts
    95
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: How To ad the Zul'Aman items (Almost all ZA items)+ Amani war bear and flying mac

    not working for me says check mysql recourse or something

Similar Threads

  1. [Selling] Selling account with: spectral Tiger Amani war bear and lots of TCG Items
    By gynxz in forum WoW-US Account Buy Sell Trade
    Replies: 4
    Last Post: 06-13-2013, 12:51 AM
  2. [Trading] Lf anyone with the surname Kapkin that got some nice mounts, amani war bear, spectral
    By shizyo in forum World of Warcraft Buy Sell Trade
    Replies: 1
    Last Post: 09-25-2012, 04:12 PM
  3. Replies: 9
    Last Post: 12-27-2007, 12:52 AM
  4. Allmost All The Zul'Aman Item's!!
    By Summer in forum WoW EMU Guides & Tutorials
    Replies: 14
    Last Post: 12-24-2007, 03:30 PM
  5. [Armor Edit]Reskin To Almost All Availible Zul'Aman Items
    By Xcynic in forum World of Warcraft Model Editing
    Replies: 26
    Last Post: 10-30-2007, 06:53 PM
All times are GMT -5. The time now is 06:56 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search