Geeklog Forums

<?php and ?>

-------------------------------------------------------------------------------

<?php
function Headlines($topic_id)
{
    global $_TABLES, $_GROUPS, $_USER;

    /***************************************************************************/
    /*  Set these configuration variables to meet your website's requirements  */
    /***************************************************************************/

    // maximum number of stories to display under each topic.  
    $num_stories = 3;

    // if you want to display stories only within a certain time interval, then
    // uncomment and set this variable to the desired time frame.  If set to zero
    // or if left commented out, all stories will be displayed up to the max number
    // desired ($num_stories) regardless of time period.
    // $newstoriesinterval = 86400;   // this time is in seconds (86400 = 24 hours)

    // maximum number of characters to display in a story's title
    $max_title_length = 20;

    /****************************************************************************/
    /*  Please do not modify the code below unless you know what you are doing  */
    /****************************************************************************/

    // initialize variables
    $display    = '';
    $group_list = '';
    $perms      = '';

    // return empty string if variables are not set properly or user has no access
    if (!isset($topic_id) OR (sizeof($topic_id) < 1) OR
        !isset($num_stories) OR !is_numeric($num_stories) OR
        !SEC_hasTopicAccess($topic_id)) {
        return $display;
    }

    // get a listing of all groups to which the visitor belongs
    if (!empty($_USER['uid'])) {
        foreach ($_GROUPS as $grp) {
            $group_list .= $grp . ',';
        }
        $group_list = substr($group_list, 0, -1);
    }

    // set up the permission checker
    if (!empty( $_USER['uid'])) {
        $perms .= "(owner_id = {$_USER['uid']} AND perm_owner >= 2) OR ";
        $perms .= "(group_id IN ($group_list) AND perm_group >= 2) OR ";
        $perms .= '(perm_members >= 2) OR ';
    }
    $perms .= '(perm_anon >= 2)';

    // pull only the stories the visitor is allowed to view
    $sql = "SELECT title, sid FROM {$_TABLES['stories']} WHERE ";
    if (isset($newstoriesinterval) AND (is_numeric($newstoriesinterval)) AND
        ($newstoriesinterval > 0)) {
        $sql .= "(date >= (NOW() - INTERVAL {$newstoriesinterval} SECOND)) AND ";
    }
    $sql .= "(date <= NOW()) AND (draft_flag = 0) AND (tid='$topic_id') AND ($perms)
ORDER BY date DESC, sid DESC LIMIT $num_stories";

    $result  = DB_query($sql,0);
    $numrows = DB_numRows($result);

    // continue on only if there is data to process
    if ($numrows >= 1) {

        // pull each story this particular topic
        for ($count = 0; $count < $numrows; $count++) {
            $row   = DB_fetchArray($result);
            $story_title = $row['title'];
            $sid   = $row['sid'];

            // shorten the story's title if it's too long to fit nicely in the space
            if (isset($max_title_length) AND is_numeric($max_title_length)) {
                $title_length = strlen($story_title);
                if ($title_length > $max_title_length) {
                    $story_title = substr($story_title, 0, ($max_title_length - 3));
                    $story_title = str_replace('$', '$', $story_title) . '...';
                    $story_title = str_replace(' ', ' ', $story_title);
                }
            } // end if

            // display the title with url for each story
            $display .= '<a href="' . $_CONF['site_url'] . '/article.php?story='
. $sid . '">' . $story_title . '</a><br />';

        }  // end for

    } // end if

    // return output to display
    return $display;

} // end function Headlines

?>