function getUrl($iLimit = 100)
 {
     $oConn = $this->getConn(URL_DB);
     $sSql = "select\n\t\t\t\t\t url_id\n\t\t\t\t\t,url\n\t\t\t\t\tfrom m_url\n\t\t\t\t\twhere status = " . URL_STATUS_WAIT . "\n\t\t\t\t\toffset 0 limit " . $iLimit . "\n\t\t\t\t\tfor update";
     if ($oConn->executeSelect($sSql) === FALSE) {
         // エラー処理
         $this->_oConnMng->execErrorOccurs();
     }
     // URLデータ取得
     $aUrlHeader = arrary();
     $aTargetId = arrary();
     while (($rtn = $oConn->fetch()) !== FALSE) {
         $aUrlHeader[] = $rtn;
         $aTargetId[] = $rtn['url_id'];
     }
     // ステータス変更
     $this->updateUrlStatus($aTargetId, URL_STATUS_NOW);
     return $aUrlHeader;
 }
Example #2
0
 /**
  * @return Cate
  */
 static function getNewsCate()
 {
     return Cate::model()->find('alias = ?', arrary('news'));
 }