// *************************************************************** // Function: DeleteCharacter.cpp // *************************************************************** #include "Main.h" #include "LocalData.h" void SendError(int errorCode, int numLogins, short NetworkID); struct DELETE_CHARACTER_TEMP_DATA { unsigned char* dest; NetMessage d; char name[50]; }; //************************************ // Name: CompleteDeleteCharacter // // Process the query that gets everything needed to delete a character. // // Parameters: // pResult - Database query result // pLir - Player's local data // // Return: // //************************************ int CompleteDeleteCharacter(QUERY_RESULT* pResult, LOCAL_DATA* pLir) { if (pResult->pResult==NULL) { SendError(46, pLir->loginAttempts, pLir->networkId); return -1; } DELETE_CHARACTER_TEMP_DATA *cn=(DELETE_CHARACTER_TEMP_DATA*)pLir->pTempData; assert(pResult!=NULL); assert(pResult->pResult!=NULL); MYSQL_ROW row=mysql_fetch_row(pResult->pResult); if (row==NULL) { SendError(46, pLir->loginAttempts, pLir->networkId); return -1; } unsigned long char_id=atoi(row[0]); char query[140]; sprintf(query, "DELETE FROM items WHERE OwnerCID=%u", char_id); gDatabase.Query(query, (long)strlen(query)); //-------------------------------------------------------- //Erase the character from the character table //-------------------------------------------------------- sprintf(query, "DELETE FROM characters WHERE Name=\"%s\" AND OwnerAccountID=%u LIMIT 1", cn->name, pLir->accountId); gDatabase.Query(query, (long)strlen(query)); gCoreLog.debug("Character deleted!"); //--------------------------------------------------- //Send, character deleted packets //--------------------------------------------------- unsigned long num_logins=Read_uLong(cn->dest+2); CompiledPacket pck; pck.AddShort(ServerOpcode(11)); pck.AddLong(num_logins); pck.AddLong(0); Util::SendCompiledPacket(&pck, pLir->networkId, gpLoginServer); delete [] cn->dest; return 0; } //************************************ // Name: HandleOpcode_CHARACTER_DELETE // // Handles the character deletion request from the client. // // Parameters: // pData - Network message data // pLir - Player's local data // // Return: // Size of packet //************************************ int HandleOpcode_CHARACTER_DELETE(NetMessage* pData, LOCAL_DATA* pLir) { if (!BIT_TEST(pLir->bitfield, LD_AUTHENTICATED)) { SendError(24, pLir->loginAttempts, pLir->networkId); gpLoginServer->Kick(pLir->networkId); return -1; } //Save stuff for processing after query DELETE_CHARACTER_TEMP_DATA *temp_data=new DELETE_CHARACTER_TEMP_DATA; temp_data->d=*pData; temp_data->dest=new unsigned char[pData->dataSize]; memcpy(temp_data->dest, pData->pData, pData->dataSize); memset(temp_data->name, 0, 50); memcpy(temp_data->name, temp_data->dest+8, (int)temp_data->dest[6]*2); Util::StripUnicode(temp_data->name); gCoreLog.debug("Deleting: %s", temp_data->name); pLir->loginAttempts=Read_uLong(pData->pData+2); //------------------------------------------------------------------------------- //Get the character ID so we can erase the character from the account later //------------------------------------------------------------------------------- char query[250]; sprintf(query, "SELECT ID, HeadArmor, ChestArmor, ArmsArmor, LegArmor, FeetArmor FROM characters WHERE Name=\"%s\" AND OwnerAccountID=%u LIMIT 1", temp_data->name, pLir->accountId); pLir->queryId=gDatabase.Query(query, (long)strlen(query)); pLir->pTempData=(void*)temp_data; pLir->QueryProcess=CompleteDeleteCharacter; return pData->dataSize; }