Wie kann ich das beheben. Hier die Datei die es betreffen sollte.
Code: Alles auswählen
<?php
/**
*
* @package mxBBmodule_mx_kb
* @version $Id: kb_post.php,v 1.12 2007/08/05 22:08:47 jonohlsson Exp $
* @copyright (c) 2002-2006 [wGEric, Jon Ohlsson] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/
if ( !defined( 'IN_PORTAL' ) )
{
die( "Hacking attempt" );
}
/**
* Enter description here...
*
*/
class mx_kb_post extends mx_kb_public
{
/**
* Enter description here...
*
* @param unknown_type $action
*/
function main( $action )
{
global $template, $mx_kb_functions, $lang, $board_config, $phpEx, $kb_config, $db, $images, $userdata;
global $mx_root_path, $module_root_path, $phpbb_root_path, $is_block, $phpEx, $mx_request_vars, $theme;
global $html_entities_match, $html_entities_replace, $unhtml_specialchars_match, $unhtml_specialchars_replace;
global $HTTP_SERVER_VARS;
//
// Request vars
//
$article_id = $mx_request_vars->request('k', MX_TYPE_INT, '');
$cat_id = $mx_request_vars->request('cat', MX_TYPE_INT, 0);
$do = ( isset( $_REQUEST['do'] ) ) ? intval( $_REQUEST['do'] ) : '';
$kb_post_mode = empty( $article_id ) ? 'add' : 'edit'; //Main mode toggle
$this->page_title = $kb_post_mode == 'add' ? $lang['Add_article'] : $lang['Edit_article'];
$delete = $mx_request_vars->request('delete', MX_TYPE_NO_TAGS, '');
$preview = $mx_request_vars->is_request('preview');
$cancel = $mx_request_vars->is_request('cancel');
//
// Main Auth
//
if ( !empty( $cat_id ) )
{
if ( !$this->auth_user[$cat_id]['auth_post'] )
{
mx_message_die( GENERAL_MESSAGE, $lang['Sorry_auth_post'] );
}
}
else
{
$dropmenu = ( !$cat_id ) ? $this->generate_jumpbox( 0, 0, '', true, true, 'auth_post' ) : $this->generate_jumpbox( 0, 0, array( $cat_id => 1 ), true, true, 'auth_post' );
if ( empty( $dropmenu ) )
{
mx_message_die( GENERAL_MESSAGE, $lang['Sorry_auth_post'] );
}
}
//
// Load article info...if $article_id is set
//
if ( $article_id )
{
$sql = 'SELECT *
FROM ' . KB_ARTICLES_TABLE . "
WHERE article_id = '" . $article_id . "'";
if ( !( $result = $db->sql_query( $sql ) ) )
{
mx_message_die( GENERAL_ERROR, 'Couldnt query Article data', '', __LINE__, __FILE__, $sql );
}
$article_data = $db->sql_fetchrow( $result );
$cat_id = $article_data['article_category_id'];
$db->sql_freeresult( $result );
}
//
// Further security.
// Reset vars if no related data exist.
//
if ( $article_id && !$cat_id )
{
$article_id = 0;
}
if ( $cat_id && !$this->cat_rowset[$cat_id]['category_id'] )
{
$cat_id = 0;
}
// =======================================================
// Delete
// =======================================================
if ( $do == 'delete' && $article_id)
{
if ( ( $this->auth_user[$cat_id]['auth_delete'] && $article_data['user_id'] == $userdata['user_id'] ) || $this->auth_user[$cat_id]['auth_mod'] )
{
//
// Notification
//
$this->update_add_item_notify($article_id, 'delete');
//
// Comments
//
if ($this->comments[$cat_id]['activated'] && $kb_config['del_topic'])
{
if ( $this->comments[$cat_id]['internal_comments'] )
{
$sql = 'DELETE FROM ' . KB_COMMENTS_TABLE . "
WHERE article_id = '" . $article_id . "'";
if ( !( $db->sql_query( $sql ) ) )
{
mx_message_die( GENERAL_ERROR, 'Couldnt delete comments', '', __LINE__, __FILE__, $sql );
}
}
else
{
if ( $article_data['topic_id'] )
{
include( $module_root_path . 'kb/includes/functions_comment.' . $phpEx );
$mx_kb_comments = new mx_kb_comments();
$mx_kb_comments->init( $article_data, 'phpbb');
$mx_kb_comments->post('delete_all', $article_data['topic_id']);
}
}
}
$this->delete_items( $article_id );
$this->_kb();
$message = $lang['Article_Deleted'] . '<br /><br />' . sprintf( $lang['Click_return'], '<a href="' . append_sid( $this->this_mxurl( "mode=cat&cat=" . $cat_id ) ) . '">', '</a>' );
mx_message_die( GENERAL_MESSAGE, $message );
}
else
{
mx_message_die( GENERAL_MESSAGE, $lang['Sorry_auth_delete'] );
}
}
//
// Define more vars
//
$kb_title = $preview || isset($_POST['article_name']) ? $_POST['article_name'] : $article_data['article_title'];
$kb_desc = $preview || isset($_POST['article_desc']) ? $_POST['article_desc'] : $article_data['article_description'];
$kb_text = $preview || isset($_POST['message']) ? $_POST['message'] : $article_data['article_body'];
$bbcode_uid = $preview ? '' : $article_data['bbcode_uid'];
$username = $preview || isset($_POST['username']) ? $_POST['username'] : $article_data['username'];
$type_id = $preview || isset($_POST['type_id']) ? intval($_POST['type_id']) : $article_data['article_type'];
//
// Instatiate custom fields (only used in kb_article)
//
$mx_kb_custom_field = new mx_custom_field(KB_CUSTOM_TABLE, KB_CUSTOM_DATA_TABLE);
$mx_kb_custom_field->init();
//
// wysiwyg
//
if ( $kb_config['allow_wysiwyg'] && file_exists( $mx_root_path . $kb_config['wysiwyg_path'] . 'tinymce/jscripts/tiny_mce/blank.htm' ))
{
$allow_wysiwyg = true;
$bbcode_on = false;
$html_on = true;
$smilies_on = false;
$links_on = false;
$images_on = false;
$langcode = mx_get_langcode();
$template->assign_block_vars( "tinyMCE", array(
'PATH' => $mx_root_path,
'LANG' => !empty($langcode) ? $langcode : $HTTP_SERVER_VARS['HTTP_ACCEPT_LANGUAGE'],
'TEMPLATE' => $phpbb_root_path . 'templates/'. $theme['template_name'] . '/' . $theme['head_stylesheet']
));
}
else
{
$allow_wysiwyg = false;
$bbcode_on = $kb_config['allow_bbcode'] ? true : false;
$html_on = $kb_config['allow_html'] ? true : false;
$smilies_on = $kb_config['allow_smilies'] ? true : false;
$links_on = $kb_config['allow_links'] ? true : false;
$images_on = $kb_config['allow_images'] ? true : false;
$board_config['allow_html_tags'] = $kb_config['allowed_html_tags'];
$template->assign_block_vars( 'formatting', array() );
if ($smilies_on)
{
$mx_kb_functions->generate_smilies( 'inline', PAGE_POSTING );
}
}
//
// Instantiate the mx_text and mx_text_formatting classes
//
$mx_text = new mx_text();
$mx_text->init($html_on, $bbcode_on, $smilies_on);
$mx_text_formatting = new mx_text_formatting();
//
// Allow all html tags
// Fix: Setting 'emtpy' enables all
//
$mx_text->allow_all_html_tags = $allow_wysiwyg;
//
// IF submit then upload the article and update the sql for it
//
if ( isset( $_POST['submit'] ) && $cat_id )
{
if ( !$mx_request_vars->is_request('article_name') || !$mx_request_vars->is_request('article_desc') || !$mx_request_vars->is_request('message') )
{
$message = $lang['Empty_fields'] . '<br /><br />' . sprintf( $lang['Empty_fields_return'], '<a href="' . append_sid( $this->this_mxurl( 'mode=add' ) ) . '">', '</a>' );
mx_message_die( GENERAL_MESSAGE, $message );
}
//
// Encode for db storage
//
$article_title = $mx_text->encode_simple($kb_title);
$article_description = $mx_text->encode_simple($kb_desc);
$article_text = $mx_text->encode($kb_text);
$bbcode_uid = $mx_text->bbcode_uid;
$username = $mx_text->encode_username($username);
$date = time();
$author_id = $userdata['user_id'] > 0 ? intval( $userdata['user_id'] ) : '-1';
if ( !$article_id )
{
if ( $this->auth_user[$cat_id]['auth_post'] || $this->auth_user[$cat_id]['auth_mod'] )
{
//
// Approve
//
$approve = $this->auth_user[$cat_id]['auth_approval'] || $this->auth_user[$cat_id]['auth_mod'] ? 1 : 0; // approved
$sql = "INSERT INTO " . KB_ARTICLES_TABLE . " ( article_category_id , article_title , article_description , article_date , article_author_id , username , bbcode_uid , article_body , article_type , approved, views )
VALUES ( '$cat_id', '" . str_replace( "\'", "''", $article_title ) . "', '" . str_replace( "\'", "''", $article_description ) . "', '$date', '$author_id', '" . str_replace( "\'", "''", $username ) . "', '$bbcode_uid', '" . str_replace( "\'", "''", $article_text ) . "', '$type_id', '$approve', '0')";
if ( !( $results = $db->sql_query( $sql ) ) )
{
mx_message_die( GENERAL_ERROR, "Could not submit aritcle", '', __LINE__, __FILE__, $sql );
}
//
// Get new article id
//
$sql = "SELECT MAX(article_id) AS new_id FROM " . KB_ARTICLES_TABLE;
if( !($result = $db->sql_query($sql)) )
{
mx_message_die(GENERAL_ERROR, "Couldn't find max article_id", "", __LINE__, __FILE__, $sql);
}
$temp_row = $db->sql_fetchrow($result);
$article_id = $temp_row['new_id'];
//
// Update custom fields
//
$mx_kb_custom_field->file_update_data( $article_id );
$this->modified( true );
$this->_kb();
}
else
{
$message = $lang['Sorry_auth_post'];
}
}
else
{
if ( ($this->auth_user[$cat_id]['auth_edit'] && $article_data['user_id'] == $userdata['user_id'] ) || $this->auth_user[$cat_id]['auth_mod'] )
{
//
// Approve
//
$approve = $this->auth_user[$cat_id]['auth_approval_edit'] || $this->auth_user[$cat_id]['auth_mod'] ? 1 : 0; // approved
$sql = "UPDATE " . KB_ARTICLES_TABLE . "
SET article_category_id = '$cat_id',
article_title = '" . str_replace( "\'", "''", $article_title ) . "',
article_description = '" . str_replace( "\'", "''", $article_description ) . "',
article_body = '" . str_replace( "\'", "''", $article_text ) . "',
article_type = '" . $type_id . "',
approved = '" . $approve . "',
bbcode_uid = '" . $bbcode_uid . "'
WHERE article_id = ". $article_id;
if ( !( $results = $db->sql_query( $sql ) ) )
{
mx_message_die( GENERAL_ERROR, "Could not edit article", '', __LINE__, __FILE__, $sql );
}
//
// Update custom fields
//
$mx_kb_custom_field->file_update_data( $article_id );
$this->modified( true );
$this->_kb();
}
else
{
$message = $lang['Sorry_auth_edit'];
}
}
//
// Notification
//
$this->update_add_item_notify($article_id, $kb_post_mode);
//
// Auto comment
//
if ( $this->comments[$cat_id]['activated'] && $this->comments[$cat_id]['autogenerate_comments'] )
{
//
// Autogenerate comment (duplicate the notification message)
//
$mx_kb_notification = new mx_kb_notification();
$mx_kb_notification->init( $article_id );
$mx_kb_notification->_compose_auto_note($kb_post_mode == 'add' ? MX_NEW_NOTIFICATION : MX_EDITED_NOTIFICATION);
//
// Generate comment
//
$this->update_add_comment('', $article_id, 0, addslashes(trim($mx_kb_notification->topic_title)), addslashes(trim($mx_kb_notification->message)) );
}
if ( $approve == 1 )
{
$message = $lang['Article_submitted'] . '<br /><br />' . sprintf( $lang['Click_return_kb'], '<a href="' . append_sid( $this->this_mxurl() ) . '">', '</a>' ) . '<br /><br />' . sprintf($lang['Click_return_article'], '<a href="' . append_sid($this->this_mxurl("mode=article&k=" . $article_id)). '">', '</a>') . '<br /><br />' . sprintf( $lang['Click_return_index'], '<a href="' . append_sid( $mx_root_path . "index.$phpEx" ) . '">', '</a>' );
}
else
{
$message = $lang['Article_submitted_Approve'] . '<br /><br />' . sprintf( $lang['Click_return_kb'], '<a href="' . append_sid( $this->this_mxurl() ) . '">', '</a>' ) . '<br /><br />' . sprintf( $lang['Click_return_index'], '<a href="' . append_sid( $mx_root_path . "index.$phpEx" ) . '">', '</a>' );
}
mx_message_die( GENERAL_MESSAGE, $message );
}
else
// =======================================================
// IF not submit then load data MAIN form
// =======================================================
{
if ( !$article_id )
{
if ( !$this->auth_user[$cat_id]['auth_post'] )
{
mx_message_die( GENERAL_MESSAGE, $lang['Sorry_auth_post'] );
}
}
else
{
if ( !( ( $this->auth_user[$cat_id]['auth_edit'] && $article_data['user_id'] == $userdata['user_id'] ) || $this->auth_user[$cat_id]['auth_mod'] ) )
{
mx_message_die( GENERAL_MESSAGE, $lang['Sorry_auth_edit'] );
}
}
//
// PreText HIDE/SHOW
//
if ( $kb_config['show_pretext'] )
{
//
// Pull Header/Body info.
//
$pt_header = $kb_config['pt_header'];
$pt_body = $kb_config['pt_body'];
$template->set_filenames( array( 'pretext' => 'kb_post_pretext.tpl' ) );
$template->assign_vars( array(
'PRETEXT_HEADER' => $pt_header,
'PRETEXT_BODY' => $pt_body ) );
$template->assign_var_from_handle( 'KB_PRETEXT_BOX', 'pretext' );
}
if ( $preview )
{
//
// Encode for preview
//
$preview_title = $mx_text->encode_preview_simple($kb_title);
$preview_desc = $mx_text->encode_preview_simple($kb_desc);
$preview_text = $mx_text->encode_preview($kb_text);
if (!$kb_config['allow_images'] || !$kb_config['allow_links'])
{
$preview_text = $mx_text_formatting->remove_images_links( $preview_text, $kb_config['allow_images'], $kb_config['no_image_message'], $kb_config['allow_links'], $kb_config['no_link_message'] );
}
$template->set_filenames( array( 'preview' => 'kb_post_preview.tpl' ) );
$template->assign_vars( array(
'L_PREVIEW' => $lang['Preview'],
'ARTICLE_TITLE' => $preview_title,
'ARTICLE_DESC' => $preview_desc,
'ARTICLE_BODY' => $preview_text,
'PRE_COMMENT' => $preview_text )
);
$template->assign_var_from_handle( 'KB_PREVIEW_BOX', 'preview' );
//
// Decode for form editing
//
$kb_title = $mx_text->decode_simple($kb_title, true);
$kb_desc = $mx_text->decode_simple($kb_desc, true);
$kb_text = $mx_text->decode($kb_text, '', true);
}
else
{
//
// Decode for form editing
//
$kb_title = $mx_text->decode_simple($kb_title, true);
$kb_desc = $mx_text->decode_simple($kb_desc, true);
$kb_text = $mx_text->decode($kb_text, $bbcode_uid, true);
}
//
// show article form - MAIN
//
if ( $kb_post_mode == 'edit' )
{
$s_hidden_vars = '<input type="hidden" name="k" value="' . $article_id . '"><input type="hidden" name="bbcode_uid" value="' . $bbcode_uid . '"><input type="hidden" name="author_id" value="' . $author_id . '">';
}
else
{
$s_hidden_vars = '<input type="hidden" name="cat" value="' . $cat_id . '">';
}
//
// Toggle selection
//
$html_status = ( $html_on ) ? $lang['HTML_is_ON'] : $lang['HTML_is_OFF'];
$bbcode_status = ( $bbcode_on ) ? $lang['BBCode_is_ON'] : $lang['BBCode_is_OFF'];
$smilies_status = ( $smilies_on ) ? $lang['Smilies_are_ON'] : $lang['Smilies_are_OFF'];
$links_status = ( $links_on ) ? $lang['Links_are_ON'] : $lang['Links_are_OFF'];
$images_status = ( $images_on ) ? $lang['Images_are_ON'] : $lang['Images_are_OFF'];
//
// set up page
//
$template->set_filenames( array( 'body' => 'kb_post_body.tpl' ) );
if ( !$userdata['session_logged_in'] )
{
$template->assign_block_vars( 'switch_name', array() );
}
$kb_action_url = $kb_post_mode == 'add' ? $this->this_mxurl( 'mode=add' ) : $this->this_mxurl( 'mode=edit' );
$custom_data = $kb_post_mode == 'add' ? $mx_kb_custom_field->display_edit() : $mx_kb_custom_field->display_edit( $article_id );
if ( $custom_data )
{
$template->assign_block_vars( 'custom_data_fields', array(
'L_ADDTIONAL_FIELD' => $lang['Addtional_field']
));
}
$template->assign_vars( array(
'S_ACTION' => $kb_action_url,
'S_HIDDEN_FIELDS' => $s_hidden_vars,
'ARTICLE_TITLE' => $kb_title,
'ARTICLE_DESC' => $kb_desc,
'ARTICLE_BODY' => $kb_text,
'USERNAME' => $username,
'L_ADD_ARTICLE' => $lang['Add_article'],
'L_ARTICLE_TITLE' => $lang['Article_title'],
'L_ARTICLE_DESCRIPTION' => $lang['Article_description'],
'L_ARTICLE_TEXT' => $lang['Article_text'],
'L_ARTICLE_CATEGORY' => $lang['Category'],
'L_ARTICLE_TYPE' => $lang['Article_type'],
'L_SUBMIT' => $lang['Submit'],
'L_PREVIEW' => $lang['Preview'],
'L_SELECT_TYPE' => $lang['Select'],
'L_NAME' => $lang['Username'],
'HTML_STATUS' => $html_status,
'BBCODE_STATUS' => sprintf($bbcode_status, '<a href="' . PHPBB_URL . append_sid("faq.$phpEx?mode=bbcode") . '" target="_phpbbcode">', '</a>'),
'SMILIES_STATUS' => $smilies_status,
'LINKS_STATUS' => $links_status,
'IMAGES_STATUS' => $images_status,
'L_BBCODE_B_HELP' => $lang['bbcode_b_help'],
'L_BBCODE_I_HELP' => $lang['bbcode_i_help'],
'L_BBCODE_U_HELP' => $lang['bbcode_u_help'],
'L_BBCODE_Q_HELP' => $lang['bbcode_q_help'],
'L_BBCODE_C_HELP' => $lang['bbcode_c_help'],
'L_BBCODE_L_HELP' => $lang['bbcode_l_help'],
'L_BBCODE_O_HELP' => $lang['bbcode_o_help'],
'L_BBCODE_P_HELP' => $lang['bbcode_p_help'],
'L_BBCODE_W_HELP' => $lang['bbcode_w_help'],
'L_BBCODE_A_HELP' => $lang['bbcode_a_help'],
'L_BBCODE_S_HELP' => $lang['bbcode_s_help'],
'L_BBCODE_F_HELP' => $lang['bbcode_f_help'],
'L_EMPTY_MESSAGE' => $lang['Empty_message'],
'L_EMPTY_ARTICLE_NAME' => $lang['Empty_article_name'],
'L_EMPTY_ARTICLE_DESC' => $lang['Empty_article_desc'],
'L_EMPTY_CAT' => $lang['Empty_category'],
'L_EMPTY_TYPE' => $lang['Empty_type'],
'L_FONT_COLOR' => $lang['Font_color'],
'L_COLOR_DEFAULT' => $lang['color_default'],
'L_COLOR_DARK_RED' => $lang['color_dark_red'],
'L_COLOR_RED' => $lang['color_red'],
'L_COLOR_ORANGE' => $lang['color_orange'],
'L_COLOR_BROWN' => $lang['color_brown'],
'L_COLOR_YELLOW' => $lang['color_yellow'],
'L_COLOR_GREEN' => $lang['color_green'],
'L_COLOR_OLIVE' => $lang['color_olive'],
'L_COLOR_CYAN' => $lang['color_cyan'],
'L_COLOR_BLUE' => $lang['color_blue'],
'L_COLOR_DARK_BLUE' => $lang['color_dark_blue'],
'L_COLOR_INDIGO' => $lang['color_indigo'],
'L_COLOR_VIOLET' => $lang['color_violet'],
'L_COLOR_WHITE' => $lang['color_white'],
'L_COLOR_BLACK' => $lang['color_black'],
'L_FONT_SIZE' => $lang['Font_size'],
'L_FONT_TINY' => $lang['font_tiny'],
'L_FONT_SMALL' => $lang['font_small'],
'L_FONT_NORMAL' => $lang['font_normal'],
'L_FONT_LARGE' => $lang['font_large'],
'L_FONT_HUGE' => $lang['font_huge'],
'L_PAGES' => $lang['L_Pages'],
'L_PAGES_EXPLAIN' => $lang['L_Pages_explain'],
'L_TOC' => $lang['L_Toc'],
'L_TOC_EXPLAIN' => $lang['L_Toc_explain'],
'L_ABSTRACT' => $lang['L_Abstract'],
'L_ABSTRACT_EXPLAIN' => $lang['L_Abstract_explain'],
'L_TITLE_FORMAT' => $lang['L_Title_Format'],
'L_TITLE_FORMAT_EXPLAIN' => $lang['L_Title_Format_explain'],
'L_SUBTITLE_FORMAT' => $lang['L_Subtitle_Format'],
'L_SUBTITLE_FORMAT_EXPLAIN' => $lang['L_Subtitle_Format_explain'],
'L_SUBSUBTITLE_FORMAT' => $lang['L_Subsubtitle_Format'],
'L_SUBSUBTITLE_FORMAT_EXPLAIN' => $lang['L_Subsubtitle_Format_explain'],
'L_OPTIONS' => $lang['L_Options'],
'L_FORMATTING' => $lang['L_Formatting'],
'L_BBCODE_CLOSE_TAGS' => $lang['Close_Tags'],
'L_STYLES_TIP' => $lang['Styles_tip']
) );
$mx_kb_functions->get_kb_type_list( $type_id );
if ( $kb_post_mode == 'edit' )
{
$template->assign_block_vars( 'switch_edit', array(
'CAT_LIST' => $this->generate_jumpbox( 0, 0, array( $cat_id => 1 ), false, true, 'auth_edit')
));
}
if ( $bbcode_on )
{
$template->assign_block_vars( 'switch_bbcodes', array());
}
// ===================================================
// assign var for top navigation
// ===================================================
$this->generate_navigation( $cat_id );
//
// User authorisation levels output
//
$this->auth_can( $cat_id );
//
// Get footer quick dropdown jumpbox
//
$this->generate_jumpbox( 0, 0, array( $cat_id => 1 ));
}
}
}
?>Danke
TTS
Hoffentlich hilft mir hier endlich mal jemand, wird echt immer seltener.
