if ($obj->fk_categorie_mere != $obj->fk_categorie_fille) { $filles[$obj->fk_categorie_fille]=1; // Set record for this child $couples[$obj->fk_categorie_mere.'_'.$obj->fk_categorie_fille]=array('mere'=>$obj->fk_categorie_mere, 'fille'=>$obj->fk_categorie_fille); } } } dolibarr_install_syslog("upgrade: result is num=".$num." sizeof(couples)=".sizeof($couples)); // If there is duplicates couples or child with two parents if (sizeof($couples) > 0 && $num > sizeof($couples)) { $error=0; $db->begin(); $sql="DELETE FROM ".MAIN_DB_PREFIX."categorie_association"; dolibarr_install_syslog("upgrade: delete association sql=".$sql); $resqld=$db->query($sql); if ($resqld) { foreach($couples as $key => $val) { $sql ="INSERT INTO ".MAIN_DB_PREFIX."categorie_association(fk_categorie_mere,fk_categorie_fille)"; $sql.=" VALUES(".$val['mere'].", ".$val['fille'].")"; dolibarr_install_syslog("upgrade: insert association sql=".$sql); $resqli=$db->query($sql); if (! $resqli) $error++; } }