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:

  1. function add_topic($topic_title, $post, $forum_id) {
  2.  
  3. $db_host = '**********';
  4. $db_user = '***********';
  5. $db_pass = '**************';
  6. if (!$db = mysql_connect($db_host, $db_user, $db_pass))
  7. die('nie polaczono');
  8.  
  9. $topic_title = mysql_real_escape_string($topic_title);
  10. $post = mysql_real_escape_string($post);
  11. $forum_id = (int)$forum_id;
  12. $time = time();
  13.  
  14. mysql_select_db('**************');
  15.  
  16.  
  17. $query1 = "INSERT INTO phpbb_topics
  18. (forum_id, topic_approved, topic_title,
  19. topic_first_post_id, topic_time, topic_views,
  20. topic_poster, topic_first_poster_name,
  21. topic_last_post_id, topic_last_poster_id, topic_last_poster_name,
  22. topic_last_poster_colour, topic_last_post_subject,
  23. topic_last_post_time, topic_last_view_time)
  24.  
  25. VALUES
  26. ('{$forum_id}' , '1' , '{$topic_title}' ,
  27. '{$topic_first_post_id}' , '{$time}' , '1' ,
  28. '2' , 'Monstershark' ,
  29. '{$topic_first_post_id}' , '2' , 'Monstershark',
  30. 'AA0000' , '{$topic_title}' ,
  31. '{$time}' , '{$time}')";
  32.  
  33. mysql_query($query1);
  34. $topic_id = mysql_insert_id();
  35.  
  36.  
  37.  
  38.  
  39. $query2 = "INSERT INTO phpbb_topics_posted (user_id, topic_id, topic_posted)
  40. VALUES
  41. ('2' , '{$topic_id}' , '1')";
  42.  
  43. mysql_query($query2);
  44.  
  45. $bb_code_uid = substr(sha1(rand(0,9999999)),0,8);
  46.  
  47. $query3 = "INSERT INTO phpbb_posts
  48. (topic_id , forum_id , poster_id , icon_id , poster_ip , post_time , post_approved ,
  49. enable_bbcode , enable_smilies , post_subject , post_text, enable_sig, bbcode_uid)
  50. VALUES
  51. ('{$topic_id}' , '{$forum_id}' , '2' , '0' , '127.0.0.1' , '{$time}' , '1' ,
  52. '1' , '1' , '{$topic_title}' , '{$post}' , 0 , '{$bbcode_uid}')";
  53.  
  54. mysql_query($query3);
  55. $post_id = mysql_insert_id();
  56.  
  57. $query4 = "UPDATE phpbb_topics SET (topic_first_post_id = '{$post_id}' , topic_last_post_id = '{$post_id}')
  58. WHERE topic_id = '{$topic_id}' LIMIT 1";
  59.  
  60. mysql_query($query);
  61.  
  62.  
  63. }


Prosze o pomoc w rozwiązaniu tego problemu