post status “draft” or “published”

get_post_status() is there something that gives me the status??

You can grab it from the database, if you know how to retrieve things using MySQL.

To do what you’re looking for is gonna involve some quite extensive mods to the admin area, you’ll need to be very comfortable with PHP and MySQL. If you feel you’re up to it, then go for it! But I would suggest that you save the original file before making mods!

yeh; I know PHP and MYSQL.
And I thought of using them, but want to make sure if some one else have done it yet so I could grab it.

I think I will check the wp_posts table for that column storing the post status “draft, published, saved”, that was the easy part.
then I will add a column to the manage post table in admin section and populate it with the green or red images (depending on the post status).
then I will make an “onclick” function attached to those images which will do the actual job and update the wp_posts table (post status column) accordingly.

does that make sense??

this will enable me to list all my posts and give an over view of what is what. in addition can help me publish and draft them with one click.

i dunno if it’s exactly what you want, but check the plugins list cuz I’m pretty sure there is 1 that does something like that, as far as check-boxes for quickly changing from draft to published

do you have a name for this plugin? I could not find it ??

I did it. Almost. now it looks like this (messy yet but will be cleaned up soon):

https://img145.imageshack.us/my.php?image=postthingbo6.png

don’t be fooled by post tiltes, they are just there for testing. everythng is sortable you can sort your posts by ID, post title, post date, post status, what ever. Post title is clickable and brings you to edit post page.

when you click on the post status it does the followings:
– change the post_status from “draft2 to “publish” or other way around.
– it time stamp the “post_date” and “post_date_mgt” with now date and time.

however, posts that are being published in this way do not show up in the sites index page. what am I doing wrong. I went to the wp_posts table and compare a normal published post with one my published one and they were the same. they had the same parameters.

I guess I need to alter some other things somewhere else to make them really published. can someone help me please.

what do I need to change to make a post published?

thanks.

do I need to ping it? how do I do that?

OK, nobody,
I noticed that posts published in this way will show up after 2-3 hours on index page. why is that? timing problem?? ping thing??

please help.

https://img7.picsplace.to/img7/25/site_000.jpg

All right. figured out. what I was doing was that I assigned both date and date_gmt to the same thing and knowing the time zone has 2 hours offset posts published in manual way (my way) shows up 2 hours later.

just had to assign post_date_gmt to namely gmt offset date.
see below:

$date2 = date(“Y-m-d : H:i:s”);
$My_date_gmt = $post_date_gmt = get_gmt_from_date($date2);

//connect to database
mysql_query(“update wp_posts set post_status = ‘$post_status_change’, post_date_gmt = ‘$My_date_gmt’, post_date = ‘$date2′, post_modified =’$date1′, post_modified_gmt=’$date2’ where ID = ‘$post_id'”);

works fine now.

That’s very cool!!
So when you gonna make it a plugin?

KLM