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