+}
+
+static void update_volinchanger(UAContext *ua, char *val, MEDIA_DBR *mr)
+{
+ int InChanger;
+ char ed1[50];
+
+ POOL_MEM query(PM_MESSAGE);
+ if (!is_yesno(val, &InChanger)) {
+ bsendmsg(ua, _("Invalid value. It must be yes or no.\n"));
+ return;
+ }
+ Mmsg(query, "UPDATE Media SET InChanger=%d WHERE MediaId=%s",
+ InChanger, edit_int64(mr->MediaId, ed1));
+ if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) {
+ bsendmsg(ua, "%s", db_strerror(ua->db));
+ } else {
+ bsendmsg(ua, _("New InChanger flag is: %s\n"),
+ mr->InChanger==1?_("yes"):_("no"));
+ }
+}
+
+
+static void update_volslot(UAContext *ua, char *val, MEDIA_DBR *mr)
+{
+ POOL_DBR pr;
+
+ memset(&pr, 0, sizeof(POOL_DBR));
+ pr.PoolId = mr->PoolId;
+ if (!db_get_pool_record(ua->jcr, ua->db, &pr)) {
+ bsendmsg(ua, "%s", db_strerror(ua->db));
+ return;
+ }
+ mr->Slot = atoi(val);
+ if (pr.MaxVols > 0 && mr->Slot > (int)pr.MaxVols) {
+ bsendmsg(ua, _("Invalid slot, it must be between 0 and MaxVols=%d\n"),
+ pr.MaxVols);
+ return;
+ }
+ /*
+ * Make sure to use db_update... rather than doing this directly,
+ * so that any Slot is handled correctly.
+ */
+ if (!db_update_media_record(ua->jcr, ua->db, mr)) {
+ bsendmsg(ua, _("Error updating media record Slot: ERR=%s"), db_strerror(ua->db));
+ } else {
+ bsendmsg(ua, _("New Slot is: %d\n"), mr->Slot);
+ }