i am now in the message porting into jforum.
i found adding data to 3 tables to do the trick(jforum_topics,jforum_posts,jforum_posts_text).
however, there is a last_post_id,first_post_id in the topics table and a topic_id in the posts table. the ids are auto incremented so they are determined by the DB on insert.
how should i insert the data then, is this a 4 phase thing where i should:
1. insert a new topic |(withouth last/first_post_id)
2. insert post
3. insert post text
4. go back to topics tables and update last_first_post_id
is this the way or am i missing something
thanks. [originally posted on jforum.net by gkatz]
i am porting from my proprietry MessageBoard table into jforum tables structure.
i tool a look again @ jforum_topics and jforum_posts. they both have references to each others primary keys which are auto generated. what did i miss? [originally posted on jforum.net by gkatz]
Well, in jforum_posts the post_id is an auto_increment in fact, as well the topic_id in jforum_topics, But the relationship between them is done via SQL or Java code. So, for each jforum_topic where are one to many jforum_posts. You can take a look at src/net/jforum/view/forum/PostAction.java, src/net/jforum/drivers/generic/PostModel.java and src/net/jforum/drivers/generic/TopicModel.java.
Rafael [originally posted on jforum.net by Rafael Steil]
I wasn't selected to go to mars. This tiny ad got in ahead of me: