*/
$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());
