Esempio n. 1
0
     # 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':
Esempio n. 2
0
     # 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