Does anybody here know how wordpress maps its categories? I've looked through the database, there's no key that I can find. The "post" table has a "categories" row but it's only populated with Zeros. Anybody know where this information is at? I will eventually figure it out, but I was hoping one of the dudes here might already have an idea. For those of you who have no idea what any of this is about, but chose to visit my thread anyway, here is a kittah: <img src="http://icanhascheezburger.files.wordpress.com/2009/09/funny-pictures-cat-watches-scary-movie.jpg" /> 2009-09-15T17:11:46-04:00 8 2009-09-14T17:27:00-04:00 true 0 77041 false false 997 997 1 2009-11-21T04:49:36-05:00 147 I could not halllppp... I failed. Anyone else want to help the good man? (aka BUMPPPP!) 77041 Post 2009-09-14T17:41:22-04:00 2472281 1514 2009-09-14T17:41:22-04:00 No idea what you are on about but you have a nice pussy. 77041 Post 2009-09-14T17:43:47-04:00 2472311 12032 2009-09-14T17:43:47-04:00 Thanks for the try dude! Putting it out there: I'm not looking to manipulate wordpress code at all. I am writing a standalone script that is going to piggyback off of wordpresses database. I can't figure out how they handle categories though. 77041 Post 2009-09-14T17:43:59-04:00 2472321 997 2009-09-14T17:43:59-04:00 I am glad that you like my pussy. 77041 Post 2009-09-14T17:46:23-04:00 2472351 997 2009-09-14T17:46:23-04:00 May very well not be in database. I rember trying to butcher my textpattern cms db only to find that some stuff is stored in other code, like xml 77041 Post 2009-09-14T17:52:23-04:00 2472431 7859 2009-09-14T17:52:49-04:00 Yeah, I am thinking it's in the filesystem somewhere. Looking for it now. 77041 Post 2009-09-14T19:06:57-04:00 2473231 997 2009-09-14T19:06:57-04:00 Maybe this might help. <a href="http://codex.wordpress.org/images/8/83/WP_27_dbsERD.png"><img src="http://codex.wordpress.org/images/8/83/WP_27_dbsERD.png" /></a> It might use a different naming convention. wp_terms might be a good place to start. I'll be on chat later if you need to talk Nick. Wordpress is not as xml reliant as some of the other CMS out there. Now look what you did, made me sound geeky. haha. ;) 77041 Post 2009-09-15T09:43:29-04:00 2481421 303 2009-09-15T09:48:21-04:00 I know what you're saying, and thank you for the diagram, but I have been through the database. There is a "post_category" column, but it's just set to the default value. I have also thoroughly browsed the DB looking for any patterns I could relate to the simple categories structure. It's jut not in there. :\ I have been all up in that crap with PHPMyAdmin. I think I'm just going to include the wp_load.php file in my script and use the regular wordpress calls to manipulate categories for me. Seems simple enough. 77041 Post 2009-09-15T17:11:46-04:00 2488521 997 2009-09-15T17:11:46-04:00