Gatt (21st January 2009)
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)
Hi penfold - just test the new Mod - and its a hell of a lot easier! (though needed to change the block php file from :
$this->content->text = '<a target="_self" href="'.$blockwww.'/mod/simstimetable/view.php">My Timetable</a>';
to work with my site as I dont have moodle in my Root Directory..PHP Code:
$this->content->text = '<a target="_self" href="'.$blockwww.'/moodle/mod/simstimetable/view.php">My Timetable</a>';
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..
Last edited by Gatt; 21st January 2009 at 07:51 AM.
Nice work mate and the code is alot tidier but the 2 week timetable wont work because of this bit:
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.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);
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.
That worked a treat penfold!!
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.
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?
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!!
Mine is like so //
the tds version needs to be set to your SQL Server versionCode:# $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
9.0 is SQL 2005
And also - I've set up two scheduled tasks on the server (as the documentation says)
When they run I get the errors:
andCode:Script: D:\SIMS2AD\SIMS2AD.vbs Line: 259 Char: 1 Error: Table does not exist. Code: 80040E37 Source: Provider
Respectively.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
I've tried to follow the instructions exactly as written in the documentation.
yeah - sometimes a blank file means the file isnt there..
might be worth doingto find out if its been put somewhere else!Code:whereis freetds.conf
But IIRC it should default to /etc
There are currently 1 users browsing this thread. (0 members and 1 guests)