コード例 #1
0
ファイル: SourceDAO.php プロジェクト: redbugz/rootstech2013
 function getSources(&$source, $type = Q_LIKE)
 {
     global $tblprefix, $err_locations;
     $res = array();
     $squery = "SELECT source_id as s_source_id," . Source::getFields("s") . " FROM " . $tblprefix . "source s ";
     if (isset($source->source_id) && $source->source_id != '') {
         $squery .= "WHERE source_id = " . quote_smart($source->source_id);
     } else {
         if (isset($source->title) && $source->title != '%') {
             if ($type == Q_LIKE) {
                 $squery .= "WHERE title LIKE " . quote_smart($source->title);
             } else {
                 $squery .= "WHERE title = " . quote_smart($source->title);
             }
         }
     }
     $squery .= " ORDER BY title";
     $this->addLimit($source, $squery);
     //TODO - error message
     $result = $this->runQuery($squery, '');
     $source->numResults = 0;
     while ($row = $this->getNextRow($result)) {
         $s = new Source();
         $s->loadFields($row, "s_");
         $s->setPermissions();
         $source->numResults++;
         $res[] = $s;
     }
     $this->freeResultSet($result);
     $source->results = $res;
 }