Public feed #889506

Mine

public text v1 · immutable
Raw Edit
·published 2008-02-02 23:36 UTC
rendered paste body
INSERT INTO `creatureloot` (`entryid`,`itemid`,`percentchance`,`mincount`,`maxcount`) VALUES (3458,5026,50,1,1);
UPDATE `creatureloot` set `percentchance` = 50 WHERE itemid = 5026;
UPDATE `creatureloot` set `percentchance` = 50 WHERE itemid = 6652;
UPDATE `creatureloot` set `percentchance` = 75 WHERE itemid = 6640;
UPDATE `creatureloot` set `percentchance` = 75 WHERE itemid = 6634;
UPDATE `creatureloot` set `percentchance` = 50 WHERE itemid = 23744;
INSERT INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`) VALUES 
(5893, 1, -244.623, -4017.98, 187.304, 1.71895, 0, 2172, 15, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`) VALUES 
(5893, 1, -236.075, -4018.38, 187.304, 2.37425, 0, 2172, 91, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5893, 1, -253.083, -4020.82, 187.304, 0.925191, 0, 2172, 91, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5893, 1, -252.627, -4010.83, 187.291, 5.97137, 0, 2172, 91, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5893, 1, -236.866, -4008.16, 187.227, 3.77226, 0, 2172, 91, 256, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`) VALUES 
(5894, 0, 417.727, 1823.51, 12.4818, 0.834097, 0, 5493, 15, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`) VALUES 
(5894, 0, 397.419, 1827.36, 10.3968, 1.09956, 0, 5493, 15, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5894, 0, 406.073, 1818.3, 10.3026, 1.35874, 0, 5493, 15, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5894, 0, 418.938, 1835.96, 10.4415, 1.30376, 0, 5493, 15, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5894, 0, 425.997, 1830.39, 10.4651, 0.977822, 0, 5493, 15, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5894, 0, 429.731, 1818.89, 10.3836, 1.51975, 0, 5493, 15, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5894, 0, 422.285, 1813.8, 10.3846, 1.31161, 0, 5493, 15, 256, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gameobject_spawns`
  (Entry, map, position_x, position_y, position_z, Facing, orientation1, orientation2, orientation3, orientation4, State, Flags, Faction, Scale, stateNpcLink)
VALUES
  (101748, 0, 422.733, 1862.23, 9.5, 0, 0, 0, 0, 1, 1, 0, 0, 1, 0);
INSERT INTO `gameobject_spawns`
  (Entry, map, position_x, position_y, position_z, Facing, orientation1, orientation2, orientation3, orientation4, State, Flags, Faction, Scale, stateNpcLink)
VALUES
  (63674, 0, 422.733, 1862.23, 9.5, 0, 0, 0, 0, 1, 1, 0, 0, 1, 0);
UPDATE `creature_proto` SET `respawntime` = 120 , `auras` = 8203 , `money` = 0 WHERE `entry` = 5893 ;
UPDATE `creature_proto` SET `respawntime` = 120 , `auras` = 8203 , `money` = 0 WHERE `entry` = 5894 ;
UPDATE `creature_proto` SET `auras` = 8203 WHERE `entry` = 5891 ;
UPDATE `quests` SET `questlevel` = '22',`ReceiveItemId1` = '7766',`ReceiveItemCount1` = '1' WHERE `quests`.`entry` =1535 LIMIT 1 ;
UPDATE `quests` SET `questlevel` = '22',`ReceiveItemId1` = '7768',`ReceiveItemCount1` = '1' WHERE `quests`.`entry` =1536 LIMIT 1 ;
UPDATE `quests` SET `questlevel` = '23',`ReceiveItemId1` = '7767',`ReceiveItemCount1` = '1' WHERE `quests`.`entry` =1534 LIMIT 1 ;
UPDATE `quests` SET `questlevel` = '23',`ReceiveItemId1` = '7810',`ReceiveItemCount1` = '1' WHERE `quests`.`entry` =220 LIMIT 1 ;
UPDATE `quests` SET `questlevel` = '13',`ReceiveItemId1` = '0',`ReceiveItemCount1` = '0' WHERE `entry` =1527 LIMIT 1 ;
DELETE FROM `creature_quest_starter` WHERE `quest` = 972 ;
DELETE FROM `creature_quest_finisher` WHERE `quest` = 972 ;
DELETE FROM `gameobject_spawns` WHERE `entry` = 100035 ;