i dont see any easy way to do this via a link in php, i wish comment_post_ID could be used as an url parameter

..?ctrl=comments&action=publish&comment_post_ID=485

where as 485 being the post ID, However b2 requires comment_ID to perform the action, which does not make sense for mentioned operation..

But i agree, there's gotta be an easy button to publish/deprecate/delete ALL comments post-wise blog-wise and install-wise

Anyway, you can do it with a simple line mysql query through phpmyadmin

UPDATE `b2_db`.`evo_comments` SET `comment_status` = 'published' WHERE `evo_comments`.`comment_post_ID` =13 ;

being 'b2_db' your database, 13 your post's ID

Thanks, though looking at that table and your SQL, surely using WHERE IN(x, y, z) using the comment ID would work?

That way I could be more selective which I publish, rather than publish/draft all the comments for a post.

UPDATE `b2_db`.`evo_comments` SET `comment_status` = 'published' WHERE `evo_comments`.`comment_ID` IN (13,14,15,18,22);

What do you think?

eyehawk78 wrote:

Thanks, though looking at that table and your SQL, surely using WHERE IN(x, y, z) using the comment ID would work?

That way I could be more selective which I publish, rather than publish/draft all the comments for a post.

UPDATE `b2_db`.`evo_comments` SET `comment_status` = 'published' WHERE `evo_comments`.`comment_ID` IN (13,14,15,18,22);

What do you think?

agreed, i missed the "checkboxes" part.. thought you wanted to publish all of them then i assume you dont have to go to phpmyadmin..

you can just combine url

.../admin.php?ctrl=comments&action=publish&comment_ID=221&220

but i guess rather than looking up comment id's in status bar, simple mouse middle clicks would do faster