atomjani wrote:I would see this mod for phpBB3.
UQM is currently in development and in beta testing for phpBB3. More information and progress can be found
here and
here.
WDBMagic wrote:Have created a phpbb_quiz_statistics table that works.
Enclosed below - hope this helps somebody
CREATE TABLE phpbb_quiz_statistics(
`stats_id` int( 5 ) NOT NULL default '0',
`quiz_id` int( 10 ) NOT NULL default '0',
`user_id` int( 10 ) NOT NULL default '0',
`stats_correct` INT( 5 ) NOT NULL default '0',
`stats_incorrect` INT( 5 ) NOT NULL default '0',
`stats_percentage` INT( 3 ) NOT NULL default '0'
For whatever reason this worked if I inserted '0' into the default fields
The phpBB3 UQM database architecture can be found
here. Bearing in mind that it's still in it's early stages and therefore likely that this will not be the final SQL, especially for statistics.