forward OnOSetNameCheck(playerid, newname[], oldname[]); //check if newname exists
public OnOSetNameCheck(playerid, newname[], oldname[])
{
	new rows, fields;
	cache_get_data(rows, fields);

	if(strlen(newname) > MAX_PLAYER_NAME) return SendClientMessage( playerid, COLOR_GREY, "{FF0000}Error:{FFFFFF} the new name is too long." );
	if(rows) return SendClientMessage(playerid, COLOR_GREY, "{FF0000}Error:{FFFFFF} that name is taken.");

	new query[128];
	mysql_format(sqlGameConnection, query, sizeof(query), "SELECT ID, `BizKey`, `pHouseID`, `FMember`, `RadioStation` FROM `players` WHERE `Name` = '%e'", oldname);
	mysql_pquery(sqlGameConnection, query, "OnOSetNameProcess", "iss", playerid, newname, oldname);
	return 1;
}

forward OnOSetNameProcess(playerid, newname[], oldname[]);
public OnOSetNameProcess(playerid, newname[], oldname[])
{
	new str[128];
	new rows, fields, query[128];
	cache_get_data(rows, fields);

	if(!rows) return SendClientMessage(playerid, COLOR_GREY, "{FF0000}Error:{FFFFFF} that account doesn't exist.");

	new BizKey = cache_get_field_content_int(0, "BizKey");

	new FMember =cache_get_field_content_int(0, "FMember");
	new RadioStation = cache_get_field_content_int(0, "RadioStation");

	//set the non player variables
	if(BizKey != -1) //owns a business
	{
		strmid(BizInfo[BizKey][bOwner], newname, 0, strlen(newname), 255);
		// Government seized
		if(BizInfo[BizKey][bSeized] == 1)
		{
			format(str, sizeof(str), "{AFAFAF}%s{AFAFAF}\n{FFFFFF}This business has been seized by the\n{696969}Government", BizInfo[BizKey][bName]);
		}
		// Judicial Department seized
		else if(BizInfo[BizKey][bSeized] == 2) {
			format(str, sizeof(str), "{AFAFAF}%s{AFAFAF}\n{FFFFFF}This business has been seized by the\n{BA6103}Department of Justice", BizInfo[BizKey][bName]);
		}
		else
		{
			if(BizInfo[BizKey][bLocked] == 1)
			{
				format(str, sizeof(str), "{3D97E0}%s{FFFFFF}\nOwner: %s", BizInfo[BizKey][bName], BizInfo[BizKey][bOwner]);
			}
			else
			{
				format(str, sizeof(str), "{3D97E0}%s{FFFFFF}\nOwner: %s", BizInfo[BizKey][bName], BizInfo[BizKey][bOwner]);
			}
		}
		UpdateDynamic3DTextLabelText(Text3D:BizText[BizKey], COLOR_BIZTEXT, str);
	}

	if(FMember != 255) //owns a family
	{
		if(strcmp(FamilyInfo[FMember][FamilyLeader], oldname, true) == 0)
		{
			strmid(FamilyInfo[FMember][FamilyLeader], newname, 0, strlen(newname), 255);
			SaveFamilies();
		}
	}
	if(RadioStation != 255) //owns a radio station
	{
		if(strcmp(radioInfo[RadioStation][ownerName], oldname, true) == 0)
		{
			strmid(radioInfo[RadioStation][ownerName], newname, 0, strlen(newname), 255);
			SaveRadios();
		}
	}

	mysql_format(sqlGameConnection, query, sizeof(query), "UPDATE `players` SET `Name` = '%e' WHERE `Name` = '%e'", newname, oldname);
	mysql_pquery(sqlGameConnection, query); //send the query

	mysql_format(sqlGameConnection, query, sizeof(query), "UPDATE `newcrimes` SET `RealName` = '%e' WHERE `RealName` = '%e'", newname, oldname);
	mysql_pquery(sqlGameConnection, query);

	mysql_format(sqlGameConnection, query, sizeof(query), "UPDATE `tickets` SET `IssuerName` = '%e' WHERE `IssuerName` = '%e'", newname, oldname);
	mysql_pquery(sqlGameConnection, query);

	//log the namechange
	format(str, sizeof(str), "%s has renamed %s to %s.", PlayerName(playerid), oldname, newname);
	StatLog(str);

	format(str, sizeof(str), "You have renamed %s to %s.", oldname, newname); //To admin
	SendClientMessage(playerid, COLOR_GREY, str);

	mysql_format(sqlGameConnection, query, sizeof(query), "SELECT `ID` FROM `players` WHERE `Name` = '%e'", newname);
	mysql_pquery(sqlGameConnection, query, "OnGetSQLID", "is", playerid, newname);
	if(cache_num_rows() != 1) return SendClientMessage(playerid, COLOR_GREY, "{FF0000}Error:{FFFFFF} that account doesn't exist.");
	new sqlid;
	sqlid = cache_get_field_content_int(0, "ID");
	NameChangeLog(oldname, newname, PlayerName(playerid), PlayerInfo[playerid][pID], sqlid);
	return 1;
}