SQL query to get total number of resources in a course.?

SQL query to get total number of resources in a course.?

by madhusudan kh -
Number of replies: 0

Hi,

I am developing a custom course report, and for this i need to find total number of  resources existing in a course, I upgraded moodle from 1.9 to 2.4 step by step  in 1.9 i used to get from resource table , but  after upgrading to 2.4 I have two tables 'resource_old' and 'resource' both tables contains data

resource table contains ~78 records whereas resource_old contains ~500 records.

so in this situation can anyone tell me how to get the total resources in a course ?

 

Average of ratings: -