MoodleDocs - User contributions [en]

Talk:Antivirus plugins

2025-03-04T14:40:12Z

Jonwitts: broken link in article fixed

Antivirus plugins

2025-03-04T14:39:40Z

Jonwitts: fix broken link

{{Security}}
An administrator can enable and configure virus scanners for use on uploaded files via ''Site administration > Plugins > Antivirus plugins > Manage antivirus plugins''.

ClamAV antivirus is available as a standard plugin. It's likely that more antivirus plugins will be available in future from the [https://moodle.org/plugins/ Moodle plugins directory].

==ClamAV antivirus==

To make use of ClamAV antivirus, ClamAV® should be installed on your server. See http://www.clamav.net for more information.

== See also ==

* RHEL/CentOS and [https://en.wikipedia.org/wiki/Security-Enhanced_Linux SELinux]: https://moodle.org/mod/forum/discuss.php?d=316066
* RHEL/CentOS and [https://access.redhat.com/blogs/766093/posts/1976243 PrivateTmp]: https://moodle.org/mod/forum/discuss.php?d=364706
* Improve performance by using ClamDScan https://moodle.org/mod/forum/discuss.php?d=382731

[[Category:Site administration]]

[[eu:Antibirusa]]
[[de:Antivirus]]
[[es:Plugins antivirus]]

Pedagogy

2025-01-09T12:04:53Z

Jonwitts: /* Social Constructionism as a Referent */ update link

{{About Moodle}}
Let's sit back and really reflect on the pedagogy that is at the core of what we, as online educators, are trying to do.

==Definition of Pedagogy==
One definition of [http://en.wiktionary.org/wiki/Pedagogy pedagogy] in Wiktionary says
#The profession of teaching
#The activities of educating, teaching or instructing

Wikipedia has a much longer page on [http://en.wikipedia.org/wiki/Pedagogy Pedagogy]. At one point it said Pedagogy is the art or science of being a teacher, generally refers to strategies of instruction, or a style of instruction. The word comes from the Ancient Greek παιδαγωγέω (paidagōgeō; from παῖς (child) and ἄγω (lead)): literally, "to lead the child”.

==Moodle in three short paragraphs==

The heart of Moodle is courses that contain activities and resources. There are about 20 different types of activities available (forums, glossaries, wikis, assignments, quizzes, choices (polls), SCORM players, databases etc) and each can be customised quite a lot. The main power of this activity-based model comes in combining the activities into sequences and groups, which can help you guide participants through learning paths. Thus, each activity can build on the outcomes of previous ones.

There are a number of other tools that make it easier to build communities of learners, including blogs, messaging, participant lists etc, as well as useful tools like grading, reports, integration with other systems and so on.

For more about Moodle, see http://moodle.org, and particularly the main community “course” called [http://moodle.org/course/view.php?id=5 Moodle in English]. It's crowded and busy these days, but jump in and you'll soon find interesting stuff I'm sure. The developers and the users are deliberately forced to mix in the same forums. The other great place to start is our [https://docs.moodle.org/ online documentation] which is a community-developed wiki site.

==Social Constructionism as a Referent==

I have these five points on a slide which I use in every presentation I do. They are useful referents taken from research that apply to education in general, boiled down into a simple list that I carry around under the moniker of "social constructionism".

# '''All of us are potential teachers as well as learners - in a true collaborative environment we are both'''. It's so important to recognise and remember this. I think this perspective helps us retain some humility as teachers and fight the (very natural!) tendency to consolidate all your history and assume the revered position of “wise source of knowledge”. It helps us keep our eyes open for opportunities to allow the other participants in our learning situation to share their ideas with us and to remind us to listen carefully and ask good questions that elicit more from others. I find I need to constantly remind myself of this point, especially when the culture of a situation pushes me into a central role (like now!) 
# '''We learn particularly well from the act of creating or expressing something for others to see.''' For most of us this is basically “learning by doing”, and is fairly obvious, yet it's worth reminding ourselves of it. It's surprising how much online learning is still just presenting static information, giving students little opportunity to practice the activities they are learning about. I often see online teachers spending a great deal of time constructing perfect resources for their course, which no doubt is a terrific learning experience for them, but then they deny their students that same learning experience. Even textbooks often do a better job, with exercises after every chapter and so on. Most importantly, such learning is best when you are expressing and presenting posts, projects, assignments, constructions etc '''for others to see'''. In this situation your personal “stakes” are a lot higher, and a lot of self-checking and reflection takes place that increases learning. Seymour Papert (the inventor of logo) famously described the process of constructing something for others to see as a very powerful learning experience, and really this sort of thinking goes right back to Socrates and beyond. 
# '''We learn a lot by just observing the activity of our peers'''. Basically this is about “classroom culture”, or learning by osmosis. Humans are good at watching each other and learning what to do in a given situation through cues from others. For example, if you walk into a lecture theatre where everyone is sitting in seats, facing the front, listening quietly to the teacher at the front and taking notes, then that's most likely what you are going to do too, right? If you are in a less rigid class where people are asking questions all the time, then it's likely you'll feel freer to do so too. By doing so you'll be learning about both the subject itself and the meta-subject of how learning occurs from overhearing the discussions of your peers and the kinds of questions that get asked, leading to a richer multi-dimensional immersion in learning. 
# '''By understanding the contexts of others, we can teach in a more transformational way (constructivism)''' As you probably know from experience, advice from a mentor or friend can provide a better, more timely and customised learning experience than with someone who doesn't know you and is speaking to a hundred people. If we understand the background of the people we are speaking to then we can customise our language and our expression of concepts in ways that are best suited to the audience. You can choose metaphors that you know the audience will relate to. You can use jargon where it helps or avoid jargon when it gets in the way. Again this is a pretty basic idea - every guide to public speaking talks about knowing your audience - but in online learning we need to be particularly mindful of this because we often have not met these people in person and don't have access to many visual and auditory cues. 
# '''A learning environment needs to be flexible and adaptable, so that it can quickly respond to the needs of the participants within it'''. Combining all the above, if you as a learning facilitator want to take advantage of your growing knowledge about your participants, giving them tailored opportunities to share ideas, ask questions and express their knowledge, then you need an environment which is flexible, both in time and space. If you discover that you need to throw your schedule out the window because your participants know a lot less than you'd expected when you first designed the course, you should be able to readjust the schedule, and easily add new activities to help everyone (or just one group) catch up. Likewise, some great ideas for a simulation or something may have come up during discussions, so you should be able to add those later in the course. Timewise, your participants may be spread over different time-zones, or maybe they live in the same time-zone but have differing free time, so you should be able to offer asynchronous activities where people can work together but at different times. 

Jason Cole from Open University recently referred to these as “Martin's five laws” (ha!) but really they are referents: guiding concepts that I personally find useful to refer to whenever I need to make a decision in any given educational situation. In particular I find them useful for building '''communities of learners'''.

I guess you probably find a lot of this familiar, even if you use different terms. If not there is a lot of research about constructionism, constructivism and social Constructionism which you can find out more about in some of [https://dougiamas.com/archives/ my more formal papers].

==How Moodle tries to support a Social Constructionist view==

I'm going to go through the earlier list again, this time pointing out existing features in Moodle. Pedagogy and software design are closely intertwined in online learning - the "shape" of the software can help or hinder the teacher in what they are trying to do.

# '''All of us are potential teachers as well as learners - in a true collaborative environment we are both''' Many of the activities in Moodle are designed to allow students to control common content, such as forums, wikis, glossaries, databases, messaging and so on. This encourages students to add to the total course experience for others. We made a huge step with a Roles implementation which further breaks down the distinction of teachers and students, allowing Moodle system administrators and teachers to create new roles with any mix of capabilities they like. If you want students to be allowed to facilitate forums, create quiz questions or even control the course layout then you can. There is a very fine degree of control – for example you can allow students the ability to delete posts in just one single forum if you like. I hope that people will take these features and experiment with control in their courses, allowing students more flexibility to do things that were previously thought of as something teachers should do. 
# '''We learn particularly well from the act of creating or expressing something for others to see''' Moodle has a wide range of ways in which people can create representations of their knowledge and share them. 
#* The course structure itself is terrific way to construct a shared and active representation of the learning journey that everyone is going through.
#* Forums of course are the core of this, providing spaces for discussion and sharing of media and documents (using the media plugin filters, attachments or simply links).
#* Wikis are collaboratively-built pages useful for group work and other negotiations.
#* Glossaries are collaboratively-built lists of definitions that can then appear throughout the course.
#* Databases are an extension of this idea allowing participants to enter structured media of any type (for example a collection of digital photos or a library of references). 
# '''We learn a lot by just observing the activity of our peers''' The participants link in the navigation block is the main place where you can see everyone in your course. It shows a lot of information about your participants and how recently they've been there. An Online Users block is the best way to see everyone else who might be on right now. The Recent Activity block shows a great deal of information about what has happened recently, and via link you can see reports with more detail. Things that happened not only include changes to the course and forum posts, etc, but also things like assignment submissions and quiz attempts. Students can't see the results that other students got from these activities, but they do get some sense that everyone is submitting Assignment 1 now and this peer pressure hopefully helps those who need it. Finally, almost all the modules will "tag" an entry or change with the name of the user, so that you can see who did what and when. For example, wiki pages all have a history link with full details on every edit. 
# '''By understanding the contexts of others, we can teach in a more transformational way (constructivism)''' There are many different ways to find out about people. Access to these can be decided on a site basis (different sites have different privacy policies): 
#* The user profile contains several fields where people can provide information about their background, etc. In particular there is a user profile photograph, which appears throughout Moodle whenever that person writes something. The photo links back to the profile page.
#* A compendium of forum posts (and discussion starters) by that person in that course (or across the site).
#* Individual blogs allow people to express things in a public but reflective way, often providing access to thinking that might not normally expressed in, say, a forum. Others can give comments on the blog posts.
#* Overall activity reports show all the contributions from a user in a course, including assignment submissions, glossary entries, etc.
#* User log reports show detailed logs of every action taken by a person in Moodle, as well as graphs showing overall activity statistics.
#* The survey module provides a variety of proven questionnaire instruments for discovering interesting information about the state of mind of the group. 
# '''A learning environment needs to be flexible and adaptable, so that it can quickly respond to the needs of the participants within it''' 
#* The course page itself is the main tool for a teacher, allowing them to add/remove and structure activities as necessary. Changing the course is one button click away at any time, so the teacher can change it on a whim. We have AJAX features, so that activities, sections and blocks can all be simply dragged-and-dropped. Access can be restricted according to time, conditions or user profile fields.
#* Roles can be applied individually in every context across the site, and can be further tweaked with overrides. So if you want to create one single quiz where everyone has access to everybody's results, or allow parents of students to see parts of your course, then you can.
#* Navigation around the course and site is automatically generated.
#* The gradebook is automatically maintained, and reflects the activities in the course at any given time.
#* There are preferences for many aspects of appearance and behaviour, at site, course and activity levels, allowing educators to fine-tune the behaviour of Moodle in many ways.
#* External systems can be integrated easily, to maintain authentication, enrolments and other things, allowing Moodle to react smoothly as data in other systems is modified. 

==Finding a balance==

Before I talk about where we are going, let me talk a little about the balance that a Course Management System (aka VLE) like Moodle needs to achieve. One thing I found out quickly in a community like ours is that people have a wide range of expectations of online learning.

At the authoritarian extreme there are those who want students to be highly controlled: reading resources that are revealed at set times and later sitting quizzes to prove they read those resources. I call this the rat-in-the-maze approach, or dump-and-pump.

At the techno-hippy end of that spectrum there are those who want to devolve management completely, with every user running their own portfolio site, streaming blogs and files to each other using RSS and trackbacks. It's an interesting dream that really opens up thinking about education but I think the problems to be solved are many (such as security, accountability, the structure of institutions etc).

The vast majority of people that I meet fall somewhere between these two extremes. Many of them are new to online learning, and are looking for the next step beyond what they were being paid to do offline, while being accepting of gentle guidance to improving their online techniques. These people are on a steep learning curve already without facing the aggregation of 100 different blogs.

==Progression==

Moodle needs to be flexible to cater for a wide variety of needs while remaining simple enough for ordinary teachers to start making good use of the power of the internet for community building and collaborative learning. My hope is that Moodle can be seen as a toolbox where they can start simply and naturally, and then progress to more and more advanced community facilitation over time. Ultimately, we'd like to see teachers being involved with and supported by a community of their peers.

Let's look at a typical progression that a teacher might go through as they learn to use the Moodle tools:

# Putting up the handouts (Resources, SCORM)
# Providing a passive Forum (unfacilitated)
# Using Quizzes and Assignments (less management)
# Using the Wiki, Glossary and Database tools (interactive content)
# Facilitate discussions in Forums, asking questions, guiding
# Combining activities into sequences, where results feed later activities
# Introduce external activities and games (internet resources)
# Using the Survey module to study and reflect on course activity
# Using peer-review modules like Workshop, giving students more control over grading and even structuring the course in some ways
# Conducting active research on oneself, sharing ideas in a community of peers

===Repositories and Portfolios===

Special-purpose [[Repository|repositories]]
are a growing area, and it means institutions can keep their valuable data where they want to, even if they switch front-end systems like VLEs.
Most importantly, this will allow the development of e-Portfolios to explode, and these are something I think a lot of us really want to see as a very positive pedagogical enhancement.

===Community Hubs===

We want to improve the way teachers and users of Moodle communicate with each other, not only about e-learning and Moodle, but also in their subject areas. For example, imagine a Biology 101 teacher finding a "community search" block in their course, taking them straight to a place where their peers are all discussing best practice for teaching Biology 101, sharing and browsing repositories of course materials and learning designs.

The creation of networking between Moodles allows anyone to turn their Moodle site into a [[Community_hubs|Moodle Community Hub]]. Login between Moodles is transparent but secure and fully controlled by site administrators. The peer-to-peer nature of the design allows all sorts of interesting scenarios to develop.

===Interaction between tools===

By piping all the messaging from throughout the system via the Messaging module that we already have, users have a much finer control over exactly what sorts of messages they want to see.

===Metadata and outcome statements===

Moodle has a mechanism so that:

# admins can import a long list of outcome statements (as tags)
# teachers can relate a subset of these to their course
# teachers can connect each activity to an even smaller subset

[[Tracking_progress|Progress Tracking]] allows these things to be guided by individual learning plans for each student.

===Role-playing and scenario simulations===

A popular and effective technique in face-to-face teaching is that of role-playing in scenarios, and this can be difficult to do online. You could imagine an Environmental Science course running a role-playing simulation where some students play the government, some as Greenpeace, some as industry for a particular scenario.

The plans for this have been around for a long time, but I hope it can be developed soon. It would be a module where people can be assigned roles within a simulated situation and appear to others anonymously in those roles, interacting in forums, wikis, and all the other tools in Moodle according to the rules of the simulation.

==What else would you like to see?==

I hope this has stimulated some thoughts about the sorts of things you would like to see in your ideal online learning environment. If so, please join in with the discussions on http://moodle.org and let's brainstorm them a bit. I hope we can come up with some new ideas to put in the [http://tracker.moodle.org Moodle Tracker], or at least some support or modifications for old ones.

==Interesting links==

* [http://muppetmasteruk.blogspot.com/2010/06/effective-use-of-guerra-scale-in-moodle.html Effective use of the Guerra Scale in Moodle]
* [[Bloom's_taxonomy | Bloom's taxonomy]] Is, arguably, one of the most commonly used pedagogies in 6-10 education today.
* [http://www.uq.edu.au/teach/assessment/docs/biggs-SOLO.pdf Solo Pedagogy] An alternative to Bloom's is SOLO (Structure of the Observed Learning Outcome) Taxonomy.

[[Category:Pedagogy]]

[[es:Pedagogia]]
[[de:Pädagogik]]
[[fr:Pédagogie]]
[[it:Pedagogia]]

Talk:Pedagogy

2025-01-09T12:03:57Z

Jonwitts: /* Broken link... */

===References to up and coming Moodle 2===
I understand this page is based on a talk Martin gave a while back, but I wonder if we should perhaps rephrase the parts where he talks about the up and coming features of Moodle 2.0 such as community hubs/repositories/messaging etc? I appreciate as a transcript it is a useful archive but on the other hand for people who are not aware of that it might be a bit confusing?--[[User:Mary Cooch|Mary Cooch]] 04:33, 20 January 2013 (WST)

:Hi Mary, I think the page should be updated. The original version will always be available via the page history. --[[User:Helen Foster|Helen Foster]] 18:53, 21 January 2013 (WST)

===Broken link...===
Hello ladies, could you please update the link to Martin's formal papers? The current link is this: https://dougiamas.com/writing/ but it's broken :(
Perhaps it should be this: https://dougiamas.com/writing/tlf2000/ ? --[[User:anna krassa|Anna Krassa]] 7:50, 7 November 2016 (GTM+2)

:Thanks Anna, I have updated the link. --[[User:Helen Foster|Helen Foster]] ([[User talk:Helen Foster|talk]]) 14:21, 8 November 2016 (AWST)

:I have updated the link to this https://dougiamas.com/archives/ as it seems to link to a greater list of writings than the previous link. [[User:Jon Witts|Jon Witts]] ([[User talk:Jon Witts|talk]]) 12:03, 9 January 2025 (UTC)

Grade calculations

2021-12-03T11:58:27Z

Jonwitts: /* Setting a grade calculation */

{{Managing grades}}
A grade calculation is a formula used to determine grades, based on other grade items. Note that this is not the same as [[Calculated_question_type|Calculated question types]].

Grade calculations follow the pattern of formulas/functions in popular spreadsheet programs. They start with an equal (=) sign, and use common mathematical operators and functions to produce a single numerical output. This output is then used as the computed value for the grade item you are editing.

Conditional (IF) operators can be used in grade calculations of the grade book, and logical operators (AND,OR) can be also used (MDL-64414).
==Setting a grade calculation==
[[File:Edit Calculated Grade.png|alt=|thumb|Edit calculation setting]]
[[Image:newcalculationgrade.png|thumb|Example calculation]]

To set a grade calculation:

# Login as teacher or other user with permission to edit grades
# Click on Grades in the course administration block
# Click 'View > Grader Report'
# Click 'Turn Editing On'; a 'Controls' bar should appear above the grades
# Click the 'Calculator' icon above the grade item or category you wish to edit. Note: if you don't see this, then it must be enabled in ''Site administration>Grades>Report settings>Grader report>Show calculations''
# Start with an equal sign (=)
# Type an expression using numbers, arithmetic operators, mathematical functions and ID numbers; for example =average()
# Plug in your ID numbers (see below) enclosed in double square brackets, for example =<nowiki>[[item1]]</nowiki>+<nowiki>[[item2]]</nowiki>
# Separate each function argument with a comma, as in =average(<nowiki>[[item1]]</nowiki>, <nowiki>[[item2]]</nowiki>)+<nowiki>[[item3]]</nowiki>)
# Click the "Save Changes" button

==Assigning ID numbers==
You can include the values of other grade items by using their ID number as references in your formulas. The ID number must be surrounded by double square brackets, for example if you have a grade item with Quiz.3 as ID number, you can refer this item using <nowiki>[[Quiz.3]]</nowiki> in your calculation.

Below the calculation field there is a list of your course grade categories and grade items. Next to each item or category's total there is the ID number you can use in your calculation (already surrounded with the required double square brackets).

However, since ID numbers are optional, some items may not yet have one. Each item without ID number have a form field that you can use to enter its ID number directly. As soon as you have assigned the ID numbers you need, you must click the "Add ID numbers" button; the page will reload and show you the same list including the ID numbers you have just assigned. Now you can use them in your grade calculation.

'''Note''': Moodle does not allow calculations involving no ID numbers.
==Calculation functions==
Every grade calculation must start with an equal sign (=) followed by an expression using operators and functions supported by the system.
All common arithmetic operators are supported
* addition, using the plus (+) sign
* subtraction, using the minus (-) sign
* multiplication, using the asterisk (*) character
* division, using the slash (/) character
* exponentiation, using the caret (^) character
with their usual evaluation precedence rules: exponentiations are evaluated first, then multiplications and divisions are performed, finally additions and subtraction are carried out; so, the expression =1+2-3*4/5^6 gives almost 3 (2,999232). Different precedences can be forced using round parentheses, as in the expression =((((1+2)-3)*4)/5)^6 which yields 0.

Functions can also appear in expressions, using a separator between their arguments listed within round brackets.
<div class="alert alert-danger">Important:
<ul><li>For the English language pack this separator is a comma (,).</li>
<li>For other [[Language|languages]] the separator could be a different character, for example a semicolon (;).</li></ul></div>
* average<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the average of the values in a list of arguments
* ceil(number): Maps a real number to the smallest following integer
* floor(number): Maps a real number to the largest previous integer
* if<nowiki>([[item1]], [[item2]], [[item3]]):</nowiki> Evaluates the first argument (condition) and returns the second argument if the condition is not zero (true condition) and returns the third argument if the condition is zero (false condition).
* max<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the maximum value in a list of arguments
* min<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the minimum value in a list of arguments
* mod(dividend, divisor): Calculates the remainder of a division
* pi(): Returns the value of the number Pi (3.14159265...)
* power(base, exponent): Raises a number to the exponent power (this is the same as base^exponent)
* round(number, count): Rounds number to count decimal digits
* sum<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the sum of all arguments (this is the same as <nowiki>[[item1]]+[[item2]]+...</nowiki>
Many other mathematical functions are also supported:
* sin()
* sinh()
* arcsin()
* asin()
* arcsinh()
* asinh()
* cos()
* cosh()
* arccos()
* acos()
* arccosh()
* acosh()
* tan()
* tanh()
* arctan()
* atan()
* arctanh()
* atanh()
* sqrt()
* abs()
* ln()
* log()
* exp()
==Example calculations==
* <nowiki>=max([[Quiz.1]], [[Quiz.4]], [[Assignment.1]])</nowiki> - Returns the maximum value of the grades referred by Quiz.1, Quiz.4 and Assignment.1
* <nowiki>=average(max([[Quiz.1]], [[Quiz.4]], [[Assignment.1]]), min([[Quiz.1]], [[Quiz.4]], [[Assignment.1]]))</nowiki> - Returns the average of the maximum and the minimum values among Quiz.1, Quiz.4 and Assignment.1 (functions can be nested)
* <nowiki>=sum([[item1]]*0.3, [[item2]]*0.6, [[item3]]*2)</nowiki> - Returns a weighted grade sum where item1 is weighted 30%, item2 is weighted at 60% and item3 is weighted at 200%
* <nowiki>=if([[midtermexam]]>=5, [[midtermexam]]+[[lab]], 0)</nowiki> - Returns the sum of midtermexam and lab items if the midtermexam grade is 5 of more, and 0 otherwise. This is a very handy way of dealing with conditional evaluation in a course.
* <nowiki>=if(AND([[item1]]>=5, [[item2]]>=5), ([[item1]]+[[item2]])/2, 0)</nowiki> - Returns the average of item1 and item2 if both have 5 of more, and 0 otherwise. This is a very handy way of dealing with sine qua non activities.
==Calculations when user language is not English==
Calculations and formulas use decimal and list separators as defined in the [https://docs.moodle.org/dev/Translation_langconfig langconfig.php] file of each [[Language packs|language pack]].

The [[Decimal separator|decimal separator]] (the symbol used to mark the boundary between the integral and the fractional parts of a decimal number) is a point (.) in English. In other languages it may be a comma (,).

Analogously, the list separator (the symbol used to separate the items within a list, such as the arguments of a function) is a comma (,) in English. In other languages it may be a semicolon (;).
==See also==
*[http://www.youtube.com/watch?v=WKUGyzAXcyA Video on how to set up calculations in the gradebook (basic)]
*[http://www.youtube.com/watch?v=VBEj8mmu8lM Video on how to set up calculations in the gradebook (advanced)]
[[ca:grade/edit/tree/calculation]]
[[es:Cálculos de calificación]]
[[fr:Calcul de note]]
[[ru:Формулы и вычисления оценок]]
[[ja:評定計算]]
[[de:Bewertungen berechnen]]

File:Edit Calculated Grade.png

2021-12-03T11:58:16Z

Jonwitts:

Edit Calculated Grade

Usage

2021-08-27T12:03:12Z

Jonwitts: /* Maintenance */

{{About Moodle}}
==Who uses Moodle?==
Moodle is used by a variety of institutions and individuals, including:
* Universities
* High schools
* Primary schools
* Government departments
* Healthcare organisations
* Military organistions
* Airlines
* Oil companies
* Homeschoolers
* Independent educators
* special educators
==How many Moodle sites are there==
There are tens of thousands of registered Moodle sites in the sites list that we maintain; however it is impossible to know exactly how many Moodle sites exist because Moodle is open source, free to download and distribute, and doesn't force registration on its users. Very often we find people, will not inform us about their sites.

For up-to-date summary statistics about registered sites browse the [https://stats.moodle.org/ Moodle statistics] page. Statistics shown on this page are updated daily to provide an accurate summary of collected information.
You can also browse the [https://stats.moodle.org/sites/ Registered sites] page, which provides a useful list of registered sites grouped by country for all sites that have chosen to make their information public.
==How statistics are collected and maintained==
===Registration===
All information collected is from site administrators that have registered their sites. See [[Site registration]] for further details.

Registration data is updated automatically by a scheduled task. The administrator can also manually update their registration at any time.
===Moderation===
To ensure that the statistics that we collect are as accurate as possible there are certain conditions that a registered site has to meet in order to be included into both the statistics and sites pages.

When a site first registers we check the information about the site to ensure that the URL they have provided is valid and that the email address for the site administrator is a valid email address.
===Maintenance===
Like most of the web many sites come and go. Since we strive to maintain accurate statistics we need to check registered sites on a regular basis and clean out old data.
A sophisticated, automated site check process is used to undertake the task of checking every registered site on a weekly basis.

In checking registered sites, every site is visited by our site check program that then evaluates and scores each site individually based on a collection of a number of defined rules that we have set to identify each and every Moodle release. The score that a site receives determines whether the site is included in the sites list or not.

Any site that fails the evaluation is then removed from the list of registered sites and not included in any statistics.
===Ensuring your site passes the weekly evaluation===
To ensure that your site passes the weekly evaluation check that your site meets the following three criteria.
* Check the URL you registered is the URL of your Moodle registration. We check only the page returned from the URL you registered, we don't dig down into your site, or search any alternatives.
* Check the site is publicly available on the Internet. We can't check your site if it is only available locally, or has been wrapped in any means of authentication.
* Ensure you have content when you register your site. If you don't have any content when you register it is likely we will dismiss your site as a test site. Ensure that you have created at least one course, and three users within your installation before registering.
To find out when we last came through, you can check your web server logs. Look for page requests that have the following user-agent:
<nowiki>MoodleBot-LinkChecker (+https://docs.moodle.org/en/Usage)</nowiki>
==See also==
*[[:Category:Installations|Moodle installation listings]]
[[de:Nutzung]]
[[es:Uso]]
[[fr:Utilisation]]

Usage

2021-08-27T12:02:01Z

Jonwitts: /* Registration */

{{About Moodle}}
==Who uses Moodle?==
Moodle is used by a variety of institutions and individuals, including:
* Universities
* High schools
* Primary schools
* Government departments
* Healthcare organisations
* Military organistions
* Airlines
* Oil companies
* Homeschoolers
* Independent educators
* special educators
==How many Moodle sites are there==
There are tens of thousands of registered Moodle sites in the sites list that we maintain; however it is impossible to know exactly how many Moodle sites exist because Moodle is open source, free to download and distribute, and doesn't force registration on its users. Very often we find people, will not inform us about their sites.

For up-to-date summary statistics about registered sites browse the [https://stats.moodle.org/ Moodle statistics] page. Statistics shown on this page are updated daily to provide an accurate summary of collected information.
You can also browse the [https://stats.moodle.org/sites/ Registered sites] page, which provides a useful list of registered sites grouped by country for all sites that have chosen to make their information public.
==How statistics are collected and maintained==
===Registration===
All information collected is from site administrators that have registered their sites. See [[Site registration]] for further details.

Registration data is updated automatically by a scheduled task. The administrator can also manually update their registration at any time.
===Moderation===
To ensure that the statistics that we collect are as accurate as possible there are certain conditions that a registered site has to meet in order to be included into both the statistics and sites pages.

When a site first registers we check the information about the site to ensure that the URL they have provided is valid and that the email address for the site administrator is a valid email address.
===Maintenance===
Like most of the web many sites come and go. Since we strive to maintain accurate statistics we need to check registered sites on a regular basis and clean out old data.
A sophisticated, automated site check process is used to undertake the task of checking every registered site on a weekly basis.

In checking registered sites every sites is visited by our site check program that then evaluates and scores each site individually based on a collection of a number of defined rules that we have set to identify each and every Moodle release. The score that a site receives determines whether the site is included in the sites list or not.

Any site that fails the evaluation is then removed from the list of registered sites and not included in any statistics.
===Ensuring your site passes the weekly evaluation===
To ensure that your site passes the weekly evaluation check that your site meets the following three criteria.
* Check the URL you registered is the URL of your Moodle registration. We check only the page returned from the URL you registered, we don't dig down into your site, or search any alternatives.
* Check the site is publicly available on the Internet. We can't check your site if it is only available locally, or has been wrapped in any means of authentication.
* Ensure you have content when you register your site. If you don't have any content when you register it is likely we will dismiss your site as a test site. Ensure that you have created at least one course, and three users within your installation before registering.
To find out when we last came through, you can check your web server logs. Look for page requests that have the following user-agent:
<nowiki>MoodleBot-LinkChecker (+https://docs.moodle.org/en/Usage)</nowiki>
==See also==
*[[:Category:Installations|Moodle installation listings]]
[[de:Nutzung]]
[[es:Uso]]
[[fr:Utilisation]]

Assign roles

2015-10-01T10:34:20Z

Jonwitts: /* Enabling teachers to assign the role of teacher */

{{Roles}}
==Context and roles==

*In Moodle, apart from the site administrator, users do not normally have a global, site-wide role. In other words, even though you may be a tutor offline, when you are in Moodle you could have a tutor role in the course you teach in but a student role in another course where you are studying for a diploma. There are a few exceptions but this is generally the case.
*Because of the way Moodle works,assigning roles is done for a particular context. A site and course are examples of two different contexts. When you create a new role or tweak a pre-existing role via ''Administration > Site Administration > Users > Permissions > Define roles'', you are asked in which context(s) you want the role to be assigned:
[[File:rolecontexttypes.png]]

*Here are some examples of contexts; how to get to the assign roles screen, and when/why you would assign roles here:

===System context===
*''Administration > Site Administration > Users > Permissions > Assign system roles''
*Any roles assigned here apply to the whole Moodle site. It makes sense therefore that only roles that need this functionality can be assigned here. The [[Manager]] role and [[Course creator]] role are examples of two such roles. Assigning a teacher or student here would result in their being able to teach/study in every single course on the site, which is not usually desirable.
*If you really feel your Moodle needs to have teachers or students assigned in the system context, go to the teacher/student role in ''Administration > Site administration > Users > Permissions > Define roles'' and check the "system" box. Then search for and allow the capability [[Capabilities/moodle/course:view|moodle/course:view]]

=====Assigning system roles by CSV=====
{{New features}}

Where certain custom roles are applied in the system context, it is possible to upload users to that role in bulk by adding the field ''sysrole1'' (etc) to a CSV file.

[[File:GlobalRoles1.png|thumb|500px|center|sysrole column]]

When previewed, there is a column indicating their system role:

[[File:GlobalRoles2.png|thumb|center|500px|Preview screen]]

Once uploaded, the users are present on the 'Assign system roles' screen:

[[File:GlobalRoles3.png|thumb|center|500px|Assign system roles screen]]

See [[Upload users]] for information on adding users to roles via CSV.

===Front page context===
*''Administration > Site Administration > Front Page>Users>Permissions>Assigned roles
*Those with a role in the system context do not need to be assigned a role here as well.
*However you might want to allow a teacher to manage items on the front page; in this instance, you would assign them the role on the Front page.

===Course Category context===
*See [[Category enrolments]]
*Users may be enrolled in the category to save enrolling them in each individual course in that category.

===Course context===
[[File:enrolusers.png|thumb|Enrol users]]
* Go to ''Administration > Course administration > Enrolled users''
* Click the "Enrol users" button and click those users you wish to enrol

The dropdown menu at the top shows roles for which you are allowed to enrol; typically those users with lower roles than you. See [[Enrolled users]] for more details.

===Block context===
*(Within the block) ''Administration > Assign roles''
*You may wish to assign roles to a block if, for instance you want specific people to see the block but for it to be hidden from others

=== Activity Module context===
*(Within the activity settings) ''Administration > Locally assigned roles''
*An example of this is assigning a student the teacher role locally in an individual activity like a forum so they can moderate their classmates' posts while still retaining the student role in the rest of the course.

===User context===
*The most common use of this is for the Parent role.
*When the Parent role is created via''Administration > Site administration > Users > Permissions > Define roles'' the "user" context box is checked.
*To assign a parent the role in the context of their child (so they can see their child's grades etc) click the child's profile and then go to ''Administration>Roles>Assign roles relative to this user''
*See [[Parent role]] for more information.

The assign roles page lists the names of users assigned to each role (unless there are more than 10 users, in which case this is stated).

==Hierarchy==

By assigning a role to a user in a certain context, you grant them the permissions contained in that role for the current context and all lower contexts.

The list of contexts in hierarchical order is as follows:

*System (no parent)
*Front page (parent = system) -
*Course category (parent = parent category or system)
*Course (parent = category or system)
*Module (parent = course or system)
*Block (parent = course or system)
*User (parent = system)

Roles can be inherited. For example if a user is assigned a Teacher role in a specific course category then the user will have this role in ALL courses within the category. Tip: use the override feature in a specific context for exceptions.

Roles will only work if the role assignment is made in the correct context. Some examples: a Teacher role should be assigned to a user in the course or course category context, a Forum moderator for a particular forum should be assigned in that specific forum.

==Assigning someone the role of Site administrator==

*Site administrators are assigned via a special page: ''Administration > Site Administration > Users > Permissions > Site Administrators''. Select the name from the right and move it over to the left:
[[File:managesiteadmins.png]]
*The original (primary) administrator cannot be deleted.

==Checking a user's role assignments==

A user's role assignments can be checked by going to their profile page then in the administration block under the profile settings for the user, clicking 'This user's role assignments'.

==Hidden roles==

If you want to provide users with access to the course, but don't want them to be visible in the participants list, use the [[Other users]] link in the course administration menu (''Administration > Course Administration > Users > Other Users''). Assigning roles here provides course access, and editing rights according to the permissions set for the role assigned without actually enrolling the user in the course. This is similar to the functionality of the "hidden user" check box in previous versions of Moodle.

Note: By default, the only role which can be assigned to other users is the manager role. To enable other roles, such as teacher to be assigned, the capability [[Capabilities/moodle/course:view|moodle/course:view]] should be allowed for the role (see below).

==Enabling teachers to assign the role of teacher==

By default, teachers are only allowed to assign the roles of non-editing teacher, student and guest. To enable teachers to assign the role of teacher:

#Access ''Site Administration > Users > Permissions > Define roles''.
#Click the tab "Allow role assignments".
#Click the checkbox where the teacher row and column intersect.
#Click the "Save changes" button.

==Beware of assignments that don't make sense==

There are many role assignments that do not make sense as the underlying functionality does not exist. Just because you give someone the "right" to do something does not guarantee that the interface or facility actually exists within the context that you have assigned that right. For example, you can assign a user the right to create new categories in the category context. However there is no interface within Moodle to do that (category creation is only available at the system level).

==Multiple assignments==

A significant part of the roles infrastructure is the ability to assign a user into multiple roles (at the same time). The capabilities of each role are merged to produce the effective set of capabilities. For example, a user could be both a Teacher and Student in the same course. You should be careful to ensure that if you change a user's role that you remove them from any other roles as required as this will no longer be done automatically.

==See also==
*[[Creating custom roles]]
*[[Enrolment]]
*[[Managing roles]] - for administrators
*[[Useful things a teacher can do with roles]]

Using Moodle forum discussions:
*[http://moodle.org/mod/forum/discuss.php?d=59900 Discrepancies between Assign Roles lists and Participants list]
*[http://moodle.org/mod/forum/discuss.php?d=66782 What happens if a user has multiple roles in a course?]

[[Category:Roles]]

[[de:Rollen zuweisen]]
[[es:Asignar_roles]]
[[eu:Rolak_esleitu]]
[[fr:Attribuer des rôles]]
[[ja:ロールの割り当て]]

question/type/ddmarker

2015-06-28T15:18:36Z

Jonwitts: /* More documentation */

{{Questions}}Drag and drop marker questions allow for multiple markers to be placed onto an image and the positioning of each marker to be assessed.

[[File:markerexample.png]]

Drag and drop marker questions differ from Drag and drop onto image questions in that there are no predefined areas on the underlying image that are visible to the student.

This is a question type created and maintained by the Open University.

== More documentation ==

More [http://www.open.edu/openlearnworks/mod/oucontent/view.php?id=52747&section=2.5.1 documentation is available] on the Open University's [http://www.open.edu/openlearn/ OpenLearn site].

== See also ==

* [http://moodle.org/plugins/browse.php?list=set&id=10 Other Moodle plugins from the Open University]
* [http://moodle.org/plugins/browse.php?list=category&id=29 Other third-party question type plugins]
* [http://labspace.open.ac.uk/course/view.php?id=3484 eAssessment at the Open University with open source software]
* [http://www.somerandomthoughts.com/blog/2012/02/20/review-question-type-drag-and-drop-marker-for-moodle-2/ Review of this question type]
* [http://www.youtube.com/watch?v=Tvl4GuGvtxc Video tutorial: How to Create a Question Using the Drag and Drop with Markers Question Type]
[[Category:Contributed code]]

[[de:question/type/ddmarker]]

Dataform notification block

2015-03-16T21:18:55Z

Jonwitts: /* Git clone */

{{Dataform | innertrail = ► [[Dataform Plugins|Plugins and components ]] }}

{{Infobox plugin
|type = Blocks
|set = https://moodle.org/plugins/browse.php?list=set&id=4
|entry = http://moodle.org/plugins/view.php?plugin=block_dataformnotification
|tracker = https://tracker.moodle.org/browse/CONTRIB/component/13430
|discussion = http://moodle.org/mod/forum/view.php?id=3505
|maintainer = [[User:Itamar Tzadok|Itamar Tzadok]]
}}

The Dataform notification block provides context and settings for [Dataform_module|Dataform activity] notification rules. The Dataform notification rules allow sending custom messages to specified recipients on specified Dataform events.

==Features==
* General Dataform rule settings

* Dataform notification settings

==Installation==
===Git clone===
* Type the following command in the root of your Moodle install: git clone git://github.com/itamart/moodle-block_dataformnotification.git blocks/dataformnotification
* Add /blocks/dataformnotification to your .git/info/exclude.
* Visit http://yoursite.com/admin to finish the installation.

===Download===
* Download zip from: https://github.com/itamart/moodle-block_dataformaccessview/zipball/master or http://moodle.org/plugins/pluginversions.php?plugin=block_dataformnotification
* Unzip into the 'blocks' subfolder of your Moodle install.
* Rename the new folder to dataform_view.
* Visit http://yoursite.com/admin to finish the installation.

==Configuration==
===General settings===
[[File:df-rule-general-settings.png]]

===Notification settings===
[[File:df-rule-notification-settings.png]]

[[Category:Block]]

Dataform field access block

2015-03-16T21:15:10Z

Jonwitts: /* Git clone */

{{Dataform | innertrail = ► [[Dataform Plugins|Plugins and components ]] }}

{{Infobox plugin
|type = Blocks
|set = https://moodle.org/plugins/browse.php?list=set&id=4
|entry = http://moodle.org/plugins/view.php?plugin=block_dataformaccessfield
|tracker = https://tracker.moodle.org/browse/CONTRIB/component/13430
|discussion = http://moodle.org/mod/forum/view.php?id=8192
|maintainer = [[User:Itamar Tzadok|Itamar Tzadok]]
}}

The Dataform field access block provides context and settings for [[Dataform_module|Dataform activity]] view access rules. The field access rules allow for controlling access to specific fields.

==Features==
* General Dataform rule settings

==Installation==
===Git clone===
* Type the following command in the root of your Moodle install: git clone git://github.com/itamart/moodle-block_dataformaccessfield blocks/dataformaccessfield
* Add /blocks/dataformaccessfield to your .git/info/exclude.
* Visit http://yoursite.com/admin to finish the installation.

===Download===
* Download zip from: or
* Unzip into the 'blocks' subfolder of your Moodle install.
* Rename the new folder to
* Visit http://yoursite.com/admin to finish the installation.

==Configuration==
===General settings===

Dataform field access block

2015-03-16T12:00:57Z

Jonwitts: /* General settings */

Dataform field access block

2015-03-16T12:00:34Z

Jonwitts:

{{Dataform | innertrail = ► [[Dataform Plugins|Plugins and components ]] }}

{{Infobox plugin
|type = Blocks
|set = https://moodle.org/plugins/browse.php?list=set&id=4
|entry = http://moodle.org/plugins/view.php?plugin=block_dataformaccessfield
|tracker = https://tracker.moodle.org/browse/CONTRIB/component/13430
|discussion = http://moodle.org/mod/forum/view.php?id=8192
|maintainer = [[User:Itamar Tzadok|Itamar Tzadok]]
}}

The Dataform field access block provides context and settings for [[Dataform_module|Dataform activity]] view access rules. The field access rules allow for controlling access to specific fields.

==Features==
* General Dataform rule settings

==Installation==
===Git clone===
* Type the following command in the root of your Moodle install: git clone
* Add /blocks/ to your .git/info/exclude.
* Visit http://yoursite.com/admin to finish the installation.

===Download===
* Download zip from: or
* Unzip into the 'blocks' subfolder of your Moodle install.
* Rename the new folder to
* Visit http://yoursite.com/admin to finish the installation.

==Configuration==
===General settings===
[[Image:Dataform_Manage-Access.png]]

Dataform view access block

2015-03-16T11:58:14Z

Jonwitts:

{{Dataform | innertrail = ► [[Dataform Plugins|Plugins and components ]] }}

{{Infobox plugin
|type = Blocks
|set = https://moodle.org/plugins/browse.php?list=set&id=4
|entry = http://moodle.org/plugins/view.php?plugin=block_dataformaccessview
|tracker = https://tracker.moodle.org/browse/CONTRIB/component/13430
|discussion = http://moodle.org/mod/forum/view.php?id=3505
|maintainer = [[User:Itamar Tzadok|Itamar Tzadok]]
}}

The Dataform view access block provides context and settings for [[Dataform_module|Dataform activity]] view access rules. The view access rules allow for controlling access to specific views.

==Features==
* General Dataform rule settings

==Installation==
===Git clone===
* Type the following command in the root of your Moodle install: git clone git://github.com/itamart/moodle-block_dataformaccessview.git blocks/dataformaccessview
* Add /blocks/dataformaccessview to your .git/info/exclude.
* Visit http://yoursite.com/admin to finish the installation.

===Download===
* Download zip from: https://github.com/itamart/moodle-block_dataformaccessview/zipball/master or http://moodle.org/plugins/pluginversions.php?plugin=block_dataformaccessview
* Unzip into the 'blocks' subfolder of your Moodle install.
* Rename the new folder to dataform_view.
* Visit http://yoursite.com/admin to finish the installation.

==Configuration==
===General settings===
[[File:df-rule-general-settings.png]]

[[Category:Block]]

Dataform entry access block

2015-03-16T11:57:51Z

Jonwitts:

{{Dataform | innertrail = ► [[Dataform Plugins|Plugins and components ]] }}

{{Infobox plugin
|type = Blocks
|set = https://moodle.org/plugins/browse.php?list=set&id=4
|entry = http://moodle.org/plugins/view.php?plugin=block_dataformaccessentry
|tracker = https://tracker.moodle.org/browse/CONTRIB/component/13430
|discussion = http://moodle.org/mod/forum/view.php?id=3505
|maintainer = [[User:Itamar Tzadok|Itamar Tzadok]]
}}

The Dataform entry access block provides context and settings for [[Dataform_module|Dataform activity]] entry access rules. The entry access rules allow for controlling access to entries that have a specified content in specified views.

==Features==
* Entry filter settings for creating content specific entry access rules.

==Installation==
===Git clone===
* Type the following command in the root of your Moodle install: git clone git://github.com/itamart/moodle-block_dataformaccessentry.git blocks/dataformaccessentry
* Add /blocks/dataformaccessentry to your .git/info/exclude.
* Visit http://yoursite.com/admin to finish the installation.

===Download===
* Download zip from: https://github.com/itamart/moodle-block_dataformaccessentry/zipball/master or http://moodle.org/plugins/pluginversions.php?plugin=block_dataformaccessentry
* Unzip into the 'blocks' subfolder of your Moodle install.
* Rename the new folder to dataform_view.
* Visit http://yoursite.com/admin to finish the installation.

==Configuration==
===General settings===
[[File:df-rule-general-settings.png]]

===Entry filter settings===

[[File:df-rule-access-entry-filter-settings.png]]

[[Category:Block]]

Dataform field access block

2015-03-16T11:55:49Z

Jonwitts:

{{Dataform | innertrail = ► [[Dataform Plugins|Plugins and components ]] }}
[[Image:Dataform_Manage-Access.png]]
{{Infobox plugin
|type = Blocks
|set = https://moodle.org/plugins/browse.php?list=set&id=4
|entry = http://moodle.org/plugins/view.php?plugin=block_dataformaccessfield
|tracker = https://tracker.moodle.org/browse/CONTRIB/component/13430
|discussion = http://moodle.org/mod/forum/view.php?id=8192
|maintainer = [[User:Itamar Tzadok|Itamar Tzadok]]
}}

File:Dataform Manage-Access.png

2015-03-16T11:54:21Z

Jonwitts:

Dataform field access block

2015-03-16T11:53:50Z

Jonwitts:

{{Dataform | innertrail = ► [[Dataform Plugins|Plugins and components ]] }}
[[Image:Manage-Access Edit Manage-Access.png]]
{{Infobox plugin
|type = Blocks
|set = https://moodle.org/plugins/browse.php?list=set&id=4
|entry = http://moodle.org/plugins/view.php?plugin=block_dataformaccessfield
|tracker = https://tracker.moodle.org/browse/CONTRIB/component/13430
|discussion = http://moodle.org/mod/forum/view.php?id=8192
|maintainer = [[User:Itamar Tzadok|Itamar Tzadok]]
}}

mod/dataform/access/index

2015-03-16T11:48:55Z

Jonwitts: Redirected page to Dataform field access block

#REDIRECT [[Dataform_field_access_block]]

Upgrading

2015-02-26T15:29:54Z

Jonwitts: /* Finishing the upgrade */

{{Installing Moodle}}
''This page explains in detail how to upgrade Moodle. For a summary of the process, see [[Upgrade overview]].''

==Check the requirements==

Check that your server meets all requirements for 2.8 in ''Administration > Site administration > Server > [[Environment]]''.

Note: You can only upgrade to Moodle 2.8 from Moodle 2.2 or later. If upgrading from earlier versions, you must [https://docs.moodle.org/22/en/Upgrading_to_Moodle_2.2 upgrade to 2.2] as a first step.

==Before upgrading==

'''We advise that you test the upgrade first on a COPY of your production site, to make sure it works as you expect.'''

== Backup important data ==

There are three areas that should be backed up before any upgrade:
#Moodle software (For example, everything in server/htdocs/moodle)
#Moodle uploaded files (For example, server/moodledata)
#Moodle database (For example, your Postgres or MySQL database dump)

See [[Site backup]] for more specific information.

== Check for plugin updates ==

If you have [[Automatic updates deployment]] enabled, you will be able to update installed plugins automatically during the upgrade. Just make sure you check for available updates (via the button for it) at the Plugins check screen.

If you are updating plugins manually, it is a good moment now to check in the [http://moodle.org/plugins Moodle Plugins directory] whether there is a 2.8 version available for any plugins (including themes) that you have previously installed on your site. If so, download the plugin package. In the next step, you will copy it to the appropriate location in your Moodle code (see [[Installing plugins]]).

The upgrade of the plugin will then happen as part of the Moodle upgrade process.

If an out-of-date plugin causes your upgrade to fail, you can usually delete the plugin code rather than uninstalling it from within Moodle so that the data associated with it is not deleted.

==Put your site into maintenance mode==
Before you begin upgrading your site, you should put it into [[Maintenance_mode | maintenance mode]] to stop any non-admin users from logging in. Then you should wait for any currently running cron processes to complete before proceeding.

== Install the new Moodle software ==
You can fetch the current (2.8) version of the software through

wget http://sourceforge.net/projects/moodle/files/Moodle/stable28/moodle-latest-28.tgz

=== Standard install package ===

# Move your old Moodle software program files to another location. ''Do NOT copy new files over the old files.''
# Unzip or unpack the upgrade file so that all the new Moodle software program files are in the location the old files used to be in on the server. Moodle will adjust SQL and moodledata if it needs to in the upgrade.
# Copy your old [[Configuration file|config.php file]] back to the new Moodle directory.
# As mentioned above, if you had installed any plugins on your site you should add them to the new code tree now. It is important to check that you get the correct version for your new version of Moodle. Be particularly careful that you do not overwrite any code in the new version of Moodle.
# Dont forget to also copy over your moodledata folder / directory. If you don't you will get a "fatal error $cfg- dataroot is not configured properly".

====Linux====
mv moodle moodle.backup
tar xvzf moodle-2.8.tgz

Next, copy across your config.php, any custom plugins, and your .htaccess file if you created one ('''check that custom plugins are the correct version for your new Moodle first'''):

cp moodle.backup/config.php moodle
cp -pr moodle.backup/theme/mytheme moodle/theme/mytheme
cp -pr moodle.backup/mod/mymod moodle/mod/mymod

Don't forget to make moodle/config.php (and the rest of the source code) readable by your www server. Ideally the files should not be writeable by your server.

If you use cron, take care that cron.php is executeable and uses the correct php command:
chmod 740 admin/cli/cron.php (some configurations need chmod 750 or chmod 755)
copy the first line from cron.php (if it looks like '#!/usr/local/bin/php' or '#!/usr/local/bin/php5.3', no need to copy '<?php')

if necessary.

=== Using Git ===

You can use Git for updating or upgrading your Moodle. See [[Git for Administrators]] for details.

===Command line upgrade===

On Linux servers, Moodle 2.8 supports running the [[CLI|upgrade from the command line]], rather than through a web browser. This is likely to be more reliable, particularly for large sites.

== Finishing the upgrade ==

The last step is to trigger the upgrade processes within Moodle.

If you put your site into Maintenance mode earlier; take it out now!

To do this just go to ''Administration > Site administration > Notifications''.

Moodle will automatically detect the new version and perform all the SQL database or file system upgrades that are necessary. If there is anything it can't do itself (very rare) then you will see messages telling you what you need to do.

Assuming all goes well (no error messages) then you can start using your new version of Moodle and enjoy the new features!

Note: If you are running multiple servers then you should purge all caches manually (via ''Administration > Site administration > Development > Purge all caches'') after completing the upgrade on all servers.

===Fatal error: Maximum execution time of 30 seconds exceeded...===

If your server uses a main language other than English, you may encounter a 'Fatal error: Maximum execution time of 30 seconds exceeded' when you try to upgrade it. You can increase max_execution_time = 160 on php.ini to allow the scripts enough time to process the language update. Otherwise, you can switch to English as the default language before doing the upgrade and back to your original language after a succcessful upgrade. See the forum discussion at https://moodle.org/mod/forum/discuss.php?d=119598.

==After upgrading==

The config.php file from your installation should work fine but if you take a look at config-dist.php that came with Moodle 2.8 there are more/different options available (e.g. database drivers and settings). It's a good idea to map your old config.php settings to a new one based on the 2.8 config-dist.php.

===Cron===

Cron has received a major update (MDL-25499) and now has support for both scheduled and adhoc tasks.

The benefits of these changes are:
* The schedule for every task can be configured by the admin
* Tasks can run in parallel
* Cron processes use locking to prevent the same task running at the same time by different processes
* Clusters with multiple identical application nodes are supported, you can run cron on all of them

A result of this is that cron can be run much more often, which means (for example) forum posts can be sent out sooner. To take advantage of the new cron system it is now strongly recommended that administrators increase the frequency that cron is run to at least ''once per minute''.

You also may need to modify any automated scripts you have that are parsing the output from cron. It is no longer possible to simply monitor the output of cron for the string "Cron script completed correctly" (if that is what you were doing). An alternative is to monitor the output for the string "task failed:". If you detect that a task is failing, [[Cron#Debugging_Scheduled_Tasks|here]] are some tips for debugging the failure.

Before the upgrade to 2.8, there may have been a cron task that was failing, which was preventing the rest of cron from being executed. A failure in any single task will no longer prevent the rest of the Moodle cron tasks from executing, so you may uncover previously masked bugs. It is a good idea to closely monitor the output from cron after the upgrade to 2.8.

===Assignments===

The old assignment (2.2) module has been removed from core and has been replaced by a stub to support transparently remapping URLs and restoring course backups from the old module to the new one.

If you are still using the old assignment (2.2) module, after upgrading to Moodle 2.8 all assignment (2.2) activities will be hidden. You need to run the [[Assignment upgrade tool]] to un-hide the activities.

If you really, really need to keep using the old assignment (2.2) module, you should update the code to Moodle 2.8, and then replace the "mod/assignment" folder with the one from https://github.com/moodlehq/moodle-mod_assignment/releases before completing the upgrade.

==Possible issues that may affect you in Moodle 2.8==

===New aggregation method - 'Natural'===

The aggregation method 'Sum of grades' used in the [[Grades|gradebook]] has been reviewed, significantly improved and renamed to 'Natural'. It is recommended that 'Natural' is set as the default aggregation method, as for new Moodle 2.8 installs.

In addition, the aggregation setting 'Aggregate including subcategories' has been removed.

Any courses previously using either 'Sum of grades' and/or 'Aggregate including subcategories' may have some changes to grades. Thus it is recommended that grades in the gradebook are reviewed for such courses.

===Teachers able to enrol users via the cohort sync enrolment method===

Teachers will get access to [[Cohort sync]] enrolment method if it is enabled, remove capability to use this enrolment method from teachers if you want to preserve 2.7 behaviour. See MDL-36014

===Gradebook scrolling and theme issues===
Themes with non-fixed headers must have the .navbar class in their navbar in order for floating headers in the grader report to work - see MDL-46658 for more information.

===Removal of the 'Group members only' experimental setting===

The experimental setting 'Group members only' has been removed in Moodle 2.8. The group and grouping restrictions in [[Conditional activities settings|conditional activities]] now provide this functionality. Any 'Available for group members only' instances are automatically converted to group or grouping restrictions when a site is upgraded.

* 'Available for group members only' instances with no grouping selected are converted to a 'Must belong to any group' restriction.
* 'Available for group members only' instances with a grouping specified are converted to a 'Must belong to the specific grouping' restriction.

===Removal of DragMath===

DragMath is no longer distributed in Moodle. It is available elsewhere as a third-party plugin which may be downloaded and installed by an administrator.

=== MySQL dmlwriteexceptionerror exception throw on course restoration ===

Some users are getting the following MySQL error during the course restoration procedure:

Row size too large (>8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help.

This affect all moodle versions and is due MySQL default InnoDB file format (Antelope) cannot handle more than 10 text columns. We strongly recommend you change the InnoDB file format to Barracuda.

Since 2.6 onwards we have a specific tool to help users on this conversion. Please use the command below to do the database change.

php admin/cli/mysql_compressed_rows.php

More information about InnoDB file formats can be found here:
http://dev.mysql.com/doc/innodb/1.1/en/glossary.html#glos_antelope
http://dev.mysql.com/doc/innodb/1.1/en/glossary.html#glos_barracuda

=== Moodle 2.3, 2.4, 2.5, 2.6 and 2.7 improvements ===

Depending on which version you are upgrading from, please see the section 'Possible issues that may affect you' in the documentation

* [https://docs.moodle.org/23/en/Upgrading Upgrading to Moodle 2.3]
* [https://docs.moodle.org/24/en/Upgrading Upgrading to Moodle 2.4]
* [https://docs.moodle.org/25/en/Upgrading Upgrading to Moodle 2.5]
* [https://docs.moodle.org/26/en/Upgrading Upgrading to Moodle 2.6]
* [https://docs.moodle.org/27/en/Upgrading Upgrading to Moodle 2.7]

==See also==

* [[Installation]]
* Using Moodle [http://moodle.org/mod/forum/view.php?id=28 Installation problems forum]
* [[dev:Moodle 2.8 release notes|Moodle 2.8 release notes]]

[[es:Actualización de moodle]]
[[fr:Mise à jour]]
[[ja:Moodleをアップグレードする]]
[[de:Aktualisierung von Moodle]]

Upgrading

2015-02-26T14:52:34Z

Jonwitts: Correct order of checking plugin updates and entering maintenance mode

{{Installing Moodle}}
''This page explains in detail how to upgrade Moodle. For a summary of the process, see [[Upgrade overview]].''

==Check the requirements==

Check that your server meets all requirements for 2.8 in ''Administration > Site administration > Server > [[Environment]]''.

Note: You can only upgrade to Moodle 2.8 from Moodle 2.2 or later. If upgrading from earlier versions, you must [https://docs.moodle.org/22/en/Upgrading_to_Moodle_2.2 upgrade to 2.2] as a first step.

==Before upgrading==

'''We advise that you test the upgrade first on a COPY of your production site, to make sure it works as you expect.'''

== Backup important data ==

There are three areas that should be backed up before any upgrade:
#Moodle software (For example, everything in server/htdocs/moodle)
#Moodle uploaded files (For example, server/moodledata)
#Moodle database (For example, your Postgres or MySQL database dump)

See [[Site backup]] for more specific information.

== Check for plugin updates ==

If you have [[Automatic updates deployment]] enabled, you will be able to update installed plugins automatically during the upgrade. Just make sure you check for available updates (via the button for it) at the Plugins check screen.

If you are updating plugins manually, it is a good moment now to check in the [http://moodle.org/plugins Moodle Plugins directory] whether there is a 2.8 version available for any plugins (including themes) that you have previously installed on your site. If so, download the plugin package. In the next step, you will copy it to the appropriate location in your Moodle code (see [[Installing plugins]]).

The upgrade of the plugin will then happen as part of the Moodle upgrade process.

If an out-of-date plugin causes your upgrade to fail, you can usually delete the plugin code rather than uninstalling it from within Moodle so that the data associated with it is not deleted.

==Put your site into maintenance mode==
Before you begin upgrading your site, you should put it into [[Maintenance_mode | maintenance mode]] to stop any non-admin users from logging in. Then you should wait for any currently running cron processes to complete before proceeding.

== Install the new Moodle software ==
You can fetch the current (2.8) version of the software through

wget http://sourceforge.net/projects/moodle/files/Moodle/stable28/moodle-latest-28.tgz

=== Standard install package ===

# Move your old Moodle software program files to another location. ''Do NOT copy new files over the old files.''
# Unzip or unpack the upgrade file so that all the new Moodle software program files are in the location the old files used to be in on the server. Moodle will adjust SQL and moodledata if it needs to in the upgrade.
# Copy your old [[Configuration file|config.php file]] back to the new Moodle directory.
# As mentioned above, if you had installed any plugins on your site you should add them to the new code tree now. It is important to check that you get the correct version for your new version of Moodle. Be particularly careful that you do not overwrite any code in the new version of Moodle.
# Dont forget to also copy over your moodledata folder / directory. If you don't you will get a "fatal error $cfg- dataroot is not configured properly".

====Linux====
mv moodle moodle.backup
tar xvzf moodle-2.8.tgz

Next, copy across your config.php, any custom plugins, and your .htaccess file if you created one ('''check that custom plugins are the correct version for your new Moodle first'''):

cp moodle.backup/config.php moodle
cp -pr moodle.backup/theme/mytheme moodle/theme/mytheme
cp -pr moodle.backup/mod/mymod moodle/mod/mymod

Don't forget to make moodle/config.php (and the rest of the source code) readable by your www server. Ideally the files should not be writeable by your server.

If you use cron, take care that cron.php is executeable and uses the correct php command:
chmod 740 admin/cli/cron.php (some configurations need chmod 750 or chmod 755)
copy the first line from cron.php (if it looks like '#!/usr/local/bin/php' or '#!/usr/local/bin/php5.3', no need to copy '<?php')

if necessary.

=== Using Git ===

You can use Git for updating or upgrading your Moodle. See [[Git for Administrators]] for details.

===Command line upgrade===

On Linux servers, Moodle 2.8 supports running the [[CLI|upgrade from the command line]], rather than through a web browser. This is likely to be more reliable, particularly for large sites.

== Finishing the upgrade ==

The last step is to trigger the upgrade processes within Moodle.

To do this just go to ''Administration > Site administration > Notifications''.

Moodle will automatically detect the new version and perform all the SQL database or file system upgrades that are necessary. If there is anything it can't do itself (very rare) then you will see messages telling you what you need to do.

Assuming all goes well (no error messages) then you can start using your new version of Moodle and enjoy the new features!

Note: If you are running multiple servers then you should purge all caches manually (via ''Administration > Site administration > Development > Purge all caches'') after completing the upgrade on all servers.

===Fatal error: Maximum execution time of 30 seconds exceeded...===

If your server uses a main language other than English, you may encounter a 'Fatal error: Maximum execution time of 30 seconds exceeded' when you try to upgrade it. You can increase max_execution_time = 160 on php.ini to allow the scripts enough time to process the language update. Otherwise, you can switch to English as the default language before doing the upgrade and back to your original language after a succcessful upgrade. See the forum discussion at https://moodle.org/mod/forum/discuss.php?d=119598.

==After upgrading==

The config.php file from your installation should work fine but if you take a look at config-dist.php that came with Moodle 2.8 there are more/different options available (e.g. database drivers and settings). It's a good idea to map your old config.php settings to a new one based on the 2.8 config-dist.php.

===Cron===

Cron has received a major update (MDL-25499) and now has support for both scheduled and adhoc tasks.

The benefits of these changes are:
* The schedule for every task can be configured by the admin
* Tasks can run in parallel
* Cron processes use locking to prevent the same task running at the same time by different processes
* Clusters with multiple identical application nodes are supported, you can run cron on all of them

A result of this is that cron can be run much more often, which means (for example) forum posts can be sent out sooner. To take advantage of the new cron system it is now strongly recommended that administrators increase the frequency that cron is run to at least ''once per minute''.

You also may need to modify any automated scripts you have that are parsing the output from cron. It is no longer possible to simply monitor the output of cron for the string "Cron script completed correctly" (if that is what you were doing). An alternative is to monitor the output for the string "task failed:". If you detect that a task is failing, [[Cron#Debugging_Scheduled_Tasks|here]] are some tips for debugging the failure.

Before the upgrade to 2.8, there may have been a cron task that was failing, which was preventing the rest of cron from being executed. A failure in any single task will no longer prevent the rest of the Moodle cron tasks from executing, so you may uncover previously masked bugs. It is a good idea to closely monitor the output from cron after the upgrade to 2.8.

===Assignments===

The old assignment (2.2) module has been removed from core and has been replaced by a stub to support transparently remapping URLs and restoring course backups from the old module to the new one.

If you are still using the old assignment (2.2) module, after upgrading to Moodle 2.8 all assignment (2.2) activities will be hidden. You need to run the [[Assignment upgrade tool]] to un-hide the activities.

If you really, really need to keep using the old assignment (2.2) module, you should update the code to Moodle 2.8, and then replace the "mod/assignment" folder with the one from https://github.com/moodlehq/moodle-mod_assignment/releases before completing the upgrade.

==Possible issues that may affect you in Moodle 2.8==

===New aggregation method - 'Natural'===

The aggregation method 'Sum of grades' used in the [[Grades|gradebook]] has been reviewed, significantly improved and renamed to 'Natural'. It is recommended that 'Natural' is set as the default aggregation method, as for new Moodle 2.8 installs.

In addition, the aggregation setting 'Aggregate including subcategories' has been removed.

Any courses previously using either 'Sum of grades' and/or 'Aggregate including subcategories' may have some changes to grades. Thus it is recommended that grades in the gradebook are reviewed for such courses.

===Teachers able to enrol users via the cohort sync enrolment method===

Teachers will get access to [[Cohort sync]] enrolment method if it is enabled, remove capability to use this enrolment method from teachers if you want to preserve 2.7 behaviour. See MDL-36014

===Gradebook scrolling and theme issues===
Themes with non-fixed headers must have the .navbar class in their navbar in order for floating headers in the grader report to work - see MDL-46658 for more information.

===Removal of the 'Group members only' experimental setting===

The experimental setting 'Group members only' has been removed in Moodle 2.8. The group and grouping restrictions in [[Conditional activities settings|conditional activities]] now provide this functionality. Any 'Available for group members only' instances are automatically converted to group or grouping restrictions when a site is upgraded.

* 'Available for group members only' instances with no grouping selected are converted to a 'Must belong to any group' restriction.
* 'Available for group members only' instances with a grouping specified are converted to a 'Must belong to the specific grouping' restriction.

===Removal of DragMath===

DragMath is no longer distributed in Moodle. It is available elsewhere as a third-party plugin which may be downloaded and installed by an administrator.

=== MySQL dmlwriteexceptionerror exception throw on course restoration ===

Some users are getting the following MySQL error during the course restoration procedure:

Row size too large (>8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help.

This affect all moodle versions and is due MySQL default InnoDB file format (Antelope) cannot handle more than 10 text columns. We strongly recommend you change the InnoDB file format to Barracuda.

Since 2.6 onwards we have a specific tool to help users on this conversion. Please use the command below to do the database change.

php admin/cli/mysql_compressed_rows.php

More information about InnoDB file formats can be found here:
http://dev.mysql.com/doc/innodb/1.1/en/glossary.html#glos_antelope
http://dev.mysql.com/doc/innodb/1.1/en/glossary.html#glos_barracuda

=== Moodle 2.3, 2.4, 2.5, 2.6 and 2.7 improvements ===

Depending on which version you are upgrading from, please see the section 'Possible issues that may affect you' in the documentation

* [https://docs.moodle.org/23/en/Upgrading Upgrading to Moodle 2.3]
* [https://docs.moodle.org/24/en/Upgrading Upgrading to Moodle 2.4]
* [https://docs.moodle.org/25/en/Upgrading Upgrading to Moodle 2.5]
* [https://docs.moodle.org/26/en/Upgrading Upgrading to Moodle 2.6]
* [https://docs.moodle.org/27/en/Upgrading Upgrading to Moodle 2.7]

==See also==

* [[Installation]]
* Using Moodle [http://moodle.org/mod/forum/view.php?id=28 Installation problems forum]
* [[dev:Moodle 2.8 release notes|Moodle 2.8 release notes]]

[[es:Actualización de moodle]]
[[fr:Mise à jour]]
[[ja:Moodleをアップグレードする]]
[[de:Aktualisierung von Moodle]]

admin/setting/filtersettingtex

2014-12-07T19:47:04Z

Jonwitts: Redirected page to TeX notation filter

#REDIRECT [[TeX_notation_filter]]

Talk:Course meta link enrolment

2014-11-26T19:54:53Z

Jonwitts: Created page with "Can anyone offer some explanation as to what the "External unenrol action" setting in the Course meta link plugin does? ~~~~"

Can anyone offer some explanation as to what the "External unenrol action" setting in the Course meta link plugin does? [[User:Jon Witts|Jon Witts]] ([[User talk:Jon Witts|talk]]) 03:54, 27 November 2014 (AWST)

Media FAQ

2014-09-24T05:22:36Z

Jonwitts: /* How can I convert my video file to an .FLV or other format? */

{{Working with media}}
==Should I put my video into a label or a page?==
While the embedding process is the same, adding a video to a label will mean it displays as soon as the user clicks on that course page. This can be beneficial if the video is, for example, an introduction to the course or an integral part of the whole course. However, if there are several videos in labels, they can slow the loading of the course down, especially if the videos are coming from an external site. Adding a video to a page in Moodle means that the user has to click a text link to reach the video, but it doesn't clutter up the main course page and it is a better choice if the course contains a large number of videos.

==My embedded video is too big/small. How can I change its display size?==
*With the editing turned on, click the edit (hand/pen) icon to get into the HMTL editor where you embedded your video.
*Click the HTML code icon:
[[File:Htmlcodeicon.png]]
*You will see the code of your video there.

*'''For videos you uploaded yourself...''' Find the file extension (such as flv or wmv) and just '''after''' the file extension and '''before''' the ", type in ''?d=400x300''(for example) where 400 and 300 are the width and height in pixels of the display size you wish your video to be:
[[File:Resizevideo.png]]
*'''For external videos you embedded with embed code'''...Change the height and width numbers to the size in pixels you wish your video to be:
[[File:Youtuberesize.png]]

*Click ''Update'' and then, on the next screen, click ''Save changes''. Your video will now display in a different size.

==Why is the size and player for MP4 video clips hard coded?==
Not sure. If anyone from out there knows, so far they have not let on any reasons. See MDL-43385

==Why won't my swf video play?==
The .swf format carries with it some security issues and so the filter that allows it to display is disabled by default. For you to be able to add .swf videos, your administrator needs to enable the filter in [[Multimedia_plugins|Multimedia plugins]], then to go to ''Site Administration>Security>Site policies'' and check the "enable trusted content" box. They then need to go to ''Site Administration>Users>Permissions>Define roles'' and allow Trust Submitted content ''moodle/site:trustcontent'' for your role. However; swf will still not display in all areas of Moodle, for example forum posts. See this discussion [http://moodle.org/mod/forum/discuss.php?d=183681#p800390| here]

==How can I convert my video file to an .FLV or other format?==
*There are many sites online that allow you to upload a file which will then be converted and sent to you via a link or email. Zamzar [http://www.zamzar.com]or Youconvertit [http://www.youconvertit.com] are just two examples.
*However, if it is a large video file or you want to do the conversion off line, then the free Any Video Converter [http://www.any-video-converter.com/products/for_video_free/] (a downloadable program) will convert most video formats to most others.
*More and more full-featured MTS Video Converter [http://www.mtsconverterfree.com/]software free download a trial, to solve your problem more format conversions.
*The free and open source video player, VLC has the ability to convert to and from many video formats. For more details and downloads [http://www.videolan.org/vlc/ visit their site].
*If you are using Linux as your operating system either ffmpeg or avconv can both convert to FLV.

== I have a .wma/wav file. How can I play it in Moodle's player?==
*There are various free programs available that will convert one type of sound file to another. If you convert your file to an mp3 then you will be able to use Moodle's built-in mp3 player.
*Jodix Free WMA to MP3 converter [http://www.wma-mp3.org/] is just one example

== I have an MP4 file. How can I play it in Moodle's player? (ie Flowplayer)==
It seems that the media filter is hard coded to NOT use Flowplayer for MP4.
*See the discussion here: https://moodle.org/mod/forum/discuss.php?d=208849#p914927. Renaming an MP4 to an FLV seems to create a file that will play in Flowplayer.
*See the discussion here: https://docs.moodle.org/dev/Media_embedding
*See the discussion about [https://moodle.org/mod/forum/discuss.php?d=232296#p1048676 how to play mp4 videos in Moodle]
*You can try the [[Videofile]] plugin

You can vote for a change here: MDL-43385

==Can you stop Flowplayer from preloading a video?==
*See the discussion here: http://moodle.org/mod/forum/discuss.php?d=184081

[[Category:FAQ]]

[[de:Multimedia FAQ]]
[[es:Medios FAQ]]

Media FAQ

2014-09-24T05:21:55Z

Jonwitts: /* Should I put my video into a label or a page? */

{{Working with media}}
==Should I put my video into a label or a page?==
While the embedding process is the same, adding a video to a label will mean it displays as soon as the user clicks on that course page. This can be beneficial if the video is, for example, an introduction to the course or an integral part of the whole course. However, if there are several videos in labels, they can slow the loading of the course down, especially if the videos are coming from an external site. Adding a video to a page in Moodle means that the user has to click a text link to reach the video, but it doesn't clutter up the main course page and it is a better choice if the course contains a large number of videos.

==My embedded video is too big/small. How can I change its display size?==
*With the editing turned on, click the edit (hand/pen) icon to get into the HMTL editor where you embedded your video.
*Click the HTML code icon:
[[File:Htmlcodeicon.png]]
*You will see the code of your video there.

*'''For videos you uploaded yourself...''' Find the file extension (such as flv or wmv) and just '''after''' the file extension and '''before''' the ", type in ''?d=400x300''(for example) where 400 and 300 are the width and height in pixels of the display size you wish your video to be:
[[File:Resizevideo.png]]
*'''For external videos you embedded with embed code'''...Change the height and width numbers to the size in pixels you wish your video to be:
[[File:Youtuberesize.png]]

*Click ''Update'' and then, on the next screen, click ''Save changes''. Your video will now display in a different size.

==Why is the size and player for MP4 video clips hard coded?==
Not sure. If anyone from out there knows, so far they have not let on any reasons. See MDL-43385

==Why won't my swf video play?==
The .swf format carries with it some security issues and so the filter that allows it to display is disabled by default. For you to be able to add .swf videos, your administrator needs to enable the filter in [[Multimedia_plugins|Multimedia plugins]], then to go to ''Site Administration>Security>Site policies'' and check the "enable trusted content" box. They then need to go to ''Site Administration>Users>Permissions>Define roles'' and allow Trust Submitted content ''moodle/site:trustcontent'' for your role. However; swf will still not display in all areas of Moodle, for example forum posts. See this discussion [http://moodle.org/mod/forum/discuss.php?d=183681#p800390| here]

==How can I convert my video file to an .FLV or other format?==
*There are many sites online that allow you to upload a file which will then be converted and sent to you via a link or email. Zamzar [http://www.zamzar.com]or Youconvertit [http://www.youconvertit.com] are just two examples.
*However, if it is a large video file or you want to do the conversion off line, then the free Any Video Converter [http://www.any-video-converter.com/products/for_video_free/] (a downloadable program) will convert most video formats to most others.
*More and more full-featured MTS Video Converter [http://www.mtsconverterfree.com/]software free download a trial, to solve your problem more format conversions.

== I have a .wma/wav file. How can I play it in Moodle's player?==
*There are various free programs available that will convert one type of sound file to another. If you convert your file to an mp3 then you will be able to use Moodle's built-in mp3 player.
*Jodix Free WMA to MP3 converter [http://www.wma-mp3.org/] is just one example

== I have an MP4 file. How can I play it in Moodle's player? (ie Flowplayer)==
It seems that the media filter is hard coded to NOT use Flowplayer for MP4.
*See the discussion here: https://moodle.org/mod/forum/discuss.php?d=208849#p914927. Renaming an MP4 to an FLV seems to create a file that will play in Flowplayer.
*See the discussion here: https://docs.moodle.org/dev/Media_embedding
*See the discussion about [https://moodle.org/mod/forum/discuss.php?d=232296#p1048676 how to play mp4 videos in Moodle]
*You can try the [[Videofile]] plugin

You can vote for a change here: MDL-43385

==Can you stop Flowplayer from preloading a video?==
*See the discussion here: http://moodle.org/mod/forum/discuss.php?d=184081

[[Category:FAQ]]

[[de:Multimedia FAQ]]
[[es:Medios FAQ]]

Talk:Masquerading

2014-09-10T05:46:04Z

Jonwitts:

oh my lawd oh my god what oh my dear friends what does the following mean: "Then tweak internal DNS server" could there be a little more elobration on that point - thank you my dear friends. i am in great pain, in agony, i'm on fire like the fat guy who ate at lazarus' table and is now burning in the lake of sulphur i suppose i shall continue to burn until i fix this masquarading issue and I want to spare you all my agony with clearer explanations: which i will do once i work out how to do it all.

Then tweak internal DNS server

You can either tweak all PCs in your intranet by editing hosts files which can override the data returned from DNS server.

Or you can tweak your DNS server (or forwarder) to return the internal server IP instead of the public one.

-------
Let's say your external dns name for your Moodle server was moodle.my-school.edu and your internal dns domain was my-school.local. Internaly your moodle server would respond to server-name.my-school.local with it's internal IP address. What we want is for it to respond with it's internal IP address from inside your network to moodle.my-school.edu.

So the "tweak" would be to create the my-school.edu zone on your internal dns servers and then create an a-record in that zone called moodle which points to the internal ip address of your moodle server. This would get the result we wanted.

The potential gotcha here is if you also have a website configured at www.my-school.edu which is not hosted on your internal LAN... You would then need to add the external IP address for teh server hosting your website as an a record with name www (and possible as the root of the zone too if your website is configured to respond to calls without www).

I hope that clarifies things a little! [[User:Jon Witts|Jon Witts]] ([[User talk:Jon Witts|talk]])

External database enrolment

2013-12-13T11:48:46Z

Jonwitts: /* Unenrolment */

{{Enrolment}}
Location: External database edit settings link in ''Administration > Site administration > Plugins > Enrolments > Manage enrol plugins''

You may use a external database (of nearly any kind) to control your enrolments. It is assumed your external database contains a field containing a course ID, a field containing a user ID, and optionally a field containing a role. These are compared against fields that you choose in the local course, user tables, and role tables.

The following are the supported data sources, but note that you will need to have to compiled PHP with the appropriate options or through [[ODBC]].

*access
*ado
*mssql
*borland_ibase
*csv
*db2
*fbsql
*firebird
*ibase
*informix72
*informix
*mysql
*mysqlt
*oci805
*oci8
*oci8po
*odbc
*odbc_mssql
*odbc_oracle
*oracle
*postgres64
*postgres7
*postgres
*proxy
*sqlanywhere
*sybase
*vfp

== Enrolment & Unenrolment ==

External database enrolment happens at the moment when a user logs into Moodle. The plugin will attempt to automatically enrol the student in all their courses according to the data in the external database and, optionally, create empty courses where they do not already exist. To check if it is working, you can log in as a student and then check that their list of courses is as you would expect.

The process also unenrols users from courses if they are no longer in the database. User records are marked according to their original enrolment method. Therefore the external database plugin can only unenrol users who were enroled by the plugin in the first place.

== Hidden Courses ==

Courses that are set to "Course is not available to students" can be ignored for enrolment purposes by setting the "enrol_db_ignorehiddencourse" to '''yes'''.

== Enrolment & Roles ==

The "enrol_database | defaultrole" setting in the plugin settings page specifies the role that the user will take when they are added to the course. The default setting will set them to the course default setting (initially "student"). However, you can specify a field in the external table (specified in the "enrol_database | remoterolefield" setting) that contains the short name or id for the user's role. This could, for example, be used to enrol both students and teachers into courses using a suitably configured database.

== Unenrolment ==

The External unenrol action ("enrol_database | unenrolaction") setting in the plugin settings page defines what action should be taken when a user enrolment disappears from external enrolment source. Each setting does the following:
#'''"Unenrol user from course"''' When the user disappears from the external source, the enrolment is completely removed and all the roles removed. This means some user data and settings are purged from course during course unenrolment (that usually include grades, activity attempts, etc.)
#'''"Keep user enrolled"''' When the user disappears from the external source, the enrolment is kept as is, and the user is still able to enter the course and perform activities, access resources, etc. It's a "do nothing" option.
#'''"Disable course enrolment"''' When the user disappears from the external source, user enrolment is suspended (the user can't access the course, but user data and settings are kept), and roles are kept as is. You might use this because in some cases the user needs a role with some capability to be visible in UI - such has in gradebook, assignments, etc.
#'''"Disable course enrolment and remove roles"''' When the user disappears from the external source, the enrolment is suspended and roles assigned by enrol instance are removed. Please note that user may "disappear" from gradebook and other areas.

== Creating Courses ==

Optionally courses that do not exist in the Moodle site can be created. Switch the "enrol_db_autocreate" option to "yes" in the plugin settings.

You can additionally specify the Category into which the new course will be placed, in the '''New course category id field'''. The data in this field must be the id of a currently existing category; it will not create a new category. The id number is number assigned by Moodle in the database when the category is created (e.g. mdl_course_categories.id).

* Do not confuse this ''category id'' with the new custom ''category id number'' field that you can manually assign to a category. (See Trackers http://tracker.moodle.org/browse/MDL-28518 and http://tracker.moodle.org/browse/MDL-31845).
* Leaving the category id data empty means that a course will be assigned to the default category.
* If you assign data to categories that do not exist already in Moodle, the courses will not be created.

'''Default new course category''' is the category to which courses will be assigned and created in, unless you set up and so indicate in the data field of the "New course category id field."

You may also specify a '''New course template''': a "template" course from which the new course will be copied. The data for this field should be the ''shortname'' of the template course.

== Synchronization Script ==

A script is provided that can synchronize all your user enrollments at once - both adding and removing user enrolments (and creating courses if specified). The script is called sync.php and is found in the enrol/database/cli folder.

This script is meant to be called from a system cronjob to sync moodle enrolments with enrolments in the external database. You need to make sure all the users present in the external enrolments are already created in moodle. If you are using external authentication plugins (db, ldap, etc.) you can use the scripts provided by those plugins to synchronize your users before running this script.

Example cron entry for Moodle 2.5
# 5 minutes past 4am
5 4 * * * /usr/bin/php -c /path/to/php.ini /path/to/moodle/enrol/database/cli/sync.php

Notes:
* If you have a large number of enrolments, you may want to raise the memory limits by passing -d memory_limit=256M
* For debugging & better logging, you are encouraged to use in the command line: -d log_errors=1 -d error_reporting=E_ALL -d display_errors=0 -d html_errors=0
* This only works for users that already exist in your Moodle site (see comment above)

== Setting up enrolment sync (How to) ==

You will need to perform (as a minimum) the following steps to enable external database enrolment - only a single table is required in the database which contains a record for every user/course combination. If the table is large it is a good idea to make sure appropriate indexes have been created:

* Use an existing database or create a new one. Use an existing table or create a new one with the following minimum fields.
*# A unique course identifier to match one of the following fields.
*#* the "idnumber" field in Moodle's course table (varchar 100), which is manually specified as the "Course ID number" when editing a course's settings
*#* the "shortname" field in Moodle's course table (varchar 255), which is manually specified as the "Course short name" when editing a course's settings
*#* the "id" field in Moodle's course table (int 10), which is based on course creation order
*# A unique user identifier to match one of the following fields.
*#* the "idnumber" field in Moodle's user table (varchar 255), which is manually specified as the "ID number" when editing a user's profile
*#* the "username" field in Moodle's user table (varchar 100), which is manually specified as the "Username" when editing a user's profile
*#* the "email" field in Moodle's user table (varchar 100), which is manually specified as the "Email address" when editing a user's profile
*#* the "id" field in Moodle's user table (int 10), which is based on user creation order
*# (optional) A unique role identifier to match one of the following fields.
*#* the "shortname" field in Moodle's role table (varchar 100), for example editingteacher, coursecreator, student, ...
*#* the "name" field in Moodle's role table (varchar 255), for example Teacher, Course creator, Student, ...
*#* the "id" field in Moodle's role table (int 10), which is based on initial installation and new role creation order
* Populate the database table. Each user/course combination to have a record in the table.
* In Moodle, go to Site administration => Plugins => Enrolments => Manage enrol plugins, find External Database in the list, enable it (click the closed-eye icon) and click Settings.
* In the top panel, select the database type (make sure you have the necessary configuration in PHP for that type) and then supply the information to connect to the database.
* The middle panel creates the mapping between Moodle and the external database. The first three settings are for the local (Moodle) field names and the last three for the remote (external database) settings. They are in the same order.
** enrol_localcoursefield / enrol_remotecoursefield - in Moodle the name of the field in the course settings the uniquely identifies the course (e.g., idnumber). In the external database the name of the matching field.
** enrol_localuserfield / enrol_remoteuserfield - in Moodle the name of the field in the user profile that uniquely identified the user (e.g., idnumber). In the external database the name of the matching field.
** enrol_db_localrolefield / enrol_db_remoterolefield - (optional) in Moodle the name of the field in the role edit page the uniquely identifies the role (e.g., shortname). In the external database the name of the matching field.
* The Roles panel specifies the role that the user will get in the course if their role is not specified in the external database.
* The final panel enables auto creation of courses.
* Save changes, and then tick the box to enable external database enrolment.

== Database enrolment does not appear in the course enrolment drop down menu. Why? ==

The course enrolment drop down menu only lists [[Enrolment_plugins#Interactive_enrolment|'''interactive''' enrolment plugins]]. External database enrolment is not such a plugin, so it doesn't appear in the list. Similarly, the "Course Enrollable" setting (in the Course Settings) page also only applies to interactive enrolment plugins and has no effect on external database enrollment.

As of this writing, the only interactive enrolment plugins are ''manual'' (also know as ''internal''), ''paypal'' and ''authorize.net''.

== Field Mapping Example: ==
Choose your fields from the Moodle database:

*enrol_localcoursefield: A course identifier from mdl_course, e.g. "idnumber"
*enrol_localuserfield: A user identifier from mdl_user, e.g. "idnumber"
*enrol_localrolefield: (optional) A role identifier from mdl_role, e.g. "shortname"

Create a view in your external database which matches the chosen field values from Moodle:

*enrol_remotecoursefield: A matching course identifier from your external database table, e.g. "course_number"
*enrol_remoteuserfield: A matching user identifier from your external database table, e.g. "userid"
*enrol_remoterolefield: (optional) A matching role identifier from your external database table, e.g. "role_name"

== Potential Gotchas ==

* It almost goes without saying that the integrity of the external database is important. If data is missing from the database then there is a potential for users being unenrolled from some or all of their courses. The unenrollment process will remove them from any group assignments and also poll each module type to give the module the option of removing that user's data if appropriate (for example, however, forum posts are never deleted). It is therefore prudent that you take the utmost care to ensure that the data in the external bass is correct at all times.
* '''Minor Security Issue''' Consider that if the ID number field you use to identify your students is editable by the students (in their profile), then there is a potential for them changing this to the id of another valid student and gaining access to resources that they should not. (However, they will still appear as themselves, they cannot impersonate the other user or otherwise gain access to their resources.) To prevent this and similar issues, you can lock the ID number as well as other fields so the user can not change them. Do this in the '''Data mapping''' section of ''Settings>Site administration>Plugins>Authentication>External database''.

==Errors and Diagnostics==

The plugin produces a number of diagnostic messages and/or errors which are recorded to the PHP error log (as defined in the php.ini file). In addition messages about courses that are in the database for the user but that do not exist in the Moodle site will only be produced if debugging is set to ALL or DEVELOPER.

You can get detailed progress information by executing the sync script with -v parameter:

<code>
php /path/to/moodle/enrol/database/cli/sync.php -v
</code>

==See also==
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=49475 MySQL enrolment plugin doesn't seem to work] forum discussion
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=74133 Someone explain external database enrolment, please??] forum discussion
*Example Setup [https://docs.moodle.org/en/Talk:External_database_enrolment#Example_External_Enrollment] Example Database Enrollment Setup

[[es:Matriculación Base de Datos Externa]]
[[fr:Base de données externe]]
[[de:Einschreibung über externe Datenbank]]
[[ja:外部データベース登録]]

External database enrolment

2013-12-13T11:17:05Z

Jonwitts: /* Enrolment & Roles */

{{Enrolment}}
Location: External database edit settings link in ''Administration > Site administration > Plugins > Enrolments > Manage enrol plugins''

You may use a external database (of nearly any kind) to control your enrolments. It is assumed your external database contains a field containing a course ID, a field containing a user ID, and optionally a field containing a role. These are compared against fields that you choose in the local course, user tables, and role tables.

The following are the supported data sources, but note that you will need to have to compiled PHP with the appropriate options or through [[ODBC]].

*access
*ado
*mssql
*borland_ibase
*csv
*db2
*fbsql
*firebird
*ibase
*informix72
*informix
*mysql
*mysqlt
*oci805
*oci8
*oci8po
*odbc
*odbc_mssql
*odbc_oracle
*oracle
*postgres64
*postgres7
*postgres
*proxy
*sqlanywhere
*sybase
*vfp

== Enrolment & Unenrolment ==

External database enrolment happens at the moment when a user logs into Moodle. The plugin will attempt to automatically enrol the student in all their courses according to the data in the external database and, optionally, create empty courses where they do not already exist. To check if it is working, you can log in as a student and then check that their list of courses is as you would expect.

The process also unenrols users from courses if they are no longer in the database. User records are marked according to their original enrolment method. Therefore the external database plugin can only unenrol users who were enroled by the plugin in the first place.

== Hidden Courses ==

Courses that are set to "Course is not available to students" can be ignored for enrolment purposes by setting the "enrol_db_ignorehiddencourse" to '''yes'''.

== Enrolment & Roles ==

The "enrol_database | defaultrole" setting in the plugin settings page specifies the role that the user will take when they are added to the course. The default setting will set them to the course default setting (initially "student"). However, you can specify a field in the external table (specified in the "enrol_database | remoterolefield" setting) that contains the short name or id for the user's role. This could, for example, be used to enrol both students and teachers into courses using a suitably configured database.

== Unenrolment ==

The External unenrol action ("enrol_database | unenrolaction") setting in the plugin settings page defines what action should be taken when a user enrolment disappears from external enrolment source. Each setting does the following:
*'''"Unenrol user from course"''' When the user disappears from the external source, the enrolment is completely removed and all the roles removed. This means some user data and settings are purged from course during course unenrolment (that usually include grades, activity attempts, etc.)
*'''"Keep user enrolled"''' When the user disappears from the external source, the enrolment is kept as is, and the user is still able to enter the course and perform activities, access resources, etc. It's a "do nothing" option.
*'''"Disable course enrolment"''' When the user disappears from the external source, user enrolment is suspended (the user can't access the course, but user data and settings are kept), and roles are kept as is. You might use this because in some cases the user needs a role with some capability to be visible in UI - such has in gradebook, assignments, etc.
*'''"Disable course enrolment and remove roles"''' When the user disappears from the external source, the enrolment is suspended and roles assigned by enrol instance are removed. Please note that user may "disappear" from gradebook and other areas.

== Creating Courses ==

Optionally courses that do not exist in the Moodle site can be created. Switch the "enrol_db_autocreate" option to "yes" in the plugin settings.

You can additionally specify the Category into which the new course will be placed, in the '''New course category id field'''. The data in this field must be the id of a currently existing category; it will not create a new category. The id number is number assigned by Moodle in the database when the category is created (e.g. mdl_course_categories.id).

* Do not confuse this ''category id'' with the new custom ''category id number'' field that you can manually assign to a category. (See Trackers http://tracker.moodle.org/browse/MDL-28518 and http://tracker.moodle.org/browse/MDL-31845).
* Leaving the category id data empty means that a course will be assigned to the default category.
* If you assign data to categories that do not exist already in Moodle, the courses will not be created.

'''Default new course category''' is the category to which courses will be assigned and created in, unless you set up and so indicate in the data field of the "New course category id field."

You may also specify a '''New course template''': a "template" course from which the new course will be copied. The data for this field should be the ''shortname'' of the template course.

== Synchronization Script ==

A script is provided that can synchronize all your user enrollments at once - both adding and removing user enrolments (and creating courses if specified). The script is called sync.php and is found in the enrol/database/cli folder.

This script is meant to be called from a system cronjob to sync moodle enrolments with enrolments in the external database. You need to make sure all the users present in the external enrolments are already created in moodle. If you are using external authentication plugins (db, ldap, etc.) you can use the scripts provided by those plugins to synchronize your users before running this script.

Example cron entry for Moodle 2.5
# 5 minutes past 4am
5 4 * * * /usr/bin/php -c /path/to/php.ini /path/to/moodle/enrol/database/cli/sync.php

Notes:
* If you have a large number of enrolments, you may want to raise the memory limits by passing -d memory_limit=256M
* For debugging & better logging, you are encouraged to use in the command line: -d log_errors=1 -d error_reporting=E_ALL -d display_errors=0 -d html_errors=0
* This only works for users that already exist in your Moodle site (see comment above)

== Setting up enrolment sync (How to) ==

You will need to perform (as a minimum) the following steps to enable external database enrolment - only a single table is required in the database which contains a record for every user/course combination. If the table is large it is a good idea to make sure appropriate indexes have been created:

* Use an existing database or create a new one. Use an existing table or create a new one with the following minimum fields.
*# A unique course identifier to match one of the following fields.
*#* the "idnumber" field in Moodle's course table (varchar 100), which is manually specified as the "Course ID number" when editing a course's settings
*#* the "shortname" field in Moodle's course table (varchar 255), which is manually specified as the "Course short name" when editing a course's settings
*#* the "id" field in Moodle's course table (int 10), which is based on course creation order
*# A unique user identifier to match one of the following fields.
*#* the "idnumber" field in Moodle's user table (varchar 255), which is manually specified as the "ID number" when editing a user's profile
*#* the "username" field in Moodle's user table (varchar 100), which is manually specified as the "Username" when editing a user's profile
*#* the "email" field in Moodle's user table (varchar 100), which is manually specified as the "Email address" when editing a user's profile
*#* the "id" field in Moodle's user table (int 10), which is based on user creation order
*# (optional) A unique role identifier to match one of the following fields.
*#* the "shortname" field in Moodle's role table (varchar 100), for example editingteacher, coursecreator, student, ...
*#* the "name" field in Moodle's role table (varchar 255), for example Teacher, Course creator, Student, ...
*#* the "id" field in Moodle's role table (int 10), which is based on initial installation and new role creation order
* Populate the database table. Each user/course combination to have a record in the table.
* In Moodle, go to Site administration => Plugins => Enrolments => Manage enrol plugins, find External Database in the list, enable it (click the closed-eye icon) and click Settings.
* In the top panel, select the database type (make sure you have the necessary configuration in PHP for that type) and then supply the information to connect to the database.
* The middle panel creates the mapping between Moodle and the external database. The first three settings are for the local (Moodle) field names and the last three for the remote (external database) settings. They are in the same order.
** enrol_localcoursefield / enrol_remotecoursefield - in Moodle the name of the field in the course settings the uniquely identifies the course (e.g., idnumber). In the external database the name of the matching field.
** enrol_localuserfield / enrol_remoteuserfield - in Moodle the name of the field in the user profile that uniquely identified the user (e.g., idnumber). In the external database the name of the matching field.
** enrol_db_localrolefield / enrol_db_remoterolefield - (optional) in Moodle the name of the field in the role edit page the uniquely identifies the role (e.g., shortname). In the external database the name of the matching field.
* The Roles panel specifies the role that the user will get in the course if their role is not specified in the external database.
* The final panel enables auto creation of courses.
* Save changes, and then tick the box to enable external database enrolment.

== Database enrolment does not appear in the course enrolment drop down menu. Why? ==

The course enrolment drop down menu only lists [[Enrolment_plugins#Interactive_enrolment|'''interactive''' enrolment plugins]]. External database enrolment is not such a plugin, so it doesn't appear in the list. Similarly, the "Course Enrollable" setting (in the Course Settings) page also only applies to interactive enrolment plugins and has no effect on external database enrollment.

As of this writing, the only interactive enrolment plugins are ''manual'' (also know as ''internal''), ''paypal'' and ''authorize.net''.

== Field Mapping Example: ==
Choose your fields from the Moodle database:

*enrol_localcoursefield: A course identifier from mdl_course, e.g. "idnumber"
*enrol_localuserfield: A user identifier from mdl_user, e.g. "idnumber"
*enrol_localrolefield: (optional) A role identifier from mdl_role, e.g. "shortname"

Create a view in your external database which matches the chosen field values from Moodle:

*enrol_remotecoursefield: A matching course identifier from your external database table, e.g. "course_number"
*enrol_remoteuserfield: A matching user identifier from your external database table, e.g. "userid"
*enrol_remoterolefield: (optional) A matching role identifier from your external database table, e.g. "role_name"

== Potential Gotchas ==

* It almost goes without saying that the integrity of the external database is important. If data is missing from the database then there is a potential for users being unenrolled from some or all of their courses. The unenrollment process will remove them from any group assignments and also poll each module type to give the module the option of removing that user's data if appropriate (for example, however, forum posts are never deleted). It is therefore prudent that you take the utmost care to ensure that the data in the external bass is correct at all times.
* '''Minor Security Issue''' Consider that if the ID number field you use to identify your students is editable by the students (in their profile), then there is a potential for them changing this to the id of another valid student and gaining access to resources that they should not. (However, they will still appear as themselves, they cannot impersonate the other user or otherwise gain access to their resources.) To prevent this and similar issues, you can lock the ID number as well as other fields so the user can not change them. Do this in the '''Data mapping''' section of ''Settings>Site administration>Plugins>Authentication>External database''.

==Errors and Diagnostics==

The plugin produces a number of diagnostic messages and/or errors which are recorded to the PHP error log (as defined in the php.ini file). In addition messages about courses that are in the database for the user but that do not exist in the Moodle site will only be produced if debugging is set to ALL or DEVELOPER.

You can get detailed progress information by executing the sync script with -v parameter:

<code>
php /path/to/moodle/enrol/database/cli/sync.php -v
</code>

==See also==
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=49475 MySQL enrolment plugin doesn't seem to work] forum discussion
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=74133 Someone explain external database enrolment, please??] forum discussion
*Example Setup [https://docs.moodle.org/en/Talk:External_database_enrolment#Example_External_Enrollment] Example Database Enrollment Setup

[[es:Matriculación Base de Datos Externa]]
[[fr:Base de données externe]]
[[de:Einschreibung über externe Datenbank]]
[[ja:外部データベース登録]]

Moodle video tutorials

2013-02-15T13:16:14Z

Jonwitts: /* Video tutorials in English */

There are a large number of free online video tutorials about Moodle and this page collates them for Moodle 2. If you have made some Moodle 2 video tutorials or have a link to some free Moodle 2 video tutorials, please add them here.

==Video tutorials in English==
*[http://www.youtube.com/moodlehq Videos made by Moodle HQ]
*[http://youtube.com/usingmoodle video tutorials explaining the new features of Moodle 2]
*[http://www.lynda.com/Moodle-2-0-tutorials/Moodle-2-Essential-Training-for-Teachers/85410-2.html some free video tutorials from lynda.com]
*[http://www.youtube.com/HRDNZMoodlePartner Videos made by HRDNZ]
*[http://www.webanywhere.co.uk/video Videos made by Webanywhere]

==Video tutorials in other languages==
*[http://youtube.com/Moodle2Ourlearning video tutorials in French/en Français]

==See also==

*[[Moodle manuals]]
*[[Moodle presentations]]

Moodle video tutorials

2013-02-15T13:14:01Z

Jonwitts: Removed link as videos have been removed "due to intellectual property rights."

There are a large number of free online video tutorials about Moodle and this page collates them for Moodle 2. If you have made some Moodle 2 video tutorials or have a link to some free Moodle 2 video tutorials, please add them here.

==Video tutorials in English==
*[http://www.youtube.com/moodlehq Videos made by Moodle HQ]
*[http://youtube.com/usingmoodle video tutorials explaining the new features of Moodle 2]
*[http://www.lynda.com/Moodle-2-0-tutorials/Moodle-2-Essential-Training-for-Teachers/85410-2.html some free video tutorials from lynda.com]
*[http://www.youtube.com/HRDNZMoodlePartner Videos made by HRDNZ]

==Video tutorials in other languages==
*[http://youtube.com/Moodle2Ourlearning video tutorials in French/en Français]

==See also==

*[[Moodle manuals]]
*[[Moodle presentations]]

ad-hoc contributed reports

2012-05-14T13:59:01Z

Jonwitts: /* Number of Quizes per Course */

==User and Role Report==
===Detailed ACTIONs for each ROLE (TEACHER,NONE-EDITING TEACHER and STUDENT)===
<code sql>
SELECT r.name,l.action, count( l.userid ) as counter
FROM `prefix_log` as l
JOIN `prefix_role_assignments` AS ra on l.userid = ra.userid
JOIN prefix_role AS r ON ra.roleid = r.id
WHERE ra.roleid IN (3,4,5)
GROUP BY roleid,l.action
ORDER BY counter desc
</code>

===LIST of all site USERS by COURSE enrollment (Moodle 1.9.x)===

Reports a site global list of all users enroled in each course
<code sql>
SELECT
user.firstname AS Firstname,
user.lastname AS Lastname,
user.email AS Email,
user.city AS City,
course.fullname AS Course
,(SELECT name FROM prefix_role WHERE id=asg.roleid)
FROM
prefix_user AS user,
prefix_course AS course,
prefix_role_assignments AS asg
INNER JOIN prefix_context AS context ON asg.contextid=context.id
WHERE
context.contextlevel = 50
AND
user.id=asg.userid
AND
context.instanceid=course.id
</code>

===LIST of all site USERS by COURSE enrollment (Moodle 2.x)===

<code sql>
SELECT
user2.firstname AS Firstname,
user2.lastname AS Lastname,
user2.email AS Email,
user2.city AS City,
course.fullname AS Course
,(SELECT shortname FROM prefix_role WHERE id=en.roleid) as Role
,(SELECT name FROM prefix_role WHERE id=en.roleid) as RoleName

FROM prefix_course as course
JOIN prefix_enrol AS en ON en.courseid = course.id
JOIN prefix_user_enrolments AS ue ON ue.enrolid = en.id
JOIN prefix_user AS user2 ON ue.userid = user2.id
</code>

===Permissions Overides on Categories===
(By: [http://moodle.org/mod/forum/discuss.php?d=153059#p712834 Séverin Terrier] )
<code sql>
SELECT rc.id, ct.instanceid, ccat.name, rc.roleid, rc.capability, rc.permission,
DATE_FORMAT( FROM_UNIXTIME( rc.timemodified ) , '%Y-%m-%d' ) AS timemodified, rc.modifierid, ct.instanceid, ct.path, ct.depth
FROM `prefix_role_capabilities` AS rc
INNER JOIN `prefix_context` AS ct ON rc.contextid = ct.id
INNER JOIN `prefix_course_categories` AS ccat ON ccat.id = ct.instanceid
AND `contextlevel` =40
</code>

===Lists "Totally Opened Courses" (visible, opened to guests, with no password)===
(By: [http://moodle.org/mod/forum/discuss.php?d=153059#p712837 Séverin Terrier] )
<code sql>
SELECT id , category , fullname , shortname , enrollable
FROM `prefix_course`
WHERE `guest` =1
AND `password` = ""
AND `visible` =1
</code>

===Lists "loggedin users" from the last 120 days===
<code sql>
SELECT id,username,FROM_UNIXTIME(`lastlogin`) as days
FROM `prefix_user`
WHERE DATEDIFF( NOW(),FROM_UNIXTIME(`lastlogin`) ) < 120
</code>

''and user count for that same population:''
<code sql>
SELECT COUNT(id) as Users FROM `prefix_user`
WHERE DATEDIFF( NOW(),FROM_UNIXTIME(`lastlogin`) ) < 120
</code>

===Students in all courses of some institute===
What is the status (deleted or not) of all Students (roleid = 5) in all courses of some Institute
<code sql>
SELECT c.id, c.fullname, u.firstname, u.lastname, u.deleted
FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid =5
AND ctx.instanceid = c.id
AND u.institution = 'please enter school name here'
</code>

===Full User info (for deleted users)===
Including extra custom profile fields (from mdl_user_info_data)
<code sql>
SELECT *
FROM prefix_user as u
JOIN prefix_user_info_data as uid ON uid.userid = u.id
JOIN prefix_user_info_field as uif ON (uid.fieldid = uif.id AND uif.shortname = 'class')
WHERE `deleted` = "1" and `institution`="your school name" and `department` = "your department" and `data` = "class level and number"
</code>

===User's courses===
change "u.id = 2" with a new user id
<code sql>
SELECT u.firstname, u.lastname, c.id, c.fullname
FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE u.id = 2
</code>

===Special Roles===
<code sql>
SELECT ra.roleid,r.name
,concat('<a target="_new" href="%%WWWROOT%%/course/user.php?id=1&user=',ra.userid,'">',u.firstname ,' ',u.lastname,'</a>') AS Username
,concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course
FROM prefix_role_assignments AS ra
JOIN prefix_role AS r ON r.id = ra.roleid
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_context AS ctx ON (ctx.id = ra.contextid AND ctx.contextlevel = 50)
JOIN prefix_course AS c ON ctx.instanceid = c.id
WHERE ra.roleid > 6
</code>

===Courses without Teachers===
Actually, shows the number of Teachers in a course.
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course
,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 3 AND ctx.instanceid = c.id) AS Teachers
FROM prefix_course AS c
ORDER BY Teachers ASC
</code>

===List of users who have been enrolled for more than 4 weeks===
For Moodle 2.2 , by Isuru Madushanka Weerarathna
<code sql>
SELECT uenr.userid As User, IF(enr.courseid=enr.courseid ,'Y','N') As Enrolled,
IF(DATEDIFF(NOW(), FROM_UNIXTIME(uenr.timecreated))>=28,'Y','N') As EnrolledMoreThan4Weeks
FROM mdl_enrol As enr, mdl_user_enrolments AS uenr
WHERE enr.id = uenr.enrolid AND enr.status = uenr.statu
</code>

==Log Acivity Reports==
===Detailed "VIEW" ACTION for each ROLE (TEACHER,NONE-EDITING TEACHER and STUDENT)===
<code sql>
SELECT l.action, count( l.userid ) as counter , r.name
FROM `prefix_log` as l
JOIN `prefix_role_assignments` AS ra on l.userid = ra.userid
JOIN `prefix_role` AS r ON ra.roleid = r.id
WHERE (ra.roleid IN (3,4,5)) AND (l.action LIKE '%view%' )
GROUP BY roleid,l.action
order by r.name,counter desc
</code>

===Total Activity of Roles:"Teacher" and "None-Editing Teacher" by Dates and by Hours===
The output columns of this report table can be used as base for a Pivot-Table
which will show the amount of '''activity''' per '''hour''' per '''days''' in 3D graph view.

<code sql>
SELECT DATE_FORMAT( FROM_UNIXTIME( l.time ) , '%Y/%m/%d' ) AS grptimed ,
DATE_FORMAT( FROM_UNIXTIME( l.time ) , '%k' ) AS grptimeh , count( l.userid ) AS counter
FROM `prefix_log` AS l
JOIN prefix_user AS u ON u.id = l.userid
JOIN prefix_role_assignments AS ra ON l.userid = ra.userid
JOIN prefix_role AS r ON r.id = ra.roleid
WHERE ra.roleid IN (3,4)
GROUP BY grptimed,grptimeh
ORDER BY grptimed,grptimeh
</code>

===How many LOGINs per user and user's Activity===
+ link username to a user activity graph report
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/user.php?id=1&user=',u.id,'&mode=alllogs">',u.firstname ,' ',u.lastname,'</a>') as Username
,count(*) as logins
,(SELECT count(*) FROM prefix_log WHERE userid = l.userid GROUP BY userid) as Activity
FROM prefix_log as l JOIN prefix_user as u ON l.userid = u.id
WHERE `action` LIKE '%login%' group by userid
ORDER BY Activity DESC
</code>

==Course Reports==
===Most Active courses===
<code sql>
SELECT COUNT(l.id) hits, l.course courseId, c.fullname coursename
FROM prefix_log l INNER JOIN prefix_course c ON l.course = c.id
GROUP BY courseId
ORDER BY hits DESC
</code>

===Active courses, advanced===
Including: Teacher's name, link to the course, All types of log activities, special YEAR generated field, Activities and Resource count, enrolled Student count
<code sql>
SELECT COUNT(l.id) hits, concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course

,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher

,CASE
WHEN c.fullname LIKE '%תשע' THEN 'תשע'
WHEN c.fullname LIKE '%תשעא' THEN 'תשעא'
WHEN c.fullname LIKE '%תשעב' THEN 'תשעב'
END AS Year

,(SELECT count(*) FROM prefix_course_modules cm WHERE cm.course = l.course) Modules

,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students

FROM prefix_log l
INNER JOIN prefix_course c ON l.course = c.id
GROUP BY c.id
HAVING Modules > 2
ORDER BY Year DESC, hits DESC
</code>

===RESOURCE count for each COURSE===
<code sql>
SELECT COUNT(l.id) count, l.course, c.fullname coursename
FROM prefix_resource l INNER JOIN prefix_course c on l.course = c.id
GROUP BY course
ORDER BY count DESC
</code>

===Courses that are defined as using GROUPs===
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/group/index.php?id=',c.id,'">',c.fullname,'</a>') AS Course
,(SELECT count(*) FROM prefix_course_modules cm WHERE cm.course = c.id) Modules
FROM `prefix_course` AS c
WHERE groupmode > 0
</code>

===List all Courses in and below a certain category===
Use this SQL code to retrieve all courses that exist in or under a set category.

$s should be the id of the category you want to know about...
<code sql>
SELECT prefix_course. * , prefix_course_categories. *
FROM prefix_course, prefix_course_categories
WHERE prefix_course.category = prefix_course_categories.id
AND (
prefix_course_categories.path LIKE '/$s/%'
OR prefix_course_categories.path LIKE '/$s'
)
</code>
===List all Categories in one level below a certain category===
Use this PHP code to retrieve a list of all categories below a certain category.

$s should be the id of the top level category you are interested in.
<code php>
<?php

require_once('./config.php');

$parent_id = $s;

$categories= array();

$categories = get_categories($parent_id);

echo '<ol>';
foreach ($categories as $category)
{
echo '<li><a href="'.$CFG->wwwroot.'/course/category.php?id='.$category->id.'">'.$category->name.'</a></li>';
}
echo '</ol>';

?>
</code>

===Blog activity per Course (not including VIEW)===
Filter activity logging to some specific Course Categories!
+ link course name to actual course (for quick reference)
(you can change %blog% to %wiki% to filter down all wiki activity or any other module you wish)
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',cm.course,'">',c.fullname,'</a>') as CourseID
,m.name ,count(cm.id) as counter
,(SELECT Count( ra.userid ) AS Users
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5
AND ctx.instanceid = c.id
) AS Students
, ( SELECT count(id) FROM prefix_log WHERE `module` LIKE '%blog%' AND course = c.id AND action NOT LIKE '%view%' ) as BlogActivity
FROM `prefix_course_modules` as cm JOIN prefix_modules as m ON cm.module=m.id JOIN prefix_course as c ON cm.course = c.id
WHERE m.name LIKE '%blog%' AND c.category IN ( 8,13,15)
GROUP BY cm.course,cm.module order by counter desc
</code>

===All Courses which uploaded a Syllabus file===
+ under specific Category
+ show first Teacher in that course
+ link Course's fullname to actual course
<code sql>
SELECT
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course
,c.shortname,r.name
,(SELECT CONCAT(u.firstname,' ', u.lastname) as Teacher
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
JOIN prefix_user as u ON u.id = ra.userid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) as Teacher
FROM prefix_resource as r
JOIN prefix_course as c ON r.course = c.id
WHERE ( r.name LIKE '%סילבוס%' OR r.name LIKE '%סילאבוס%' OR r.name LIKE '%syllabus%' OR r.name LIKE '%תכנית הקורס%' )
AND c.category IN (10,18,26,13,28)
</code>

==Grade Reports==
===Site-Wide Grade Report with All Items===
Shows grades for all course items along with course totals for each student.
<code sql>
SELECT u.firstname AS 'First' , u.lastname AS 'Last', u.firstname + ' ' + u.lastname AS 'Display Name',
c.fullname AS 'Course',
cc.name AS 'Category',

CASE
WHEN gi.itemtype = 'course'
THEN c.fullname + ' Course Total'
ELSE gi.itemname
END AS 'Item Name',

ROUND(gg.finalgrade,2) AS Grade,
DATEADD(ss,gi.timemodified,'1970-01-01') AS Time

FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_grade_grades AS gg ON gg.userid = u.id
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid
JOIN prefix_course_categories as cc ON cc.id = c.category

WHERE gi.courseid = c.id
ORDER BY lastname
</code>
For MySQL users, you'll need to use the MySQL DATE_ADD function instead of DATEADD:
<code>
DATE_ADD('1970-01-01', INTERVAL gi.timemodified SECONDS) AS Time
</code>

===Site-Wide Grade Report with Just Course Totals===
A second site-wide grade report for all students that just shows course totals.
<code sql>
SELECT u.firstname AS 'First' , u.lastname AS 'Last', u.firstname + ' ' + u.lastname AS 'Display Name',
cc.name AS 'Category',
CASE
WHEN gi.itemtype = 'course'
THEN c.fullname + ' Course Total'
ELSE gi.itemname
END AS 'Item Name',

ROUND(gg.finalgrade,2) AS Grade,
DATEADD(ss,gi.timemodified,'1970-01-01') AS Time

FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_grade_grades AS gg ON gg.userid = u.id
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid
JOIN prefix_course_categories as cc ON cc.id = c.category

WHERE gi.courseid = c.id AND gi.itemtype = 'course'

ORDER BY lastname
</code>
For MySQL users, you'll need to use the MySQL DATE_ADD function instead of DATEADD:
<code>
DATE_ADD('1970-01-01', INTERVAL gi.timemodified SECONDS) AS Time
</code>

===Learner report by Learner with grades===
Which Learners in which course and what are the grades
<code sql>
SELECT u.firstname AS 'Name' , u.lastname AS 'Surname', c.fullname AS 'Course', cc.name AS 'Category',
CASE WHEN gi.itemtype = 'Course'
THEN c.fullname + ' Course Total'
ELSE gi.itemname
END AS 'Item Name', ROUND(gg.finalgrade,2) AS Score,ROUND(gg.rawgrademax,2) AS Max, ROUND(gg.finalgrade / gg.rawgrademax * 100 ,2) as Percentage,

if (ROUND(gg.finalgrade / gg.rawgrademax * 100 ,2) > 79,'Yes' , 'No') as Pass

FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_grade_grades AS gg ON gg.userid = u.id
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid
JOIN prefix_course_categories AS cc ON cc.id = c.category
WHERE gi.courseid = c.id and gi.itemname != 'Attendance'
ORDER BY `Name` ASC
</code>

==Activity Module Reports==

===Detailed ACTIONs for each MODULE===
<code sql>
SELECT module,action,count(id) as counter
FROM prefix_log
GROUP BY module,action
ORDER BY module,counter desc
</code>

===Most popular ACTIVITY===
<code sql>
SELECT COUNT(l.id) hits, module
FROM prefix_log l
WHERE module != 'login' AND module != 'course' AND module != 'role'
GROUP BY module
ORDER BY hits DESC
</code>

===System wide use of ACTIVITIES and RESOURCES===
<code sql>
SELECT count( cm.id ) AS counter, m.name
FROM `prefix_course_modules` AS cm
JOIN prefix_modules AS m ON cm.module = m.id
GROUP BY cm.module
ORDER BY counter DESC
</code>

===LOG file ACTIONS per MODULE per COURSE (IDs)===
<code sql>
select course,module,action,count(action) as summa from prefix_log
where action <> 'new'
group by course,action,module
order by course,module,action
</code>

===System Wide usage count of various course Activities===
(Tested and works fine in Moodle 2.x)
Like: Forum, Wiki, Blog, Assignment, Database,
#Within specific category
#Teacher name in course

<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course

,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%wiki%') AS Wikis
,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%blog%') AS Blogs

,(SELECT count( m.name ) AS count FROM
prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%forum%') AS Forums

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%data%') AS Databses

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%assignment%') AS Assignments

,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students

FROM prefix_course AS c
WHERE c.category IN ( 18)
ORDER BY Wikis DESC,Blogs DESC, Forums DESC
</code>

===Detailed WIKI activity (per wiki per course)===
Including Number of Students in course (for reference)
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',cm.course,'">',c.fullname,'</a>') as CourseID
,(SELECT Count( ra.userid ) AS Users
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5 AND ctx.instanceid = c.id ) AS Students
,m.name
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%updat%' ) as 'UPDAT E'
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%annotate%' ) as ANNOTATE
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%comment%' ) as COMMENT
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%add%' ) as 'A DD'
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%edit%' ) as EDIT
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action NOT LIKE '%view%' ) as 'All (NO View)'
FROM `prefix_course_modules` as cm
JOIN prefix_modules as m ON cm.module=m.id
JOIN prefix_course as c ON cm.course = c.id
WHERE m.name LIKE '%wiki%'
GROUP BY cm.course,cm.module
ORDER BY 'All (NO View)' DESC
</code>

===Wiki usage, system wide===
(you can filter the output by selecting some specific course categories : "WHERE c.category IN ( 8,13,15)")

<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%wiki%') AS Wikis

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%') AS 'WikiActivity ALL'

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%add%' ) AS 'WikiActivity ADD'

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%edit%' ) AS 'WikiActivity EDIT'

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%annotate%' ) AS 'WikiActivity ANNOTATE'

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%comments%' ) AS 'WikiActivity Comments'

,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students

,(SELECT count(*) FROM prefix_ouwiki_pages as ouwp
JOIN prefix_ouwiki as ouw ON ouw.id = ouwp.subwikiid
WHERE ouw.course = c.id GROUP BY ouw.course ) as OUWikiPages

,(SELECT count( DISTINCT nwp.pagename ) FROM prefix_wiki_pages AS nwp
JOIN prefix_wiki AS nw ON nw.id = nwp.dfwiki WHERE nw.course = c.id ) As NWikiPages

FROM prefix_course AS c
WHERE c.category IN ( 8,13,15)
HAVING Wikis > 0
ORDER BY 'WikiActivity ALL' DESC
</code>

===Aggregated Teacher activity by "WEB2" Modules===
(Tested and works fine in Moodle 2.x)
The NV column shows activity without VIEW log activity
<code sql>
SELECT ra.userid, u.firstname,u.lastname
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%wiki%') AS Wiki
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%wiki%' AND l.action NOT LIKE '%view%') AS Wiki_NV
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%forum%') AS Forum
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%forum%' AND l.action NOT LIKE '%view%') AS Forum_NV
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%blog%') AS Blog
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%blog%' AND l.action NOT LIKE '%view%') AS Blog_NV
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%assignment%') AS Assignment
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%assignment%' AND l.action NOT LIKE '%view%') AS Assignment_NV
FROM prefix_role_assignments AS ra
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid = 3
GROUP BY ra.userid
</code>

===List all the certificates issued, sort by variables in the custom profile fields===
Note: The SQL queries look intimidating at first, but isn't really that difficult to learn. I've seen in the forums that users wanted to do 'site-wide' groups in 1.9x. This is sort of the idea. It pulls all the certificates issued to all users sorted by the custom profile fields, which in my case is the Units or Depts (i.e. my site wide groups). Why certificates? I've explored with both grades and quizzes, the course admins are not really interested in the actual grades but whether the learner received a certificate (i.e. passed the course with x, y, z activities). It also saves me from creating groups and assigning them into the right groups. Even assigning in bulk is not efficient, since I have upward of 25 groups per course and constantly new learners enrolling in courses. The limitation is something to do with the server? as it only pull 5000 rows of data. If anyone figured out how to change this, please let me know. In the meantime, the work around is to pull only a few units/depts at a time to limit the number of rows. This is fine at the moment, since each course admin are only responsible for certain units/depts.

<code sql>
SELECT
DATE_FORMAT( FROM_UNIXTIME(prefix_certificate_issues.timecreated), '%Y/%m/%d' ) AS Date,
prefix_certificate_issues.classname AS Topic,
prefix_certificate.name AS Certificate,
prefix_certificate_issues.studentname as Name,
prefix_user_info_data.data AS Units

FROM
prefix_certificate_issues

INNER JOIN prefix_user_info_data
on prefix_certificate_issues.userid = prefix_user_info_data.userid

INNER JOIN prefix_certificate
on prefix_certificate_issues.certificateid = prefix_certificate.id

WHERE prefix_user_info_data.data='Unit 1'
OR prefix_user_info_data.data='Unit 2'
OR prefix_user_info_data.data='Unit 3'

ORDER BY Units, Name, Topic ASC
</code>

===Counter Blog usage in Courses,system wide===
What teachers in what courses, uses blogs and how many + student count in that course.
<code sql>

SELECT ( @counter := @counter+1) as counter,
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course

,( SELECT DISTINCT CONCAT(u.firstname,' ',u.lastname)
FROM prefix_role_assignments AS ra
JOIN prefix_user AS u ON ra.userid = u.id
JOIN prefix_context AS ctx ON ctx.id = ra.contextid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id AND ctx.contextlevel = 50 LIMIT 1) AS Teacher

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%blog%') AS Blogs

,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students

FROM prefix_course AS c, (SELECT @counter := 0) as s_init
WHERE c.category IN ( 8,13,15)
HAVING Blogs > 0
ORDER BY Blogs DESC
</code>

==Assignment Module Reports==
===All Ungraded Assignments===
Returns all the submitted assignments that still need grading
<code sql>
select
u.firstname AS "First",
u.lastname AS "Last",
c.fullname AS "Course",
a.name AS "Assignment"

from prefix_assignment_submissions as asb
join prefix_assignment as a ON a.id = asb.assignment
join prefix_user as u ON u.id = asb.userid
join prefix_course as c ON c.id = a.course
join prefix_course_modules as cm ON c.id = cm.course

where asb.grade < 0 and cm.instance = a.id
and cm.module = 1

order by c.fullname, a.name, u.lastname
</code>

===All Ungraded Assignments w/ Link===
Returns all the submitted assignments that still need grading, along with a link that goes directly to the submission to grade it. The links work if you view the report within Moodle.
<code sql>
select
u.firstname AS "First",
u.lastname AS "Last",
c.fullname AS "Course",
a.name AS "Assignment",

'<a href="http://education.varonis.com/mod/assignment/submissions.php' + char(63) +
+ 'id=' + cast(cm.id as varchar) + '&userid=' + cast(u.id as varchar)
+ '&mode=single&filter=0&offset=2">' + a.name + '</a>'
AS "Assignmentlink"

from prefix_assignment_submissions as asb
join prefix_assignment as a ON a.id = asb.assignment
join prefix_user as u ON u.id = asb.userid
join prefix_course as c ON c.id = a.course
join prefix_course_modules as cm ON c.id = cm.course

where asb.grade < 0 and cm.instance = a.id and cm.module = 1

order by c.fullname, a.name, u.lastname
</code>

===Who is using "Single File Upload" assignment===
<code sql>
SELECT
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course

,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher

,ass.name as "Assignment Name"

FROM
prefix_assignment as ass

JOIN
prefix_course as c ON c.id = ass.course

WHERE `assignmenttype` LIKE 'uploadsingle'
</code>

==Resource Module Reports==
===List "Recently uploaded files"===
see what users are uploading
<code sql>
SELECT FROM_UNIXTIME(time,'%Y %M %D %h:%i:%s') as time ,ip,userid,url,info
FROM `prefix_log`
WHERE `action` LIKE 'upload'
ORDER BY `prefix_log`.`time` DESC
</code>

===List Courses that loaded a specific file: "X"===
Did the Teacher (probably) uploaded course's Syllabus ?
<code sql>
SELECT c.id, c.fullname FROM `prefix_log` as l
JOIN prefix_course as c ON c.id = l.course
WHERE `action` LIKE '%upload%' AND ( info LIKE '%Syllabus%' OR info LIKE '%Sylabus%' ) GROUP BY c.id
</code>

===All resources that link to some specific external website===
+ link to course
+ who's the teacher
+ link to external resource
<code sql>
SELECT
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course
,c.shortname,r.name
,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher
,concat('<a target="_new" href="%%WWWROOT%%/mod/resource/view.php?id=',r.id,'">',r.name,'</a>') AS Resource
FROM prefix_resource AS r
JOIN prefix_course AS c ON r.course = c.id
WHERE r.reference LIKE 'http://info.oranim.ac.il/home%'
</code>

==="Compose Web Page" RESOURCE count===
<code sql>
SELECT course,prefix_course.fullname, COUNT(*) AS Total
FROM `prefix_resource`
JOIN `prefix_course` ON prefix_course.id = prefix_resource.course
WHERE type='html'
GROUP BY course
</code>

===Resource count in courses===
+ (First)Teacher name
+ Where course is inside some specific Categories
<code sql>
SELECT
COUNT(*) AS count
,r.course
,c.shortname shortname
,c.fullname coursename
,( SELECT DISTINCT CONCAT(u.firstname,' ',u.lastname)
FROM prefix_role_assignments AS ra
JOIN prefix_user as u ON ra.userid = u.id
JOIN prefix_context AS ctx ON ctx.id = ra.contextid
WHERE ra.roleid = 3 AND ctx.instanceid = r.course AND ctx.contextlevel = 50 LIMIT 1) AS Teacher
FROM prefix_resource r
JOIN prefix_course c ON r.course = c.id
WHERE c.category IN (10,13,28,18,26)
GROUP BY r.course
ORDER BY COUNT(*) DESC
</code>

==Forum Module Reports==
===FORUM use Count per COURSE -- not including NEWS Forum!===
<code sql>
SELECT prefix_course.fullname, prefix_forum.course, count(*) as total FROM prefix_forum
INNER JOIN prefix_course
ON prefix_course.id = prefix_forum.course
WHERE NOT(prefix_forum.type = 'news')
GROUP BY prefix_forum.course
ORDER BY total desc
</code>

===FORUM use Count per COURSE by type -- not including NEWS Forum!===
<code sql>
SELECT prefix_course.fullname, prefix_forum.course, prefix_forum.type, count(*) as total FROM prefix_forum
INNER JOIN prefix_course
ON prefix_course.id = prefix_forum.course
WHERE NOT(prefix_forum.type = 'news')
GROUP BY prefix_forum.course,prefix_forum.type
ORDER BY total desc
</code>

===Activity In Forums===
Trying to figure out how much real activity we have in Forums by aggregating:
Users in Course, Number of Posts, Number of Discussions, Unique student post, Unique student discussions, Number of Teachers , Number of Students, ratio between unique Student posts and the number of students in the Course...
<code sql>
SELECT c.fullname,f.name,f.type
,(SELECT count(id) FROM prefix_forum_discussions as fd WHERE f.id = fd.forum) as Discussions
,(SELECT count(distinct fd.userid) FROM prefix_forum_discussions as fd WHERE fd.forum = f.id) as UniqueUsersDiscussions
,(SELECT count(fp.id) FROM prefix_forum_discussions fd JOIN prefix_forum_posts as fp ON fd.id = fp.discussion WHERE f.id = fd.forum) as Posts
,(SELECT count(distinct fp.userid) FROM prefix_forum_discussions fd JOIN prefix_forum_posts as fp ON fd.id = fp.discussion WHERE f.id = fd.forum) as UniqueUsersPosts
,(SELECT Count( ra.userid ) AS Students
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid =5
AND ctx.instanceid = c.id
) AS StudentsCount
,(SELECT Count( ra.userid ) AS Teachers
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid =3
AND ctx.instanceid = c.id
) AS 'Teacher Count'
,(SELECT Count( ra.userid ) AS Users
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid IN (3,5)
AND ctx.instanceid = c.id
) AS UserCount
, (SELECT (UniqueUsersDiscussions / StudentsCount )) as StudentDissUsage
, (SELECT (UniqueUsersPosts /StudentsCount)) as StudentPostUsage
FROM prefix_forum as f
JOIN prefix_course as c ON f.course = c.id
WHERE `type` != 'news'
ORDER BY StudentPostUsage DESC
</code>

===All Forum type:NEWS===
<code sql>
SELECT f.id, f.name
FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
JOIN prefix_forum AS f ON cm.instance = f.id
WHERE m.name = 'forum'
AND f.type = 'news'
</code>

===All new forum NEWS items (discussions) from all my Courses===
change "userid = 26" and "id = 26" to a new user id
<code sql>
SELECT c.shortname,f.name,fd.name,FROM_UNIXTIME(fd.timemodified ,"%d %M %Y ") as Date
FROM prefix_forum_discussions as fd
JOIN prefix_forum as f ON f.id = fd.forum
JOIN prefix_course as c ON c.id = f.course
JOIN prefix_user_lastaccess as ul ON (c.id = ul.courseid AND ul.userid = 26)
WHERE fd.timemodified > ul.timeaccess
AND fd.forum IN (SELECT f.id
FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
JOIN prefix_forum AS f ON cm.instance = f.id
WHERE m.name = 'forum'
AND f.type = 'news')
AND c.id IN (SELECT c.id
FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE u.id = 26) ORDER BY `fd`.`timemodified` DESC
</code>

===News Forum - Discussions COUNT===
Which is actually... How much instructions students get from their teachers
<code sql>
SELECT c.shortname ,
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course
,( SELECT DISTINCT CONCAT(u.firstname,' ',u.lastname)
FROM prefix_role_assignments AS ra
JOIN prefix_user AS u ON ra.userid = u.id
JOIN prefix_context AS ctx ON ctx.id = ra.contextid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id AND ctx.contextlevel = 50 LIMIT 1) AS Teacher
,concat('<a target="_new" href="%%WWWROOT%%/mod/forum/view.php?f=',fd.forum,'">',count(fd.id),'</a>') AS DiscussionsSum
FROM prefix_forum_discussions AS fd
INNER JOIN prefix_forum AS f ON f.id = fd.forum
INNER JOIN prefix_course AS c ON c.id = f.course
WHERE f.type = 'news' AND c.category IN (10,13,28,18,26)
GROUP BY fd.forum
ORDER BY count(fd.id) DESC
</code>

==Quiz Module Reports==
===Generate a list of instructors and their email addresses for those courses that has "essay questions" in their quizzes===
<code sql>
SELECT qu.id AS quiz_id, qu.course AS course_id, qu.questions,
co.fullname AS course_fullname, co.shortname AS course_shortname,
qu.name AS quiz_name, FROM_UNIXTIME(qu.timeopen) AS quiz_timeopen, FROM_UNIXTIME(qu.timeclose) AS quiz_timeclose,
u.firstname, u.lastname, u.email,
FROM mdl_quiz qu, mdl_course co, mdl_role re, mdl_context ct, mdl_role_assignments ra, mdl_user u
WHERE FROM_UNIXTIME(timeopen) > '2008-05-14' AND
qu.course = co.id AND
co.id = ct.instanceid AND
ra.roleid = re.id AND
re.name = 'Teacher' AND
ra.contextid = ct.id AND
ra.userid = u.id

SELECT Count('x') As NumOfStudents
FROM mdl_role_assignments a
JOIN mdl_user u ON userid = u.id
WHERE roleid = 5 AND contextid = (SELECT id FROM mdl_context WHERE instanceid = 668 AND contextlevel = 50)
</code>

===Number of Quizes per Course===
<code sql>
SELECT count(*)
,concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course
,concat('<a target="_new" href="%%WWWROOT%%/mod/quiz/index.php?id=',c.id,'">Link</a>') AS Quizes

FROM prefix_course_modules cm
JOIN prefix_course c ON c.id = cm.course
JOIN prefix_modules as m ON m.id = cm.module
WHERE m.name LIKE 'quiz'
GROUP BY c.id
</code>

ad-hoc contributed reports

2012-05-03T12:57:30Z

Jonwitts: /* List all Courses in and below a certain category */

Talk:File upload size

2012-03-05T17:13:50Z

Jonwitts: /* This is in the FAQ but is not in the "style of" FAQ */

==This is in the FAQ but is not in the "style of" FAQ==
I've been going through the FAQ pages and spotted this one - it's in the list but doesn't actually follow the FAQ format. Shall I restyle it, making some questions out of the long paragraphs (of the bits I understand) so it looks like the others? OR.. is it here by error?? --[[User:Mary Cooch|Mary Cooch]] 21:08, 5 March 2012 (WST)
===My thoughts...===
I don't think this one should really been seen as an FAQ page Mary. I appreciate it starts with the line "Probably the most frequently asked question in the Moodle.org Using Moodle forums is" but it needs an in-depth technical page to be able to cope with all of the different ways there are of making this change.

Maybe take it out of the FAQ group of pages and just ensure there is a link from a relevant FAQ page back to this one... [[User:Jon Witts|Jon Witts]] 01:13, 6 March 2012 (WST)

Talk:File upload size

2012-03-05T17:13:21Z

Jonwitts:

==This is in the FAQ but is not in the "style of" FAQ==
I've been going through the FAQ pages and spotted this one - it's in the list but doesn't actually follow the FAQ format. Shall I restyle it, making some questions out of the long paragraphs (of the bits I understand) so it looks like the others? OR.. is it here by error?? --[[User:Mary Cooch|Mary Cooch]] 21:08, 5 March 2012 (WST)

I don't think this one should really been seen as an FAQ page Mary. I appreciate it starts with the line "Probably the most frequently asked question in the Moodle.org Using Moodle forums is" but it needs an in-depth technical page to be able to cope with all of the different ways there are of making this change.

Maybe take it out of the FAQ group of pages and just ensure there is a link from a relevant FAQ page back to this one... [[User:Jon Witts|Jon Witts]] 01:13, 6 March 2012 (WST)

Performance FAQ

2011-10-19T17:21:49Z

Jonwitts: /* Should I go for 64 bit or is 32 bit OK? */

{{Performance}}
==How do you define "concurrent users"?==
As has been repeatedly stressed in the [http://moodle.org/mod/forum/view.php?f=94 Hardware and performance] forum, the load on the server at a particular time depends on the number of concurrent users, not on the total number of users neither on the number of users logged-in. The term "concurrent users" is used to mean those users for whom the server is actively doing something . It may by processing a webpage written in PHP, querying the database or simply transferring a file. (see also Wikipedia [http://en.wikipedia.org/wiki/Concurrency_(computer_science) Concurrency])

==How do I benchmark a Moodle-site?==
You can of course benchmark parts of the system separately: the hardware as seen by the operating system (eg. CPU, disk access), web server performance, database server performance, execution on PHP operations, etc. For further details see [[Performance#Obtain_a_baseline_benchmark]].

But there is no easy formula to deduce the maximum number of concurrent users from those results. There is a PHP-script, the [http://moodle.org/mod/forum/discuss.php?d=57028 Performance perspectives - a little script], circulating amoung the Moodle-community which calculates a ballpark figure. The current version is attached to [http://moodle.org/mod/forum/discuss.php?d=57028&parent=772267|the posting on 25. March 2011].

Warning: Note that running this script on a production server may have unwanted side-effects. You are strongly adviced to run it on a test-site.

==What are PHP-accelerators?==
See Wikipedia [http://en.wikipedia.org/wiki/PHP_accelerator PHP accelerator].

Available software are documented under [[Performance#PHP_performance]].

You find some user suggestions here [http://moodle.org/mod/forum/discuss.php?d=168965 Update on PHP-accelerators].

==How do I cluster Moodle?==

See [[Performance#Scalability]]

[[Moodle_Clusters]]

==How do I replicate Moodle?==

[[Mirroring_Moodle]]

[http://moodle.org/mod/forum/discuss.php?d=173408&parent=760514 How to Replicate MOODLE ??!!]

==My site is very slow, what should I do?==

First find out "how slow". (The theme-trick here).

The next question is, whether the performance is normal or something malfunctions. There are many things which can malfunction:
* hardware
* crashed filesystems, specially network filesystems
* memory leaks or other crashes in the system
* bug in Moodle
* corrupted database
* networking issues (DNS, firewalls, ...)

Or your performance could be "normal" under the given circumstances:
* Are you on a dedicated server or a shared (virtual) server?
* How much RAM, processing power do you have?
* What is the software stack you use? (Unix or Windows, Apache or IIS, MySQL, PostgreSQL or SQL-Server, ...?)
* how many concurrent users can you support
* what modules/activities you use? Check [[Performance#Performance of different Moodle modules]]

[[Performance#Obtain a baseline benchmark]] and compare it with the published figures.

==What are the requirements for N users?==

[http://moodle.org/mod/forum/discuss.php?d=111847 A moodle setup for 10K simultaneous users]

==How many users will my installation support?==

This is another way of asking the same question as above. Please move up.

==What is the best webserver?==

==Should I go for 64 bit or is 32 bit OK?==

==What hosting provider do you recommend?==
http://moodle.org/mod/forum/discuss.php?d=99405

== See also ==

Using Moodle forum discussions
* [http://moodle.org/mod/forum/search.php?notwords=Re:&id=5&subject=performance All performance related discussions]
* [http://moodle.org/mod/forum/search.php?notwords=Re:&id=5&forumid=33&&subject=performance Performance related discussions in the General Developer forum]

* [http://moodle.org/mod/forum/discuss.php?d=102978 1000 concurrent users]
* [http://moodle.org/mod/forum/discuss.php?d=103040 Tool to estimate server's maximum concurrent users]
* [http://moodle.org/mod/forum/discuss.php?d=144718 Handling Moodle database load - a solution!]

[[Category:FAQ]]

ad-hoc contributed reports

2011-09-14T12:27:41Z

Jonwitts: /* List all Courses in and below a certain category */

These are community contributed reports for the [[Custom_SQL_queries_report]] site-wide report plugin (module) 
Everyone is welcome to add their own. until we find a better way to exchange reports between us. 
Enjoy :-) 

----

===Detailed ACTIONs for each MODULE===
<code sql>
SELECT module,action,count(id) as counter
FROM prefix_log
GROUP BY module,action
ORDER BY module,counter desc
</code>

===Detailed ACTIONs for each ROLE (TEACHER,NONE-EDITING TEACHER and STUDENT)===
<code sql>
SELECT r.name,l.action, count( l.userid ) as counter
FROM `prefix_log` as l
JOIN `prefix_role_assignments` AS ra on l.userid = ra.userid
JOIN prefix_role AS r ON ra.roleid = r.id
WHERE ra.roleid IN (3,4,5)
GROUP BY roleid,l.action
ORDER BY counter desc
</code>

===Detailed "VIEW" ACTION for each ROLE (TEACHER,NONE-EDITING TEACHER and STUDENT)===
<code sql>
SELECT l.action, count( l.userid ) as counter , r.name
FROM `prefix_log` as l
JOIN `prefix_role_assignments` AS ra on l.userid = ra.userid
JOIN `prefix_role` AS r ON ra.roleid = r.id
WHERE (ra.roleid IN (3,4,5)) AND (l.action LIKE '%view%' )
GROUP BY roleid,l.action
order by r.name,counter desc
</code>

===Most Active courses===
<code sql>
SELECT COUNT(l.id) hits, l.course courseId, c.fullname coursename
FROM prefix_log l INNER JOIN prefix_course c ON l.course = c.id
GROUP BY courseId
ORDER BY hits DESC
</code>

===RESOURCE count for each COURSE===
<code sql>
SELECT COUNT(l.id) count, l.course, c.fullname coursename
FROM prefix_resource l INNER JOIN prefix_course c on l.course = c.id
GROUP BY course
ORDER BY count DESC
</code>

===Most popular ACTIVITY===
<code sql>
SELECT COUNT(l.id) hits, module
FROM prefix_log l
WHERE module != 'login' AND module != 'course' AND module != 'role'
GROUP BY module
ORDER BY hits DESC
</code>

===System wide use of ACTIVITIES and RESOURCES===
<code sql>
SELECT count( cm.id ) AS counter, m.name
FROM `prefix_course_modules` AS cm
JOIN prefix_modules AS m ON cm.module = m.id
GROUP BY cm.module
ORDER BY counter DESC
</code>

===LOG file ACTIONS per MODULE per COURSE (IDs)===
<code sql>
select course,module,action,count(action) as summa from prefix_log
where action <> 'new'
group by course,action,module
order by course,module,action
</code>

==="Compose Web Page" RESOURCE count===
<code sql>
SELECT course,prefix_course.fullname, COUNT(*) AS Total
FROM `prefix_resource`
JOIN `prefix_course` ON prefix_course.id = prefix_resource.course
WHERE type='html'
GROUP BY course
</code>

===Total Activity of Roles:"Teacher" and "None-Editing Teacher" by Dates and by Hours===
The output columns of this report table can be used as base for a Pivot-Table
which will show the amount of '''activity''' per '''hour''' per '''days''' in 3D graph view.

<code sql>
SELECT DATE_FORMAT( FROM_UNIXTIME( l.time ) , '%Y/%m/%d' ) AS grptimed ,
DATE_FORMAT( FROM_UNIXTIME( l.time ) , '%k' ) AS grptimeh , count( l.userid ) AS counter
FROM `prefix_log` AS l
JOIN prefix_user AS u ON u.id = l.userid
JOIN prefix_role_assignments AS ra ON l.userid = ra.userid
JOIN prefix_role AS r ON r.id = ra.roleid
WHERE ra.roleid IN (3,4)
GROUP BY grptimed,grptimeh
ORDER BY grptimed,grptimeh
</code>

===FORUM use Count per COURSE -- not including NEWS Forum!===
<code sql>
SELECT prefix_course.fullname, prefix_forum.course, count(*) as total FROM prefix_forum
INNER JOIN prefix_course
ON prefix_course.id = prefix_forum.course
WHERE NOT(prefix_forum.type = 'news')
GROUP BY prefix_forum.course
ORDER BY total desc
</code>

===FORUM use Count per COURSE by type -- not including NEWS Forum!===
<code sql>
SELECT prefix_course.fullname, prefix_forum.course, prefix_forum.type, count(*) as total FROM prefix_forum
INNER JOIN prefix_course
ON prefix_course.id = prefix_forum.course
WHERE NOT(prefix_forum.type = 'news')
GROUP BY prefix_forum.course,prefix_forum.type
ORDER BY total desc
</code>

===LIST of all site USERS by COURSE enrollment (Moodle 1.9.x)===

Reports a site global list of all users enroled in each course
<code sql>
SELECT
user.firstname AS Firstname,
user.lastname AS Lastname,
user.email AS Email,
user.city AS City,
course.fullname AS Course
,(SELECT name FROM prefix_role WHERE id=asg.roleid)
FROM
prefix_user AS user,
prefix_course AS course,
prefix_role_assignments AS asg
INNER JOIN prefix_context AS context ON asg.contextid=context.id
WHERE
context.contextlevel = 50
AND
user.id=asg.userid
AND
context.instanceid=course.id
</code>

===LIST of all site USERS by COURSE enrollment (Moodle 2.x)===

<code sql>
SELECT
user2.firstname AS Firstname,
user2.lastname AS Lastname,
user2.email AS Email,
user2.city AS City,
course.fullname AS Course
,(SELECT shortname FROM prefix_role WHERE id=en.roleid) as Role
,(SELECT name FROM prefix_role WHERE id=en.roleid) as RoleName

FROM prefix_course as course
JOIN prefix_enrol AS en ON en.courseid = course.id
JOIN prefix_user_enrolments AS ue ON ue.enrolid = en.id
JOIN prefix_user AS user2 ON ue.userid = user2.id
</code>

===Permissions Overides on Categories===
(By: [http://moodle.org/mod/forum/discuss.php?d=153059#p712834 Séverin Terrier] )
<code sql>
SELECT rc.id, ct.instanceid, ccat.name, rc.roleid, rc.capability, rc.permission,
DATE_FORMAT( FROM_UNIXTIME( rc.timemodified ) , '%Y-%m-%d' ) AS timemodified, rc.modifierid, ct.instanceid, ct.path, ct.depth
FROM `prefix_role_capabilities` AS rc
INNER JOIN `prefix_context` AS ct ON rc.contextid = ct.id
INNER JOIN `prefix_course_categories` AS ccat ON ccat.id = ct.instanceid
AND `contextlevel` =40
</code>

===Lists "Totally Opened Courses" (visible, opened to guests, with no password)===
(By: [http://moodle.org/mod/forum/discuss.php?d=153059#p712837 Séverin Terrier] )
<code sql>
SELECT id , category , fullname , shortname , enrollable
FROM `prefix_course`
WHERE `guest` =1
AND `password` = ""
AND `visible` =1
</code>

===Lists "loggedin users" from the last 120 days===
<code sql>
SELECT id,username,FROM_UNIXTIME(`lastlogin`) as days
FROM `mdl_user`
WHERE DATEDIFF( NOW(),FROM_UNIXTIME(`lastlogin`) ) < 120
</code>

''and user count for that same population:''
<code sql>
SELECT COUNT(id) as Users FROM `mdl_user`
WHERE DATEDIFF( NOW(),FROM_UNIXTIME(`lastlogin`) ) < 120
</code>

===List "Recently uploaded files"===
see what users are uploading
<code sql>
SELECT FROM_UNIXTIME(time,'%Y %M %D %h:%i:%s') as time ,ip,userid,url,info
FROM `prefix_log`
WHERE `action` LIKE 'upload'
ORDER BY `prefix_log`.`time` DESC
</code>

===List Courses that loaded a specific file: "X"===
Did the Teacher (probably) uploaded course's Syllabus ?
<code sql>
SELECT c.id, c.fullname FROM `prefix_log` as l
JOIN prefix_course as c ON c.id = l.course
WHERE `action` LIKE '%upload%' AND ( info LIKE '%Syllabus%' OR info LIKE '%Sylabus%' ) GROUP BY c.id
</code>

===Students in all courses of some institute===
What is the status (deleted or not) of all Students (roleid = 5) in all courses of some Institute
<code sql>
SELECT c.id, c.fullname, u.firstname, u.lastname, u.deleted
FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid =5
AND ctx.instanceid = c.id
AND u.institution = 'please enter school name here'
</code>

===Full User info (for deleted users)===
Including extra custom profile fields (from mdl_user_info_data)
<code sql>
SELECT *
FROM mdl_user as u
JOIN mdl_user_info_data as uid ON uid.userid = u.id
JOIN mdl_user_info_field as uif ON (uid.fieldid = uif.id AND uif.shortname = 'class')
WHERE `deleted` = "1" and `institution`="your school name" and `department` = "your department" and `data` = "class level and number"
</code>

===Activity In Forums===
Trying to figure out how much real activity we have in Forums by aggregating:
Users in Course, Number of Posts, Number of Discussions, Unique student post, Unique student discussions, Number of Teachers , Number of Students, ratio between unique Student posts and the number of students in the Course...
<code sql>
SELECT c.fullname,f.name,f.type
,(SELECT count(id) FROM prefix_forum_discussions as fd WHERE f.id = fd.forum) as Discussions
,(SELECT count(distinct fd.userid) FROM prefix_forum_discussions as fd WHERE fd.forum = f.id) as UniqueUsersDiscussions
,(SELECT count(fp.id) FROM prefix_forum_discussions fd JOIN prefix_forum_posts as fp ON fd.id = fp.discussion WHERE f.id = fd.forum) as Posts
,(SELECT count(distinct fp.userid) FROM prefix_forum_discussions fd JOIN prefix_forum_posts as fp ON fd.id = fp.discussion WHERE f.id = fd.forum) as UniqueUsersPosts
,(SELECT Count( ra.userid ) AS Students
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid =5
AND ctx.instanceid = c.id
) AS StudentsCount
,(SELECT Count( ra.userid ) AS Teachers
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid =3
AND ctx.instanceid = c.id
) AS 'Teacher Count'
,(SELECT Count( ra.userid ) AS Users
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid IN (3,5)
AND ctx.instanceid = c.id
) AS UserCount
, (SELECT (UniqueUsersDiscussions / StudentsCount )) as StudentDissUsage
, (SELECT (UniqueUsersPosts /StudentsCount)) as StudentPostUsage
FROM prefix_forum as f
JOIN prefix_course as c ON f.course = c.id
WHERE `type` != 'news'
ORDER BY StudentPostUsage DESC
</code>

===Blog activity per Course (not including VIEW)===
Filter activity logging to some specific Course Categories!
+ link course name to actual course (for quick reference)
(you can change %blog% to %wiki% to filter down all wiki activity or any other module you wish)
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',cm.course,'">',c.fullname,'</a>') as CourseID
,m.name ,count(cm.id) as counter
,(SELECT Count( ra.userid ) AS Users
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5
AND ctx.instanceid = c.id
) AS Students
, ( SELECT count(id) FROM prefix_log WHERE `module` LIKE '%blog%' AND course = c.id AND action NOT LIKE '%view%' ) as BlogActivity
FROM `prefix_course_modules` as cm JOIN prefix_modules as m ON cm.module=m.id JOIN prefix_course as c ON cm.course = c.id
WHERE m.name LIKE '%blog%' AND c.category IN ( 8,13,15)
GROUP BY cm.course,cm.module order by counter desc
</code>

===Detailed WIKI activity (per wiki per course)===
Including Number of Students in course (for reference)
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',cm.course,'">',c.fullname,'</a>') as CourseID
,(SELECT Count( ra.userid ) AS Users
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5 AND ctx.instanceid = c.id ) AS Students
,m.name
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%updat%' ) as 'UPDAT E'
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%annotate%' ) as ANNOTATE
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%comment%' ) as COMMENT
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%add%' ) as 'A DD'
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%edit%' ) as EDIT
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action NOT LIKE '%view%' ) as 'All (NO View)'
FROM `prefix_course_modules` as cm
JOIN prefix_modules as m ON cm.module=m.id
JOIN prefix_course as c ON cm.course = c.id
WHERE m.name LIKE '%wiki%'
GROUP BY cm.course,cm.module
ORDER BY 'All (NO View)' DESC
</code>

===All Courses which uploaded a Syllabus file===
+ under specific Category
+ show first Teacher in that course
+ link Course's fullname to actual course
<code sql>
SELECT
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course
,c.shortname,r.name
,(SELECT CONCAT(u.firstname,' ', u.lastname) as Teacher
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
JOIN prefix_user as u ON u.id = ra.userid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) as Teacher
FROM prefix_resource as r
JOIN prefix_course as c ON r.course = c.id
WHERE ( r.name LIKE '%סילבוס%' OR r.name LIKE '%סילאבוס%' OR r.name LIKE '%syllabus%' OR r.name LIKE '%תכנית הקורס%' )
AND c.category IN (10,18,26,13,28)
</code>

===All resources that link to some specific external website===
+ link to course
+ who's the teacher
+ link to external resource
<code sql>
SELECT
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course
,c.shortname,r.name
,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher
,concat('<a target="_new" href="%%WWWROOT%%/mod/resource/view.php?id=',r.id,'">',r.name,'</a>') AS Resource
FROM prefix_resource AS r
JOIN prefix_course AS c ON r.course = c.id
WHERE r.reference LIKE 'http://info.oranim.ac.il/home%'
</code>

===How many LOGINs per user and user's Activity===
+ link username to a user activity graph report
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/user.php?id=1&user=',u.id,'&mode=alllogs">',u.firstname ,' ',u.lastname,'</a>') as Username
,count(*) as logins
,(SELECT count(*) FROM prefix_log WHERE userid = l.userid GROUP BY userid) as Activity
FROM prefix_log as l JOIN prefix_user as u ON l.userid = u.id
WHERE `action` LIKE '%login%' group by userid
ORDER BY Activity DESC
</code>

===User's courses===
change "u.id = 2" with a new user id
<code sql>
SELECT u.firstname, u.lastname, c.id, c.fullname
FROM mdl_course AS c
JOIN mdl_context AS ctx ON c.id = ctx.instanceid
JOIN mdl_role_assignments AS ra ON ra.contextid = ctx.id
JOIN mdl_user AS u ON u.id = ra.userid
WHERE u.id = 2
</code>

===All Forum type:NEWS===
<code sql>
SELECT f.id, f.name
FROM mdl_course_modules AS cm
JOIN mdl_modules AS m ON cm.module = m.id
JOIN mdl_forum AS f ON cm.instance = f.id
WHERE m.name = 'forum'
AND f.type = 'news'
</code>

===All new forum NEWS items (discussions) from all my Courses===
change "userid = 26" and "id = 26" to a new user id
<code sql>
SELECT c.shortname,f.name,fd.name,FROM_UNIXTIME(fd.timemodified ,"%d %M %Y ") as Date
FROM mdl_forum_discussions as fd
JOIN mdl_forum as f ON f.id = fd.forum
JOIN mdl_course as c ON c.id = f.course
JOIN mdl_user_lastaccess as ul ON (c.id = ul.courseid AND ul.userid = 26)
WHERE fd.timemodified > ul.timeaccess
AND fd.forum IN (SELECT f.id
FROM mdl_course_modules AS cm
JOIN mdl_modules AS m ON cm.module = m.id
JOIN mdl_forum AS f ON cm.instance = f.id
WHERE m.name = 'forum'
AND f.type = 'news')
AND c.id IN (SELECT c.id
FROM mdl_course AS c
JOIN mdl_context AS ctx ON c.id = ctx.instanceid
JOIN mdl_role_assignments AS ra ON ra.contextid = ctx.id
JOIN mdl_user AS u ON u.id = ra.userid
WHERE u.id = 26) ORDER BY `fd`.`timemodified` DESC
</code>

==Resource count in courses==
+ (First)Teacher name
+ Where course is inside some specific Categories
<code sql>
SELECT
COUNT(*) AS count
,r.course
,c.shortname shortname
,c.fullname coursename
,( SELECT DISTINCT CONCAT(u.firstname,' ',u.lastname)
FROM prefix_role_assignments AS ra
JOIN prefix_user as u ON ra.userid = u.id
JOIN prefix_context AS ctx ON ctx.id = ra.contextid
WHERE ra.roleid = 3 AND ctx.instanceid = r.course AND ctx.contextlevel = 50 LIMIT 1) AS Teacher
FROM prefix_resource r
JOIN prefix_course c ON r.course = c.id
WHERE c.category IN (10,13,28,18,26)
GROUP BY r.course
ORDER BY COUNT(*) DESC
</code>

==News Forum - Discussions COUNT==
Which is actually... How much instructions students get from their teachers
<code sql>
SELECT c.shortname ,
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course
,( SELECT DISTINCT CONCAT(u.firstname,' ',u.lastname)
FROM prefix_role_assignments AS ra
JOIN prefix_user AS u ON ra.userid = u.id
JOIN prefix_context AS ctx ON ctx.id = ra.contextid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id AND ctx.contextlevel = 50 LIMIT 1) AS Teacher
,concat('<a target="_new" href="%%WWWROOT%%/mod/forum/view.php?f=',fd.forum,'">',count(fd.id),'</a>') AS DiscussionsSum
FROM prefix_forum_discussions AS fd
INNER JOIN prefix_forum AS f ON f.id = fd.forum
INNER JOIN prefix_course AS c ON c.id = f.course
WHERE f.type = 'news' AND c.category IN (10,13,28,18,26)
GROUP BY fd.forum
ORDER BY count(fd.id) DESC
</code>

==Special Roles==
<code sql>
SELECT ra.roleid,r.name
,concat('<a target="_new" href="%%WWWROOT%%/course/user.php?id=1&user=',ra.userid,'">',u.firstname ,' ',u.lastname,'</a>') AS Username
,concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course
FROM prefix_role_assignments AS ra
JOIN prefix_role AS r ON r.id = ra.roleid
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_context AS ctx ON (ctx.id = ra.contextid AND ctx.contextlevel = 50)
JOIN prefix_course AS c ON ctx.instanceid = c.id
WHERE ra.roleid > 6
</code>

==Courses without Teachers==
Actually, shows the number of Teachers in a course.
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course
,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 3 AND ctx.instanceid = c.id) AS Teachers
FROM prefix_course AS c
ORDER BY Teachers ASC
</code>

==Site-Wide Grade Report with All Items==
Shows grades for all course items along with course totals for each student.
<code sql>
SELECT u.firstname AS 'First' , u.lastname AS 'Last', u.firstname + ' ' + u.lastname AS 'Display Name',
c.fullname AS 'Course',
cc.name AS 'Category',

CASE
WHEN gi.itemtype = 'course'
THEN c.fullname + ' Course Total'
ELSE gi.itemname
END AS 'Item Name',

ROUND(gg.finalgrade,2) AS Grade,
DATEADD(ss,gi.timemodified,'1970-01-01') AS Time

FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_grade_grades AS gg ON gg.userid = u.id
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid
JOIN prefix_course_categories as cc ON cc.id = c.category

WHERE gi.courseid = c.id
ORDER BY lastname
</code>
For MySQL users, you'll need to use the MySQL DATE_ADD function instead of DATEADD:
<code>
DATE_ADD('1970-01-01', INTERVAL gi.timemodified SECONDS) AS Time
</code>

==Site-Wide Grade Report with Just Course Totals==
A second site-wide grade report for all students that just shows course totals.
<code sql>
SELECT u.firstname AS 'First' , u.lastname AS 'Last', u.firstname + ' ' + u.lastname AS 'Display Name',
cc.name AS 'Category',
CASE
WHEN gi.itemtype = 'course'
THEN c.fullname + ' Course Total'
ELSE gi.itemname
END AS 'Item Name',

ROUND(gg.finalgrade,2) AS Grade,
DATEADD(ss,gi.timemodified,'1970-01-01') AS Time

FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_grade_grades AS gg ON gg.userid = u.id
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid
JOIN prefix_course_categories as cc ON cc.id = c.category

WHERE gi.courseid = c.id AND gi.itemtype = 'course'

ORDER BY lastname
</code>
For MySQL users, you'll need to use the MySQL DATE_ADD function instead of DATEADD:
<code>
DATE_ADD('1970-01-01', INTERVAL gi.timemodified SECONDS) AS Time
</code>
==All Ungraded Assignments==
Returns all the submitted assignments that still need grading
<code sql>
select
u.firstname AS "First",
u.lastname AS "Last",
c.fullname AS "Course",
a.name AS "Assignment"

from prefix_assignment_submissions as asb
join prefix_assignment as a ON a.id = asb.assignment
join prefix_user as u ON u.id = asb.userid
join prefix_course as c ON c.id = a.course
join prefix_course_modules as cm ON c.id = cm.course

where asb.grade < 0 and cm.instance = a.id
and cm.module = 1

order by c.fullname, a.name, u.lastname
</code>

==All Ungraded Assignments w/ Link==
Returns all the submitted assignments that still need grading, along with a link that goes directly to the submission to grade it. The links work if you view the report within Moodle.
<code sql>
select
u.firstname AS "First",
u.lastname AS "Last",
c.fullname AS "Course",
a.name AS "Assignment",

'<a href="http://education.varonis.com/mod/assignment/submissions.php' + char(63) +
+ 'id=' + cast(cm.id as varchar) + '&userid=' + cast(u.id as varchar)
+ '&mode=single&filter=0&offset=2">' + a.name + '</a>'
AS "Assignmentlink"

from prefix_assignment_submissions as asb
join prefix_assignment as a ON a.id = asb.assignment
join prefix_user as u ON u.id = asb.userid
join prefix_course as c ON c.id = a.course
join prefix_course_modules as cm ON c.id = cm.course

where asb.grade < 0 and cm.instance = a.id and cm.module = 1

order by c.fullname, a.name, u.lastname
</code>

==Wiki usage, system wide==
(you can filter the output by selecting some specific course categories : "WHERE c.category IN ( 8,13,15)")

<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%wiki%') AS Wikis

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%') AS 'WikiActivity ALL'

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%add%' ) AS 'WikiActivity ADD'

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%edit%' ) AS 'WikiActivity EDIT'

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%annotate%' ) AS 'WikiActivity ANNOTATE'

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%comments%' ) AS 'WikiActivity Comments'

,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students

,(SELECT count(*) FROM prefix_ouwiki_pages as ouwp
JOIN prefix_ouwiki as ouw ON ouw.id = ouwp.subwikiid
WHERE ouw.course = c.id GROUP BY ouw.course ) as OUWikiPages

,(SELECT count( DISTINCT nwp.pagename ) FROM prefix_wiki_pages AS nwp
JOIN prefix_wiki AS nw ON nw.id = nwp.dfwiki WHERE nw.course = c.id ) As NWikiPages

FROM prefix_course AS c
WHERE c.category IN ( 8,13,15)
HAVING Wikis > 0
ORDER BY 'WikiActivity ALL' DESC
</code>

==Aggregated Teacher activity by "WEB2" Modules==
(Tested and works fine in Moodle 2.x)
The NV column shows activity without VIEW log activity
<code sql>
SELECT ra.userid, u.firstname,u.lastname
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%wiki%') AS Wiki
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%wiki%' AND l.action NOT LIKE '%view%') AS Wiki_NV
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%forum%') AS Forum
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%forum%' AND l.action NOT LIKE '%view%') AS Forum_NV
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%blog%') AS Blog
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%blog%' AND l.action NOT LIKE '%view%') AS Blog_NV
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%assignment%') AS Assignment
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%assignment%' AND l.action NOT LIKE '%view%') AS Assignment_NV
FROM prefix_role_assignments AS ra
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid = 3
GROUP BY ra.userid
</code>

==Courses that are defined as using GROUPs==
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/group/index.php?id=',c.id,'">',c.fullname,'</a>') AS Course
FROM `prefix_course` AS c
WHERE groupmode > 0
</code>

==System Wide usage count of various course Activities==
(Tested and works fine in Moodle 2.x)
Like: Forum, Wiki, Blog, Assignment, Database,
#Within specific category
#Teacher name in course

<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course

,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%wiki%') AS Wikis
,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%blog%') AS Blogs

,(SELECT count( m.name ) AS count FROM
prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%forum%') AS Forums

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%data%') AS Databses

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%assignment%') AS Assignments

,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students

FROM prefix_course AS c
WHERE c.category IN ( 18)
ORDER BY Wikis DESC,Blogs DESC, Forums DESC
</code>

==List all the certificates issued, sort by variables in the custom profile fields==
Note: The SQL queries look intimidating at first, but isn't really that difficult to learn. I've seen in the forums that users wanted to do 'site-wide' groups in 1.9x. This is sort of the idea. It pulls all the certificates issued to all users sorted by the custom profile fields, which in my case is the Units or Depts (i.e. my site wide groups). Why certificates? I've explored with both grades and quizzes, the course admins are not really interested in the actual grades but whether the learner received a certificate (i.e. passed the course with x, y, z activities). It also saves me from creating groups and assigning them into the right groups. Even assigning in bulk is not efficient, since I have upward of 25 groups per course and constantly new learners enrolling in courses. The limitation is something to do with the server? as it only pull 5000 rows of data. If anyone figured out how to change this, please let me know. In the meantime, the work around is to pull only a few units/depts at a time to limit the number of rows. This is fine at the moment, since each course admin are only responsible for certain units/depts.

<code sql>
SELECT
DATE_FORMAT( FROM_UNIXTIME(prefix_certificate_issues.timecreated), '%Y/%m/%d' ) AS Date,
prefix_certificate_issues.classname AS Topic,
prefix_certificate.name AS Certificate,
prefix_certificate_issues.studentname as Name,
prefix_user_info_data.data AS Units

FROM
prefix_certificate_issues

INNER JOIN prefix_user_info_data
on prefix_certificate_issues.userid = prefix_user_info_data.userid

INNER JOIN prefix_certificate
on prefix_certificate_issues.certificateid = prefix_certificate.id

WHERE prefix_user_info_data.data='Unit 1'
OR prefix_user_info_data.data='Unit 2'
OR prefix_user_info_data.data='Unit 3'

ORDER BY Units, Name, Topic ASC
</code>
==List all Courses in and below a certain category==
Use this SQL code to retrieve all courses that exist in or under a set category.

$s should be the id of the category you want to know about...
<code sql>
SELECT prefix_course. * , prefix_course_categories. *
FROM prefix_course, prefix_course_categories
WHERE prefix_course.category = prefix_course_categories.id
AND (
prefix_course_categories.path LIKE '/$s/%'
OR prefix_course_categories.path LIKE '/$s'
)
</code>

ad-hoc contributed reports

2011-09-14T12:27:15Z

Jonwitts:

These are community contributed reports for the [[Custom_SQL_queries_report]] site-wide report plugin (module) 
Everyone is welcome to add their own. until we find a better way to exchange reports between us. 
Enjoy :-) 

----

===Detailed ACTIONs for each MODULE===
<code sql>
SELECT module,action,count(id) as counter
FROM prefix_log
GROUP BY module,action
ORDER BY module,counter desc
</code>

===Detailed ACTIONs for each ROLE (TEACHER,NONE-EDITING TEACHER and STUDENT)===
<code sql>
SELECT r.name,l.action, count( l.userid ) as counter
FROM `prefix_log` as l
JOIN `prefix_role_assignments` AS ra on l.userid = ra.userid
JOIN prefix_role AS r ON ra.roleid = r.id
WHERE ra.roleid IN (3,4,5)
GROUP BY roleid,l.action
ORDER BY counter desc
</code>

===Detailed "VIEW" ACTION for each ROLE (TEACHER,NONE-EDITING TEACHER and STUDENT)===
<code sql>
SELECT l.action, count( l.userid ) as counter , r.name
FROM `prefix_log` as l
JOIN `prefix_role_assignments` AS ra on l.userid = ra.userid
JOIN `prefix_role` AS r ON ra.roleid = r.id
WHERE (ra.roleid IN (3,4,5)) AND (l.action LIKE '%view%' )
GROUP BY roleid,l.action
order by r.name,counter desc
</code>

===Most Active courses===
<code sql>
SELECT COUNT(l.id) hits, l.course courseId, c.fullname coursename
FROM prefix_log l INNER JOIN prefix_course c ON l.course = c.id
GROUP BY courseId
ORDER BY hits DESC
</code>

===RESOURCE count for each COURSE===
<code sql>
SELECT COUNT(l.id) count, l.course, c.fullname coursename
FROM prefix_resource l INNER JOIN prefix_course c on l.course = c.id
GROUP BY course
ORDER BY count DESC
</code>

===Most popular ACTIVITY===
<code sql>
SELECT COUNT(l.id) hits, module
FROM prefix_log l
WHERE module != 'login' AND module != 'course' AND module != 'role'
GROUP BY module
ORDER BY hits DESC
</code>

===System wide use of ACTIVITIES and RESOURCES===
<code sql>
SELECT count( cm.id ) AS counter, m.name
FROM `prefix_course_modules` AS cm
JOIN prefix_modules AS m ON cm.module = m.id
GROUP BY cm.module
ORDER BY counter DESC
</code>

===LOG file ACTIONS per MODULE per COURSE (IDs)===
<code sql>
select course,module,action,count(action) as summa from prefix_log
where action <> 'new'
group by course,action,module
order by course,module,action
</code>

==="Compose Web Page" RESOURCE count===
<code sql>
SELECT course,prefix_course.fullname, COUNT(*) AS Total
FROM `prefix_resource`
JOIN `prefix_course` ON prefix_course.id = prefix_resource.course
WHERE type='html'
GROUP BY course
</code>

===Total Activity of Roles:"Teacher" and "None-Editing Teacher" by Dates and by Hours===
The output columns of this report table can be used as base for a Pivot-Table
which will show the amount of '''activity''' per '''hour''' per '''days''' in 3D graph view.

<code sql>
SELECT DATE_FORMAT( FROM_UNIXTIME( l.time ) , '%Y/%m/%d' ) AS grptimed ,
DATE_FORMAT( FROM_UNIXTIME( l.time ) , '%k' ) AS grptimeh , count( l.userid ) AS counter
FROM `prefix_log` AS l
JOIN prefix_user AS u ON u.id = l.userid
JOIN prefix_role_assignments AS ra ON l.userid = ra.userid
JOIN prefix_role AS r ON r.id = ra.roleid
WHERE ra.roleid IN (3,4)
GROUP BY grptimed,grptimeh
ORDER BY grptimed,grptimeh
</code>

===FORUM use Count per COURSE -- not including NEWS Forum!===
<code sql>
SELECT prefix_course.fullname, prefix_forum.course, count(*) as total FROM prefix_forum
INNER JOIN prefix_course
ON prefix_course.id = prefix_forum.course
WHERE NOT(prefix_forum.type = 'news')
GROUP BY prefix_forum.course
ORDER BY total desc
</code>

===FORUM use Count per COURSE by type -- not including NEWS Forum!===
<code sql>
SELECT prefix_course.fullname, prefix_forum.course, prefix_forum.type, count(*) as total FROM prefix_forum
INNER JOIN prefix_course
ON prefix_course.id = prefix_forum.course
WHERE NOT(prefix_forum.type = 'news')
GROUP BY prefix_forum.course,prefix_forum.type
ORDER BY total desc
</code>

===LIST of all site USERS by COURSE enrollment (Moodle 1.9.x)===

Reports a site global list of all users enroled in each course
<code sql>
SELECT
user.firstname AS Firstname,
user.lastname AS Lastname,
user.email AS Email,
user.city AS City,
course.fullname AS Course
,(SELECT name FROM prefix_role WHERE id=asg.roleid)
FROM
prefix_user AS user,
prefix_course AS course,
prefix_role_assignments AS asg
INNER JOIN prefix_context AS context ON asg.contextid=context.id
WHERE
context.contextlevel = 50
AND
user.id=asg.userid
AND
context.instanceid=course.id
</code>

===LIST of all site USERS by COURSE enrollment (Moodle 2.x)===

<code sql>
SELECT
user2.firstname AS Firstname,
user2.lastname AS Lastname,
user2.email AS Email,
user2.city AS City,
course.fullname AS Course
,(SELECT shortname FROM prefix_role WHERE id=en.roleid) as Role
,(SELECT name FROM prefix_role WHERE id=en.roleid) as RoleName

FROM prefix_course as course
JOIN prefix_enrol AS en ON en.courseid = course.id
JOIN prefix_user_enrolments AS ue ON ue.enrolid = en.id
JOIN prefix_user AS user2 ON ue.userid = user2.id
</code>

===Permissions Overides on Categories===
(By: [http://moodle.org/mod/forum/discuss.php?d=153059#p712834 Séverin Terrier] )
<code sql>
SELECT rc.id, ct.instanceid, ccat.name, rc.roleid, rc.capability, rc.permission,
DATE_FORMAT( FROM_UNIXTIME( rc.timemodified ) , '%Y-%m-%d' ) AS timemodified, rc.modifierid, ct.instanceid, ct.path, ct.depth
FROM `prefix_role_capabilities` AS rc
INNER JOIN `prefix_context` AS ct ON rc.contextid = ct.id
INNER JOIN `prefix_course_categories` AS ccat ON ccat.id = ct.instanceid
AND `contextlevel` =40
</code>

===Lists "Totally Opened Courses" (visible, opened to guests, with no password)===
(By: [http://moodle.org/mod/forum/discuss.php?d=153059#p712837 Séverin Terrier] )
<code sql>
SELECT id , category , fullname , shortname , enrollable
FROM `prefix_course`
WHERE `guest` =1
AND `password` = ""
AND `visible` =1
</code>

===Lists "loggedin users" from the last 120 days===
<code sql>
SELECT id,username,FROM_UNIXTIME(`lastlogin`) as days
FROM `mdl_user`
WHERE DATEDIFF( NOW(),FROM_UNIXTIME(`lastlogin`) ) < 120
</code>

''and user count for that same population:''
<code sql>
SELECT COUNT(id) as Users FROM `mdl_user`
WHERE DATEDIFF( NOW(),FROM_UNIXTIME(`lastlogin`) ) < 120
</code>

===List "Recently uploaded files"===
see what users are uploading
<code sql>
SELECT FROM_UNIXTIME(time,'%Y %M %D %h:%i:%s') as time ,ip,userid,url,info
FROM `prefix_log`
WHERE `action` LIKE 'upload'
ORDER BY `prefix_log`.`time` DESC
</code>

===List Courses that loaded a specific file: "X"===
Did the Teacher (probably) uploaded course's Syllabus ?
<code sql>
SELECT c.id, c.fullname FROM `prefix_log` as l
JOIN prefix_course as c ON c.id = l.course
WHERE `action` LIKE '%upload%' AND ( info LIKE '%Syllabus%' OR info LIKE '%Sylabus%' ) GROUP BY c.id
</code>

===Students in all courses of some institute===
What is the status (deleted or not) of all Students (roleid = 5) in all courses of some Institute
<code sql>
SELECT c.id, c.fullname, u.firstname, u.lastname, u.deleted
FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid =5
AND ctx.instanceid = c.id
AND u.institution = 'please enter school name here'
</code>

===Full User info (for deleted users)===
Including extra custom profile fields (from mdl_user_info_data)
<code sql>
SELECT *
FROM mdl_user as u
JOIN mdl_user_info_data as uid ON uid.userid = u.id
JOIN mdl_user_info_field as uif ON (uid.fieldid = uif.id AND uif.shortname = 'class')
WHERE `deleted` = "1" and `institution`="your school name" and `department` = "your department" and `data` = "class level and number"
</code>

===Activity In Forums===
Trying to figure out how much real activity we have in Forums by aggregating:
Users in Course, Number of Posts, Number of Discussions, Unique student post, Unique student discussions, Number of Teachers , Number of Students, ratio between unique Student posts and the number of students in the Course...
<code sql>
SELECT c.fullname,f.name,f.type
,(SELECT count(id) FROM prefix_forum_discussions as fd WHERE f.id = fd.forum) as Discussions
,(SELECT count(distinct fd.userid) FROM prefix_forum_discussions as fd WHERE fd.forum = f.id) as UniqueUsersDiscussions
,(SELECT count(fp.id) FROM prefix_forum_discussions fd JOIN prefix_forum_posts as fp ON fd.id = fp.discussion WHERE f.id = fd.forum) as Posts
,(SELECT count(distinct fp.userid) FROM prefix_forum_discussions fd JOIN prefix_forum_posts as fp ON fd.id = fp.discussion WHERE f.id = fd.forum) as UniqueUsersPosts
,(SELECT Count( ra.userid ) AS Students
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid =5
AND ctx.instanceid = c.id
) AS StudentsCount
,(SELECT Count( ra.userid ) AS Teachers
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid =3
AND ctx.instanceid = c.id
) AS 'Teacher Count'
,(SELECT Count( ra.userid ) AS Users
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid IN (3,5)
AND ctx.instanceid = c.id
) AS UserCount
, (SELECT (UniqueUsersDiscussions / StudentsCount )) as StudentDissUsage
, (SELECT (UniqueUsersPosts /StudentsCount)) as StudentPostUsage
FROM prefix_forum as f
JOIN prefix_course as c ON f.course = c.id
WHERE `type` != 'news'
ORDER BY StudentPostUsage DESC
</code>

===Blog activity per Course (not including VIEW)===
Filter activity logging to some specific Course Categories!
+ link course name to actual course (for quick reference)
(you can change %blog% to %wiki% to filter down all wiki activity or any other module you wish)
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',cm.course,'">',c.fullname,'</a>') as CourseID
,m.name ,count(cm.id) as counter
,(SELECT Count( ra.userid ) AS Users
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5
AND ctx.instanceid = c.id
) AS Students
, ( SELECT count(id) FROM prefix_log WHERE `module` LIKE '%blog%' AND course = c.id AND action NOT LIKE '%view%' ) as BlogActivity
FROM `prefix_course_modules` as cm JOIN prefix_modules as m ON cm.module=m.id JOIN prefix_course as c ON cm.course = c.id
WHERE m.name LIKE '%blog%' AND c.category IN ( 8,13,15)
GROUP BY cm.course,cm.module order by counter desc
</code>

===Detailed WIKI activity (per wiki per course)===
Including Number of Students in course (for reference)
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',cm.course,'">',c.fullname,'</a>') as CourseID
,(SELECT Count( ra.userid ) AS Users
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5 AND ctx.instanceid = c.id ) AS Students
,m.name
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%updat%' ) as 'UPDAT E'
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%annotate%' ) as ANNOTATE
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%comment%' ) as COMMENT
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%add%' ) as 'A DD'
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%edit%' ) as EDIT
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action NOT LIKE '%view%' ) as 'All (NO View)'
FROM `prefix_course_modules` as cm
JOIN prefix_modules as m ON cm.module=m.id
JOIN prefix_course as c ON cm.course = c.id
WHERE m.name LIKE '%wiki%'
GROUP BY cm.course,cm.module
ORDER BY 'All (NO View)' DESC
</code>

===All Courses which uploaded a Syllabus file===
+ under specific Category
+ show first Teacher in that course
+ link Course's fullname to actual course
<code sql>
SELECT
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course
,c.shortname,r.name
,(SELECT CONCAT(u.firstname,' ', u.lastname) as Teacher
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
JOIN prefix_user as u ON u.id = ra.userid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) as Teacher
FROM prefix_resource as r
JOIN prefix_course as c ON r.course = c.id
WHERE ( r.name LIKE '%סילבוס%' OR r.name LIKE '%סילאבוס%' OR r.name LIKE '%syllabus%' OR r.name LIKE '%תכנית הקורס%' )
AND c.category IN (10,18,26,13,28)
</code>

===All resources that link to some specific external website===
+ link to course
+ who's the teacher
+ link to external resource
<code sql>
SELECT
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course
,c.shortname,r.name
,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher
,concat('<a target="_new" href="%%WWWROOT%%/mod/resource/view.php?id=',r.id,'">',r.name,'</a>') AS Resource
FROM prefix_resource AS r
JOIN prefix_course AS c ON r.course = c.id
WHERE r.reference LIKE 'http://info.oranim.ac.il/home%'
</code>

===How many LOGINs per user and user's Activity===
+ link username to a user activity graph report
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/user.php?id=1&user=',u.id,'&mode=alllogs">',u.firstname ,' ',u.lastname,'</a>') as Username
,count(*) as logins
,(SELECT count(*) FROM prefix_log WHERE userid = l.userid GROUP BY userid) as Activity
FROM prefix_log as l JOIN prefix_user as u ON l.userid = u.id
WHERE `action` LIKE '%login%' group by userid
ORDER BY Activity DESC
</code>

===User's courses===
change "u.id = 2" with a new user id
<code sql>
SELECT u.firstname, u.lastname, c.id, c.fullname
FROM mdl_course AS c
JOIN mdl_context AS ctx ON c.id = ctx.instanceid
JOIN mdl_role_assignments AS ra ON ra.contextid = ctx.id
JOIN mdl_user AS u ON u.id = ra.userid
WHERE u.id = 2
</code>

===All Forum type:NEWS===
<code sql>
SELECT f.id, f.name
FROM mdl_course_modules AS cm
JOIN mdl_modules AS m ON cm.module = m.id
JOIN mdl_forum AS f ON cm.instance = f.id
WHERE m.name = 'forum'
AND f.type = 'news'
</code>

===All new forum NEWS items (discussions) from all my Courses===
change "userid = 26" and "id = 26" to a new user id
<code sql>
SELECT c.shortname,f.name,fd.name,FROM_UNIXTIME(fd.timemodified ,"%d %M %Y ") as Date
FROM mdl_forum_discussions as fd
JOIN mdl_forum as f ON f.id = fd.forum
JOIN mdl_course as c ON c.id = f.course
JOIN mdl_user_lastaccess as ul ON (c.id = ul.courseid AND ul.userid = 26)
WHERE fd.timemodified > ul.timeaccess
AND fd.forum IN (SELECT f.id
FROM mdl_course_modules AS cm
JOIN mdl_modules AS m ON cm.module = m.id
JOIN mdl_forum AS f ON cm.instance = f.id
WHERE m.name = 'forum'
AND f.type = 'news')
AND c.id IN (SELECT c.id
FROM mdl_course AS c
JOIN mdl_context AS ctx ON c.id = ctx.instanceid
JOIN mdl_role_assignments AS ra ON ra.contextid = ctx.id
JOIN mdl_user AS u ON u.id = ra.userid
WHERE u.id = 26) ORDER BY `fd`.`timemodified` DESC
</code>

==Resource count in courses==
+ (First)Teacher name
+ Where course is inside some specific Categories
<code sql>
SELECT
COUNT(*) AS count
,r.course
,c.shortname shortname
,c.fullname coursename
,( SELECT DISTINCT CONCAT(u.firstname,' ',u.lastname)
FROM prefix_role_assignments AS ra
JOIN prefix_user as u ON ra.userid = u.id
JOIN prefix_context AS ctx ON ctx.id = ra.contextid
WHERE ra.roleid = 3 AND ctx.instanceid = r.course AND ctx.contextlevel = 50 LIMIT 1) AS Teacher
FROM prefix_resource r
JOIN prefix_course c ON r.course = c.id
WHERE c.category IN (10,13,28,18,26)
GROUP BY r.course
ORDER BY COUNT(*) DESC
</code>

==News Forum - Discussions COUNT==
Which is actually... How much instructions students get from their teachers
<code sql>
SELECT c.shortname ,
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course
,( SELECT DISTINCT CONCAT(u.firstname,' ',u.lastname)
FROM prefix_role_assignments AS ra
JOIN prefix_user AS u ON ra.userid = u.id
JOIN prefix_context AS ctx ON ctx.id = ra.contextid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id AND ctx.contextlevel = 50 LIMIT 1) AS Teacher
,concat('<a target="_new" href="%%WWWROOT%%/mod/forum/view.php?f=',fd.forum,'">',count(fd.id),'</a>') AS DiscussionsSum
FROM prefix_forum_discussions AS fd
INNER JOIN prefix_forum AS f ON f.id = fd.forum
INNER JOIN prefix_course AS c ON c.id = f.course
WHERE f.type = 'news' AND c.category IN (10,13,28,18,26)
GROUP BY fd.forum
ORDER BY count(fd.id) DESC
</code>

==Special Roles==
<code sql>
SELECT ra.roleid,r.name
,concat('<a target="_new" href="%%WWWROOT%%/course/user.php?id=1&user=',ra.userid,'">',u.firstname ,' ',u.lastname,'</a>') AS Username
,concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course
FROM prefix_role_assignments AS ra
JOIN prefix_role AS r ON r.id = ra.roleid
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_context AS ctx ON (ctx.id = ra.contextid AND ctx.contextlevel = 50)
JOIN prefix_course AS c ON ctx.instanceid = c.id
WHERE ra.roleid > 6
</code>

==Courses without Teachers==
Actually, shows the number of Teachers in a course.
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course
,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 3 AND ctx.instanceid = c.id) AS Teachers
FROM prefix_course AS c
ORDER BY Teachers ASC
</code>

==Site-Wide Grade Report with All Items==
Shows grades for all course items along with course totals for each student.
<code sql>
SELECT u.firstname AS 'First' , u.lastname AS 'Last', u.firstname + ' ' + u.lastname AS 'Display Name',
c.fullname AS 'Course',
cc.name AS 'Category',

CASE
WHEN gi.itemtype = 'course'
THEN c.fullname + ' Course Total'
ELSE gi.itemname
END AS 'Item Name',

ROUND(gg.finalgrade,2) AS Grade,
DATEADD(ss,gi.timemodified,'1970-01-01') AS Time

FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_grade_grades AS gg ON gg.userid = u.id
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid
JOIN prefix_course_categories as cc ON cc.id = c.category

WHERE gi.courseid = c.id
ORDER BY lastname
</code>
For MySQL users, you'll need to use the MySQL DATE_ADD function instead of DATEADD:
<code>
DATE_ADD('1970-01-01', INTERVAL gi.timemodified SECONDS) AS Time
</code>

==Site-Wide Grade Report with Just Course Totals==
A second site-wide grade report for all students that just shows course totals.
<code sql>
SELECT u.firstname AS 'First' , u.lastname AS 'Last', u.firstname + ' ' + u.lastname AS 'Display Name',
cc.name AS 'Category',
CASE
WHEN gi.itemtype = 'course'
THEN c.fullname + ' Course Total'
ELSE gi.itemname
END AS 'Item Name',

ROUND(gg.finalgrade,2) AS Grade,
DATEADD(ss,gi.timemodified,'1970-01-01') AS Time

FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_grade_grades AS gg ON gg.userid = u.id
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid
JOIN prefix_course_categories as cc ON cc.id = c.category

WHERE gi.courseid = c.id AND gi.itemtype = 'course'

ORDER BY lastname
</code>
For MySQL users, you'll need to use the MySQL DATE_ADD function instead of DATEADD:
<code>
DATE_ADD('1970-01-01', INTERVAL gi.timemodified SECONDS) AS Time
</code>
==All Ungraded Assignments==
Returns all the submitted assignments that still need grading
<code sql>
select
u.firstname AS "First",
u.lastname AS "Last",
c.fullname AS "Course",
a.name AS "Assignment"

from prefix_assignment_submissions as asb
join prefix_assignment as a ON a.id = asb.assignment
join prefix_user as u ON u.id = asb.userid
join prefix_course as c ON c.id = a.course
join prefix_course_modules as cm ON c.id = cm.course

where asb.grade < 0 and cm.instance = a.id
and cm.module = 1

order by c.fullname, a.name, u.lastname
</code>

==All Ungraded Assignments w/ Link==
Returns all the submitted assignments that still need grading, along with a link that goes directly to the submission to grade it. The links work if you view the report within Moodle.
<code sql>
select
u.firstname AS "First",
u.lastname AS "Last",
c.fullname AS "Course",
a.name AS "Assignment",

'<a href="http://education.varonis.com/mod/assignment/submissions.php' + char(63) +
+ 'id=' + cast(cm.id as varchar) + '&userid=' + cast(u.id as varchar)
+ '&mode=single&filter=0&offset=2">' + a.name + '</a>'
AS "Assignmentlink"

from prefix_assignment_submissions as asb
join prefix_assignment as a ON a.id = asb.assignment
join prefix_user as u ON u.id = asb.userid
join prefix_course as c ON c.id = a.course
join prefix_course_modules as cm ON c.id = cm.course

where asb.grade < 0 and cm.instance = a.id and cm.module = 1

order by c.fullname, a.name, u.lastname
</code>

==Wiki usage, system wide==
(you can filter the output by selecting some specific course categories : "WHERE c.category IN ( 8,13,15)")

<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%wiki%') AS Wikis

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%') AS 'WikiActivity ALL'

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%add%' ) AS 'WikiActivity ADD'

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%edit%' ) AS 'WikiActivity EDIT'

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%annotate%' ) AS 'WikiActivity ANNOTATE'

,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%comments%' ) AS 'WikiActivity Comments'

,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students

,(SELECT count(*) FROM prefix_ouwiki_pages as ouwp
JOIN prefix_ouwiki as ouw ON ouw.id = ouwp.subwikiid
WHERE ouw.course = c.id GROUP BY ouw.course ) as OUWikiPages

,(SELECT count( DISTINCT nwp.pagename ) FROM prefix_wiki_pages AS nwp
JOIN prefix_wiki AS nw ON nw.id = nwp.dfwiki WHERE nw.course = c.id ) As NWikiPages

FROM prefix_course AS c
WHERE c.category IN ( 8,13,15)
HAVING Wikis > 0
ORDER BY 'WikiActivity ALL' DESC
</code>

==Aggregated Teacher activity by "WEB2" Modules==
(Tested and works fine in Moodle 2.x)
The NV column shows activity without VIEW log activity
<code sql>
SELECT ra.userid, u.firstname,u.lastname
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%wiki%') AS Wiki
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%wiki%' AND l.action NOT LIKE '%view%') AS Wiki_NV
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%forum%') AS Forum
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%forum%' AND l.action NOT LIKE '%view%') AS Forum_NV
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%blog%') AS Blog
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%blog%' AND l.action NOT LIKE '%view%') AS Blog_NV
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%assignment%') AS Assignment
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%assignment%' AND l.action NOT LIKE '%view%') AS Assignment_NV
FROM prefix_role_assignments AS ra
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid = 3
GROUP BY ra.userid
</code>

==Courses that are defined as using GROUPs==
<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/group/index.php?id=',c.id,'">',c.fullname,'</a>') AS Course
FROM `prefix_course` AS c
WHERE groupmode > 0
</code>

==System Wide usage count of various course Activities==
(Tested and works fine in Moodle 2.x)
Like: Forum, Wiki, Blog, Assignment, Database,
#Within specific category
#Teacher name in course

<code sql>
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course

,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%wiki%') AS Wikis
,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%blog%') AS Blogs

,(SELECT count( m.name ) AS count FROM
prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%forum%') AS Forums

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%data%') AS Databses

,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm
JOIN prefix_modules AS m ON cm.module = m.id
WHERE cm.course = c.id AND m.name LIKE '%assignment%') AS Assignments

,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students

FROM prefix_course AS c
WHERE c.category IN ( 18)
ORDER BY Wikis DESC,Blogs DESC, Forums DESC
</code>

==List all the certificates issued, sort by variables in the custom profile fields==
Note: The SQL queries look intimidating at first, but isn't really that difficult to learn. I've seen in the forums that users wanted to do 'site-wide' groups in 1.9x. This is sort of the idea. It pulls all the certificates issued to all users sorted by the custom profile fields, which in my case is the Units or Depts (i.e. my site wide groups). Why certificates? I've explored with both grades and quizzes, the course admins are not really interested in the actual grades but whether the learner received a certificate (i.e. passed the course with x, y, z activities). It also saves me from creating groups and assigning them into the right groups. Even assigning in bulk is not efficient, since I have upward of 25 groups per course and constantly new learners enrolling in courses. The limitation is something to do with the server? as it only pull 5000 rows of data. If anyone figured out how to change this, please let me know. In the meantime, the work around is to pull only a few units/depts at a time to limit the number of rows. This is fine at the moment, since each course admin are only responsible for certain units/depts.

<code sql>
SELECT
DATE_FORMAT( FROM_UNIXTIME(prefix_certificate_issues.timecreated), '%Y/%m/%d' ) AS Date,
prefix_certificate_issues.classname AS Topic,
prefix_certificate.name AS Certificate,
prefix_certificate_issues.studentname as Name,
prefix_user_info_data.data AS Units

FROM
prefix_certificate_issues

INNER JOIN prefix_user_info_data
on prefix_certificate_issues.userid = prefix_user_info_data.userid

INNER JOIN prefix_certificate
on prefix_certificate_issues.certificateid = prefix_certificate.id

WHERE prefix_user_info_data.data='Unit 1'
OR prefix_user_info_data.data='Unit 2'
OR prefix_user_info_data.data='Unit 3'

ORDER BY Units, Name, Topic ASC
</code>
==List all Courses in and below a certain category==
Use this SQL code to retrieve all courses that exist in or under a set category.

$s should be the id of the category you want to know about...
<code sql>
SELECT prefix_course. * , prefix_course_categories. *
FROM prefix_course, prefix_course_categories
WHERE prefix_course.category = prefix_course_categories.id
AND (
prefix_course_categories.path LIKE '/$v/%'
OR prefix_course_categories.path LIKE '/$s'
)
</code>

Private files

2011-06-14T18:18:03Z

Jonwitts:

{{Working with files and folders}}
{{Repositories}}
'''Please refer to [[Page_notes#Private files|these notes]] before editing this page.'''

In Moodle 2.0 onwards, each user has a private files area for uploading and managing a set of files.

The private files area is accessible via ''Navigation > My home > My profile > My private files'' or the [[My private files block]]. It is available as a source within the filepicker when selecting files to use in a course.

==Private files management==

To add a file to your private files area
# On the Navigation menu, click My profile > My private files
# Click "Manage my private files" button
# The standard file picker Add-Create folder popup will appear.
# If desired, create or move to a folder,
#Click on the Add button
#Browse for and select a file
# Click the 'Save changes' button

[[Image:Files_standard_added_files_1.png|center|frame|Standard file add- create directory, showing 2 files]]
*Uploaded files may be downloaded, renamed, moved or deleted by clicking the icon next to the file. After making any changes, '''remember to click the 'Save changes' button'''.

[[Category:Repositories]]
[[Category:Moodle 2.0]][[Category:Files]]

[[eu:Fitxategi_pribatuak]]
[[fr:Fichiers personnels]]

Legacy course files

2011-06-14T18:17:23Z

Jonwitts:

{{Working with files and folders}}
{{Repositories}}
'''Please refer to [[Page_notes#Legacy course files|these notes]] before editing this page.'''
In Moodle 2.0 onwards, files are stored in separate areas, rather than together in the course files area. See [[Course files]] for a detailed explanation.

''Note: It is recommended that teachers make use of the new [[Repositories|repositories]] in Moodle 2.0 for storing course files, rather than saving them in a course files area''.

In Moodle 2.0 the course files area has been renamed 'Legacy course files'. By default, this area is not available in new courses.

==Enabling legacy course files areas==

To enable a legacy course files area in a new course

# Enable the legacy course files repository plugin in ''Administration > Plugins > Repositories > [[Manage repositories]]''.
# Check the legacyfilesinnewcourses box in the Manage repositories common settings then click the 'Save changes' button.
# Set 'Legacy course files' to Yes in the course settings.

A legacy course files link will then appear in the course administration block.

[[Category:Repositories]]

Antivirus plugins

2011-06-10T17:40:11Z

Jonwitts:

{{Security}}
'''Please refer to [[Page_notes#Anti-Virus |these notes]] before editing this page.'''
Location: ''Administration > Security > Anti-Virus''

To make use of Moodle's anti-virus feature, the open source virus scanner ClamAV should be installed on your server. See http://www.clamav.net for more information.

==See also==

* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=147820 ClamAV upgrade may be required] forum discussion

[[Category:Administrator]]
[[Category:Security]]

[[eu:Antibirusa]]
[[hu:Vírusölő]]
[[de:Anti-Virus]]

Database activity FAQ

2010-07-21T23:26:10Z

Jonwitts:

{{Database activity module}}
==Where can I download additional database presets?==

See [[Database presets]] for discussion links with presets for download.

==How can I create a database in which students can only view their own entries?==

Either:
*Set up the database so that entries require approval. If the entries are never approved, then only the student that added a particular entry and the teachers can view it.

Or:
*Set the group mode of the database to "Separate groups" and assign each student to a separate group.

==How can I enable a sort function by clicking on the field headings?==

For sorting, you need to manually create the link in the template around that heading. To find the URL you need, you can do a sort using the menus and then look in the URLs. Take out everything but the d, sort and order parameters. For example,

http://moodle.org/mod/data/view.php?d=13&sort=44&order=ASC

http://moodle.org/mod/data/view.php?d=13&sort=44&order=DESC

==How can I add highlighting like on the Module and plugins page?==

In the repeated part of the template (note onmouseover and onmouseout to change the classes):
<pre><tr onmouseover="this.className='trhighlight'" onmouseout="this.className='trnormal'">
<td class="c0"><a href="##MoreURL##">[[Name]]</a></td>
<td class="c1">[[Type]]</td>
<td class="c2">[[Requirement]]</td>
<td class="c3">[[Status]]</td>
<td class="c4">[[Summary]]</td>
<td align="center" class="c5">##Edit## ##Delete## ##More## ##Approve## </td>
</tr></pre>

In the CSS template there are two styles:

<pre>.trnormal td {
background-color: #FFFFFF;
}
.trhighlight td {
background-color: #EEEEEE;
}</pre>

==How can I list database information horizontally instead of vertically?==
*[http://moodle.org/mod/forum/discuss.php?d=74243 How can I list database information horizontally instead of vertically? Forum discussion]

==Can't get columns to line up in list view==
*[http://moodle.org/mod/forum/discuss.php?d=84050 Can't get columns to line up in list view forum discussion] including moodle.org presets for download

==How can I make an Encyclopedia database preset?==
*[http://moodle.org/mod/forum/discuss.php?d=87560 Encyclopedia database preset forum discussion] including encyclopedia-style preset for download

==Is there a Time stamp for database entries?==
*[http://moodle.org/mod/forum/discuss.php?d=86927 Time stamp for database entries forum discussion]

==How can I make the title of an entry into a link?==

To make the title of an entry in list view link to the single view, add the following code to the list template:

<nowiki><a href="##moreurl##">[[Title]]</a></nowiki>

==How can I make email addresses clickable?==

To make email addresses clickable, add the following code to the single template:

<nowiki><a href="mailto:[[Email]]">[[Email]]</a></nowiki>

where 'Email' is the text field for inputting email addresses.

==How can I delete a file attached to a database entry?==

There is currently no user interface for deleting a file attached to a database entry, however a workaround would be to delete the entry completely and then create a new entry without the file attached.

==How can I hide a database entry which was previously approved?==

There is currently no user interface for hiding a database entry which was previously approved i.e. setting it to require approval again. However, an entry can be hidden using [[MySQL Admin]] by editing it in the ''data_records'' table and changing the approved value from 1 to 0.

==How can I add a default sort order of entries?==

In the Fields tab, select a default sort field, choose ascending or descending then click the Save button.

==Why is my database so slow to show each page?==

Try to go to "Administration > Miscellaneous > XMLDB editor" and choose "Check Indexes". If you have any missing indexes found; upgrade your Moodle to the latest weekly build of your version; re-run the test; backup your site database and then run the suggested SQL from the test on your site database. This should speed up your database activity load times.

==See also==
Using Moodle forum discussions:

*[http://moodle.org/mod/forum/discuss.php?d=87005 New preset, please review, and make suggestions!] including FAQ preset for download
*[http://moodle.org/mod/forum/discuss.php?d=88727 Design a Database Preset for Document Sharing] including preset for download
*[http://moodle.org/mod/forum/discuss.php?d=55338 Look of the database module]
*[http://moodle.org/mod/forum/discuss.php?d=61179 For those who want the display of Moodle Site's Modules and plugins]
*[http://moodle.org/mod/forum/discuss.php?d=94854#p457252 Looking for some stellar examples of Moodle courses] including book reviews preset for download

[[Category:FAQ]]

[[de:Datenbank FAQ]]

PHP settings by Moodle version

2010-07-18T07:31:28Z

Jonwitts: /* PHP Settings */

{{stub}}
and
{{Review}}{{Template:Installing Moodle}}
==PHP Version==
Moodle has different PHP requirements for different versions:
* Moodle 2.0 will require PHP 5.2.8 or later.
* Moodle 1.6 to 1.9 requires PHP 4.3.0 or later
* Moodle 1.0 to 1.5 requires PHP 4.1.0 or later
==PHP Settings==
Check these settings in your php.ini or .htaccess file (if you're using Apache). For settings which use ON/OFF as their values, you can substitute 1 for ON and 0 for OFF if you prefer.
* ''register_globals'' '''MUST''' be OFF
* ''safe_mode'' needs to be OFF.
* ''memory_limit'' should be at least 16M (32M is recommended for Moodle 1.7 and 40M for Moodle 1.8 or later). Large sites may need more than 128M. PHP 5.2.x requires higher memory_limit values than previous versions of PHP. 64bit operating systems require even more memory.
* ''session.save_handler'' needs to be set to FILES.
* ''magic_quotes_gpc'' should be OFF. (It will be an installation pre-requisite for this to be turned off from 2.0 onwards.)
* ''magic_quotes_runtime'' needs to be OFF.
* ''file_uploads'' needs to be ON.
* ''session.auto_start'' needs to be OFF.
* ''session.bug_compat_warn'' needs to be OFF.
* For file uploads in Moodle 2 on a Windows install, the temp folder must be defined and writeable by your webserver user

==PHP Extensions and libraries==
* The mbstring extension is recommended for Moodle 1.6 or later.
* The iconv extension is recommended for Moodle 1.6 or later.
* [http://www.libgd.org/ GD library] and the [http://www.freetype.org/ FreeType 2] library and extensions are needed to be able to look at the dynamic graphs that the logs pages make. (Freetype support is available as part of the GD extension for the 5.x versions of PHP)
* The mysql extension is required if you are using the MySQL database. Note that in some Linux distributions (notably Red Hat) this is an optional installation.
* The pgsql extension is required if you are using the PostgreSQL database.
* The zlib extension is required for zip/unzip functionality.
* The pdo and pdo_sqlite extensions are required for the (experimental) SQLite 3 database support.
* The tokenizer extension is recommended for Moodle 1.8 or later (enabled by default as of [http://www.php.net/manual/en/tokenizer.installation.php PHP 4.3.0]).
* The curl and openssl extensions are required for the Moodle network functionality (Moodle 1.8 or later).
* The xmlrpc extension is required for the Moodle network functionality (Moodle 1.8 or later).
* The ctype extension is recommended for Moodle 1.8 or later (enabled by default as of [http://www.php.net/manual/en/ctype.installation.php PHP 4.2.0]).
* Other PHP extensions may be required to support optional Moodle functionality, especially external authentication and/or enrolment (e.g. LDAP extension for LDAP authentication and the sockets extension for Chat server).
==Database Support==
A working database server: [[MySQL]] or [[PostgreSQL]] are completely supported and recommended for use with any version of Moodle. Support for Microsoft SQL Server and Oracle has been added in Moodle 1.7. MySQL is ''the'' choice for many people because it is very popular, but there are some [[Arguments in favour of PostgreSQL|arguments in favour of PostgreSQL]], especially if you are planning a large deployment.
* For Moodle 1.5, MySQL (version 3.23 or later) or PostgreSQL (7.4 or later).
* For Moodle 1.6, MySQL (version 4.1.12 or later) or PostgreSQL (7.4 or later).
* For Moodle 1.7, MySQL (version 4.1.12 or later), PostgreSQL (7.4 or later) or Microsoft SQL Server 2005 (version 9 or [http://moodle.org/mod/forum/discuss.php?d=59284 SQL Server Express 2005])
* For Moodle 1.8 or later, MySQL (version 4.1.12 or later), PostgreSQL (8.0 or later) or Microsoft SQL Server 2005 (version 9 or [http://moodle.org/mod/forum/discuss.php?d=59284 SQL Server Express 2005])
: MySQL Notes: For Moodle 1.6 or later, If you use latin languages only you can use MySQL 4.1.12. If you are using non-latin languages you require MySQL 4.1.16 or later. Currently the MySQL setting "strict mode" must be OFF (set to "" or "MYSQL40") in the MySQL configuration file.
: PostgreSQL Notes: PostgreSQL 7.4 is recommended for earlier Moodle versions, since Moodle 1.8 only PostgreSQL 8.0 and above are supported.
* For showcases or low to medium-sized installations, Moodle 2.0 also includes (experimental) support for SQLite 3 database. This setup requires no database server, as the database file is stored in a local directory on the server.

==See also==
*[[Installing Moodle]]
*[[Performance]]

[[de:PHP-Versionen für Moodle]]
[[ru:Настройки PHP для разных версий Moodle]]

User:Jon Witts/Biography

2010-07-11T19:14:24Z

Jonwitts: /* Education History */

=Jon Witts Biography=
==Work History==
*2007 - Current : Director of ICT at South Hunsley School
*2004 - 2007 : Learning Resource Centre Manager at South Hunsley School
*2003 - 2004 : Ran my own Cyber Café and IT consultancy Company
*2002 - 2003 : Audio Visual and IT Technician at Hull Time Based Arts
*2001 - 2002 : Administrative Assistant at Hull Time Based Arts

==Education History==

*2005 - 2008 : Foundation Degree, Design and Development of e-Learning, University of Huddersfield
*1997 - 2000 : BA Hons , Fine Art - Time Based Media, University of Humberside and Lincolnshire
*1996 - 1997 : BTEC, Fine Art Foundation, Barnfield College
*1994 - 1996 : A Level, Art, Maths and Physics, Luton Sixth Form College

User:Jon Witts/Biography

2010-07-11T19:10:47Z

Jonwitts: /* Work History */

User:Jon Witts

2010-07-11T19:09:19Z

Jonwitts:

I work at a secondary school in the East Riding of Yorkshire in England as the Director of ICT.

I like to help out in the forums if I can...

I have just started to try and focus more of Moodle time on the docs. Hopefully some of the edits I make and pages I create will help those starting out with Moodle.

Here are links to my User area sub-pages...

*[[user:Jon_Witts/Biography]]
*[[User:Jon_Witts/moodle_via_apt_get]]
*[[User:Jon_Witts/file-upload-v2]]

User:Jon Witts

2010-06-30T20:08:14Z

Jonwitts:

I work at a secondary school in the East Riding of Yorkshire in England as the Director of ICT.

I like to help out in the forums if I can...

I have just started to try and focus more of Moodle time on the docs. Hopefully some of the edits I make and pages I create will help those starting out with Moodle.

[[user:Jon_Witts/Biography]]

[[User:Jon_Witts/moodle_via_apt_get]]

User:Jon Witts

2010-06-30T20:08:01Z

Jonwitts:

I work at a secondary school in the East Riding of Yorkshire in England as the Director of ICT.

I like to help out in the forums if I can...

I have just started to try and focus more of Moodle time on the docs. Hopefully some of the edits I make and pages I create will help those starting out with Moodle.

[[user:Jon_Witts/Biography]]
[[User:Jon_Witts/moodle_via_apt_get]]

User:Jon Witts/moodle via apt get

2010-06-30T20:07:24Z

Jonwitts: New page: =Install Moodle via apt get package on Ubuntu and Debian= So this to try and tidy up the apt-get install docs which are in a bit of disarray at the moment... *Ubuntu and Debain both use t...

=Install Moodle via apt get package on Ubuntu and Debian=
So this to try and tidy up the apt-get install docs which are in a bit of disarray at the moment...

*Ubuntu and Debain both use the same package manager that uses deb packages to allow you to install software and know that all of the dependencies will be automatically met and resolved for you by the operating system. Packages are also updated automatically as new versions are maintained in the package repositories.
*There is a deb package for Moodle maintained by ???. Whilst it will not be the latest version of Moodle; it should make installation on a Debian or Ubuntu server very easy.
==Install your server==
Download either the latest Ubuntu server disc (10.04 as this written) or the latest Debian disc (5.0 as writing) and follow the documentation on either site to install an basic server install with no packages installed (also known as the base system).
==Update your server==
Once your server is installed, make sure it is fully up to date.
sudo apt-get update
sudo apt-get dist-upgrade
At this point it is probably wise to reboot your server
==Set Static IP==
You are probably going to want your server running on a static IP.
*Edit /etc/networking/interfaces to set your static IP
*Restart your networking: sudo /etc/init.d/networking restart
*Check it works; can you ping another server? www.google.com for example?
==Install Moodle==

Wiki settings

2010-06-28T17:44:48Z

Jonwitts: Undo revision 73407 by Sadak0304025 (Talk)

{{Wiki}}
The standard Moodle wiki has different settings. Please note that these instructions are located in docs.moodle.org's documentation wiki.

==Adding a wiki==
[[Image:Wiki settting screen.JPG|thumb|Adding a new wiki in Moodle 1.7]]
To create a wiki:
#Click the "Turn editing on" button.
#Select Wiki from the "Add an activity" dropdown menu in the course section where you would like to add the wiki.
#On the Adding a new wiki page, give the wiki a descriptive name.
#In the summary field, describe the purpose of the wiki and what you expect students to contribute.
#Select the wiki type - groups, student or teacher. The wiki type interacts with the groups setting for your course, resulting in 9 options, as shown in the [http://moodle.org/help.php?module=wiki&file=wikitype.html&lang=en type help pop-up].
#Click the "Show Advanced" button (in Moodle 1.8 onwards) to display additional options (see below).
#Select the common module settings (see below).
#Click the "Save changes" button.

== Adding and editing wiki pages ==

After you've created a wiki, it's available for editing. [[Viewing a wiki]] contains information on adding and editing wiki pages.

==Advanced options==

===Print wiki name of every page===
If you select this option, the top of each page will have the name of the wiki.

===HTML mode===
There are three options: No HTML, safe HTML or HTML only. 'No HTML' will display all HTML tags as tags. 'Safe HTML' will allow certain tags to be displayed. 'HTML only' enables the [[HTML editor]] to display in [[Common_acronyms#N_to_Z|WYSIWYG]].

===Allow binary files===
Binary files are graphics, audio, video, and other non-text resources. If you want students to be able to add files as attachments, set this to Yes.

===Wiki auto-linking options===
A new page can be created in the wiki by typing a word using CamelCase i.e. with a capital letter at the beginning and a capital letter somewhere else in the word. It's called CamelCase because the two capital letters resemble a two-humped camel. CamelCase combines all the words for the link into one word. Each word in the link is capitalized. When a word is added in CamelCase, the wiki automatically creates a new page and makes the word a link. You can disable this feature if you wish, so that typing a word enclosed in square brackets is the only way of creating a new page.

CamelCase is not always desirable, as some text is written in it. For example a file name might be MyFile_2007_Feb.jpg.

===Student admin options===
When students can edit a page, you can allow them certain administrative privileges in the wiki (see [[Wiki administration]]).

===Page name===
You may wish to seed the wiki with a page name for the first page.

===Choose an initial page===
This can be the first wiki page that is created, or a way to switch to a different front page. Other files in the same directory as the first wiki page you select will also become part of the initial wiki - see:
http://moodle.org/mod/forum/discuss.php?d=8501

==Common module settings==
The [[Common module settings]] section appears in many modules besides wiki. It sets [[Groups]] interactions levels and the ID number.

==Creating a Wiki with Groups (Step by Step Instructions)==
Create a Wiki with Groups Tutorial (Subject: American War Battles)

'''Create Groups'''

1. On the course page select “Groups” under “Administration”.

2. On the groups page click the “Create group” button.

3. Fill in the following info for this group:

- Group name: civil
- Group description: Civil War Battles Group Project
- Enrollment key: civil

4. Click the "Save changes" button.

5. On the group page, make sure the ''civil'' group is selected and click the “Add/remove users” button.

6. Add users to the ''civil'' group (move them from the right box to the left box by clicking the “Add” button). When finished, click the “Back to groups” button.

7. Repeat steps 2-6 to create three additional groups (vietnam, world1, world2). Make sure to make the appropriate changes to Group name, Group description, and Enrollment key.

8. Return to course page.

'''Create the Wiki'''

1. Turn editing on.

2. Click the drop-down menu for “Add an Activity”. Select “Wiki”.

3. On the “Add a Wiki” page fill in the following:

- Name: American War Battles
- Summary: American War Battles Group Project
- Type: Groups
- Print Wiki name on every page: Yes (optional)
- HTML mode: HTML only
- Allow Binary Files: Yes
- Disable CamelCase linking: Yes
- Group Mode: Visible Groups
- Visible: Show
- Grade Category: Uncategorized

4. Click the “Save and return to course” button.

5. On the course page click on the Wiki link.

6. This is where you need to stop for a moment and get yourself oriented. Most likely you are on the “Groups wiki for civil” page in the “American War Battles" Wiki since this was the first group you created (this will be shown on the top-left of the page). If so, you are ready to begin created your Civil War page Wiki. If you would prefer to start with another war, simply click the drop-down on the top-right of the page labeled “Other Wikis:” and choose the wiki group you want to start with.

7. On the lower portion of the page you should see a bold header: '''Edit this page ‘American War Battles’'''. (I chose to start with the civil group so I will begin editing for the Civil War). Type the following:

[The Battle of Shiloh]

[The Battle of Gettysburg]

[The Battle of New Orleans]

8. Click the “Save” button

9. On the top-right of the page choose the world1 group from the drop-down menu.

10. Repeat steps 7-8 but replace the battles with battles from World War I.

11. On the top-right of the page choose the world2 group from the drop-down menu.

12. Repeat steps 7-8 but replace the battles with battles from World War II.

13. On the top-right of the page choose the vietnam group from the drop-down menu.

14. Repeat steps 7-8 but replace the battles with battles from the Vietnam War.

15. Now the Wiki is ready for students to work in!

'''Student Access to Wiki'''

1. Go to course page.

2. Click on the “American War Battles” Wiki.

3. Select your group from the top-right drop-down menu.

4. Use the Enrollment key that was given to you by your teacher.

5. Click the ? to the right of the battle you want to begin working on.

6. Get to work!

7. Note: Students will only be able to edit within their group. Because the Group Mode was set to “Visible Groups” by the teacher, students will be able to view every groups work but will only be able to edit their own.

==See also==

*[[Wiki permissions]]

[[Category:Wiki]]

[[fr:Ajouter/modifier un wiki]]
[[de:Wiki anlegen]]
[[ja:Wikiを追加/編集する]]