UQM is currently in development and in beta testing for phpBB3. More information and progress can be found here and here.atomjani wrote:I would see this mod for phpBB3.
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.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
Users browsing this forum: No registered users and 16 guests