From 123d40dcfec7183b8c26e671f9d05987fced7cfb Mon Sep 17 00:00:00 2001
From: click <none@none>
Date: Wed, 21 Apr 2010 20:34:04 +0200
Subject: * Add some more transactioncontrol to pet database handling + adjust
 character_aura keys to avoid duplicates

--HG--
branch : trunk
---
 src/game/Pet.cpp | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'src')

diff --git a/src/game/Pet.cpp b/src/game/Pet.cpp
index ee96d7de9ee..9122b83adbb 100644
--- a/src/game/Pet.cpp
+++ b/src/game/Pet.cpp
@@ -378,6 +378,7 @@ void Pet::SavePetToDB(PetSaveMode mode)
     uint32 curhealth = GetHealth();
     uint32 curmana = GetPower(POWER_MANA);
 
+    CharacterDatabase.BeginTransaction();
     // save auras before possibly removing them
     _SaveAuras();
 
@@ -389,6 +390,7 @@ void Pet::SavePetToDB(PetSaveMode mode)
 
     _SaveSpells();
     _SaveSpellCooldowns();
+    CharacterDatabase.CommitTransaction();
 
     // current/stable/not_in_slot
     if (mode >= PET_SAVE_AS_CURRENT)
@@ -453,11 +455,13 @@ void Pet::SavePetToDB(PetSaveMode mode)
 
 void Pet::DeleteFromDB(uint32 guidlow)
 {
+    CharacterDatabase.BeginTransaction();
     CharacterDatabase.PExecute("DELETE FROM character_pet WHERE id = '%u'", guidlow);
     CharacterDatabase.PExecute("DELETE FROM character_pet_declinedname WHERE id = '%u'", guidlow);
     CharacterDatabase.PExecute("DELETE FROM pet_aura WHERE guid = '%u'", guidlow);
     CharacterDatabase.PExecute("DELETE FROM pet_spell WHERE guid = '%u'", guidlow);
     CharacterDatabase.PExecute("DELETE FROM pet_spell_cooldown WHERE guid = '%u'", guidlow);
+    CharacterDatabase.CommitTransaction();
 }
 
 void Pet::setDeathState(DeathState s)                       // overwrite virtual Creature::setDeathState and Unit::setDeathState
-- 
cgit v1.2.3