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

Allgemeiner Fehler

Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' 1054577793, 1, 0, 0, 0, 0)' at line 1

INSERT INTO phpbb_topics (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote, topic_icon) VALUES ('Quiz Frage #1 ...', , 1054577793, 1, 0, 0, 0, 0)
Line : 271
File : /www/htdocs/hdgrstai/board/includes/functions_post.php

Code: Alles auswählen

Parse error: parse error, unexpected T_IF, expecting '{' in /home/www/htdocs/windelbabys.net/test-forum/includes/functions_search.php on line 24

Fatal error: Call to undefined function: add_search_words() in /home/www/htdocs/windelbabys.net/test-forum/includes/functions_post.php on line 298

Code: Alles auswählen

#
#-----[ OPEN ]------------------------------------------
#
templates/xxx/posting_body.tpl
#
#-----[ FIND ]------------------------------------------
#
		formErrors = "{L_EMPTY_MESSAGE}";
	}
#
#-----[ AFTER, ADD ]------------------------------------------
#
	<!-- BEGIN switch_quiz_answer_js -->
	{switch_quiz_answer_js.JS} 
	<!-- END switch_quiz_answer_js -->
#
#-----[ FIND ]------------------------------------------
#
	<tr> 
	  <td class="row1" valign="top"><span class="gen"><b>{L_OPTIONS}</b></span><br /><span class="gensmall">{HTML_STATUS}<br />{BBCODE_STATUS}<br />{SMILIES_STATUS}</span></td>
#
#-----[ BEFORE, ADD ]------------------------------------------
#
	<!-- BEGIN switch_quiz_answer -->
	<tr> 
		<td class="row1" valign="top"><span class="gen"><b>{switch_quiz_answer.L_ANSWER}</b></span></td>
		<td class="row2"><span class="genmed">{switch_quiz_answer.ANSWER}</span></td>
	</tr>
	<!-- END switch_quiz_answer -->