* Added an 'RDAIRPLAY.LOGO_PATH' field to the database.
* Incremented the database version to 355.
* Added 'RDAirPlayConf::logoPath()' and
'RDAirPlayConf::setLogoPath()' methods.
* Added a 'Logo Image' control to the 'Configure RDAirPlay' dialog
in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Fixed a regression in rddbmgr(8) in '--check' mode that caused
alteration of a table's engine type to fail.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Fixed a bug in rddbmgr(8) that generated a SQL error when checking
for orphaned scheduler code rules when no Clocks existed in the
database.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added a 'SERVICES.INCLUDE_MUS_IMPORT_MARKERS' field to the database.
* Added a 'SERVICES.INCLUDE_TFC_IMPORT_MARKERS' field to the database.
* Added a 'LOGS.INCLUDE_MUS_IMPORT_MARKERS' field to the database.
* Added a 'LOGS.INCLUDE_TFC_IMPORT_MARKERS' field to the database.
* Incremented the database version to 354.
* Replaced the 'Include Import Marker in Finished Logs' checkbox
with 'Include Music Import Markers in Finished Logs' and
'Include Traffic Import Markers in Finished Logs' checkboxes in
the 'Edit Service' dialog in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added a 'SYSTEM.REALM_NAME' field to the database.
* Incremented the database version to 353.
* Added 'RDSystem::realmName()' and 'RDSystem::setREalmName()'
methods.
* Added a 'realm_name' member to the 'rd_system_settings' struct
in the RivWebCApi library.
* Added a 'Realm Name' control to the 'System-Wide Settings'
dialog in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Removed the 'SYSTEM.TIME_FORMAT' field from the database.
* Added a 'SYSTEM.SHOW_TWELVE_HOUR_TIME' field to the database.
* Incremented the database version 352.
* Added 'RDSystem::showTwelveHourTime()' and
'RDSystem::setShowTwelveHourTime()' methods.
* Refactored 'RDTimeEdit' to support 12 hour time format.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added 'SYSTEM.LONG_DATE_FORMAT', 'SYSTEM.SHORT_DATE_FORMAT'
and 'SYSTEM.TIME_FORMAT' fields to the database.
* Incremented the database version to 351.
* Added 'RDSystem::longDateFormat()', 'RDSystem'setLongDateFormat()',
'RDSystem::shortDateFormat()', 'RDSystem::setShortDateFormat()',
'RDSystem::timeFormat()' and 'RDSystem::setTimeFormat()' methods.
* Added a 'Date/Time Formats' section to the 'System-Wide Settings'
dialog in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added an 'AUDIO_INPUTS.LABEL' field to the database.
* Added an 'AUDIO_OUTPUTS.LABEL' field to the database.
* Incremented the database version to 350.
* Added 'RDAudioPort::inputPortLabel()',
'RDAudioPort::setInputPortLabel()' 'RDAudioPort::outputPortLabel()'
and 'RDAudioPort::setOutputPortLabel()' methods.
* Added 'Label' fields to the 'Input Port' and 'Output Port'
sections of the 'Edit Audio Ports' dialog in rdadmin(1).
* Added code to rdairplay(1) to use port labels on audio meters.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
Fix typos in lib/rdsvc.cpp that threw SQL errors.
Fix typos in rdlibrary/list_reports.cpp that threw SQL errors.
Fix typos in utils/rdclilogedit/operations.cpp that threw SQL errors.
Fix typos in utils/rddbmgr/updateschema.cpp that threw SQL errors.
Signed-off-by: David Klann <dklann@broadcasttool.com>
* Changed the 'RDAIRPLAY_EXIT_PASSWORD' field from 'varchar(41)'
to 'varchar(48)'.
* Incremented the database version to 349.
* Renamed the 'RDSha1Hash()' function to 'RDSha1HashFile()'.
* Added 'RDSha1HashPassword()' function in 'lib/rdhash.[cpp|h]'.
* Added 'RDSha1HashCheckPassword()' function in 'lib/rdhash.[cpp|h]'.
* Changed the hashing algorithm used for the Exit Password for
rdairplay(1) to salted SHA1.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Fixed regressions that caused SQL errors when performing
schema upgrades and reversions.
* Disabled the reversion from schema 257=>256 in rddbmgr(8).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Fixed regressions caused by changes in behavior in the null
constructor of 'QTime' between Qt4 and Qt5.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Escaped all SQL identifiers in 'utils/rddbmgr/'.
* Replaced " with ' delimiters in all SQL literal strings in
'utils/rddbmgr/'.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Cleaned up compilation warnings in rddbmgr(8).
* Rebased rddbmgr(8) to use 'QCoreApplication' rather than
'QApplication'.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Commented out code to initialize the 'NEXUS_STATIONS' table
in rddbmgr(8).
* Fixed a bug in 'CheckSchedCodeRules()' in rddbmgr(8) that
would throw a SQL error when no schedule codes were defined.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added 'RDSchedRulesModel'.
* Added a pseudo-schema change to force checking of schedule code
rules.
* Incremented the database version to 348.
* Added a check for scheduler code rules to rddbmgr(8).
* Refactored the 'Scheduler Rules' dialog in rdlogmanager(1) to
use the model based API.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Removed the 'USERS.ADMIN_USERS_PRIV' field from the database.
* Added a 'USERS.ADMIN_RSS_PRIV' field to the database.
* Incremented the database version to 346.
* Added 'RDUser:adminRss()' and 'RDUser::setAdminRss()' methods.
* Added an 'Administer RSS Feeds' checkbox to the 'Administrative
Rights' section of the 'User' dialog in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added a 'DROPBOXES.SEND_EMAIL' field to the database.
* Incremented the database version to 345.
* Added 'RDDropbox::sendEmail()' and 'RDDropbox::setSendEmail()'
methods.
* Added a 'Send e-mail reports' checkbox to the 'Dropbox
Configuration' dialog in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added a 'SYSTEM.ORIGIN_EMAIL_ADDRESS' field to the database.
* Added a 'GROUPS.NOTIFY_EMAIL_ADDRESS' field to the database.
* Incremented the database version to 344.
* Added an 'Origin E-Mail Address' control to the 'System-Wide
Settings' dialog in rdadmin(1).
* Added a 'Notification E-Mail Addresses' control to the 'Group'
dialog in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Fixed a bug in rddbmgr(8) that could cause the 'RSS_SCHEMAS',
'FEED_IMAGES' and 'SUPERFEED_MAPS' to be created with incorrect
character set and engine type values.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added an 'ENCODER_PRESETS' table to the database.
* Incremented the database verssion to 343.
* Added an 'Encoder Profiles' dialog to rdadmin(1).
* Removed static content dependencies from the WebGet service.
* Refactored the WebGet service to use Encoder Profiles.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added an index to the 'GPIO_EVENTS.EVENT_DATETIME' field.
* Incremented the database version to 342.
* Implemented the '--verbose' switch for rdmaint(8).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added an 'IMPORTER_LINES.FILE_LINE' field to the database.
* Added an 'IMPORTER_LINES.LINK_START_TIME' field to the database.
* Added an 'IMPORTER_LINES.LINK_LENGTH' field to the database.
* Incremented the database version to 341.
* Reimplemented the 'RDSvc::linkLog()' and 'RDEventLine::linkLog()'
methods to use the updated 'IMPORTER_LINES' table schema.
* Added generation of an 'RDLogManager Error Report' when errors
are detected when importing an external scheduler file in
rdlogmanager(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added an 'IMPORTER_LINES.TYPE' field to the database.
* Removed the 'not null' attribute from the
'IMPORTER_LINES.START_HOUR' field in the database.
* Removed the 'not null' attribute from the
'IMPORTER_LINES.START_SECS' field in the database.
* Removed the 'IMPORTER_LINES.LINK_LENGTH' field from the database.
* Removed the 'IMPORTER_LINES.INSERT_TRACK' field from the database.
* Removed the 'IMPORTER_LINES.INSERT_FIRST' field from the database.
* Removed the 'IMPORTER_LINES.TRACK_STRING' field from the database.
* Removed the 'IMPORTER_LINES.LINK_START_TIME' field from the database.
* Removed the 'IMPORTER_LINES.LINK_LENGTH' field from the database.
* Incremented the database version to 340.
* Added type icons to the 'Imported Events' list in the 'Test Import'
dialog in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added a 'SERVICES.SUB_EVENT_INHERITANCE' field to the
database.
* Incremented the database version to 339.
* Added 'RDSvc::subEventInheritance()' and
'RDSvc::setSubEventInheritance()' methods.
* Added an 'Inline Traffic Inheritance' control to the 'Edit Service'
dialog in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Changed the 'FEEDS.CHANNEL_LANGUAGE' database field from
'varchar(5)' to' 'varchar(8)'.
* Incremented the database version to 338.
* Increased the 5 character length limitation of the
'Channel Language' field for podcasts to 8.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added 'FEEDS.CHANNEL_IMAGE_ID_IDX', 'FEEDS.DEFAULT_ITEM_IMAGE_ID_IDX'
and 'PODCASTS.ITEM_IMAGE_ID_IDX' indexes to the database.
* Incremented the database version to 337.
* Added a sanity check to the 'Image Manager' dialog in
rdadmin(1) to prevent deletion of in-use images.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Modified the type of the 'FEED_IMAGES.DATA' database field
to 'longblob'.
* Incremented the database version to 336.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added a 'PODCASTS.SHA1_HASH' field to the database.
* Incremented the database version to 335.
* Added 'RDPodcast::sha1Hash()' and 'RDPodcast::setSha1Hash()'
methods.
* Implemented audio relinking for podcast media files.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Changed the database field 'FEEDS.PURGE_PASSWORD' from
'varchar(64)' to 'text'.
* Changed the contents of the 'FEEDS.PURGE_PASSWORD' database
field from plaintext to Base64 encoding.
* Incremented the database version to 334.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added a 'STATIONS.SSH_IDENTITY_FILE' field to the database.
* Added a 'RECORDINGS.URL_USE_ID_FILE' field to the database.
* Added a 'FEEDS.PURGE_USE_ID_FILE' field to the database.
* Incremented the database version to 333.
* Added 'RDStation::sshIdentityFile()' and
'RDStation::setSshIdentityFile()' methods.
* Added 'RDRecording::urlUseIdFile()' and
'RDRecording::setUrlUseIdFile()' methods.
* Added 'RDFeed::purgeUseIdFile()' and 'RDFeed::setPurgeUseIdFile()'
methods.
* Added a 'SSH Ident. File' control to the 'Host' dialog in
rdadmin(1).
* Added an 'Authenticate with local identity file' checkbox to
the 'Feed' dialog in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added a 'FEEDS.CHANNEL_AUTHOR_IS_DEFAULT' field to the database.
* Incremented the database version to 332.
* Added 'RDFeed::channelAuthorIsDefault()' and
'RDFeed::setChannelAuthorIsDefault()' methods.
* Added a 'Use as default Item Author' checkbox to the 'Edit Feed'
dialog in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Dropped the 'ENCODERS', 'ENCODER_BITRATES', 'ENCODER_BITRATES'
and 'ENCODER_CHANNELS' tables from the database.
* Incremented the database version to 331.
* Removed the 'RDSettings::customCommandLine()',
'RDSettings::setCustomCommandLine()' and
' RDSettings::resolvedCustomCommandLine()' methods.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added a 'PODCASTS.ORIGIN_LOGIN_NAME' field to the database.
* Added a 'PODCASTS.ORIGIN_STATION' field to the database.
* Incremented the database version to 330.
* Changed the 'Origin' column to 'Start' in the 'Podcast Item List'
dialog in rdcastmanager(1).
* Added a 'Posted By' column to the 'Podcast Item List' dialog in
rdcastmanager(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added a 'SYSTEM.RSS_PROCESSOR_STATION' field to the database.
* Added a 'PODCASTS.EXPIRATION_DATETIME' field to the database.
* Dropped the 'PODCASTS.SHELF_LIFE' field from the database.
* Incremented the database version to 329.
* Modified convention to use local system time for all podcast
components.
* Added 'RDPodcast::expirationDateTime()' and
'RDPodcast::setExpirationDateTime()' methods.
* Removed 'RDPodcast::shelfLife()' and 'RDPodcast::setShelfLife()'
methods.
* Added an rdrssd(8) daemon.
* Removed the rdpurgecasts(8) utility.
* Added 'RDSystem::rssProcessorStation()' and
'RDSystem::setRssProcessorStation()' methods.
* Added a 'Process RSS Updates' control to the 'System-Wide Settings'
dialog in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Dropped the 'FEEDS.AUDIENCE_METRICS' field from the database.
* Dropped the 'FEEDS.KEEP_METADATA' field from the database.
* Dropped the 'FEEDS.MEDIA_LINK_MODE' field from the database.
* Dropped the 'FEEDS.REDIRECT_PATH' field from the database.
* Dropped the 'CAST_DOWNLOADS' table from the database.
* Incremented the database version to 328.
* Removed support for dynamically generated RSS feed metadata.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added a 'FEEDS.CHANNEL_SUB_CATEGORY' field to the database.
* Incremented the database version to 327.
* Added 'RDFeed::channelSubCategory()' and
'RDFeed::setChannelSubCategory()' methods.
* Added a 'RDRssCategoryBox' widget.
* Updated the 'Edit Feed' dialog in rdadmin(1) to use the
'RDRssCategoryBox' widget.
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
* Added 'FEEDS.CHANNEL_AUTHOR', 'FEEDS.CHANNEL_OWNER_NAME',
'FEEDS.CHANNEL_OWNER_EMAIL', 'FEEDS.CHANNEL_EXPLICIT' and
'PODCASTS.ITEM_EXPLICIT' fields to the database.
* Incremented the database version to 326.
* Added 'RDFeed::channelAuthor()', 'RDFeed::setChannelAuthor()',
'RDFeed::channelOwnerName()', 'RDFeed::setChannelOwnerName()',
'RDFeed::channelOwnerEmail(), 'RDFeed::setChannelOwnerEmail()',
'RDFeed::channelExplicit()', 'RDFeed::setChannelExplicit()',
'RDPodcast::itemExplicit()' and 'RDPodcast::setItemExplicit()'
methods.
* Added 'Author', Owner Name' and 'Owner E-Mail controls to the
'Edit Feed' dialog box in rdadmin(1).
* Added a 'Channel contains explicit content' checkbox to the
'Edit Feed' dialog box in rdadmin(1).
Signed-off-by: Fred Gleason <fredg@paravelsystems.com>
