phpBB.de

Code: Alles auswählen

CREATE TABLE phpbb_quiz (
   quiz_id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
   question text NOT NULL,
   answer varchar(100) NOT NULL,
   answer2 varchar(100) NOT NULL,
   answer3 varchar(100) NOT NULL,
   answer4 varchar(100) NOT NULL,
   quiz_points tinyint(2) DEFAULT '1' NOT NULL,
   quiz_type tinyint(1) DEFAULT '0' NOT NULL,
   quiz_status tinyint(1) DEFAULT '0' NOT NULL,
   quiz_from_user_id mediumint(8) DEFAULT '0' NOT NULL,
   quiz_topic_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   quiz_bot_post_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   answered_by_user_id mediumint(8) DEFAULT '0' NOT NULL,
   PRIMARY KEY (quiz_id),
   KEY quiz_status (quiz_status),
   KEY quiz_topic_id (quiz_topic_id),
   KEY user_id (quiz_from_user_id)
);
CREATE TABLE phpbb_quiz_config (
   config_name varchar(255) NOT NULL,
   config_value text NOT NULL,
   PRIMARY KEY (config_name)
);
INSERT INTO phpbb_quiz_config VALUES ('quizbot_id', '2'),
('forum_id', '1'),
('next_quiz', '" . ( time() - 3600 ) . "'),
('next_quiz_step', '1'),
('next_quiz_step_mode', '1'),
('disable', '1'),
('subject', 'Quiz Frage #{NUM} ...'),
('message', 'Und hier die neue Quiz-Frage:\r\n{QUIZ}'),
('subject2', 'Quiz beantwortet'),
('message2', 'Die Quiz-Frage wurde von [i]{USERNAME}[/i] richtig beantwortet.\r\nDas Quiz wurde beendet.'),
('subject3', 'Fehler'),
('message3', 'Aus technischen Gründen wurde die Antwort von [i]{USERNAME}[/i] irrtümlich als richtig markiert. Wir bitten dies zu entschuldigen.\r\nDas Quiz wird nicht wiedereröffnet und bleibt beendet. \r\n'),
('next_quiz_number', '1'),
('quiz_points_disable', '0'),
('banned_users', ''),
('banned_groups', ''),
('admin_user_id', '2'),
('allow_admin_in_quiz', '0'),
('allow_mod_in_quiz', '0'),
('allow_quiz_from_user_in_quiz', '0'),
('html', '1'),
('bbcode', '1'),
('smilies', '1'),
('imported_files', ''),
('last_start_time', '0'),
('version', '0.1.0');
ALTER TABLE phpbb_users ADD quiz_points MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_topics ADD topic_quiz MEDIUMINT(8) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_posts_text ADD quiz_answer VARCHAR(100) NOT NULL;

Code: Alles auswählen

http://www.heubach.org/dgb/install_quiz_hack.php

Code: Alles auswählen

http://www.heubach.org/dgb/login.php?redirect=install_quiz_hack.php&sid=fd0b08461f74997d47d9514a625c9aa9

Code: Alles auswählen

Allgemeiner Fehler 
  
Could not get quiz config information

DEBUG MODE

SQL Error : 1146 Table 'heubach1.dgb_quiz_config' doesn't exist

SELECT config_name, config_value FROM dgb_quiz_config WHERE config_name IN ('next_quiz','last_start_time','disable')

Line : 201
File : /home/sites/site143/web/dgb/common.php

Code: Alles auswählen

$sql_query = " 
CREATE TABLE phpbb_QUIZ_TABLE 
   quiz_id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment, 
   question text NOT NULL, 
   answer varchar(100) NOT NULL, 
   answer2 varchar(100) NOT NULL, 
   answer3 varchar(100) NOT NULL, 
   answer4 varchar(100) NOT NULL, 
   quiz_points tinyint(2) DEFAULT '1' NOT NULL, 
   quiz_type tinyint(1) DEFAULT '0' NOT NULL, 
   quiz_status tinyint(1) DEFAULT '0' NOT NULL, 
   quiz_from_user_id mediumint(8) DEFAULT '0' NOT NULL, 
   quiz_topic_id mediumint(8) unsigned DEFAULT '0' NOT NULL, 
   quiz_bot_post_id mediumint(8) unsigned DEFAULT '0' NOT NULL, 
   answered_by_user_id mediumint(8) DEFAULT '0' NOT NULL, 
   PRIMARY KEY (quiz_id), 
   KEY quiz_status (quiz_status), 
   KEY quiz_topic_id (quiz_topic_id), 
   KEY user_id (quiz_from_user_id) 


CREATE TABLE phpbb_QUIZ_CONFIG_TABLE 
   config_name varchar(255) NOT NULL, 
   config_value text NOT NULL, 
   PRIMARY KEY (config_name) 


INSERT INTO phpbb_QUIZ_CONFIG_TABLE 
('quizbot_id', '2'), 
('forum_id', '1'), 
('next_quiz', '" . ( time() - 3600 ) . "'), 
('next_quiz_step', '1'), 
('next_quiz_step_mode', '1'), 
('disable', '1'), 
('subject', 'Quiz Frage #{NUM} ...'), 
('message', 'Und hier die neue Quiz-Frage:\r\n{QUIZ}'), 
('subject2', 'Quiz beantwortet'), 
('message2', 'Die Quiz-Frage wurde von [i]{USERNAME}[/i] richtig beantwortet.\r\nDas Quiz wurde beendet.'), 
('subject3', 'Fehler'), 
('message3', 'Aus technischen Gründen wurde die Antwort von [i]{USERNAME}[/i] irrtümlich als richtig markiert. Wir bitten dies zu entschuldigen.\r\nDas Quiz wird nicht wiedereröffnet und bleibt beendet. \r\n'), 
('next_quiz_number', '1'), 
('quiz_points_disable', '0'), 
('banned_users', ''), 
('banned_groups', ''), 
('admin_user_id', '2'), 
('allow_admin_in_quiz', '0'), 
('allow_mod_in_quiz', '0'), 
('allow_quiz_from_user_in_quiz', '0'), 
('html', '1'), 
('bbcode', '1'), 
('smilies', '1'), 
('imported_files', ''), 
('last_start_time', '0'), 
('version', '0.1.0'); 

ALTER TABLE phpbb_USERS_TABLE ADD quiz_points MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL; 

ALTER TABLE phpbb_TOPICS_TABLE . " ADD topic_quiz MEDIUMINT(8) DEFAULT '0' NOT NULL; 

ALTER TABLE phpbb_POSTS_TEXT_TABLE . " ADD quiz_answer VARCHAR(100) NOT NULL;