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
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.