2 * Copyright (C) 2005-2008 MaNGOS <http://getmangos.com/>
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.
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.
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
20 #include "Database/DatabaseEnv.h"
21 #include "WorldPacket.h"
22 #include "SharedDefines.h"
23 #include "WorldSession.h"
27 #include "ObjectMgr.h"
30 #include "UpdateMask.h"
32 #include "MapManager.h"
33 #include "ObjectAccessor.h"
35 #include "Database/DatabaseImpl.h"
36 #include "PlayerDump.h"
37 #include "SocialMgr.h"
41 class LoginQueryHolder
: public SqlQueryHolder
47 LoginQueryHolder(uint32 accountId
, uint64 guid
)
48 : m_accountId(accountId
), m_guid(guid
) { }
49 uint64
GetGuid() const { return m_guid
; }
50 uint32
GetAccountId() const { return m_accountId
; }
54 bool LoginQueryHolder::Initialize()
56 SetSize(MAX_PLAYER_LOGIN_QUERY
);
60 // NOTE: all fields in `characters` must be read to prevent lost character data at next save in case wrong DB structure.
61 // !!! NOTE: including unused `zone`,`online`
62 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADFROM
, "SELECT guid, account, data, name, race, class, position_x, position_y, position_z, map, orientation, taximask, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, online, death_expire_time, taxi_path, dungeon_difficulty FROM characters WHERE guid = '%u'", GUID_LOPART(m_guid
));
63 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADGROUP
, "SELECT leaderGuid FROM group_member WHERE memberGuid ='%u'", GUID_LOPART(m_guid
));
64 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADBOUNDINSTANCES
, "SELECT id, permanent, map, difficulty, resettime FROM character_instance LEFT JOIN instance ON instance = id WHERE guid = '%u'", GUID_LOPART(m_guid
));
65 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADAURAS
, "SELECT caster_guid,spell,effect_index,stackcount,amount,maxduration,remaintime,remaincharges FROM character_aura WHERE guid = '%u'", GUID_LOPART(m_guid
));
66 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADSPELLS
, "SELECT spell,slot,active,disabled FROM character_spell WHERE guid = '%u'", GUID_LOPART(m_guid
));
67 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADQUESTSTATUS
, "SELECT quest,status,rewarded,explored,timer,mobcount1,mobcount2,mobcount3,mobcount4,itemcount1,itemcount2,itemcount3,itemcount4 FROM character_queststatus WHERE guid = '%u'", GUID_LOPART(m_guid
));
68 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADDAILYQUESTSTATUS
,"SELECT quest,time FROM character_queststatus_daily WHERE guid = '%u'", GUID_LOPART(m_guid
));
69 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADTUTORIALS
, "SELECT tut0,tut1,tut2,tut3,tut4,tut5,tut6,tut7 FROM character_tutorial WHERE account = '%u' AND realmid = '%u'", GetAccountId(), realmID
);
70 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADREPUTATION
, "SELECT faction,standing,flags FROM character_reputation WHERE guid = '%u'", GUID_LOPART(m_guid
));
71 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADINVENTORY
, "SELECT data,bag,slot,item,item_template FROM character_inventory JOIN item_instance ON character_inventory.item = item_instance.guid WHERE character_inventory.guid = '%u' ORDER BY bag,slot", GUID_LOPART(m_guid
));
72 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADACTIONS
, "SELECT button,action,type,misc FROM character_action WHERE guid = '%u' ORDER BY button", GUID_LOPART(m_guid
));
73 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADMAILCOUNT
, "SELECT COUNT(id) FROM mail WHERE receiver = '%u' AND (checked & 1)=0 AND deliver_time <= '" I64FMTD
"'", GUID_LOPART(m_guid
),(uint64
)time(NULL
));
74 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADMAILDATE
, "SELECT MIN(deliver_time) FROM mail WHERE receiver = '%u' AND (checked & 1)=0", GUID_LOPART(m_guid
));
75 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADSOCIALLIST
, "SELECT friend,flags,note FROM character_social WHERE guid = '%u' LIMIT 255", GUID_LOPART(m_guid
));
76 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADHOMEBIND
, "SELECT map,zone,position_x,position_y,position_z FROM character_homebind WHERE guid = '%u'", GUID_LOPART(m_guid
));
77 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADSPELLCOOLDOWNS
, "SELECT spell,item,time FROM character_spell_cooldown WHERE guid = '%u'", GUID_LOPART(m_guid
));
78 if(sWorld
.getConfig(CONFIG_DECLINED_NAMES_USED
))
79 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADDECLINEDNAMES
, "SELECT genitive, dative, accusative, instrumental, prepositional FROM character_declinedname WHERE guid = '%u'",GUID_LOPART(m_guid
));
80 // in other case still be dummy query
81 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADGUILD
, "SELECT guildid,rank FROM guild_member WHERE guid = '%u'", GUID_LOPART(m_guid
));
82 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADACHIEVEMENTS
, "SELECT achievement, date FROM character_achievement WHERE guid = '%u'", GUID_LOPART(m_guid
));
83 res
&= SetPQuery(PLAYER_LOGIN_QUERY_LOADCRITERIAPROGRESS
,"SELECT criteria, counter, date FROM character_achievement_progress WHERE guid = '%u'", GUID_LOPART(m_guid
));
88 // don't call WorldSession directly
89 // it may get deleted before the query callbacks get executed
90 // instead pass an account id to this handler
91 class CharacterHandler
94 void HandleCharEnumCallback(QueryResult
* result
, uint32 account
)
96 WorldSession
* session
= sWorld
.FindSession(account
);
102 session
->HandleCharEnum(result
);
104 void HandlePlayerLoginCallback(QueryResult
* /*dummy*/, SqlQueryHolder
* holder
)
107 WorldSession
*session
= sWorld
.FindSession(((LoginQueryHolder
*)holder
)->GetAccountId());
113 session
->HandlePlayerLogin((LoginQueryHolder
*)holder
);
117 void WorldSession::HandleCharEnum(QueryResult
* result
)
119 // keys can be non cleared if player open realm list and close it by 'cancel'
120 loginDatabase
.PExecute("UPDATE account SET v = '0', s = '0' WHERE id = '%u'", GetAccountId());
122 WorldPacket
data(SMSG_CHAR_ENUM
, 100); // we guess size
130 Player
*plr
= new Player(this);
133 uint32 guidlow
= (*result
)[0].GetUInt32();
134 sLog
.outDetail("Loading char guid %u from account %u.",guidlow
,GetAccountId());
136 if(plr
->MinimalLoadFromDB( result
, guidlow
))
138 plr
->BuildEnumData( result
, &data
);
142 while( result
->NextRow() );
148 data
.put
<uint8
>(0, num
);
153 void WorldSession::HandleCharEnumOpcode( WorldPacket
& /*recv_data*/ )
155 /// get all the data necessary for loading all characters (along with their pets) on the account
156 CharacterDatabase
.AsyncPQuery(&chrHandler
, &CharacterHandler::HandleCharEnumCallback
, GetAccountId(),
157 !sWorld
.getConfig(CONFIG_DECLINED_NAMES_USED
) ?
158 // ------- Query Without Declined Names --------
160 "SELECT characters.guid, characters.data, characters.name, characters.position_x, characters.position_y, characters.position_z, characters.map, characters.totaltime, characters.leveltime, "
162 "characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, guild_member.guildid "
163 "FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' "
164 "LEFT JOIN guild_member ON characters.guid = guild_member.guid "
165 "WHERE characters.account = '%u' ORDER BY characters.guid"
167 // --------- Query With Declined Names ---------
169 "SELECT characters.guid, characters.data, characters.name, characters.position_x, characters.position_y, characters.position_z, characters.map, characters.totaltime, characters.leveltime, "
171 "characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, guild_member.guildid, genitive "
172 "FROM characters LEFT JOIN character_pet ON characters.guid = character_pet.owner AND character_pet.slot='0' "
173 "LEFT JOIN character_declinedname ON characters.guid = character_declinedname.guid "
174 "LEFT JOIN guild_member ON characters.guid = guild_member.guid "
175 "WHERE characters.account = '%u' ORDER BY characters.guid",
179 void WorldSession::HandleCharCreateOpcode( WorldPacket
& recv_data
)
181 CHECK_PACKET_SIZE(recv_data
,1+1+1+1+1+1+1+1+1+1);
188 // recheck with known string size
189 CHECK_PACKET_SIZE(recv_data
,(name
.size()+1)+1+1+1+1+1+1+1+1+1);
194 WorldPacket
data(SMSG_CHAR_CREATE
, 1); // returned with diff.values in all cases
196 if(GetSecurity() == SEC_PLAYER
)
198 if(uint32 mask
= sWorld
.getConfig(CONFIG_CHARACTERS_CREATING_DISABLED
))
200 bool disabled
= false;
202 uint32 team
= Player::TeamForRace(race_
);
205 case ALLIANCE
: disabled
= mask
& (1<<0); break;
206 case HORDE
: disabled
= mask
& (1<<1); break;
211 data
<< (uint8
)CHAR_CREATE_DISABLED
;
218 ChrClassesEntry
const* classEntry
= sChrClassesStore
.LookupEntry(class_
);
219 ChrRacesEntry
const* raceEntry
= sChrRacesStore
.LookupEntry(race_
);
221 if( !classEntry
|| !raceEntry
)
223 data
<< (uint8
)CHAR_CREATE_FAILED
;
225 sLog
.outError("Class: %u or Race %u not found in DBC (Wrong DBC files?) or Cheater?", class_
, race_
);
229 // prevent character creating Expansion race without Expansion account
230 if (raceEntry
->addon
> Expansion())
232 data
<< (uint8
)CHAR_CREATE_EXPANSION
;
233 sLog
.outError("Expansion %u account:[%d] tried to Create character with expansion %u race (%u)",Expansion(),GetAccountId(),raceEntry
->addon
,race_
);
238 // prevent character creating Expansion class without Expansion account
239 if (classEntry
->addon
> Expansion())
241 data
<< (uint8
)CHAR_CREATE_EXPANSION_CLASS
;
242 sLog
.outError("Expansion %u account:[%d] tried to Create character with expansion %u class (%u)",Expansion(),GetAccountId(),classEntry
->addon
,class_
);
247 // prevent character creating with invalid name
248 if(!normalizePlayerName(name
))
250 data
<< (uint8
)CHAR_NAME_INVALID_CHARACTER
;
252 sLog
.outError("Account:[%d] but tried to Create character with empty [name] ",GetAccountId());
256 // check name limitations
257 if(!ObjectMgr::IsValidName(name
,true))
259 data
<< (uint8
)CHAR_NAME_INVALID_CHARACTER
;
264 if(GetSecurity() == SEC_PLAYER
&& objmgr
.IsReservedName(name
))
266 data
<< (uint8
)CHAR_NAME_RESERVED
;
271 if(objmgr
.GetPlayerGUIDByName(name
))
273 data
<< (uint8
)CHAR_CREATE_NAME_IN_USE
;
278 QueryResult
*resultacct
= loginDatabase
.PQuery("SELECT SUM(numchars) FROM realmcharacters WHERE acctid = '%d'", GetAccountId());
281 Field
*fields
=resultacct
->Fetch();
282 uint32 acctcharcount
= fields
[0].GetUInt32();
285 if (acctcharcount
>= sWorld
.getConfig(CONFIG_CHARACTERS_PER_ACCOUNT
))
287 data
<< (uint8
)CHAR_CREATE_ACCOUNT_LIMIT
;
293 QueryResult
*result
= CharacterDatabase
.PQuery("SELECT COUNT(guid) FROM characters WHERE account = '%d'", GetAccountId());
297 Field
*fields
=result
->Fetch();
298 charcount
= fields
[0].GetUInt8();
301 if (charcount
>= sWorld
.getConfig(CONFIG_CHARACTERS_PER_REALM
))
303 data
<< (uint8
)CHAR_CREATE_SERVER_LIMIT
;
309 bool AllowTwoSideAccounts
= !sWorld
.IsPvPRealm() || sWorld
.getConfig(CONFIG_ALLOW_TWO_SIDE_ACCOUNTS
) || GetSecurity() > SEC_PLAYER
;
310 uint32 skipCinematics
= sWorld
.getConfig(CONFIG_SKIP_CINEMATICS
);
312 bool have_same_race
= false;
313 if(!AllowTwoSideAccounts
|| skipCinematics
== 1 || class_
== CLASS_DEATH_KNIGHT
)
315 QueryResult
*result2
= CharacterDatabase
.PQuery("SELECT race,class FROM characters WHERE account = '%u' %s",
316 GetAccountId(), (skipCinematics
== 1 || class_
== CLASS_DEATH_KNIGHT
) ? "" : "LIMIT 1");
319 uint32 team_
= Player::TeamForRace(race_
);
321 Field
* field
= result2
->Fetch();
322 uint8 acc_race
= field
[0].GetUInt32();
324 if(class_
== CLASS_DEATH_KNIGHT
)
326 uint8 acc_class
= field
[1].GetUInt32();
327 if(acc_class
== CLASS_DEATH_KNIGHT
)
329 data
<< (uint8
)CHAR_CREATE_UNIQUE_CLASS_LIMIT
;
335 // need to check team only for first character
336 // TODO: what to if account already has characters of both races?
337 if (!AllowTwoSideAccounts
)
341 acc_team
= Player::TeamForRace(acc_race
);
343 if(acc_team
!= team_
)
345 data
<< (uint8
)CHAR_CREATE_PVP_TEAMS_VIOLATION
;
352 // search same race for cinematic or same class if need
353 // TODO: check if cinematic already shown? (already logged in?; cinematic field)
354 while ((skipCinematics
== 1 && !have_same_race
) || class_
== CLASS_DEATH_KNIGHT
)
356 if(!result2
->NextRow())
359 field
= result2
->Fetch();
360 acc_race
= field
[0].GetUInt32();
363 have_same_race
= race_
== acc_race
;
365 if(class_
== CLASS_DEATH_KNIGHT
)
367 uint8 acc_class
= field
[1].GetUInt32();
368 if(acc_class
== CLASS_DEATH_KNIGHT
)
370 data
<< (uint8
)CHAR_CREATE_UNIQUE_CLASS_LIMIT
;
380 // extract other data required for player creating
381 uint8 gender
, skin
, face
, hairStyle
, hairColor
, facialHair
, outfitId
;
382 recv_data
>> gender
>> skin
>> face
;
383 recv_data
>> hairStyle
>> hairColor
>> facialHair
>> outfitId
;
385 Player
* pNewChar
= new Player(this);
386 if(!pNewChar
->Create( objmgr
.GenerateLowGuid(HIGHGUID_PLAYER
), name
, race_
, class_
, gender
, skin
, face
, hairStyle
, hairColor
, facialHair
, outfitId
))
388 // Player not create (race/class problem?)
391 data
<< (uint8
)CHAR_CREATE_ERROR
;
397 if(have_same_race
&& skipCinematics
== 1 || skipCinematics
== 2)
398 pNewChar
->setCinematic(1); // not show intro
400 // Player created, save it now
401 pNewChar
->SaveToDB();
404 loginDatabase
.PExecute("DELETE FROM realmcharacters WHERE acctid= '%d' AND realmid = '%d'", GetAccountId(), realmID
);
405 loginDatabase
.PExecute("INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (%u, %u, %u)", charcount
, GetAccountId(), realmID
);
407 delete pNewChar
; // created only to call SaveToDB()
409 data
<< (uint8
)CHAR_CREATE_SUCCESS
;
412 std::string IP_str
= GetRemoteAddress();
413 sLog
.outBasic("Account: %d (IP: %s) Create Character:[%s]",GetAccountId(),IP_str
.c_str(),name
.c_str());
414 sLog
.outChar("Account: %d (IP: %s) Create Character:[%s]",GetAccountId(),IP_str
.c_str(),name
.c_str());
417 void WorldSession::HandleCharDeleteOpcode( WorldPacket
& recv_data
)
419 CHECK_PACKET_SIZE(recv_data
,8);
424 // can't delete loaded character
425 if(objmgr
.GetPlayer(guid
))
428 uint32 accountId
= 0;
432 if(objmgr
.GetGuildByLeader(guid
))
434 WorldPacket
data(SMSG_CHAR_DELETE
, 1);
435 data
<< (uint8
)CHAR_DELETE_FAILED_GUILD_LEADER
;
440 // is arena team captain
441 if(objmgr
.GetArenaTeamByCapitan(guid
))
443 WorldPacket
data(SMSG_CHAR_DELETE
, 1);
444 data
<< (uint8
)CHAR_DELETE_FAILED_ARENA_CAPTAIN
;
449 QueryResult
*result
= CharacterDatabase
.PQuery("SELECT account,name FROM characters WHERE guid='%u'", GUID_LOPART(guid
));
452 Field
*fields
= result
->Fetch();
453 accountId
= fields
[0].GetUInt32();
454 name
= fields
[1].GetCppString();
458 // prevent deleting other players' characters using cheating tools
459 if(accountId
!= GetAccountId())
462 std::string IP_str
= GetRemoteAddress();
463 sLog
.outBasic("Account: %d (IP: %s) Delete Character:[%s] (guid:%u)",GetAccountId(),IP_str
.c_str(),name
.c_str(),GUID_LOPART(guid
));
464 sLog
.outChar("Account: %d (IP: %s) Delete Character:[%s] (guid: %u)",GetAccountId(),IP_str
.c_str(),name
.c_str(),GUID_LOPART(guid
));
466 if(sLog
.IsOutCharDump()) // optimize GetPlayerDump call
468 std::string dump
= PlayerDumpWriter().GetDump(GUID_LOPART(guid
));
469 sLog
.outCharDump(dump
.c_str(),GetAccountId(),GUID_LOPART(guid
),name
.c_str());
472 Player::DeleteFromDB(guid
, GetAccountId());
474 WorldPacket
data(SMSG_CHAR_DELETE
, 1);
475 data
<< (uint8
)CHAR_DELETE_SUCCESS
;
479 void WorldSession::HandlePlayerLoginOpcode( WorldPacket
& recv_data
)
481 CHECK_PACKET_SIZE(recv_data
,8);
483 m_playerLoading
= true;
484 uint64 playerGuid
= 0;
486 DEBUG_LOG( "WORLD: Recvd Player Logon Message" );
488 recv_data
>> playerGuid
;
490 LoginQueryHolder
*holder
= new LoginQueryHolder(GetAccountId(), playerGuid
);
491 if(!holder
->Initialize())
493 delete holder
; // delete all unprocessed queries
494 m_playerLoading
= false;
498 CharacterDatabase
.DelayQueryHolder(&chrHandler
, &CharacterHandler::HandlePlayerLoginCallback
, holder
);
501 void WorldSession::HandlePlayerLogin(LoginQueryHolder
* holder
)
503 uint64 playerGuid
= holder
->GetGuid();
505 Player
* pCurrChar
= new Player(this);
506 pCurrChar
->GetMotionMaster()->Initialize();
508 // "GetAccountId()==db stored account id" checked in LoadFromDB (prevent login not own character using cheating tools)
509 if(!pCurrChar
->LoadFromDB(GUID_LOPART(playerGuid
), holder
))
511 KickPlayer(); // disconnect client, player no set to session and it will not deleted or saved at kick
512 delete pCurrChar
; // delete it manually
513 delete holder
; // delete all unprocessed queries
514 m_playerLoading
= false;
518 SetPlayer(pCurrChar
);
520 pCurrChar
->SendDungeonDifficulty(false);
522 WorldPacket
data( SMSG_LOGIN_VERIFY_WORLD
, 20 );
523 data
<< pCurrChar
->GetMapId();
524 data
<< pCurrChar
->GetPositionX();
525 data
<< pCurrChar
->GetPositionY();
526 data
<< pCurrChar
->GetPositionZ();
527 data
<< pCurrChar
->GetOrientation();
530 data
.Initialize( SMSG_ACCOUNT_DATA_TIMES
, 4+1+8*4 ); // changed in WotLK
531 data
<< uint32(time(NULL
)); // unix time of something
533 for(int i
= 0; i
< NUM_ACCOUNT_DATA_TYPES
; i
++)
534 data
<< uint32(GetAccountData(i
)->Time
); // also unix time
537 data
.Initialize(SMSG_FEATURE_SYSTEM_STATUS
, 2); // added in 2.2.0
538 data
<< uint8(2); // unknown value
539 data
<< uint8(0); // enable(1)/disable(0) voice chat interface in client
544 data
.Initialize(SMSG_MOTD
, 50); // new in 2.0.1
548 std::string str_motd
= sWorld
.GetMotd();
549 std::string::size_type pos
, nextpos
;
552 while ( (nextpos
= str_motd
.find('@',pos
)) != std::string::npos
)
556 data
<< str_motd
.substr(pos
,nextpos
-pos
);
562 if (pos
<str_motd
.length())
564 data
<< str_motd
.substr(pos
);
568 data
.put(0, linecount
);
571 DEBUG_LOG( "WORLD: Sent motd (SMSG_MOTD)" );
574 //QueryResult *result = CharacterDatabase.PQuery("SELECT guildid,rank FROM guild_member WHERE guid = '%u'",pCurrChar->GetGUIDLow());
575 QueryResult
*resultGuild
= holder
->GetResult(PLAYER_LOGIN_QUERY_LOADGUILD
);
579 Field
*fields
= resultGuild
->Fetch();
580 pCurrChar
->SetInGuild(fields
[0].GetUInt32());
581 pCurrChar
->SetRank(fields
[1].GetUInt32());
584 else if(pCurrChar
->GetGuildId()) // clear guild related fields in case wrong data about non existed membership
586 pCurrChar
->SetInGuild(0);
587 pCurrChar
->SetRank(0);
590 if(pCurrChar
->GetGuildId() != 0)
592 Guild
* guild
= objmgr
.GetGuildById(pCurrChar
->GetGuildId());
595 data
.Initialize(SMSG_GUILD_EVENT
, (2+guild
->GetMOTD().size()+1));
596 data
<< (uint8
)GE_MOTD
;
598 data
<< guild
->GetMOTD();
600 DEBUG_LOG( "WORLD: Sent guild-motd (SMSG_GUILD_EVENT)" );
602 data
.Initialize(SMSG_GUILD_EVENT
, (5+10)); // we guess size
603 data
<<(uint8
)GE_SIGNED_ON
;
605 data
<<pCurrChar
->GetName();
606 data
<<pCurrChar
->GetGUID();
607 guild
->BroadcastPacket(&data
);
608 DEBUG_LOG( "WORLD: Sent guild-signed-on (SMSG_GUILD_EVENT)" );
610 // Increment online members of the guild
611 guild
->IncOnlineMemberCount();
615 // remove wrong guild data
616 sLog
.outError("Player %s (GUID: %u) marked as member not existed guild (id: %u), removing guild membership for player.",pCurrChar
->GetName(),pCurrChar
->GetGUIDLow(),pCurrChar
->GetGuildId());
617 pCurrChar
->SetInGuild(0);
621 if(!pCurrChar
->isAlive())
622 pCurrChar
->SendCorpseReclaimDelay(true);
624 pCurrChar
->SendInitialPacketsBeforeAddToMap();
626 //Show cinematic at the first time that player login
627 if( !pCurrChar
->getCinematic() )
629 pCurrChar
->setCinematic(1);
631 if(ChrClassesEntry
const* cEntry
= sChrClassesStore
.LookupEntry(pCurrChar
->getClass()))
633 if(cEntry
->CinematicSequence
)
635 data
.Initialize(SMSG_TRIGGER_CINEMATIC
, 4);
636 data
<< uint32(cEntry
->CinematicSequence
);
639 else if(ChrRacesEntry
const* rEntry
= sChrRacesStore
.LookupEntry(pCurrChar
->getRace()))
641 data
.Initialize(SMSG_TRIGGER_CINEMATIC
, 4);
642 data
<< uint32(rEntry
->CinematicSequence
);
648 if (!pCurrChar
->GetMap()->Add(pCurrChar
))
650 AreaTrigger
const* at
= objmgr
.GetGoBackTrigger(pCurrChar
->GetMapId());
652 pCurrChar
->TeleportTo(at
->target_mapId
, at
->target_X
, at
->target_Y
, at
->target_Z
, pCurrChar
->GetOrientation());
654 pCurrChar
->TeleportTo(pCurrChar
->m_homebindMapId
, pCurrChar
->m_homebindX
, pCurrChar
->m_homebindY
, pCurrChar
->m_homebindZ
, pCurrChar
->GetOrientation());
657 ObjectAccessor::Instance().AddObject(pCurrChar
);
658 //sLog.outDebug("Player %s added to Map.",pCurrChar->GetName());
659 pCurrChar
->GetSocial()->SendSocialList();
661 pCurrChar
->SendInitialPacketsAfterAddToMap();
663 CharacterDatabase
.PExecute("UPDATE characters SET online = 1 WHERE guid = '%u'", pCurrChar
->GetGUIDLow());
664 loginDatabase
.PExecute("UPDATE account SET online = 1 WHERE id = '%u'", GetAccountId());
665 pCurrChar
->SetInGameTime( getMSTime() );
667 // announce group about member online (must be after add to player list to receive announce to self)
668 if(Group
*group
= pCurrChar
->GetGroup())
670 //pCurrChar->groupInfo.group->SendInit(this); // useless
675 sSocialMgr
.SendFriendStatus(pCurrChar
, FRIEND_ONLINE
, pCurrChar
->GetGUIDLow(), true);
677 // Place character in world (and load zone) before some object loading
678 pCurrChar
->LoadCorpse();
680 // setting Ghost+speed if dead
681 if (pCurrChar
->m_deathState
!= ALIVE
)
683 // not blizz like, we must correctly save and load player instead...
684 if(pCurrChar
->getRace() == RACE_NIGHTELF
)
685 pCurrChar
->CastSpell(pCurrChar
, 20584, true, 0);// auras SPELL_AURA_INCREASE_SPEED(+speed in wisp form), SPELL_AURA_INCREASE_SWIM_SPEED(+swim speed in wisp form), SPELL_AURA_TRANSFORM (to wisp form)
686 pCurrChar
->CastSpell(pCurrChar
, 8326, true, 0); // auras SPELL_AURA_GHOST, SPELL_AURA_INCREASE_SPEED(why?), SPELL_AURA_INCREASE_SWIM_SPEED(why?)
688 pCurrChar
->SetMovement(MOVE_WATER_WALK
);
691 if(uint32 sourceNode
= pCurrChar
->m_taxi
.GetTaxiSource())
694 sLog
.outDebug( "WORLD: Restart character %u taxi flight", pCurrChar
->GetGUIDLow() );
696 uint32 MountId
= objmgr
.GetTaxiMount(sourceNode
, pCurrChar
->GetTeam());
697 uint32 path
= pCurrChar
->m_taxi
.GetCurrentTaxiPath();
699 // search appropriate start path node
700 uint32 startNode
= 0;
702 TaxiPathNodeList
const& nodeList
= sTaxiPathNodesByPath
[path
];
704 float distPrev
= MAP_SIZE
*MAP_SIZE
;
706 (nodeList
[0].x
-pCurrChar
->GetPositionX())*(nodeList
[0].x
-pCurrChar
->GetPositionX())+
707 (nodeList
[0].y
-pCurrChar
->GetPositionY())*(nodeList
[0].y
-pCurrChar
->GetPositionY())+
708 (nodeList
[0].z
-pCurrChar
->GetPositionZ())*(nodeList
[0].z
-pCurrChar
->GetPositionZ());
710 for(uint32 i
= 1; i
< nodeList
.size(); ++i
)
712 TaxiPathNode
const& node
= nodeList
[i
];
713 TaxiPathNode
const& prevNode
= nodeList
[i
-1];
715 // skip nodes at another map
716 if(node
.mapid
!= pCurrChar
->GetMapId())
722 (node
.x
-pCurrChar
->GetPositionX())*(node
.x
-pCurrChar
->GetPositionX())+
723 (node
.y
-pCurrChar
->GetPositionY())*(node
.y
-pCurrChar
->GetPositionY())+
724 (node
.z
-pCurrChar
->GetPositionZ())*(node
.z
-pCurrChar
->GetPositionZ());
727 (node
.x
-prevNode
.x
)*(node
.x
-prevNode
.x
)+
728 (node
.y
-prevNode
.y
)*(node
.y
-prevNode
.y
)+
729 (node
.z
-prevNode
.z
)*(node
.z
-prevNode
.z
);
731 if(distNext
+ distPrev
< distNodes
)
738 SendDoFlight( MountId
, path
, startNode
);
741 // Load pet if any and player is alive and not in taxi flight
742 if(pCurrChar
->isAlive() && pCurrChar
->m_taxi
.GetTaxiSource()==0)
743 pCurrChar
->LoadPet();
745 // Set FFA PvP for non GM in non-rest mode
746 if(sWorld
.IsFFAPvPRealm() && !pCurrChar
->isGameMaster() && !pCurrChar
->HasFlag(PLAYER_FLAGS
,PLAYER_FLAGS_RESTING
) )
747 pCurrChar
->SetFlag(PLAYER_FLAGS
,PLAYER_FLAGS_FFA_PVP
);
749 if(pCurrChar
->HasFlag(PLAYER_FLAGS
, PLAYER_FLAGS_CONTESTED_PVP
))
750 pCurrChar
->SetContestedPvP();
752 // Apply at_login requests
753 if(pCurrChar
->HasAtLoginFlag(AT_LOGIN_RESET_SPELLS
))
755 pCurrChar
->resetSpells();
756 SendNotification(LANG_RESET_SPELLS
);
759 if(pCurrChar
->HasAtLoginFlag(AT_LOGIN_RESET_TALENTS
))
761 pCurrChar
->resetTalents(true);
762 SendNotification(LANG_RESET_TALENTS
);
765 // show time before shutdown if shutdown planned.
766 if(sWorld
.IsShutdowning())
767 sWorld
.ShutdownMsg(true,pCurrChar
);
769 if(sWorld
.getConfig(CONFIG_ALL_TAXI_PATHS
))
770 pCurrChar
->SetTaxiCheater(true);
772 if(pCurrChar
->isGameMaster())
773 SendNotification(LANG_GM_ON
);
775 std::string IP_str
= GetRemoteAddress();
776 sLog
.outChar("Account: %d (IP: %s) Login Character:[%s] (guid:%u)",
777 GetAccountId(),IP_str
.c_str(),pCurrChar
->GetName() ,pCurrChar
->GetGUIDLow());
779 m_playerLoading
= false;
783 void WorldSession::HandleSetFactionAtWar( WorldPacket
& recv_data
)
785 CHECK_PACKET_SIZE(recv_data
,4+1);
787 DEBUG_LOG( "WORLD: Received CMSG_SET_FACTION_ATWAR" );
792 recv_data
>> repListID
;
795 FactionStateList::iterator itr
= GetPlayer()->m_factions
.find(repListID
);
796 if (itr
== GetPlayer()->m_factions
.end())
799 // always invisible or hidden faction can't change war state
800 if(itr
->second
.Flags
& (FACTION_FLAG_INVISIBLE_FORCED
|FACTION_FLAG_HIDDEN
) )
803 GetPlayer()->SetFactionAtWar(&itr
->second
,flag
);
806 //I think this function is never used :/ I dunno, but i guess this opcode not exists
807 void WorldSession::HandleSetFactionCheat( WorldPacket
& /*recv_data*/ )
809 //CHECK_PACKET_SIZE(recv_data,4+4);
811 //sLog.outDebug("WORLD SESSION: HandleSetFactionCheat");
816 recv_data >> FactionID;
817 recv_data >> Standing;
819 std::list<struct Factions>::iterator itr;
821 for(itr = GetPlayer()->factions.begin(); itr != GetPlayer()->factions.end(); ++itr)
823 if(itr->ReputationListID == FactionID)
825 itr->Standing += Standing;
826 itr->Flags = (itr->Flags | 1);
831 GetPlayer()->UpdateReputation();
834 void WorldSession::HandleMeetingStoneInfo( WorldPacket
& /*recv_data*/ )
836 DEBUG_LOG( "WORLD: Received CMSG_MEETING_STONE_INFO" );
838 WorldPacket
data(SMSG_MEETINGSTONE_SETQUEUE
, 5);
839 data
<< uint32(0) << uint8(6);
843 void WorldSession::HandleTutorialFlag( WorldPacket
& recv_data
)
845 CHECK_PACKET_SIZE(recv_data
,4);
850 uint32 wInt
= (iFlag
/ 32);
853 //sLog.outError("CHEATER? Account:[%d] Guid[%u] tried to send wrong CMSG_TUTORIAL_FLAG", GetAccountId(),GetGUID());
856 uint32 rInt
= (iFlag
% 32);
858 uint32 tutflag
= GetPlayer()->GetTutorialInt( wInt
);
859 tutflag
|= (1 << rInt
);
860 GetPlayer()->SetTutorialInt( wInt
, tutflag
);
862 //sLog.outDebug("Received Tutorial Flag Set {%u}.", iFlag);
865 void WorldSession::HandleTutorialClear( WorldPacket
& /*recv_data*/ )
867 for ( uint32 iI
= 0; iI
< 8; iI
++)
868 GetPlayer()->SetTutorialInt( iI
, 0xFFFFFFFF );
871 void WorldSession::HandleTutorialReset( WorldPacket
& /*recv_data*/ )
873 for ( uint32 iI
= 0; iI
< 8; iI
++)
874 GetPlayer()->SetTutorialInt( iI
, 0x00000000 );
877 void WorldSession::HandleSetWatchedFactionIndexOpcode(WorldPacket
& recv_data
)
879 CHECK_PACKET_SIZE(recv_data
,4);
881 DEBUG_LOG("WORLD: Received CMSG_SET_WATCHED_FACTION");
884 GetPlayer()->SetUInt32Value(PLAYER_FIELD_WATCHED_FACTION_INDEX
, fact
);
887 void WorldSession::HandleSetWatchedFactionInactiveOpcode(WorldPacket
& recv_data
)
889 CHECK_PACKET_SIZE(recv_data
,4+1);
891 DEBUG_LOG("WORLD: Received CMSG_SET_FACTION_INACTIVE");
894 recv_data
>> replistid
>> inactive
;
896 FactionStateList::iterator itr
= _player
->m_factions
.find(replistid
);
897 if (itr
== _player
->m_factions
.end())
900 _player
->SetFactionInactive(&itr
->second
, inactive
);
903 void WorldSession::HandleToggleHelmOpcode( WorldPacket
& /*recv_data*/ )
905 DEBUG_LOG("CMSG_TOGGLE_HELM for %s", _player
->GetName());
906 _player
->ToggleFlag(PLAYER_FLAGS
, PLAYER_FLAGS_HIDE_HELM
);
909 void WorldSession::HandleToggleCloakOpcode( WorldPacket
& /*recv_data*/ )
911 DEBUG_LOG("CMSG_TOGGLE_CLOAK for %s", _player
->GetName());
912 _player
->ToggleFlag(PLAYER_FLAGS
, PLAYER_FLAGS_HIDE_CLOAK
);
915 void WorldSession::HandleChangePlayerNameOpcode(WorldPacket
& recv_data
)
917 CHECK_PACKET_SIZE(recv_data
,8+1);
923 CHECK_PACKET_SIZE(recv_data
, 8+1);
926 recv_data
>> newname
;
928 QueryResult
*result
= CharacterDatabase
.PQuery("SELECT at_login FROM characters WHERE guid ='%u'", GUID_LOPART(guid
));
931 uint32 at_loginFlags
;
932 Field
*fields
= result
->Fetch();
933 at_loginFlags
= fields
[0].GetUInt32();
936 if (!(at_loginFlags
& AT_LOGIN_RENAME
))
938 WorldPacket
data(SMSG_CHAR_RENAME
, 1);
939 data
<< (uint8
)CHAR_CREATE_ERROR
;
946 WorldPacket
data(SMSG_CHAR_RENAME
, 1);
947 data
<< (uint8
)CHAR_CREATE_ERROR
;
952 if(!objmgr
.GetPlayerNameByGUID(guid
, oldname
)) // character not exist, because we have no name for this guid
954 WorldPacket
data(SMSG_CHAR_RENAME
, 1);
955 data
<< (uint8
)CHAR_LOGIN_NO_CHARACTER
;
960 // prevent character rename to invalid name
961 if(!normalizePlayerName(newname
))
963 WorldPacket
data(SMSG_CHAR_RENAME
, 1);
964 data
<< (uint8
)CHAR_NAME_NO_NAME
;
969 if(!ObjectMgr::IsValidName(newname
,true))
971 WorldPacket
data(SMSG_CHAR_RENAME
, 1);
972 data
<< (uint8
)CHAR_NAME_INVALID_CHARACTER
;
977 // check name limitations
978 if(GetSecurity() == SEC_PLAYER
&& objmgr
.IsReservedName(newname
))
980 WorldPacket
data(SMSG_CHAR_RENAME
, 1);
981 data
<< (uint8
)CHAR_NAME_RESERVED
;
986 if(objmgr
.GetPlayerGUIDByName(newname
)) // character with this name already exist
988 WorldPacket
data(SMSG_CHAR_RENAME
, 1);
989 data
<< (uint8
)CHAR_CREATE_ERROR
;
994 if(newname
== oldname
) // checked by client
996 WorldPacket
data(SMSG_CHAR_RENAME
, 1);
997 data
<< (uint8
)CHAR_NAME_FAILURE
;
1002 // we have to check character at_login_flag & AT_LOGIN_RENAME also (fake packets hehe)
1004 CharacterDatabase
.escape_string(newname
);
1005 CharacterDatabase
.PExecute("UPDATE characters set name = '%s', at_login = at_login & ~ %u WHERE guid ='%u'", newname
.c_str(), uint32(AT_LOGIN_RENAME
),GUID_LOPART(guid
));
1006 CharacterDatabase
.PExecute("DELETE FROM character_declinedname WHERE guid ='%u'", GUID_LOPART(guid
));
1008 std::string IP_str
= GetRemoteAddress();
1009 sLog
.outChar("Account: %d (IP: %s) Character:[%s] (guid:%u) Changed name to: %s",GetAccountId(),IP_str
.c_str(),oldname
.c_str(),GUID_LOPART(guid
),newname
.c_str());
1011 WorldPacket
data(SMSG_CHAR_RENAME
,1+8+(newname
.size()+1));
1012 data
<< (uint8
)RESPONSE_SUCCESS
;
1018 void WorldSession::HandleDeclinedPlayerNameOpcode(WorldPacket
& recv_data
)
1022 CHECK_PACKET_SIZE(recv_data
, 8);
1025 // not accept declined names for unsupported languages
1027 if(!objmgr
.GetPlayerNameByGUID(guid
, name
))
1029 WorldPacket
data(SMSG_SET_PLAYER_DECLINED_NAMES_RESULT
, 4+8);
1031 data
<< uint64(guid
);
1037 if(!Utf8toWStr(name
, wname
))
1039 WorldPacket
data(SMSG_SET_PLAYER_DECLINED_NAMES_RESULT
, 4+8);
1041 data
<< uint64(guid
);
1046 if(!isCyrillicCharacter(wname
[0])) // name already stored as only single alphabet using
1048 WorldPacket
data(SMSG_SET_PLAYER_DECLINED_NAMES_RESULT
, 4+8);
1050 data
<< uint64(guid
);
1056 DeclinedName declinedname
;
1058 CHECK_PACKET_SIZE(recv_data
, recv_data
.rpos() + 1);
1061 if(name2
!= name
) // character have different name
1063 WorldPacket
data(SMSG_SET_PLAYER_DECLINED_NAMES_RESULT
, 4+8);
1065 data
<< uint64(guid
);
1070 for(int i
= 0; i
< MAX_DECLINED_NAME_CASES
; ++i
)
1072 CHECK_PACKET_SIZE(recv_data
, recv_data
.rpos() + 1);
1073 recv_data
>> declinedname
.name
[i
];
1074 if(!normalizePlayerName(declinedname
.name
[i
]))
1076 WorldPacket
data(SMSG_SET_PLAYER_DECLINED_NAMES_RESULT
, 4+8);
1078 data
<< uint64(guid
);
1084 if(!ObjectMgr::CheckDeclinedNames(GetMainPartOfName(wname
, 0), declinedname
))
1086 WorldPacket
data(SMSG_SET_PLAYER_DECLINED_NAMES_RESULT
, 4+8);
1088 data
<< uint64(guid
);
1093 for(int i
= 0; i
< MAX_DECLINED_NAME_CASES
; ++i
)
1094 CharacterDatabase
.escape_string(declinedname
.name
[i
]);
1096 CharacterDatabase
.BeginTransaction();
1097 CharacterDatabase
.PExecute("DELETE FROM character_declinedname WHERE guid = '%u'", GUID_LOPART(guid
));
1098 CharacterDatabase
.PExecute("INSERT INTO character_declinedname (guid, genitive, dative, accusative, instrumental, prepositional) VALUES ('%u','%s','%s','%s','%s','%s')",
1099 GUID_LOPART(guid
), declinedname
.name
[0].c_str(), declinedname
.name
[1].c_str(), declinedname
.name
[2].c_str(), declinedname
.name
[3].c_str(), declinedname
.name
[4].c_str());
1100 CharacterDatabase
.CommitTransaction();
1102 WorldPacket
data(SMSG_SET_PLAYER_DECLINED_NAMES_RESULT
, 4+8);
1103 data
<< uint32(0); // OK
1104 data
<< uint64(guid
);
1108 void WorldSession::HandleAlterAppearance( WorldPacket
& recv_data
)
1110 sLog
.outDebug("CMSG_ALTER_APPEARANCE");
1112 CHECK_PACKET_SIZE(recv_data
, 4+4+4);
1114 uint32 Hair
, Color
, FacialHair
;
1115 recv_data
>> Hair
>> Color
>> FacialHair
;
1117 BarberShopStyleEntry
const* bs_hair
= sBarberShopStyleStore
.LookupEntry(Hair
);
1119 if(!bs_hair
|| bs_hair
->type
!= 0 || bs_hair
->race
!= _player
->getRace() || bs_hair
->gender
!= _player
->getGender())
1122 BarberShopStyleEntry
const* bs_facialHair
= sBarberShopStyleStore
.LookupEntry(FacialHair
);
1124 if(!bs_facialHair
|| bs_facialHair
->type
!= 2 || bs_facialHair
->race
!= _player
->getRace() || bs_facialHair
->gender
!= _player
->getGender())
1127 uint32 Cost
= _player
->GetBarberShopCost(bs_hair
->hair_id
, Color
, bs_facialHair
->hair_id
);
1130 // 1,3 - not enough money
1131 // 2 - you have to seat on barber chair
1132 if(_player
->GetMoney() < Cost
)
1134 WorldPacket
data(SMSG_BARBER_SHOP_RESULT
, 4);
1135 data
<< uint32(1); // no money
1141 WorldPacket
data(SMSG_BARBER_SHOP_RESULT
, 4);
1142 data
<< uint32(0); // ok
1146 _player
->SetMoney(_player
->GetMoney() - Cost
); // it isn't free
1148 _player
->SetByteValue(PLAYER_BYTES
, 2, uint8(bs_hair
->hair_id
));
1149 _player
->SetByteValue(PLAYER_BYTES
, 3, uint8(Color
));
1150 _player
->SetByteValue(PLAYER_BYTES_2
, 0, uint8(bs_facialHair
->hair_id
));
1152 _player
->GetAchievementMgr().UpdateAchievementCriteria(ACHIEVEMENT_CRITERIA_TYPE_VISIT_BARBER_SHOP
, 1);
1154 _player
->SetStandState(0); // stand up
1157 void WorldSession::HandleRemoveGlyph( WorldPacket
& recv_data
)
1159 CHECK_PACKET_SIZE(recv_data
, 4);
1166 sLog
.outDebug("Client sent wrong glyph slot number in opcode CMSG_REMOVE_GLYPH %u", slot
);
1170 if(uint32 glyph
= _player
->GetGlyph(slot
))
1172 if(GlyphPropertiesEntry
const *gp
= sGlyphPropertiesStore
.LookupEntry(glyph
))
1174 _player
->RemoveAurasDueToSpell(gp
->SpellId
);
1175 _player
->SetGlyph(slot
, 0);