mambax7 / alumni-26x

        global $xoopsDB;

        if ('category' === $category) {

            // Assume we have a valid topid id

            $sql          = 'SELECT title  FROM ' . $xoopsDB->prefix('alumni_categories') . ' WHERE cid = ' . $item_id . ' LIMIT 1';

            $result       = $xoopsDB->query($sql); // TODO: error check

            $result_array = $xoopsDB->fetchArray($result);

            $item['name'] = $result_array['title'];

            $item['url']  = XOOPS_URL . '/modules/' . $module->getVar('dirname') . '/categories.php?cid=' . $item_id;

            return $item;

        }

        if ('listing' === $category) {

            // Assume we have a valid post id

            return $item;

        }

        if ('listing' === $category) {

            // Assume we have a valid post id

            $sql          = 'SELECT title FROM ' . $xoopsDB->prefix('alumni_listing') . ' WHERE lid = ' . $item_id . ' LIMIT 1';

            $result       = $xoopsDB->query($sql);

            $result_array = $xoopsDB->fetchArray($result);

            $item['name'] = $result_array['title'];

            $item['url']  = XOOPS_URL . '/modules/' . $module->getVar('dirname') . '/listing.php?lid= ' . $item_id;

            return $item;

        }

        return $item;

    }