Flash Activity Records

Sorry, there was a problem setting up the FlashMod database table. Please click on REFRESH to try again. If this isn't successful you may have to create the table manually in phpMyAdmin. Here is the database SQL query:

CREATE TABLE `YOUR-MOODLE-DB-NAME`.`flashmod_results` (

`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT( 11 ) NOT NULL ,
`username` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`courseid` INT( 11 ) NOT NULL ,
`coursename` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`swfname` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`xmlname` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
`timemodified` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`timeelapsed` INT( 11 ) NULL DEFAULT NULL ,
`grade` INT( 3 ) NULL DEFAULT NULL ,
`score1` INT( 30 ) NULL DEFAULT NULL ,
`score2` INT( 30 ) NULL DEFAULT NULL ,
`answer` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
`usertime` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL

) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT = 'Records Flash user interaction output data'

Congratulations! The FlashMod table mdl_flashmod_results was successfully created in the Moodle database.

VERY IMPORTANT: Please delete this PHP page from the server before you do anything else.

Flash Activities
Course: $flashmod_coursename
Student: $flashmod_studentname
Activity	Lesson	Time & Date		%	123	123	Answer
$flashmod_swfname	$flashmod_xmlname	$flashmod_usertime	$flashmod_timeelapsed_hms	$flashmod_grade	$flashmod_score1	$flashmod_score2	$flashmod_answer
$flashmod_swfname	$flashmod_xmlname	$flashmod_usertime	$flashmod_timeelapsed_hms	$flashmod_grade	$flashmod_score1	$flashmod_score2	$flashmod_answer
.

Totals
	$flashmod_total_timeelapsed
Average %:	$flashmod_average_grade
Total score 123:	$flashmod_total_score1
Total score 123:	$flashmod_total_score2