Recent Topics

1 Jul 01, 2010 22:27    

My b2evolution Version: 2.x

I must be missing something obvious here. I'm running b2evolution at:

http://shininghappypeople.net/blogs/kazan-2010.php

I'm trying to figure out where a posting's blog_ID is located in evo_items__item. None of the categories seem to have a direct representation the blog_ID, so how does b2e know which blog to display a particular item in?

The categories I see there are:

post_ID
post_parent_ID
post_creator_user_ID
post_lastedit_user_ID
post_assigned_user_ID
post_datestart
post_datedeadline
post_datecreated
post_datemodified
post_status
post_pst_ID
post_ptyp_ID
post_locale
post_content
post_excerpt
post_title
post_urltitle
post_url
post_main_cat_ID
post_notifications_status
post_notifications_ctsk_ID
post_views
post_wordcount
post_comment_status
post_commentsexpire
post_renderers
post_priority
post_order
post_featured

2 Jul 02, 2010 03:11

Each post is linked to a category (evo_postcats) while each category is linked to a blog (evo_categories -> cat_blog_ID)

3 Jul 02, 2010 08:27

Now I see. So to get the blog ID I have to do a join in sql. [Pause to write query.] Success! Thanks!


Form is loading...