Changeset 22 for trunk

Timestamp:

11/19/08 13:23:58 (17 years ago)

Author:

yumileroy

Message:

[svn] * Updated character create query to use proper LEFT JOIN instead of NOT IN (SELECT...

Original author: Neo2003
Date: 2008-10-06 13:49:41-05:00

Files:

• trunk/src/game/AccountMgr.cpp (modified) (1 diff)

trunk/src/game/AccountMgr.cpp

@@ -58 +58 @@
     if(!loginDatabase.PExecute("INSERT INTO account(username,sha_pass_hash,joindate) VALUES('%s',SHA1(CONCAT('%s',':','%s')),NOW())", username.c_str(), username.c_str(), password.c_str()))
         return AOR_DB_INTERNAL_ERROR;                       // unexpected error
-    loginDatabase.Execute("INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM account, realmlist WHERE account.id NOT IN (SELECT acctid FROM realmcharacters)");
+    loginDatabase.Execute("INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist,account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL");
 
     return AOR_OK;                                          // everything's fine