Jump to content
  • Ammo for Rumbleshot Script on Quest Complete


    Arkadus
    • Status: In Progress
      Main Category: Quests
      Sub-Category: Quest
      Version: 0.20 Milestone: 20 Priority: New
      Implemented Version: 0.20

    As title describes

    UPDATE `creature_template`
    SET `FactionHorde` = 55, `FactionAlliance` = 55
    WHERE `Entry` = 15436 AND `Entry` = 12385;

    UPDATE `creature_movement_template`
    SET `waittime` = 450000
    WHERE `entry` = 10610 AND `point` = 1;

    UPDATE `creature_movement_template`
    SET `waittime` = 450000
    WHERE `entry` = 10610 AND `point` = 7;

    UPDATE `creature_movement_template`
    SET `waittime` = 10000
    WHERE `entry` = 10610 AND `point` = 5;

    REPLACE INTO `dbscripts_on_quest_end` (`id`,`delay`,`command`,`datalong`,`datalong2`,`buddy_entry`,`search_radius`,`data_flags`,`dataint`,`dataint2`,`dataint3`,`dataint4`,`x`,`y`,`z`,`o`,`comments`)
    VALUES
    (7811,0,21,1,0,10610,269,16,0,0,0,0,0,0,0,0,'Angus - active'),
    (7811,0,21,1,0,10805,272,16,0,0,0,0,0,0,0,0,'Klemmy - active'),
    (7811,0,21,1,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty - active'),
    (7811,1,21,1,0,10803,266,16,0,0,0,0,0,0,0,0,'Wheeler - active'),
    (7811,1,21,1,0,10804,268,16,0,0,0,0,0,0,0,0,'Middlecamp - active'),
    (7811,2,25,1,0,10805,272,16,0,0,0,0,0,0,0,0,'RUN ON'),
    (7811,3,16,6598,2,0,0,0,0,0,0,0,0,0,0,0,'sound'),
    (7811,3,3,0,0,10610,269,16,0,0,0,0,-6031.16,-230.264,414.361,2.18492,'Angus'),
    (7811,4,3,0,0,10611,267,16,0,0,0,0,-6031.59,-228.182,414.404,2,'Shorty'),
    (7811,4,3,0,0,10804,268,16,0,0,0,0,-6034.14,-223.333,413.4,1,'Middlecamp'),
    (7811,4,3,0,0,10805,272,16,0,0,0,0,-6011.17,-197.021,406.765,1.97737,'Klemmy'),
    (7811,4,3,0,0,10803,266,16,0,0,0,0,-6011.87,-199.241,406.834,4.31443,'Wheeler'),
    (7811,5,3,0,0,10805,272,16,0,0,0,0,-6015.51,-184.362,407.712,2.49704,'Klemmy'),
    (7811,7,3,0,0,10805,272,16,0,0,0,0,-6065.18,-201.938,424.419,5,'Klemmy'),
    (7811,6,3,0,0,10803,266,16,0,0,0,0,-6031.93,-221.088,413.153,2.44346,'Wheeler'),
    (7811,17,3,0,0,10805,272,16,0,0,0,0,0,0,0,5.59936,'Klemmy'),
    (7811,19,3,0,0,10611,267,16,0,0,0,0,0,0,0,2.18492,'Shorty'),
    (7811,20,3,0,0,10803,266,16,0,0,0,0,0,0,0,2.44346,'Wheeler'),
    (7811,20,3,0,0,10804,268,16,0,0,0,0,0,0,0,1.88496,'Middlecamp'),
    (7811,20,3,0,0,10610,269,16,0,0,0,0,0,0,0,2,'angus'),
    (7811,24,3,0,0,1243,265,16,0,0,0,0,0,0,0,3.68522,'Hegnar'),
    (7811,31,0,0,0,10804,268,23,2000005730,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,34,15,16768,0,10804,268,23,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,36,0,0,0,10804,268,23,2000005731,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,40,0,0,0,10804,268,23,2000005732,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,42,15,16772,0,10804,268,23,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,44,0,0,0,10804,268,23,2000005733,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,46,3,0,0,10804,268,16,0,0,0,0,0,0,0,0.810652,'Middlecamp'),
    (7811,47,1,5,0,10804,268,16,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,47,1,11,0,10803,266,16,0,0,0,0,0,0,0,0,'Wheeler'),
    (7811,48,1,274,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,48,1,274,0,10610,269,16,0,0,0,0,0,0,0,0,''),
    (7811,49,3,0,0,10804,268,16,0,0,0,0,0,0,0,1.88496,'Middlecamp'),
    (7811,50,0,0,0,10803,266,23,2000005734,0,0,0,0,0,0,0,'Wheeler'),
    (7811,54,15,16767,0,10803,266,23,0,0,0,0,0,0,0,0,'Wheeler'),
    (7811,56,0,0,0,10803,266,23,2000005735,0,0,0,0,0,0,0,'Wheeler'),
    (7811,58,3,0,0,10803,266,16,0,0,0,0,0,0,0,4.00565,'Wheeler'),
    (7811,59,1,25,0,10803,266,16,0,0,0,0,0,0,0,0,'Wheeler'),
    (7811,59,16,6249,2,10803,266,16,0,0,0,0,0,0,0,0,'sound'),
    (7811,61,1,21,0,10610,269,16,0,0,0,0,0,0,0,0,''),
    (7811,62,1,21,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,62,1,23,0,10803,266,16,0,0,0,0,0,0,0,0,'Wheeler'),
    (7811,64,3,0,0,10803,266,16,0,0,0,0,0,0,0,2.44346,'Wheeler'),
    (7811,67,0,0,0,10804,268,23,2000005736,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,69,15,16777,0,10804,268,23,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,71,0,0,0,10804,268,23,2000005737,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,73,1,20,0,10804,268,16,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,73,3,0,0,10803,266,16,0,0,0,0,0,0,0,4.00565,'Wheeler'),
    (7811,74,1,6,0,10803,266,16,0,0,0,0,0,0,0,0,'Wheeler'),
    (7811,74,16,6248,2,10803,266,16,0,0,0,0,0,0,0,0,'sound'),
    (7811,77,3,0,0,10803,266,16,0,0,0,0,0,0,0,2.44346,'Wheeler'),
    (7811,77,0,0,0,10804,268,23,2000005738,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,79,15,16780,0,10804,268,23,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,81,0,0,0,10804,268,23,2000005739,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,83,0,0,0,10803,266,23,2000005740,0,0,0,0,0,0,0,'Wheeler'),
    (7811,83,15,16775,0,10803,266,23,0,0,0,0,0,0,0,0,'Wheeler'),
    (7811,85,0,0,0,10803,266,23,2000005741,0,0,0,0,0,0,0,'Wheeler'),
    (7811,87,15,16778,0,10803,266,23,0,0,0,0,0,0,0,0,'Wheeler'),
    (7811,89,0,0,0,10803,266,23,2000005742,0,0,0,0,0,0,0,'Wheeler'),
    (7811,91,3,0,0,10803,266,16,0,0,0,0,0,0,0,4.00565,'Wheeler'),
    (7811,91,1,5,0,10803,266,16,0,0,0,0,0,0,0,0,'Wheeler'),
    (7811,91,3,0,0,10804,268,16,0,0,0,0,0,0,0,0.810652,'Middlecamp'),
    (7811,93,1,25,0,10804,268,16,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,95,1,11,0,10804,268,16,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,98,3,0,0,10804,268,16,0,0,0,0,0,0,0,1.88496,'Middlecamp'),
    (7811,98,3,0,0,10803,266,16,0,0,0,0,0,0,0,2.44346,'Wheeler'),
    (7811,100,0,0,0,10804,268,23,2000005743,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,100,16,6250,2,10804,268,23,0,0,0,0,0,0,0,0,'sound'),
    (7811,100,15,16572,0,10804,268,23,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,103,0,0,0,10804,268,23,2000005744,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,103,16,6250,2,10804,268,23,0,0,0,0,0,0,0,0,'sound'),
    (7811,103,15,16776,0,10804,268,23,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,106,0,0,0,10804,268,23,2000005745,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,106,16,6250,2,10804,268,23,0,0,0,0,0,0,0,0,'sound'),
    (7811,106,15,16779,0,10804,268,23,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,109,1,71,0,10804,268,16,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,109,16,6246,2,10804,268,23,0,0,0,0,0,0,0,0,'sound'),
    (7811,113,3,0,0,10804,268,16,0,0,0,0,0,0,0,0.810652,'Middlecamp'),
    (7811,114,3,0,0,10803,266,16,0,0,0,0,0,0,0,4.00565,'Wheeler'),
    (7811,115,1,2,0,10804,268,16,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,115,1,21,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,115,1,21,0,10610,269,16,0,0,0,0,0,0,0,0,''),
    (7811,115,1,21,0,10803,266,16,0,0,0,0,0,0,0,0,'Wheeler'),
    (7811,119,3,0,0,10804,268,16,0,0,0,0,0,0,0,5.13852,'Middlecamp'),
    (7811,119,3,0,0,10803,266,16,0,0,0,0,0,0,0,4.77803,'Wheeler'),
    (7811,119,3,0,0,10611,267,16,0,0,0,0,0,0,0,2.84489,'Shorty'),
    (7811,119,3,0,0,10610,269,16,0,0,0,0,0,0,0,2.84489,''),
    (7811,120,25,0,0,10805,272,16,0,0,0,0,0,0,0,0,'RUN OFF'),
    (7811,121,1,4,0,10610,269,16,0,0,0,0,0,0,0,0,''),
    (7811,121,1,4,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,121,16,6256,2,0,0,0,0,0,0,0,0,0,0,0,''),
    (7811,121,3,0,0,10805,272,16,0,0,0,0,-6077.43,-213.257,424.05,5.59936,'Klemmy'),
    (7811,131,10,11875,180000,0,0,0,0,0,0,0,-6076,-215,424,0,'summon 1st Mortar Team Target Dummy'),
    (7811,132,25,1,0,10805,272,16,0,0,0,0,0,0,0,0,'RUN ON'),
    (7811,134,3,0,0,10805,272,16,0,0,0,0,-6065.9,-202.298,424.369,5,'Klemmy'),
    (7811,137,3,0,0,10805,272,16,0,0,0,0,0,0,0,5.59936,'Klemmy'),
    (7811,139,1,3,0,10805,272,16,0,0,0,0,0,0,0,0,'Klemmy'),
    (7811,141,3,0,0,10611,267,16,0,0,0,0,0,0,0,4.54215,'Shorty'),
    (7811,142,3,0,0,10805,272,16,0,0,0,0,0,0,0,4.0985,'Klemmy'),
    (7811,142,1,16,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,143,1,69,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,148,1,0,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,150,3,0,0,10611,267,16,0,0,0,0,0,0,0,2.84489,'Shorty'),
    (7811,151,3,0,0,10804,268,16,0,0,0,0,0,0,0,2.9147,'Middlecamp'),
    (7811,151,3,0,0,10803,266,16,0,0,0,0,0,0,0,3.01942,'Wheeler'),
    (7811,151,1,25,0,10610,269,16,0,0,0,0,0,0,0,0,''),
    (7811,152,15,18655,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,154,16,7316,2,0,0,0,0,0,0,0,0,0,0,0,'sound'),
    (7811,156,15,16786,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,156,15,5,0,11875,100,7,0,0,0,0,0,0,0,0,''),
    (7811,159,1,17,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,160,25,0,0,10805,272,16,0,0,0,0,0,0,0,0,'RUN OFF'),
    (7811,162,3,0,0,10611,267,16,0,0,0,0,0,0,0,4.54215,'Shorty'),
    (7811,162,3,0,0,10805,272,16,0,0,0,0,-6077.43,-213.257,424.05,5.59936,'Klemmy'),
    (7811,163,1,1,0,10610,269,16,0,0,0,0,0,0,0,0,''),
    (7811,163,16,6252,2,0,0,0,0,0,0,0,0,0,0,0,''),
    (7811,164,1,4,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,167,3,0,0,10611,267,16,0,0,0,0,0,0,0,2.84489,'Shorty'),
    (7811,172,10,11875,180000,0,0,0,0,0,0,0,-6076,-215,424,0,'summon 2nd Mortar Team Target Dummy'),
    (7811,174,3,0,0,10805,272,16,0,0,0,0,-6071.88,-212.831,422.929,5,'Klemmy'),
    (7811,176,3,0,0,10805,272,16,0,0,0,0,0,0,0,6.04228,'Klemmy'),
    (7811,177,25,1,0,10805,272,16,0,0,0,0,0,0,0,0,'RUN ON'),
    (7811,178,1,66,0,10805,272,16,0,0,0,0,0,0,0,0,'Klemmy'),
    (7811,178,3,0,0,10611,267,16,0,0,0,0,0,0,0,4.54215,'Shorty'),
    (7811,180,3,0,0,10805,272,16,0,0,0,0,-6065.9,-202.298,424.369,5,'Klemmy'),
    (7811,180,28,8,0,10611,267,16,0,0,0,0,0,0,0,0,'STATE_KNEEL'),
    (7811,182,16,6254,2,0,0,0,0,0,0,0,0,0,0,0,''),
    (7811,183,3,0,0,10805,272,16,0,0,0,0,0,0,0,4.0985,'Klemmy'),
    (7811,187,28,0,0,10611,267,16,0,0,0,0,0,0,0,0,'STATE_STAND'),
    (7811,188,3,0,0,10611,267,16,0,0,0,0,0,0,0,2.84489,'Shorty'),
    (7811,189,1,25,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,189,16,6255,2,0,0,0,0,0,0,0,0,0,0,0,''),
    (7811,190,15,18655,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,191,16,7316,2,0,0,0,0,0,0,0,0,0,0,0,'sound'),
    (7811,192,15,16786,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,192,15,5,0,11875,100,7,0,0,0,0,0,0,0,0,''),
    (7811,193,3,0,0,10611,267,16,0,0,0,0,0,0,0,4.54215,'Shorty'),
    (7811,193,25,0,0,10805,272,16,0,0,0,0,0,0,0,0,'RUN OFF'),
    (7811,194,1,25,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,194,16,6251,2,0,0,0,0,0,0,0,0,0,0,0,'sound'),
    (7811,195,3,0,0,10804,268,16,0,0,0,0,0,0,0,5.13852,'Middlecamp'),
    (7811,195,3,0,0,10805,272,16,0,0,0,0,-6077.43,-213.257,424.05,5.59936,'Klemmy'),
    (7811,196,1,21,0,10804,268,16,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,196,3,0,0,10803,266,16,0,0,0,0,0,0,0,4.77803,'Wheeler'),
    (7811,197,3,0,0,10611,267,16,0,0,0,0,0,0,0,2.84489,'Shorty'),
    (7811,197,1,4,0,10803,266,16,0,0,0,0,0,0,0,0,'Wheeler'),
    (7811,204,10,12385,180000,0,0,0,0,0,0,0,-6076,-215,424,0,'summon Mortar Team Advanced Target Dummy'),
    (7811,205,3,0,0,10805,272,16,0,0,0,0,-6071.88,-212.831,422.929,5,'Klemmy'),
    (7811,208,3,0,0,10805,272,16,0,0,0,0,0,0,0,6.04228,'Klemmy'),
    (7811,210,15,18655,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,207,1,25,0,10805,272,16,0,0,0,0,0,0,0,0,'Klemmy'),
    (7811,208,1,11,0,10805,272,16,0,0,0,0,0,0,0,0,'Klemmy'),
    (7811,211,1,15,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,211,1,5,0,10610,269,16,0,0,0,0,0,0,0,0,''),
    (7811,212,16,6258,2,0,0,0,0,0,0,0,0,0,0,0,'sound'),
    (7811,210,25,1,0,10805,272,16,0,0,0,0,0,0,0,0,'RUN ON'),
    (7811,213,16,7316,2,0,0,0,0,0,0,0,0,0,0,0,'sound'),
    (7811,215,3,0,0,10804,268,16,0,0,0,0,0,0,0,2.9147,'Middlecamp'),
    (7811,215,3,0,0,10803,266,16,0,0,0,0,0,0,0,3.01942,'Wheeler'),
    (7811,210,3,0,0,10805,272,16,0,0,0,0,-6064.07,-209.851,421.98,6.10275,'Klemmy'),
    (7811,214,15,16786,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,214,15,5,0,12385,100,7,0,0,0,0,0,0,0,0,''),
    (7811,215,1,10,0,10610,269,16,0,0,0,0,0,0,0,0,''),
    (7811,215,1,10,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,215,3,0,0,10805,272,16,0,0,0,0,-6061.97,-218.956,421.085,5.92054,'Klemmy'),
    (7811,219,3,0,0,10805,272,16,0,0,0,0,-6040.96,-221.929,414.921,5.92054,'Klemmy'),
    (7811,229,1,14,0,10805,272,16,0,0,0,0,0,0,0,0,'Klemmy'),
    (7811,229,1,0,0,10610,269,16,0,0,0,0,0,0,0,0,''),
    (7811,229,1,0,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,230,1,11,0,10610,269,16,0,0,0,0,0,0,0,0,''),
    (7811,230,1,11,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,231,1,11,0,10804,268,16,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,231,1,11,0,10803,266,16,0,0,0,0,0,0,0,0,'Wheeler'),
    (7811,231,1,14,0,10805,272,16,0,0,0,0,0,0,0,0,'Klemmy'),
    (7811,232,1,11,0,10610,269,16,0,0,0,0,0,0,0,0,''),
    (7811,232,1,11,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty'),
    (7811,233,1,11,0,10804,268,16,0,0,0,0,0,0,0,0,'Middlecamp'),
    (7811,233,1,11,0,10803,266,16,0,0,0,0,0,0,0,0,'Wheeler'),
    (7811,236,3,0,0,10805,272,16,0,0,0,0,-6007.3,-200.348,406.777,3.28222,'Klemmy'),
    (7811,236,3,0,0,10611,267,16,0,0,0,0,-6007.46,-202.158,407.448,2,'Shorty'),
    (7811,237,3,0,0,10610,269,16,0,0,0,0,-6009.25,-202.65,406.983,2,'angus'),
    (7811,237,3,0,0,10804,268,16,0,0,0,0,-6010.67,-199.434,406.792,5.53269,'Middlecamp'),
    (7811,237,3,0,0,10803,266,16,0,0,0,0,-6008.53,-199.145,406.687,4.37218,'Wheeler'),
    (7811,256,3,0,0,10805,272,16,0,0,0,0,0,0,0,3.28222,'Klemmy'),
    (7811,254,3,0,0,10803,266,16,0,0,0,0,0,0,0,4.37218,'Wheeler'),
    (7811,254,3,0,0,10610,269,16,0,0,0,0,0,0,0,1.58825,'angus'),
    (7811,259,3,0,0,10804,268,16,0,0,0,0,0,0,0,5.53269,'Middlecamp'),
    (7811,260,3,0,0,1243,265,16,0,0,0,0,0,0,0,0.0349066,'Hegnar'),
    (7811,260,3,0,0,10611,267,16,0,0,0,0,0,0,0,2.47837,'Shorty'),
    (7811,270,21,0,0,10610,269,16,0,0,0,0,0,0,0,0,'Angus - unactive'),
    (7811,270,21,0,0,10805,272,16,0,0,0,0,0,0,0,0,'Klemmy - unactive'),
    (7811,270,21,0,0,10611,267,16,0,0,0,0,0,0,0,0,'Shorty - unactive'),
    (7811,270,21,0,0,10803,266,16,0,0,0,0,0,0,0,0,'Wheeler - unactive'),
    (7811,270,21,0,0,10804,268,16,0,0,0,0,0,0,0,0,'Middlecamp - unactive');

    UPDATE `quest_template`
    SET `CompleteScript` = 7811
    WHERE `entry` = 5541;


    User Feedback

    Recommended Comments

    FYI i made a mistake with the SQL update with:

    UPDATE `creature_template`
    SET `FactionHorde` = 55, `FactionAlliance` = 55
    WHERE `Entry` = 15436 AND `Entry` = 12385;


    is actually supposed to have "OR" instead of "AND" this is for the target dumies so you cant attack them and they still get destroyed by the mortar,
    this was my fault:

    UPDATE `creature_template`
    SET `FactionHorde` = 55, `FactionAlliance` = 55
    WHERE `Entry` = 15436 OR `Entry` = 12385;

    Link to comment
    Share on other sites

    Right, Arkadus, you'd better assume the position... a rubber duck thrashing for you, me laddie :D

    -----------------------------------------------------------

    No worries, will create a Pull Request for that now :)

    FIX committed: [url]https://github.com/mangoszero/database/pull/191[/url]
    All is well :D

    And merged!! [url]https://github.com/mangoszero/database/pull/191#event-218274871[/url]

    Blimey, that Antz does not hang around!!!

    Link to comment
    Share on other sites



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use