// delete pages $stmt = new db_stmt_delete("pages"); $stmt->setWhereClause("id_account = '" . $id . "'"); $s = $stmt->getStatement(); $rs = $db->Execute($s); // delete sources $stmt = new db_stmt_delete("sources"); $stmt->setWhereClause("id_account = '" . $id . "'"); $s = $stmt->getStatement(); $rs = $db->Execute($s); // delete users $stmt = new db_stmt_delete("users"); $stmt->setWhereClause("id_account = '" . $id . "'"); $s = $stmt->getStatement(); $rs = $db->Execute($s); // delete targets $stmt = new db_stmt_delete("targets"); $stmt->setWhereClause("id_account = '" . $id . "'"); $s = $stmt->getStatement(); $rs = $db->Execute($s); // delete account $stmt = new db_stmt_delete("accounts"); $stmt->setWhereClause("id = '" . $id . "'"); $s = $stmt->getStatement(); $rs = $db->Execute($s); } } $ret = "OK"; echo $ret; exit; }
$rs = $db->Execute($s); if (!$rs) { echo "Error while reading sources table !"; exit; } $count = 0; while (!$rs->EOF) { $id = $rs->fields["id"]; // load db_get_value($db, "plugins", "class_php", "id=" . $rs->fields["type"], $class); $source = SourceFactory::createInstance($class, $config, $id_account_current, $db, null, null); $source->load($rs->GetRowAssoc()); // delete $delstmt = new db_stmt_delete('sources'); $delstmt->setWhereClause("id = '" . $id . "'"); $s = $delstmt->getStatement(); if (!$db->Execute($s)) { echo 'Error while deleting record ' . $id; exit; } else { // insert $s = $source->getSqlStmt('insert'); if (!$db->Execute($s)) { echo 'Error while writing record ' . $id; echo '</br>Stop upgrade (' . $count . ' sources upgraded)'; echo '</br>' . $db->ErrorMsg(); echo '</br>' . $s; exit; } $count++; }