Witam!
Mam następujący problem : Parsując dane i zapisując je do bazy mysql forum phpbb3 ( czystego ) nie nastepuje zliczanie postów na tym forum. Zaznaczam że ani synchronizacja tematów ani postów i czyszczenie cache nic nie pomaga . Gdzie leży bład? oto kawałek kodu odpowiedzialny za wstawianie danych do bazy:
function add_topic($topic_title, $post, $forum_id) {
$db_host = '**********';
$db_user = '***********';
$db_pass = '**************';
$forum_id = (int)$forum_id;
$query1 = "INSERT INTO phpbb_topics
(forum_id, topic_approved, topic_title,
topic_first_post_id, topic_time, topic_views,
topic_poster, topic_first_poster_name,
topic_last_post_id, topic_last_poster_id, topic_last_poster_name,
topic_last_poster_colour, topic_last_post_subject,
topic_last_post_time, topic_last_view_time)
VALUES
('{$forum_id}' , '1' , '{$topic_title}' ,
'{$topic_first_post_id}' , '{$time}' , '1' ,
'2' , 'Monstershark' ,
'{$topic_first_post_id}' , '2' , 'Monstershark',
'AA0000' , '{$topic_title}' ,
'{$time}' , '{$time}')";
$query2 = "INSERT INTO phpbb_topics_posted (user_id, topic_id, topic_posted)
VALUES
('2' , '{$topic_id}' , '1')";
$query3 = "INSERT INTO phpbb_posts
(topic_id , forum_id , poster_id , icon_id , poster_ip , post_time , post_approved ,
enable_bbcode , enable_smilies , post_subject , post_text, enable_sig, bbcode_uid)
VALUES
('{$topic_id}' , '{$forum_id}' , '2' , '0' , '127.0.0.1' , '{$time}' , '1' ,
'1' , '1' , '{$topic_title}' , '{$post}' , 0 , '{$bbcode_uid}')";
$query4 = "UPDATE phpbb_topics SET (topic_first_post_id = '{$post_id}' , topic_last_post_id = '{$post_id}')
WHERE topic_id = '{$topic_id}' LIMIT 1";
}
Prosze o pomoc w rozwiązaniu tego problemu