I am trying to create a block of comments that need approval. I have tried many iterations of ways to do this and I cannot figure it out. I would like to do this with views. If anyone can give me a suggestion I would appreciate it.
Thanks,
Steve
Steve Kessler
Denver DataMan
303-587-4428
http://www.denverdataman.com/content/enewsletter-signup Sign up for the Denver DataMan Free eNewsletter
this is what I have in a block, alongside some other stats:
<b><span style="color:red;"><?php $count_unpub_comm_tot = db_result(db_query("SELECT COUNT(cid) FROM {comments} WHERE `status` = 1")); echo $count_unpub_comm_tot; ?></span></b> <b>Un</b>published Comments
with Views, I imagine it would be even easier, no? Just use unpublished filter. Preferred to roll my own though.
Neil ----- Original Message ----- From: Steve Kessler To: support@drupal.org Sent: Thursday, July 30, 2009 2:28 PM Subject: [support] Comments needing approval block
I am trying to create a block of comments that need approval. I have tried many iterations of ways to do this and I cannot figure it out. I would like to do this with views. If anyone can give me a suggestion I would appreciate it.
Thanks,
Steve
Steve Kessler
Denver DataMan
303-587-4428
Sign up for the Denver DataMan Free eNewsletter
------------------------------------------------------------------------------
-- [ Drupal support list | http://lists.drupal.org/ ]
Thank you very much.
There does not appear to be published/unpublished toggle available in views.
Thanks,
Steve
Steve Kessler
Denver DataMan
303-587-4428
Sign up for the http://www.denverdataman.com/content/enewsletter-signup Denver DataMan Free eNewsletter
From: Neil Coghlan [mailto:neil@esl-lounge.com] Sent: Thursday, July 30, 2009 11:46 AM To: support@drupal.org Subject: Re: [support] Comments needing approval block
this is what I have in a block, alongside some other stats:
<b><span style="color:red;"><?php $count_unpub_comm_tot = db_result(db_query("SELECT COUNT(cid) FROM {comments} WHERE `status` = 1")); echo $count_unpub_comm_tot; ?></span></b> <b>Un</b>published Comments
with Views, I imagine it would be even easier, no? Just use unpublished filter. Preferred to roll my own though.
Neil
----- Original Message -----
From: Steve Kessler mailto:skessler@denverdataman.com
To: support@drupal.org
Sent: Thursday, July 30, 2009 2:28 PM
Subject: [support] Comments needing approval block
I am trying to create a block of comments that need approval. I have tried many iterations of ways to do this and I cannot figure it out. I would like to do this with views. If anyone can give me a suggestion I would appreciate it.
Thanks,
Steve
Steve Kessler
Denver DataMan
303-587-4428
Sign up for the http://www.denverdataman.com/content/enewsletter-signup Denver DataMan Free eNewsletter
_____
-- [ Drupal support list | http://lists.drupal.org/ ]
It's in Filters -> Node: Published.
On Thu, Jul 30, 2009 at 2:19 PM, Steve Kessler skessler@denverdataman.comwrote:
Thank you very much.
There does not appear to be published/unpublished toggle available in views.
Thanks,
Steve
Steve Kessler
*Denver DataMan *
303-587-4428
Sign up for the Denver DataMan Free eNewsletterhttp://www.denverdataman.com/content/enewsletter-signup
*From:* Neil Coghlan [mailto:neil@esl-lounge.com] *Sent:* Thursday, July 30, 2009 11:46 AM *To:* support@drupal.org *Subject:* Re: [support] Comments needing approval block
this is what I have in a block, alongside some other stats:
<b><span style="color:red;"><?php $count_unpub_comm_tot = db_result(db_query("SELECT COUNT(cid) FROM {comments} WHERE `status` = 1")); echo $count_unpub_comm_tot; ?></span></b> <b>Un</b>published Comments
with Views, I imagine it would be even easier, no? Just use unpublished filter. Preferred to roll my own though.
Neil
----- Original Message -----
*From:* Steve Kessler skessler@denverdataman.com
*To:* support@drupal.org
*Sent:* Thursday, July 30, 2009 2:28 PM
*Subject:* [support] Comments needing approval block
I am trying to create a block of comments that need approval. I have tried many iterations of ways to do this and I cannot figure it out. I would like to do this with views. If anyone can give me a suggestion I would appreciate it.
Thanks,
Steve
Steve Kessler
*Denver DataMan *
303-587-4428
Sign up for the Denver DataMan Free eNewsletterhttp://www.denverdataman.com/content/enewsletter-signup
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Sorry, misread that as nodes not comments.
Does *Filters -> Comment: In moderation* do what you want?
Brian
On Fri, Jul 31, 2009 at 6:37 PM, Brian Choc bchoc@t4tcolorado.org wrote:
It's in Filters -> Node: Published.
On Thu, Jul 30, 2009 at 2:19 PM, Steve Kessler <skessler@denverdataman.com
wrote:
Thank you very much.
There does not appear to be published/unpublished toggle available in views.
Thanks,
Steve
Steve Kessler
*Denver DataMan *
303-587-4428
Sign up for the Denver DataMan Free eNewsletterhttp://www.denverdataman.com/content/enewsletter-signup
*From:* Neil Coghlan [mailto:neil@esl-lounge.com] *Sent:* Thursday, July 30, 2009 11:46 AM *To:* support@drupal.org *Subject:* Re: [support] Comments needing approval block
this is what I have in a block, alongside some other stats:
<b><span style="color:red;"><?php $count_unpub_comm_tot = db_result(db_query("SELECT COUNT(cid) FROM {comments} WHERE `status` = 1")); echo $count_unpub_comm_tot; ?></span></b> <b>Un</b>published Comments
with Views, I imagine it would be even easier, no? Just use unpublished filter. Preferred to roll my own though.
Neil
----- Original Message -----
*From:* Steve Kessler skessler@denverdataman.com
*To:* support@drupal.org
*Sent:* Thursday, July 30, 2009 2:28 PM
*Subject:* [support] Comments needing approval block
I am trying to create a block of comments that need approval. I have tried many iterations of ways to do this and I cannot figure it out. I would like to do this with views. If anyone can give me a suggestion I would appreciate it.
Thanks,
Steve
Steve Kessler
*Denver DataMan *
303-587-4428
Sign up for the Denver DataMan Free eNewsletterhttp://www.denverdataman.com/content/enewsletter-signup
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Does not appear to.
Steve Kessler
Denver DataMan
303-587-4428
Sign http://www.denverdataman.com/content/enewsletter-signup up for the Denver DataMan Free eNewsletter
From: Brian Choc [mailto:bchoc@t4tcolorado.org] Sent: Friday, July 31, 2009 10:20 PM To: support@drupal.org Subject: Re: [support] Comments needing approval block
Sorry, misread that as nodes not comments.
Does Filters -> Comment: In moderation do what you want?
Brian
On Fri, Jul 31, 2009 at 6:37 PM, Brian Choc bchoc@t4tcolorado.org wrote:
It's in Filters -> Node: Published.
On Thu, Jul 30, 2009 at 2:19 PM, Steve Kessler skessler@denverdataman.com wrote:
Thank you very much.
There does not appear to be published/unpublished toggle available in views.
Thanks,
Steve
Steve Kessler
Denver DataMan
303-587-4428
Sign http://www.denverdataman.com/content/enewsletter-signup up for the Denver DataMan Free eNewsletter
From: Neil Coghlan [mailto:neil@esl-lounge.com] Sent: Thursday, July 30, 2009 11:46 AM To: support@drupal.org Subject: Re: [support] Comments needing approval block
this is what I have in a block, alongside some other stats:
<b><span style="color:red;"><?php $count_unpub_comm_tot = db_result(db_query("SELECT COUNT(cid) FROM {comments} WHERE `status` = 1")); echo $count_unpub_comm_tot; ?></span></b> <b>Un</b>published Comments
with Views, I imagine it would be even easier, no? Just use unpublished filter. Preferred to roll my own though.
Neil
----- Original Message -----
From: Steve Kessler mailto:skessler@denverdataman.com
To: support@drupal.org
Sent: Thursday, July 30, 2009 2:28 PM
Subject: [support] Comments needing approval block
I am trying to create a block of comments that need approval. I have tried many iterations of ways to do this and I cannot figure it out. I would like to do this with views. If anyone can give me a suggestion I would appreciate it.
Thanks,
Steve
Steve Kessler
Denver DataMan
303-587-4428
Sign http://www.denverdataman.com/content/enewsletter-signup up for the Denver DataMan Free eNewsletter
_____
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]