View: a new block

View: a new block

by Olivier CATTEAU -
Number of replies: 7
Hi everybody,
here is a new block.
When you have many courses in your moodle server, you are very annoyed to create the course categories to fit the needs of the whole variety of moodle users.
With this block, each user can choose the “view” that best fits his needs.
Each course creator or administrator can create a “view”.
Enjoy it.
Best regards.
Average of ratings: -
In reply to Olivier CATTEAU

Re: View: a new block

by frank weissman -
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND u.deleted = 0' at line 1

SELECT u.id, u.username, u.firstname, u.lastname, u.email, u.city, u.country, u.picture, u.lang, u.timezone, u.emailstop, u.maildisplay, s.timeaccess AS lastaccess FROM mdl_user u LEFT JOIN mdl_user_students s ON s.userid = u.id WHERE s.course = AND u.deleted = 0;

.... So please tell me if it is to be used in 1.53+

Frank

In reply to frank weissman

Re: View: a new block

by Olivier CATTEAU -

Hi Frank,
Ive installed the block view in a clean Moodle 1.5.2+ server.
Ive extracted the block_view.zip archive in the root moodle directory.
Check if these files are created in your root moodle directory:
blocks/view/*
blocks/view/db/*
lang/en/block_view.php
lang/fr/block_view.php

Then login as admin, and go to the admin page:
http://moodle_server/admin/

And then the installation succeeded.

However, I didnt find you SQL request in the block code. The problem cause may be elsewhere

Best regards.

Attachment ViewBlockSucceeded.jpg
In reply to Olivier CATTEAU

Re: View: a new block

by Olivier CATTEAU -

With the block “view”, each course creator can easily create a view framework.
Here is an example.

Attachment ViewBlockFramework.jpg
In reply to Olivier CATTEAU

Re: View: a new block

by Olivier CATTEAU -

The course creator can also easily define the view content from existing courses.
He can reorder the courses list just by drag and drop.

Attachment ViewBlockContent.jpg
In reply to Olivier CATTEAU

Re: View: a new block

by Olivier CATTEAU -

The best place for the view block is on your moodle server home page.

Cheers.

Attachment ViewBlock.jpg