/**
* Retourne tous les trackers
*
* @return array
*/
public static function getTrackers()
{
$oMysqli = Database::getInstance();
$oResults = $oMysqli->query("SELECT t.*, (SELECT COUNT(*) FROM tks_passkey AS p WHERE t.id = p.id_tracker) AS nb_passkey \r\n FROM tks_trackers as t ");
$aResults = array();
while ($aResult = $oResults->fetch_assoc()) {
$oTracker = new Tracker($aResult['name'], $aResult['id']);
$oTracker->setLink($aResult['link']);
$oTracker->setDirectLink($aResult['directlink']);
$oTracker->setNbPasskeys($aResult['nb_passkey']);
$aResults[$aResult['id']] = $oTracker;
}
return $aResults;
}
