diff options
| -rw-r--r-- | data/sql/updates/world/2016_08_19_01.sql | 24 | ||||
| -rw-r--r-- | issue_template.md | 4 |
2 files changed, 27 insertions, 1 deletions
diff --git a/data/sql/updates/world/2016_08_19_01.sql b/data/sql/updates/world/2016_08_19_01.sql new file mode 100644 index 0000000000..80922332bc --- /dev/null +++ b/data/sql/updates/world/2016_08_19_01.sql @@ -0,0 +1,24 @@ +ALTER TABLE world_db_version CHANGE COLUMN 2016_08_19_00 2016_08_19_01 BIT; + +/* +Issue: Not work quest id 11543 #93 +Missing SAI for the correct execution of quest + +Create SAI for ending quest +*/ + +UPDATE creature_template SET AIName="SmartAI" WHERE entry IN (25090,25091,25092); +DELETE FROM smart_scripts WHERE entryorguid IN (25090,25091,25092) AND source_type=0; +INSERT INTO smart_scripts VALUES +(25090,0,0,0,8,0,100,0,45115,0,0,0,33,25090,0,0,0,0,0,7,0,0,0,0,0,0,0,"Sin'Loren - On spellhit 45115 - Kill Credit"), +(25091,0,0,0,8,0,100,0,45115,0,0,0,33,25091,0,0,0,0,0,7,0,0,0,0,0,0,0,"Bloodoath - On spellhit 45115 - Kill Credit"), +(25092,0,0,0,8,0,100,0,45115,0,0,0,33,25092,0,0,0,0,0,7,0,0,0,0,0,0,0,"Dawnchaser - On spellhit 45115 - Kill Credit"); + +/* +Backup for next DELETE query +INSERT INTO conditions VALUES +(15,9143,0,0,0,9,0,11542,0,0,0,0,0,,"Show gossip option if player has quest 11542 but not complete"), +(15,9143,0,0,1,9,0,11543,0,0,0,0,0,,"Show gossip option if player has quest 11543 but not complete"); +*/ + +DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup=9143;
\ No newline at end of file diff --git a/issue_template.md b/issue_template.md index b2c451e074..dcbdb28382 100644 --- a/issue_template.md +++ b/issue_template.md @@ -14,9 +14,11 @@ **AC hash/commit**: +**Operating system**: + **Modules**: Are you using modules? if yes, list them -**Operating system**: +**Other Customizations**: Are you use core/db patches or other customizations? If yes please specify them here. [//]: # (This template is for problem reports, for other type of reports edit it accordingly) |