if (NQ_WHITELIST_EXISTENTIAL ? count($whitelist) > 0 : true) { $from_query->whitelist_columns($whitelist); } } # Adding our select columns $from_query->add_select_columns($G_FROM_TABLE_COLUMNS); # Where columns $from_query->add_where_columns($_CGET); # Order by if (isset($_CGET['order'])) { $order_sort = isset($_CGET['ordersort']) ? explode(',', $_CGET['ordersort']) : []; $from_query->add_order_by(explode(',', $_CGET['order']), $order_sort); } # Group by if (isset($_CGET['group'])) { $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);
$query->whitelist_columns($whitelist); } } # Excluding from the table if ($G_COLUMNS_EXCLUDED !== false) { $query->blacklist_columns($G_COLUMNS_EXCLUDED); } # Adding our select columns $query->add_select_columns($G_COLUMNS_SELECTED, false, $G_TABLE_DETAILS['alias']); # Order by if ($G_ORDER_BY !== false) { $query->add_order_by($G_ORDER_BY, $G_ORDER_DESC, false, $G_TABLE_DETAILS['alias']); } # Group by if ($G_GROUP_BY !== false) { $query->add_group_by($G_GROUP_BY, false, $G_TABLE_DETAILS['alias']); } # Where columns $query->add_where_columns($_CGET, false, $G_TABLE_DETAILS['alias']); } } mysqli_free_result($partition_results); # We don't want to do our counts (large queries) $matched_count = 0; if (!$show_count) { # Handling our pages $per_page = isset($_CGET['limit']) ? min((int) $_CGET['limit'], $G_APP_DATA['results_limit']) : $G_APP_DATA['results_limit']; $page = isset($_CGET['page']) ? abs((int) $_CGET['page']) : 0; $page_start = $page * $per_page; $per_page = $per_page + 1; # We are forcing pagination