View Full Version : Simple list of articles from CMS_Node
charlesr
05-29-2013, 05:25 AM
Would it be possible to generate a page with a simple text/hyperlink list of all articles along with basics like author (which would link to their articles), section (with link to that section), categories (with links), publish date, etc.
Lynne
05-29-2013, 02:03 PM
Short answer - yes, it would be possible.
Long answer - I don't have the code handy, if that is what you are actually asking for. I do have this code which I had posted earlier for someone to get the article titles in a specific section:
$myquery2 =vB::$vbulletin->db->query_read_slave($myquery = "SELECT cms_nodeinfo.title AS title FROM cms_nodeinfo RIGHT JOIN cms_node ON (cms_node.nodeid=cms_nodeinfo.nodeid) WHERE cms_node.parentnode = 2 AND cms_node.contenttypeid = 18");
while ($myarts = vB::$vbulletin->db->fetch_array($myquery2))
{
$output .= $myarts['title']."<br />";
}
So, feel free to modify that for your own needs.
charlesr
05-29-2013, 04:01 PM
Thanks. I will have a go.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.