XoopsModules25x / smallworld

     * @param int $ownerID

     * @return array

     */

    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);

        $data = [];

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

            $data[] = $row;

        }

        return $data;

    }

    /**

     * Updates share link in dB

     * @param int $ownerID

     * @return array

     */

    public function updatesSharelink($updid, $ownerID)

    {

        $GLOBALS['xoopsLogger']->activated = false;

        //error_reporting(E_ALL);

        $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 = '" . (int)$updid . "'";

        $query  .= ' ORDER BY created DESC LIMIT 1';

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

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

        $data = [];

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

            $data[] = $row;

        }

        return $data;

    }

    /**

     * Get sharing HTML link