$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: