Exemplo n.º 1
0
         $from_query->add_group_by(explode(',', $_CGET['group']));
     }
     # Where columns
     $from_query->add_where_columns($_CGET);
     # Overwriting with our global session where values
     if (isset($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->global->{$G_FROM_TABLE_SETTINGS['alias']})) {
         $from_query->add_where_columns($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->global->{$G_FROM_TABLE_SETTINGS['alias']});
     }
     # Overwriting with our specific fetch where values
     if (isset($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->fetch->{$G_FROM_TABLE_SETTINGS['alias']})) {
         $from_query->add_where_columns($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->fetch->{$G_FROM_TABLE_SETTINGS['alias']});
     }
 }
 # Selecting
 $from_query->set_table($from_partition_data['table_name'], false, false, $from_partition_data['database']);
 $select_query = $from_query->get_select_query($limit, false, false);
 $select_result = mysqli_multi_result_query($from_partition_data['dblink'], $select_query);
 # Processing our results
 while ($from_data = mysqli_fetch_assoc($select_result)) {
     # Entry to insert
     $entry = new stdClass();
     # Full record match
     if ($G_FROM_TABLE_COLUMNS_COUNT == 1 && $G_FROM_TABLE_COLUMNS[0] == '*') {
         $entry = (object) $from_data;
     } else {
         for ($i = 0; $i < $G_FROM_TABLE_COLUMNS_COUNT; $i++) {
             if (isset($from_data[$G_FROM_TABLE_COLUMNS[$i]])) {
                 $entry->{$G_TO_TABLE_COLUMNS[$i]} = $from_data[$G_FROM_TABLE_COLUMNS[$i]];
             }
         }
     }
Exemplo n.º 2
0
     $select_columns = $G_COLUMNS_SELECTED;
     if ($select_columns != '*' && !in_array($attached['column'], $select_columns)) {
         $select_columns[] = $attached['column'];
         $unset_link_id = true;
     }
     $query->add_select_columns($select_columns, false, $table_settings['alias'], true);
     # Where columns
     $query->add_where_columns([$attached['column'] => '[]' . implode(',', $column_values)], false, $table_settings['alias']);
     # Order by
     if ($G_ORDER_BY !== false) {
         $query->add_order_by($G_ORDER_BY, $G_ORDER_DESC, false, $table_settings['alias']);
     }
 }
 # Getting our results
 $query->set_table($partition_data['table_name'], false, false, $partition_data['database']);
 $select_query = $query->get_select_query($G_APP_DATA['db_attach_multi_limit'], false, COLUMNS_SORTED);
 $select_result = mysqli_multi_result_query($dblink, $select_query);
 # Saving the indices before processing (optimization)
 $acol = $attached['column'];
 $aname = $attached['name'];
 # Processing our results
 while ($attached_data = mysqli_fetch_assoc($select_result)) {
     # Saving the indices and column name
     $colval = $attached_data[$acol];
     # If we need to unset link id
     if ($unset_link_id) {
         unset($attached_data[$acol]);
     }
     # Adding to records to the right result
     foreach ($column_keys->{$colval} as $key) {
         $content[$key][$aname][] = $attached_data;