# Insterted - mysqli_affected_rows = 1
if (mysqli_affected_rows($to_partition->dblink) == 1) {
$content->inserted_ids[] = $entry->id;
$inserted_count++;
$partitions_affected->{$to_partition->data['id']}->inserted_rows++;
$G_TO_TABLE_DETAILS['rows'] = (int) $G_TO_TABLE_DETAILS['rows'] + 1;
} else {
$content->update_ids[] = mysqli_insert_id($to_partition->dblink);
}
$write_rows++;
}
}
# If we need to remove from the from table
if (isset($_CGET['delete']) && boolval($_CGET['delete'])) {
# Deleting the items
$delete_query = $from_query->get_delete_query($limit);
mysqli_sub_query($from_partition_data['dblink'], $delete_query);
$rows_deleted = mysqli_affected_rows($from_partition_data['dblink']);
# Tracking the partitions changes
if (!isset($partitions_affected->{$from_partition_data['id']})) {
$partitions_affected->{$from_partition_data['id']} = (object) ['table_id' => $G_FROM_TABLE_SETTINGS['id'], 'inserted_rows' => 0, 'deleted_rows' => 0];
}
$partitions_affected->{$from_partition_data['id']}->deleted_rows += $rows_deleted;
$deleted_count += $rows_deleted;
}
# Lowering the limit
$limit -= mysqli_num_rows($select_result);
# Done if no more to check
if ($limit <= 0) {
break;
}
$partitions_affected->{$partition_data['id']} = (object) ['data' => $partition_data, 'dblink' => $partition_dblink, 'database' => $partition_data['database'], 'deleted_rows' => 0];
# First partition, new query object
if ($query === false) {
# Creating our new parser
$query = new MySQLParser($partition_dblink, $partition_data['table_name'], $partition_data['database']);
# Order by
if (isset($_JPOST->order)) {
$order_sort = isset($_JPOST->order_sort) ? explode(',', $_JPOST->order_sort) : [];
$query->add_order_by(explode(',', $_JPOST->order), $order_sort);
}
# Where columns
$query->add_where_columns($_JPOST);
}
# Deleting from the partition
$query->set_table($partition_data['table_name'], false, false, $partition_data['database']);
$delete_query = $query->get_delete_query($limit, false);
mysqli_sub_query($partition_dblink, $delete_query);
# Getting our deleted info
$affected = mysqli_affected_rows($partition_dblink);
$limit -= (int) $affected;
# Tracking our internal changed numbers
$content->affected_rows += $affected;
$deleted_count += $affected;
$partitions_affected->{$partition_data['id']}->deleted_rows += $affected;
# We are done updating
if ($limit !== false && $limit <= 0) {
break;
}
}
# Returning our values
PostParser::send($content);
