classes/paper/PublishedPaperDAO.inc.php

Go to the documentation of this file.

<?php

//$Id$

import('paper.PublishedPaper');

define('PAPER_SORT_ORDER_NATURAL', 0);
define('PAPER_SORT_ORDER_TIME', 1);

class PublishedPaperDAO extends DAO {
   var $paperDao;
   var $authorDao;
   var $galleyDao;
   var $suppFileDao;

   function PublishedPaperDAO() {
      parent::DAO();
      $this->paperDao =& DAORegistry::getDAO('PaperDAO');
      $this->authorDao =& DAORegistry::getDAO('AuthorDAO');
      $this->galleyDao =& DAORegistry::getDAO('PaperGalleyDAO');
      $this->suppFileDao =& DAORegistry::getDAO('SuppFileDAO');
   }

   function &getPublishedPapers($schedConfId, $sortOrder = PAPER_SORT_ORDER_NATURAL) {
      $primaryLocale = AppLocale::getPrimaryLocale();
      $locale = AppLocale::getLocale();

      $params = array(
         'title',
         $primaryLocale,
         'title',
         $locale,
         'abbrev',
         $primaryLocale,
         'abbrev',
         $locale,
         $schedConfId
      );

      $publishedPapers = array();

      $sql = 'SELECT pp.*,
            p.*,
            COALESCE(ttl.setting_value, ttpl.setting_value) AS track_title,
            COALESCE(tal.setting_value, tapl.setting_value) AS track_abbrev,
            t.seq AS track_seq, pp.seq
         FROM  published_papers pp,
            papers p
            LEFT JOIN tracks t ON t.track_id = p.track_id
            LEFT JOIN track_settings ttpl ON (t.track_id = ttpl.track_id AND ttpl.setting_name = ? AND ttpl.locale = ?)
            LEFT JOIN track_settings ttl ON (t.track_id = ttl.track_id AND ttl.setting_name = ? AND ttl.locale = ?)
            LEFT JOIN track_settings tapl ON (t.track_id = tapl.track_id AND tapl.setting_name = ? AND tapl.locale = ?)
            LEFT JOIN track_settings tal ON (t.track_id = tal.track_id AND tal.setting_name = ? AND tal.locale = ?)
         WHERE pp.paper_id = p.paper_id
            AND pp.sched_conf_id = ?
            AND p.status = ' . STATUS_PUBLISHED;

      switch ($sortOrder) {
         case PAPER_SORT_ORDER_TIME:
            $sql .= ' ORDER BY p.start_time ASC, p.end_time ASC';
            break;
         case PAPER_SORT_ORDER_NATURAL:
         default:
            $sql .= ' ORDER BY track_seq ASC, pp.seq ASC';
            break;
      }

      $result =& $this->retrieve($sql, $params);
      $returner = new DAOResultFactory($result, $this, '_returnPublishedPaperFromRow');
      return $returner;
   }

   function getPublishedPaperCountBySchedConfId($schedConfId) {
      $result =& $this->retrieve(
         'SELECT count(*) FROM published_papers pa, papers a WHERE pa.paper_id = a.paper_id AND a.sched_conf_id = ? AND a.status = ' . STATUS_PUBLISHED,
         $schedConfId
      );
      list($count) = $result->fields;
      $result->Close();
      return $count;
   }

   function &getPublishedPapersBySchedConfId($schedConfId, $rangeInfo = null) {
      $primaryLocale = AppLocale::getPrimaryLocale();
      $locale = AppLocale::getLocale();

      $result =& $this->retrieveRange(
         'SELECT pp.*,
            p.*,
            COALESCE(ttl.setting_value, ttpl.setting_value) AS track_title,
            COALESCE(tal.setting_value, tapl.setting_value) AS track_abbrev
         FROM published_papers pp,
            papers p
            LEFT JOIN tracks t ON t.track_id = p.track_id
            LEFT JOIN track_settings ttpl ON (t.track_id = ttpl.track_id AND ttpl.setting_name = ? AND ttpl.locale = ?)
            LEFT JOIN track_settings ttl ON (t.track_id = ttl.track_id AND ttl.setting_name = ? AND ttl.locale = ?)
            LEFT JOIN track_settings tapl ON (t.track_id = tapl.track_id AND tapl.setting_name = ? AND tapl.locale = ?)
            LEFT JOIN track_settings tal ON (t.track_id = tal.track_id AND tal.setting_name = ? AND tal.locale = ?)
         WHERE pp.paper_id = p.paper_id
            AND p.sched_conf_id = ?
            AND p.status = ' . STATUS_PUBLISHED,
         array(
            'title',
            $primaryLocale,
            'title',
            $locale,
            'abbrev',
            $primaryLocale,
            'abbrev',
            $locale,
            $schedConfId
         ),
         $rangeInfo
      );

      $returner = new DAOResultFactory($result, $this, '_returnPublishedPaperFromRow');
      return $returner;
   }

   function &getPublishedPapersInTracks($schedConfId, $trackId = null, $searchField = null, $searchMatch = null, $search = null, $previewAbstracts = false) {
      $primaryLocale = AppLocale::getPrimaryLocale();
      $locale = AppLocale::getLocale();

      $publishedPapers = array();

      $params = array(
         'title', // Paper title
         $primaryLocale,
         'title', // Paper title
         $locale,
         'title', // Track title
         $primaryLocale,
         'title', // Track title
         $locale,
         'abbrev',
         $primaryLocale,
         'abbrev',
         $locale,
         $schedConfId
      );

      if ($trackId) $params[] = $trackId;
      $searchSql = '';
      if (!empty($search)) switch ($searchField) {
         case SUBMISSION_FIELD_TITLE:
            if ($searchMatch === 'is') {
               $searchSql = ' AND LOWER(COALESCE(ptl.setting_value, ptpl.setting_value)) = LOWER(?)';
            } else {
               $searchSql = ' AND LOWER(COALESCE(ptl.setting_value, ptpl.setting_value)) LIKE LOWER(?)';
               $search = '%' . $search . '%';
            }
            $params[] = $search;
            break;
         case SUBMISSION_FIELD_AUTHOR:
            $directorSubmissionDao =& DAORegistry::getDAO('DirectorSubmissionDAO');
            $searchSql = $directorSubmissionDao->_generateUserNameSearchSQL($search, $searchMatch, 'pp.', $params);
            break;
      }

      $result =& $this->retrieve(
         'SELECT DISTINCT
            pa.*,
            p.*,
            COALESCE(ttl.setting_value, ttpl.setting_value) AS track_title,
            COALESCE(tal.setting_value, tapl.setting_value) AS track_abbrev,
            t.seq AS track_seq,
            pa.seq
         FROM  paper_authors pp,
            papers p
            LEFT JOIN published_papers pa ON (p.paper_id = pa.paper_id)
            LEFT JOIN paper_settings ptl ON (p.paper_id = ptl.paper_id AND ptl.setting_name = ? AND ptl.locale = ?)
            LEFT JOIN paper_settings ptpl ON (p.paper_id = ptpl.paper_id AND ptpl.setting_name = ? AND ptpl.locale = ?)
            LEFT JOIN tracks t ON t.track_id = p.track_id
            LEFT JOIN track_settings ttpl ON (t.track_id = ttpl.track_id AND ttpl.setting_name = ? AND ttpl.locale = ?)
            LEFT JOIN track_settings ttl ON (t.track_id = ttl.track_id AND ttl.setting_name = ? AND ttl.locale = ?)
            LEFT JOIN track_settings tapl ON (t.track_id = tapl.track_id AND tapl.setting_name = ? AND tapl.locale = ?)
            LEFT JOIN track_settings tal ON (t.track_id = tal.track_id AND tal.setting_name = ? AND tal.locale = ?)
         WHERE p.sched_conf_id = ?
            AND (
               (p.status = ' . STATUS_PUBLISHED . ' AND pa.paper_id IS NOT NULL)' .
               ($previewAbstracts ? 'OR (p.review_mode <> ' . REVIEW_MODE_BOTH_SIMULTANEOUS . ' AND p.status = ' . STATUS_QUEUED . ' AND p.current_stage = ' . REVIEW_STAGE_PRESENTATION . ')':'') . '
            )
            AND pp.paper_id = p.paper_id
            ' . ($trackId?'AND p.track_id = ?' : ''). '
            ' . $searchSql . '
         ORDER BY track_seq ASC, pa.seq ASC', $params
      );

      $currTrackId = 0;
      while (!$result->EOF) {
         $row =& $result->GetRowAssoc(false);
         $publishedPaper =& $this->_returnPublishedPaperFromRow($row);
         if ($publishedPaper->getTrackId() != $currTrackId) {
            $currTrackId = $publishedPaper->getTrackId();
            $publishedPapers[$currTrackId] = array(
               'papers'=> array(),
               'title' => ''
            );
            $publishedPapers[$currTrackId]['title'] = $publishedPaper->getTrackTitle();
         }
         $publishedPapers[$currTrackId]['papers'][] = $publishedPaper;
         $result->moveNext();
      }

      $result->Close();
      unset($result);

      return $publishedPapers;
   }

   function &getPublishedPapersByTrackId($trackId, $schedConfId) {
      $primaryLocale = AppLocale::getPrimaryLocale();
      $locale = AppLocale::getLocale();

      $publishedPapers = array();

      $result =& $this->retrieve(
         'SELECT pa.*,
            a.*,
            COALESCE(ttl.setting_value, ttpl.setting_value) AS track_title,
            COALESCE(tal.setting_value, tapl.setting_value) AS track_abbrev
         FROM published_papers pa,
            papers a,
            tracks t
            LEFT JOIN track_settings ttpl ON (t.track_id = ttpl.track_id AND ttpl.setting_name = ? AND ttpl.locale = ?)
            LEFT JOIN track_settings ttl ON (t.track_id = ttl.track_id AND ttl.setting_name = ? AND ttl.locale = ?)
            LEFT JOIN track_settings tapl ON (t.track_id = tapl.track_id AND tapl.setting_name = ? AND tapl.locale = ?)
            LEFT JOIN track_settings tal ON (t.track_id = tal.track_id AND tal.setting_name = ? AND tal.locale = ?)
         WHERE a.track_id = t.track_id
            AND pa.paper_id = a.paper_id
            AND a.track_id = ?
            AND pa.sched_conf_id = ?
            AND a.status = ' . STATUS_PUBLISHED . '
         ORDER BY pa.seq ASC', array(
            'title',
            $primaryLocale,
            'title',
            $locale,
            'abbrev',
            $primaryLocale,
            'abbrev',
            $locale,
            $trackId,
            $schedConfId
         )
      );

      $currTrackId = 0;
      while (!$result->EOF) {
         $publishedPaper =& $this->_returnPublishedPaperFromRow($result->GetRowAssoc(false));
         $publishedPapers[] = $publishedPaper;
         $result->moveNext();
      }

      $result->Close();
      unset($result);

      return $publishedPapers;
   }

   function &getPublishedPaperById($pubId) {
      $result =& $this->retrieve(
         'SELECT * FROM published_papers WHERE pub_id = ?', $pubId
      );
      $row = $result->GetRowAssoc(false);

      $publishedPaper = new PublishedPaper();
      $publishedPaper->setPubId($row['pub_id']);
      $publishedPaper->setId($row['paper_id']);
      $publishedPaper->setSchedConfId($row['sched_conf_id']);
      $publishedPaper->setDatePublished($this->datetimeFromDB($row['date_published']));
      $publishedPaper->setSeq($row['seq']);
      $publishedPaper->setViews($row['views']);
      $publishedPaper->setRoomId($row['room_id']);

      $publishedPaper->setSuppFiles($this->suppFileDao->getSuppFilesByPaper($row['paper_id']));

      $result->Close();
      unset($result);

      return $publishedPaper;
   }

   function &getPublishedPaperByPaperId($paperId, $schedConfId = null, $previewAbstracts = null) {
      $primaryLocale = AppLocale::getPrimaryLocale();
      $locale = AppLocale::getLocale();
      $params = array(
         'title',
         $primaryLocale,
         'title',
         $locale,
         'abbrev',
         $primaryLocale,
         'abbrev',
         $locale,
         $paperId
      );
      if ($schedConfId) $params[] = $schedConfId;

      $result =& $this->retrieve(
         'SELECT pa.*,
            a.*,
            COALESCE(ttl.setting_value, ttpl.setting_value) AS track_title,
            COALESCE(tal.setting_value, tapl.setting_value) AS track_abbrev
         FROM  papers a
            LEFT JOIN published_papers pa ON (pa.paper_id = a.paper_id)
            LEFT JOIN tracks t ON t.track_id = a.track_id
            LEFT JOIN track_settings ttpl ON (t.track_id = ttpl.track_id AND ttpl.setting_name = ? AND ttpl.locale = ?)
            LEFT JOIN track_settings ttl ON (t.track_id = ttl.track_id AND ttl.setting_name = ? AND ttl.locale = ?)
            LEFT JOIN track_settings tapl ON (t.track_id = tapl.track_id AND tapl.setting_name = ? AND tapl.locale = ?)
            LEFT JOIN track_settings tal ON (t.track_id = tal.track_id AND tal.setting_name = ? AND tal.locale = ?)
         WHERE a.paper_id = ?' .
            (isset($schedConfId)?' AND a.sched_conf_id = ?':'') .
            ($previewAbstracts!==true?' AND pa.paper_id IS NOT NULL':'') .
            ($previewAbstracts===true?' AND (a.status = ' . STATUS_PUBLISHED . ' OR (a.review_mode <> ' . REVIEW_MODE_BOTH_SIMULTANEOUS . ' AND a.status = ' . STATUS_QUEUED . ' AND a.current_stage = ' . REVIEW_STAGE_PRESENTATION . '))':'') .
            ($previewAbstracts===false?' AND a.status = ' . STATUS_PUBLISHED:''),
         $params
      );

      $publishedPaper = null;
      if ($result->RecordCount() != 0) {
         $publishedPaper =& $this->_returnPublishedPaperFromRow($result->GetRowAssoc(false));
      }

      $result->Close();
      unset($result);

      return $publishedPaper;
   }

   function &getPublishedPaperByPublicPaperId($schedConfId, $publicPaperId) {
      $primaryLocale = AppLocale::getPrimaryLocale();
      $locale = AppLocale::getLocale();

      $result =& $this->retrieve(
         'SELECT  pa.*,
            a.*,
            COALESCE(ttl.setting_value, ttpl.setting_value) AS track_title,
            COALESCE(tal.setting_value, tapl.setting_value) AS track_abbrev
         FROM  published_papers pa,
            papers a
            LEFT JOIN tracks t ON t.track_id = a.track_id
            LEFT JOIN track_settings ttpl ON (t.track_id = ttpl.track_id AND ttpl.setting_name = ? AND ttpl.locale = ?)
            LEFT JOIN track_settings ttl ON (t.track_id = ttl.track_id AND ttl.setting_name = ? AND ttl.locale = ?)
            LEFT JOIN track_settings tapl ON (t.track_id = tapl.track_id AND tapl.setting_name = ? AND tapl.locale = ?)
            LEFT JOIN track_settings tal ON (t.track_id = tal.track_id AND tal.setting_name = ? AND tal.locale = ?)
         WHERE pa.paper_id = a.paper_id
            AND pa.public_paper_id = ?
            AND a.sched_conf_id = ?',
         array(
            'title',
            $primaryLocale,
            'title',
            $locale,
            'abbrev',
            $primaryLocale,
            'abbrev',
            $locale,
            $publicPaperId,
            $schedConfId
         )
      );

      $publishedPaper = null;
      if ($result->RecordCount() != 0) {
         $publishedPaper =& $this->_returnPublishedPaperFromRow($result->GetRowAssoc(false));
      }

      $result->Close();
      unset($result);

      return $publishedPaper;
   }

   function &getPublishedPaperByBestPaperId($schedConfId, $paperId, $previewAbstracts = null) {
      $paper =& $this->getPublishedPaperByPublicPaperId($schedConfId, $paperId);
      if (!isset($paper)) $paper =& $this->getPublishedPaperByPaperId((int) $paperId, $schedConfId, $previewAbstracts);
      return $paper;
   }

   function &getPublishedPaperIdsAlphabetizedByTitle($conferenceId = null, $schedConfId = null, $rangeInfo = null) {
      $params = array(
         'cleanTitle',
         AppLocale::getLocale(),
         'cleanTitle',
         AppLocale::getPrimaryLocale()
      );
      if ($conferenceId) $params[] = $conferenceId;
      if ($schedConfId) $params[] = $schedConfId;

      $paperIds = array();

      $result =& $this->retrieveCached(
         'SELECT  p.paper_id,
            COALESCE(ptl.setting_value, ptpl.setting_value) AS paper_title
         FROM  published_papers pp,
            papers p
            ' . ($conferenceId?'LEFT JOIN sched_confs sc ON sc.sched_conf_id = p.sched_conf_id':'') . '
            LEFT JOIN paper_settings ptl ON (ptl.setting_name = ? AND ptl.paper_id = p.paper_id AND ptl.locale = ?)
            LEFT JOIN paper_settings ptpl ON (ptpl.setting_name = ? AND ptpl.paper_id = p.paper_id AND ptpl.locale = ?)
         WHERE pp.paper_id = p.paper_id AND
            p.status = ' . STATUS_PUBLISHED . '
            ' . ($schedConfId?'AND p.sched_conf_id = ?':'') . '
            ' . ($conferenceId?'AND sc.conference_id = ?':'') . '
         ORDER BY paper_title',
         $params
      );

      while (!$result->EOF) {
         $row = $result->getRowAssoc(false);
         $paperIds[] = $row['paper_id'];
         $result->MoveNext();
      }

      $result->Close();
      unset($result);

      return $paperIds;
   }

   function &getPublishedPaperIdsAlphabetizedBySchedConf($conferenceId = null, $schedConfId = null, $rangeInfo = null) {
      $params = array();
      if ($conferenceId) $params[] = $conferenceId;
      if ($schedConfId) $params[] = $schedConfId;

      $paperIds = array();

      $result =& $this->retrieveCached(
         'SELECT  p.paper_id AS pub_id
         FROM  published_papers pa,
            papers p
            ' . ($conferenceId?'LEFT JOIN sched_confs e ON e.sched_conf_id = p.sched_conf_id':'') . '
         WHERE pa.paper_id = p.paper_id
            AND p.status = ' . STATUS_PUBLISHED .
            ($conferenceId?' AND e.conference_id = ?':'') .
            ($schedConfId?' AND p.sched_conf_id = ?':'') .
         ' ORDER BY p.sched_conf_id',
         $params
      );

      while (!$result->EOF) {
         $row = $result->getRowAssoc(false);
         $paperIds[] = $row['pub_id'];
         $result->moveNext();
      }

      $result->Close();
      unset($result);

      return $paperIds;
   }

   function &_returnPublishedPaperFromRow($row) {
      $publishedPaper = new PublishedPaper();
      $publishedPaper->setPubId($row['pub_id']);
      $publishedPaper->setSchedConfId($row['sched_conf_id']);
      $publishedPaper->setDatePublished($this->datetimeFromDB($row['date_published']));
      $publishedPaper->setSeq($row['seq']);
      $publishedPaper->setViews($row['views']);
      $publishedPaper->setPublicPaperId($row['public_paper_id']);
      $publishedPaper->setRoomId($row['room_id']);

      // Paper attributes
      $this->paperDao->_paperFromRow($publishedPaper, $row);

      $publishedPaper->setGalleys($this->galleyDao->getGalleysByPaper($row['paper_id']));

      $publishedPaper->setSuppFiles($this->suppFileDao->getSuppFilesByPaper($row['paper_id']));

      HookRegistry::call('PublishedPaperDAO::_returnPublishedPaperFromRow', array(&$publishedPaper, &$row));

      return $publishedPaper;
   }

   function insertPublishedPaper(&$publishedPaper) {
      $this->update(
         sprintf('INSERT INTO published_papers
            (paper_id, sched_conf_id, date_published, seq, public_paper_id, room_id)
            VALUES
            (?, ?, %s, ?, ?, ?)',
            $this->datetimeToDB($publishedPaper->getDatePublished())),
         array(
            $publishedPaper->getId(),
            $publishedPaper->getSchedConfId(),
            $publishedPaper->getSeq(),
            $publishedPaper->getPublicPaperId(),
            $publishedPaper->getRoomId()
         )
      );

      $publishedPaper->setPubId($this->getInsertPublishedPaperId());
      return $publishedPaper->getPubId();
   }

   function getInsertPublishedPaperId() {
      return $this->getInsertId('published_papers', 'pub_id');
   }

   function deletePublishedPaperById($pubId) {
      $this->update(
         'DELETE FROM published_papers WHERE pub_id = ?', $pubId
      );
   }

   function deletePublishedPaperByPaperId($paperId) {
      return $this->update(
         'DELETE FROM published_papers WHERE paper_id = ?', $paperId
      );
   }

   function deletePublishedPapersByTrackId($trackId) {
      $result =& $this->retrieve(
         'SELECT pa.paper_id AS paper_id FROM published_papers pa, papers a WHERE pa.paper_id = a.paper_id AND a.track_id = ?', $trackId
      );

      while (!$result->EOF) {
         $row = $result->GetRowAssoc(false);
         $this->update(
            'DELETE FROM published_papers WHERE paper_id = ?', $row['paper_id']
         );
      }

      $result->Close();
      unset($result);
   }

   function deletePublishedPapersBySchedConfId($schedConfId) {
      return $this->update(
         'DELETE FROM published_papers WHERE sched_conf_id = ?', $schedConfId
      );
   }

   function updatePublishedPaper($publishedPaper) {
      $this->update(
         sprintf('UPDATE published_papers
            SET
               paper_id = ?,
               sched_conf_id = ?,
               date_published = %s,
               seq = ?,
               public_paper_id = ?,
               room_id = ?
            WHERE pub_id = ?',
            $this->datetimeToDB($publishedPaper->getDatePublished())),
         array(
            $publishedPaper->getId(),
            $publishedPaper->getSchedConfId(),
            $publishedPaper->getSeq(),
            $publishedPaper->getPublicPaperId(),
            $publishedPaper->getRoomId(),
            $publishedPaper->getPubId()
         )
      );
   }

   function updatePublishedPaperField($pubId, $field, $value) {
      $this->update(
         "UPDATE published_papers SET $field = ? WHERE pub_id = ?", array($value, $pubId)
      );
   }

   function resequencePublishedPapers($trackId, $schedConfId) {
      $result =& $this->retrieve(
         'SELECT pa.pub_id FROM published_papers pa, papers a WHERE a.track_id = ? AND a.paper_id = pa.paper_id AND pa.sched_conf_id = ? ORDER BY pa.seq',
         array($trackId, $schedConfId)
      );

      for ($i=1; !$result->EOF; $i++) {
         list($pubId) = $result->fields;
         $this->update(
            'UPDATE published_papers SET seq = ? WHERE pub_id = ?',
            array($i, $pubId)
         );

         $result->moveNext();
      }

      $result->close();
      unset($result);
   }

   function getPublishedPaperAuthors($schedConfId) {
      $authors = array();
      $result =& $this->retrieve(
         'SELECT aa.* FROM paper_authors aa, published_papers pa WHERE aa.paper_id = pa.paper_id AND pa.sched_conf_id = ? ORDER BY pa.sched_conf_id', $schedConfId
      );

      while (!$result->EOF) {
         $row = $result->GetRowAssoc(false);
         $author = new Author();
         $author->setId($row['author_id']);
         $author->setPaperId($row['paper_id']);
         $author->setFirstName($row['first_name']);
         $author->setMiddleName($row['middle_name']);
         $author->setLastName($row['last_name']);
         $author->setAffiliation($row['affiliation']);
         $author->setEmail($row['email']);
         $author->setBiography($row['biography']);
         $author->setPrimaryContact($row['primary_contact']);
         $author->setSequence($row['seq']);
         $authors[] = $author;
         $result->moveNext();
      }

      $result->Close();
      unset($result);

      return $authors;
   }

   function incrementViewsByPaperId($paperId) {
      return $this->update(
         'UPDATE published_papers SET views = views + 1 WHERE paper_id = ?',
         $paperId
      );
   }

   function publicPaperIdExists($publicPaperId, $paperId, $schedConfId) {
      $result =& $this->retrieve(
         'SELECT COUNT(*) FROM published_papers pa, papers a WHERE pa.paper_id = a.paper_id AND a.sched_conf_id = ? AND pa.public_paper_id = ? AND pa.paper_id <> ?',
         array($schedConfId, $publicPaperId, $paperId)
      );
      $returner = $result->fields[0] ? true : false;

      $result->Close();
      unset($result);

      return $returner;
   }
   
   function getPaperYearRange($conferenceId = null) {
      $result =& $this->retrieve(
         'SELECT MAX(pp.date_published), MIN(pp.date_published) FROM published_papers pp, papers p, sched_confs sc WHERE pp.paper_id = p.paper_id AND pp.sched_conf_id = sc.sched_conf_id ' . (isset($conferenceId)?' AND sc.conference_id = ?':''),
         isset($conferenceId)?$conferenceId:false
      );
      $returner = array($result->fields[0], $result->fields[1]);

      $result->Close();
      unset($result);

      return $returner;
   }
}

?>

---