1. class AccountMounts : public PlayerScript
  2. {
  3. static const bool limitrace = false; // This set to true will only learn mounts from chars on the same team, do what you want.
  4. public:
  5. AccountMounts() : PlayerScript("AccountMounts") { }
  7. void OnLogin(Player* pPlayer)
  8. {
  9. std::vector<uint32> Guids;
  10. QueryResult result1 = CharacterDatabase.PQuery("SELECT guid, race FROM characters WHERE account = %u", pPlayer->GetSession()->GetAccountId());
  11. if (!result1)
  12. return;
  14. do
  15. {
  16. Field* fields = result1->Fetch();
  18. uint32 guid = fields[0].GetUInt32();
  19. uint32 race = fields[1].GetUInt8();
  21. if ((Player::TeamForRace(race) == Player::TeamForRace(pPlayer->getRace())) || !limitrace)
  22. Guids.push_back(result1->Fetch()[0].GetUInt32());
  24. } while (result1->NextRow());
  26. std::vector<uint32> Spells;
  28. for (auto& i : Guids)
  29. {
  30. QueryResult result2 = CharacterDatabase.PQuery("SELECT spell FROM character_spell WHERE guid = %u", i);
  31. if (!result2)
  32. continue;
  34. do
  35. {
  36. Spells.push_back(result2->Fetch()[0].GetUInt32());
  37. } while (result2->NextRow());
  38. }
  40. for (auto& i : Spells)
  41. {
  42. auto sSpell = sSpellStore.LookupEntry(i);
  43. if (sSpell->Effect[0] == SPELL_EFFECT_APPLY_AURA && sSpell->EffectApplyAuraName[0] == SPELL_AURA_MOUNTED)
  44. pPlayer->learnSpell(sSpell->Id, false);
  45. }
  46. }
  47. };
  49. void AddSC_accontmounts()
  50. {
  51. new AccountMounts;
  52. }