$l->software($datas['logiciel']);
$l->admin(true);
}
//Insert "other" keys
$iter = XDB::iterator('SELECT logiciel, cle, eleve_id, binet_id
FROM msdnaa.cles_autres');
while ($datas = $iter->next()) {
$l = new License();
$l->insert();
$l->key($datas['cle']);
$l->software($datas['logiciel']);
if ($datas['eleve_id']) {
$l->uid($datas['eleve_id']);
}
if ($datas['binet_id']) {
$l->gid($datas['binet_id']);
}
}
//Insert unregistred user keys
$iter = XDB::iterator('SELECT logiciel, cle, prenom, nom, statut, mail
FROM msdnaa.cles_unregistered_users');
while ($datas = $iter->next()) {
$l = new License();
$l->insert();
$l->key($datas['cle']);
$l->software($datas['logiciel']);
$l->uid(0);
$l->comments("Key given to " . $datas['prenom'] . " " . $datas['nom'] . " (" . $datas['statut'] . ") " . $datas['mail']);
}
echo "Done \n";
// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
