I am sorry but I am afraid this won't work as you think it would. The "External database" authentication module is not intended to be used for executing custom SQL queries. You can check the auth_db or enrol_database modules in Moodle to see how they use the adodb library to connect to the external database, and use similar approach in your code.
hello David Mudrák
report_overviewstats and install plugins in my personal moodle works perfectly but I wanted to install on the platform of the university also uses moodle to see how I showed the statistics but generate them was loaded but went blank page not if many records .
Not if you happened but I'm looking beyond the problem and nothing would be of great help you to recommend me something.
Hi Jose. Always you get a blank page in Moodle, it typically means there is an error and the site is configured not to display errors. You can either check the web server / PHP error logs, or turn on errors display in Moodle administration UI. Some useful error message should appear instead of the blank page.
Hello David ,
thanks for the reply was very helpful , and I could see the error moodle
showing me and the next Fatal error: Allowed memory size of 134217728 bytes
exhausted ( tried to allocate 8208 bytes) in / var / www / moodle / admin /
tool / log / store / standard / classes / log / store.php on line 81 , and it
is out of memory then I went to the line 81 and shows me the following $ data [
'other '] = unserialize ($ data [' other' ] ) ; moodle --- Linea 81 , if not be
error moodle you can help me with this error thanks David .
hi David thanks for the reply I will check to see how it goes , finally you wanted to say something , I need to create some reports , I will be generated from moodle these reports would be a report that shows me the income of the student to see if they are using the platform , the other teachers would be the same case and finally a report that shows me the statistics on how many people entered the platform would appreciate David would be helpful if you have the idea of how to create these reports.
Thanks.