Paypal plugin: in what table is the cost by course stored?

Paypal plugin: in what table is the cost by course stored?

by Irene Azoia -
Number of replies: 3

Moodle version 2.3

Re Paypal enrollment plugin: As I understand it, there is a default site wide course cost.  In addition, there is a cost that can be set for each course separately.  In what table are these costs stored in the Moodle database?

 

 

Average of ratings: -
In reply to Irene Azoia

Re: Paypal plugin: in what table is the cost by course stored?

by Irene Azoia -

does anyone know the answer to this question?

In reply to Irene Azoia

Re: Paypal plugin: in what table is the cost by course stored?

by Floyd Saner -

Table:  mdl_enrol     look for entries 'paypal' in the enrol field

Fields:  cost and currency.

 

 

In reply to Floyd Saner

Re: Paypal plugin: in what table is the cost by course stored?

by Irene Azoia -

Thanks Floyd.  I'm familiar with those fields, but those are associated with each enrollment.  I'm looking for the cost that is associated with each course.  When the paypal plugin is set-up for each course, the cost for that course is entered and stored.  When a student enrolls, it uses that course cost to populate mdl_enrol.cost.  I'm trying to locate where the course cost is stored.  Need that data for a report.  I've looked through every database table I can think might hold that data, including all the config tables and mdl_enrol_paypal, but can't seem to find it.