public void UpdateActive(TeleportDescription description)
{
Db.Query().CommandText("update teleportdescriptions set active=@active where id=@id")
.SetParameter("@id", description.id)
.SetParameter("@active", description.active)
.ExecuteNonQuery().ThrowIfEqual(0, ErrorCodes.SQLUpdateError);
}
public void Activate(Player player, TeleportDescription description)
{
if (_usedTeleportDescription != null)
{
return;
}
_usedTeleportDescription = description;
var gang = player.Gang;
if (gang == null)
{
return;
}
var result = ToDictionary();
Message.Builder.SetCommand(Commands.TeleportTargetSet).WithData(result).ToCharacters(gang.GetMembers()).Send();
}
public void Insert(TeleportDescription description)
{
const string insertCommand = @"INSERT dbo.teleportdescriptions (
description,
sourcecolumn,
targetcolumn,
sourcezone,
sourcerange,
targetzone,
targetx,
targety,
targetz,
targetrange,
usetimeout,
listable,
type
) VALUES (
@description,
@sourcecolumn,
@targetcolumn,
@sourcezone,
7,
@targetzone,
NULL,
NULL,
NULL,
7,
0,
1,
@type
) ";
Db.Query().CommandText(insertCommand)
.SetParameter("@description", description.description)
.SetParameter("@sourcecolumn", description.SourceTeleport?.Eid)
.SetParameter("@targetcolumn", description.TargetTeleport?.Eid)
.SetParameter("@sourcezone", description.SourceZone?.Id)
.SetParameter("@targetzone", description.TargetZone?.Id)
.SetParameter("@type", (int)description.descriptionType)
.ExecuteNonQuery().ThrowIfEqual(0, ErrorCodes.SQLInsertError);
}
