phpBB.de

Verfasst: **30.12.2004 23:51**

Hallo zusammen,

hab mir den Forum Icon-Mod installiert und wollte nun im ACP ein Icon einem Forum zuweisen.
Als ich bestätigen wollte, kam folgende Meldung:

Couldn't update forum information

DEBUG MODE

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 ' = 0, forum_icon = 'faq.gif', prune_enable = 0 WHERE forum_

UPDATE phpbb_forums SET forum_name = 'FAQ (häufig gestellte Fragen)', cat_id = 2, forum_desc = 'Hier werden Antworten auf die am häufigsten gestellten Fragen über Schildkröten archiviert.', forum_status, = 0, forum_icon = 'faq.gif', prune_enable = 0 WHERE forum_id = 9

Line : 473
File : /homepages/14/d84923327/htdocs/Forum/admin/admin_forums.php

Was nun?
Wo liegt da der Fehler?

Grüße,
Dominik

Verfasst: **31.12.2004 00:10**

kannst du mal die entsprechende Query aus dem Code posten?

mfg Johny

Verfasst: **31.12.2004 00:17**

Was heißt Query

Meinst du die in der Anleitung geschriebenen Befehle?

Wenn ja:

#
#-----[ FIND ]------------------------------------------
#
if ($mode == 'editforum')
{
// $newmode determines if we are going to INSERT or UPDATE after posting?

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Forum Icon MOD
$dir = @opendir($phpbb_root_path . $board_config['forum_icon_path']);
$count = 0;
while( $file = @readdir($dir) )
{
if( !@is_dir(phpbb_realpath($phpbb_root_path . $board_config['forum_icon_path'] . '/' . $file)) )
{
if( preg_match('/(\.gif$|\.png$|\.jpg|\.jpeg)$/is', $file) )
{
$forum_icons[$count] = $file;
$count++;
}
}
}

@closedir($dir);

$forum_icons_list = "";
for( $i = 0; $i < count($forum_icons); $i++ )
{
if ($forum_icons[$i] == $row['forum_icon'])
$forum_icons_list .= '<option value="' . $forum_icons[$i] . '" selected="selected">' . $forum_icons[$i] . '</option>';
else
$forum_icons_list .= '<option value="' . $forum_icons[$i] . '">' . $forum_icons[$i] . '</option>';
$default_ficon = $forum_icons[0];
}

#
#-----[ FIND ]------------------------------------------
#
$forumstatus = $row['forum_status'];

#
#-----[ AFTER, ADD ]------------------------------------------
#
$forumicon = $row['forum_icon']; // Forum Icon MOD

#
#-----[ FIND ]------------------------------------------
#
$forumstatus = FORUM_UNLOCKED;

#
#-----[ AFTER, ADD ]------------------------------------------
#
$forumicon = ''; // Forum Icon MOD

#
#-----[ FIND ]------------------------------------------
#
'L_FORUM_STATUS' => $lang['Forum_status'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
'L_FORUM_ICON' => $lang['Forum_icon'], // Forum Icon MOD

#
#-----[ FIND ]------------------------------------------
#
'DESCRIPTION' => $forumdesc)

#
#-----[ REPLACE WITH ]------------------------------------------
#
'DESCRIPTION' => $forumdesc,
'ICON_LIST' => $forum_icons_list, // Forum Icon MOD
'ICON_BASEDIR' => $phpbb_root_path . $board_config['forum_icon_path'], // Forum Icon MOD
'ICON_IMG' => ( $forumicon ) ? $phpbb_root_path . $board_config['forum_icon_path'] . '/' . $forumicon : $phpbb_root_path . $board_config['forum_icon_path'] . '/' . $default_ficon // Forum Icon MOD
)

#
#-----[ FIND ]------------------------------------------
#
// There is no problem having duplicate forum names so we won't check for it.
$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable" . $field_sql . ")

#
#-----[ IN-LINE FIND ]------------------------------------------
#
forum_status

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, forum_icon

#
#-----[ FIND ]------------------------------------------
#
VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";

#
#-----[ IN-LINE FIND ]------------------------------------------
#
, " . intval($HTTP_POST_VARS['forumstatus']) . "

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "'

#
#-----[ FIND ]------------------------------------------
#
$sql = "UPDATE " . FORUMS_TABLE . "
SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
#
#-----[ IN-LINE FIND ]------------------------------------------
#
, forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . "

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, forum_icon = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "'

#
#-----[ FIND ]------------------------------------------
#
'FORUM_DESC' => $forum_rows[$j]['forum_desc'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
'FORUM_ICON_IMG' => ( $forum_rows[$j]['forum_icon'] ) ? '<img src="' . $phpbb_root_path . $board_config['forum_icon_path'] .'/' . $forum_rows[$j]['forum_icon'] . '" alt="'.$forum_data[$j]['forum_name'].'" title="'.$forum_data[$j]['forum_name'].'" />' : '', // Forum Icon Mod

Und das hier steht in meiner admin_forums.php-Datei:

#
#-----[ FIND ]------------------------------------------
#
if ($mode == 'editforum')
{
// $newmode determines if we are going to INSERT or UPDATE after posting?

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Forum Icon MOD
$dir = @opendir($phpbb_root_path . $board_config['forum_icon_path']);
$count = 0;
while( $file = @readdir($dir) )
{
if( !@is_dir(phpbb_realpath($phpbb_root_path . $board_config['forum_icon_path'] . '/' . $file)) )
{
if( preg_match('/(\.gif$|\.png$|\.jpg|\.jpeg)$/is', $file) )
{
$forum_icons[$count] = $file;
$count++;
}
}
}

@closedir($dir);

$forum_icons_list = "";
for( $i = 0; $i < count($forum_icons); $i++ )
{
if ($forum_icons[$i] == $row['forum_icon'])
$forum_icons_list .= '<option value="' . $forum_icons[$i] . '" selected="selected">' . $forum_icons[$i] . '</option>';
else
$forum_icons_list .= '<option value="' . $forum_icons[$i] . '">' . $forum_icons[$i] . '</option>';
$default_ficon = $forum_icons[0];
}

#
#-----[ FIND ]------------------------------------------
#
$forumstatus = $row['forum_status'];

#
#-----[ AFTER, ADD ]------------------------------------------
#
$forumicon = $row['forum_icon']; // Forum Icon MOD

#
#-----[ FIND ]------------------------------------------
#
$forumstatus = FORUM_UNLOCKED;

#
#-----[ AFTER, ADD ]------------------------------------------
#
$forumicon = ''; // Forum Icon MOD

#
#-----[ FIND ]------------------------------------------
#
'L_FORUM_STATUS' => $lang['Forum_status'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
'L_FORUM_ICON' => $lang['Forum_icon'], // Forum Icon MOD

#
#-----[ FIND ]------------------------------------------
#
'DESCRIPTION' => $forumdesc)

#
#-----[ REPLACE WITH ]------------------------------------------
#
'DESCRIPTION' => $forumdesc,
'ICON_LIST' => $forum_icons_list, // Forum Icon MOD
'ICON_BASEDIR' => $phpbb_root_path . $board_config['forum_icon_path'], // Forum Icon MOD
'ICON_IMG' => ( $forumicon ) ? $phpbb_root_path . $board_config['forum_icon_path'] . '/' . $forumicon : $phpbb_root_path . $board_config['forum_icon_path'] . '/' . $default_ficon // Forum Icon MOD
)

#
#-----[ FIND ]------------------------------------------
#
// There is no problem having duplicate forum names so we won't check for it.
$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable" . $field_sql . ")

#
#-----[ IN-LINE FIND ]------------------------------------------
#
forum_status

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, forum_icon

#
#-----[ FIND ]------------------------------------------
#
VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";

#
#-----[ IN-LINE FIND ]------------------------------------------
#
, " . intval($HTTP_POST_VARS['forumstatus']) . "

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "'

#
#-----[ FIND ]------------------------------------------
#
$sql = "UPDATE " . FORUMS_TABLE . "
SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
#
#-----[ IN-LINE FIND ]------------------------------------------
#
, forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . "

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, forum_icon = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "'

#
#-----[ FIND ]------------------------------------------
#
'FORUM_DESC' => $forum_rows[$j]['forum_desc'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
'FORUM_ICON_IMG' => ( $forum_rows[$j]['forum_icon'] ) ? '<img src="' . $phpbb_root_path . $board_config['forum_icon_path'] .'/' . $forum_rows[$j]['forum_icon'] . '" alt="'.$forum_data[$j]['forum_name'].'" title="'.$forum_data[$j]['forum_name'].'" />' : '', // Forum Icon Mod

Grüße,
Dominik

Verfasst: **31.12.2004 00:18**

und dann bräuchte ich noch die admin_forums.php als txt.

mfg Johny

Verfasst: **31.12.2004 00:22**

http://www.forum.schildkroeten-farm.de/admin_forums.txt

Verfasst: **31.12.2004 00:26**

suche:

Code: Alles auswählen

forum_status, = " . intval($HTTP_POST_VARS['forumstatus'])

ersetze mit

Code: Alles auswählen

forum_status = " . intval($HTTP_POST_VARS['forumstatus'])

Verfasst: **31.12.2004 00:42**

Dann mal vielen vielen Dank für die schnelle Hilfe!

phpBB.de

Fehler bei "Forum Icon" Mod!!!

Fehler bei "Forum Icon" Mod!!!