# Adding our duplicate columns if (isset($_CGET['duplicate'])) { $to_query->add_insert_duplicate_columns(explode(',', $_CGET['duplicate'])); } # Adding our duplicate ignore columns if (isset($_CGET['duplicate_ignore'])) { $to_query->add_insert_duplicate_columns(explode(',', $_CGET['duplicate_ignore'])); } } # Creating our auto-increment id $insert_query = "\tINSERT INTO\n\t\t\t\t\t\t\t" . NQ_DATABASE_STORAGE_DATABASE . ".`" . NQ_DATABASE_PARTITION_PREFIX . $G_APP_DATA['id'] . "_" . $G_TO_TABLE_DETAILS['id'] . "_" . $to_partition->data['number'] . "`\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\t`data`=0"; mysqli_sub_query($G_STORAGE_CONTROLLER_DBLINK, $insert_query); $entry->id = ($to_partition->data['number'] << $to_bitmask[0]) + mysqli_insert_id($G_STORAGE_CONTROLLER_DBLINK); # Adding our insert columns $to_query->clear_insert_columns(); $to_query->add_insert_columns($entry); # Adding our global session values if (isset($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->global->{$G_TO_TABLE_SETTINGS['alias']})) { $to_query->add_insert_columns($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->global->{$G_TO_TABLE_SETTINGS['alias']}); } # Adding our specific session values if (isset($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->insert->{$G_TO_TABLE_SETTINGS['alias']})) { $to_query->add_insert_columns($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->insert->{$G_TO_TABLE_SETTINGS['alias']}); } # If we have max rows, we need to do something $rejected = false; if ((int) $G_TO_TABLE_DETAILS['max_rows'] > 0 && (int) $G_TO_TABLE_DETAILS['rows'] + 1 > (int) $G_TO_TABLE_DETAILS['max_rows']) { # Our action to take switch ($G_TO_TABLE_DETAILS['max_rows_action']) { # Done case 'reject':
# Pushing columns into stack $partition_queries->{$partition->data['id']}->push_insert_columns(); } else { # New query class if ($query === false) { # Creating our new parser $query = new MySQLParser($partition->dblink, $partition->data['table_name'], $partition->database); # Checking for whitelisting if (NQ_WHITELIST_COLUMNS && (NQ_WHITELIST_EXISTENTIAL ? count($whitelist) > 0 : true)) { $query->whitelist_columns($whitelist); } # Blacklisting the timestamp $query->blacklist_columns(['timestamp']); } # Adding our insert columns $query->add_insert_columns($entry); # Adding our global session values if ($session_global_variables) { $query->add_insert_columns($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->global->{$G_TABLE_DETAILS['alias']}); } # Adding our specific session values if ($session_insert_variables) { $query->add_insert_columns($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->insert->{$G_TABLE_DETAILS['alias']}); } # If we are going to update duplicates if (UPDATE_DUPLICATES) { # Adding our duplicate columns if (isset($_CGET['duplicate'])) { $query->add_insert_duplicate_columns(explode(',', $_CGET['duplicate'])); } # Adding our duplicate ignore columns