Thanks to penfold_99 from:

**penfold_99** · 20th January 2009, 10:04 PM

Originally Posted by Gatt

This was something out Deputy Head asked - on the STAFF timetables so they can click on the class code and get a list of the pupils in that class?

Not sure how feasable that would be...

Hi Gatt,

In the latest version of the module links the course name to the moodle course. I will upload this tomorrow when i get back into work.

For the course page there is a link in the top left hand corner for participants, this will list everyone on the course.

Also the updated version reduces the configuration burden for users, could you test and see if it works out of the box?

**Gatt** · 21st January 2009, 08:48 AM

Hi penfold - just test the new Mod - and its a hell of a lot easier! (though needed to change the block php file from :

PHP Code:

    $this->content->text = '<a target="_self" href="'.$blockwww.'/mod/simstimetable/view.php">My Timetable</a>';

to

PHP Code:

    $this->content->text = '<a target="_self" href="'.$blockwww.'/moodle/mod/simstimetable/view.php">My Timetable</a>';

to work with my site as I dont have moodle in my Root Directory..

Also, the Mod files - any chance you can put them into a sub-dir ease the deployment (eg Zip File/mod/simstimetable/files) - saves creating it on the Server..

**apeo** · 21st January 2009, 09:38 AM

Nice work mate and the code is alot tidier but the 2 week timetable wont work because of this bit:

PHP Code:

     $days = array('Mon' => 1, 'Tue' => 2, 'Wed' => 3, 'Thu' => 4, 'Fri' => 5,

                  '1Mon' => 1, '1Tue' => 2, '1Wed' => 3, '1Thu' => 4, '1Fri' => 5,

                  'Mon1' => 1, 'Tue1' => 2, 'Wed1' => 3, 'Thu1' => 4, 'Fri1' => 5,

                  '2Mon' => 1, '2Tue' => 2, '2Wed' => 3, '2Thu' => 4, '2Fri' => 5,

                  'Mon2' => 1, 'Tue2' => 2, 'Wed2' => 3, 'Thu2' => 4, 'Fri2' => 5);

What happens is that it only prints 2 tables with 1 filled and 1 blank i.e. week 1 table is filled and week 2 table is blank. The week 1 table is wrong because the above code will override week 2 timetable with week1. For example a student has maths in '1Mon 1' (week 1 monday period 1) and English in '2Mon 1' (week 2 monday period 1) so if you take the period out (ie 1Mon and 2Mon) and apply the array above both of em will end up with a value of 1. I should have mentioned that the kids have different timetables for each week.

I havent really looked it too closely just yet as im working on something else but when i get a chance i'll try and bash it to work.

**penfold_99** · 21st January 2009, 10:45 AM

Originally Posted by Gatt

Hi penfold - just test the new Mod - and its a hell of a lot easier! (though needed to change the block php file from :

PHP Code:

    $this->content->text = '<a target="_self" href="'.$blockwww.'/mod/simstimetable/view.php">My Timetable</a>';

to

PHP Code:

    $this->content->text = '<a target="_self" href="'.$blockwww.'/moodle/mod/simstimetable/view.php">My Timetable</a>';

to work with my site as I dont have moodle in my Root Directory..

Also, the Mod files - any chance you can put them into a sub-dir ease the deployment (eg Zip File/mod/simstimetable/files) - saves creating it on the Server..

Hi gatt,

thanks for testing, i will repackage for you.

I will try and find a way of getting the block link to work correctly.

**penfold_99** · 21st January 2009, 10:59 AM

Originally Posted by Gatt

Hi penfold - just test the new Mod - and its a hell of a lot easier! (though needed to change the block php file from :

PHP Code:

    $this->content->text = '<a target="_self" href="'.$blockwww.'/mod/simstimetable/view.php">My Timetable</a>';

to

PHP Code:

    $this->content->text = '<a target="_self" href="'.$blockwww.'/moodle/mod/simstimetable/view.php">My Timetable</a>';

to work with my site as I dont have moodle in my Root Directory..

Also, the Mod files - any chance you can put them into a sub-dir ease the deployment (eg Zip File/mod/simstimetable/files) - saves creating it on the Server..

Hi Gatt,

could you swap $blockwww to $CFG->wwwroot and see if that removes the need for /moodle?

**penfold_99** · 21st January 2009, 11:02 AM

Originally Posted by apeo

Nice work mate and the code is alot tidier but the 2 week timetable wont work because of this bit:

PHP Code:

     $days = array('Mon' => 1, 'Tue' => 2, 'Wed' => 3, 'Thu' => 4, 'Fri' => 5,

                  '1Mon' => 1, '1Tue' => 2, '1Wed' => 3, '1Thu' => 4, '1Fri' => 5,

                  'Mon1' => 1, 'Tue1' => 2, 'Wed1' => 3, 'Thu1' => 4, 'Fri1' => 5,

                  '2Mon' => 1, '2Tue' => 2, '2Wed' => 3, '2Thu' => 4, '2Fri' => 5,

                  'Mon2' => 1, 'Tue2' => 2, 'Wed2' => 3, 'Thu2' => 4, 'Fri2' => 5);

What happens is that it only prints 2 tables with 1 filled and 1 blank i.e. week 1 table is filled and week 2 table is blank. The week 1 table is wrong because the above code will override week 2 timetable with week1. For example a student has maths in '1Mon 1' (week 1 monday period 1) and English in '2Mon 1' (week 2 monday period 1) so if you take the period out (ie 1Mon and 2Mon) and apply the array above both of em will end up with a value of 1. I should have mentioned that the kids have different timetables for each week.

I havent really looked it too closely just yet as im working on something else but when i get a chance i'll try and bash it to work.

hi apeo,

that array is correct, the problem is do to will how i add lessons to the array before printing.

The timetables are printing out on top of each other i just need to add the correct off set.

**Gatt** · 21st January 2009, 11:07 AM

That worked a treat penfold!!

**penfold_99** · 21st January 2009, 11:33 AM

Hi Gatt, Apeo

I have updated to the latest version, if you could download and test i would be grateful.

The latest version includes the link to from the timetable to the course.

**Hightower** · 21st January 2009, 12:38 PM

Can anybody help me configure FreeTDS for Ubuntu 8.04LTS?

I've done a "sudo apt-get install freetds-dev" successfully but when editing /etc/freetds.conf I get a blank file - is this normal and do I have to populate it myself?

**Gatt** · 21st January 2009, 12:40 PM

Nice one - though in the block_simstimetable.php you need to change /mod/simstimetable/ to mod/simstimetable/

Sorry - meant to remove it myself in my previous quote..

For some reason if its there it ignores the $CFG->wwwroot entirely!!

**Gatt** · 21st January 2009, 12:44 PM

Originally Posted by Hightower

Can anybody help me configure FreeTDS for Ubuntu 8.04LTS?

I've done a "sudo apt-get install freetds-dev" successfully but when editing /etc/freetds.conf I get a blank file - is this normal and do I have to populate it myself?

Hmm this should have had some default content IIRC..

Mine is like so //

Code:

# $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $
#
# This file is installed by FreeTDS if no file by the same 
# name is found in the installation directory. 
#
# For information about the layout of this file and its settings, 
# see the freetds.conf manpage "man freetds.conf". 
# Global settings are overridden by those in a database
# server specific section
[global]
host = [sql server ip]\[sql server instance]
port = [port number for sql server]
client charset = UTF-8
tds version = 9.0
text size = 20971520
　
　
# A typical Sybase server
　
# A typical Microsoft server

the tds version needs to be set to your SQL Server version

9.0 is SQL 2005

**Hightower** · 21st January 2009, 12:44 PM

And also - I've set up two scheduled tasks on the server (as the documentation says)

SIMS2AD
SIMS2AD_access_manager

When they run I get the errors:

Code:

Script: D:\SIMS2AD\SIMS2AD.vbs
Line: 259
Char: 1
Error: Table does not exist.
Code: 80040E37
Source: Provider

and

Code:

Script: D:\SIMS2AD\SIMS2AD_access_manager.vbs
Line: 222
Char: 1
Error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Code: 80004005
Source: Microsoft OLE DB Provider for ODBS Drivers

Respectively.

I've tried to follow the instructions exactly as written in the documentation.

**Hightower** · 21st January 2009, 12:45 PM

Originally Posted by Gatt

Hmm this should have had some default content IIRC..

Mine is like so //

Code:

# $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $
#
# This file is installed by FreeTDS if no file by the same 
# name is found in the installation directory. 
#
# For information about the layout of this file and its settings, 
# see the freetds.conf manpage "man freetds.conf". 
# Global settings are overridden by those in a database
# server specific section
[global]
host = [sql server ip]\[sql server instance]
port = [port number for sql server]
client charset = UTF-8
tds version = 9.0
text size = 20971520
　
　
# A typical Sybase server
　
# A typical Microsoft server

the tds version needs to be set to your SQL Server version

9.0 is SQL 2005

Where is your freetds.conf stored? Is it /etc/freetds.conf?

**Gatt** · 21st January 2009, 12:47 PM

yeah - sometimes a blank file means the file isnt there..

might be worth doing

Code:

whereis freetds.conf

to find out if its been put somewhere else!

But IIRC it should default to /etc

**Hightower** · 21st January 2009, 12:50 PM

Originally Posted by Hightower

Where is your freetds.conf stored? Is it /etc/freetds.conf?

Never mind - found the location

Just the Scheduled tasks I'm having trouble with at the minute?

LinkBack

Thread Tools

Search Thread

Thanks to penfold_99 from:

Similar Threads

SIMS.Net & Timetable planning

SIMS Lesson Monitor Timetable Structure

Timetable T6 or Sims.net confused

Sims Timetable Front end

Moodle Blog Module SQL Injection Vulnerability - Heads Up

Thread Information

Users Browsing this Thread

Posting Permissions