Guild House fix for TC Cataclysm

Xaver · Dec 26, 2014

Credits :
Synth
QQrofl,
and updated by me

Fix Line:

if (!object->Create(guidLow, objectInfo->entry, map, pPlayer->GetPhaseMgr().GetPhaseMaskForSpawn(), x, y, z, o, 0.0f, 0.0f, 0.0f, 0.0f, 0, GO_STATE_READY))

Code:

/*######################-> [[Guild Housing ]] <-#########################
**************************! DEV: QQRofl Rewrite&Release:Me(Azteco)  !****************************
#######################################################################*/
#include "ScriptPCH.h"
#include <cstring>
#include "GuildMgr.h"
#include "ObjectMgr.h"
#include <Player.h>
#include "PhaseMgr.h"

const uint32 GUILD_TOKEN = 37711;
bool requiresGUpdate = true;
std::vector<uint64> GuildHouses;
char string[200];

enum Objects
{
	OBJECT_TABLE = 180698,
	OBJECT_TORCH = 187988,
	OBJECT_MAILBOX = 142094,
	OBJECT_CRATE = 183992,
	OBJECT_A_FLAG = 187342,
	OBJECT_H_FLAG = 192688,
	OBJECT_CHAIR = 10201,
	OBJECT_FIREPIT = 1967,
	OBJECT_GUILDVAULT = 187390,
	OBJECT_BARBER_CHAIR = 191817,
	OBJECT_CRANBERRY_BUSH = 195199,
};

void SpawnObject(Player * pPlayer, uint32 objectId)
{
	const GameObjectTemplate* objectInfo = sObjectMgr->GetGameObjectTemplate(objectId);

	float x = float(pPlayer->GetPositionX());
	float y = float(pPlayer->GetPositionY());
	float z = float(pPlayer->GetPositionZ());
	float o = float(pPlayer->GetOrientation());
	Map* map = pPlayer->GetMap();

	GameObject* object = new GameObject;
	uint32 guidLow = sObjectMgr->GenerateLowGuid(HIGHGUID_GAMEOBJECT);
	

	if (!object->Create(guidLow, objectInfo->entry, map, pPlayer->GetPhaseMgr().GetPhaseMaskForSpawn(), x, y, z, o, 0.0f, 0.0f, 0.0f, 0.0f, 0, GO_STATE_READY))
	{
		delete object;
		return;
	}

	object->SetRespawnTime(1);
	object->SaveToDB(map->GetId(), (1 << map->GetSpawnMode()), pPlayer->GetPhaseMgr().GetPhaseMaskForSpawn());

	if (!object->LoadGameObjectFromDB(guidLow, map))
	{
		delete object;
		return;
	}

	sObjectMgr->AddGameobjectToGrid(guidLow, sObjectMgr->GetGOData(guidLow));
	WorldDatabase.PExecute("INSERT INTO guildhouse_objects VALUES('%u', '%u')", pPlayer->GetGuildId(), guidLow);
}

uint32 getGuildAreaId(Player * pPlayer)
{
	QueryResult Result = WorldDatabase.PQuery("SELECT area FROM guildhouses WHERE guildId='%u'", pPlayer->GetGuildId());
	if (Result)
	{
		Field * pField = Result->Fetch();
		return pField[0].GetUInt32();
	}

	return -1;

}

bool isInGuildArea(Player * pPlayer)
{
	for (int i = 0; i < 21; i++)
	{
		if (pPlayer->GetAreaId() == getGuildAreaId(pPlayer))
			return true;
	}
	return false;
}

bool isGuildHouseOwner(Player * pPlayer)
{
	if (GuildHouses.empty() || requiresGUpdate == true)
	{
		if (requiresGUpdate == true)
		{
			GuildHouses.clear();
			requiresGUpdate = false;
		}
		QueryResult Result = WorldDatabase.PQuery("SELECT guildId FROM guildhouses WHERE guildId != '0'");
		if (Result)
		{
			Field * pFields = Result->Fetch();
			int i = 0;
			do
			{
				GuildHouses.push_back(pFields[0].GetUInt64());
				i++;
			} while (Result->NextRow());

			return isGuildHouseOwner(pPlayer);
		}
		else
		{
			return false;
		}
	}
	else
	{
		for (std::vector<uint64>::iterator itr = GuildHouses.begin(); itr != GuildHouses.end(); itr++)
		{
			if (*itr != pPlayer->GetGuildId())
				continue;
			else
				return true;
		}
		return false;
	}
}

bool isPlayerGuildLeader(Player *player)
{
	return (player->GetRank() == 0) && (player->GetGuildId() != 0);
}

bool GuildOwnsHouse(Player * pPlayer)
{
	QueryResult pResult = WorldDatabase.PQuery("SELECT * FROM guildhouses WHERE guildId='%u'", pPlayer->GetGuildId());
	if (!pResult)
		return false;
	else
		return true;
}

void CleanUpObjects(Player * pPlayer, uint32 guildId)
{
	QueryResult ObjectSpawns = WorldDatabase.PQuery("SELECT `guid` FROM `guildhouse_objects` WHERE `guildId` = '%u'", guildId);
	if (ObjectSpawns)
	{
		do
		{
			Field * pField = ObjectSpawns->Fetch();
			uint32 Object_GUID = pField[0].GetUInt32();
			GameObject* object = NULL;
			ChatHandler handler = ChatHandler(pPlayer->GetSession());

			if (GameObjectData const* gameObjectData = sObjectMgr->GetGOData(Object_GUID))
				object = handler.GetObjectGlobalyWithGuidOrNearWithDbGuid(Object_GUID, gameObjectData->id);

			if (!object)
				continue;

			object->SetRespawnTime(0);
			object->Delete();
			object->DeleteFromDB();
			WorldDatabase.PExecute("DELETE FROM `guildhouse_objects` WHERE guid='%u'", Object_GUID);
		} while (ObjectSpawns->NextRow());
	}
}

void SellGuildHouse(Player * pPlayer, Creature * pCreature)
{
	if (isInGuildArea(pPlayer))
	{
		WorldDatabase.PExecute("UPDATE `guildhouses` SET `guildId`='0' WHERE `guildId`='%u'", pPlayer->GetGuildId());
		CleanUpObjects(pPlayer, pPlayer->GetGuildId());
		pCreature->MonsterSay("Ihr Gilden Haus wurde Verkauft!", LANG_UNIVERSAL, pPlayer->GetGUID());
		pPlayer->PlayerTalkClass->SendCloseGossip();
		requiresGUpdate = true;
		pPlayer->TeleportTo(530, -1861.239990f, 5437.810059f, -10.463400f, 1.353830f); // generally the mall
	}
	else
	{
		pPlayer->GetSession()->SendNotification("Gilden Haus Verkauft!");
	}
}

void PurchaseGuildHouse(Player * pPlayer, Creature * pCreature, uint32 &Id)
{
	if (pPlayer->HasItemCount(GUILD_TOKEN, 1))
	{
		WorldDatabase.PExecute("UPDATE `guildhouses` SET `guildId`='%u' WHERE `id`='%u'", pPlayer->GetGuildId(), Id);
		pCreature->MonsterSay("Sie sind nun besitzer eines Gilden Hauses Viel erfolg!", LANG_UNIVERSAL, pPlayer->GetGUID());
		pPlayer->DestroyItemCount(GUILD_TOKEN, 1, true);
		requiresGUpdate = true;
	}
	else
	{
		pCreature->MonsterSay("Sie haben nicht den Gilden-Token um ein Gilden Haus zu kaufen!", LANG_UNIVERSAL, pPlayer->GetGUID());
	}
	pPlayer->PlayerTalkClass->SendCloseGossip();
}

void TeleportToHouse(Player * pPlayer)
{
	if (pPlayer->isInCombat())
		return;

	QueryResult result = WorldDatabase.PQuery("SELECT `x`, `y`, `z`, `map` FROM `guildhouses` WHERE `guildId` = '%u'", pPlayer->GetGuildId());
	if (result)
	{
		Field *fields = result->Fetch();
		float x = fields[0].GetFloat();
		float y = fields[1].GetFloat();
		float z = fields[2].GetFloat();
		uint32 map = fields[3].GetUInt32();
		pPlayer->TeleportTo(map, x, y, z, pPlayer->GetOrientation());
	}
}

class GuildHouse_NPC : public CreatureScript
{
public:
	GuildHouse_NPC() : CreatureScript("GuildHouse"){}


	void ShowHouseListings(Player * pPlayer, Creature * pCreature, unsigned int start = 0)
	{
		pPlayer->PlayerTalkClass->ClearMenus();

		QueryResult pResult = WorldDatabase.PQuery("SELECT id, comment FROM guildhouses WHERE guildId='0'");
		uint32 houses = pResult->GetRowCount();
		int offset = 0;
		Field * pField = pResult->Fetch();
		bool ranOnce = false;
		for (unsigned int i = start; i < houses; i++)
		{
			if (start != 0 && ranOnce == false)
			{
				for (int x = 0; x < start; x++)
				{
					pResult->NextRow();
				}
				ranOnce = true;
			}

			if (offset != 10)
			{
				pPlayer->ADD_GOSSIP_ITEM(6, pField[1].GetString(), GOSSIP_SENDER_MAIN, pField[0].GetUInt32());
				offset++;
				pResult->NextRow();
			}
			else
			{
				if ((startid + 12) > houses)
				{
					/*pPlayer->ADD_GOSSIP_ITEM(7, "-------------END--------------", GOSSIP_SENDER_MAIN, 41);*/
				}
				else
				{
					pPlayer->ADD_GOSSIP_ITEM(7, "Weiter...", GOSSIP_SENDER_MAIN, 4353);
					startid = start + offset;
					i = houses + 10;
				}
			}
		}
		pPlayer->PlayerTalkClass->SendGossipMenu(2, pCreature->GetGUID());
	}

	bool OnGossipHello(Player * pPlayer, Creature * pCreature)
	{
		startid = 0;

		if (pPlayer->GetGuildId() == 0)
		{
			pPlayer->GetSession()->SendNotification("Sie sollten schon in einer Gilde sein!");
			return false;
		}
		else if (!GuildOwnsHouse(pPlayer) && !isPlayerGuildLeader(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Ihre Gilde besizt kein Gilden Haus!");
			return false;
		}
		/*pPlayer->ADD_GOSSIP_ITEM(4, "Guild Housing System:", GOSSIP_SENDER_MAIN, 41);
		pPlayer->ADD_GOSSIP_ITEM(4, "----------------------------------------------", GOSSIP_SENDER_MAIN, 41);*/
		if (isPlayerGuildLeader(pPlayer))
		{
			if (!GuildOwnsHouse(pPlayer))
				pPlayer->ADD_GOSSIP_ITEM(6, "Gilden Haus Kaufen", GOSSIP_SENDER_MAIN, 38);
			else
				pPlayer->ADD_GOSSIP_ITEM_EXTENDED(6, "Gilden Haus Verkaufen", GOSSIP_SENDER_MAIN, 39, "Sind sie sicher das sie ihr Gilden Haus verkaufen wollen ??", 0, false);
		}
		if (GuildOwnsHouse(pPlayer))
			pPlayer->ADD_GOSSIP_ITEM(7, "Tele zum Gilden Haus", GOSSIP_SENDER_MAIN, 40);
		pPlayer->PlayerTalkClass->SendGossipMenu(2, pCreature->GetGUID());
		return true;
	}

	bool OnGossipSelect(Player * pPlayer, Creature * pCreature, uint32 /*uiSender*/, uint32 uiAction)
	{
		pPlayer->PlayerTalkClass->ClearMenus();

		switch (uiAction)
		{
		case 38:
			ShowHouseListings(pPlayer, pCreature);
			break;
		case 39:
			SellGuildHouse(pPlayer, pCreature);
			WorldDatabase.PExecute("UPDATE `guildhouses` SET `guildId`='0' WHERE `guildId`='%u'", pPlayer->GetGuildId());
			pPlayer->PlayerTalkClass->SendCloseGossip();
			break;
		case 40:
			TeleportToHouse(pPlayer);
			break;
		case 41:
			OnGossipHello(pPlayer, pCreature);
			break;
		case 4353:
			ShowHouseListings(pPlayer, pCreature, startid);
			break;
		default:
			if (uiAction < 38 && uiAction > 0)
				PurchaseGuildHouse(pPlayer, pCreature, uiAction);
			break;
		}
		return true;
	}

private:
	uint32 startid;
};


class Table_Token : public ItemScript
{
public:
	Table_Token() : ItemScript("Table Token"){}

	bool OnUse(Player* pPlayer, Item* pItem, SpellCastTargets const& /*targets*/)
	{
		if (!pPlayer)
			return false;

		if (!pItem)
			return false;

		if (!isPlayerGuildLeader(pPlayer) || !isGuildHouseOwner(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie brauchen ein Gilden Haus um dies zu tuhn!");
			return false;
		};

		if (!isInGuildArea(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie befinden sich nicht in ihrer Gilden Area!");
			return false;
		}

		SpawnObject(pPlayer, OBJECT_TABLE);
		pPlayer->DestroyItemCount(pItem->GetEntry(), 1, true);
		return true;
	}
};

class Torch_Token : public ItemScript
{
public:
	Torch_Token() : ItemScript("Torch Token"){}

	bool OnUse(Player* pPlayer, Item* pItem, SpellCastTargets const& /*targets*/)
	{
		if (!pPlayer)
			return false;

		if (!pItem)
			return false;

		if (!isPlayerGuildLeader(pPlayer) || !isGuildHouseOwner(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie brauchen ein Gilden Haus um dies zu tuhn!");
			return false;
		};

		if (!isInGuildArea(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie befinden sich nicht in ihrer Gilden Area!");
			return false;
		}

		SpawnObject(pPlayer, OBJECT_TORCH);
		pPlayer->DestroyItemCount(pItem->GetEntry(), 1, true);

		return true;
	}
};

class Mailbox_Token : public ItemScript
{
public:
	Mailbox_Token() : ItemScript("Mailbox Token"){}

	bool OnUse(Player* pPlayer, Item* pItem, SpellCastTargets const& /*targets*/)
	{
		if (!pPlayer)
			return false;

		if (!pItem)
			return false;

		if (!isPlayerGuildLeader(pPlayer) || !isGuildHouseOwner(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie brauchen ein Gilden Haus um dies zu tuhn!");
			return false;
		};

		if (!isInGuildArea(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie befinden sich nicht in ihrer Gilden Area!");
			return false;
		}

		SpawnObject(pPlayer, OBJECT_MAILBOX);
		pPlayer->DestroyItemCount(pItem->GetEntry(), 1, true);

		return true;
	}
};

class Crate_Token : public ItemScript
{
public:
	Crate_Token() : ItemScript("Crate Token"){}

	bool OnUse(Player* pPlayer, Item* pItem, SpellCastTargets const& /*targets*/)
	{
		if (!pPlayer)
			return false;

		if (!pItem)
			return false;

		if (!isPlayerGuildLeader(pPlayer) || !isGuildHouseOwner(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie brauchen ein Gilden Haus um dies zu tuhn!");
			return false;
		};

		if (!isInGuildArea(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie befinden sich nicht in ihrer Gilden Area!");
			return false;
		}

		SpawnObject(pPlayer, OBJECT_CRATE);
		pPlayer->DestroyItemCount(pItem->GetEntry(), 1, true);

		return true;
	}
};

class A_Flag_Token : public ItemScript
{
public:
	A_Flag_Token() : ItemScript("A_Flag Token"){}

	bool OnUse(Player* pPlayer, Item* pItem, SpellCastTargets const& /*targets*/)
	{
		if (!pPlayer)
			return false;

		if (!pItem)
			return false;

		if (!isPlayerGuildLeader(pPlayer) || !isGuildHouseOwner(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie brauchen ein Gilden Haus um dies zu tuhn!");
			return false;
		};

		if (!isInGuildArea(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie befinden sich nicht in ihrer Gilden Area!");
			return false;
		}

		SpawnObject(pPlayer, OBJECT_A_FLAG);
		pPlayer->DestroyItemCount(pItem->GetEntry(), 1, true);

		return true;
	}
};

class H_Flag_Token : public ItemScript
{
public:
	H_Flag_Token() : ItemScript("H_Flag Token"){}

	bool OnUse(Player* pPlayer, Item* pItem, SpellCastTargets const& /*targets*/)
	{
		if (!pPlayer)
			return false;

		if (!pItem)
			return false;

		if (!isPlayerGuildLeader(pPlayer) || !isGuildHouseOwner(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie brauchen ein Gilden Haus um dies zu tuhn!");
			return false;
		};

		if (!isInGuildArea(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie befinden sich nicht in ihrer Gilden Area!");
			return false;
		}


		SpawnObject(pPlayer, OBJECT_H_FLAG);
		pPlayer->DestroyItemCount(pItem->GetEntry(), 1, true);

		return true;
	}
};

class Chair_Token : public ItemScript
{
public:
	Chair_Token() : ItemScript("Chair Token"){}

	bool OnUse(Player* pPlayer, Item* pItem, SpellCastTargets const& /*targets*/)
	{
		if (!pPlayer)
			return false;

		if (!pItem)
			return false;

		if (!isPlayerGuildLeader(pPlayer) || !isGuildHouseOwner(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie brauchen ein Gilden Haus um dies zu tuhn!");
			return false;
		};

		if (!isInGuildArea(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie befinden sich nicht in ihrer Gilden Area!");
			return false;
		}

		SpawnObject(pPlayer, OBJECT_CHAIR);
		pPlayer->DestroyItemCount(pItem->GetEntry(), 1, true);

		return true;
	}
};

class Firepit_Token : public ItemScript
{
public:
	Firepit_Token() : ItemScript("Firepit Token"){}

	bool OnUse(Player* pPlayer, Item* pItem, SpellCastTargets const& /*targets*/)
	{
		if (!pPlayer)
			return false;

		if (!pItem)
			return false;

		if (!isPlayerGuildLeader(pPlayer) || !isGuildHouseOwner(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie brauchen ein Gilden Haus um dies zu tuhn!");
			return false;
		};

		if (!isInGuildArea(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie befinden sich nicht in ihrer Gilden Area!");
			return false;
		}

		SpawnObject(pPlayer, OBJECT_FIREPIT);
		pPlayer->DestroyItemCount(pItem->GetEntry(), 1, true);

		return true;
	}
};

class Vault_Token : public ItemScript
{
public:
	Vault_Token() : ItemScript("Vault Token"){}

	bool OnUse(Player* pPlayer, Item* pItem, SpellCastTargets const& /*targets*/)
	{
		if (!pPlayer)
			return false;

		if (!pItem)
			return false;

		if (!isPlayerGuildLeader(pPlayer) || !isGuildHouseOwner(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie brauchen ein Gilden Haus um dies zu tuhn!");
			return false;
		};

		if (!isInGuildArea(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie befinden sich nicht in ihrer Gilden Area!");
			return false;
		}

		SpawnObject(pPlayer, OBJECT_GUILDVAULT);
		pPlayer->DestroyItemCount(pItem->GetEntry(), 1, true);

		return true;
	}
};

class Barber_Token : public ItemScript
{
public:
	Barber_Token() : ItemScript("Barber Token"){}

	bool OnUse(Player* pPlayer, Item* pItem, SpellCastTargets const& /*targets*/)
	{
		if (!pPlayer)
			return false;

		if (!pItem)
			return false;

		if (!isPlayerGuildLeader(pPlayer) || !isGuildHouseOwner(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie brauchen ein Gilden Haus um dies zu tuhn!");
			return false;
		};

		if (!isInGuildArea(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie befinden sich nicht in ihrer Gilden Area!");
			return false;
		}

		SpawnObject(pPlayer, OBJECT_BARBER_CHAIR);
		pPlayer->DestroyItemCount(pItem->GetEntry(), 1, true);

		return true;
	}
};

class Cranberry_Token : public ItemScript
{
public:
	Cranberry_Token() : ItemScript("Cranberry Token"){}

	bool OnUse(Player* pPlayer, Item* pItem, SpellCastTargets const& /*targets*/)
	{
		if (!pPlayer)
			return false;

		if (!pItem)
			return false;

		if (!isPlayerGuildLeader(pPlayer) || !isGuildHouseOwner(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie brauchen ein Gilden Haus um dies zu tuhn!");
			return false;
		};

		if (!isInGuildArea(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Sie befinden sich nicht in ihrer Gilden Area!");
			return false;
		}

		SpawnObject(pPlayer, OBJECT_CRANBERRY_BUSH);
		pPlayer->DestroyItemCount(pItem->GetEntry(), 1, true);

		return true;
	}
};

//token vendor

class Guild_Token_Vendor : public CreatureScript
{
public:
	Guild_Token_Vendor() : CreatureScript("Token Vendor"){}

	bool OnGossipHello(Player * pPlayer, Creature * pCreature)
	{
		if (!isPlayerGuildLeader(pPlayer))
		{
			pPlayer->GetSession()->SendNotification("Nur der Gilden Meister kann dies tuhn!");
			pPlayer->PlayerTalkClass->SendCloseGossip();
			return false;
		}
		if (isGuildHouseOwner(pPlayer))
		{
			pPlayer->PlayerTalkClass->ClearMenus();
			pPlayer->ADD_GOSSIP_ITEM(4, "Willkommen beim IKEA Shop, Viel erfolg beim einkaufen!", GOSSIP_SENDER_MAIN, GOSSIP_ACTION_TRADE);
			pPlayer->ADD_GOSSIP_ITEM(3, "Beenden.", GOSSIP_SENDER_MAIN, 2);
			pPlayer->PlayerTalkClass->SendGossipMenu(2, pCreature->GetGUID());
			//return true;
		}
		else
		{
			pPlayer->GetSession()->SendNotification("Nur der Gilden Meister kann dies tuhn!");
			return false;
		}
		return true;
	}

	bool OnGossipSelect(Player * pPlayer, Creature * pCreature, uint32 /*uiSender*/, uint32 uiAction)
	{
		switch (uiAction)
		{
		case GOSSIP_ACTION_TRADE:
			pPlayer->GetSession()->SendListInventory(pCreature->GetGUID());
			break;
		case 2:
			pPlayer->PlayerTalkClass->SendCloseGossip();
			break;
		}
		return true;
	}
};


void AddSC_GuildHouse()
{
	new GuildHouse_NPC();
	new Table_Token();
	new Torch_Token();
	new Mailbox_Token();
	new Crate_Token();
	new A_Flag_Token();
	new H_Flag_Token();
	new Chair_Token();
	new Firepit_Token();
	new Vault_Token();
	new Barber_Token();
	new Guild_Token_Vendor();
	new Cranberry_Token();
}

Guild House fix for TC Cataclysm

Xaver

Respected Member