Sturdy Crates can be created everywhere #2452

Closed
overy opened this Issue Jul 31, 2011 · 5 comments

Comments

Projects
None yet
5 participants
@overy

overy commented Jul 31, 2011

Sturdy Crates http://www.wowhead.com/item=36771 can be used everywhere

rev: 16a1435
TDB DB 41

@jasperrietrae

This comment has been minimized.

Show comment
Hide comment
@jasperrietrae

jasperrietrae Jul 31, 2011

Contributor

Woah. Amazing exploit.. =/

Contributor

jasperrietrae commented Jul 31, 2011

Woah. Amazing exploit.. =/

@Havenard

This comment has been minimized.

Show comment
Hide comment
@Havenard

Havenard Jul 31, 2011

Contributor

This SQL would make everyone cast 47431 on self when entering area 65 (Dragonblight), its definitively not a fix.

This is what would impose a condition to cast 47431 only at area 4195 (Ice Heart Cavern):

REPLACE INTOconditionsVALUES (17, 0, 47431, 0, 23, 4195, 0, 0, 64, '', 'Limit Capture Jormungar Spawn use to Ice Heart Cavern');

Contributor

Havenard commented Jul 31, 2011

This SQL would make everyone cast 47431 on self when entering area 65 (Dragonblight), its definitively not a fix.

This is what would impose a condition to cast 47431 only at area 4195 (Ice Heart Cavern):

REPLACE INTOconditionsVALUES (17, 0, 47431, 0, 23, 4195, 0, 0, 64, '', 'Limit Capture Jormungar Spawn use to Ice Heart Cavern');

@jasperrietrae

This comment has been minimized.

Show comment
Hide comment
@jasperrietrae

jasperrietrae Jul 31, 2011

Contributor

That's better, Havenard. :) Yeah, it was just a fast test. ^^

Contributor

jasperrietrae commented Jul 31, 2011

That's better, Havenard. :) Yeah, it was just a fast test. ^^

@ZxBiohazardZx

This comment has been minimized.

Show comment
Hide comment
@ZxBiohazardZx

ZxBiohazardZx Aug 12, 2011

Contributor

use delete and insert, looks good

Contributor

ZxBiohazardZx commented Aug 12, 2011

use delete and insert, looks good

@jasperrietrae

This comment has been minimized.

Show comment
Hide comment
@jasperrietrae

jasperrietrae Aug 12, 2011

Contributor
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=47431;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(17,0,47431,0,23,4195,0,0,64,'','Capture Jormungar Spawn can only be used in Ice Heart Cavern');
Contributor

jasperrietrae commented Aug 12, 2011

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=47431;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(17,0,47431,0,23,4195,0,0,64,'','Capture Jormungar Spawn can only be used in Ice Heart Cavern');

@DDuarte DDuarte closed this in 4e58efc Apr 1, 2012

DDuarte added a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014

DB/Conditions: Capture Jormungar Spawn can only be used in Ice Heart …
…Cavern

Fix by Discover and Havenard
Closes #2452
Also fix a typo in a previous commit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment