Code:
REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "Flags1", "type", "family", "rank", "unk4", "spelldataid", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "civilian", "leader") VALUES
('50085','Weapon','Raid Tier VII','Vendor','0','4','0','3','0','0',18106,0,1,0,'1','0','0',0);
REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "Flags1", "type", "family", "rank", "unk4", "spelldataid", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "civilian", "leader") VALUES
('50083','Armor','Raid Tier VII','Vendor','0','4','0','3','0','0',18106,0,1,0,'1','0','0',0);
REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "mountdisplayid", "equipmodel1", "equipinfo1", "equipslot1", "equipmodel2", "equipinfo2", "equipslot2", "equipmodel3", "equipinfo3", "equipslot3", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags") VALUES
('50083','100','100','35','1000000','1000000','100000','1','4224','100',10000,'10000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','36000','5','0','0','0','0','0','0','1','1',' ','0',0,'0','0','2.5','8','14',0);
REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "mountdisplayid", "equipmodel1", "equipinfo1", "equipslot1", "equipmodel2", "equipinfo2", "equipslot2", "equipmodel3", "equipinfo3", "equipslot3", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags") VALUES
And Change to:
Code:
INSERT INTO `creature_names` VALUES ('50085','Weapon','Raid Tier VII','Vendor','0','4','0','3','0','0',18106,0,1,0,'1','0','0',0);
INSERT INTO `creature_names` VALUES ('50083','Armor','Raid Tier VII','Vendor','0','4','0','3','0','0',18106,0,1,0,'1','0','0',0);
INSERT INTO `creature_proto` VALUES ('50083','100','100','35','1000000','1000000','100000','1','4224','100',10000,'10000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','36000','5','0','0','0','0','0','0','1','1',' ','0',0,'0','0','2.5','8','14',0);
INSERT INTO `creature_proto` VALUES ('50085','100','100','35','1000000','1000000','100000','1','4224','100',10000,'10000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','36000','5','0','0','0','0','0','0','1','1',' ','0',0,'0','0','2.5','8','14',0);