IMOS
11-24-2007, 08:36 PM
Make the dwarf located here:
x-6834.73 y-4157.1 z266.529
into a lv 90 boss that drops money and Tier VI
First delete your "1337" entry in your "creature_proto" table of your world DB, then
Query this into your DB:
#
# Insert statement for table: 'creature_proto' and all related tables (if specified inside the XML)
# ID: 1337
#-
INSERT INTO `creature_proto` ( `rangedmaxdamage`, `equipinfo3`, `equipinfo2`, `armor`, `equipinfo1`, `maxdamage`, `faction`, `mountdisplayid`, `death_state`, `minhealth`, `npcflags`, `equipmodel3`, `equipmodel2`, `equipmodel1`, `auras`, `attacktime`, `bounding_radius`, `mana`, `entry`, `scale`, `boss`, `minlevel`, `resistance6`, `combat_reach`, `resistance5`, `maxhealth`, `resistance4`, `resistance3`, `money`, `resistance2`, `resistance1`, `rangedmindamage`, `mindamage`, `maxlevel`, `rangedattacktime`, `respawntime`, `equipslot3`, `equipslot2`, `equipslot1`, `invisibility_type` ) VALUES ( '0.0', '0', '33490436', '9451', '33488898', '3547.0', '57', '0', '0', '35000', '0', '0', '45479', '45481', '0', '1710', '1.0', '0', '1337', '3.0', '1', '90', '0', '1.0', '0', '35000', '0', '0', '300000', '0', '0', '0.0', '641.0', '90', '0', '360000', '0', '32837', '32838', '0' );
Then this for the loot:
#
# Inserting new object inside table 'creatureloot'
# ID: 1337
#
INSERT INTO `creatureloot` ( `percentchance`, `mincount`, `maxcount`, `index`, `entryid`, `heroicpercentchance`, `itemid` ) VALUES ( '.6', '1', '1', '999991', '1337', '.3', '31068' );
#
# Insert statement for table: 'creatureloot' and all related tables (if specified inside the XML)
# ID: 1337
#-
INSERT INTO `creatureloot` ( `percentchance`, `mincount`, `maxcount`, `index`, `entryid`, `heroicpercentchance`, `itemid` ) VALUES ( '.6', '1', '1', '999992', '1337', '.3', '31063' );
#
# Insert statement for table: 'creatureloot' and all related tables (if specified inside the XML)
# ID: 1337
#-
INSERT INTO `creatureloot` ( `percentchance`, `mincount`, `maxcount`, `index`, `entryid`, `heroicpercentchance`, `itemid` ) VALUES ( '.6', '1', '1', '999993', '1337', '.3', '31060' );
#
# Insert statement for table: 'creatureloot' and all related tables (if specified inside the XML)
# ID: 1337
#-
INSERT INTO `creatureloot` ( `percentchance`, `mincount`, `maxcount`, `index`, `entryid`, `heroicpercentchance`, `itemid` ) VALUES ( '.6', '1', '1', '999994', '1337', '.3', '31069' );
#
# Insert statement for table: 'creatureloot' and all related tables (if specified inside the XML)
# ID: 1337
#-
INSERT INTO `creatureloot` ( `percentchance`, `mincount`, `maxcount`, `index`, `entryid`, `heroicpercentchance`, `itemid` ) VALUES ( '.6', '1', '1', '999995', '1337', '.3', '31066' );
Test and see what you get. :)
x-6834.73 y-4157.1 z266.529
into a lv 90 boss that drops money and Tier VI
First delete your "1337" entry in your "creature_proto" table of your world DB, then
Query this into your DB:
#
# Insert statement for table: 'creature_proto' and all related tables (if specified inside the XML)
# ID: 1337
#-
INSERT INTO `creature_proto` ( `rangedmaxdamage`, `equipinfo3`, `equipinfo2`, `armor`, `equipinfo1`, `maxdamage`, `faction`, `mountdisplayid`, `death_state`, `minhealth`, `npcflags`, `equipmodel3`, `equipmodel2`, `equipmodel1`, `auras`, `attacktime`, `bounding_radius`, `mana`, `entry`, `scale`, `boss`, `minlevel`, `resistance6`, `combat_reach`, `resistance5`, `maxhealth`, `resistance4`, `resistance3`, `money`, `resistance2`, `resistance1`, `rangedmindamage`, `mindamage`, `maxlevel`, `rangedattacktime`, `respawntime`, `equipslot3`, `equipslot2`, `equipslot1`, `invisibility_type` ) VALUES ( '0.0', '0', '33490436', '9451', '33488898', '3547.0', '57', '0', '0', '35000', '0', '0', '45479', '45481', '0', '1710', '1.0', '0', '1337', '3.0', '1', '90', '0', '1.0', '0', '35000', '0', '0', '300000', '0', '0', '0.0', '641.0', '90', '0', '360000', '0', '32837', '32838', '0' );
Then this for the loot:
#
# Inserting new object inside table 'creatureloot'
# ID: 1337
#
INSERT INTO `creatureloot` ( `percentchance`, `mincount`, `maxcount`, `index`, `entryid`, `heroicpercentchance`, `itemid` ) VALUES ( '.6', '1', '1', '999991', '1337', '.3', '31068' );
#
# Insert statement for table: 'creatureloot' and all related tables (if specified inside the XML)
# ID: 1337
#-
INSERT INTO `creatureloot` ( `percentchance`, `mincount`, `maxcount`, `index`, `entryid`, `heroicpercentchance`, `itemid` ) VALUES ( '.6', '1', '1', '999992', '1337', '.3', '31063' );
#
# Insert statement for table: 'creatureloot' and all related tables (if specified inside the XML)
# ID: 1337
#-
INSERT INTO `creatureloot` ( `percentchance`, `mincount`, `maxcount`, `index`, `entryid`, `heroicpercentchance`, `itemid` ) VALUES ( '.6', '1', '1', '999993', '1337', '.3', '31060' );
#
# Insert statement for table: 'creatureloot' and all related tables (if specified inside the XML)
# ID: 1337
#-
INSERT INTO `creatureloot` ( `percentchance`, `mincount`, `maxcount`, `index`, `entryid`, `heroicpercentchance`, `itemid` ) VALUES ( '.6', '1', '1', '999994', '1337', '.3', '31069' );
#
# Insert statement for table: 'creatureloot' and all related tables (if specified inside the XML)
# ID: 1337
#-
INSERT INTO `creatureloot` ( `percentchance`, `mincount`, `maxcount`, `index`, `entryid`, `heroicpercentchance`, `itemid` ) VALUES ( '.6', '1', '1', '999995', '1337', '.3', '31066' );
Test and see what you get. :)