diff options
| author | Lopin <davca.hr@seznam.cz> | 2011-06-20 17:47:20 +0200 |
|---|---|---|
| committer | Lopin <davca.hr@seznam.cz> | 2011-06-20 17:47:20 +0200 |
| commit | 2df209eb79747919f51df1132b1f4faffbfee2e7 (patch) | |
| tree | 5b1a34360383bdd3e232db6055a7238c3fe85d6c | |
| parent | 77afbeb84e18ceb6c3f2912f468f0449a5c7b7bb (diff) | |
DB/SQL: Better queries deletion, thanks Dasio for pointing it out
3 files changed, 3 insertions, 3 deletions
diff --git a/sql/updates/world/2011_06_20_01_world_achievement_criteria_data.sql b/sql/updates/world/2011_06_20_01_world_achievement_criteria_data.sql index 88202e26061..d13b65d98f3 100644 --- a/sql/updates/world/2011_06_20_01_world_achievement_criteria_data.sql +++ b/sql/updates/world/2011_06_20_01_world_achievement_criteria_data.sql @@ -1,4 +1,4 @@ -DELETE FROM `disables` WHERE `entry`=7598; +DELETE FROM `disables` WHERE `entry`=7598 AND `sourceType`=4; DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=7598 AND `type`=11; INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES diff --git a/sql/updates/world/2011_06_20_02_world_achievement_criteria_data.sql b/sql/updates/world/2011_06_20_02_world_achievement_criteria_data.sql index a0156a780a3..82823227106 100644 --- a/sql/updates/world/2011_06_20_02_world_achievement_criteria_data.sql +++ b/sql/updates/world/2011_06_20_02_world_achievement_criteria_data.sql @@ -1,4 +1,4 @@ -DELETE FROM `disables` WHERE `entry`=7587; +DELETE FROM `disables` WHERE `entry`=7587 AND `sourceType`=4; DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=7587 AND `type`=11; INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES diff --git a/sql/updates/world/2011_06_20_04_world_achievement_criteria_data.sql b/sql/updates/world/2011_06_20_04_world_achievement_criteria_data.sql index 16ccd48a28f..1de020af638 100644 --- a/sql/updates/world/2011_06_20_04_world_achievement_criteria_data.sql +++ b/sql/updates/world/2011_06_20_04_world_achievement_criteria_data.sql @@ -1,4 +1,4 @@ -DELETE FROM `disables` WHERE `entry` IN (7264,7548); +DELETE FROM `disables` WHERE `entry` IN (7264,7548) AND `sourceType`=4; DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (7264,7548) AND `type`=11; INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES |