I'd like a topic block

Worker Joined: Apr 30, 2005 Posts: 170

I'd like to make a block that lists all the topics from the topic module. How would I go about making something like that? Is there something out there that does that already?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Code:

<?php


/************************************************************************/


/* PHP-NUKE: Web Portal System                                          */


/* ===========================                                          */


/*                                                                      */


/* Copyright (c) 2002 by Francisco Burzi                                */


/* http://phpnuke.org                                                   */


/*                                                                      */


/* This program is free software. You can redistribute it and/or modify */


/* it under the terms of the GNU General Public License as published by */


/* the Free Software Foundation; either version 2 of the License.       */


/************************************************************************/


/************************************************************************/


/* Name:    block-Topics.php                                            */


/* Author:  Gaylen Fraley aka Raven                                     */


/* Support: http://ravenphpscripts.com http://ravenwebhosting.com       */


/* Date:    2005-08-08                                                  */


/* Purpose: List all Topics in a block rather than a module.            */


/* Usage:   Place this script in your nuke blocks folder. Then activate */


/*          it via ACP.                                                 */


/* License: GNU/GPL                                                     */


/* Warranty:None.  Proceed at your own risk.                            */


/************************************************************************/





if ( !defined('BLOCK_FILE') ) {


    Header("Location: index.php");


    die();


}





global $user_prefix, $db;





$sql     = "SELECT topicid, topicname, topicimage, topictext FROM ".$user_prefix."_topics ORDER BY topictext";


$result  = $db->sql_query($sql);


$numrows = $db->sql_numrows($result);


if ($numrows == 0) {


   $content = 'No topics to list';


} else {


   $boxstuff = "<font class=\"content\">";


   while ($row = $db->sql_fetchrow($result)) {


      $topicid   = intval($row['catid']);


      $topicname = $row['topicname'];


      $topictext = $row['topictext'];


      $boxstuff .= "<strong><big>&middot;</big></strong>&nbsp;<b>$topicname</b><br>";


   }


   $boxstuff .= "</font>";


   $content = $boxstuff;


 }


?>

Posted: Tue Aug 09, 2005 12:28 am

Thanks heaps!

Posted: Tue Aug 09, 2005 2:33 am

Hey Raven,

I'm getting this error "Safari can’t open the page.
Too many redirects occurred trying to open “http://www.jamenashshs.qld.edu.au/index.php”. This might occur if you open a page that is redirected to open another page which then is redirected to open the original page."

This occurs when I activate the block..

Any ideas?

Posted: Tue Aug 09, 2005 2:40 am

It looks like I was right.. It's not compatible with 7.8 I tried it in my site running 7.7, and it works. I was hoping that the topics would be clickable though. So that it would go to all the news stories under that topic.

This is all very educational all the same though. Smile

Posted: Tue Aug 09, 2005 7:25 am

See if this helps on the Safari error: [ Only registered users can see links on this board! Get registered or login! ]

Posted: Wed Aug 10, 2005 6:05 am

So, if I need to define the block file properly in my mainfile.php. What code do I need to enter. Is it like the stuff in the language files??