[2008_10_31_01_mangos_creature_template.sql] Creature related code and DB cleanups.
[getmangos.git] / src / game / QueryHandler.cpp
blob713338c51ce2d1db8b070f27330a7e1a7604839a
1 /*
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
19 #include "Common.h"
20 #include "Language.h"
21 #include "Database/DatabaseEnv.h"
22 #include "Database/DatabaseImpl.h"
23 #include "WorldPacket.h"
24 #include "WorldSession.h"
25 #include "Opcodes.h"
26 #include "Log.h"
27 #include "World.h"
28 #include "ObjectMgr.h"
29 #include "Player.h"
30 #include "UpdateMask.h"
31 #include "NPCHandler.h"
32 #include "ObjectAccessor.h"
33 #include "Pet.h"
35 void WorldSession::SendNameQueryOpcode(Player *p)
37 if(!p)
38 return;
40 // guess size
41 WorldPacket data( SMSG_NAME_QUERY_RESPONSE, (8+1+4+4+4+10) );
42 data << p->GetGUID();
43 data << p->GetName();
44 data << uint8(0); // realm name for cross realm BG usage
45 data << uint32(p->getRace());
46 data << uint32(p->getGender());
47 data << uint32(p->getClass());
48 if(DeclinedName const* names = p->GetDeclinedNames())
50 data << uint8(1); // is declined
51 for(int i = 0; i < MAX_DECLINED_NAME_CASES; ++i)
52 data << names->name[i];
54 else
55 data << uint8(0); // is not declined
57 SendPacket(&data);
60 void WorldSession::SendNameQueryOpcodeFromDB(uint64 guid)
62 CharacterDatabase.AsyncPQuery(&WorldSession::SendNameQueryOpcodeFromDBCallBack, GetAccountId(),
63 !sWorld.getConfig(CONFIG_DECLINED_NAMES_USED) ?
64 // ------- Query Without Declined Names --------
65 // 0 1 2
66 "SELECT guid, name, SUBSTRING(data, LENGTH(SUBSTRING_INDEX(data, ' ', '%u'))+2, LENGTH(SUBSTRING_INDEX(data, ' ', '%u')) - LENGTH(SUBSTRING_INDEX(data, ' ', '%u'))-1) "
67 "FROM characters WHERE guid = '%u'"
69 // --------- Query With Declined Names ---------
70 // 0 1 2
71 "SELECT characters.guid, name, SUBSTRING(data, LENGTH(SUBSTRING_INDEX(data, ' ', '%u'))+2, LENGTH(SUBSTRING_INDEX(data, ' ', '%u')) - LENGTH(SUBSTRING_INDEX(data, ' ', '%u'))-1), "
72 // 3 4 5 6 7
73 "genitive, dative, accusative, instrumental, prepositional "
74 "FROM characters LEFT JOIN character_declinedname ON characters.guid = character_declinedname.guid WHERE characters.guid = '%u'",
75 UNIT_FIELD_BYTES_0, UNIT_FIELD_BYTES_0+1, UNIT_FIELD_BYTES_0, GUID_LOPART(guid));
78 void WorldSession::SendNameQueryOpcodeFromDBCallBack(QueryResult *result, uint32 accountId)
80 if(!result)
81 return;
83 WorldSession * session = sWorld.FindSession(accountId);
84 if(!session)
86 delete result;
87 return;
90 Field *fields = result->Fetch();
91 uint32 guid = fields[0].GetUInt32();
92 std::string name = fields[1].GetCppString();
93 uint32 field = 0;
94 if(name == "")
95 name = session->GetMangosString(LANG_NON_EXIST_CHARACTER);
96 else
97 field = fields[2].GetUInt32();
99 // guess size
100 WorldPacket data( SMSG_NAME_QUERY_RESPONSE, (8+1+4+4+4+10) );
101 data << MAKE_NEW_GUID(guid, 0, HIGHGUID_PLAYER);
102 data << name;
103 data << (uint8)0;
104 data << (uint32)(field & 0xFF);
105 data << (uint32)((field >> 16) & 0xFF);
106 data << (uint32)((field >> 8) & 0xFF);
108 // if the first declined name field (3) is empty, the rest must be too
109 if(sWorld.getConfig(CONFIG_DECLINED_NAMES_USED) && fields[3].GetCppString() != "")
111 data << (uint8)1; // is declined
112 for(int i = 3; i < MAX_DECLINED_NAME_CASES+3; ++i)
113 data << fields[i].GetCppString();
115 else
116 data << (uint8)0; // is declined
118 session->SendPacket( &data );
119 delete result;
122 void WorldSession::HandleNameQueryOpcode( WorldPacket & recv_data )
124 CHECK_PACKET_SIZE(recv_data,8);
126 uint64 guid;
128 recv_data >> guid;
130 Player *pChar = objmgr.GetPlayer(guid);
132 if (pChar)
133 SendNameQueryOpcode(pChar);
134 else
135 SendNameQueryOpcodeFromDB(guid);
138 void WorldSession::HandleQueryTimeOpcode( WorldPacket & /*recv_data*/ )
140 WorldPacket data( SMSG_QUERY_TIME_RESPONSE, 4+4 );
141 data << (uint32)time(NULL);
142 data << (uint32)0;
143 SendPacket( &data );
146 /// Only _static_ data send in this packet !!!
147 void WorldSession::HandleCreatureQueryOpcode( WorldPacket & recv_data )
149 CHECK_PACKET_SIZE(recv_data,4+8);
151 uint32 entry;
152 recv_data >> entry;
154 CreatureInfo const *ci = objmgr.GetCreatureTemplate(entry);
155 if (ci)
158 std::string Name, SubName;
159 Name = ci->Name;
160 SubName = ci->SubName;
162 int loc_idx = GetSessionDbLocaleIndex();
163 if (loc_idx >= 0)
165 CreatureLocale const *cl = objmgr.GetCreatureLocale(entry);
166 if (cl)
168 if (cl->Name.size() > loc_idx && !cl->Name[loc_idx].empty())
169 Name = cl->Name[loc_idx];
170 if (cl->SubName.size() > loc_idx && !cl->SubName[loc_idx].empty())
171 SubName = cl->SubName[loc_idx];
174 sLog.outDetail("WORLD: CMSG_CREATURE_QUERY '%s' - Entry: %u.", ci->Name, entry);
175 // guess size
176 WorldPacket data( SMSG_CREATURE_QUERY_RESPONSE, 100 );
177 data << (uint32)entry; // creature entry
178 data << Name;
179 data << uint8(0) << uint8(0) << uint8(0); // name2, name3, name4, always empty
180 data << SubName;
181 data << ci->IconName; // "Directions" for guard, string for Icons 2.3.0
182 data << (uint32)ci->type_flags; // flags wdbFeild7=wad flags1
183 data << (uint32)ci->type;
184 data << (uint32)ci->family; // family wdbFeild9
185 data << (uint32)ci->rank; // rank wdbFeild10
186 data << (uint32)0; // unknown wdbFeild11
187 data << (uint32)ci->PetSpellDataId; // Id from CreatureSpellData.dbc wdbField12
188 data << (uint32)ci->DisplayID_A; // modelid_male1
189 data << (uint32)ci->DisplayID_H; // modelid_female1 ?
190 data << (uint32)ci->DisplayID_A2; // modelid_male2 ?
191 data << (uint32)ci->DisplayID_H2; // modelid_femmale2 ?
192 data << (float)1.0f; // unk
193 data << (float)1.0f; // unk
194 data << (uint8)ci->RacialLeader;
195 SendPacket( &data );
196 sLog.outDebug( "WORLD: Sent SMSG_CREATURE_QUERY_RESPONSE " );
198 else
200 uint64 guid;
201 recv_data >> guid;
203 sLog.outDebug( "WORLD: CMSG_CREATURE_QUERY - (%u) NO CREATURE INFO! (GUID: %u, ENTRY: %u)", uint32(GUID_LOPART(guid)), guid, entry );
204 WorldPacket data( SMSG_CREATURE_QUERY_RESPONSE, 4 );
205 data << uint32(entry | 0x80000000);
206 SendPacket( &data );
207 sLog.outDebug( "WORLD: Sent SMSG_CREATURE_QUERY_RESPONSE " );
211 /// Only _static_ data send in this packet !!!
212 void WorldSession::HandleGameObjectQueryOpcode( WorldPacket & recv_data )
214 CHECK_PACKET_SIZE(recv_data,4+8);
216 uint32 entryID;
217 recv_data >> entryID;
219 const GameObjectInfo *info = objmgr.GetGameObjectInfo(entryID);
220 if(info)
223 std::string Name;
224 std::string CastBarCaption;
226 Name = info->name;
227 CastBarCaption = info->castBarCaption;
229 int loc_idx = GetSessionDbLocaleIndex();
230 if (loc_idx >= 0)
232 GameObjectLocale const *gl = objmgr.GetGameObjectLocale(entryID);
233 if (gl)
235 if (gl->Name.size() > loc_idx && !gl->Name[loc_idx].empty())
236 Name = gl->Name[loc_idx];
237 if (gl->CastBarCaption.size() > loc_idx && !gl->CastBarCaption[loc_idx].empty())
238 CastBarCaption = gl->CastBarCaption[loc_idx];
241 sLog.outDetail("WORLD: CMSG_GAMEOBJECT_QUERY '%s' - Entry: %u. ", info->name, entryID);
242 WorldPacket data ( SMSG_GAMEOBJECT_QUERY_RESPONSE, 150 );
243 data << entryID;
244 data << (uint32)info->type;
245 data << (uint32)info->displayId;
246 data << Name;
247 data << uint8(0) << uint8(0) << uint8(0); // name2, name3, name4
248 data << uint8(0); // 2.0.3, string
249 data << CastBarCaption; // 2.0.3, string. Text will appear in Cast Bar when using GO (ex: "Collecting")
250 data << uint8(0); // 2.0.3, probably string
251 data.append(info->raw.data,24);
252 data << float(info->size); // go size
253 SendPacket( &data );
254 sLog.outDebug( "WORLD: Sent CMSG_GAMEOBJECT_QUERY " );
256 else
259 uint64 guid;
260 recv_data >> guid;
262 sLog.outDebug( "WORLD: CMSG_GAMEOBJECT_QUERY - (%u) Missing gameobject info for (GUID: %u, ENTRY: %u)", uint32(GUID_LOPART(guid)), guid, entryID );
263 WorldPacket data ( SMSG_GAMEOBJECT_QUERY_RESPONSE, 4 );
264 data << uint32(entryID | 0x80000000);
265 SendPacket( &data );
266 sLog.outDebug( "WORLD: Sent CMSG_GAMEOBJECT_QUERY " );
270 void WorldSession::HandleCorpseQueryOpcode(WorldPacket & /*recv_data*/)
272 sLog.outDetail("WORLD: Received MSG_CORPSE_QUERY");
274 Corpse *corpse = GetPlayer()->GetCorpse();
276 uint8 found = 1;
277 if(!corpse)
278 found = 0;
280 WorldPacket data(MSG_CORPSE_QUERY, (1+found*(5*4)));
281 data << uint8(found);
282 if(found)
284 data << corpse->GetMapId();
285 data << corpse->GetPositionX();
286 data << corpse->GetPositionY();
287 data << corpse->GetPositionZ();
288 data << _player->GetMapId();
290 SendPacket(&data);
293 void WorldSession::HandleNpcTextQueryOpcode( WorldPacket & recv_data )
295 CHECK_PACKET_SIZE(recv_data,4+8);
297 uint32 textID;
298 uint64 guid;
299 GossipText *pGossip;
300 std::string GossipStr;
302 recv_data >> textID;
303 sLog.outDetail("WORLD: CMSG_NPC_TEXT_QUERY ID '%u'", textID);
305 recv_data >> guid;
306 GetPlayer()->SetUInt64Value(UNIT_FIELD_TARGET, guid);
308 pGossip = objmgr.GetGossipText(textID);
310 WorldPacket data( SMSG_NPC_TEXT_UPDATE, 100 ); // guess size
311 data << textID;
313 if (!pGossip)
315 for(uint32 i = 0; i < 8; ++i)
317 data << float(0);
318 data << "Greetings $N";
319 data << "Greetings $N";
320 data << uint32(0);
321 data << uint32(0);
322 data << uint32(0);
323 data << uint32(0);
324 data << uint32(0);
325 data << uint32(0);
326 data << uint32(0);
329 else
331 std::string Text_0[8], Text_1[8];
332 for (int i=0;i<8;i++)
334 Text_0[i]=pGossip->Options[i].Text_0;
335 Text_1[i]=pGossip->Options[i].Text_1;
338 int loc_idx = GetSessionDbLocaleIndex();
339 if (loc_idx >= 0)
341 NpcTextLocale const *nl = objmgr.GetNpcTextLocale(textID);
342 if (nl)
344 for (int i=0;i<8;i++)
346 if (nl->Text_0[i].size() > loc_idx && !nl->Text_0[i][loc_idx].empty())
347 Text_0[i]=nl->Text_0[i][loc_idx];
348 if (nl->Text_1[i].size() > loc_idx && !nl->Text_1[i][loc_idx].empty())
349 Text_1[i]=nl->Text_1[i][loc_idx];
354 for (int i=0; i<8; i++)
356 data << pGossip->Options[i].Probability;
358 if ( Text_0[i].empty() )
359 data << Text_1[i];
360 else
361 data << Text_0[i];
363 if ( Text_1[i].empty() )
364 data << Text_0[i];
365 else
366 data << Text_1[i];
368 data << pGossip->Options[i].Language;
370 data << pGossip->Options[i].Emotes[0]._Delay;
371 data << pGossip->Options[i].Emotes[0]._Emote;
373 data << pGossip->Options[i].Emotes[1]._Delay;
374 data << pGossip->Options[i].Emotes[1]._Emote;
376 data << pGossip->Options[i].Emotes[2]._Delay;
377 data << pGossip->Options[i].Emotes[2]._Emote;
381 SendPacket( &data );
383 sLog.outDebug( "WORLD: Sent SMSG_NPC_TEXT_UPDATE " );
386 void WorldSession::HandlePageQueryOpcode( WorldPacket & recv_data )
388 CHECK_PACKET_SIZE(recv_data,4);
390 uint32 pageID;
392 recv_data >> pageID;
393 sLog.outDetail("WORLD: Received CMSG_PAGE_TEXT_QUERY for pageID '%u'", pageID);
395 while (pageID)
397 PageText const *pPage = sPageTextStore.LookupEntry<PageText>( pageID );
398 // guess size
399 WorldPacket data( SMSG_PAGE_TEXT_QUERY_RESPONSE, 50 );
400 data << pageID;
402 if (!pPage)
404 data << "Item page missing.";
405 data << uint32(0);
406 pageID = 0;
408 else
410 std::string Text = pPage->Text;
412 int loc_idx = GetSessionDbLocaleIndex();
413 if (loc_idx >= 0)
415 PageTextLocale const *pl = objmgr.GetPageTextLocale(pageID);
416 if (pl)
418 if (pl->Text.size() > loc_idx && !pl->Text[loc_idx].empty())
419 Text = pl->Text[loc_idx];
423 data << Text;
424 data << uint32(pPage->Next_Page);
425 pageID = pPage->Next_Page;
427 SendPacket( &data );
429 sLog.outDebug( "WORLD: Sent SMSG_PAGE_TEXT_QUERY_RESPONSE " );