[Core / Worldserver] Starequipp Custom Command

https://www.youtube.com/watch?v=q0UlGnxQruQ

PHP Code:

---

Author: Lucky_Patcher <lucky_patcher@script-devilz.to>  2017-08-09 22:21:06
Committer: Lucky_Patcher <lucky_patcher@script-devilz.to>  2017-08-09 22:21:06
Parent: af86b1cc921fcef2f68dee8bd26c75b826bc9ba3 (Merge branch '3.3.5' of https://github.com/TrinityCore/TrinityCore into 3.3.5)
Branch: 3.3.5
Follows: TDB335.63
Precedes: 

    Add Command Startequipp

----------------------- src/server/game/Accounts/RBAC.h -----------------------
index cf2d1f3f40..03909fd414 100644
@@ -774,6 +774,7 @@ enum RBACPermissions
     RBAC_PERM_COMMAND_LIST_SPAWNPOINTS                       = 866,
 
     // custom permissions 1000+
+    RBAC_PERM_COMMAND_STARTEQUIPP                            = 1000,
     RBAC_PERM_MAX
 };
 

------------------- src/server/scripts/Commands/cs_misc.cpp -------------------
index dbf50d6564..e42054e251 100644
@@ -115,6 +115,7 @@ public:
             { "unstuck",          rbac::RBAC_PERM_COMMAND_UNSTUCK,           true, &HandleUnstuckCommand,          "" },
             { "wchange",          rbac::RBAC_PERM_COMMAND_WCHANGE,          false, &HandleChangeWeather,           "" },
             { "mailbox",          rbac::RBAC_PERM_COMMAND_MAILBOX,          false, &HandleMailBoxCommand,          "" },
+            { "startequipp",      rbac::RBAC_PERM_COMMAND_STARTEQUIPP,       true, &HandleStartequippCommand,      "" },
         };
         return commandTable;
     }
@@ -2713,7 +2714,68 @@ public:
 
         handler->GetSession()->SendShowMailBox(player->GetGUID());
         return true;
+        
+
     }
+
+    static bool HandleStartequippCommand(ChatHandler* handler, char const* /*args*/)
+    {
+        Player* player = handler->GetSession()->GetPlayer();
+        uint32 pClass = player->getClass();
+
+        if (CharacterDatabase.PQuery("SELECT used FROM player_startequipp WHERE guid=%u and used = 1;", player->GetGUID().GetCounter()))
+        {
+            handler->PSendSysMessage("You already used this command for this character!");
+            handler->SetSentErrorMessage(true);
+            return false;
+        }
+
+        CharacterDatabase.PExecute("INSERT INTO player_startequipp (`guid`, `used`, `datatime`) VALUES (%u, 1, NOW())", player->GetGUID().GetCounter());
+        
+        switch (pClass) 
+        {
+            case CLASS_DEATH_KNIGHT:
+                player->AddItem(51125, 1);
+                player->AddItem(51126, 1);
+                player->AddItem(51127, 1);
+                player->AddItem(51128, 1);
+                player->AddItem(51129, 1);
+                player->AddItem(49623, 1);
+                player->ModifyMoney(1000000, true);
+                player->ModifyArenaPoints(2200);
+                player->ModifyHonorPoints(80000);
+                handler->PSendSysMessage("[SYSTEM]: You have reached your items successfull!");
+                break;
+            case CLASS_DRUID:
+                handler->PSendSysMessage("The items for your class are not avaible at the moment!");
+                break;
+            case CLASS_HUNTER:
+                handler->PSendSysMessage("The items for your class are not avaible at the moment!");
+                break;
+            case CLASS_MAGE:
+                handler->PSendSysMessage("The items for your class are not avaible at the moment!");
+                break;
+            case CLASS_PALADIN:
+                handler->PSendSysMessage("The items for your class are not avaible at the moment!");
+                break;
+            case CLASS_PRIEST:
+                handler->PSendSysMessage("The items for your class are not avaible at the moment!");
+                break;
+            case CLASS_ROGUE:
+                handler->PSendSysMessage("The items for your class are not avaible at the moment!");
+                break;
+            case CLASS_SHAMAN:
+                handler->PSendSysMessage("The items for your class are not avaible at the moment!");
+                break;
+            case CLASS_WARLOCK:
+                handler->PSendSysMessage("The items for your class are not avaible at the moment!");
+                break;
+            case CLASS_WARRIOR:
+                handler->PSendSysMessage("The items for your class are not avaible at the moment!");
+                break;
+        }
+        return true;
+    }
 };
 
 void AddSC_misc_commandscript() 


---

SQL Part :

World Database : Table command

PHP Code:

---

INSERT INTO `command` (`name`, `permission`, `help`) VALUES ('startequipp', '1000', 'Syntax: .startequipp will give you a one time start equipp for your new character.'); 


---

Auth Database :

PHP Code:

---

INSERT INTO `rbac_permissions` (`id`, `name`) VALUES ('1000', 'Command : startequipp');
INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES ('195', '1000'); 


---

Characters Database :

PHP Code:

---

CREATE TABLE IF NOT EXISTS `player_startequipp` (
  `guid` int(128) NOT NULL,
  `used` int(1) DEFAULT '0',
  `datatime` datetime DEFAULT NULL,
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; 


---

Credits goes to :

winter_the_mute, Treeston, rochet2, Riztazz, Aokromes from TrinityCore. Thanks for helping me and thanks that you teach me some stuff i will learn forward!