public function procede() { if (!$this->oRequest->existParam('key')) { throw new Error('Vous devez renseigner la clé.', 3003); } if ($this->oRequest->getParam('key', 'string') != Config::get('ingestkey')) { throw new Error('La clé est invalide.', 3003); } //Ajoute du titre $this->oView->addData('titre', 'Analyse des releases'); //On récupère les 30 dernières releases $oMysqli = Database::getInstance(); //Traitement de la requête $sSqlRequest = "SELECT r.*, \r\n (SELECT GROUP_CONCAT(t.id_regex ORDER BY t.id_regex SEPARATOR ';') FROM tks_tags t WHERE t.id_release = r.id) AS tags,\r\n (SELECT GROUP_CONCAT(f.date ORDER BY f.date SEPARATOR ';') FROM tks_torrents f WHERE f.id_release = r.id) AS dates\t\r\n FROM tks_releases r \r\n WHERE r.id_categorie = '0' \r\n ORDER BY r.id DESC \r\n LIMIT 10"; $oResults = $oMysqli->query($sSqlRequest); $oTable = new TableGenerator(); $oTable->setId(md5('Scrapper')); $oTable->addColumn('Release'); $oTable->addColumn('Catégorie'); $oTable->addColumn('ID Fiche'); $aCategories = Categorie::getCategoriesSelect(); while ($aResult = $oResults->fetch_assoc()) { $oScrapper = new Scrapper($aResult['name'], $aResult['id']); $oScrapper->procede(); $oTable->addLine(array($aResult['name'], $aCategories[$oScrapper->getCategorie()], $oScrapper->getFiche())); } $oTable->setBottom(''); $oTable->create(); $this->oView->addData('content', $oTable->getCode()); $this->oView->Create(); }