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

    $Id: emailer.php,v 1.15.2.3 2002/05/20 00:21:38 psotfx Exp $

***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/
// BEGIN Quiz Hack
if ( defined('EMAILER_INCLUDED') )
{
	return;
}
define('EMAILER_INCLUDED', true);
// END Quiz Hack
//
// The emailer class has support for attaching files, that isn't implemented
// in the 2.0 release but we can probable find some way of using it in a future
// release
//
class emailer
{

Code: Alles auswählen

$sql = ( $mode != "editpost" ) ? "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote $quiz_sql1) VALUES ('$post_subject', " . $userdata['user_id'] . ", $current_time, $forum_id, " . TOPIC_UNLOCKED . ", $topic_type, $topic_vote $quiz_sql2)" : "UPDATE " . TOPICS_TABLE . " SET topic_title = '$post_subject', topic_type = $topic_type, topic_vote = $topic_vote WHERE topic_id = $topic_id"; 

Code: Alles auswählen

		// BEGINN Quiz Hack
		$quiz_sql1 = !empty($post_data['topic_quiz']) ? ', topic_quiz' : '';
		$quiz_sql2 = !empty($post_data['topic_quiz']) ? ', 1' : '';
		// END Quiz Hack
		$sql  = ( $mode != "editpost" ) ? "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote $quiz_sql1) VALUES ('$post_subject', " . $userdata['user_id'] . ", $current_time, $forum_id, " . TOPIC_UNLOCKED . ", $topic_type, $topic_vote $quiz_sql2)" : "UPDATE " . TOPICS_TABLE . " SET topic_title = '$post_subject', topic_type = $topic_type, topic_vote = $topic_vote WHERE topic_id = $topic_id";
// ADDED $quiz_sql1 AND $quiz_sql2 BY Quiz Hack
		if ( !$db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
		}

		if ( $mode == 'newtopic' )
		{
			$topic_id = $db->sql_nextid();
		}
	}

	$edited_sql = ( $mode == 'editpost' && !$post_data['last_post'] && $post_data['poster_post'] ) ? ", post_edit_time = $current_time, post_edit_count = post_edit_count + 1 " : "";
	$sql = ( $mode != "editpost" ) ? "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $attach_sig)" : "UPDATE " . POSTS_TABLE . " SET enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig" . $edited_sql . " WHERE post_id = $post_id";
	if ( !$db->sql_query($sql, BEGIN_TRANSACTION) )
	{
		message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
	}

	if ( $mode != 'editpost' )
	{
		$post_id = $db->sql_nextid();
	}
	// BEGINN Quiz Hack
	$quiz_sql1 = !empty($post_data['quiz_answer']) ? ', quiz_answer' : '';
	$quiz_sql2 = !empty($post_data['quiz_answer']) ? ( ", '" . $post_data['quiz_answer'] . "'" ) : '';
	// END Quiz Hack
	$sql = ( $mode != 'editpost' ) ? "INSERT INTO " . POSTS_TEXT_TABLE . " (post_id, post_subject, bbcode_uid, post_text, $quiz_sql1) VALUES ($post_id, '$post_subject', '$bbcode_uid', '$post_message', '$quiz_sql2')" : "UPDATE " . POSTS_TEXT_TABLE . " SET post_text = '$post_message',  bbcode_uid = '$bbcode_uid', post_subject = '$post_subject' WHERE post_id = $post_id";
// ADDED $quiz_sql1 AND $quiz_sql2 BY Quiz Hack

Code: Alles auswählen

INSERT INTO phpbb_quiz_config VALUES 'quizbot_id', '2'), ('admin_user_id', '2');