Ejemplo n.º 1
0
 *
 * PHP Version 5.3.3
 *
 * @category General
 * @package  ArchiWiki
 * @author   Pierre Rudloff <*****@*****.**>
 * @license  GNU GPL v3 https://www.gnu.org/licenses/gpl.html
 * @link     http://archi-wiki.org/
 *
 * */
require_once "includes/framework/config.class.php";
require_once "modules/archi/includes/archiEvenement.class.php";
$config = new ArchiConfig();
$req = "\n    SELECT idPersonne, description\n    FROM personne";
$res = $config->connexionBdd->requete($req);
$e = new archiEvenement();
while ($person = mysql_fetch_object($res)) {
    $req2 = "\n    SELECT *\n    FROM _personneEvenement\n    WHERE idPersonne = " . $person->idPersonne;
    if (!mysql_fetch_object($config->connexionBdd->requete($req2))) {
        $idEvenement = $e->getNewIdEvenement();
        $idSousEvenement = $idEvenement + 1;
        $req3 = "\n        INSERT INTO `historiqueEvenement` (\n            `idEvenement`,\n            `dateCreationEvenement`,\n            `idTypeEvenement`\n        )\n        VALUES (\n            '" . $idEvenement . "',\n            now(),\n            '" . $e->getIdTypeEvenementGroupeAdresse() . "'\n        )";
        $config->connexionBdd->requete($req3);
        $req3 = "\n        INSERT INTO `historiqueEvenement` (\n            `idEvenement`, `description`,\n            `dateCreationEvenement`\n        )\n        VALUES (\n            '" . $idSousEvenement . "',\n            '" . mysql_escape_string($person->description) . "',\n            now()\n        )";
        $config->connexionBdd->requete($req3);
        $req3 = "\n        INSERT INTO `_personneEvenement` (\n            `idPersonne`, `idEvenement`\n        )\n        VALUES (\n            '" . $person->idPersonne . "',\n            " . $idEvenement . "\n        )";
        $config->connexionBdd->requete($req3);
        $req3 = "\n            insert into _evenementEvenement (idEvenement,idEvenementAssocie)\n            values ('" . $idEvenement . "','" . $idSousEvenement . "');\n        ";
        $config->connexionBdd->requete($req3);
    }
}