• hello. ive searched for this and found one other post but it wasnt really what i was looking. Here is my q tho. Im going to make a direct insert into the database so that i can post new articles externally. The reason I am doing this is quite longwinded so I wont go into details, but it is my beleif that it the best way to achieve what i need to do. if you want more details ill tell ya. my point is, the insert will not be a problem, insert into wp_posts blah blah. and the catagorys. I am mostly concerned about the postmeta. see when i post an article through the sub panel of course WP makes all this nice fanct stuff in the postmeta table like :
    “a:6:{s:15:”itunes:subtitle”;s:15:”##PostExcerpt##”;s:14:”itunes:summary”;s:15:”##PostExcerpt##”;s:15:”itunes:keywords”;s:17:”##WordPressCats##”;s:13:”itunes:author”;s:10:”##Global##”;s:15:”itunes:explicit”;s:2:”No”;s:12:”itunes:block”;s:2:”No”;}”
    with the meta key “podPressPostSpecific” sometimes it is the same, and it seams sometimes its different. like a “_enclosement” or “enclosure” with a flag. i dont want to lose this stuff because I fear i may lose SEO without all that crazy stuff. I want to keep it automated by WP incase it has some kind of system that gives keys to certain things. BTW I am using the autometa Plugin too.
    do you think it would be possible to insert new articles externally and let WP take care of the postmeta data.
    I mean i suppose if i really wanted to i could just program my insert query script to do it, but I am a lazy SoB and I am looking for the easiest way possible.
    any help is appreciated. thanx.

    p.s. sry if this is in the wrong section i didnt really know what section to put it in

Viewing 5 replies - 1 through 5 (of 5 total)
  • what about wp_post2cat? You going to skip that one?

    You don’t want to go into details about your reasoning… but have you at least considered a Weblog_Client?

    Thread Starter chrisman826

    (@chrisman826)

    no, im not going to skip wp_post2cat that wont be a problem. weblog client wont work because i need to integrate with a web application that i am custom designing. here are some details:
    there is actually a seperate site that clients will be filling out a form, the form is submitted and stored in a database, which i view from my admin panel, and i then choose to publish it, in which case the article is directly inserted into the wp databse.

    it would be nice to just use the function that WP uses to insert a post, but which one would that be?

    Thread Starter chrisman826

    (@chrisman826)

    or pehaps i can just utilize xmlrpc? i dont really know what that is but i will guess that it is for doing stuff like what i need :P. more research to do!

    Thread Starter chrisman826

    (@chrisman826)

    ok wow i have it all figured out now, im going to write a killer script, ill post it up when i finish maybe someone else will want to use it??

    By all means, share a link to your script when done. Did you go with the xmlrpc option?

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Direct DB Insert’ is closed to new replies.