src/game/PetitionsHandler.cpp

   1 /*
   2  * Copyright (C) 2005-2013 MaNGOS <http://getmangos.com/>
   3  *
   4  * This program is free software; you can redistribute it and/or modify
   5  * it under the terms of the GNU General Public License as published by
   6  * the Free Software Foundation; either version 2 of the License, or
   7  * (at your option) any later version.
   8  *
   9  * This program is distributed in the hope that it will be useful,
  10  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  * GNU General Public License for more details.
  13  *
  14  * You should have received a copy of the GNU General Public License
  15  * along with this program; if not, write to the Free Software
  16  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  17  */
  18
  19 #include "Common.h"
  20 #include "Language.h"
  21 #include "WorldPacket.h"
  22 #include "WorldSession.h"
  23 #include "World.h"
  24 #include "ObjectMgr.h"
  25 #include "Log.h"
  26 #include "Opcodes.h"
  27 #include "Guild.h"
  28 #include "GuildMgr.h"
  29 #include "ArenaTeam.h"
  30 #include "GossipDef.h"
  31 #include "SocialMgr.h"
  32
  33 /*enum PetitionType // dbc data
  34 {
  35     PETITION_TYPE_GUILD      = 1,
  36     PETITION_TYPE_ARENA_TEAM = 3
  37 };*/
  38
  39 // Charters ID in item_template
  40 #define GUILD_CHARTER               5863
  41 #define GUILD_CHARTER_COST          1000                    // 10 S
  42 #define CHARTER_DISPLAY_ID          16161
  43
  44 void WorldSession::HandlePetitionBuyOpcode(WorldPacket& recv_data)
  45 {
  46     DEBUG_LOG("Received opcode CMSG_PETITION_BUY");
  47     recv_data.hexlike();
  48
  49     ObjectGuid guidNPC;
  50     std::string name;
  51
  52     recv_data >> guidNPC;                                   // NPC GUID
  53     recv_data.read_skip<uint32>();                          // 0
  54     recv_data.read_skip<uint64>();                          // 0
  55     recv_data >> name;                                      // name
  56     recv_data.read_skip<std::string>();                     // some string
  57     recv_data.read_skip<uint32>();                          // 0
  58     recv_data.read_skip<uint32>();                          // 0
  59     recv_data.read_skip<uint32>();                          // 0
  60     recv_data.read_skip<uint32>();                          // 0
  61     recv_data.read_skip<uint32>();                          // 0
  62     recv_data.read_skip<uint32>();                          // 0
  63     recv_data.read_skip<uint32>();                          // 0
  64     recv_data.read_skip<uint16>();                          // 0
  65     recv_data.read_skip<uint32>();                          // 0
  66     recv_data.read_skip<uint32>();                          // 0
  67     recv_data.read_skip<uint32>();                          // 0
  68
  69     for (int i = 0; i < 10; ++i)
  70         recv_data.read_skip<std::string>();
  71
  72     recv_data.read_skip<uint32>();                          // client index
  73     recv_data.read_skip<uint32>();                          // 0
  74
  75     DEBUG_LOG("Petitioner %s tried sell petition: name %s", guidNPC.GetString().c_str(), name.c_str());
  76
  77     // prevent cheating
  78     Creature* pCreature = GetPlayer()->GetNPCIfCanInteractWith(guidNPC, UNIT_NPC_FLAG_PETITIONER);
  79     if (!pCreature)
  80     {
  81         DEBUG_LOG("WORLD: HandlePetitionBuyOpcode - %s not found or you can't interact with him.", guidNPC.GetString().c_str());
  82         return;
  83     }
  84
  85     // remove fake death
  86     if (GetPlayer()->hasUnitState(UNIT_STAT_DIED))
  87         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
  88
  89     if (!pCreature->isTabardDesigner())
  90     {
  91         sLog.outError("WORLD: HandlePetitionBuyOpcode - unsupported npc type, npc: %s", guidNPC.GetString().c_str());
  92         return;
  93     }
  94
  95     if (sGuildMgr.GetGuildByName(name))
  96     {
  97         SendGuildCommandResult(GUILD_CREATE_S, name, ERR_GUILD_NAME_EXISTS_S);
  98         return;
  99     }
 100     if (sObjectMgr.IsReservedName(name) || !ObjectMgr::IsValidCharterName(name))
 101     {
 102         SendGuildCommandResult(GUILD_CREATE_S, name, ERR_GUILD_NAME_INVALID);
 103         return;
 104     }
 105
 106     ItemPrototype const* pProto = ObjectMgr::GetItemPrototype(GUILD_CHARTER);
 107     if (!pProto)
 108     {
 109         _player->SendBuyError(BUY_ERR_CANT_FIND_ITEM, NULL, GUILD_CHARTER, 0);
 110         return;
 111     }
 112
 113     if (_player->GetMoney() < GUILD_CHARTER_COST)
 114     {
 115         // player hasn't got enough money
 116         _player->SendBuyError(BUY_ERR_NOT_ENOUGHT_MONEY, pCreature, GUILD_CHARTER, 0);
 117         return;
 118     }
 119
 120     ItemPosCountVec dest;
 121     InventoryResult msg = _player->CanStoreNewItem(NULL_BAG, NULL_SLOT, dest, GUILD_CHARTER, pProto->BuyCount);
 122     if (msg != EQUIP_ERR_OK)
 123     {
 124         _player->SendEquipError(msg, NULL, NULL, GUILD_CHARTER);
 125         return;
 126     }
 127
 128     _player->ModifyMoney(-(int64)GUILD_CHARTER_COST);
 129     Item* charter = _player->StoreNewItem(dest, GUILD_CHARTER, true);
 130     if (!charter)
 131         return;
 132
 133     charter->SetUInt32Value(ITEM_FIELD_ENCHANTMENT_1_1, charter->GetGUIDLow());
 134     // ITEM_FIELD_ENCHANTMENT_1_1 is guild/arenateam id
 135     // ITEM_FIELD_ENCHANTMENT_1_1+1 is current signatures count (showed on item)
 136     charter->SetState(ITEM_CHANGED, _player);
 137     _player->SendNewItem(charter, 1, true, false);
 138
 139     // a petition is invalid, if both the owner and the type matches
 140     // we checked above, if this player is in an arenateam, so this must be data corruption
 141     QueryResult* result = CharacterDatabase.PQuery("SELECT petitionguid FROM petition WHERE ownerguid = '%u'", _player->GetGUIDLow());
 142
 143     std::ostringstream ssInvalidPetitionGUIDs;
 144
 145     if (result)
 146     {
 147         do
 148         {
 149             Field* fields = result->Fetch();
 150             ssInvalidPetitionGUIDs << "'" << fields[0].GetUInt32() << "' , ";
 151         }
 152         while (result->NextRow());
 153
 154         delete result;
 155     }
 156
 157     // delete petitions with the same guid as this one
 158     ssInvalidPetitionGUIDs << "'" << charter->GetGUIDLow() << "'";
 159
 160     DEBUG_LOG("Invalid petition GUIDs: %s", ssInvalidPetitionGUIDs.str().c_str());
 161     CharacterDatabase.escape_string(name);
 162     CharacterDatabase.BeginTransaction();
 163     CharacterDatabase.PExecute("DELETE FROM petition WHERE petitionguid IN ( %s )",  ssInvalidPetitionGUIDs.str().c_str());
 164     CharacterDatabase.PExecute("DELETE FROM petition_sign WHERE petitionguid IN ( %s )", ssInvalidPetitionGUIDs.str().c_str());
 165     CharacterDatabase.PExecute("INSERT INTO petition (ownerguid, petitionguid, name) VALUES ('%u', '%u', '%s')",
 166                                _player->GetGUIDLow(), charter->GetGUIDLow(), name.c_str());
 167     CharacterDatabase.CommitTransaction();
 168 }
 169
 170 void WorldSession::HandlePetitionShowSignOpcode(WorldPacket& recv_data)
 171 {
 172     // ok
 173     DEBUG_LOG("Received opcode CMSG_PETITION_SHOW_SIGNATURES");
 174     // recv_data.hexlike();
 175
 176     uint8 signs = 0;
 177     ObjectGuid petitionguid;
 178     recv_data >> petitionguid;                              // petition guid
 179
 180     // solve (possible) some strange compile problems with explicit use GUID_LOPART(petitionguid) at some GCC versions (wrong code optimization in compiler?)
 181     uint32 petitionguid_low = petitionguid.GetCounter();
 182
 183     QueryResult* result = CharacterDatabase.PQuery("SELECT 1 FROM petition WHERE petitionguid = '%u'", petitionguid_low);
 184     if (!result)
 185     {
 186         sLog.outError("any petition on server...");
 187         return;
 188     }
 189     delete result;
 190
 191     // if has guild => error, return;
 192     if (_player->GetGuildId())
 193         return;
 194
 195     result = CharacterDatabase.PQuery("SELECT playerguid FROM petition_sign WHERE petitionguid = '%u'", petitionguid_low);
 196
 197     // result==NULL also correct in case no sign yet
 198     if (result)
 199         signs = (uint8)result->GetRowCount();
 200
 201     DEBUG_LOG("CMSG_PETITION_SHOW_SIGNATURES petition: %s", petitionguid.GetString().c_str());
 202
 203     WorldPacket data(SMSG_PETITION_SHOW_SIGNATURES, (8 + 8 + 4 + 1 + signs * 12));
 204     data << petitionguid;                                   // petition guid
 205     data << _player->GetObjectGuid();                       // owner guid
 206     data << uint32(petitionguid_low);                       // guild guid (in mangos always same as GUID_LOPART(petitionguid)
 207     data << uint8(signs);                                   // sign's count
 208
 209     for (uint8 i = 1; i <= signs; ++i)
 210     {
 211         Field* fields2 = result->Fetch();
 212         ObjectGuid signerGuid = ObjectGuid(HIGHGUID_PLAYER, fields2[0].GetUInt32());
 213
 214         data << signerGuid;                                 // Player GUID
 215         data << uint32(0);                                  // there 0 ...
 216
 217         result->NextRow();
 218     }
 219     delete result;
 220     SendPacket(&data);
 221 }
 222
 223 void WorldSession::HandlePetitionQueryOpcode(WorldPacket& recv_data)
 224 {
 225     DEBUG_LOG("Received opcode CMSG_PETITION_QUERY");
 226     // recv_data.hexlike();
 227
 228     uint32 guildguid;
 229     ObjectGuid petitionguid;
 230     recv_data >> guildguid;                                 // in mangos always same as GUID_LOPART(petitionguid)
 231     recv_data >> petitionguid;                              // petition guid
 232     DEBUG_LOG("CMSG_PETITION_QUERY Petition %s Guild GUID %u", petitionguid.GetString().c_str(), guildguid);
 233
 234     SendPetitionQueryOpcode(petitionguid);
 235 }
 236
 237 void WorldSession::SendPetitionQueryOpcode(ObjectGuid petitionguid)
 238 {
 239     uint32 petitionLowGuid = petitionguid.GetCounter();
 240
 241     ObjectGuid ownerGuid;
 242     std::string name = "NO_NAME_FOR_GUID";
 243     uint8 signs = 0;
 244
 245     QueryResult* result = CharacterDatabase.PQuery(
 246                               "SELECT ownerguid, name, "
 247                               "  (SELECT COUNT(playerguid) FROM petition_sign WHERE petition_sign.petitionguid = '%u') AS signs "
 248                               "FROM petition WHERE petitionguid = '%u'", petitionLowGuid, petitionLowGuid);
 249
 250     if (result)
 251     {
 252         Field* fields = result->Fetch();
 253         ownerGuid = ObjectGuid(HIGHGUID_PLAYER, fields[0].GetUInt32());
 254         name      = fields[1].GetCppString();
 255         signs     = fields[2].GetUInt8();
 256         delete result;
 257     }
 258     else
 259     {
 260         DEBUG_LOG("CMSG_PETITION_QUERY failed for petition (GUID: %u)", petitionLowGuid);
 261         return;
 262     }
 263
 264     WorldPacket data(SMSG_PETITION_QUERY_RESPONSE, (4 + 8 + name.size() + 1 + 1 + 4 * 12 + 2 + 10));
 265     data << uint32(petitionLowGuid);                        // guild/team guid (in mangos always same as GUID_LOPART(petition guid)
 266     data << ObjectGuid(ownerGuid);                          // charter owner guid
 267     data << name;                                           // name (guild/arena team)
 268     data << uint8(0);                                       // some string
 269     data << uint32(4);
 270     data << uint32(4);
 271     data << uint32(0);                                      // bypass client - side limitation, a different value is needed here for each petition
 272     data << uint32(0);                                      // 5
 273     data << uint32(0);                                      // 6
 274     data << uint32(0);                                      // 7
 275     data << uint32(0);                                      // 8
 276     data << uint16(0);                                      // 9 2 bytes field
 277     data << uint32(0);                                      // 10
 278     data << uint32(0);                                      // 11
 279     data << uint32(0);                                      // 13 count of next strings?
 280
 281     for (int i = 0; i < 10; ++i)
 282         data << uint8(0);                                   // some string
 283
 284     data << uint32(0);                                      // 14
 285     data << uint32(0);                                      // 15 0 - guild, 1 - arena team
 286
 287     SendPacket(&data);
 288 }
 289
 290 void WorldSession::HandlePetitionRenameOpcode(WorldPacket& recv_data)
 291 {
 292     DEBUG_LOG("Received opcode MSG_PETITION_RENAME");   // ok
 293     // recv_data.hexlike();
 294
 295     ObjectGuid petitionGuid;
 296     std::string newname;
 297
 298     recv_data >> petitionGuid;                              // guid
 299     recv_data >> newname;                                   // new name
 300
 301     Item* item = _player->GetItemByGuid(petitionGuid);
 302     if (!item)
 303         return;
 304
 305     QueryResult* result = CharacterDatabase.PQuery("SELECT 1 FROM petition WHERE petitionguid = '%u'", petitionGuid.GetCounter());
 306     if (!result)
 307     {
 308         DEBUG_LOG("CMSG_PETITION_QUERY failed for petition: %s", petitionGuid.GetString().c_str());
 309         return;
 310     }
 311     delete result;
 312
 313     if (sGuildMgr.GetGuildByName(newname))
 314     {
 315         SendGuildCommandResult(GUILD_CREATE_S, newname, ERR_GUILD_NAME_EXISTS_S);
 316         return;
 317     }
 318     if (sObjectMgr.IsReservedName(newname) || !ObjectMgr::IsValidCharterName(newname))
 319     {
 320         SendGuildCommandResult(GUILD_CREATE_S, newname, ERR_GUILD_NAME_INVALID);
 321         return;
 322     }
 323
 324     std::string db_newname = newname;
 325     CharacterDatabase.escape_string(db_newname);
 326     CharacterDatabase.PExecute("UPDATE petition SET name = '%s' WHERE petitionguid = '%u'",
 327                                db_newname.c_str(), petitionGuid.GetCounter());
 328
 329     DEBUG_LOG("Petition %s renamed to '%s'", petitionGuid.GetString().c_str(), newname.c_str());
 330
 331     WorldPacket data(MSG_PETITION_RENAME, 8 + newname.size() + 1);
 332     data << petitionGuid;
 333     data << newname;
 334     SendPacket(&data);
 335 }
 336
 337 void WorldSession::HandlePetitionSignOpcode(WorldPacket& recv_data)
 338 {
 339     DEBUG_LOG("Received opcode CMSG_PETITION_SIGN");    // ok
 340     // recv_data.hexlike();
 341
 342     Field* fields;
 343     ObjectGuid petitionGuid;
 344     uint8 unk;
 345     recv_data >> petitionGuid;                              // petition guid
 346     recv_data >> unk;
 347
 348     uint32 petitionLowGuid = petitionGuid.GetCounter();
 349
 350     QueryResult* result = CharacterDatabase.PQuery(
 351                               "SELECT ownerguid, "
 352                               "  (SELECT COUNT(playerguid) FROM petition_sign WHERE petition_sign.petitionguid = '%u') AS signs "
 353                               "FROM petition WHERE petitionguid = '%u'", petitionLowGuid, petitionLowGuid);
 354
 355     if (!result)
 356     {
 357         sLog.outError("any petition on server...");
 358         return;
 359     }
 360
 361     fields = result->Fetch();
 362     uint32 ownerLowGuid = fields[0].GetUInt32();
 363     ObjectGuid ownerGuid = ObjectGuid(HIGHGUID_PLAYER, ownerLowGuid);
 364     uint8 signs = fields[1].GetUInt8();
 365
 366     delete result;
 367
 368     if (ownerGuid == _player->GetObjectGuid())
 369         return;
 370
 371     // not let enemies sign guild charter
 372     if (!sWorld.getConfig(CONFIG_BOOL_ALLOW_TWO_SIDE_INTERACTION_GUILD) &&
 373             GetPlayer()->GetTeam() != sObjectMgr.GetPlayerTeamByGUID(ownerGuid))
 374     {
 375         SendGuildCommandResult(GUILD_CREATE_S, "", ERR_GUILD_NOT_ALLIED);
 376         return;
 377     }
 378
 379     if (_player->GetGuildId() || _player->GetGuildIdInvited())
 380     {
 381         // close at signer side
 382         _player->SendPetitionSignResult(petitionGuid, _player, PETITION_SIGN_ALREADY_IN_GUILD);
 383         return;
 384     }
 385
 386     if (++signs > 4)                                        // client signs maximum
 387     {
 388         // close at signer side
 389         _player->SendPetitionSignResult(petitionGuid, _player, PETITION_SIGN_PETITION_FULL);
 390         return;
 391     }
 392
 393     // client doesn't allow to sign petition two times by one character, but not check sign by another character from same account
 394     // not allow sign another player from already sign player account
 395     result = CharacterDatabase.PQuery("SELECT playerguid, petitionguid FROM petition_sign WHERE player_account = '%u'", GetAccountId());
 396
 397     if (result)
 398     {
 399         fields = result->Fetch();
 400         ObjectGuid playerGuid = ObjectGuid(HIGHGUID_PLAYER, fields[0].GetUInt32());
 401         uint32 otherPetition = fields[1].GetUInt32();
 402         delete result;
 403         if (otherPetition == petitionGuid.GetCounter())
 404         {
 405             // close at signer side
 406             _player->SendPetitionSignResult(petitionGuid, _player, PETITION_SIGN_ALREADY_SIGNED);
 407
 408             // update for owner if online
 409             if (Player* owner = sObjectMgr.GetPlayer(ownerGuid))
 410                 owner->SendPetitionSignResult(petitionGuid, _player, PETITION_SIGN_ALREADY_SIGNED);
 411             return;
 412         }
 413         else if (playerGuid == _player->GetObjectGuid())
 414         {
 415             // close at signer side
 416             _player->SendPetitionSignResult(petitionGuid, _player, PETITION_SIGN_ALREADY_SIGNED_OTHER);
 417
 418             // update for owner if online
 419             if (Player* owner = sObjectMgr.GetPlayer(ownerGuid))
 420                 owner->SendPetitionSignResult(petitionGuid, _player, PETITION_SIGN_ALREADY_SIGNED_OTHER);
 421             return;
 422         }
 423     }
 424
 425     CharacterDatabase.PExecute("INSERT INTO petition_sign (ownerguid,petitionguid, playerguid, player_account) VALUES ('%u', '%u', '%u','%u')",
 426                                ownerLowGuid, petitionLowGuid, _player->GetGUIDLow(), GetAccountId());
 427
 428     DEBUG_LOG("PETITION SIGN: %s by %s", petitionGuid.GetString().c_str(), _player->GetGuidStr().c_str());
 429
 430     // close at signer side
 431     _player->SendPetitionSignResult(petitionGuid, _player, PETITION_SIGN_OK);
 432
 433     // update signs count on charter, required testing...
 434     // Item *item = _player->GetItemByGuid(petitionguid));
 435     // if(item)
 436     //    item->SetUInt32Value(ITEM_FIELD_ENCHANTMENT_1_1+1, signs);
 437
 438     // update for owner if online
 439     if (Player* owner = sObjectMgr.GetPlayer(ownerGuid))
 440         owner->SendPetitionSignResult(petitionGuid, _player, PETITION_SIGN_OK);
 441 }
 442
 443 void WorldSession::HandlePetitionDeclineOpcode(WorldPacket& recv_data)
 444 {
 445     DEBUG_LOG("Received opcode MSG_PETITION_DECLINE");  // ok
 446     // recv_data.hexlike();
 447
 448     ObjectGuid petitionGuid;
 449     recv_data >> petitionGuid;                              // petition guid
 450
 451     DEBUG_LOG("Petition %s declined by %s", petitionGuid.GetString().c_str(), _player->GetGuidStr().c_str());
 452
 453     uint32 petitionLowGuid = petitionGuid.GetCounter();
 454
 455     QueryResult* result = CharacterDatabase.PQuery("SELECT ownerguid FROM petition WHERE petitionguid = '%u'", petitionLowGuid);
 456     if (!result)
 457         return;
 458
 459     Field* fields = result->Fetch();
 460     ObjectGuid ownerguid = ObjectGuid(HIGHGUID_PLAYER, fields[0].GetUInt32());
 461     delete result;
 462
 463     if (Player* owner = sObjectMgr.GetPlayer(ownerguid))    // petition owner online
 464     {
 465         WorldPacket data(MSG_PETITION_DECLINE, 8);
 466         data << _player->GetObjectGuid();
 467         owner->GetSession()->SendPacket(&data);
 468     }
 469 }
 470
 471 void WorldSession::HandleOfferPetitionOpcode(WorldPacket& recv_data)
 472 {
 473     DEBUG_LOG("Received opcode CMSG_OFFER_PETITION");   // ok
 474     // recv_data.hexlike();
 475
 476     ObjectGuid petitionGuid;
 477     ObjectGuid playerGuid;
 478     uint32 junk;
 479     recv_data >> junk;                                      // this is not petition type!
 480     recv_data >> petitionGuid;                              // petition guid
 481     recv_data >> playerGuid;                                // player guid
 482
 483     Player* player = ObjectAccessor::FindPlayer(playerGuid);
 484     if (!player)
 485         return;
 486
 487     /// Get petition type and check
 488     QueryResult* result = CharacterDatabase.PQuery("SELECT 1 FROM petition WHERE petitionguid = '%u'", petitionGuid.GetCounter());
 489     if (!result)
 490         return;
 491     delete result;
 492
 493     DEBUG_LOG("OFFER PETITION: petition %s to %s", petitionGuid.GetString().c_str(), playerGuid.GetString().c_str());
 494
 495     if (!sWorld.getConfig(CONFIG_BOOL_ALLOW_TWO_SIDE_INTERACTION_GUILD) && GetPlayer()->GetTeam() != player->GetTeam())
 496     {
 497         SendGuildCommandResult(GUILD_CREATE_S, "", ERR_GUILD_NOT_ALLIED);
 498         return;
 499     }
 500
 501     if (player->GetGuildId())
 502     {
 503         SendGuildCommandResult(GUILD_INVITE_S, _player->GetName(), ERR_ALREADY_IN_GUILD_S);
 504         return;
 505     }
 506
 507     if (player->GetGuildIdInvited())
 508     {
 509         SendGuildCommandResult(GUILD_INVITE_S, _player->GetName(), ERR_ALREADY_INVITED_TO_GUILD_S);
 510         return;
 511     }
 512
 513     /// Get petition signs count
 514     uint8 signs = 0;
 515     result = CharacterDatabase.PQuery("SELECT playerguid FROM petition_sign WHERE petitionguid = '%u'", petitionGuid.GetCounter());
 516     // result==NULL also correct charter without signs
 517     if (result)
 518         signs = (uint8)result->GetRowCount();
 519
 520     /// Send response
 521     WorldPacket data(SMSG_PETITION_SHOW_SIGNATURES, (8 + 8 + 4 + signs + signs * 12));
 522     data << petitionGuid;                                   // petition guid
 523     data << _player->GetObjectGuid();                       // owner guid
 524     data << uint32(petitionGuid.GetCounter());              // guild guid (in mangos always same as low part of petition guid)
 525     data << uint8(signs);                                   // sign's count
 526
 527     for (uint8 i = 1; i <= signs; ++i)
 528     {
 529         Field* fields2 = result->Fetch();
 530         ObjectGuid signerGuid = ObjectGuid(HIGHGUID_PLAYER, fields2[0].GetUInt32());
 531
 532         data << signerGuid;                                 // Player GUID
 533         data << uint32(0);                                  // there 0 ...
 534
 535         result->NextRow();
 536     }
 537
 538     delete result;
 539     player->GetSession()->SendPacket(&data);
 540 }
 541
 542 void WorldSession::HandleTurnInPetitionOpcode(WorldPacket& recv_data)
 543 {
 544     DEBUG_LOG("Received opcode CMSG_TURN_IN_PETITION"); // ok
 545     // recv_data.hexlike();
 546
 547     ObjectGuid petitionGuid;
 548
 549     recv_data >> petitionGuid;
 550
 551     DEBUG_LOG("Petition %s turned in by %s", petitionGuid.GetString().c_str(), _player->GetGuidStr().c_str());
 552
 553     /// Collect petition info data
 554     ObjectGuid ownerGuid;
 555     std::string name;
 556
 557     // data
 558     QueryResult* result = CharacterDatabase.PQuery("SELECT ownerguid, name FROM petition WHERE petitionguid = '%u'", petitionGuid.GetCounter());
 559     if (result)
 560     {
 561         Field* fields = result->Fetch();
 562         ownerGuid = ObjectGuid(HIGHGUID_PLAYER, fields[0].GetUInt32());
 563         name = fields[1].GetCppString();
 564         delete result;
 565     }
 566     else
 567     {
 568         sLog.outError("CMSG_TURN_IN_PETITION: petition table not have data for guid %u!", petitionGuid.GetCounter());
 569         return;
 570     }
 571
 572     if (_player->GetGuildId())
 573     {
 574         _player->SendPetitionTurnInResult(PETITION_TURN_ALREADY_IN_GUILD);  // already in guild
 575         return;
 576     }
 577
 578     if (_player->GetObjectGuid() != ownerGuid)
 579         return;
 580
 581     // signs
 582     result = CharacterDatabase.PQuery("SELECT playerguid FROM petition_sign WHERE petitionguid = '%u'", petitionGuid.GetCounter());
 583     uint8 signs = result ? (uint8)result->GetRowCount() : 0;
 584
 585     uint32 count = sWorld.getConfig(CONFIG_UINT32_MIN_PETITION_SIGNS);
 586     if (signs < count)
 587     {
 588         _player->SendPetitionTurnInResult(PETITION_TURN_NEED_MORE_SIGNATURES);  // need more signatures...
 589         delete result;
 590         return;
 591     }
 592
 593     if (sGuildMgr.GetGuildByName(name))
 594     {
 595         _player->SendPetitionTurnInResult(PETITION_TURN_GUILD_NAME_INVALID);
 596         delete result;
 597         return;
 598     }
 599
 600     // and at last charter item check
 601     Item* item = _player->GetItemByGuid(petitionGuid);
 602     if (!item)
 603     {
 604         delete result;
 605         return;
 606     }
 607
 608     // OK!
 609
 610     // delete charter item
 611     _player->DestroyItem(item->GetBagSlot(), item->GetSlot(), true);
 612
 613     Guild* guild = new Guild;
 614     if (!guild->Create(_player, name))
 615     {
 616         delete guild;
 617         delete result;
 618         return;
 619     }
 620
 621     // register guild and add guildmaster
 622     sGuildMgr.AddGuild(guild);
 623
 624     // add members
 625     for (uint8 i = 0; i < signs; ++i)
 626     {
 627         Field* fields = result->Fetch();
 628
 629         ObjectGuid signGuid = ObjectGuid(HIGHGUID_PLAYER, fields[0].GetUInt32());
 630         if (!signGuid)
 631             continue;
 632
 633         guild->AddMember(signGuid, guild->GetLowestRank());
 634         result->NextRow();
 635     }
 636
 637     delete result;
 638
 639     CharacterDatabase.BeginTransaction();
 640     CharacterDatabase.PExecute("DELETE FROM petition WHERE petitionguid = '%u'", petitionGuid.GetCounter());
 641     CharacterDatabase.PExecute("DELETE FROM petition_sign WHERE petitionguid = '%u'", petitionGuid.GetCounter());
 642     CharacterDatabase.CommitTransaction();
 643
 644     // created
 645     DEBUG_LOG("TURN IN PETITION %s", petitionGuid.GetString().c_str());
 646
 647     _player->SendPetitionTurnInResult(PETITION_TURN_OK);
 648 }
 649
 650 void WorldSession::HandlePetitionShowListOpcode(WorldPacket& recv_data)
 651 {
 652     DEBUG_LOG("Received CMSG_PETITION_SHOWLIST");
 653     // recv_data.hexlike();
 654
 655     ObjectGuid guid;
 656     recv_data >> guid;
 657
 658     SendPetitionShowList(guid);
 659 }
 660
 661 void WorldSession::SendPetitionShowList(ObjectGuid guid)
 662 {
 663     Creature* pCreature = GetPlayer()->GetNPCIfCanInteractWith(guid, UNIT_NPC_FLAG_PETITIONER);
 664     if (!pCreature)
 665     {
 666         DEBUG_LOG("WORLD: HandlePetitionShowListOpcode - %s not found or you can't interact with him.", guid.GetString().c_str());
 667         return;
 668     }
 669
 670     // remove fake death
 671     if (GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 672         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 673
 674     // only guild petitions currently used
 675     if (!pCreature->isTabardDesigner())
 676     {
 677         DEBUG_LOG("WORLD: HandlePetitionShowListOpcode - %s is not supported npc type.", guid.GetString().c_str());
 678         return;
 679     }
 680
 681     WorldPacket data(SMSG_PETITION_SHOWLIST, 8 + 1 + 4 * 6);
 682     data << guid;                                           // npc guid
 683     data << uint32(1);                                      // index
 684     data << uint32(GUILD_CHARTER);                          // charter entry
 685     data << uint32(CHARTER_DISPLAY_ID);                     // charter display id
 686     data << uint32(GUILD_CHARTER_COST);                     // charter cost
 687     data << uint32(0);                                      // unknown
 688     data << uint32(4);                                      // required signs
 689
 690     // for(uint8 i = 0; i < count; ++i)
 691     //{
 692     //    data << uint32(i);                        // index
 693     //    data << uint32(GUILD_CHARTER);            // charter entry
 694     //    data << uint32(CHARTER_DISPLAY_ID);       // charter display id
 695     //    data << uint32(GUILD_CHARTER_COST+i);     // charter cost
 696     //    data << uint32(0);                        // unknown
 697     //    data << uint32(9);                        // required signs
 698     //}
 699     SendPacket(&data);
 700     DEBUG_LOG("Sent SMSG_PETITION_SHOWLIST");
 701 }