break;
case 'webcontent':
default:
if ($DB->record_exists_select('rcontent', 'bookid = :bookid AND course != :course', array('bookid' => $bookid, 'course' => SITEID))) {
$success = false;
}
break;
}
if (!$success) {
echo $OUTPUT->notification(get_string('book_deleted_act_error', 'local_rcommon', $bookid));
} else {
$sql = 'SELECT * FROM {rcommon_user_credentials} RUC INNER JOIN {rcommon_books} RB ON RB.isbn = RUC.isbn WHERE RUC.euserid != 0 AND RB.id = :bookid';
if ($DB->record_exists_sql($sql, array('bookid' => $bookid))) {
echo $OUTPUT->notification(get_string('book_deleted_cred_error', 'local_rcommon', $bookid));
} else {
if (rcommon_book::delete($bookid, $id)) {
echo $OUTPUT->notification(get_string('book_deleted', 'local_rcommon', $bookid));
}
}
}
}
}
}
$params = array('publisher' => $id);
$sql = 'SELECT b.id, b.name, b.levelid, b.isbn, b.format, l.name AS levelname, count(uc.isbn) as total, SUM(case when uc.euserid > 0 THEN 1 ELSE 0 END) as assig
FROM {rcommon_books} b
INNER JOIN {rcommon_level} l
ON b.levelid=l.id
LEFT JOIN {rcommon_user_credentials} uc
ON b.isbn = uc.isbn
WHERE b.publisherid=:publisher
