Posts made by Martin Dougiamas

Moodle in English -> Installing and upgrading help -> After upgrading to 1.0.8 no admin in the bottom left corner -> Re: After upgrading to 1.0.8 no admin in the bottom left corner

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
I fixed Hans' server the other day. Something had gone wrong during the upgrade (I don't think it was due to Moodle) and the database fields hadn't been renamed, hence admin status wasn't being determined. Easily fixed by renaming the user fields (to userid) in user_* databases.
Average of ratings: -

Moodle in English -> Installing and upgrading help -> How to install 1.0.8.1? -> Tar, gz and archive formats

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
Yes, this is how it's meant to be. The gz file is a compressed tar file.

.tgz is an abbreviation for .tar.gz

This is how you can uncompress the .tgz file in one step using Unix shell:

tar xvzf moodle-1.0.8.1.tgz

and it will all be unpacked into a "moodle" subdirectory.
Average of ratings: -

Moodle in English -> General plugins -> Is there an activity roadmap? -> Paging feature and SQL

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
That looks like old code. The user field for posts is now called userid, and there are no prefixes. 
 SELECT p . * , u.firstname, u.lastname, u.email, u.picture, u.id
as userid
FROM forum_discussions d, user u, forum_posts p
WHERE d.forum = '1' AND p.discussion = d.id AND p.parent = 0 AND p.userid = u.id
ORDER BY p.created DESC
LIMIT 0, 5
This code works OK for me.
Average of ratings: -

Moodle in English -> General help -> Display of dates -> Re: Fix for date-setting problem in assignments and quizzes

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
Yes that's right, assignment->timemodified is zero for offline assignments (students have never modified it). Zero is 1/1/1970 GMT on most computers.

You're right that this looks bad on the user activity table, so I've just added a small fix to mod/assignment/submissions.php to set the field to be the same as the first grading time.

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/moodle/moodle/mod/assignment/
Average of ratings: -