src/snac/server/database/SQL.php
/**
     * Select Constellations User Recently Edited
     *
     * Gets a list of the version history id, version that have been recently edited
     * by the user (even if they have been published by someone else later.
     *
     * @param integer $appUserID The user ID to query
     * @param integer $limit The maximum number of results to return
     * @param integer $offset Where in the list of results to start
     * @return string[][] The list of ic_id and version numbers recently edited
     */
Select Constellations User Recently Edited
Gets a list of the version history id, version that have been recently edited
by the user (even if they have been published by someone else later.

@param integer $appUserID The user ID to query
@param integer $limit The maximum number of results to return
@param integer $offset Where in the list of results to start
@return string[][] The list of ic_id and version numbers recently edited
Select Constellations User Recently Edited Gets a list of the version history id version that have been recently edited by the user ( even if they have been published by someone else later . @param integer $appUserID The user ID to query @param integer $limit The maximum number of results to return @param integer $offset Where in the list of results to start @return string [] [] The list of ic_id and version numbers recently edited
public function selectConstellationsUserEdited($appUserID, $limit, $offset)
    {
        $limitStr = '';
        $offsetStr = '';
        $limitStr = $this->doLOValue('limit', $limit);
        $offsetStr = $this->doLOValue('offset', $offset);
        $queryString = sprintf(
            'select id as ic_id, max(version) as latest_version from
                (select distinct id, version from version_history where user_id = $1) as a
                group by id order by latest_version desc %s %s;', $limitStr, $offsetStr);
        $this->logger->addDebug("Sending the following SQL request: " . $queryString);
        $result = $this->sdb->query($queryString,
                                    array($appUserID));
        $this->logger->addDebug("Done request");
        $all = array();
        while($row = $this->sdb->fetchrow($result)) {
            array_push($all, $row);
        }
        return $all;
    }
public function selectConstellationsUserEdited ( $ appUserID , $ limit , $ offset ) { $ limitStr = '' ; $ offsetStr = '' ; $ limitStr = $ this -> doLOValue ( 'limit' , $ limit ) ; $ offsetStr = $ this -> doLOValue ( 'offset' , $ offset ) ; $ queryString = sprintf ( 'select id as ic_id, max(version) as latest_version from
                (select distinct id, version from version_history where user_id = $1) as a
                group by id order by latest_version desc %s %s;' , $ limitStr , $ offsetStr ) ; $ this -> logger -> addDebug ( " Sending the following SQL request:  " . $ queryString ) ; $ result = $ this -> sdb -> query ( $ queryString , array ( $ appUserID ) ) ; $ this -> logger -> addDebug ( " Done request " ) ; $ all = array ( ) ; while ( $ row = $ this -> sdb -> fetchrow ( $ result ) ) { array_push ( $ all , $ row ) ; } return $ all ; }
Select Constellations User Recently Edited
 Gets a list of the version history id, version that have been recently edited
 by the user (even if they have been published by someone else later.
Select Constellations User Recently Edited Gets a list of the version history id version that have been recently edited by the user ( even if they have been published by someone else later .