src/game/Level2.cpp

   1 /*
   2  * Copyright (C) 2005,2006 MaNGOS <http://www.mangosproject.org/>
   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 "Database/DatabaseEnv.h"
  21 #include "WorldPacket.h"
  22 #include "WorldSession.h"
  23 #include "World.h"
  24 #include "ObjectMgr.h"
  25 #include "Player.h"
  26 #include "Item.h"
  27 #include "GameObject.h"
  28 #include "Opcodes.h"
  29 #include "Chat.h"
  30 #include "ObjectAccessor.h"
  31 #include "MapManager.h"
  32 #include "Language.h"
  33 #include "World.h"
  34
  35 bool ChatHandler::HandleTargetObjectCommand(const char* args)
  36 {
  37
  38     Player* pl = m_session->GetPlayer();
  39     QueryResult *result;
  40
  41     if(*args)
  42     {
  43         int32 id = atoi((char*)args);
  44         if(id)
  45             result = sDatabase.PQuery("SELECT `guid`, `id`, `position_x`, `position_y`, `position_z`, `orientation`, `map`, (POW(`position_x` - '%f', 2) + POW(`position_y` - '%f', 2) + POW(`position_z` - '%f', 2)) as `order` FROM `gameobject` WHERE `map` = '%i' AND `id` = '%u' ORDER BY `order` ASC LIMIT 1",
  46                 pl->GetPositionX(), pl->GetPositionY(), pl->GetPositionZ(), pl->GetMapId(),id);
  47         else
  48         {
  49             std::string name = args;
  50             sDatabase.escape_string(name);
  51             result = sDatabase.PQuery(
  52                 "SELECT `guid`, `id`, `position_x`, `position_y`, `position_z`, `orientation`, `map`, (POW(`position_x` - %f, 2) + POW(`position_y` - %f, 2) + POW(`position_z` - %f, 2)) as `order` "
  53                 "FROM `gameobject`,`gameobject_template` WHERE `gameobject_template`.`entry` = `gameobject`.`id` AND `map` = %i AND `name` LIKE '%%%s%%' ORDER BY `order` ASC LIMIT 1",
  54                 pl->GetPositionX(), pl->GetPositionY(), pl->GetPositionZ(), pl->GetMapId(),name.c_str());
  55         }
  56     }
  57     else
  58         result = sDatabase.PQuery("SELECT `guid`, `id`, `position_x`, `position_y`, `position_z`, `orientation`, `map`, (POW(`position_x` - %f, 2) + POW(`position_y` - %f, 2) + POW(`position_z` - %f, 2)) as `order` FROM `gameobject` WHERE `map` = %i ORDER BY `order` ASC LIMIT 1", m_session->GetPlayer()->GetPositionX(), m_session->GetPlayer()->GetPositionY(), m_session->GetPlayer()->GetPositionZ(), m_session->GetPlayer()->GetMapId());
  59
  60     if (!result)
  61     {
  62         SendSysMessage("Nothing found!");
  63         return true;
  64     }
  65
  66     Field *fields = result->Fetch();
  67     uint32 guid = fields[0].GetUInt32();
  68     uint32 id = fields[1].GetUInt32();
  69     float x = fields[2].GetFloat();
  70     float y = fields[3].GetFloat();
  71     float z = fields[4].GetFloat();
  72     float o = fields[5].GetFloat();
  73     int mapid = fields[6].GetUInt16();
  74     delete result;
  75
  76     const GameObjectInfo *goI = objmgr.GetGameObjectInfo(id);
  77
  78     if (!goI)
  79     {
  80         PSendSysMessage(LANG_GAMEOBJECT_NOT_EXIST,id);
  81         return false;
  82     }
  83
  84     PSendSysMessage("Selected object:\n%s\nGUID: %u ID: %u\nX: %f Y: %f Z: %f MapId: %u\nOrientation: %f", goI->name, guid, id, x, y, z, mapid, o);
  85
  86     return true;
  87 }
  88
  89 bool ChatHandler::HandleGoObjectCommand(const char* args)
  90 {
  91     if(m_session->GetPlayer()->isInFlight())
  92     {
  93         SendSysMessage(LANG_YOU_IN_FLIGHT);
  94         return true;
  95     }
  96
  97     if(!*args)
  98         return false;
  99
 100     int32 guid = atoi((char*)args);
 101     if(!guid)
 102         return false;
 103
 104     QueryResult *result = sDatabase.PQuery("SELECT `position_x`,`position_y`,`position_z`,`orientation`,`map` FROM `gameobject` WHERE `guid` = '%i'",guid);
 105     if (!result)
 106     {
 107         SendSysMessage("Object not found!");
 108         return true;
 109     }
 110
 111     Field *fields = result->Fetch();
 112     float x = fields[0].GetFloat();
 113     float y = fields[1].GetFloat();
 114     float z = fields[2].GetFloat();
 115     float ort = fields[3].GetFloat();
 116     int mapid = fields[4].GetUInt16();
 117     delete result;
 118
 119     if(!MapManager::ExistMAP(mapid,x,y))
 120     {
 121         PSendSysMessage("target map not exist (X: %f Y: %f MapId:%u)",x,y,mapid);
 122         return true;
 123     }
 124
 125     m_session->GetPlayer()->TeleportTo(mapid, x, y, z, ort);
 126     return true;
 127 }
 128
 129 bool ChatHandler::HandleGoCreatureCommand(const char* args)
 130 {
 131     if(m_session->GetPlayer()->isInFlight())
 132     {
 133         SendSysMessage(LANG_YOU_IN_FLIGHT);
 134         return true;
 135     }
 136
 137     if(!*args)
 138         return false;
 139
 140     int32 guid = atoi((char*)args);
 141     if(!guid)
 142         return false;
 143
 144     QueryResult *result = sDatabase.PQuery("SELECT `position_x`,`position_y`,`position_z`,`orientation`,`map` FROM `creature` WHERE `guid` = '%i'",guid);
 145     if (!result)
 146     {
 147         SendSysMessage("Creature not found!");
 148         return true;
 149     }
 150
 151     Field *fields = result->Fetch();
 152     float x = fields[0].GetFloat();
 153     float y = fields[1].GetFloat();
 154     float z = fields[2].GetFloat();
 155     float ort = fields[3].GetFloat();
 156     int mapid = fields[4].GetUInt16();
 157
 158     delete result;
 159
 160     if(!MapManager::ExistMAP(mapid,x,y))
 161     {
 162         PSendSysMessage("target map not exist (X: %f Y: %f MapId:%u)",x,y,mapid);
 163         return true;
 164     }
 165
 166     m_session->GetPlayer()->TeleportTo(mapid, x, y, z, ort);
 167     return true;
 168 }
 169
 170 bool ChatHandler::HandleGUIDCommand(const char* args)
 171 {
 172     uint64 guid = m_session->GetPlayer()->GetSelection();
 173
 174     if (guid == 0)
 175     {
 176         SendSysMessage(LANG_NO_SELECTION);
 177         return true;
 178     }
 179
 180     PSendSysMessage(LANG_OBJECT_GUID, GUID_LOPART(guid), GUID_HIPART(guid));
 181     return true;
 182 }
 183
 184 bool ChatHandler::HandleNameCommand(const char* args)
 185 {
 186     /* Temp. disabled
 187         if(!*args)
 188             return false;
 189
 190         if(strlen((char*)args)>75)
 191         {
 192             PSendSysMessage(LANG_TOO_LONG_NAME, strlen((char*)args)-75);
 193             return true;
 194         }
 195
 196         for (uint8 i = 0; i < strlen(args); i++)
 197         {
 198             if(!isalpha(args[i]) && args[i]!=' ')
 199             {
 200                 SendSysMessage(LANG_CHARS_ONLY);
 201                 return false;
 202             }
 203         }
 204
 205         uint64 guid;
 206         guid = m_session->GetPlayer()->GetSelection();
 207         if (guid == 0)
 208         {
 209             SendSysMessage(LANG_NO_SELECTION);
 210             return true;
 211         }
 212
 213         Creature* pCreature = ObjectAccessor::Instance().GetCreature(*m_session->GetPlayer(), guid);
 214
 215         if(!pCreature)
 216         {
 217             SendSysMessage(LANG_SELECT_CREATURE);
 218             return true;
 219         }
 220
 221         pCreature->SetName(args);
 222         uint32 idname = objmgr.AddCreatureTemplate(pCreature->GetName());
 223         pCreature->SetUInt32Value(OBJECT_FIELD_ENTRY, idname);
 224
 225         pCreature->SaveToDB();
 226     */
 227
 228     return true;
 229 }
 230
 231 bool ChatHandler::HandleSubNameCommand(const char* args)
 232 {
 233     /* Temp. disabled
 234
 235     if(!*args)
 236         args = "";
 237
 238     if(strlen((char*)args)>75)
 239     {
 240
 241         PSendSysMessage(LANG_TOO_LONG_SUBNAME, strlen((char*)args)-75);
 242         return true;
 243     }
 244
 245     for (uint8 i = 0; i < strlen(args); i++)
 246     {
 247         if(!isalpha(args[i]) && args[i]!=' ')
 248         {
 249             SendSysMessage(LANG_CHARS_ONLY);
 250             return false;
 251         }
 252     }
 253     uint64 guid;
 254     guid = m_session->GetPlayer()->GetSelection();
 255     if (guid == 0)
 256     {
 257         SendSysMessage(LANG_NO_SELECTION);
 258         return true;
 259     }
 260
 261     Creature* pCreature = ObjectAccessor::Instance().GetCreature(*m_session->GetPlayer(), guid);
 262
 263     if(!pCreature)
 264     {
 265         SendSysMessage(LANG_SELECT_CREATURE);
 266         return true;
 267     }
 268
 269     uint32 idname = objmgr.AddCreatureSubName(pCreature->GetName(),args,pCreature->GetUInt32Value(UNIT_FIELD_DISPLAYID));
 270     pCreature->SetUInt32Value(OBJECT_FIELD_ENTRY, idname);
 271
 272     pCreature->SaveToDB();
 273     */
 274     return true;
 275 }
 276
 277 bool ChatHandler::HandleNYICommand(const char* args)
 278 {
 279     SendSysMessage(LANG_NOT_IMPLEMENTED);
 280     return true;
 281 }
 282
 283 bool ChatHandler::HandleProgCommand(const char* args)
 284 {
 285     if(m_session->GetPlayer()->isInFlight())
 286     {
 287         SendSysMessage(LANG_YOU_IN_FLIGHT);
 288         return true;
 289     }
 290
 291     m_session->GetPlayer()->TeleportTo(451, 16391.80f, 16341.20f, 69.44f,0.0f);
 292
 293     return true;
 294 }
 295
 296 bool ChatHandler::HandleItemMoveCommand(const char* args)
 297 {
 298     uint8 srcslot, dstslot;
 299
 300     char* pParam1 = strtok((char*)args, " ");
 301     if (!pParam1)
 302         return false;
 303
 304     char* pParam2 = strtok(NULL, " ");
 305     if (!pParam2)
 306         return false;
 307
 308     srcslot = (uint8)atoi(pParam1);
 309     dstslot = (uint8)atoi(pParam2);
 310
 311     uint16 src = ((INVENTORY_SLOT_BAG_0 << 8) | srcslot);
 312     uint16 dst = ((INVENTORY_SLOT_BAG_0 << 8) | dstslot);
 313
 314     m_session->GetPlayer()->SwapItem( src, dst );
 315
 316     return true;
 317 }
 318
 319 bool ChatHandler::HandleSpawnCommand(const char* args)
 320 {
 321     char* pEntry = strtok((char*)args, " ");
 322     if (!pEntry)
 323         return false;
 324
 325     char* pFlags = strtok(NULL, " ");
 326     if (!pFlags)
 327         return false;
 328
 329     char* pLevel = strtok(NULL, " ");
 330     if (!pLevel)
 331         return false;
 332
 333     char* pName = strtok(NULL, "%");
 334     if (!pName)
 335         return false;
 336
 337     uint32 level  = atoi(pLevel);
 338
 339     for (uint8 i = 0; i < strlen(pName); i++)
 340     {
 341         if(!isalpha(pName[i]) && pName[i]!=' ')
 342         {
 343             SendSysMessage(LANG_CHARS_ONLY);
 344             return false;
 345         }
 346     }
 347     SpawnCreature(m_session, pName, level);
 348
 349     return true;
 350 }
 351
 352 bool ChatHandler::HandleAddSpwCommand(const char* args)
 353 {
 354     char* charID = strtok((char*)args, " ");
 355     if (!charID)
 356         return false;
 357
 358     uint32 id  = atoi(charID);
 359
 360     Player *chr = m_session->GetPlayer();
 361     float x = chr->GetPositionX();
 362     float y = chr->GetPositionY();
 363     float z = chr->GetPositionZ();
 364     float o = chr->GetOrientation();
 365
 366     Creature* pCreature = new Creature;
 367     if (!pCreature->Create(objmgr.GenerateLowGuid(HIGHGUID_UNIT), chr->GetMapId(), x, y, z, o, id))
 368     {
 369         delete pCreature;
 370         return false;
 371     }
 372
 373     pCreature->SaveToDB();
 374     pCreature->LoadFromDB(pCreature->GetGUIDLow());         // To call _LoadGoods(); _LoadQuests(); CreateTrainerSpells();
 375     MapManager::Instance().GetMap(pCreature->GetMapId())->Add(pCreature);
 376
 377     sLog.outDebug(LANG_ADD_OBJ);
 378
 379     return true;
 380 }
 381
 382 bool ChatHandler::HandleDeleteCommand(const char* args)
 383 {
 384     Creature *unit = getSelectedCreature();
 385     if(!unit)
 386     {
 387         SendSysMessage(LANG_SELECT_CREATURE);
 388         return true;
 389     }
 390
 391     unit->CombatStop();
 392
 393     unit->DeleteFromDB();
 394
 395     ObjectAccessor::Instance().AddObjectToRemoveList(unit);
 396
 397     SendSysMessage("Creature Removed");
 398
 399     return true;
 400 }
 401
 402 bool ChatHandler::HandleDelObjectCommand(const char* args)
 403 {
 404     if(!*args)
 405         return false;
 406
 407     uint32 lowguid = atoi((char*)args);
 408     if(!lowguid)
 409         return false;
 410
 411     GameObject* obj = ObjectAccessor::Instance().GetGameObject(*m_session->GetPlayer(), MAKE_GUID(lowguid, HIGHGUID_GAMEOBJECT));
 412
 413     if(!obj)
 414     {
 415         PSendSysMessage("Game Object (GUID: %u) not found", lowguid);
 416         return true;
 417     }
 418
 419     uint64 owner_guid = obj->GetOwnerGUID();
 420     if(owner_guid)
 421     {
 422         Unit* owner = ObjectAccessor::Instance().GetUnit(*m_session->GetPlayer(),owner_guid);
 423         if(!owner && GUID_HIPART(owner_guid)!=HIGHGUID_PLAYER)
 424         {
 425             PSendSysMessage("Game Object (GUID: %u) have references in not found creature %u GO list, can't be deleted.", GUID_LOPART(owner_guid), obj->GetGUIDLow());
 426             return true;
 427         }
 428
 429         owner->RemoveGameObject(obj,false);
 430     }
 431
 432     obj->Delete();
 433     obj->DeleteFromDB();
 434
 435     PSendSysMessage("Game Object (GUID: %u) removed", obj->GetGUIDLow());
 436
 437     return true;
 438 }
 439
 440 bool ChatHandler::HandleTurnObjectCommand(const char* args)
 441 {
 442     if(!*args)
 443         return false;
 444
 445     char* plowguid = strtok((char*)args, " ");
 446
 447     if(!plowguid)
 448         return false;
 449
 450     uint32 lowguid = (uint32)atoi(plowguid);
 451
 452     GameObject* obj = ObjectAccessor::Instance().GetGameObject(*m_session->GetPlayer(), MAKE_GUID(lowguid, HIGHGUID_GAMEOBJECT));
 453
 454     if(!obj)
 455     {
 456         PSendSysMessage("Game Object (GUID: %u) not found", lowguid);
 457         return true;
 458     }
 459
 460     char* po = strtok(NULL, " ");
 461     float o;
 462
 463     if (po)
 464     {
 465         o = (float)atof(po);
 466     }
 467     else
 468     {
 469         Player *chr = m_session->GetPlayer();
 470         o = chr->GetOrientation();
 471     }
 472
 473     float rot2 = sin(o/2);
 474     float rot3 = cos(o/2);
 475
 476     obj->Relocate(obj->GetPositionX(), obj->GetPositionY(), obj->GetPositionZ(), o);
 477
 478     obj->SetFloatValue(GAMEOBJECT_FACING, o);
 479     obj->SetFloatValue(GAMEOBJECT_ROTATION+2, rot2);
 480     obj->SetFloatValue(GAMEOBJECT_ROTATION+3, rot3);
 481
 482     obj->SaveToDB();
 483     obj->Refresh();
 484
 485     PSendSysMessage("Game Object (GUID: %u) turned", obj->GetGUIDLow(), o);
 486
 487     return true;
 488 }
 489
 490 bool ChatHandler::HandleMoveObjectCommand(const char* args)
 491 {
 492     if(!*args)
 493         return false;
 494
 495     char* plowguid = strtok((char*)args, " ");
 496
 497     if(!plowguid)
 498         return false;
 499
 500     uint32 lowguid = (uint32)atoi(plowguid);
 501
 502     GameObject* obj = ObjectAccessor::Instance().GetGameObject(*m_session->GetPlayer(), MAKE_GUID(lowguid, HIGHGUID_GAMEOBJECT));
 503
 504     if(!obj)
 505     {
 506         PSendSysMessage("Game Object (GUID: %u) not found", lowguid);
 507         return true;
 508     }
 509
 510     char* px = strtok(NULL, " ");
 511     char* py = strtok(NULL, " ");
 512     char* pz = strtok(NULL, " ");
 513
 514     if (!px)
 515     {
 516         Player *chr = m_session->GetPlayer();
 517
 518         obj->Relocate(chr->GetPositionX(), chr->GetPositionY(), chr->GetPositionZ(), obj->GetOrientation());
 519
 520         obj->SetFloatValue(GAMEOBJECT_POS_X, chr->GetPositionX());
 521         obj->SetFloatValue(GAMEOBJECT_POS_Y, chr->GetPositionY());
 522         obj->SetFloatValue(GAMEOBJECT_POS_Z, chr->GetPositionZ());
 523     }
 524     else
 525     {
 526         if(!py || !pz)
 527             return false;
 528
 529         float x = (float)atof(px);
 530         float y = (float)atof(py);
 531         float z = (float)atof(pz);
 532
 533         if(!MapManager::ExistMAP(obj->GetMapId(),x,y))
 534         {
 535             PSendSysMessage(".move target map not exist (X: %f Y: %f MapId:%u)",x,y,obj->GetMapId());
 536             return true;
 537         }
 538
 539         obj->Relocate(x, y, z, obj->GetOrientation());
 540
 541         obj->SetFloatValue(GAMEOBJECT_POS_X, x);
 542         obj->SetFloatValue(GAMEOBJECT_POS_Y, y);
 543         obj->SetFloatValue(GAMEOBJECT_POS_Z, z);
 544     }
 545
 546     obj->SaveToDB();
 547     obj->Refresh();
 548
 549     PSendSysMessage("Game Object (GUID: %u) moved", obj->GetGUIDLow());
 550
 551     return true;
 552 }
 553
 554 bool ChatHandler::HandleDeMorphCommand(const char* args)
 555 {
 556     sLog.outError(LANG_DEMORPHED,m_session->GetPlayer()->GetName());
 557     m_session->GetPlayer()->DeMorph();
 558     return true;
 559 }
 560
 561 bool ChatHandler::HandleItemCommand(const char* args)
 562 {
 563     /*
 564         char* pitem = strtok((char*)args, " ");
 565         if (!pitem)
 566             return false;
 567
 568         uint64 guid = m_session->GetPlayer()->GetSelection();
 569         if (guid == 0)
 570         {
 571             SendSysMessage(LANG_NO_SELECTION);
 572             return true;
 573         }
 574
 575         Creature* pCreature = ObjectAccessor::Instance().GetCreature(*m_session->GetPlayer(), guid);
 576
 577         if(!pCreature)
 578         {
 579             SendSysMessage(LANG_SELECT_CREATURE);
 580             return true;
 581         }
 582
 583         uint32 item = atoi(pitem);
 584         int amount = -1;
 585
 586         char* pamount = strtok(NULL, " ");
 587         if (pamount)
 588             amount = atoi(pamount);
 589
 590         ItemPrototype* tmpItem = objmgr.GetItemPrototype(item);
 591
 592         if(tmpItem)
 593         {
 594             QueryResult *result = sDatabase.PQuery("INSERT INTO `npc_vendor` (`entry`,`itemguid`,`amount`) VALUES('%u','%u','%d')",pCreature->GetEntry(), item, amount);
 595
 596             uint8 itemscount = pCreature->GetItemCount();
 597             pCreature->setItemId(itemscount , item);
 598             pCreature->setItemAmount(itemscount , amount);
 599             pCreature->IncrItemCount();
 600             PSendSysMessage(LANG_ITEM_ADDED_TO_LIST,item,tmpItem->Name1);
 601             delete result;
 602         }
 603         else
 604         {
 605             PSendSysMessage(LANG_ITEM_NOT_FOUND,item);
 606         }
 607     */
 608     return true;
 609 }
 610
 611 bool ChatHandler::HandleItemRemoveCommand(const char* args)
 612 {
 613     /*
 614         char* iguid = strtok((char*)args, " ");
 615         if (!iguid)
 616             return false;
 617
 618         uint64 guid = m_session->GetPlayer()->GetSelection();
 619         if (guid == 0)
 620         {
 621             SendSysMessage(LANG_NO_SELECTION);
 622             return true;
 623         }
 624
 625         Creature *pCreature = ObjectAccessor::Instance().GetCreature(*m_session->GetPlayer(), guid);
 626
 627         if(!pCreature)
 628         {
 629             SendSysMessage(LANG_SELECT_CREATURE);
 630             return true;
 631         }
 632
 633         uint32 itemguid = atoi(iguid);
 634         int slot = pCreature->GetItemSlot(itemguid);
 635
 636         if(slot != -1)
 637         {
 638             uint32 guidlow = GUID_LOPART(guid);
 639
 640             sDatabase.PExecute("DELETE FROM `npc_vendor` WHERE `entry` = '%u' AND `itemguid` = '%u'",pCreature->GetEntry(),itemguid);
 641
 642             pCreature->setItemId(slot , 0);
 643             pCreature->setItemAmount(slot , 0);
 644             ItemPrototype* tmpItem = objmgr.GetItemPrototype(itemguid);
 645             if(tmpItem)
 646             {
 647                 PSendSysMessage(LANG_ITEM_DELETED_FROM_LIST,itemguid,tmpItem->Name1);
 648             }
 649             else
 650             {
 651                 PSendSysMessage(LANG_ITEM_DELETED_FROM_LIST,itemguid,"<unknonwn>");
 652             }
 653
 654         }
 655         else
 656         {
 657             PSendSysMessage(LANG_ITEM_NOT_IN_LIST,itemguid);
 658         }
 659     */
 660     return true;
 661 }
 662
 663 bool ChatHandler::HandleAddMoveCommand(const char* args)
 664 {
 665     if(!*args)
 666         return false;
 667
 668     char* guid_str = strtok((char*)args, " ");
 669     char* wait_str = strtok((char*)NULL, " ");
 670
 671     uint32 lowguid = atoi((char*)guid_str);
 672
 673     Creature* pCreature = NULL;
 674
 675     if(lowguid)
 676         pCreature = ObjectAccessor::Instance().GetCreature(*m_session->GetPlayer(),MAKE_GUID(lowguid,HIGHGUID_UNIT));
 677
 678     if(!pCreature)
 679     {
 680         PSendSysMessage("Creature (GUID: %u) not found", lowguid);
 681         return true;
 682     }
 683
 684     int wait = wait_str ? atoi(wait_str) : 0;
 685
 686     if(wait < 0)
 687         wait = 0;
 688
 689     uint32 point;
 690
 691     QueryResult *result = sDatabase.PQuery( "SELECT MAX(`point`) FROM `creature_movement` WHERE `id` = '%u'",pCreature->GetGUIDLow());
 692     if( result )
 693     {
 694         point = (*result)[0].GetUInt32()+1;
 695
 696         delete result;
 697     }
 698     else
 699         point = 0;
 700
 701     Player* player = m_session->GetPlayer();
 702
 703     sDatabase.PExecute("INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`) VALUES ('%u','%u','%f', '%f', '%f','%u')",
 704         pCreature->GetGUIDLow(), point, player->GetPositionX(), player->GetPositionY(), player->GetPositionZ(), wait);
 705
 706     // update movement type
 707     if(pCreature->GetDefaultMovementType()!=WAYPOINT_MOTION_TYPE)
 708     {
 709         pCreature->SetDefaultMovementType(WAYPOINT_MOTION_TYPE);
 710         sDatabase.PExecute("UPDATE `creature` SET `MovementType` = '%u' WHERE `guid` = '%u'", pCreature->GetDefaultMovementType(),pCreature->GetGUIDLow());
 711     }
 712
 713     SendSysMessage(LANG_WAYPOINT_ADDED);
 714
 715     return true;
 716 }
 717
 718 bool ChatHandler::HandleRandomCommand(const char* args)
 719 {
 720     if(!*args)
 721         return false;
 722
 723     int option = atoi((char*)args);
 724
 725     if (option != 0 && option != 1)
 726     {
 727         //m_session->GetPlayer( )->SendMessageToSet( &data, true );
 728         SendSysMessage(LANG_USE_BOL);
 729         return true;
 730     }
 731
 732     Creature* pCreature = getSelectedCreature();
 733
 734     if(!pCreature)
 735     {
 736         SendSysMessage(LANG_SELECT_CREATURE);
 737         return true;
 738     }
 739
 740     // fix me : 'moverandom' doesn't exist in https://svn.mangosproject.org/trac/MaNGOS/wiki/Database/creature ?
 741     // perhaps it should be 'state'?
 742     sDatabase.PExecute("UPDATE `creature` SET `moverandom` = '%i' WHERE `guid` = '%u'", option, pCreature->GetGUIDLow());
 743
 744     pCreature->setMoveRandomFlag(option > 0);
 745
 746     SendSysMessage(LANG_VALUE_SAVED);
 747
 748     return true;
 749 }
 750
 751 bool ChatHandler::HandleRunCommand(const char* args)
 752 {
 753     if(!*args)
 754         return false;
 755
 756     int option = atoi((char*)args);
 757
 758     if(option != 0 && option != 1)
 759     {
 760         SendSysMessage(LANG_USE_BOL);
 761         return true;
 762     }
 763
 764     Creature* pCreature = getSelectedCreature();
 765
 766     if(!pCreature)
 767     {
 768         SendSysMessage(LANG_SELECT_CREATURE);
 769         return true;
 770     }
 771
 772     // fix me : 'running' doesn't exist in https://svn.mangosproject.org/trac/MaNGOS/wiki/Database/creatures ?
 773     // perhaps it should be 'state'?
 774     sDatabase.PExecute("UPDATE `creature` SET `running` = '%i' WHERE `guid` = '%u'", option, pCreature->GetGUIDLow());
 775
 776     pCreature->setMoveRunFlag(option > 0);
 777
 778     SendSysMessage(LANG_VALUE_SAVED);
 779     return true;
 780 }
 781
 782 bool ChatHandler::HandleChangeLevelCommand(const char* args)
 783 {
 784     if (!*args)
 785         return false;
 786
 787     uint8 lvl = (uint8) atoi((char*)args);
 788     if ( lvl < 1 || lvl > sWorld.getConfig(CONFIG_MAX_PLAYER_LEVEL) + 3)
 789     {
 790         SendSysMessage(LANG_BAD_VALUE);
 791         return true;
 792     }
 793
 794     Creature* pCreature = getSelectedCreature();
 795     if(!pCreature)
 796     {
 797         SendSysMessage(LANG_SELECT_CREATURE);
 798         return true;
 799     }
 800
 801     pCreature->SetHealth( 100 + 30*lvl);
 802     pCreature->SetMaxHealth( 100 + 30*lvl);
 803     pCreature->SetLevel( lvl);
 804
 805     pCreature->SaveToDB();
 806
 807     return true;
 808 }
 809
 810 bool ChatHandler::HandleNPCFlagCommand(const char* args)
 811 {
 812     if (!*args)
 813         return false;
 814
 815     uint32 npcFlags = (uint32) atoi((char*)args);
 816
 817     Creature* pCreature = getSelectedCreature();
 818
 819     if(!pCreature)
 820     {
 821         SendSysMessage(LANG_SELECT_CREATURE);
 822         return true;
 823     }
 824
 825     pCreature->SetUInt32Value(UNIT_NPC_FLAGS, npcFlags);
 826
 827     sDatabase.PExecute("UPDATE `creature_template` SET `npcflag` = '%u' WHERE `entry` = '%u'", npcFlags, pCreature->GetEntry());
 828
 829     SendSysMessage(LANG_VALUE_SAVED_REJOIN);
 830
 831     uint32 entry = pCreature->GetUInt32Value( OBJECT_FIELD_ENTRY );
 832     m_session->SendCreatureQuery( entry, pCreature->GetGUID() );
 833
 834     return true;
 835 }
 836
 837 bool ChatHandler::HandleDisplayIdCommand(const char* args)
 838 {
 839     if (!*args)
 840         return false;
 841
 842     uint32 displayId = (uint32) atoi((char*)args);
 843
 844     Creature *pCreature = getSelectedCreature();
 845
 846     if(!pCreature)
 847     {
 848         SendSysMessage(LANG_SELECT_CREATURE);
 849         return true;
 850     }
 851
 852     pCreature->SetUInt32Value(UNIT_FIELD_DISPLAYID, displayId);
 853
 854     pCreature->SaveToDB();
 855
 856     return true;
 857 }
 858
 859 bool ChatHandler::HandleFactionIdCommand(const char* args)
 860 {
 861     if (!*args)
 862         return false;
 863
 864     uint32 factionId = (uint32) atoi((char*)args);
 865
 866     Creature* pCreature = getSelectedCreature();
 867
 868     if(!pCreature)
 869     {
 870         SendSysMessage(LANG_SELECT_CREATURE);
 871         return true;
 872     }
 873
 874     pCreature->setFaction(factionId);
 875
 876     pCreature->SaveToDB();
 877
 878     return true;
 879 }
 880
 881 bool ChatHandler::HandleKickPlayerCommand(const char *args)
 882 {
 883     char* kickName = strtok((char*)args, " ");
 884     if (!kickName)
 885     {
 886         Player* player = getSelectedPlayer();
 887         if(player==m_session->GetPlayer())
 888         {
 889             SendSysMessage("You can't kick self by selecting, use .kick name ;)");
 890             return true;
 891         }
 892
 893         player->GetSession()->KickPlayer();
 894     }
 895     else
 896     {
 897         std::string name = kickName;
 898         normalizePlayerName(name);
 899         if(sWorld.KickPlayer(name))
 900             PSendSysMessage("Player %s kicked.",name.c_str());
 901         else
 902             PSendSysMessage("Player %s not found.",name.c_str());
 903     }
 904
 905     return true;
 906 }
 907
 908 bool ChatHandler::HandlePInfoCommand(const char* args)
 909 {
 910     Player* target = NULL;
 911
 912     char* px = strtok((char*)args, " ");
 913     if (px)
 914     {
 915         std::string name = px;
 916         normalizePlayerName(name);
 917         target = objmgr.GetPlayer(name.c_str());
 918     }
 919     else
 920         target = getSelectedPlayer();
 921
 922     if(!target)
 923     {
 924         SendSysMessage(LANG_PLAYER_NOT_FOUND);
 925         return true;
 926     }
 927
 928     std::string username = "<error>";
 929     std::string last_ip = "<error>";
 930
 931     QueryResult* result = loginDatabase.PQuery("SELECT `username`, `last_ip` FROM `account` WHERE `id` = '%u'",target->GetSession()->GetAccountId());
 932     if(result)
 933     {
 934         Field* fields = result->Fetch();
 935         username = fields[0].GetCppString();
 936         if(m_session->GetSecurity() >= target->GetSession()->GetSecurity())
 937             last_ip = fields[1].GetCppString();
 938         else
 939             last_ip = "-";
 940
 941         delete result;
 942     }
 943
 944     PSendSysMessage(LANG_PINFO_ACCOUNT,  target->GetName(), target->GetGUIDLow(), username.c_str(), target->GetSession()->GetAccountId(), target->GetSession()->GetSecurity(), last_ip.c_str());
 945
 946     uint32 days = target->GetTotalPlayedTime() / (60*60*24);
 947     uint32 hours = (target->GetTotalPlayedTime() % (60*60*24)) / (60*60);
 948     uint32 gold = target->GetMoney() /(100*100);
 949     uint32 silv = (target->GetMoney() % (100*100)) / 100;
 950     uint32 copp = (target->GetMoney() % (100*100)) % 100;
 951     PSendSysMessage(LANG_PINFO_LEVEL,  days, hours, target->getLevel(), gold,silv,copp );
 952
 953     return true;
 954 }
 955
 956 void ChatHandler::ShowTicket(uint64 guid, uint32 category, char const* text)
 957 {
 958     std::string name;
 959     objmgr.GetPlayerNameByGUID(guid,name);
 960
 961     if(name=="") name = " <unknown> ";
 962
 963     PSendSysMessage("Ticket of %s (Category: %i):\n%s\n", name.c_str(),category,text);
 964 }
 965
 966 bool ChatHandler::HandleTicketCommand(const char* args)
 967 {
 968     char* px = strtok((char*)args, " ");
 969
 970     // ticket<end>
 971     if (!px)
 972     {
 973         QueryResult *result = sDatabase.Query("SELECT `ticket_id` FROM `character_ticket`");
 974         size_t count = result ? result->GetRowCount() : 0;
 975
 976         PSendSysMessage("Tickets count: %i show new tickets: %s\n", count,m_session->GetPlayer()->isAcceptTickets() ?  "on" : "off");
 977         delete result;
 978         return true;
 979     }
 980
 981     // ticket on
 982     if(strncmp(px,"on",3) == 0)
 983     {
 984         m_session->GetPlayer()->SetAcceptTicket(true);
 985         SendSysMessage("New ticket show: on");
 986         return true;
 987     }
 988
 989     // ticket off
 990     if(strncmp(px,"off",4) == 0)
 991     {
 992         m_session->GetPlayer()->SetAcceptTicket(false);
 993         SendSysMessage("New ticket show: off");
 994         return true;
 995     }
 996
 997     // ticket #num
 998     int num = atoi(px);
 999     if(num > 0)
1000     {
1001         QueryResult *result = sDatabase.Query("SELECT `guid`,`ticket_category`,`ticket_text` FROM `character_ticket`");
1002
1003         if(!result || uint64(num) > result->GetRowCount())
1004         {
1005             PSendSysMessage("Ticket %i doesn't exist", num);
1006             delete result;
1007             return true;
1008         }
1009
1010         for(int i = 1; i < num; ++i)
1011             result->NextRow();
1012
1013         Field* fields = result->Fetch();
1014
1015         uint64 guid = fields[0].GetUInt64();
1016         uint32 category = fields[1].GetUInt32();
1017         char const* text = fields[2].GetString();
1018
1019         ShowTicket(guid,category,text);
1020         delete result;
1021         return true;
1022     }
1023
1024     std::string name = px;
1025     normalizePlayerName(name);
1026     sDatabase.escape_string(name);                          // prevent SQL injection - normal name don't must changed by this call
1027
1028     uint64 guid = objmgr.GetPlayerGUIDByName(name.c_str());
1029
1030     if(!guid)
1031         return false;
1032
1033     // ticket $char_name
1034     QueryResult *result = sDatabase.PQuery("SELECT `guid`,`ticket_category`,`ticket_text` FROM `character_ticket` WHERE `guid` = '%u'",GUID_LOPART(guid));
1035
1036     if(!result)
1037         return false;
1038
1039     Field* fields = result->Fetch();
1040
1041     uint32 category = fields[1].GetUInt32();
1042     char const* text = fields[2].GetString();
1043
1044     ShowTicket(guid,category,text);
1045     delete result;
1046
1047     return true;
1048 }
1049
1050 uint32 ChatHandler::GetTicketIDByNum(uint32 num)
1051 {
1052     QueryResult *result = sDatabase.Query("SELECT `ticket_id` FROM `character_ticket`");
1053
1054     if(!result || num > result->GetRowCount())
1055     {
1056         PSendSysMessage("Ticket %i doesn't exist", num);
1057         delete result;
1058         return 0;
1059     }
1060
1061     for(uint32 i = 1; i < num; ++i)
1062         result->NextRow();
1063
1064     Field* fields = result->Fetch();
1065
1066     uint32 id = fields[0].GetUInt32();
1067     delete result;
1068     return id;
1069 }
1070
1071 bool ChatHandler::HandleDelTicketCommand(const char *args)
1072 {
1073     char* px = strtok((char*)args, " ");
1074     if (!px)
1075         return false;
1076
1077     // delticket all
1078     if(strncmp(px,"all",4) == 0)
1079     {
1080         QueryResult *result = sDatabase.Query("SELECT `guid` FROM `character_ticket`");
1081
1082         if(!result)
1083             return true;
1084
1085         // notify players about ticket deleting
1086         do
1087         {
1088             Field* fields = result->Fetch();
1089
1090             uint64 guid = fields[0].GetUInt64();
1091
1092             if(Player* sender = objmgr.GetPlayer(guid))
1093                 sender->GetSession()->SendGMTicketGetTicket(1,0);
1094
1095         }while(result->NextRow());
1096
1097         delete result;
1098
1099         sDatabase.PExecute("DELETE FROM `character_ticket`");
1100         SendSysMessage("All tickets deleted.");
1101         return true;
1102     }
1103
1104     int num = (uint32)atoi(px);
1105
1106     // delticket #num
1107     if(num > 0)
1108     {
1109         QueryResult *result = sDatabase.PQuery("SELECT `ticket_id`,`guid` FROM `character_ticket` LIMIT '%i'",num);
1110
1111         if(!result || uint64(num) > result->GetRowCount())
1112         {
1113             PSendSysMessage("Ticket %i doesn't exist", num);
1114             delete result;
1115             return true;
1116         }
1117
1118         for(int i = 1; i < num; ++i)
1119             result->NextRow();
1120
1121         Field* fields = result->Fetch();
1122
1123         uint32 id   = fields[0].GetUInt32();
1124         uint64 guid = fields[1].GetUInt64();
1125         delete result;
1126
1127         sDatabase.PExecute("DELETE FROM `character_ticket` WHERE `ticket_id` = '%u'", id);
1128
1129         // notify players about ticket deleting
1130         if(Player* sender = objmgr.GetPlayer(guid))
1131         {
1132             sender->GetSession()->SendGMTicketGetTicket(1,0);
1133             PSendSysMessage("Character %s ticket deleted.",sender->GetName());
1134         }
1135         else
1136             SendSysMessage("Ticket deleted.");
1137
1138         return true;
1139     }
1140
1141     std::string name = px;
1142     normalizePlayerName(name);
1143     sDatabase.escape_string(name);                          // prevent SQL injection - normal name don't must changed by this call
1144
1145     uint64 guid = objmgr.GetPlayerGUIDByName(name.c_str());
1146
1147     if(!guid)
1148         return false;
1149
1150     // delticket $char_name
1151     sDatabase.PExecute("DELETE FROM `character_ticket` WHERE `guid` = '%u'",GUID_LOPART(guid));
1152
1153     // notify players about ticket deleting
1154     if(Player* sender = objmgr.GetPlayer(guid))
1155         sender->GetSession()->SendGMTicketGetTicket(1,0);
1156
1157     PSendSysMessage("Character %s ticket deleted.",px);
1158     return true;
1159 }