Code: Alles auswählen
SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND p.post_id = t.topic_last_post_id FROM_UNIXTIME(p.post_tim
SELECT t.*, p.poster_id, p.post_username AS last_poster_name, p.post_id, p.post_time, f.forum_name, f.forum_id, u.username AS last_poster, u.user_id AS last_poster_id, u2.username AS first_poster, u2.user_id AS first_poster_id, p2.post_username AS first_poster_name FROM orion_topics t, orion_posts p LEFT OUTER JOIN orion_posts p2 ON p2.post_id = t.topic_first_post_id LEFT OUTER JOIN orion_forums f ON p.forum_id = f.forum_id LEFT OUTER JOIN orion_users u ON p.poster_id = u.user_id LEFT OUTER JOIN orion_users u2 ON u2.user_id = t.topic_poster WHERE t.forum_id NOT IN ('start') AND t.forum_id IN () AND p.post_id = t.topic_last_post_id FROM_UNIXTIME(p.post_time,'%Y%m%d') - FROM_UNIXTIME(unix_timestamp(NOW()),'%Y%m%d') = 0 ORDER BY t.topic_last_post_id DESC LIMIT 0, 10
Line : 127
File : recent.phpCode: Alles auswählen
default:
$message = $lang['Recent_wrong_mode'] .'<br /><br />'. sprintf($lang['Recent_click_return'], '<a href="'. append_sid("recent.$phpEx") .'">', '</a>') .'<br />'. sprintf($lang['Click_return_index'], '<a href="'. append_sid("index.$phpEx") .'">', '</a>');
message_die(GENERAL_MESSAGE, $message);
break;
}
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'could not obtain main information.', '', __LINE__, __FILE__, $sql);
}
$line = array();
while( $row = $db->sql_fetchrow($result) )
{
$line[] = $row;
}
$db->sql_freeresult($result);
$template->set_filenames(array('body' => 'recent_body.tpl'));
$orig_word = array();
$replacement_word = array();
obtain_word_list($orig_word, $replacement_word);