*/ $SQL = sprintf("SELECT %s, %s, COUNT(*) AS cnt FROM %s WHERE %s='%s' GROUP BY %s HAVING cnt>1", dbKITregister::field_contact_id, dbKITregister::field_id, $dbKITregister->getTableName(), dbKITregister::field_status, dbKITregister::status_active, dbKITregister::field_email); $registers = array(); if (!$dbKITregister->sqlExec($SQL, $registers)) { $error .= sprintf('<p>[BUGFIX] %s</p>', $dbKITregister->getError()); } else { foreach ($registers as $register) { $SQL = sprintf("SELECT %s FROM %s WHERE %s='%s' AND %s='%s'", dbKITcontact::field_id, $dbKITcontact->getTableName(), dbKITcontact::field_id, $register[dbKITregister::field_contact_id], dbKITcontact::field_status, dbKITcontact::status_deleted); $contacts = array(); if (!$dbKITcontact->sqlExec($SQL, $contacts)) { $error .= sprintf('<p>[BUGFIX] %s</p>', __METHOD__, __LINE__, $dbKITcontact->getError()); } else { if (count($contacts) > 0) { $where = array(dbKITregister::field_id => $register[dbKITregister::field_id]); $data = array(dbKITregister::field_status => dbKITregister::status_deleted, dbKITregister::field_update_by => 'UPDATE FIXUP', dbKITregister::field_update_when => date('Y-m-d H:i:s')); if (!$dbKITregister->sqlUpdateRecord($data, $where)) { $error .= sprintf('<p>[BUGFIX] %s</p>', $dbKITregister->getError()); } } } } } /** * Release 0.43 * Remove /dialogs, /droplets, kit.php, class.request.php and class.repsonse.php and use kitForms instead */ // remove mod_kit_newsletter_links $SQL = sprintf("DROP TABLE IF EXISTS %smod_kit_newsletter_links", TABLE_PREFIX); $database->query($SQL); if ($database->is_error()) { $error .= sprintf('<p>[DROP TABLE mod_kit_newsletter_links] %s</p>', $database->get_error());