Code: Alles auswählen
Could not get main information for similar topics
DEBUG MODE
SQL Error : 1191 Can't find FULLTEXT index matching the column list
SELECT topic_id FROM phpbb_topics WHERE topic_id != 9 AND MATCH (topic_title) AGAINST ('Mentale Zaubermaschine') ORDER BY topic_time DESC LIMIT 0,5
Line : 394
File : viewtopic.phpCode: Alles auswählen
Führe die Querrie in deiner Datenbank aus (ersetze phpbb_ mit deinem Prefix), bevor du die Dateien veränderst!
ALTER TABLE phpbb_topics ADD FULLTEXT (topic_title);musst du mit KB:phpmyadmin im SQL-Fenster ausführen.ALTER TABLE phpbb_topics ADD FULLTEXT (topic_title);
Code: Alles auswählen
Could not get main information for similar topics
DEBUG MODE
SQL Error : 1030 Got error -1 from storage engine
SELECT topic_id FROM phpbb_topics WHERE topic_id != 361 AND MATCH (topic_title) AGAINST ('test test test') ORDER BY topic_time DESC LIMIT 0,5
Line : 606
File : viewtopic.php
Error Message saved in Database
Code: Alles auswählen
ALTER TABLE phpbb_topics ADD FULLTEXT (topic_title);
Code: Alles auswählen
##############################################################
## MOD Title: Ähnliche Beiträge (Similar Topics)
## MOD Author: Leuchte < mail@leuchte.net > http://www.leuchte.net
## MOD Description: Dieser Mod fügt eine Tabelle an das Ende eines Beitrages und zeigt andere Beiträge mit ähnlichen Themen.
##
## MOD Version: 1.0.1
##
## Installation Level: Leicht
## Installation Time: 5 Minuten
## Files To Edit: 3
##
## lang_main.php
## viewtopic.php
## templates/subSilver/viewtopic_body.tpl
##
## Included Files: 0
##############################################################
## For Security Purposes, Please Check: http://www.leuchte.net/mods/ for the
## latest version of this MOD.
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
## MOD History:
##
## 2004-09-25 - Initial Release
##
##############################################################
#
#-----[ SQL ]------------------------------------------
# Führe die Querrie in deiner Datenbank aus (ersetze phpbb_ mit deinem Prefix), bevor du die Dateien veränderst!
ALTER TABLE phpbb_topics ADD FULLTEXT (topic_title);
#
#-----[ OPEN ]------------------------------------------
#
language/lang_german/lang_main.php
#
#-----[ FIND ]------------------------------------------
#
// That's all Folks!
#
#-----[ BEFORE, ADD ]------------------------------------------
#
$lang['Similar'] = 'Ähnliche Beiträge';
#
#-----[ OPEN ]------------------------------------------
#
viewtopic.php
#
#-----[ FIND ]------------------------------------------
#
//
// Go ahead and pull all data for this topic
//
#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Similar Topics
$sql = "SELECT topic_id
FROM ". TOPICS_TABLE ."
WHERE topic_id != $topic_id
AND MATCH (topic_title) AGAINST ('". addslashes($topic_title) ."')
ORDER BY topic_time DESC LIMIT 0,5";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not get main information for similar topics", '', __LINE__, __FILE__, $sql);
}
$topics = array();
while ( $row = $db->sql_fetchrow($result) )
{
$topics[] = $row;
}
$count_similar = count($topics);
if ( $count_similar > 0 )
{
$template->assign_block_vars('similar', array(
'L_SIMILAR' => $lang['Similar'],
'L_TOPIC' => $lang['Topic'],
'L_AUTHOR' => $lang['Author'],
'L_FORUM' => $lang['Forum'],
'L_REPLIES' => $lang['Replies'],
'L_LAST_POST' => $lang['Posted'])
);
for($i = 0; $i < $count_similar; $i++)
{
$sql = "SELECT t.topic_type, t.topic_status, t.topic_id, t.topic_title, t.topic_time, t.topic_replies, t.topic_last_post_id, u.user_id, u.username, f.forum_id, f.forum_name, p.post_time, p.post_username
FROM ". TOPICS_TABLE ." t, ". USERS_TABLE ." u, ". FORUMS_TABLE ." f, ". POSTS_TABLE ." p
WHERE t.topic_id = '". $topics[$i]['topic_id'] ."'
AND f.forum_id = t.forum_id
AND p.topic_id = t.topic_id
AND u.user_id = p.poster_id
GROUP BY t.topic_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not get similar topics", '', __LINE__, __FILE__, $sql);
}
while ( $row = $db->sql_fetchrow($result) )
{
$similar = $row;
$tracking_topics = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_t']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_t']) : array();
$tracking_forums = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_f']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_f']) : array();
$topic_type = ( $similar['topic_type'] == POST_ANNOUNCE ) ? $lang['Topic_Announcement'] .' ': '';
$topic_type .= ( $similar['topic_type'] == POST_STICKY ) ? $lang['Topic_Sticky'] .' ': '';
$topic_type .= ( $similar['topic_vote'] ) ? $lang['Topic_Poll'] .' ': '';
$replies = $similar['topic_replies'];
if( $similar['topic_status'] == TOPIC_LOCKED )
{
$folder = $images['folder_locked'];
$folder_new = $images['folder_locked_new'];
}
else if( $similar['topic_type'] == POST_ANNOUNCE )
{
$folder = $images['folder_announce'];
$folder_new = $images['folder_announce_new'];
}
else if( $similar['topic_type'] == POST_GLOBAL_ANNOUNCE )
{
$folder = $images['folder_global_announce'];
$folder_new = $images['folder_global_announce_new'];
}
else if( $similar['topic_type'] == POST_STICKY )
{
$folder = $images['folder_sticky'];
$folder_new = $images['folder_sticky_new'];
}
else
{
if( $replies >= $board_config['hot_threshold'] )
{
$folder = $images['folder_hot'];
$folder_new = $images['folder_hot_new'];
}
else
{
$folder = $images['folder'];
$folder_new = $images['folder_new'];
}
}
if( $userdata['session_logged_in'] )
{
if( $similar['post_time'] > $userdata['user_lastvisit'] )
{
if( !empty($tracking_topics) || !empty($tracking_forums) || isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_f_all']) )
{
$unread_topics = true;
if( !empty($tracking_topics[$topic_id]) )
{
if( $tracking_topics[$topic_id] >= $similar['post_time'] )
{
$unread_topics = false;
}
}
if( !empty($tracking_forums[$forum_id]) )
{
if( $tracking_forums[$forum_id] >= $similar['post_time'] )
{
$unread_topics = false;
}
}
if( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_f_all']) )
{
if( $HTTP_COOKIE_VARS[$board_config['cookie_name'] .'_f_all'] >= $similar['post_time'] )
{
$unread_topics = false;
}
}
if( $unread_topics )
{
$folder_image = $folder_new;
$folder_alt = $lang['New_posts'];
$newest_img = '<a href="'. append_sid("viewtopic.$phpEx?". POST_TOPIC_URL ."=$topic_id&view=newest") .'"><img src="'. $images['icon_newest_reply'] .'" alt="'. $lang['View_newest_post'] .'" title="'. $lang['View_newest_post'] .'" border="0" /></a> ';
}
else
{
$folder_image = $folder;
$folder_alt = ( $similar['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts'];
$newest_img = '';
}
}
else
{
$folder_image = $folder_new;
$folder_alt = ( $similar['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['New_posts'];
$newest_img = '<a href="'. append_sid("viewtopic.$phpEx?". POST_TOPIC_URL ."=$topic_id&view=newest") .'"><img src="'. $images['icon_newest_reply'] .'" alt="'. $lang['View_newest_post'] .'" title="'. $lang['View_newest_post'] .'" border="0" /></a> ';
}
}
else
{
$folder_image = $folder;
$folder_alt = ( $similar['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts'];
$newest_img = '';
}
}
else
{
$folder_image = $folder;
$folder_alt = ( $similar['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts'];
$newest_img = '';
}
$title = (strlen($similar['topic_title']) > 40) ? (substr($similar['topic_title'], 0, 37) . '...') : $similar['topic_title'];
$topic_url = '<a href="'. append_sid("viewtopic.$phpEx?". POST_TOPIC_URL .'='. $similar['topic_id']) .'">'. $title . '</a>';
$author_url = append_sid("profile.$phpEx?mode=viewprofile&". POST_USERS_URL .'='. $similar['user_id']);
$author = ( $similar['user_id'] != ANONYMOUS ) ? '<a href="'. append_sid("profile.$phpEx?mode=viewprofile&". POST_USERS_URL .'='. $similar['user_id']) .'">'. $similar['username'] .'</a>' : ( ($similar['post_username'] != '' ) ? $similar['post_username'] : $lang['Guest'] );
$forum_url = append_sid("viewforum.$phpEx?f=". $similar['forum_id']);
$forum = '<a href="'. $forum_url .'">'. $similar['forum_name'] .'</a>';
$post_url = '<a href="'. append_sid("viewtopic.$phpEx?". POST_POST_URL .'='. $similar['topic_last_post_id']) .'#'. $similar['topic_last_post_id'] .'"><img src="'. $images['icon_latest_reply'] .'" alt="'. $lang['View_latest_post'] .'" title="'. $lang['View_latest_post'] .'" border="0" /></a>';
$post_time = create_date($board_config['default_dateformat'], $similar['topic_time'], $board_config['board_timezone']);
$template->assign_block_vars('similar.topics', array(
'FOLDER' => $folder_image,
'ALT' => $folder_alt,
'TYPE' => $topic_type,
'TOPICS' => $topic_url,
'AUTHOR' => $author,
'FORUM' => $forum,
'REPLIES' => $replies,
'NEWEST' => $newest_img,
'POST_TIME' => $post_time,
'POST_URL' => $post_url)
);
} // while
} // for $i
} // if ( $count_similar > 0 )
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/viewtopic_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<td align="right" valign="top" nowrap="nowrap">{JUMPBOX}<span class="gensmall">{S_AUTH_LIST}</span></td>
</tr>
</table>
#
#-----[ REPLACE, WITH ]------------------------------------------
#
<td align="right" valign="top" nowrap="nowrap">{JUMPBOX}<span class="gensmall">{S_AUTH_LIST}</span></td>
</tr>
<tr>
<td width="100%" colspan="2" align="center">
<br />
<!-- BEGIN similar -->
<table width="85%" cellspacing="1" cellpadding="4" border="0" align="center" class="forumline">
<tr>
<td class="catHead" colspan="6"><span class="genmed"><b>{similar.L_SIMILAR}</b></span></td>
</tr>
<tr>
<th colspan="2">{similar.L_TOPIC}</th>
<th>{similar.L_AUTHOR}</th>
<th>{similar.L_FORUM}</th>
<th>{similar.L_REPLIES}</th>
<th>{similar.L_LAST_POST}</th>
</tr>
<!-- BEGIN topics -->
<tr>
<td class="row1" align="center"><span class="genmed"><img src="{similar.topics.FOLDER}" border="0" alt="{similar.topics.ALT}" title="{similar.topics.ALT}" /></span></td>
<td class="row1" width="30%">{similar.topics.NEWEST}<span class="gensmall">{similar.topics.TYPE}</span> <span class="topictitle">{similar.topics.TOPICS}</span></td>
<td class="row1" width="10%"><span class="genmed">{similar.topics.AUTHOR}</span></td>
<td class="row1"><span class="genmed">{similar.topics.FORUM}</span></td>
<td class="row1" width="15%" align="center"><span class="genmed">{similar.topics.REPLIES}</span></td>
<td class="row1"><span class="genmed">{similar.topics.POST_TIME} {similar.topics.POST_URL}</span></td>
</tr>
<!-- END topics -->
</table>
<!-- END similar -->
</td>
</tr>
</table>
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
