2012/10/29

Little bit of spying

Maybe under slight influence of the latest James Bond movie, but more probably because I was asked for it, I provide you with SQL query to spy on your teachers. This asnwers a question which courses have a teacher (or teachers) and when was the first time and last time they visited their courses.
It could be used for 1.8+ version of Moodle, with default setting of roles (as roleid = 3 means "teacher" role).
I don't know about speed of this thing, so be careful of running this on production servers under heavy load. Use it lightly, no whipping of lazy teachers please :)


Btw I used Adminer, very lightweight MySql tool, for running this. This can come really handy, if you don't have anything stronger at hand.

4 comments:

ark how to paint armor said...

Donny, I will admit, Jay is a bit... well, yea. I will also admit (though it's definitely difficult) I don't think Jay is as bad as you think. He isn't abusing Kelly (if he does, I have a few choice words for him), and Jay seems to care about Kelly, I'm not saying give up completely, I'm saying be subtle, slow but sure. I can almost (not quite) guarantee it would work!!

xcom enemy unknown console commands said...

I'm 13 and my 4 and 5 year old cousins love to play spy these ideas are so easy to set up and I can't wait to try them tomorrow. Thanks so much for the great ideas



xcom 2 cheats said...

this should be the couples in the little club....
Ally and Ropo
Kelly and Donny
Carly and Leo
baby Leah and baby duck
Baby angle and baby max
And Raven will be lonely the rest of his misreble and stupid life

olive oil ear infection said...

Thanks for being here early #NotificationSquad ...or should I say Suicide Squad! I'm hanging out with you here in the comment section. Please give this video a THUMBS UP and then let's chat!