MOD-post_icons

[frank1606]

Hallo

habe den o.g Mod installiert.
Nur wenn ich etwas Posten will kommt folgende Meldung

Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' 0)' at line 1

INSERT INTO 2133_posts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, an_option, enable_sig, post_icon) VALUES (426, 75, 2, 'etz', 1093172766, 'd5c4f2f8', 1, 1, 1, 1, , 0)

Line : 294
File : /www/htdocs/xxx/phpbb2/includes/functions_post.php
Habe das db-update erfolgreich ausgeführt

Was habe ich falsch gemacht??
Danke

[Markus67]

Hi ...

post_icon) VALUES (426, 75, 2, 'etz', 1093172766, 'd5c4f2f8', 1, 1, 1, 1, , 0)

Das ist wohl irgendwas zuviel ...

Speichere mal die functions_post.php als txt-Datei und verlinke sie hier ...
KB:datei

Markus

[frank1606]

Hallo

hier der Text

http://www.tierfreunde-forum.net/functions_post.txt

[Markus67]

Hi ...

du hast da was vergessen ...

suche in der functions_post.php

Code: Alles auswählen

function submit_post($mode, &$post_data, &$message, &$meta, &$forum_id, &$topic_id, &$post_id, &$poll_id, &$topic_type, &$bbcode_on, &$html_on, &$smilies_on, &$an_option, &$an_option, &$attach_sig, &$bbcode_uid, &$post_username, &$post_subject, &$post_extra, &$post_message, &$poll_title, &$poll_options, &$poll_length)

ersetze mit:

Code: Alles auswählen

function submit_post($mode, &$post_data, &$message, &$meta, &$forum_id, &$topic_id, &$post_id, &$poll_id, &$topic_type, &$bbcode_on, &$html_on, &$smilies_on, &$an_option, &$an_option, &$attach_sig, &$bbcode_uid, &$post_username, &$post_subject, &$post_extra, &$post_message, &$poll_title, &$poll_options, &$poll_length, $post_icon = 0)

suche:

Code: Alles auswählen

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

ersetze mit:

Code: Alles auswählen

		$sql  = ($mode != "editpost") ? "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_extra, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_icon, topic_vote) VALUES ('$post_subject', '$post_extra', " . $userdata['user_id'] . ", $current_time, $forum_id, " . TOPIC_UNLOCKED . ", $topic_type, $post_icon, $topic_vote)" : "UPDATE " . TOPICS_TABLE . " SET topic_title = '$post_subject', topic_extra = '$post_extra', topic_type = $topic_type, topic_icon=$post_icon " . (($post_data['edit_vote'] || !empty($poll_title)) ? ", topic_vote = " . $topic_vote : "") . " WHERE topic_id = $topic_id";

suche:

Code: Alles auswählen

	$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, an_option, enable_sig) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $an_option, $attach_sig)" : "UPDATE " . POSTS_TABLE . " SET post_username = '$post_username', enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, an_option = $an_option, enable_sig = $attach_sig" . $edited_sql . " WHERE post_id = $post_id";

ersetze mit:

Code: Alles auswählen

	$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, an_option, enable_sig, post_icon) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $an_option, $attach_sig, $post_icon)" : "UPDATE " . POSTS_TABLE . " SET post_username = '$post_username', enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, an_option = $an_option, enable_sig = $attach_sig, post_icon = $post_icon" . $edited_sql . " WHERE post_id = $post_id";

Hattest du die Datei überhaupt entsprechend der Anleitung editiert ?

Markus

[frank1606]

Hallo

ich habe sie edetiert.
Habe es eingefügt , aber es klappt immer noch nicht

Allgemeiner Fehler

Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' 0)' at line 1

INSERT INTO 2133_posts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, an_option, enable_sig, post_icon) VALUES (548, 58, 2, 'test', 1093197799, '51adb3d4', 1, 1, 1, 1, , 0)

Line : 293
File : /www/htdocs/xxx/phpbb2/includes/functions_post.php

[Markus67]

Hi ...

nimm mal diese hier ...

funktions_post

Markus

[frank1606]

Hallo
mit dieser datei bekomme ich folgenden fehler angezeigt.

Parse error: parse error, unexpected '=' in /www/htdocs/xxx/phpbb2/includes/functions_post.php on line 268

Fatal error: Call to undefined function: generate_smilies() in /www/htdocs/xxx/phpbb2/posting.php on line 998

Oh mann ,hätte ich das vorher gewusst ,hätte ich das Teil nicht eingebaut

[Markus67]

Hi ...

na dann brauchen wir nun die posting.php als txt-Datei

Markus

[frank1606]

Hier die Posting.php als txt.

http://www.tierfreunde-forum.net/posting.txt

[Markus67]

Hi ...

posting.php ist ok.... zumindest wenn es vorher funktioniert hat ...

Ich werde mir die functions_post.php nochmal ansehen ...

Markus