Pełna wersja: Unofficial modifications

**kidzior** Wysłany: Wto 30 Maj, 2006

Hey :)

B?edy wyst?puj? dwa:
1. Pierwszy ilustruje zdj?cie poni?ej.
Z tego co pami?tam, powinien by? jeszcze gdzie? chyba opis Forum :?:

2. Po klikni?ciu na Wy?lij mam B??d Og?lny:

KodB??d Og?lny
Couldn't insert row in forums table

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 ' 390, 0, 'SORT_FPDATE', '', '', 0, 0, 0, 2, 1, 0, '', 0, 0, 0, 3, 0, 0, '', 0, 0' at line 2

INSERT INTO phpbb_forums (forum_id, forum_name, cat_id, forum_desc,forum_image_url, forum_image_url_new, forum_order, forum_status, forum_sort, password, forum_color, forum_moderate, no_count, forum_trash, forum_separate, forum_show_ga, prune_enable, forum_link, forum_link_internal, forum_link_hit_count, forum_tree_req, forum_tree_grade, forum_no_helped, forum_no_split, topic_tags, locked_bottom, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_globalannounce, auth_vote, auth_pollcreate, auth_attachments, auth_download, main_type) VALUES ('33', 'xxx', 1, '','', '',, 390, 0, 'SORT_FPDATE', '', '', 0, 0, 0, 2, 1, 0, '', 0, 0, 0, 3, 0, 0, '', 0, 0, 0, 1, 0, 1, 1, 3, 3, 5, 1, 1, 1, 0, 'c')

Line : 825
File : admin_forums.php

Wklejam linie 820-830 z pliku admin_forums.php
PHP Code:<?php

$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc,forum_image_url, forum_image_url_new, forum_order, forum_status, forum_sort, password, forum_color, forum_moderate, no_count, forum_trash, forum_separate, forum_show_ga, prune_enable, forum_link, forum_link_internal, forum_link_hit_count, forum_tree_req, forum_tree_grade, forum_no_helped, forum_no_split, topic_tags, locked_bottom" . $field_sql . ") VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', $cat_id, '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "','" . str_replace("\'", "''", $HTTP_POST_VARS['forumimageurl']) . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumimageurlnew']) . "',, $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumsort']) . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['password']) . "', '" . str_replace("\'", "''", str_replace("#", "", $HTTP_POST_VARS['forum_color'])) . "', $post_moderate, $post_no_count, $forum_trash, " . intval($HTTP_POST_VARS['forum_separate']) . ", " . intval($HTTP_POST_VARS['forum_show_ga']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . ", '$forum_link', $forum_link_internal, $forum_link_hit_count, " . intval($HTTP_POST_VARS['forum_tree_req']) . ", " . intval($HTTP_POST_VARS['forum_tree_grade']) . ", " . intval($HTTP_POST_VARS['forum_no_helped']) . ", " . intval($HTTP_POST_VARS['forum_no_split']) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['topic_tags']) . "', $locked_bottom" . $value_sql . ")"; if( !$result = $db->sql_query($sql) ) { message_die(GENERAL_ERROR, "Couldn't insert row in forums table", "", __LINE__, __FILE__, $sql); } sql_cache('clear', 'multisqlcache_forum'); sql_cache('clear', 'forum_data'); admin_check_cat(); get_user_tree($userdata);

?>

No i co si? mog?o spsu? :?:

**qbs** Wysłany: Wto 30 Maj, 2006

co to za forum_image_url_new? :| a odnosnie braku pola opis - zle przerobiony plik stylu

**kidzior** Wysłany: Wto 30 Maj, 2006

qbs napisał/aco to za forum_image_url_new?
Zmodyfikowane nowe tematy. Ikonka si? mo?e np. migac przy nowych postach w danym forum. (Oczywi?cie przy obrazku odpowiednim migaj?cym si?. ;)

**qbs** Wysłany: Wto 30 Maj, 2006

a tak wogole to zauwazyles ze w zapytaniu masz 2 przecinki?
PHP Code:<?php

$HTTP_POST_VARS['forumimageurlnew']) . "',,

?>

**kidzior** Wysłany: Sro 31 Maj, 2006

qbs napisał/aa tak wogole to zauwazyles ze w zapytaniu masz 2 przecinki?
PHP Code:<?php

$HTTP_POST_VARS['forumimageurlnew']) . "',,

?>
Racja, racja. Poprawione i dzia?a. A gdzie mog?em co? popsu? konkretnie przy edytowaniu stylu? :oops:

Browarek si? nale?y.

**qbs** Wysłany: Sro 31 Maj, 2006

zapewne usuneles czesc odpowiedzialna za edycje opisu

**kidzior** Wysłany: Pon 12 Cze, 2006

qbs napisał/azapewne usuneles czesc odpowiedzialna za edycje opisu
Gdzie mog?em zrobi? b??d konkretnie? Za??czam m?j pliczek forum_admin_body.tpl, mam nadziej?, ze to on i kto? b?dzie w stanie mi pom?c. :oops: