XoopsModules25x / smallworld

     * @param int $ownerID

     * @return array|bool

     */

    public function updatesPermalink($updid, $uid, $ownerID)

    {

        $query  = 'SELECT M.msg_id, M.uid_fk, M.message, M.created, M.priv, U.username FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_messages') . ' M, ' . $GLOBALS['xoopsDB']->prefix('smallworld_user') . " U  WHERE M.uid_fk=U.userid AND M.uid_fk='" . $ownerID . "'";

        $query  .= " AND M.msg_id = '" . $updid . "'";

        $query  .= ' order by M.created DESC LIMIT 1';

        $result = $GLOBALS['xoopsDB']->queryF($query);

        $count  = $GLOBALS['xoopsDB']->getRowsNum($result);

        if ($count < 1) {

            return false;

        }

        while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {

            $data[] = $row;

        }

        if (!empty($data)) {

            return $data;

        }

    }

    /**

     * Get share link

     * @param int $ownerID

     * @return array|bool

     */

    public function updatesSharelink($updid, $ownerID)

    {

        $query  = 'SELECT M.msg_id, M.uid_fk, M.message, M.created, M.priv, U.username FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_messages') . ' M, ' . $GLOBALS['xoopsDB']->prefix('smallworld_user') . " U WHERE M.uid_fk=U.userid AND M.uid_fk='" . $ownerID . "' AND M.priv = 0";

        $query  .= " AND M.msg_id = '" . $updid . "'";

        $query  .= ' order by created DESC LIMIT 1';

        $result = $GLOBALS['xoopsDB']->queryF($query);

        $count  = $GLOBALS['xoopsDB']->getRowsNum($result);

        if ($count < 1) {

            return false;

        }

        while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {

            $data[] = $row;

        }

        if (!empty($data)) {

            return $data;

        }

    }

    /**

     * @Get sharing link