Ich habe auch ein Problem mit dem Hack:
Jedes mal wenn ich versuche manuell eine neue Frage über den Adminpannel zu starten erscheint folgender Fehler:
Error in posting
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near ')' at line 1
INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig, post_icon) VALUES (76, 58, 41, '', 1039996026, 'd9522733', 1, 1, 1, 0, )
Line : 281
File : /home/www/web151/html/phpBB/includes/functions_post.php
Ich habe hier alles duchgelesen und versucht, aber nichts hat gewirkt. Ich habe auch den MessageIcon Hack und den Attachmenthack installiert. Ihr der Ausschnitt aus der functions_post.php
Code: Alles auswählen
249 }
250 }
251 else if ( $mode == 'editpost' )
252 {
253 remove_search_post($post_id);
254 }
255
256 if ( $mode == 'newtopic' || ( $mode == 'editpost' && $post_data['first_post'] ) )
257 {
258 $topic_vote = ( !empty($poll_title) && count($poll_options) >= 2 ) ? 1 : 0;
259
260 // BEGINN Quiz Hack
261 $quiz_sql1 = !empty($post_data['topic_quiz']) ? ', topic_quiz' : '';
262 $quiz_sql2 = !empty($post_data['topic_quiz']) ? ', 1' : '';
263 // END Quiz Hack
264
265 $sql = ( $mode != "editpost" ) ? "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote, topic_icon $quiz_sql1) VALUES ('$post_subject', " . $userdata['user_id'] . ", $current_time, $forum_id, " . TOPIC_UNLOCKED . ", $topic_type, $topic_vote, '$msg_icon' $quiz_sql2)" : "UPDATE " . TOPICS_TABLE . " SET topic_title = '$post_subject', topic_type = $topic_type, topic_vote = $topic_vote, topic_icon = $msg_icon WHERE topic_id = $topic_id";
266 if ( !$db->sql_query($sql) )
267 {
268 message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
269 }
270
271 if ( $mode == 'newtopic' )
272 {
273 $topic_id = $db->sql_nextid();
274 }
275 }
276
277 $edited_sql = ( $mode == 'editpost' && !$post_data['last_post'] && $post_data['poster_post'] ) ? ", post_edit_time = $current_time, post_edit_count = post_edit_count + 1 " : "";
278 $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, post_icon) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $attach_sig, $msg_icon)" : "UPDATE " . POSTS_TABLE . " SET enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig" . $edited_sql . ", post_icon = $msg_icon WHERE post_id = $post_id";
279 if ( !$db->sql_query($sql, BEGIN_TRANSACTION) )
280 {
281 message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
282 }
283
284 if ( $mode != 'editpost' )
285 {
286 $post_id = $db->sql_nextid();
287 }
288
289 // BEGINN Quiz Hack
Ich habe wirklich alles probiert, sogar auch einmal die Kommentare entfernt, woran es ja eigentlich nicht liegen kann *g*
Danke für die Hilfe
