Thanks for the help all
'> And that is indeed a very cool system lordofworms. To do it on mine I eventually wrote a script that bounces the player name over to the database at the same time the other housing data goes in:
string oHousemaster = GetName(oPC);
SetCampaignString("hh_doors", sDoorID + "Ownedby", oHousemaster);
I then wrote a custom trigger which I placed in front of each house, using the onenter script below. When triggered by any creature it renames the sign closest to it with the PC name if its corresponding house is owned. Just need to attract some players now
'>
#include "hh_include"
void signmaker(string sDoorID)
{
string oTag = "saleboard";
object oSign = GetNearestObjectByTag(oTag);
if (GetCampaignString("hh_doors", sDoorID) != "" && GetName(oSign) == "House For Sale!")
{
string oBname = GetCampaignString("hh_doors", sDoorID + "Ownedby");
SetName(oSign, "Property of: " + oBname);
}
}
void main()
{
string oDoorTag = "hh_door_enter_large";
object oDoor = GetNearestObjectByTag(oDoorTag);
string sDoorID = GetDoorID(oDoor);
signmaker(sDoorID);
oDoorTag = "hh_door_enter";
oDoor = GetNearestObjectByTag(oDoorTag);
sDoorID = GetDoorID(oDoor);
signmaker(sDoorID);
}