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); }