When I go into the database with phpmyadmin and browse the message table, I see this:
Maybe that will help a bit.
I suspect that someone else can give you a more convenient way to do this, though. Anyone?
I would really like to see this looked at as part of the messaging redesign.
Browsing the database is painfull as all it displays is user id's. Thgis makes matching up users to posts extremely time consuming.
Browsing for keywords is also hard as much cyber bullying is more about context than keywords. Words I search for may not even show up.
My idea was to have a Messaging report added to the 'reports' function within moodle. This would allow for easier access to this needed information. Especialy when dealing with children, this tool needs to be monitored easily.
Being able to monitor them and prove to them that you are doing this is teh bigest way I have found to prevent them abusing the system, but it is tedious looking through all of the logs for messages and then chcecking each one. As you say it is the way that they say things not just key words that we are looking for.
The old messsage hack that I used in 1.5 was an excellent addition to provide sanctions for htose that abused the system hopefully roles will be expanded to cover messaging so that we can set up users that have restricted messaging or even no messaging.
I would like to see something like this too. Currently we have uploaded all our student accounts in bulk. This allows us to use a single email address. The email address is on one the free mail services. Within that free email account we filter the messages and forum posts for inappapropriate language and drop any into a unique folder. This catches some of the misuse issues, and established the understanding that we are monitoring how the message and forum systems are being used by students
It seems like it wouldn't be too difficult to create a check on any information posted to a forum or in a message that filters for certian vocabulary. If it finds any it could send a copy via email to a Moodle administrator. I wonder if this ability could be added to the current languange filter?
Yes, we would like to see have something like this too. currently students are using the messaging system which is very attractive facility by Moodle. but as a admin we can not track all the messages. Not even a user can see the messages history without remembering the name of the person or keyword. We should have someting like inbox which should display all the messages which has been delivered and recieved by a single user and then admin should see all of them as well. If this functionality will be added in the new version will be very valuable for us.
In general, getting access to phpmyadmin requires access to the server. This is independent of Moodle access. It also has to be installed (not necessarily a given). You might need to talk to your IT folks about this.
Can you log in to the server directly and see the file structure of moodle? Do you know the username and password for the moodle database? If not, you will probably need more information and more rights.
- Install a local moodle site (complete with Apache server, mysql database, etc.) on your personal computer.
- On the remote Moodle site of your institution, do a complete backup of your course(s) (including logs, etc.) and save the download file(s) to your computer.
- On your local Moodle site, restore your complete course(s).
- Since you have full admin rights to your own local Moodle installation, you can view the whole database, using phpMyAdmin.
Hi Mr. Joseph,
Using that PHPAdmin is that a kind of hacking in a moodle site. For instance you are the student you can able to manupulate the system were the student belong and can able to get access as admin? Is that the function of PHPADMIN?
I am one of three teachers in our district using Moodle, so we are piloting all of these issues now. I begged for an administrative password and they did give it to me. I think I must email them too often. Having that password allowed me to read the messages, if I wanted.
Here's one problem that I've had - I KNOW some kids are messaging...and so to test the feature, I went to check...and it didn't log the message. If a kid starts typing the message, but then X's out of Moodle and not the message pop up, would that message be logged then? I think some of the kids found a loop hole without realizing it. Is this true?
Is there any easy way to do this yet? (view report of all messages sent / received by students in a course / by everyone)
from_unixtime(timecreated) as time,
concat(sender.firstname,' ',sender.lastname) as sender,
concat(recipient.firstname,' ',recipient.lastname) as recipient,
mdl_message left join mdl_user as sender on mdl_message.useridfrom=sender.id
left join mdl_user as recipient on mdl_message.useridto=recipient.id
You will get output similar to this:
*************************** 20. row ***************************
time: 2008-09-15 11:35:12
sender: Mike Worth
recipient: David PHILLIPS
message: I've fixed you account<br /><br />any more problems let me know,<br />Mike<br />
(html tags will display as tags, but you should be able to understand the gist of all the messages)
The latest post (currently) is a short PHP script I wrote to do much the same as the SQL above, but formats the results in a table with links to users' profiles.