eatos
07-30-2009, 05:45 PM
HI all i made Ulduar chests what bossess suppose to drop after we kill them and here how they look
And sql code just import that in db and set type to be looteble
INSERT INTO gameobject_names (`entry`,`Type`,`DisplayID`,`Name`,`Name2`,`Name3` ,`Name4`,`Category`,`CastBarText`,`UnkStr`,`Size`, `QuestItem1`,`QuestItem2`,`QuestItem3`,`QuestItem4 `,`spellfocus`,`sound1`,`sound2`,`sound3`,`sound4` ,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unk nown1`,`unknown2`,`unknown3`,`unknown4`,`unknown5` ,`unknown6`,`unknown7`,`unknown8`,`unknown9`,`unkn own10`,`unknown11`,`unknown12`,`unknown13`,`unknow n14`) VALUES ('200006','5','8627','ul_chest_lightning','','','' ,'','','','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');
INSERT INTO gameobject_names (`entry`,`Type`,`DisplayID`,`Name`,`Name2`,`Name3` ,`Name4`,`Category`,`CastBarText`,`UnkStr`,`Size`, `QuestItem1`,`QuestItem2`,`QuestItem3`,`QuestItem4 `,`spellfocus`,`sound1`,`sound2`,`sound3`,`sound4` ,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unk nown1`,`unknown2`,`unknown3`,`unknown4`,`unknown5` ,`unknown6`,`unknown7`,`unknown8`,`unknown9`,`unkn own10`,`unknown11`,`unknown12`,`unknown13`,`unknow n14`) VALUES ('200005','5','8685','ul_chest_plain','','','','', '','','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');
INSERT INTO gameobject_names (`entry`,`Type`,`DisplayID`,`Name`,`Name2`,`Name3` ,`Name4`,`Category`,`CastBarText`,`UnkStr`,`Size`, `QuestItem1`,`QuestItem2`,`QuestItem3`,`QuestItem4 `,`spellfocus`,`sound1`,`sound2`,`sound3`,`sound4` ,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unk nown1`,`unknown2`,`unknown3`,`unknown4`,`unknown5` ,`unknown6`,`unknown7`,`unknown8`,`unknown9`,`unkn own10`,`unknown11`,`unknown12`,`unknown13`,`unknow n14`) VALUES ('200007','5','8686','ul_chest_gears','','','','', '','','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');
INSERT INTO gameobject_names (`entry`,`Type`,`DisplayID`,`Name`,`Name2`,`Name3` ,`Name4`,`Category`,`CastBarText`,`UnkStr`,`Size`, `QuestItem1`,`QuestItem2`,`QuestItem3`,`QuestItem4 `,`spellfocus`,`sound1`,`sound2`,`sound3`,`sound4` ,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unk nown1`,`unknown2`,`unknown3`,`unknown4`,`unknown5` ,`unknown6`,`unknown7`,`unknown8`,`unknown9`,`unkn own10`,`unknown11`,`unknown12`,`unknown13`,`unknow n14`) VALUES ('200008','5','8628','ul_chest_leaf','','','','',' ','','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');
INSERT INTO gameobject_names (`entry`,`Type`,`DisplayID`,`Name`,`Name2`,`Name3` ,`Name4`,`Category`,`CastBarText`,`UnkStr`,`Size`, `QuestItem1`,`QuestItem2`,`QuestItem3`,`QuestItem4 `,`spellfocus`,`sound1`,`sound2`,`sound3`,`sound4` ,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unk nown1`,`unknown2`,`unknown3`,`unknown4`,`unknown5` ,`unknown6`,`unknown7`,`unknown8`,`unknown9`,`unkn own10`,`unknown11`,`unknown12`,`unknown13`,`unknow n14`) VALUES ('200009','5','8630','ul_chest_ice','','','','','' ,'','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');
And sql code just import that in db and set type to be looteble
INSERT INTO gameobject_names (`entry`,`Type`,`DisplayID`,`Name`,`Name2`,`Name3` ,`Name4`,`Category`,`CastBarText`,`UnkStr`,`Size`, `QuestItem1`,`QuestItem2`,`QuestItem3`,`QuestItem4 `,`spellfocus`,`sound1`,`sound2`,`sound3`,`sound4` ,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unk nown1`,`unknown2`,`unknown3`,`unknown4`,`unknown5` ,`unknown6`,`unknown7`,`unknown8`,`unknown9`,`unkn own10`,`unknown11`,`unknown12`,`unknown13`,`unknow n14`) VALUES ('200006','5','8627','ul_chest_lightning','','','' ,'','','','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');
INSERT INTO gameobject_names (`entry`,`Type`,`DisplayID`,`Name`,`Name2`,`Name3` ,`Name4`,`Category`,`CastBarText`,`UnkStr`,`Size`, `QuestItem1`,`QuestItem2`,`QuestItem3`,`QuestItem4 `,`spellfocus`,`sound1`,`sound2`,`sound3`,`sound4` ,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unk nown1`,`unknown2`,`unknown3`,`unknown4`,`unknown5` ,`unknown6`,`unknown7`,`unknown8`,`unknown9`,`unkn own10`,`unknown11`,`unknown12`,`unknown13`,`unknow n14`) VALUES ('200005','5','8685','ul_chest_plain','','','','', '','','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');
INSERT INTO gameobject_names (`entry`,`Type`,`DisplayID`,`Name`,`Name2`,`Name3` ,`Name4`,`Category`,`CastBarText`,`UnkStr`,`Size`, `QuestItem1`,`QuestItem2`,`QuestItem3`,`QuestItem4 `,`spellfocus`,`sound1`,`sound2`,`sound3`,`sound4` ,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unk nown1`,`unknown2`,`unknown3`,`unknown4`,`unknown5` ,`unknown6`,`unknown7`,`unknown8`,`unknown9`,`unkn own10`,`unknown11`,`unknown12`,`unknown13`,`unknow n14`) VALUES ('200007','5','8686','ul_chest_gears','','','','', '','','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');
INSERT INTO gameobject_names (`entry`,`Type`,`DisplayID`,`Name`,`Name2`,`Name3` ,`Name4`,`Category`,`CastBarText`,`UnkStr`,`Size`, `QuestItem1`,`QuestItem2`,`QuestItem3`,`QuestItem4 `,`spellfocus`,`sound1`,`sound2`,`sound3`,`sound4` ,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unk nown1`,`unknown2`,`unknown3`,`unknown4`,`unknown5` ,`unknown6`,`unknown7`,`unknown8`,`unknown9`,`unkn own10`,`unknown11`,`unknown12`,`unknown13`,`unknow n14`) VALUES ('200008','5','8628','ul_chest_leaf','','','','',' ','','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');
INSERT INTO gameobject_names (`entry`,`Type`,`DisplayID`,`Name`,`Name2`,`Name3` ,`Name4`,`Category`,`CastBarText`,`UnkStr`,`Size`, `QuestItem1`,`QuestItem2`,`QuestItem3`,`QuestItem4 `,`spellfocus`,`sound1`,`sound2`,`sound3`,`sound4` ,`sound5`,`sound6`,`sound7`,`sound8`,`sound9`,`unk nown1`,`unknown2`,`unknown3`,`unknown4`,`unknown5` ,`unknown6`,`unknown7`,`unknown8`,`unknown9`,`unkn own10`,`unknown11`,`unknown12`,`unknown13`,`unknow n14`) VALUES ('200009','5','8630','ul_chest_ice','','','','','' ,'','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');