- stat = 0;
- break;
- } else {
- bstrncpy(Vols[i].VolumeName, row[0], MAX_NAME_LENGTH);
- bstrncpy(Vols[i].MediaType, row[1], MAX_NAME_LENGTH);
- Vols[i].FirstIndex = str_to_uint64(row[2]);
- Vols[i].LastIndex = str_to_uint64(row[3]);
- Vols[i].StartFile = str_to_uint64(row[4]);
- Vols[i].EndFile = str_to_uint64(row[5]);
- Vols[i].StartBlock = str_to_uint64(row[6]);
- Vols[i].EndBlock = str_to_uint64(row[7]);
- }
- }
+ stat = 0;
+ break;
+ } else {
+ DBId_t StorageId;
+ bstrncpy(Vols[i].VolumeName, row[0], MAX_NAME_LENGTH);
+ bstrncpy(Vols[i].MediaType, row[1], MAX_NAME_LENGTH);
+ Vols[i].FirstIndex = str_to_uint64(row[2]);
+ Vols[i].LastIndex = str_to_uint64(row[3]);
+ Vols[i].StartFile = str_to_uint64(row[4]);
+ Vols[i].EndFile = str_to_uint64(row[5]);
+ Vols[i].StartBlock = str_to_uint64(row[6]);
+ Vols[i].EndBlock = str_to_uint64(row[7]);
+// Vols[i].Copy = str_to_uint64(row[8]);
+ Vols[i].Slot = str_to_uint64(row[9]);
+ StorageId = str_to_uint64(row[10]);
+ Vols[i].Storage[0] = 0;
+ SId[i] = StorageId;
+ }
+ }
+ for (i=0; i < stat; i++) {
+ if (SId[i] != 0) {
+ Mmsg(mdb->cmd, "SELECT Name from Storage WHERE StorageId=%s",
+ edit_int64(SId[i], ed1));
+ if (QUERY_DB(jcr, mdb, mdb->cmd)) {
+ if ((row = sql_fetch_row(mdb)) && row[0]) {
+ bstrncpy(Vols[i].Storage, row[0], MAX_NAME_LENGTH);
+ }
+ }
+ }
+ }
+ if (SId) {
+ free(SId);
+ }