nil.enroll(aetheric_username, quantum_class_id) (adric) wrote,
nil.enroll(aetheric_username, quantum_class_id)

Re: MySQL query to see enrolled students

Hi to you both

Thanks to GP so much for that query!

I was able to ferret out the context ids from the URL in the browser when manually enrolling users. My first course is context 14 and my second is 26, for whatever reason.

I'm not getting anywhere with the enrol ext db plugin. It just doesn't work, or log useful errors, and it's holding up my project and frustrating me.

So it looks like I'll be manually updating the mdl_roles_assignment table some way, which does work.

mysql> insert into mdl_role_assignments (roleid,contextid,userid,hidden,timestart,timeend,
timemodified,modifierid,enrol,sortorder) VALUES 
(5,14,10,0,NOW(),0,NOW(), 2, 'manual',0);

seemingly enrolled a user in a class which the enrol cron seems to have never done. Pardon my SQL.

Hope that helps you some,


Six of these, one for each valid entries in the external enrol db table:

Notice: weird! no user record entry? in /home/.flash/atlbbs_sysop/ on line 342

Tags: bug

  • Media Consumption Update (MCU), Oct 2012

    Movies: Loopers was excellent, on par with Inception and On Time for good entertaining movies with actual plots and thought provocation. In a…

  • Your Media Consumption Update

    This would be easier in wikitext. Actually, nevermind, you're getting wikitext, deal with it ==Podcasts== Having raced to the dramatic if baffling…

  • What show is this, hmm? (a Media Update)

    In which even the self-censorship PSAs have a little fun: Have a look at Boss of Dominatrix Although apparently not available en Espanol yet, this…

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded