Ticketyboo Shows unpublished pages
justin_nelson - August 12, 2009 - 15:48
| Project: | ticketyboo News Ticker |
| Version: | 6.x-1.3 |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
We've created a new Content Type called "Announcements". Showing ticker items by type works great. However when we pass the date an announcement is for an unpublish the page it still shows in the ticker.
#1
To fix Type filtering, change line 200 of ticketyboo.module to check for the status to be published :
$r = db_query("SELECT DISTINCT nid FROM {node} WHERE type ='%s' AND status = 1", trim($nodes));To fix Taxonomy filtering, change line 205 of ticketyboo.module to check for the status to be published (untested) :
$r = db_query("SELECT DISTINCT t.nid FROM {term_node} t, {node} n WHERE t.tid in (%s) AND t.nid = n.nid AND n.status = 1", $nodes);