That's what I'm usingb1g3r wrote:Does anyone tried Ulimate Quiz to install in phpbb 2.0.22
Was the install succesfull in 2.0.22
Thanks.
That's what I'm usingb1g3r wrote:Does anyone tried Ulimate Quiz to install in phpbb 2.0.22
Was the install succesfull in 2.0.22
Thanks.
http://wwd-games.com - the quiz is Usless FACTS Trivia at http://wwd-games.com/quiz.phpb1g3r wrote:Cherry thanks for your reply.
Can you paste me your forum in pm or right here so i could see it.
Thank You.
Code: Select all
require($phpbb_root_path . 'includes/functions_quiz.' . $phpEx);
Code: Select all
include($phpbb_root_path . 'common.'.$phpEx);
Code: Select all
CREATE TABLE phpbb_quiz_statistics ( `stats_id` int(5) NOT NULL default '', `quiz_id` int(10) NOT NULL default '', `user_id` int(10) NOT NULL default '', `stats_correct` INT(5) NOT NULL default '0', `stats_incorrect` INT(5) NOT NULL default '0', `stats_percentage` INT(3) NOT NULL default '0');
Code: Select all
DEBUG MODE
SQL Error : 1146 Table 'cinologia.phpbb_quiz_statistics' doesn't exist
SELECT * FROM phpbb_quiz_statistics ORDER BY stats_percentage DESC LIMIT 10
Line : 135
File : quiz_stats.php
Code: Select all
CREATE TABLE phpbb_quiz_statistics(
`stats_id` int( 5 ) NOT NULL default '',
`quiz_id` int( 10 ) NOT NULL default '',
`user_id` int( 10 ) NOT NULL default '',
`stats_correct` INT( 5 ) NOT NULL default '0',
`stats_incorrect` INT( 5 ) NOT NULL default '0',
`stats_percentage` INT( 3 ) NOT NULL default '0'
)
Messaggio di MySQL:
#1067 - Invalid default value for 'stats_id'
Code: Select all
Query 17 did not execute correctly
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE config_name = 'Quiz_Cash_Currency'' at line 1
UPDATE phpbb_config SET config_value = WHERE config_name = 'Quiz_Cash_Currency'
Line : 84
File : admin_quiz.php
Code: Select all
ORDER BY category_name ASC
The timer is in the newest version from what I've read on the developers site.quahappy wrote:Not sure if someone may have already suggested this plus I've only been looking through all the install and included files for the Ultimate Quiz MOD and can't find anything to suggest what I'm about to ask:
Do quizzes in this MOD have a timer (or is it possible?) so that Members have a certain length of time to answer all questions which prevents Searching (ie, Google) being used and getting every question right just to attain best results (statistics)? Yes, I know this is called "cheating" but I'm certain if some sort of timer was used (customisable according to Quiz type) then it adds tension and more accurate and fairer results heh heh. Results for members could be time taken and correct answers. Just a thought.