[2.0.19] Ultimate Quiz MOD

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
23
50%
Very Good
12
26%
Good
7
15%
Fair
3
7%
Poor
1
2%
 
Total votes: 46

macjob79
Registered User
Posts: 44
Joined: Wed Feb 14, 2007 2:16 pm

Re: [2.0.19] Ultimate Quiz MOD

Post by macjob79 » Fri Apr 20, 2007 8:42 pm

Jeez, I'm having a tough day with the quiz mod. Here's the newest problem for the upgrade to 1.3.3 (do you give support for that version here?)

I had version 1.2.0 (I believe) and it was great. I recently tried to do a fresh install of 1.3.3 and I got these error messages when running the install file from the root directory:

Image

Any help?

Noneya Beeswax
Registered User
Posts: 15
Joined: Thu May 03, 2007 7:54 pm

Re: [2.0.19] Ultimate Quiz MOD

Post by Noneya Beeswax » Thu May 10, 2007 8:25 pm

This is a great MOD, and I can see that the members can have a blast with it! I do have a couple of strange issues, that perhaps someone can help me with.

1. when I go to view "Who is Online" I get a very strange error message in the header.
Warning: Cannot modify header information - headers already sent by (output started at /home/chopp/public_html/viewonline.php:2) in /home/chopp/public_html/includes/page_header.php on line 545

Warning: Cannot modify header information - headers already sent by (output started at /home/chopp/public_html/viewonline.php:2) in /home/chopp/public_html/includes/page_header.php on line 547

Warning: Cannot modify header information - headers already sent by (output started at /home/chopp/public_html/viewonline.php:2) in /home/chopp/public_html/includes/page_header.php on line 548

2. When I make changes to the quiz Admin,I get an error code.

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

It seems to work, other than that, but only in the Subsilver template, and I get "Hacking attempt" when I do a quiz.

User avatar
crustybum
Registered User
Posts: 134
Joined: Thu Nov 10, 2005 2:09 pm
Contact:

Re: [2.0.19] Ultimate Quiz MOD

Post by crustybum » Mon Jun 18, 2007 4:46 pm

Tried installing this mod on 2 different forums using easymod and got this:

Critical Error

FIND FAILED: In file [includes/page_header.php] could not find:

'L_WHOSONLINE_MOD' => sprintf($lang['Mod_online_color'], '<span style="color:#' . $theme['fontcolor2'] . '">', '</span>'),

MOD script line #225 :: FAQ :: Report

Can anyone help?

Chris

User avatar
battye
Extension Customisations
Extension Customisations
Posts: 10814
Joined: Wed Feb 11, 2004 11:02 am
Location: Australia
Contact:

Re: [2.0.19] Ultimate Quiz MOD

Post by battye » Wed Jun 20, 2007 9:40 am

Try doing a manual search for:

Code: Select all

'L_WHOSONLINE_MOD' =>
It's possible the line has been edited, but that part should remain the same.
Customisations Team Member

kking183
Registered User
Posts: 45
Joined: Fri Jun 01, 2007 2:50 pm

Re: [2.0.19] Ultimate Quiz MOD

Post by kking183 » Mon Jul 02, 2007 10:37 am

how can i place the quiz icon above the main icon line instead of on the end of it

roopeshpdit
Registered User
Posts: 23
Joined: Mon Jul 09, 2007 6:49 pm

Re: [2.0.19] Ultimate Quiz MOD

Post by roopeshpdit » Mon Jul 09, 2007 6:52 pm

Code: Select all

CREATE TABLE phpbb_quiz ( `quiz_id` int(10) NOT NULL default '0', `quiz_name` varchar(200) NOT NULL default '', `quiz_author` int(10) NOT NULL default '0', `quiz_enabled` int(1) NOT NULL default '0', `quiz_category` int(5) NOT NULL default '0', `quiz_type` varchar(20) NOT NULL default '0', `quiz_plays` int(5) NOT NULL default '0');
CREATE TABLE phpbb_quiz_categories ( `category_id` int(5) NOT NULL default '0', `category_password` VARCHAR( 100 ) NOT NULL default '', `category_name` varchar(140) NOT NULL default '', `category_permissions` int(1) NOT NULL default '0', `category_description` varchar(255) NOT NULL default '');
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');
CREATE TABLE phpbb_quiz_multiple_choice_data ( `quiz_id` int(10) NOT NULL default '0', `question_id` int(10) NOT NULL default '0', `quiz_question` text NOT NULL, `quiz_alternates` text NOT NULL, `quiz_answer` text NOT NULL);
CREATE TABLE phpbb_quiz_true_false_data ( `quiz_id` int(10) NOT NULL default '0', `question_id` int(10) NOT NULL default '0', `quiz_question` text NOT NULL, `quiz_answer` text NOT NULL);
CREATE TABLE phpbb_quiz_input_data ( `quiz_id` int(10) NOT NULL default '0', `question_id` int(10) NOT NULL default '0', `quiz_question` text NOT NULL, `quiz_answer` text NOT NULL)
ALTER TABLE phpbb_sessions ADD `session_quiz_categories` VARCHAR( 255 ) NOT NULL;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_show_answers', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Register_Play', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Post_Count_Play', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Post_Requirement', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Play_Once', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Author_Play', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Min_Max_Questions', '5,10')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Author_Mod', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Banned', '')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Moderators', '')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Stats_Display', '10')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Mod_Submit', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Currency', 'user_points')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Incorrect', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Correct', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Tax', '2')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_CashMOD_On', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_packs_category', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_packs_bot', 'Quartz')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_timeout', '10')
is there a serious problem with this error method? please help me

roopeshpdit
Registered User
Posts: 23
Joined: Mon Jul 09, 2007 6:49 pm

Re: [2.0.19] Ultimate Quiz MOD

Post by roopeshpdit » Mon Jul 09, 2007 6:57 pm

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');

It is showing an error (red in colour) when i installed the quiz please let me know what is the problem?

roopeshpdit
Registered User
Posts: 23
Joined: Mon Jul 09, 2007 6:49 pm

Re: [2.0.19] Ultimate Quiz MOD

Post by roopeshpdit » Tue Jul 10, 2007 4:08 am

i hava a problem when i hit submit

Code: Select all

Unable to execute cash name query

DEBUG MODE

SQL Error : 1146 Table 'aboutqui_phpb1.CASH_TABLE' doesn't exist

SELECT cash_name FROM CASH_TABLE WHERE cash_dbfield = 'user_points'

Line : 959
File : quiz.php

roopeshpdit
Registered User
Posts: 23
Joined: Mon Jul 09, 2007 6:49 pm

Re: [2.0.19] Ultimate Quiz MOD

Post by roopeshpdit » Tue Jul 10, 2007 4:09 am

I also got two warning messages

Code: Select all

Warning: include(./includes/functions_cash.php) [function.include]: failed to open stream: No such file or directory in /home/aboutqui/public_html/quiz.php on line 952

Warning: include() [function.include]: Failed opening './includes/functions_cash.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/aboutqui/public_html/quiz.php on line 952

roopeshpdit
Registered User
Posts: 23
Joined: Mon Jul 09, 2007 6:49 pm

Re: [2.0.19] Ultimate Quiz MOD

Post by roopeshpdit » Tue Jul 10, 2007 4:09 am

I also got two warning messages

Code: Select all

Warning: include(./includes/functions_cash.php) [function.include]: failed to open stream: No such file or directory in /home/aboutqui/public_html/quiz.php on line 952

Warning: include() [function.include]: Failed opening './includes/functions_cash.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/aboutqui/public_html/quiz.php on line 952

roopeshpdit
Registered User
Posts: 23
Joined: Mon Jul 09, 2007 6:49 pm

Re: [2.0.19] Ultimate Quiz MOD

Post by roopeshpdit » Tue Jul 10, 2007 4:13 am

I also got two warning messages

Code: Select all

Warning: include(./includes/functions_cash.php) [function.include]: failed to open stream: No such file or directory in /home/aboutqui/public_html/quiz.php on line 952

Warning: include() [function.include]: Failed opening './includes/functions_cash.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/aboutqui/public_html/quiz.php on line 952

wildcatforums
Registered User
Posts: 56
Joined: Wed Jun 20, 2007 1:59 am
Location: Arkansas
Contact:

Please Help

Post by wildcatforums » Mon Jul 16, 2007 5:49 am

When I ran the fresh install, I got this.

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');

Installation is complete, however, some errors were encountered. It is suggested that you rectify these problems before attempting to use the Ultimate Quiz MOD!

Also, when I went to Quiz settings and hit submit, I got this:
Query 17 did not execute correctly

DEBUG MODE

SQL Error : 1054 Unknown column 'user_points' in 'field list'

UPDATE phpbb_config SET config_value = user_points WHERE config_name = 'Quiz_Cash_Currency'

Line : 84
File : admin_quiz.php
What do I do????

User avatar
chery
Registered User
Posts: 95
Joined: Wed Mar 22, 2006 7:30 pm
Location: terra australia
Contact:

Query 17 did not execute correctly

Post by chery » Sun Aug 12, 2007 5:06 am

Query 17 did not execute correctly

The fix is found here: http://forums.cricketmx.com/viewtopic.php?p=57367#57367

wkdwich
Registered User
Posts: 46
Joined: Wed Jun 29, 2005 6:44 am
Contact:

Re: [2.0.19] Ultimate Quiz MOD

Post by wkdwich » Tue Aug 21, 2007 1:20 pm

an examination of my php_bb database shows me:

phpbb_quiz_scores 6,463 records
phpbb_quiz_survey 95,397 records


Would it be OK to just EMPTY these 2 tables of all records?

b1g3r
Registered User
Posts: 7
Joined: Fri Jun 16, 2006 6:27 pm
Contact:

Re: [2.0.19] Ultimate Quiz MOD

Post by b1g3r » Fri Nov 02, 2007 3:47 am

Does anyone tried Ulimate Quiz to install in phpbb 2.0.22
Was the install succesfull in 2.0.22 :)

Thanks.

Post Reply

Return to “[2.0.x] MOD Database Releases”

Who is online

Users browsing this forum: No registered users and 12 guests