diff options
| author | Azazel <azazel.kon@gmail.com> | 2011-02-24 23:39:45 +0600 |
|---|---|---|
| committer | Azazel <azazel.kon@gmail.com> | 2011-02-25 00:44:33 +0600 |
| commit | 20ab3e4bdace5da533005532b67fa53bdf70aa03 (patch) | |
| tree | b6cc1bd7a4d64fe726ba75c09ecf92fa3cffe7f6 /src/server/game/Accounts/AccountMgr.cpp | |
| parent | 3e046f9bc4a1b9a14025d1569e51dd11907b41fb (diff) | |
CharDB Schema/Cleanup: cleanup account_data and character_account_data tables:
* rename column account to accountId;
* introduce prepared statements for both tables.
Diffstat (limited to 'src/server/game/Accounts/AccountMgr.cpp')
| -rwxr-xr-x | src/server/game/Accounts/AccountMgr.cpp | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/server/game/Accounts/AccountMgr.cpp b/src/server/game/Accounts/AccountMgr.cpp index 3c0072b54fa..aa8658d1d65 100755 --- a/src/server/game/Accounts/AccountMgr.cpp +++ b/src/server/game/Accounts/AccountMgr.cpp @@ -75,7 +75,9 @@ AccountOpResult AccountMgr::DeleteAccount(uint32 accid) // table realm specific but common for all characters of account for realm CharacterDatabase.PExecute("DELETE FROM character_tutorial WHERE account = '%u'",accid); - CharacterDatabase.PExecute("DELETE FROM account_data WHERE account = '%u'",accid); + PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_ACCOUNT_DATA); + stmt->setUInt32(0, accid); + CharacterDatabase.Execute(stmt); SQLTransaction trans = LoginDatabase.BeginTransaction(); |