/**
* Retourne toutes les clés
*
* @return array
*/
public static function getInvites()
{
$oMysqli = Database::getInstance();
$oResults = $oMysqli->query("SELECT i.*,p.login as parrain,f.login as filleul FROM tks_invites i \r\n LEFT OUTER JOIN tks_users p\r\n ON p.id = i.id_parrain \r\n LEFT OUTER JOIN tks_users f \r\n ON f.id = i.id_filleul");
$aResults = array();
while ($aResult = $oResults->fetch_assoc()) {
$oInvite = new Invites($aResult['id_parrain'], $aResult['code'], $aResult['id_filleul']);
$oInvite->setFilleulLogin($aResult['filleul']);
$oInvite->setParrainLogin($aResult['parrain']);
$aResults[] = $oInvite;
}
return $aResults;
}
